LM_PRG_RSTR_VW1

(SQL View)
 Index Back

Program Roster View

Program Roster View

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 ,A.LM_PRG_STATUS ,A.LM_OWNER_ID ,C.OPRID , E.LM_PERSON_ID , E.LM_HR_EMPLID FROM PS_LM_PRG A , PS_LM_PRG_LE B , PS_LM_OPRID_LE_VW C , PS_LM_PRG_REG_VW D , PS_LM_PERSON E WHERE A.LM_PRG_ID = B.LM_PRG_ID AND A.EFFDT = B.EFFDT AND B.LM_LE_ID = C.LM_LE_ID AND A.LM_PRG_STATUS <> '30' AND %CurrentDateIn >= A.EFFDT AND %CurrentDateIn <= A.LM_END_EFFDT AND D.LM_PRG_ID = A.LM_PRG_ID AND D.LM_PERSON_ID = E.LM_PERSON_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 LM_PRG_STATUS Character(2) VARCHAR2(2) NOT NULL Program Status
    10=Active
    20=Inactive
    30=Pending
    10 LM_OWNER_ID Number(15,0) DECIMAL(15) NOT NULL Owner ID
    11 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    12 LM_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL ELM Person ID
    13 LM_HR_EMPLID Character(11) VARCHAR2(11) NOT NULL EMPLID from the HR System