| Data element |
Definition |
| Aidy_Code Indexed - yes
Format - Varchar2 (4)
May be Null? N | The aid year associated with information in this record. |
| Budget_Group_Code Indexed - no
Format - Varchar2 (6)
May be Null? Y | The period budget group assigned to the applicant. |
| Budget_Group_Desc Indexed - no
Format - Varchar2 (30)
May be Null? Y | The description of the period budget group assigned. |
| COA Indexed - no
Format - Number
May be Null? Y | Student's cost of attendance calculated for aid year based on institutional methodology. |
| Penn_Id Indexed - no
Format - Varchar2(9)
May be Null? Y | Penn ID for student or applicant. |
| Pidm Indexed - yes
Format - Number (9)
May be Null? N | The internal system student identification number. |
| PK_Fa_Coa Indexed - Y
Format - Varchar(15)
May be Null? N | Internal warehouse primary key: based on PIDM, AIDY_CODE. |
| Refresh_Date Indexed - no
Format - Date
May be Null? Y | Last time data was refreshed for this record in the data warehouse. |
