| Data element |
Definition |
| Aidy_Code Indexed - yes
Format - Varchar2 (16)
May be Null? Y | Aid year code associated with record. |
| Csef Indexed - no
Format - Number (22)
May be Null? Y | Amount put in by staff for attribute CSEF. |
| Csef_Track_Req Indexed - no
Format - Varchar2 (4000)
May be Null? Y | If student has a requirement track record starting with CSEF. |
| Eif Indexed - no
Format - Number (22)
May be Null? Y | Amount put in by staff for attribute EIF. |
| Eif_Track_Req Indexed - no
Format - Varchar2 (24)
May be Null? Y | If student has a requirement track record for EIF. |
| Fa_Reval_Cmt_Pk Indexed - yes
Format - Varchar2 (176)
May be Null? N | Primary key used for data warehouse merge process |
| Penn_Accept Indexed - no
Format - Number (22)
May be Null? Y | Accepted amount for aid year for U00015 fund code. |
| Penn_Id Indexed - yes
Format - Varchar2 (36)
May be Null? Y | Penn Id of student associated with record. |
| Penn_Offer Indexed - no
Format - Number (22)
May be Null? Y | Offered amount for aid year for U00015 fund code. |
| Penn_Original_Offer Indexed - no
Format - Number (22)
May be Null? Y | Original accepted amount for aid year for U00015 fund code. |
| Penn_Paid Indexed - no
Format - Number (22)
May be Null? Y | Paid amount for aid year for U00015 fund code. |
| Pidm Indexed - no
Format - Number (22)
May be Null? Y | PIDM assocated with record. |
| Refresh_Date Indexed - no
Format - Date (7)
May be Null? Y | Refresh date of when record was updated in data warehouse. |
| Reval1_5 Indexed - no
Format - Number (22)
May be Null? Y | Amount put in by staff for attribute RHRCOMM. |
| Reval1_5_Track_Req Indexed - no
Format - Varchar2 (4000)
May be Null? Y | If student has a requirement track record of REVAL1, REVAL2, REVAL 3, REVAL4, REVAL5. |
| Revali_Track_Req Indexed - no
Format - Varchar2 (4000)
May be Null? Y | If student has a requirement track record REVALI. |
| Reval_Ivy Indexed - no
Format - Number (22)
May be Null? Y | Amount put in by staff for attribute start with the pattern RE_EVAL_I. |
