PROG_ACTN_AC_VW

(SQL View)
 Index Back

Program Actions Table

PROG_ACTN_AC_VW is used as a prompt view for the PROG_ACTION field. It provides a list of program actions that have an associated program status of "AC". The values in this view are hard coded because the program status is set programatically and is not stored in table.

SELECT A.PROG_ACTION ,A.DESCR FROM PS_PROG_ACTION_TBL A WHERE A.PROG_ACTION IN ('ACTV','RADM','MATR','REVK','RLOA') AND A.EFF_STATUS = 'A'

  • Related Language Record: PROGACTNACVWLNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PROG_ACTION Character(4) VARCHAR2(4) NOT NULL Program Action
    ACTV=Activate
    ADMT=Admit
    ADRV=Admission Revocation
    APPL=Application
    COMP=Completion of Program
    COND=Conditional Admit
    DATA=Data Change
    DDEF=Defer Decision
    DEFR=Defer Enrollment
    DEIN=Intention to Matriculate
    DENY=Deny
    DISC=Discontinuation
    DISM=Dismissal
    LEAV=Leave of Absence
    MATR=Matriculation
    PLNC=Plan Change
    PRGC=Program Change
    RADM=Readmit
    RAPP=Readmit Application
    RECN=Reconsideration
    REVK=Revoke Degree
    RLOA=Return from Leave of Absence
    SPND=Suspension
    TRAN=Transfer to Other Career
    VDIS=Voluntarily Discontinued
    WADM=Administrative Withdrawal
    WAIT=Waitlist
    WAOF=Waitlist Offer
    WAPP=Applicant Withdrawal
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description