LM_PRG_ML_LVW

(SQL View)
 Index Back

Mandatory Learning View

Mandatory Learning language view

SELECT C.OPRID , A.LM_PRG_CD , B.LANGUAGE_CD , B.LM_PRG_LONG_NM , B.LM_PRG_DESCR FROM PS_LM_PRG_VW A , PS_LM_PRG_LANG B , PS_LM_PRG_RSTR_VW C WHERE A.LM_PRG_STATUS = '10' AND A.LM_PRG_ID = B.LM_PRG_ID AND A.LM_PRG_ID = C.LM_PRG_ID AND EXISTS ( SELECT 'X' FROM PS_LM_PRG_ML D WHERE A.LM_PRG_ID=D.LM_PRG_ID AND NOT (D.LM_LRNR_GROUP_ID=0 AND D.LM_PERSON_ID=0))

  • Related Language Record for LM_PRG_ML_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_PRG_CD Character(30) VARCHAR2(30) NOT NULL Program Code is a user defined field. This field allows duplicates and is not part of the primary key structure.
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 LM_PRG_LONG_NM Character(200) VARCHAR2(200) NOT NULL Program Long Name
    5 LM_PRG_DESCR Character(254) VARCHAR2(254) NOT NULL Program Description