LM_PRG_VW2

(SQL View)
 Index Back

Program View

Program View

SELECT A.LM_PRG_ID , A.EFFDT , A.LM_END_EFFDT , A.LM_PRG_STATUS , A.LM_PRG_TYPE , A.LM_PRG_CD , A.LM_VERSION , A.LM_PRG_LONG_NM , A.LM_PRG_SHORT_NM , A.LM_PRG_DESCR FROM PS_LM_PRG A WHERE %CurrentDateIn BETWEEN A.EFFDT AND A.LM_END_EFFDT

  • Related Language Record: LM_PRG_LVW2

    • # 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_STATUS Character(2) VARCHAR2(2) NOT NULL Program Status
    10=Active
    20=Inactive
    30=Pending
    5 LM_PRG_TYPE Character(2) VARCHAR2(2) NOT NULL Program Type
    CE=Certification
    CU=Curriculum
    6 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.
    7 LM_VERSION Character(30) VARCHAR2(30) NOT NULL Program Version
    8 LM_PRG_LONG_NM Character(200) VARCHAR2(200) NOT NULL Program Long Name
    9 LM_PRG_SHORT_NM Character(10) VARCHAR2(10) NOT NULL Program Short Name
    10 LM_PRG_DESCR Character(254) VARCHAR2(254) NOT NULL Program Description