LM_PRG_STTS_LVW

(SQL View)
 Index Back

Reason Code Mapping

Reason Code Mapping

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

  • Related Language Record for LM_PRG_STTS_VW

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 LM_PRG_STTS_LNGNM Character(30) VARCHAR2(30) NOT NULL Program Status