Penn Computing

University of Pennsylvania
Penn Computing << go backback
FA_PROGRAM Table   Tables and Data Elements   FinAid Home   Data Warehouse Home

PROGRAM Table - Data Element Index

Select a data element to view its definition and its indexed, format, and null values.



 

Data element

Definition

Object name in Business Objects universe (if different from data element name)

Load_Date

Indexed - no
Format - Date
May be Null? Y

The latest date this student's record was refreshed in the warehouse from the Student Aid Management system (SAM). Does not indicate a specific column in a table has changed; the entire student's record gets refreshed whenever there is any change in SAM

Pgm_Aaidyr

Indexed - no
Format - Varchar2(6)
May be Null? Y

Alternate Aid Year (System Generated) This data element contains the same value as Aid Year described above (PGM_AidYr)

 
Pgm_Actnr

Indexed - no
Format - Varchar2(24)
May be Null? Y

Account Number associated with the Aid Program Identifier. This number is in the 9 digit legacy format General Ledger Account Number in Institutional Financial Systems. Interfaces to Institutional Financial Systems (e.g., General Ledger Accounting, Student Accounts Receivable) will use this account number.

 
Pgm_Aidid

Indexed - yes
Format - Varchar2(4)
May be Null? N

Aid Program Identifier A 4-character code assigned by the system user to uniquely identify each Financial Aid Program. Each of the Financial Aid Programs must be defined in the Aid Program File (Through programs SAMU11 and FACIU). The Aid Program file is checked for valid Aidid (and Ptype) when packaging transactions are processed through program SAMP10. The Table file is searched for Aidid by Letter Writing Program (e.g., SAMN25).

 
Pgm_Aidyr

Indexed - yes
Format - Varchar2(6)
May be Null? N

This code identifies the Financial Aid Processing Year. YYYYT, where T is A=Summer 2, B=Fall & Spring combined, C=Summer 1 All data in the SAM-II System (Except Bio File) must have a common Aidyr code to logically group by processing year. The Aidyr code can only contain 4 characters (The rightmost two characters must remain blank).

 
Pgm_Begdtec

Indexed - no
Format - Date
May be Null? Y

The beginning date of expected payment for the award. This field is informational.

 
Pgm_Campus

Indexed - no
Format - Varchar2(6)
May be Null? Y

Primary Campus The Primary Campus Administering this Aid Program. This is maintained for information only.

 
Pgm_Desc

Indexed - no
Format - Varchar2(24)
May be Null? Y

Program Description A complete description of the Aid Program. This desc will appear on the Award Letters generated by program SAMN25 and on the reports of the Funds Management Module.

 
Pgm_Enddtec

Indexed - no
Format - Date
May be Null? Y

The ending date of expected payment for the award. This field is informational.

 
Pgm_Name

Indexed - no
Format - Varchar2(8)
May be Null? Y

Program Name An abbreviated name for the Financial Aid Program. This name is used for online screens and reports.

 
Pgm_Ptype

Indexed - no
Format - Varchar2(1)
May be Null? Y

Payment Type Used to qualify the method of payment when multiple methods of payment are used for a single Aid Identifier (e.g., SEOG is paid in both cash and tuition vouchers). One Aid Program record must be defined for each Payment Type within a Financial Aid Program (Aidid).

 
Pgm_Revdtec

Indexed - no
Format - Date
May be Null? Y

Date provided by programs which update PGM File, but not changed by programs which only read the data.

 
Pgm_Schsrce

Indexed - no
Format - Varchar2(1)
May be Null? Y

Schedule Source Source of Disbursement Schedule. Indicates whether this award is to have the system automatically determine the Payment Schedule (Through program SAMN20) for quarterly, semesterly, monthly or similar payments requiring scheduling. Scheduling distributes the annual award amount to one or more of 12 payment periods.

VALUES:

A - Automatic
M - Manual
O - Override

 
Pgm_Sponsor

Indexed - no
Format - Varchar2(1)
May be Null? Y

Sponsor or source of funds for the Aid Program.

VALUES:

F - Federal
S - State
L - Local
I - Institution
C - Campus
D - Department
P - Private
X - External
M - Alumni
A - Athletics
G - Gifts
E - Endowments
N - Agencies
O - Other

 
Pgm_Typeaid

Indexed - no
Format - Varchar2(1)
May be Null? Y

Type of Aid Program Type of aid being awarded under this Aid Program. This data element is used primarily for statistical classification.

VALUES:

A - Asstship
B - Sub. Stafford - Dir. Lending
C - Unsub. Stafford - Dir. Lending
D - Plus Loan - Dir. Lending
E - Pell Grant
F - Fellowship
G - Grant
H - HEAL Loan - Dir. Lending
I - Grad PLUS Loan - Dir. Lending
J - Perkins Loans
K - Acad Competitiveness Grant
L - Loan
M - Supp. Educational Opp. Grant
N - Other No SEOG
O - Other
P - Prizes
S - Scholarship
T - Tuition Waiver
U - Loan Guaranty
V - SMART Grant
W - Work
X - Sub. Stafford - FFELP
Y - Unsub. Stafford - FFELP
Z - Plus Loan - FFELP
1 - HEAL Loan - FFELP
2 - Alternate Loan - Common Line
3 - Grad PLUS Loan - FFELP
4 - Teach Grant
5 - Addl Unsub Elig - Dir Lending
7 - Perkins Loans - COD
Q - State Grant One
R - State Grant Two

 
FA_PROGRAM Table   Tables and Data Elements   FinAid Home   Data Warehouse Home

Questions about this page? Email us at da-staff@isc.upenn.edu

Information Systems and Computing
University of Pennsylvania
Information Systems and Computing, University of Pennsylvania