LM_PRG_STTS_VW

(SQL View)
 Index Back

Program Status

Program Status view . Translate Values

SELECT A.FIELDVALUE LM_PRG_STTS , XLATLONGNAME FROM PSXLATITEM A WHERE A.FIELDNAME='LM_PRG_STTS' AND A.EFF_STATUS='A' AND A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PSXLATITEM B WHERE B.EFFDT <= %CurrentDateIn AND A.FIELDNAME = B.FIELDNAME)

  • Related Language Record: LM_PRG_STTS_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LM_PRG_STTS Character(4) VARCHAR2(4) NOT NULL Program Reg Status
    CANC=Dropped
    COMP=Completed
    DECL=Decline
    ENRL=Registered
    EXPR=Expired
    INCO=Not Completed
    INPO=In-Progress
    PEAP=Pending Approval
    PEPA=Pending Payment
    PLAN=Planned
    PPYA=Payment Approval
    REIS=Reissue
    REVK=Revoked
    WAIV=Waived
    WARN=Warning
    2 LM_PRG_STTS_LNGNM Character(30) VARCHAR2(30) NOT NULL Program Status