LM_PG_MGRCRS_VW

(SQL View)
 Index Back

Program LE/LG View

Program LE/LG View

SELECT C.OPRID ,CTG.LM_CATG_ID , A.LM_ACT_CD ,%Upper(( SELECT %Substring(M1.MESSAGE_TEXT, 1, 10) FROM PSMSGCATDEFN M1 WHERE M1.MESSAGE_SET_NBR = 18095 AND M1.MESSAGE_NBR = 5)) , CI.LM_CS_LONG_NM , A.LM_ACT_ID , A.LM_CI_ID FROM PS_LM_ACT A , PS_LM_PERSON_OPRID C , PS_LM_CI_TBL CI , PS_LM_CATG_CI_TBL CTG WHERE EXISTS( SELECT D1.LM_PERSON_ID FROM PS_LM_ACT_SEC B1 , PS_LM_GROUP_PERSON D1 WHERE A.LM_ACT_ID = B1.LM_ACT_ID AND B1.LM_LRNR_GROUP_ID = D1.LM_LRNR_GROUP_ID AND D1.LM_PERSON_ID = C.LM_PERSON_ID ) AND A.LM_CI_ID = CI.LM_CI_ID AND CI.LM_CI_ID=CTG.LM_CI_ID AND CI.EFFDT=CTG.EFFDT UNION ALL SELECT C.OPRID ,CTG.LM_CATG_ID , A.LM_CRSE_CODE ,%Upper(( SELECT %Substring(M2.MESSAGE_TEXT, 1, 10) FROM PSMSGCATDEFN M2 WHERE M2.MESSAGE_SET_NBR = 18095 AND M2.MESSAGE_NBR = 6)) ,A.LM_CS_LONG_NM , 0 , A.LM_CI_ID FROM PS_LM_CI_TBL A , PS_LM_PERSON_OPRID C , PS_LM_CATG_CI_TBL CTG WHERE EXISTS( SELECT D1.LM_PERSON_ID FROM PS_LM_CI_SEC_TBL B1 , PS_LM_GROUP_PERSON D1 WHERE A.LM_CI_ID = B1.LM_CI_ID AND B1.LM_LRNR_GROUP_ID = D1.LM_LRNR_GROUP_ID AND D1.LM_PERSON_ID = C.LM_PERSON_ID AND B1.EFFDT = A.EFFDT ) AND %CurrentDateIn BETWEEN A.EFFDT AND A.LM_END_EFFDT AND A.LM_CI_STATUS = '10' AND A.LM_CI_ID=CTG.LM_CI_ID AND A.EFFDT=CTG.EFFDT UNION ALL SELECT C.OPRID ,CTG.LM_CATG_ID , A.LM_PRG_CD , %Upper(( SELECT %Substring(M3.MESSAGE_TEXT, 1, 10) FROM PSMSGCATDEFN M3 WHERE M3.MESSAGE_SET_NBR = 18095 AND M3.MESSAGE_NBR = 7)) , A.LM_PRG_LONG_NM , A.LM_PRG_ID , 0 FROM PS_LM_PRG A , PS_LM_PERSON_OPRID C , PS_LM_PRG_CATG CTG WHERE EXISTS( SELECT D1.LM_PERSON_ID FROM PS_LM_PRG_SEC B1 , PS_LM_GROUP_PERSON D1 WHERE A.LM_PRG_ID = B1.LM_PRG_ID AND B1.LM_LRNR_GROUP_ID = D1.LM_LRNR_GROUP_ID AND D1.LM_PERSON_ID = C.LM_PERSON_ID AND B1.EFFDT = A.EFFDT AND %CurrentDateIn BETWEEN B1.EFFDT AND B1.LM_END_EFFDT) AND A.LM_PRG_STATUS = '10' AND A.LM_PRG_ID = CTG.LM_PRG_ID AND A.EFFDT = CTG.EFFDT

  • Related Language Record: LM_PG_MGRCR_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 LM_CATG_ID Number(10,0) DECIMAL(10) NOT NULL Category ID - System generated number used to uniquely identify a Category.

    Prompt Table: LM_CATG_UI_VW

    3 LM_ACT_CD Character(30) VARCHAR2(30) NOT NULL Activity Code
    4 LM_LRN_TYPE_DESC Character(15) VARCHAR2(15) NOT NULL Type
    5 LM_ACT_NAME Character(254) VARCHAR2(254) NOT NULL Name
    6 LM_ACT_ID Number(10,0) DECIMAL(10) NOT NULL Activity ID
    7 LM_CI_ID Number(10,0) DECIMAL(10) NOT NULL Catalog Item ID - System Generated ID Number associated with each Catalog Item