SAA_PROG_ST_VW

(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 FIELDVALUE , EFFDT , EFF_STATUS , XLATLONGNAME , XLATSHORTNAME FROM PSXLATITEM WHERE FIELDNAME = 'PROG_STATUS' AND FIELDVALUE <> 'AD' AND FIELDVALUE <> 'AP' AND FIELDVALUE <> 'PM' AND FIELDVALUE <> 'WT'

  • Related Language Record: SAA_PROG_ST_LNV

    • # 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 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description