LM_ACT_IDLM_PERSON_IDG=Learner Group
L=Learner
Y/N Table Edit
N=No
Y=Yes
DT=Date
LP=Learning Period
LM_MAND_LRNR_VW(SQL View) |
Index Back |
|---|---|
Mandatory learner viewMandatory learner view |
| SELECT A.LM_ACT_ID , A.LM_PERSON_ID , A.LM_LRNR_GROUP_ID ,B.LM_CI_ID ,A.LM_ML_SEL ,A.LM_HST_CRD_ALLOW ,A.LM_HIST_CRD_PRD ,A.LM_RNW_REQ ,A.LM_RNW_PD_DAYS ,A.LM_DUE_DT_MTHD ,A.LM_DUE_DATE ,A.LM_MAN_LRN_PD FROM PS_LM_ACT_ML A ,PS_LM_ACT_CI_VW B ,PS_LM_CURR_JOB_VW C WHERE A.LM_ACT_ID=B.LM_ACT_ID AND A.LM_PERSON_ID<>0 AND B.LM_ACT_STATUS='1' AND (B.LM_END_DT>=%CurrentDateIn OR B.LM_END_DT IS NULL) AND C.LM_PERSON_ID = A.LM_PERSON_ID AND C.LM_ACTIVE = 'Y' AND %CurrentDateIn BETWEEN C.EFFDT AND C.LM_END_EFFDT |
| # | 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_PERSON_ID |
Number(15,0) | DECIMAL(15) NOT NULL | ELM Person ID |
| 3 | LM_LRNR_GROUP_ID | Number(15,0) | DECIMAL(15) NOT NULL | Learner Group ID - Business Role/ Student Group ID |
| 4 | LM_CI_ID | Number(10,0) | DECIMAL(10) NOT NULL | Catalog Item ID - System Generated ID Number associated with each Catalog Item |
| 5 | LM_ML_SEL | Character(1) | VARCHAR2(1) NOT NULL |
Selection Criteria
G=Learner Group L=Learner |
| 6 | LM_HST_CRD_ALLOW | Character(1) | VARCHAR2(1) NOT NULL |
Allow historical credit
Y/N Table Edit |
| 7 | LM_HIST_CRD_PRD | Number(3,0) | SMALLINT NOT NULL | Historical credit period days |
| 8 | LM_RNW_REQ | Character(1) | VARCHAR2(1) NOT NULL |
Renewal Needed
N=No Y=Yes |
| 9 | LM_RNW_PD_DAYS | Number(3,0) | SMALLINT NOT NULL | Renewal period |
| 10 | LM_DUE_DT_MTHD | Character(2) | VARCHAR2(2) NOT NULL |
Due date method
DT=Date LP=Learning Period |
| 11 | LM_DUE_DATE | Date(10) | DATE | Due Date |
| 12 | LM_MAN_LRN_PD | Number(3,0) | SMALLINT NOT NULL | Mandatory Learning Period |