LM_ACT_EUFL_VW

(SQL View)
 Index Back

Activity Education Units

Activity Education Units

SELECT A.LM_ACT_ID , A.LM_EU_ID , A.LM_EU ,B.LM_CI_ID ,D.LM_PERSON_ID FROM PS_LM_ACT_EU A ,PS_LM_ACT_CI_VW B ,PS_LM_ACT_SEC C , PS_LM_PERS_LGRP_VW D WHERE A.LM_ACT_ID=B.LM_ACT_ID AND B.LM_ACT_STATUS='1' AND (B.LM_END_DT>=%CurrentDateIn OR B.LM_END_DT IS NULL) AND B.LM_ACT_ID = C.LM_ACT_ID AND C.LM_LRNR_GROUP_ID=D.LM_LRNR_GROUP_ID AND ( (B.LM_LST_ENRL_START = 'Y' AND ((B.LM_START_DT IS NOT NULL AND %CurrentDateIn <= B.LM_START_DT) OR (B.LM_START_DT IS NULL AND ((B.LM_END_DT IS NOT NULL AND %CurrentDateIn <= B.LM_END_DT) OR B.LM_END_DT IS NULL)))) OR (B.LM_LST_ENRL_START <> 'Y' AND ((B.LM_LST_ENRL_DT IS NOT NULL AND %CurrentDateIn <= B.LM_LST_ENRL_DT) OR (B.LM_LST_ENRL_DT IS NULL AND ((B.LM_LST_ENRL_DAYS > 0 AND (B.LM_LST_ENRL_TYPE = '1' AND ((B.LM_START_DT IS NOT NULL AND %CurrentDateIn <= %DateAdd(B.LM_START_DT,B.LM_LST_ENRL_DAYS * -1)) OR (B.LM_START_DT IS NULL AND ((B.LM_END_DT IS NOT NULL AND %CurrentDateIn <= B.LM_END_DT) OR B.LM_END_DT IS NULL))) ) OR (B.LM_LST_ENRL_TYPE <> '1' AND ((B.LM_START_DT IS NOT NULL AND %CurrentDateIn <= %DateAdd(B.LM_START_DT,B.LM_LST_ENRL_DAYS)) OR (B.LM_START_DT IS NULL AND ((B.LM_END_DT IS NOT NULL AND %CurrentDateIn <= B.LM_END_DT) OR B.LM_END_DT IS NULL))) ) ) OR (B.LM_LST_ENRL_DAYS = 0 AND (((B.LM_END_DT IS NOT NULL AND %CurrentDateIn <= B.LM_END_DT) OR B.LM_END_DT IS NULL))) ) ) ) ))

  • Parent record: LM_ACT

    • # 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_EU_ID Number(10,0) DECIMAL(10) NOT NULL Education Unit ID - System Generated number

    Default Value: 0

    Prompt Table: LM_EU_TYPE_VW

    3 LM_EU Number(8,2) DECIMAL(7,2) NOT NULL Education Units
    4 LM_CI_ID Number(10,0) DECIMAL(10) NOT NULL Catalog Item ID - System Generated ID Number associated with each Catalog Item
    5 LM_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL ELM Person ID