| Data element |
Definition |
| Banner_Pidm Indexed - no
Format - Number
May be Null? Y | Internal Banner person identifier |
| Banner_Term Indexed - no
Format - Varchar2(6)
May be Null? Y | Banner Term associated with the transaction. Banner term is formatted as YYYYTT, where YYYY is the calendar year, and TT is: 10 for Spring, 22 for Summer 1, 24 for Summer 2 and 30 for Fall. For student transactions Banner Term must be valid in the Banner SATURN.STVTERM table, or ARTERM for non-student transactions. |
| Charge_Payment_Ind Indexed - no
Format - Varchar2(4)
May be Null? Y | Charge or Payment on the student's account. Valid values are: C - Charge, P - Payment. |
| Corrected_Amt Indexed - no
Format - Number
May be Null? Y | Transaction amount, corrected for signs for charges and payments. For most warehouse queries using the STUDENT_ACCT_GL_DETAIL table, this is the amount that should be used for reporting purposes. |
| Detail_Code Indexed - no
Format - Varchar2(4)
May be Null? Y | Detail code of the transaction. See also DWNGSS.DETAIL_CODE. |
| Detail_Code_Description Indexed - no
Format - Varchar2(120)
May be Null? Y | Description of the Detail Code. See also DWNGSS.DETAIL_CODE. |
| Dr_Cr_Ind Indexed - no
Format - Varchar2(1)
May be Null? Y | Credits/Debits indicator. Values C (credit), D (debit). |
| Effective_Date Indexed - no
Format - Varchar2(11)
May be Null? Y | Effective date of the transaction used to calculate amount due, determine placement on the bill, and control feed to finance system based on Accounts Receivable System Control setting. |
| GFC_Activity_Date
Indexed - no
Format - Date
May be Null? Y | Date the transaction was processed from an individual's account to the accounting staging table. |
| GFC_Key
Indexed - yes
Format - Number
May be Null? N | Internal id number, part of the unique key for this table. |
| GFC_Penn_Gl_Feed_Date
Indexed - no
Format - Date
May be Null? Y | Date the transaction was sent to the GL |
| GFC_Penn_Gl_Ref_Number
Indexed - no
Format - Varchar2(30)
May be Null? Y | GL batch reference number - ties the detail transactions to the GL |
| GFC_Transaction_Date
Indexed - no
Format - Date
May be Null? Y | Date the transaction was posted to the student's account |
| GL_Account
Indexed - no
Format - Varchar2(60)
May be Null? Y | GL account to which the transaction was applied |
| GL_Amount
Indexed - no
Format - Number
May be Null? Y | Transaction Amount |
| GL_Bc
Indexed - no
Format - Varchar2(1)
May be Null? Y | General Ledger Budget Code associated with this tranasction. |
| GL_Cnac
Indexed - no
Format - Varchar2(3)
May be Null? Y | The General Ledger CNAC code associated with this transaction. See also DWADMIN.CNAC_CODES |
| GL_Cref
Indexed - no
Format - Varchar2(4)
May be Null? Y | The General Ledger Center Ref code associated with this transaction. |
| GL_Fund
Indexed - no
Format - Varchar2(6)
May be Null? Y | The General Ledger Fund Code associated with this transaction. See also DWADMIN.FUND_CODES. |
| GL_Object_Code
Indexed - no
Format - Varchar2(4)
May be Null? Y | The General Ledger Object Code associated with this transaction. See also DWADMIN.OBJECT_CODES. |
| GL_Org
Indexed - no
Format - Varchar2(4)
May be Null? Y | The General Ledger Organization Code associated with this transaction. See also DWADMIN.ORG_CODES. |
| GL_Program
Indexed - no
Format - Varchar2(4)
May be Null? Y | The General Ledger Program Code associated with this transaction. See also DWADMIN.PROGRAM_CODES. |
| Ods_Etl_Update_Dt Indexed - no
Format - Date
May be Null? Y | Date the staging table was updated for this record. |
| Penn_Id Indexed - no
Format - Varchar2(9)
May be Null? Y | The 8-digit identification number assigned to the student when their record was created in the PennCommunity database. |
| Rollup_Id Indexed - no
Format - Number
May be Null? Y | Rollup ID to join detail to summarized transactions:
The detail records in this table are often combined together in the transaction sent to the GL. Multiple rows in this table often have the same Rollup ID. The Rollup ID in this table maps to the ID in the STUDENT_ACCOUNT_GL table, for records with the same DR_CR_IND. |
| Source_Code Indexed - no
Format - Varchar2(1)
May be Null? Y | Code identifying the source of the transaction. See STUDENT_ACCT_SRCE_CODES table for values. |
| Srs_Term Indexed - no
Format - Varchar2(6)
May be Null? Y | SRS term code in which the transaction was applied to the student's account. SRS term is formatted YYYYT where YYYY is the calendar year and T is: A for Spring, B for Summer (both sessions) and C for Fall. |
| Srs_Term_Session Indexed - no
Format - Varchar2(2)
May be Null? Y | SRS term session code. |
| Stg_Merge_Dt Indexed - no
Format - Date
May be Null? Y | Date the warehouse was last updated for this record. |
| Transaction_Amount Indexed - no
Format - Number
May be Null? Y | Amount of the transaction, in US dollars. |
| Transaction_Number Indexed - no
Format - Varchar2(8)
May be Null? Y | The transaction number of this transaction. Each transaction for a student has a sequential transaction number assigned by Banner at the time the transaction is created. For each subsequent transaction, the transaction number is incremented by 1. Transaction numbers are unique within a student's account. For any detail transaction, the key is always student id and transaction number. |
