LM_PRG_ML_VW

(SQL View)
 Index Back

Mandatory Class view

Mandatory class view

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

  • Related Language Record: LM_PRG_ML_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_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 LM_PRG_ID Number(10,0) DECIMAL(10) NOT NULL Program ID is a unique identifier for curriculum and certification Programs.
    4 LM_PRG_STATUS Character(2) VARCHAR2(2) NOT NULL Program Status
    10=Active
    20=Inactive
    30=Pending
    5 LM_PRG_LONG_NM Character(200) VARCHAR2(200) NOT NULL Program Long Name
    6 LM_PRG_DESCR Character(254) VARCHAR2(254) NOT NULL Program Description