Data element |
Definition |
Academic_Program_Id Indexed - yes Format - Number May be Null? N | Internal key to the Grad Funding table, GF_ACADEMIC_PROGRAM. Part of the record key for this table. Also used to get the "current" academic program (not term-specific). See GF_ALLOCATION_PROGRAM. |
Allocation_Id Indexed - yes Format - Number May be Null? N | Internal key for the allocation record. Part of the record key for this table. Used to join related tables together, for a specific allocation. |
Amount Indexed - no Format - Number May be Null? Y | The summary amount of the allocations, for all types (tuition, fees, health insurance, etc.) for a student in a term in a program. |
Banner_Term Indexed - yes Format - Varchar2(24) May be Null? N | The academic term in Banner format (YYYYTT, where TT is: 10 = spring, 22 = summer1, 24 = summer2, 30 = fall). Part of the record key for this table. |
Ods_Etl_Update_Dt Indexed - no Format - Date May be Null? Y | Date the staging table was updated for this record. |
Stg_Merge_Dt Indexed - no Format - Date May be Null? Y | Date the warehouse was last updated for this record. |
Student_ID
Indexed - yes Format - Number May be Null? N | Internal key for the student. Part of the record key for this table. Used to join to other Grad Funding tables, for a specific student. (Note that the Business Objects universe for Grad Funding typically uses Penn_ID instead of Student_ID, where available.) |