| Data element |
Definition |
| Brs_Subcode Indexed - no
Format - Varchar2(5)
May be Null? Y | Legacy subcode A 5 digit number used to categorize the transaction in the old system. See also DWADMIN.BRS_SUBCODE. |
| Detail_Code Indexed - no
Format - Varchar2(4)
May be Null? Y | 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. See also DWNGSS.DETAIL_CODE table. |
| Detail_Code_Category Indexed - no
Format - Varchar2(4)
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. See also DWNGSS.DETAIL_CODE table. |
| Detail_Code_Type Indexed - no
Format - Varchar2(1)
May be Null? Y | P - Payment or C - Charge. References CHARGE_PAYMENT_INDICATOR in DWNGSS.DETAIL_CODE |
| Effective_Date Indexed - no
Format - Date
May be Null? Y | Date and time record became effective |
| End_Date Indexed - no
Format - Date
May be Null? Y | Date and time record became inactive, 12/30/2099 for active records |
| Entered_By Indexed - no
Format - Varchar2(8)
May be Null? Y | The Penn ID of the person who entered the row. |
| Entered_On Indexed - no
Format - Date
May be Null? Y | The creation date of the row |
| Generated_Flag Indexed - no
Format - Varchar2(1)
May be Null? Y | Y if mapping was system generated; defaults to N |
| Last_Edited_By Indexed - no
Format - Varchar2(8)
May be Null? Y | The Penn ID of the last person who updated the row |
| Last_Edited_On Indexed - no
Format - Date
May be Null? Y | The date when the row was last updated |
| Legacy_Pls_Restriction_Code Indexed - no
Format - Varchar2(1)
May be Null? Y | X or null, calculated based on conversion rules for detail code category and PLS (Penn Loan System) fee restrictions |
| Legacy_User_Code Indexed - no
Format - Varchar2(1)
May be Null? Y | Calculated based on conversion rules for detail code category and PLS (Penn Loan System) fee |
| Mapping_Id Indexed - yes
Format - Number
May be Null? N | Unique ID |
| Ods_Etl_Update_Dt Indexed - no
Format - Date
May be Null? Y | Date the staging table was updated for this record. |
| Primary_Flag Indexed - no
Format - Varchar2(1)
May be Null? Y | Identifies the mapping relationship between legacy subcode and Banner detail code. Values will be Y where there is a one-to-one relationship between subcode and detail code, and Y on the primary record, for records with many subcodes-to-one detail code. |
| Stg_Merge_Dt Indexed - no
Format - Date
May be Null? Y | Date the warehouse was last updated for this record. |
| Subcode_Description Indexed - no
Format - Varchar2(30)
May be Null? Y | Text description of the BRS_SUBCODE. Format is all uppercase. See also DWADMIN.BRS_SUBCODE. |
