| Data element |
Definition |
| Active_Indicator Indexed - no
Format - Varchar2(4)
May be Null? Y | DETC_ACTIVE_IND: Active Status Indicator of the Detail Code. Valid values come from the Banner TAISMGR.TBBDETC table. |
| Aged_Receivable_Category Indexed - no
Format - Varchar2(28)
May be Null? Y | The category that this detail code falls in for purposes of the aged receivable report |
| Aid_Year_Indicator Indexed - no
Format - Varchar2(4)
May be Null? Y | AID YEAR INDICATOR: This field indicates if a detail code can only be applied to a transaction in the same aid year. Valid values: (Y)es, apply only to a like aid year, and (N)o; Used primarily for financial aid transactions. |
| Brs_User_Code Indexed - no
Format - Varchar2(4)
May be Null? Y | User code associated with related subcode from legacy BRS system. See valid values in DWADMIN.BRS_USER. |
| Charge_Payment_Indicator Indexed - no
Format - Varchar2(4)
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. |
| Ddr_Indicator Indexed - no
Format - Varchar2(4)
May be Null? Y | DIRECT DEPOSIT REFUND INDICATOR: Indicator used to determine whether refund code is to be processed through direct deposit payment, (Y)es and (N)o. |
| Default_Amount Indexed - no
Format - Number
May be Null? Y | This field specifies the default amount associated with the detail code. |
| Detail_Code Indexed - yes
Format - Varchar2(16)
May be Null? N | Code that identifies the nature of the transaction. A detail code is associated with every charge and payment that can be entered onto an account. The detail codes in Banner are like the transaction subcodes in the legacy BRS system, except that Banner details codes are 4 character alpha-numeric codes, whereas the old subcodes were numeric. |
| Detail_Code_Category Indexed - no
Format - Varchar2(12)
May be Null? Y | This field identifies the catagory of the detail code. Detail codes can be group for reporting purposes into catagories like cash, tuition, etc. Valid values from Banner TAISMGR.TTVDCAT 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). |
| Detail_Code_Indicator Indexed - no
Format - Varchar2(4)
May be Null? Y | DETAIL CODE INDICATOR: This column defines a detail code indicator. Valid values are : (B)ill, (P)ayment, (T)ransfer, (R)efund, Null. |
| Detail_Code_Priority Indexed - no
Format - Varchar2(12)
May be Null? Y | This field indicates the priority of the detail code for use in the application of payments process. |
| Detc_Data_Origin Indexed - no
Format - Varchar2(120)
May be Null? Y | DATA ORIGIN: Source system that created or updated the data. |
| Effective_Date Indexed - no
Format - Date
May be Null? Y | This field specifies the default effective date associated with the detail code. |
| Effective_Term Indexed - no
Format - Varchar2(24)
May be Null? Y | This field identifies the default Banner term code associated with the detail code. |
| Home_Dept_Code Indexed - no
Format - Varchar2(16)
May be Null? Y | Identifies the Department that owns this detail code; NOT USED. |
| Last_Activity_Date Indexed - no
Format - Date
May be Null? Y | This field specifies the most current date record was created or updated. |
| Last_Updated_By Indexed - no
Format - Varchar2(120)
May be Null? Y | USER ID: The user ID of the person who inserted or last updated this record. |
| Like_Period_Indicator Indexed - no
Format - Varchar2(4)
May be Null? Y | LIKE PERIOD INDICATOR: This field indicates if a detail code can only be applied to a transaction in the same Financial Aid Enrollment Period. Valid values:(Y)es, apply only to a like enrollment period, and (N)o; Used for financial aid transactions. |
| Like_Term_Indicator Indexed - no
Format - Varchar2(4)
May be Null? Y | This field indicates if a detail code can only be applied to a detail code in the same term in the application of payment process. Valid value is: Y - Yes, only apply to a like term. Used primarily for financial aid. |
| Loan_Code Indexed - no
Format - Varchar2(20)
May be Null? Y | Identifies a loan to Penns loan servicer |
| Loc_Charge_Ind Indexed - no
Format - Varchar2(4)
May be Null? Y | Indicates if this charge can be attributed to a line of credit purchase; N = not an LOC charge, Y = yes, non-computer purchases, C = yes, computer purchases only |
| Ods_Etl_Update_Dt Indexed - no
Format - Date
May be Null? Y | Date the staging table was updated for this record. |
| Origin_Code Indexed - no
Format - Varchar2(28)
May be Null? Y | Identifies the source of the transaction on the students account; used for identifying where /to whom the student should direct any questions about an item on their bill; not used for initial release |
| Payment_Type Indexed - no
Format - Varchar2(4)
May be Null? Y | This field indicates the type of payment the detail code is. Default value is N - Non-cash. |
| Pls_Fee_Flag Indexed - no
Format - Varchar2(4)
May be Null? Y | Y/N/ flag to indicate whether this detail code should be considered a fee for budget calculations in the Penn Loan System |
| Refundable_Indictor Indexed - no
Format - Varchar2(4)
May be Null? Y | Refundable Indicator: Y to include credit amount in refund process (TFRRFND/TSRRFND) and to include in Location Management refund calculations; N if not selected
|
| Refund_Indicator Indexed - no
Format - Varchar2(4)
May be Null? Y | This field indicates if the detail code is identified as refund detail code that will generate an accounts payable transaction in the accounting feed. Valid values are: Y - Generate accounts payable transaction, blank - Do not. |
| S1042_Elig_Flag Indexed - no
Format - Varchar2(4)
May be Null? Y | Y/N flag to indicate whether this detail code is an eligible charge/payment for 1042-S reporting |
| Status_Date Indexed - no
Format - Date
May be Null? Y | Identifies the date associated with the active indicator. This field will be set when the active indicator changes and cannot be modified by the user |
| Stg_Merge_Dt Indexed - no
Format - Date
May be Null? Y | Date the warehouse was last updated for this record. |
| T1098_Category_Code Indexed - no
Format - Varchar2(16)
May be Null? Y | A code to indicate how this detail code is to be treated for 1098-T reporting |
| Tax_Type_Indicator Indexed - no
Format - Varchar2(8)
May be Null? Y | This field indicates that this tuition fee is eligible for a specified tax type |
| Term_Based_Indicator Indexed - no
Format - Varchar2(4)
May be Null? Y | Indicates whether a detail code is associated with a term-based designator (Y/N). |
| Title_Iv_Indicator Indexed - no
Format - Varchar2(4)
May be Null? Y | TITLE IV INDICATOR: This field indicates if the detail code is identified as Title IV detail code. Valid value is: (Y)es, Title IV detail code, and (N)o. This is used primarily by the application of payment process and Refund Process. |
| Tuition_Charge_Indicator Indexed - no
Format - Varchar2(4)
May be Null? Y | INSTITUTION CHARGE INDICATOR: This field indicates if the detail code is identified as Institutional Charges detail code. Valid value is: (Y)es, Institutional charge detail code, and (N)o. This is used by the application of payment process. |
