ADM_WEB_PR2_TBL

(SQL Table)
 Index Back

Web Prospect Setup Table 2

This table holds the Institutions to be used by Web Prospect Create.

  • Parent Record Of ADM_WEB_PR3_TBL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Prompt Table: INSTITUTION_VW1

    2 RECRUITING_STATUS Character(4) VARCHAR2(4) NOT NULL Recruiting Status
    APPL=Applicant
    INAC=Inactive
    INQR=Inquiry
    PAPL=Pre-Applicant
    PROS=Prospect
    SUSP=Suspect
    3 ADM_REFRL_SRCE Character(4) VARCHAR2(4) NOT NULL Referral Source

    Prompt Table: REFERL_SRCE_TBL