|
Data element
|
Definition |
Object name in Business Objects universe (if different from data element name)
|
| Budget_Amount Indexed - no
Format - Number
May be Null? Y |
|
|
| Budget_Desc Indexed - no
Format - Varchar2(25)
May be Null? Y |
|
|
| Budget_Field_Number Indexed - no
Format - Char
May be Null? Y |
|
|
| Budget_Type Indexed - yes
Format - Varchar2(2)
May be Null? N |
|
|
| 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. |
|
|
| Penn_Id Indexed - no
Format - Char
May be Null? Y |
The 8-digit identification number assigned to the student; populated from a lookup to an extract from the PennCommunity database. |
|
| SID
Indexed - yes
Format - Char
May be Null? N |
Social security number from source system. This is a protected field. |
|
| SAM_Term |
SAM term for the budget details. Where term is defined as YYYYT, for example: 2010A = Summer 1 2010, 2010B = Fall 2010 -> Spring 2011, 2010C = Summer 1 2011 |
|
