LM_PG_MGRCR_LVW

(SQL View)
 Index Back

Program LE/LG View

Program LE/LG Related Language View

SELECT C.OPRID ,CTG.LM_CATG_ID , A.LM_ACT_CD , CI.LANGUAGE_CD ,%Upper((SELECT %Substring(LNG.MESSAGE_TEXT, 1, 10) FROM PSMSGCATLANG LNG WHERE LNG.MESSAGE_SET_NBR = 18095 AND LNG.MESSAGE_NBR = 5 AND LNG.LANGUAGE_CD =CI.LANGUAGE_CD)) , CI.LM_CS_LONG_NM FROM PS_LM_ACT A , PS_LM_PERSON_OPRID C , PS_LM_CI_LANG 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 , LNG.LANGUAGE_CD , %Upper(( SELECT %Substring(LNG1.MESSAGE_TEXT, 1, 10) FROM PSMSGCATLANG LNG1 WHERE LNG1.MESSAGE_SET_NBR = 18095 AND LNG1.MESSAGE_NBR = 6 AND LNG.LANGUAGE_CD =LNG1.LANGUAGE_CD)) , LNG.LM_CS_LONG_NM FROM PS_LM_CI_TBL A , PS_LM_CI_LANG LNG , 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 = LNG.LM_CI_ID AND A.EFFDT = LNG.EFFDT 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 , LNG.LANGUAGE_CD , %Upper(( SELECT %Substring(LNG2.MESSAGE_TEXT, 1, 10) FROM PSMSGCATLANG LNG2 WHERE LNG2.MESSAGE_SET_NBR = 18095 AND LNG2.MESSAGE_NBR = 7 AND LNG.LANGUAGE_CD =LNG2.LANGUAGE_CD)) , LNG.LM_PRG_LONG_NM FROM PS_LM_PRG A , PS_LM_PERSON_OPRID C , PS_LM_PRG_LANG LNG , 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 B1.EFFDT = A.EFFDT ) AND A.LM_PRG_STATUS = '10' AND A.LM_PRG_ID = LNG.LM_PRG_ID AND A.EFFDT = LNG.EFFDT AND A.LM_PRG_ID = CTG.LM_PRG_ID AND A.EFFDT = CTG.EFFDT

  • Related Language Record for LM_PG_MGRCRS_VW

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 LM_LRN_TYPE_DESC Character(15) VARCHAR2(15) NOT NULL Type
    6 LM_ACT_NAME Character(254) VARCHAR2(254) NOT NULL Description