LM_CLS_STTS_LVW

(SQL View)
 Index Back

Class Reason Code Mapping

Class Reason Code Mapping

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

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