| Data element |
Definition |
| Banner_Pidm Indexed - yes
Format - Number
May be Null? N | Internal Banner Identifier |
| Banner_Term Indexed - no
Format - Varchar2(24)
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. |
| Bill_Date Indexed - no
Format - Date
May be Null? Y | Date that the transaction is billed. |
| Charge_Payment_Ind Indexed - no
Format - Varchar2(1)
May be Null? Y | This field indicates the whether the detail code is a charge or a payment. Valid values are: C - Charge, P - Payment. |
| Data_Origin Indexed - no
Format - Varchar2(120)
May be Null? Y | Source system that last created or updated the data. |
| Detail_Code Indexed - no
Format - Varchar2(16)
May be Null? Y | Detail code associated with the transaction. Valid values are in Banner TAISMGR.TBBDETC. See also the warehouse DWNGSS.DETAIL_CODE table. |
| Detail_Code_Description Indexed - no
Format - Varchar2(120)
May be Null? Y | Text description of the DETAIL_CODE associated with the transaction. Default value comes from the Banner Detail Code description (TAISMGR.TBBDETC). See also the warehouse DWNGSS.DETAIL_CODE table. |
| Due_Date Indexed - no
Format - Date
May be Null? Y | Date by which payment to the University is due. Due date set when the transaction is billed. |
| Effective_Date Indexed - no
Format - Date
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. |
| Entry_Date Indexed - no
Format - Date
May be Null? Y | Initial create date of the transaction |
| Last_Activity_Date Indexed - no
Format - Date
May be Null? Y | The last date this row was created or updated. |
| 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 - Char
May be Null? Y | The 8-digit identification number assigned to the student when their record was created in the PennCommunity database. |
| Source_Code Indexed - no
Format - Varchar2(4)
May be Null? Y | Code that identifies the origin of the transaction. For example, K for feeder app, R for tuition calc, F for financial aid, T for transactions entered online, X for converted
transactions The default value is user entered transaction (T). Valid values come from Banner TAISMGR.TTVSRCE. |
| Srs_Term Indexed - yes
Format - Varchar2(5)
May be Null? Y | SRS term associated with the transaction. 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(1)
May be Null? Y | SRS session (for summer terms) 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 |
| Transaction_Number Indexed - yes
Format - Number
May be Null? N | 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. |
| User_Id Indexed - no
Format - Varchar2(120)
May be Null? Y | Banner User ID, identifying who last updated the record in the source system (Pennant Accounts/Banner). |
