|
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 |
|
