SAD_PROG_RSN_VW

(SQL View)
 Index Back

Acad Program Action Reason Tbl

This is a prompt table for Academic Program Action Reason.

SELECT SETID , PROG_ACTION , PROG_REASON , EFFDT , EFF_STATUS , DESCR , DESCRSHORT FROM PS_PROG_RSN_TBL

  • Related Language Record: SADPROGRSNVWLNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Prompt Table: SETID_TBL

    2 SAD_PRA_W_CBAP_NLD Character(4) VARCHAR2(4) NOT NULL Withdrawal program action

    Prompt Table: ADM_ACTION_SCTY

    3 SAD_RA_W_CBAP_NLD Character(4) VARCHAR2(4) NOT NULL Withdrawal action reason
    ADRV=Admission Revocation
    DENY=Deny
    WADM=Administrative Withdrawal
    WAIT=Waitlist
    WAPP=Applicant Withdrawal

    Prompt Table: PROG_RSN_TBL
    Set Control Field: INSTITUTION

    4 EFFDT Date(10) DATE NOT NULL Effective Date
    5 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    7 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description