LM_MAND_RGST_VW(SQL View) |
Index Back |
|---|---|
View mapping the class & persView mapping the class & pers |
| SELECT A.LM_PRG_ID ,B.LM_PERSON_ID ,A.LM_ML_SEL ,A.LM_HST_CRD_ALLOW ,A.LM_HIST_CRD_PRD ,A.LM_DUE_DT_MTHD ,A.LM_DUE_DATE ,B.LM_PRG_REG_ID ,B.LM_PRG_STTS ,B.LM_TARGET_CMPL_DT ,B.LM_COMPL_DT ,B.LM_EMPL_RCD ,A.LM_HISTCREDIT_TYPE ,A.LM_HIST_DATE FROM PS_LM_RGSTN_ML_VW A ,PS_LM_PRG_REG B , PS_LM_PRG_VW C ,PS_LM_CURR_JOB_VW D WHERE A.LM_PRG_ID=B.LM_PRG_ID AND A.LM_PERSON_ID = B.LM_PERSON_ID AND A.LM_PRG_ID=C.LM_PRG_ID AND B.LM_MAND_ENRL_FLG = 'Y' AND C.LM_PRG_STATUS='10' 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_PRG_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Program ID is a unique identifier for curriculum and certification Programs. |
| 2 | LM_PERSON_ID |
Number(15,0) | DECIMAL(15) NOT NULL | ELM Person ID |
| 3 | LM_ML_SEL | Character(1) | VARCHAR2(1) NOT NULL |
Selection Criteria
G=Learner Group L=Learner |
| 4 | LM_HST_CRD_ALLOW | Character(1) | VARCHAR2(1) NOT NULL |
Allow historical credit
Y/N Table Edit |
| 5 | LM_HIST_CRD_PRD | Number(3,0) | SMALLINT NOT NULL | Historical credit period days |
| 6 | LM_DUE_DT_MTHD | Character(2) | VARCHAR2(2) NOT NULL |
Due date method
DT=Date LP=Learning Period |
| 7 | LM_DUE_DATE | Date(10) | DATE | Due Date |
| 8 | LM_PRG_REG_ID | Number(10,0) | DECIMAL(10) NOT NULL | The Program Registration ID is a unique identifier for a learner's program enrollment. |
| 9 | LM_PRG_STTS | Character(4) | VARCHAR2(4) NOT NULL |
Program Reg Status
CANC=Dropped COMP=Completed DECL=Decline ENRL=Registered EXPR=Expired INCO=Not Completed INPO=In-Progress PEAP=Pending Approval PEPA=Pending Payment PLAN=Planned PPYA=Payment Approval REIS=Reissue REVK=Revoked WAIV=Waived WARN=Warning |
| 10 | 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. |
| 11 | LM_COMPL_DT | Date(10) | DATE | The date on which this Enrollment was marked Completed / InComplete |
| 12 | LM_EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Record umber |
| 13 | LM_HISTCREDIT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Historical Credit Type
D=Credit Threshold Date P=Historical Credit Period Default Value: P |
| 14 | LM_HIST_DATE | Date(10) | DATE | Historical Date |