| Data element |
Definition |
| Account_A Indexed - no
Format - Varchar2(240)
May be Null? Y | For payments: Account A is the "central receivables" account. When a payment is made, it should credit the 26-digit General Ledger account number in Account A. |
| Account_A_Bc Indexed - no
Format - Varchar2(1)
May be Null? Y | The budgetary control character that represents the level at which funds availability checking occurs, for the 26-digit General Ledger account number in Account_A. |
| Account_A_Cnac Indexed - no
Format - Varchar2(3)
May be Null? Y | The 3-character Center Net Asset Class code in the 26-digit General Ledger account number in Account A. |
| Account_A_Cref Indexed - no
Format - Varchar2(4)
May be Null? Y | The 4-character Center Reference code in the 26-digit General Ledger account number in Account A. |
| Account_A_Fund Indexed - no
Format - Varchar2(6)
May be Null? Y | The 6 digit Fund number in the 26-digit General Ledger account number in Account A. |
| Account_A_Object Indexed - no
Format - Varchar2(4)
May be Null? Y | The 4-character Object code in the 26-digit General Ledger account number in Account A. |
| Account_A_Org Indexed - no
Format - Varchar2(4)
May be Null? Y | The 4-character Organization code in the 26-digit General Ledger account number in Account A. |
| Account_A_Program Indexed - no
Format - Varchar2(4)
May be Null? Y | The 4-character Program code in the 26-digit General Ledger account number in Account A. |
| Account_B Indexed - no
Format - Varchar2(240)
May be Null? Y | For charges: Account B should be credited when the charge is posted to the student's account. Equivalent to Account #1 in the legacy BRS system. |
| Account_B_Bc Indexed - no
Format - Varchar2(1)
May be Null? Y |
The budgetary control character that represents the level at which funds availability checking occurs, for the 26-digit General Ledger account number in Account_B. |
| Account_B_Cnac Indexed - no
Format - Varchar2(3)
May be Null? Y |
The 3-character Center Net Asset Class code in the 26-digit General Ledger account number in Account B. |
| Account_B_Cref Indexed - no
Format - Varchar2(4)
May be Null? Y |
The 4-character Center Reference code in the 26-digit General Ledger account number in Account B. |
| Account_B_Fund Indexed - no
Format - Varchar2(6)
May be Null? Y |
The 6 digit Fund number in the 26-digit General Ledger account number in Account B. |
| Account_B_Object Indexed - no
Format - Varchar2(4)
May be Null? Y |
The 4-character Object code in the 26-digit General Ledger account number in Account B. |
| Account_B_Org Indexed - no
Format - Varchar2(4)
May be Null? Y |
The 4-character Organization code in the 26-digit General Ledger account number in Account B. |
| Account_B_Program Indexed - no
Format - Varchar2(4)
May be Null? Y |
The 4-character Program code in the 26-digit General Ledger account number in Account B. |
| Banner_Pidm Indexed - yes
Format - Number
May be Null? N | Internal Banner person identifier |
| 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. |
| Description Indexed - no
Format - Varchar2(120)
May be Null? Y | Detail Code description. See also DWNGSS.DETAIL_CODE table. |
| Detail_Code Indexed - no
Format - Varchar2(16)
May be Null? Y | Detail Code associated with the transaction. See also DWNGSS.DETAIL_CODE table. |
| 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 - Char
May be Null? Y | The 8-digit identification number assigned to the student when their record was created in the PennCommunity database. |
| Stg_Merge_Dt Indexed - no
Format - Date
May be Null? Y | Date the warehouse was last updated for this record. |
| Third_Account Indexed - no
Format - Varchar2(104)
May be Null? Y | The Third Account should be credited when the charge on the student's account is paid. It is equivalent to credits on account #2 in the legacy BRS system. |
| Third_Account_Bc Indexed - no
Format - Varchar2(1)
May be Null? Y | The 1 digit Budget Code of the Third Account associated with this transaction. Part of the 26 digit COA designation. |
| Third_Account_Cnac Indexed - no
Format - Varchar2(3)
May be Null? Y | The 3 digit Center Net Asset Class of the Third Account associated with this transaction. Part of the 26 digit COA designation. |
| Third_Account_Cref Indexed - no
Format - Varchar2(4)
May be Null? Y | The 4 digit CenterRef code of the Third Account associated with this transaction. Part of the 26 digit COA designation. |
| Third_Account_Fund Indexed - no
Format - Varchar2(6)
May be Null? Y | The 6 digit Fund Code of the Third Account associated with this transaction. Part of the 26 digit COA designation. |
| Third_Account_Object Indexed - no
Format - Varchar2(4)
May be Null? Y | The 4 digit Object Code of the Third Account associated with this transaction. Part of the 26 digit COA designation. See DWADMIN.OBJ_CODES |
| Third_Account_Org Indexed - no
Format - Varchar2(4)
May be Null? Y | The 4 digit Organization Code of the Third Account associated with this transaction. Part of the 26 digit COA designation. |
| Third_Account_Program Indexed - no
Format - Varchar2(4)
May be Null? Y | The 4 digit Program Code of the Third Account associated with this transaction. Part of the 26 digit COA designation. |
| Transaction_Amount Indexed - no
Format - Number
May be Null? Y | Amount of the transaction in US Dollars |
| Transaction_Date Indexed - no
Format - Date
May be Null? Y | Effective date of the transactions. |
| 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. |
