| 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.) |
