PROGRSNSFVWLNG

(SQL View)
 Index Back

Acad Program Action Reason Tbl

PROGRSNSFVWLNG is the related language recordfor the record PROG_RSN_SF_VW

SELECT b.institution , a.prog_action , a.prog_reason ,e.language_cd , e.descr FROM ps_prog_rsn_tbl a ,ps_PROG_RSN_LNG e , PS_INSTITUTION_TBL b , ps_set_cntrl_rec c WHERE e.SETID =a.SETID AND e.PROG_ACTION=a.PROG_ACTION AND e.PROG_REASON=a.PROG_REASON AND e.effdt=a.effdt AND c.setcntrlvalue = b.institution AND c.recname = 'PROG_RSN_TBL' AND c.setid = a.setid AND a.effdt = ( SELECT MAX(d.effdt) FROM ps_prog_rsn_tbl d WHERE d.setid = a.setid AND d.prog_action = a.prog_action AND d.prog_reason = a.prog_reason AND d.effdt <= %CurrentDateIn AND d.eff_status = 'A')

  • Related Language Record for PROG_RSN_SF_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
    2 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
    3 PROG_REASON Character(4) VARCHAR2(4) NOT NULL Action Reason
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description