| Data element |
Definition |
| Accounting_Date Indexed - no
Format - Varchar2(32)
May be Null? Y | Date the transaction was sent to the GL |
| Activity_Date Indexed - no
Format - Date
May be Null? Y | Date which drives the transaction |
| Banner_Journal_Term Indexed - no
Format - Varchar2(60)
May be Null? Y | Banner term the transaction is loaded to the GL |
| Banner_Term Indexed - no
Format - Varchar2(24)
May be Null? Y | Banner term associated with the transaction |
| Cr_Dr_Ind Indexed - yes
Format - Varchar2(4)
May be Null? N | Indicates whether this is a Credit or Debit transaction on the GL
Values:
C - Credit
D - Debit
|
| Date_Created Indexed - no
Format - Varchar2(32)
May be Null? Y | Date the transaction was created in the GL |
| Detail_Code Indexed - no
Format - Varchar2(16)
May be Null? Y | Detail code associated with the transaction |
| Detail_Code_Category Indexed - no
Format - Varchar2(12)
May be Null? Y | Detail code category associated with the transaction |
| GFC_Key
Indexed - no
Format - Number
May be Null? Y | Unique key for the transaction - ties back to the table STUDENT_ACCT_GL_DETAIL |
| GL_Account
Indexed - no
Format - Varchar2(240)
May be Null? Y | 26 digit account for the transaction. Note that the credits and debits will usually show different accounts, i.e., where cr_dr__ind = ‘C,’ GL_Account is the 26 digit account for the credits transaction, and where cr_dr__ind = ‘D’, this is the 26 digit account for the debits transaction. |
| GL_Bc
Indexed - no
Format - Varchar2(4)
May be Null? Y | Chart of accounts Budgetary Code (part of the 26-digit GL_Account) |
| GL_Cnac
Indexed - no
Format - Varchar2(12)
May be Null? Y | Chart of Accounts CNAC (part of the 26-digit GL_Account) |
| GL_Cref
Indexed - no
Format - Varchar2(16)
May be Null? Y | Chart of Account Center Ref Code (part of the 26-digit GL_Account) |
| GL_Fund
Indexed - no
Format - Varchar2(24)
May be Null? Y | Chart of Accounts Fund Code (part of the 26-digit GL_Account) |
| GL_Object_Code
Indexed - no
Format - Varchar2(16)
May be Null? Y | Chart of Account Object Code (part of the 26-digit GL_Account) |
| GL_Org
Indexed - no
Format - Varchar2(16)
May be Null? Y | Chart of Accounts Organization Code (part of the 26-digit GL_Account) |
| GL_Program
Indexed - no
Format - Varchar2(16)
May be Null? Y | Chart of Accounts Program Code (part of the 26-digit GL_Account) |
| ID
Indexed - yes
Format - Number
May be Null? N | Id for the paired transaction - this is not the unique ID on this table - each ID will be repeated twice - once each for the debit and credit sides of the transaction |
| Ji_Status Indexed - no
Format - Varchar2(12)
May be Null? Y | Status of the Journal - Value will be "NEW" for most transactions |
| Journal_Attribute_4 Indexed - no
Format - Varchar2(60)
May be Null? Y | Journal attribute 4 (This is usually the same as the Journal_Batch_Name) |
| Journal_Batch_Name Indexed - no
Format - Varchar2(120)
May be Null? Y | Batch name for the Journal - formatted as 'PNT_AR XXX YYYYMMDD' where XXX is the a number |
| Journal_Category Indexed - no
Format - Varchar2(40)
May be Null? Y | Category of the journal - Feeder for all batch interface transactions |
| Journal_Reference_10 Indexed - no
Format - Varchar2(120)
May be Null? Y | For summary transactions, will be 'PENNANT ACCT FEED XXXXXX' where XXXXXX is Banner term. For non-summarized transactions, will contain 'XX, Student last name, student first name' where 'XX' is the Banner Division code of the student |
| Journal_Reference_4 Indexed - no
Format - Varchar2(120)
May be Null? Y | Batch name for the Journal - formatted as 'PNT_AR XXX YYYYMMDD' where XXX is the a number |
| Journal_Source_Name Indexed - no
Format - Varchar2(60)
May be Null? Y | Source of the Journal 'PENNANT AR' for all Pennant transactions |
| Journal_Student_Id Indexed - no
Format - Varchar2(60)
May be Null? Y | Student ID of either the student associated with a non_summary transaction, or something else, TBD |
| Journal_User_Name Indexed - no
Format - Varchar2(60)
May be Null? Y | PENNANT_AR for all transactions |
| 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(36)
May be Null? Y | PennID of the student for non rolled transaction - for summary transactions this should be null |
| Srs_Term Indexed - no
Format - Varchar2(24)
May be Null? Y | SRS term associated with the transaction |
| Srs_Term_Session Indexed - no
Format - Varchar2(8)
May be Null? Y | SRS term session associated with the transaction |
| 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 which was sent to the GL |
| Transaction_Date Indexed - no
Format - Date
May be Null? Y | Date of the Student Account transaction |
