LM_ENMASSDT_HST

(SQL Table)
Index Back

Mass Enrlmt Details

Mass Enrollment Detail Record- Updated from the App Eng

# 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 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
4 PROCESSINSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
5 LM_SEQ_NBR Number(10,0) DECIMAL(10) NOT NULL Sequence number to increment for the mass req record
6 LM_MASS_DT_SEQ_NBR Number(10,0) DECIMAL(10) NOT NULL Mass Person Details Seq Nbr
7 LM_ENRLMT_ID Number(10,0) DECIMAL(10) NOT NULL Enrollment ID
8 LM_ACT_ID Number(10,0) DECIMAL(10) NOT NULL Activity ID
9 LM_PRG_ID Number(10,0) DECIMAL(10) NOT NULL Program ID is a unique identifier for curriculum and certification Programs.
10 LM_CI_ID Number(10,0) DECIMAL(10) NOT NULL Catalog Item ID - System Generated ID Number associated with each Catalog Item
11 LM_ADHC_MASS_ID Number(10,0) DECIMAL(10) NOT NULL Adhoc Mass Id
12 LM_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL ELM Person ID
13 LM_PROCESS_STATUS Character(2) VARCHAR2(2) NOT NULL Fr Mass Enrollment
ER=Error
PE=Pending
PO=Processed
PR=Processing
SU=Successful
14 LM_PROCESSED_DT Date(10) DATE Fr Mass Enrollment _ Processed Date
15 LM_ROW_ADDED_DTTM DateTime(26) TIMESTAMP Datetime Added
16 LM_ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL Added By
17 LM_ROW_MAINT_DTTM DateTime(26) TIMESTAMP Row Maintainted DateTime
18 LM_ROW_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Row Maintained Oprid
19 LM_ENRLMT_DESCR Long Character(2000) VARCHAR2(2000) Comments