LM_ACT_IDLM_PERSON_IDDT=Date
LP=Learning Period
LM_MAND_DUE_VW(SQL View) |
Index Back |
|---|---|
Mandatory Due DateMandatory Due Date |
| SELECT A.LM_ACT_ID ,A.LM_PERSON_ID ,A.LM_DUE_DT_MTHD , MIN(A.LM_DUE_DATE) FROM PS_LM_PERS_MAN_VW1 A WHERE A.LM_DUE_DT_MTHD = 'DT' AND NOT EXISTS( SELECT 'X' FROM PS_LM_PERS_MAN_VW1 B WHERE A.LM_ACT_ID=B.LM_ACT_ID AND A.LM_PERSON_ID=B.LM_PERSON_ID AND B.LM_DUE_DT_MTHD='LP') GROUP BY A.LM_DUE_DT_MTHD ,A.LM_ACT_ID ,A.LM_PERSON_ID UNION SELECT A.LM_ACT_ID ,A.LM_PERSON_ID ,'LP' , MIN(A.LM_DUE_DATE) FROM PS_LM_PERS_MAN_VW1 A WHERE A.LM_DUE_DT_MTHD = 'DT' AND EXISTS( SELECT 'X' FROM PS_LM_PERS_MAN_VW1 B WHERE A.LM_ACT_ID=B.LM_ACT_ID AND A.LM_PERSON_ID=B.LM_PERSON_ID AND B.LM_DUE_DT_MTHD='LP') GROUP BY A.LM_DUE_DT_MTHD ,A.LM_ACT_ID ,A.LM_PERSON_ID |
| # | 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_DUE_DT_MTHD | Character(2) | VARCHAR2(2) NOT NULL |
Due date method
DT=Date LP=Learning Period |
| 4 | LM_DUE_DATE | Date(10) | DATE | Due Date |