|
Data element
|
Definition |
Object name in Business Objects universe (if different from data element name)
|
| Aid_Id Indexed - yes
Format - Varchar2(4)
May be Null? N |
Identifies the type and source of aid including federal loans, institutional grant, state grant, work study, etc. Each AIDID has a unique description, and it is used to identify types of aid for each student's account. |
|
| Calc_Offer Indexed - no
Format - Number
May be Null? Y |
Amount of award offered for this term |
|
| Calc_Paid Indexed - no
Format - Number
May be Null? Y |
Amount of award paid for this term |
|
| Coa_Bc Indexed - no
Format - Varchar2(1)
May be Null? Y |
|
|
| Coa_Cnac Indexed - yes
Format - Varchar2(3)
May be Null? Y |
|
|
| Coa_Cref Indexed - yes
Format - Varchar2(4)
May be Null? Y |
|
|
| Coa_Fund Indexed - yes
Format - Varchar2(6)
May be Null? Y |
|
|
| Coa_Object Indexed - yes
Format - Varchar2(4)
May be Null? Y |
|
|
| Coa_Org Indexed - yes
Format - Varchar2(4)
May be Null? Y |
|
|
| Coa_Program Indexed - yes
Format - Varchar2(4)
May be Null? Y |
|
|
| Enroll_Flag Indexed - no
Format - Varchar2(1)
May be Null? Y |
Value of term enrlts flag. Will not propagate to reporting warehouse |
|
| Gl_Date Indexed - no
Format - Date
May be Null? Y |
|
|
| Last_Updated_By Indexed - no
Format - Varchar2(1)
May be Null? Y |
|
|
| Legacy_Account_Number Indexed - yes
Format - Varchar2(9)
May be Null? Y |
Account number used to match award type to BEN Financials |
|
| Load_Date Indexed - no
Format - Date
May be Null? Y |
|
|
| Long_Description Indexed - no
Format - Varchar2(400)
May be Null? Y |
Description of the award, that prints on the Award Letter |
|
| Long_Name Indexed - no
Format - Varchar2(150)
May be Null? Y |
Name of the award, from SAM table file in a decode table |
|
| Offer_Amount Indexed - no
Format - Number
May be Null? Y |
Amount of award type offered for this term |
|
| Originally_Populated_By Indexed - no
Format - Varchar2(1)
May be Null? Y |
|
|
| Paid_Amount Indexed - no
Format - Number
May be Null? Y |
Amount of award type paid for this term |
|
| Paid_Status Indexed - yes
Format - Varchar2(15)
May be Null? Y |
Payment status of award, N = Not ready, R = Ready, P = Paid, M=Manual |
|
| Penn_Id Indexed - yes
Format - Char
May be Null? Y |
|
|
| Program_Name Indexed - no
Format - Varchar2(50)
May be Null? Y |
A short, unique description for a specific award type which identifies source of funds. E.g. REF. STF. Describes a referred Stafford Loan |
|
| SAM_Term
Indexed - yes
Format - Varchar2(5)
May be Null? Y |
Identifies the term to which the associated Student Aid Management information pertains. 'B' implies the fall term of the calendar year, followed by the spring term of the following calendar year. 'A' is the label for the summer session before the academic year, and 'C' is the tag for the summer session following the academic year. (E.g. 2009B is Fall 2009 to Spring 2010, 2009C is the first summer session in Summer 2010, followed by 2010A for the second summer session) |
|
SAM School Code
Indexed - yes
Format - Varchar2(2)
May be Null? Y |
SAM School Code (NN) |
|
| SID
Indexed - yes
Format - Char
May be Null? N |
The Student ID, normally SSN, which serves as the key for the SAM system. The data in this field will be restricted to only those individuals who are granted the SSN role. |
|
| Source Indexed - yes
Format - Varchar2(15)
May be Null? Y |
Source of funds. Based on 1st number of account (actually should use the legacy account fund type from BEN) |
|
SRS School Code
Indexed - yes
Format - Varchar2(2)
May be Null? Y |
SRS School Code (AA)
Note: in the Business Objects universe, there is also a decode for the SRS School Name, using a lookup to the SCHOOL table. |
|
SRS Division Code
Indexed - yes
Format - Varchar2(3)
May be Null? Y |
SRS Division Code (AAA)
Note: in the Business Objects universe, there is also a decode for the SRS Division Name, using a lookup to the DIVISION table. |
|
| SRS_Term
Indexed - yes
Format - Varchar2(5)
May be Null? N |
The term in the Student Records System (SRS) that corresponds to the SAM term on this record. SRS terms use A for Spring, B for Summer and C for Fall. |
|
| Term_Session Indexed - yes
Format - Varchar2(1)
May be Null? N |
The term session in the Student Records System (SRS) that corresponds to the SAM term on this record. SRS term sessions use 1, 2, blank (full term) or S for Special session. |
|
