XLPROGSTATUSLNG

(SQL View)
Index Back

Rel LnXlat View Program Status

XLPROGSTATUSLNG is the language record view related to XL_PROG_STATUS

SELECT FIELDVALUE , EFFDT , LANGUAGE_CD , XLATLONGNAME , XLATSHORTNAME FROM PSXLATITEMLANG WHERE FIELDNAME = 'PROG_STATUS'

  • Related Language Record for XL_PROG_STATUS
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PROG_STATUS Character(4) VARCHAR2(4) NOT NULL Academic Program Status
    AC=Active in Program
    AD=Admitted
    AP=Applicant
    CM=Completed Program
    CN=Cancelled
    DC=Discontinued
    DE=Deceased
    DM=Dismissed
    LA=Leave of Absence
    PM=Prematriculant
    SP=Suspended
    WT=Waitlisted
    2 EFFDT Date(10) DATE Effective Date
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description