LM_PRGRSTR_I_VW

(SQL View)
 Index Back

Program Roster View

Program Roster View that is restricted by Instructor's LE.

SELECT A.LM_PRG_ID ,A.EFFDT ,A.LM_END_EFFDT ,A.LM_PRG_CD ,A.LM_PRG_LONG_NM ,A.LM_PRG_TYPE ,A.LM_VERSION ,A.LM_COORD_ID ,C.OPRID FROM PS_LM_PRG A , PS_LM_PRG_LE B , PS_LM_INSTR_LE_VW C WHERE A.LM_PRG_ID = B.LM_PRG_ID AND A.EFFDT = B.EFFDT AND B.LM_LE_ID = C.LM_LE_ID

  • Related Language Record: LM_PRG_RSTR_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LM_PRG_ID Number(10,0) DECIMAL(10) NOT NULL Program ID is a unique identifier for curriculum and certification Programs.
    2 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    3 LM_END_EFFDT Date(10) DATE The end effective date, automatically maintained, there's a doc on how this works, so read it
    4 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.
    5 LM_PRG_LONG_NM Character(200) VARCHAR2(200) NOT NULL Program Long Name
    6 LM_PRG_TYPE Character(2) VARCHAR2(2) NOT NULL Program Type
    CE=Certification
    CU=Curriculum
    7 LM_VERSION Character(30) VARCHAR2(30) NOT NULL Program Version
    8 LM_COORD_ID Number(15,0) DECIMAL(15) NOT NULL Program Coordinator
    9 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).