| Data element |
Definition |
| Academic_Program_Id Indexed - no
Format - Number
May be Null? Y | The foreign key to the GF_ACADEMIC_PROGRAM table. |
| Active Indexed - no
Format - Varchar2(1)
May be Null? Y | |
| Allocation_Component_Id Indexed - yes
Format - Number
May be Null? N | The primary key for the GF_ALLOCATION_CHARGE table. |
| Allocation_Id Indexed - no
Format - Number
May be Null? Y | The foreign key to the GF_ALLOCATION_ORIG table. |
| Allocation_Type Indexed - no
Format - Varchar2(2)
May be Null? Y | Abbreviation of the allocation type, from the GF_ALLOCATION_TYPE table. Allocation types are Service/Non-Service, Financial Aid or External. |
| Allocation_Type_Id Indexed - no
Format - Number
May be Null? Y | The foreign key to the GF_ALLOCATIN_TYPE table. |
| Amount Indexed - no
Format - Number
May be Null? Y | The value of Cash, or CUs if Course Charge type is used for the allocation. For most reporting purposes, use Derived_Amount. |
| Banner_Term Indexed - no
Format - Varchar2(6)
May be Null? Y | The term in Banner to which this Allocation applies. |
| Charge_Type Indexed - no
Format - Varchar2(40)
May be Null? Y | From the GF_CHARGE_TYPE table: this description is the label used on the Allocation and Funding pages for a given Charge Type |
| Charge_Type_Id Indexed - no
Format - Number
May be Null? Y | The foreign key to the GF_CHARGE_TYPE table. |
| Derived_Amount Indexed - no
Format - Number
May be Null? Y | The dollar value amount of the allocation. |
| Entered_By Indexed - no
Format - Varchar2(8)
May be Null? Y | The Penn ID of the user who entered the record |
| Entered_On Indexed - no
Format - Date
May be Null? Y | The date the record was created |
| Last_Edited_By Indexed - no
Format - Varchar2(8)
May be Null? Y | The Penn ID of the last editor of the record |
| Last_Edited_On Indexed - no
Format - Date
May be Null? Y | The date the record was last edited |
| Ods_Etl_Update_Dt Indexed - no
Format - Date
May be Null? Y | |
| Package_Name Indexed - no
Format - Varchar2(60)
May be Null? Y | The name of the package. See GF_FUNDING_PACKAGE. |
| Package_Year Indexed - no
Format - Number
May be Null? Y | Generic counter for the years, starts with 0 and will contain records up to the max years allowed for the package. This value, combined with the entry year of the student, will ensure that the correct plan for a given year is created correctly. |
| Penn_Id Indexed - no
Format - Varchar2(8)
May be Null? Y | The student's Penn_ID. |
| Percentage Indexed - no
Format - Number
May be Null? Y | |
| Stg_Merge_Dt Indexed - no
Format - Date
May be Null? Y | |
