LM_SELFPACED_VW(SQL View) |
Index Back |
---|---|
Learning Component ViewBasic Learning Component View |
SELECT DISTINCT A.LM_CI_ID ,A.LM_ACT_ID ,B.LM_LC_ID ,D.LM_PERSON_ID ,A.LM_ACT_CD ,A.LM_DURN_DAYS ,A.LM_DURN_HRS ,A.LM_DURN_MINS ,A.LM_LST_ENRL_DT , A.LM_START_DT ,A.LM_LST_ENRL_START ,A.LM_LST_ENRL_DAYS ,A.LM_LST_ENRL_TYPE , A.LM_DM_LONG_NM FROM PS_LM_ACT_CI_VW A , PS_LM_LC_VW B ,PS_LM_ACT_SEC C , PS_LM_PERS_LGRP_VW D WHERE A.LM_ACT_STATUS='1' AND A.LM_ACT_ID=B.LM_ACT_ID AND A.LM_ACT_ID = C.LM_ACT_ID AND C.LM_LRNR_GROUP_ID=D.LM_LRNR_GROUP_ID AND (A.LM_END_DT>=%CurrentDateIn OR A.LM_END_DT IS NULL) AND A.LM_RESTRICT_TO_PRG ='N' AND NOT EXISTS( SELECT 'X' FROM PS_LM_LC_VW E WHERE E.LM_ACT_ID=B.LM_ACT_ID AND E.LM_BAS_LC_TYPE IN('20','30')) AND B.LM_LC_ID=( SELECT MAX(F.LM_LC_ID) FROM PS_LM_LC_VW F WHERE A.LM_ACT_ID=F.LM_ACT_ID) AND ( (A.LM_LST_ENRL_START = 'Y' AND ((A.LM_START_DT IS NOT NULL AND %CurrentDateIn <= A.LM_START_DT) OR (A.LM_START_DT IS NULL AND ((A.LM_END_DT IS NOT NULL AND %CurrentDateIn <= A.LM_END_DT) OR A.LM_END_DT IS NULL)))) OR (A.LM_LST_ENRL_START <> 'Y' AND ((A.LM_LST_ENRL_DT IS NOT NULL AND %CurrentDateIn <= A.LM_LST_ENRL_DT) OR (A.LM_LST_ENRL_DT IS NULL AND ((A.LM_LST_ENRL_DAYS > 0 AND (A.LM_LST_ENRL_TYPE = '1' AND ((A.LM_START_DT IS NOT NULL AND %CurrentDateIn <= %DateAdd(A.LM_START_DT,A.LM_LST_ENRL_DAYS * -1)) OR (A.LM_START_DT IS NULL AND ((A.LM_END_DT IS NOT NULL AND %CurrentDateIn <= A.LM_END_DT) OR A.LM_END_DT IS NULL))) ) OR (A.LM_LST_ENRL_TYPE <> '1' AND ((A.LM_START_DT IS NOT NULL AND %CurrentDateIn <= %DateAdd(A.LM_START_DT,A.LM_LST_ENRL_DAYS)) OR (A.LM_START_DT IS NULL AND ((A.LM_END_DT IS NOT NULL AND %CurrentDateIn <= A.LM_END_DT) OR A.LM_END_DT IS NULL))) ) ) OR (A.LM_LST_ENRL_DAYS = 0 AND (((A.LM_END_DT IS NOT NULL AND %CurrentDateIn <= A.LM_END_DT) OR A.LM_END_DT IS NULL))) ) ) ) )) |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | LM_CI_ID | Number(10,0) | DECIMAL(10) NOT NULL | Catalog Item ID - System Generated ID Number associated with each Catalog Item |
2 | LM_ACT_ID | Number(10,0) | DECIMAL(10) NOT NULL | Activity ID |
3 | LM_LC_ID | Number(10,0) | DECIMAL(10) NOT NULL | Learning Component ID - Blended Learning |
4 | LM_PERSON_ID | Number(15,0) | DECIMAL(15) NOT NULL | ELM Person ID |
5 | LM_ACT_CD | Character(30) | VARCHAR2(30) NOT NULL | Activity Code |
6 | LM_DURN_DAYS | Number(4,0) | SMALLINT NOT NULL | Length of Activity in Days |
7 | LM_DURN_HRS | Number(3,0) | SMALLINT NOT NULL | Duration - Hours |
8 | LM_DURN_MINS | Number(3,0) | SMALLINT NOT NULL | Duration - Minutes |
9 | LM_LST_ENRL_DT | Date(10) | DATE | Last Enroll Date |
10 | LM_START_DT | Date(10) | DATE | Start Date |
11 | LM_LST_ENRL_START | Character(1) | VARCHAR2(1) NOT NULL | Last Enrollment Date = Activity Start Date |
12 | LM_LST_ENRL_DAYS | Number(3,0) | SMALLINT NOT NULL | Last Enroll Days |
13 | LM_LST_ENRL_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Last Enroll Type: Before or After the start date
1=Before the Start Date 2=After the Start Date |
14 | LM_DM_LONG_NM | Character(200) | VARCHAR2(200) NOT NULL | Long Name - the long name of a Delivery Method Type |