LM_CLS_STTS_VW

(SQL View)
 Index Back

Program Status

Program Status view . Translate Values

SELECT A.FIELDVALUE LM_CLS_STTS , A.XLATLONGNAME FROM PSXLATITEM A WHERE A.FIELDNAME='LM_CLS_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_CLS_STTS_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LM_CLS_STTS Character(4) VARCHAR2(4) NOT NULL Program Reg Status
    APPR=Approve
    CANC=Dropped
    COMP=Completed
    DECL=Decline
    ENRL=Enrolled
    INCO=Not Completed
    INPO=In-Progress
    PEAP=Pending Approval
    PEPA=Pending Payment
    PLAN=Planned
    PPYA=Payment Approval
    WAIV=Waived
    2 LM_ENRL_STTS_LNGNM Character(30) VARCHAR2(30) NOT NULL Class Status