LM_ACT_ML(SQL Table) |
Index Back |
---|---|
Mandatory Learning tableMandatory Learning table |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | LM_ACT_ID | Number(10,0) | DECIMAL(10) NOT NULL | Activity ID |
2 | LM_LRNR_GROUP_ID | Number(15,0) | DECIMAL(15) NOT NULL |
Learner Group ID - Business Role/ Student Group ID
Prompt Table: LM_ML_LG_VW |
3 | LM_PERSON_ID | Number(15,0) | DECIMAL(15) NOT NULL |
ELM Person ID
Prompt Table: LM_ML_NAME_VW |
4 | LM_ML_SEL | Character(1) | VARCHAR2(1) NOT NULL |
Selection Criteria
G=Learner Group L=Learner Default Value: G |
5 | LM_HST_CRD_ALLOW | Character(1) | VARCHAR2(1) NOT NULL |
Allow historical credit
Y/N Table Edit |
6 | LM_HISTCREDIT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Historical Credit Type
D=Credit Threshold Date P=Historical Credit Period Default Value: P |
7 | LM_HIST_CRD_PRD | Number(3,0) | SMALLINT NOT NULL | Historical credit period days |
8 | LM_HIST_DATE | Date(10) | DATE | Historical Date |
9 | LM_RNW_REQ | Character(1) | VARCHAR2(1) NOT NULL |
Renewal Needed
N=No Y=Yes Default Value: N |
10 | LM_RENEWAL_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Renewal Type
D=Renewal Threshold Date P=Renewal Period Default Value: P |
11 | LM_RNW_PD_DAYS | Number(3,0) | SMALLINT NOT NULL | Renewal period |
12 | LM_RENW_DATE | Date(10) | DATE | Renewal date |
13 | LM_DUE_DT_MTHD | Character(2) | VARCHAR2(2) NOT NULL |
Due date method
DT=Date LP=Learning Period Default Value: LP |
14 | LM_MAN_LRN_PD | Number(3,0) | SMALLINT NOT NULL | Mandatory Learning Period |
15 | LM_DUE_DATE | Date(10) | DATE | Due Date |