RA_STUSTATUS_VW

(SQL View)
 Index Back

Student Status View

View is used as search prompt for profile field definition.

SELECT A.FIELDVALUE , A.XLATLONGNAME FROM PSXLATITEM A WHERE A.FIELDNAME='STUDENT_STATUS' AND A.EFFDT = ( SELECT MAX(AA.EFFDT) FROM PSXLATITEM AA WHERE A.FIELDNAME = AA.FIELDNAME AND A.FIELDVALUE=AA.FIELDVALUE AND AA.EFFDT <= %CurrentDateIn)

  • Related Language Record: RA_STUSTATS_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 STUDENT_STATUS Character(4) VARCHAR2(4) NOT NULL Program status field to store academic program status value.
    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 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name