| 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_Component_Amt Indexed - no
Format - Number (11,2)
May be Null? Y | The amount of the specific budget component for the budget being defined. |
| Budget_Component_Code Indexed - no
Format - Varchar2 (4)
May be Null? Y | The period budget component conde assigned to the applicant. |
| Budget_Component_Desc Indexed - no
Format - Varchar2 (30)
May be Null? Y | The period budget component assigned to the applicant. |
| 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. |
| Budget_Type_Code Indexed - no
Format - Varchar2(4)
May be Null? Y | The period budget type code assigned to the applicant. |
| Budget_Type_Desc Indexed - no
Format - Varchar2(30)
May be Null? Y | The period budget type assigned to the applicant. |
| Fa_Budget_Comp_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. |
| Rule_Code Indexed - no
Format - Varchar2 (30)
May be Null? Y | The rule code used to calculate the period budget component amount. |
| Rule_Description Indexed - yes
Format - Varchar2 (200)
May be Null? N | The rule description used to calculate the period budget component amount. |
| 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. |
| Seq_Numb Indexed - no
Format - Number (5)
May be Null? Y | The sequence number of the rule code used to calculate the period budget component amount. |
| User_Id Indexed - no
Format - Varchar2 (30)
May be Null? Y | The user ID of the person who inserted or last updated this record. |
