| Data element |
Definition |
| Activity_Date Indexed - yes
Format - Date
May be Null? Y | The date that information in this record was entered or last updated in Banner. |
| Aidy_Code Indexed - no
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. |
| Fa_Budget_Grp_Prd_Pk Indexed - yes
Format - Varchar2(60)
May be Null? N | Internal warehouse primary key based on PIDM, AIDY_CODE, RUN_NAME, BUDGET_TYPE, BUDGET_COMPONENT_CODE. |
| Penn_Id Indexed - no
Format - Varchar2(9)
May be Null? Y | Penn ID for student or applicant. |
| Period Indexed - no
Varchar2 (15)
May be Null? Y | The period associated with information in this record. |
| Pidm Indexed - no
Format - Number (9)
May be Null? N | The internal system student identification number. |
| Refresh_Date Indexed - no
Format - Date
May be Null? Y | Last time data was refreshed for this record in the data warehouse. |
| Run_Name Indexed - no
Format - Varchar2 (30)
May be Null? Y | The name to uniquely identify the run of period budgeting that produced this record. |
| User_Id Indexed - no
Format - Varchar2 (30)
May be Null? Y | The user ID of the person who inserted or last updated this record. |
