| Data element |
Definition |
| Amount Indexed - no
Format - Number
May be Null? Y | The sum of the amounts in the clearing account, for a student in a term for each detail code's amounts. This is the term balance for those charge for that student. For example, if in the GF_CLEARING_ACCOUNT_DETAIL table there is a row with amount 500 and another row with -500 for the same student in the same term for the same detail code, the amount in the GF_CLEARING_ACCOUNT_SUMMARY table will be zero. |
| Banner_Term Indexed - yes
Format - Varchar2(24)
May be Null? Y | The Banner Term to which the exemptions apply, in YYYYTT format, where TT is:
10 = SPring, 22 = Summer1, 24 = Summer2, 30 = Fall |
| Brs_Subcode Indexed - no
Format - Varchar2(20)
May be Null? Y | The legacy billing system's subcode, if applicable
Note: BRS was replaced by Pennant Accounts in October of 2015. This column will only be populated for account actiivity that transpired prior to Pennant Accounts.. |
| Brs_Term Indexed - no
Format - Varchar2(12)
May be Null? Y | The legacy billing systems code for the academic term
Note: BRS was replaced by Pennant Accounts in October of 2015. This column will only be populated for account actiivity that transpired prior to Pennant Accounts.. |
| Clearing_Account_Id Indexed - yes
Format - Number
May be Null? N | Internal record key, system-generated. |
| Detail_Code Indexed - no
Format - Varchar2(16)
May be Null? Y | The Pennant Accounts Detail Code applicable for this record. Note that Detail Codes used for exemptions all start with 'X'
See DWNGSS.DETAIL_CODE for valid values. |
| Entered_By Indexed - no
Format - Varchar2(32)
May be Null? Y | |
| Entered_On Indexed - no
Format - Date
May be Null? Y | The date the record was created in the Grad Funding system. |
| Exemption_Code Indexed - no
Format - Varchar2(32)
May be Null? Y | a numeric code that can be mapped to an exemption description.
See also GF_EXEMPTION |
| Exemption_Desc Indexed - no
Format - Varchar2(320)
May be Null? Y | The text description of the exemption, in Grad Funding.
See also GF_EXEMPTION. |
| Gfc_Account Indexed - no
Format - Varchar2(104)
May be Null? Y | The 26-digit Chart of Accounts number in BEN, for the clearing account to which the summary amount applies. |
| GF_Exemption_Id Indexed - no
Format - Number
May be Null? Y | Internal numeric foreign key to the GF_Exemption table, where exemptions are decoded and mapped to COA segments. |
| GF_Student_Id Indexed - no
Format - Number
May be Null? Y | Internal numeric foreign key to the GF_Student table. For reporting purposes, it is better to use Penn_ID instead of Student_ID. |
| GF_Term_Id Indexed - no
Format - Number
May be Null? Y | Internal numeric foreign key to the GF_Term table, where terms are decoded and mapped to term codes from other systems (SRS, BRS, Banner, PLS) |
| GF_Year Indexed - no
Format - Number
May be Null? Y | The Funding year, which runs from Fall of the first year through the summer terms of the following year. For example, Fall 2015, Spring 2016, Summer1 2016 and Summer2 2016 all fall within GF_Year 2016. |
| Last_Edited_By Indexed - no
Format - Varchar2(32)
May be Null? Y | |
| Last_Edited_On Indexed - no
Format - Date
May be Null? Y | The date the record was last changed in the Grad Funding system. |
| Ods_Etl_Update_Dt Indexed - no
Format - Date
May be Null? Y | Date the staging table was updated for this record. |
| Penn_Id Indexed - yes
Format - Varchar2(32)
May be Null? Y | The student's Penn_ID. |
| Sam_Aid_Id Indexed - no
Format - Varchar2(16)
May be Null? Y | The Aid identification code from the Student Aid Management system (AID). |
| Stg_Merge_Dt Indexed - no
Format - Date
May be Null? Y | Date the warehouse was last updated for this record. |
