SAA_PROG_ST_LNV

(SQL View)
 Index Back

Xlat View Program Status

This view is a modified view of the valid program statuses in the translate table minus the admissions-centric statuses, which are not valid in academic advisement.

SELECT A.FIELDVALUE , A.EFFDT , L.LANGUAGE_CD , L.XLATLONGNAME , L.XLATSHORTNAME FROM PSXLATITEM A ,PSXLATITEMLANG L WHERE A.FIELDNAME = 'PROG_STATUS' AND A.FIELDVALUE <> 'AP' AND A.FIELDVALUE <> 'PM' AND A.FIELDNAME = L.FIELDNAME AND A.FIELDVALUE = L.FIELDVALUE AND A.EFFDT = L.EFFDT

  • Related Language Record for SAA_PROG_ST_VW

    • # 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