LM_ML_ENRL_STG

(SQL Table)
 Index Back

Mandatory Learning Staging

This is a staging table used in Application Engine process to enroll learners into mandatory learning

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 LM_ACT_ID Number(10,0) DECIMAL(10) NOT NULL Activity ID
3 LM_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL ELM Person ID
4 LM_LRNR_GROUP_ID Number(15,0) DECIMAL(15) NOT NULL Learner Group ID - Business Role/ Student Group ID
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_ML_SEL Character(1) VARCHAR2(1) NOT NULL Selection Criteria
G=Learner Group
L=Learner
7 LM_HST_CRD_ALLOW Character(1) VARCHAR2(1) NOT NULL Allow historical credit

Y/N Table Edit

8 LM_HIST_CRD_PRD Number(3,0) SMALLINT NOT NULL Historical credit period days
9 LM_RNW_REQ Character(1) VARCHAR2(1) NOT NULL Renewal Needed
N=No
Y=Yes
10 LM_RNW_PD_DAYS Number(3,0) SMALLINT NOT NULL Renewal period
11 LM_DUE_DT_MTHD Character(2) VARCHAR2(2) NOT NULL Due date method
DT=Date
LP=Learning Period
12 LM_DUE_DATE Date(10) DATE Due Date
13 PROCESSED_FLAG Character(1) VARCHAR2(1) NOT NULL Used for Leave Donations Batch Process to indicate whether to process a request or not.
14 LM_ML_ENRL_STATUS Character(1) VARCHAR2(1) NOT NULL Mandatory Learning Enrollment status
N=No
Y=Yes
15 LM_ENRLMT_ID Number(10,0) DECIMAL(10) NOT NULL Enrollment ID
16 LM_ML_DESCR Character(254) VARCHAR2(254) NOT NULL Enrollment comments
17 LM_ROW_ADDED_DTTM DateTime(26) TIMESTAMP Datetime Added
18 LM_ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL Added By