LM_MAND_ENRL_VW(SQL View) |
Index Back |
---|---|
View mapping the class & persView mapping the class & pers |
SELECT A.LM_ACT_ID ,B.LM_PERSON_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 ,B.LM_ENRLMT_ID ,B.LM_STTS ,B.LM_TARGET_CMPL_DT ,B.LM_COMPL_DT ,B.LM_EMPL_RCD ,A.LM_RENEWAL_TYPE ,A.LM_RENW_DATE ,A.LM_HISTCREDIT_TYPE ,A.LM_HIST_DATE FROM PS_LM_ACT_ML A ,PS_LM_ML_ENR_AL_VW B , PS_LM_ACT_CI_VW C ,PS_LM_CURR_JOB_VW D WHERE A.LM_ACT_ID=B.LM_ACT_ID AND A.LM_ACT_ID=C.LM_ACT_ID AND C.LM_ACT_STATUS='1' AND (C.LM_END_DT>=%CurrentDateIn OR C.LM_END_DT IS NULL) AND B.LM_PERSON_ID = D.LM_PERSON_ID AND D.LM_ACTIVE = 'Y' AND %CurrentDateIn BETWEEN D.EFFDT AND D.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_CI_ID | Number(10,0) | DECIMAL(10) NOT NULL | Catalog Item ID - System Generated ID Number associated with each Catalog Item |
4 | LM_ML_SEL | Character(1) | VARCHAR2(1) NOT NULL |
Selection Criteria
G=Learner Group L=Learner |
5 | LM_HST_CRD_ALLOW | Character(1) | VARCHAR2(1) NOT NULL |
Allow historical credit
Y/N Table Edit |
6 | LM_HIST_CRD_PRD | Number(3,0) | SMALLINT NOT NULL | Historical credit period days |
7 | LM_RNW_REQ | Character(1) | VARCHAR2(1) NOT NULL |
Renewal Needed
N=No Y=Yes |
8 | LM_RNW_PD_DAYS | Number(3,0) | SMALLINT NOT NULL | Renewal period |
9 | LM_DUE_DT_MTHD | Character(2) | VARCHAR2(2) NOT NULL |
Due date method
DT=Date LP=Learning Period |
10 | LM_DUE_DATE | Date(10) | DATE | Due Date |
11 | LM_ENRLMT_ID | Number(10,0) | DECIMAL(10) NOT NULL | Enrollment ID |
12 | LM_STTS | Character(4) | VARCHAR2(4) NOT NULL |
Enrollment Status
CANC=Dropped COMP=Completed DECL=Denied ENRL=Enrolled INCO=Not Completed INPO=In-Progress MACT=Moved to New Activity NOTS=Not Started PEAP=Pending Approval PEPA=Pending Payment PLAN=Planned PPYA=Payment Approval RQST=Learning Request WAIV=Waived WTLT=Waitlisted |
13 | LM_TARGET_CMPL_DT | Date(10) | DATE | The target date by which the student should complete the course. This field is only applicable for WBT activity and the Learning Period for the WBT activity is Enforced. If the Learning Period is not enforced, this field will hold no value. |
14 | LM_COMPL_DT | Date(10) | DATE | The date on which this Enrollment was marked Completed / InComplete |
15 | LM_EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Record umber |
16 | LM_RENEWAL_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Renewal Type
D=Renewal Threshold Date P=Renewal Period Default Value: P |
17 | LM_RENW_DATE | Date(10) | DATE | Renewal date |
18 | LM_HISTCREDIT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Historical Credit Type
D=Credit Threshold Date P=Historical Credit Period Default Value: P |
19 | LM_HIST_DATE | Date(10) | DATE | Historical Date |