| Data element |
Definition |
| Account Indexed - no
Format - Varchar2(104)
May be Null? Y | The 26-digit Chart of Accounts number in BEN, for the clearing account that was debited or credited for the funded amount. |
| Amount Indexed - no
Format - Number
May be Null? Y | The amount in the Clearing Account that was either debited or credited. When the clearing account is debited the amount will be positive. When the clearing account is credited (meaning the actual funding source account will be debited), the amount will appear with a minus sign, i.e., as a negative number in GF_CLEARING_ACCOUNT_DETAIL.
. |
| 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(40)
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.. |
| 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. |
| GF_Allocation_Id Indexed - no
Format - Number
May be Null? Y | n/a |
| GF_Exemption_Id Indexed - no
Format - Number
May be Null? Y | Internal key to the GF_EXEMPTION table. |
| GF_Gurfeed_Trans_Log_Id Indexed - yes
Format - Number
May be Null? N | Internal unique key to this table. |
| GF_Job_Id Indexed - no
Format - Number
May be Null? Y | |
| GF_Student_Id Indexed - no
Format - Number
May be Null? Y | Internal identifying for the student in the Grad Funding system. For reporting purposes, use Penn_ID instead of GF_Student_ID. |
| GF_Term_Id Indexed - no
Format - Number
May be Null? Y | Internal key to the GF_Term table, that contains mapping of terms to other systems (SRS, 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. |
| 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 |
| Processed_Date Indexed - no
Format - Date
May be Null? Y | |
| Stg_Merge_Dt Indexed - no
Format - Date
May be Null? Y | Date the Data Warehouse was last updated for this record. |
