LM_CHGBKINF_HST

(SQL Table)
Index Back

ChargeBack Info

ChargeBack Info for an Enrollment

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PSARCH_ID Character(8) VARCHAR2(8) NOT NULL Archive ID (see PSARCHTEMPLATE).
2 PSARCH_BATCHNUM Number(30,0) DECIMAL(30) NOT NULL Archive Batch Number
3 LM_ENRLMT_ID Number(10,0) DECIMAL(10) NOT NULL Enrollment ID
4 LM_ROW_SEQ Number(10,0) DECIMAL(10) NOT NULL Row Entry for Chart Field Split for an Enrollment
5 LM_CI_ID Number(10,0) DECIMAL(10) NOT NULL Catalog Item ID - System Generated ID Number associated with each Catalog Item
6 LM_ACT_ID Number(10,0) DECIMAL(10) NOT NULL Activity ID
7 LM_HR_DEPTID Character(10) VARCHAR2(10) NOT NULL Department
8 LM_FUND_CODE Character(20) VARCHAR2(20) NOT NULL Fund Code
9 LM_CLASS_FLD Character(20) VARCHAR2(20) NOT NULL Class Chart Field
10 LM_PROGRAM_CODE Character(20) VARCHAR2(20) NOT NULL Program Chart Field
11 LM_ACCOUNT Character(20) VARCHAR2(20) NOT NULL Account Chart Field
12 LM_PROJECT_ID Character(20) VARCHAR2(20) NOT NULL Project Chart Field
13 LM_SPLIT Number(3,0) SMALLINT NOT NULL Split Percentage. The user can split theFee across various Department / Account Codes

Default Value: 100

14 LM_ROW_ADDED_DTTM DateTime(26) TIMESTAMP Datetime Added
15 LM_ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL Added By
16 LM_ROW_MAINT_DTTM DateTime(26) TIMESTAMP Row Maintainted DateTime
17 LM_ROW_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Row Maintained Oprid