LM_SCHD_LC_LVW

(SQL View)
 Index Back

Scheduled View

Scheduled View

SELECT DISTINCT A.LM_CI_ID , A.LM_ACT_ID , D.LM_PERSON_ID , B.LM_LC_ID , E.LANGUAGE_CD , E.LM_DM_LONG_NM FROM PS_LM_ACT_CI_VW A , PS_LM_ACT_CI_LVW E , PS_LM_LC_SES_FL_VW B , PS_LM_ACT_SEC C , PS_LM_PERS_LGRP_VW D WHERE A.LM_ACT_ID=B.LM_ACT_ID AND A.LM_ACT_ID=E.LM_ACT_ID AND A.LM_ACT_STATUS='1' 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_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))) ) ) ) ))

  • Related Language Record for LM_SCHD_LC1_VW LM_SCHD_LC_P_VW LM_SCHD_LC_VW

    • # 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_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL ELM Person ID
    4 LM_LC_ID Number(10,0) DECIMAL(10) NOT NULL Learning Component ID - Blended Learning
    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 LM_DM_LONG_NM Character(200) VARCHAR2(200) NOT NULL Long Name - the long name of a Delivery Method Type