QCK_ADM_PROG_HS

(SQL Table)
 Index Back

Quick Admit Default values

This table is used in the Quick Admit Process, it is used to assign default values (including program) to the Applicantion and Prospect records.

  • Parent record: PRCSRUNCNTL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
    3 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Prompt Table: INSTITUTN_SCRTY

    4 ACAD_CAREER Character(4) VARCHAR2(4) NOT NULL Academic Career
    BAC=Bachelor (NLD)
    BBL=Vocational Coaching (NLD)
    BOL=Vocational Training (NLD)
    BUSN=Graduate Business
    CNED=Continuing Education
    CRED=Semester Credit
    EDU=Education (NLD)
    EXED=Extended Education
    GRAD=Graduate
    LAW=Law
    MEDS=Medical School
    NONA=Non Award
    PGRD=Postgraduate
    RSCH=Research
    TECH=Technical
    UENG=Undergraduate Engineering
    UGRD=Undergraduate
    VAVO=Advanced General Educ. (NLD)
    VETM=Veterinary Medicine

    Prompt Table: ACAD_CAR_SCRTY

    5 ACAD_PROG Character(5) VARCHAR2(5) NOT NULL Academic Program

    Prompt Table: ACAD_PROG_SCTY

    6 ACADEMIC_LEVEL Character(3) VARCHAR2(3) NOT NULL Academic Level
    00=Not Set
    01=First Year
    02=Second Year
    03=Third Year
    04=Fourth Year
    05=Fifth Year
    06=Sixth Year
    10=Freshman
    20=Sophomore
    30=Junior
    40=Senior
    50=Post-Bacc Undergraduate
    GR=Graduate
    GRA=Graduate AUS
    HON=Honours
    IE=Industrial Experience
    MAS=Masters
    P1=Professional Year 1
    P2=Professional Year 2
    P3=Professional Year 3
    P4=Professional Year 4
    PHD=PhD
    7 ADMIT_TYPE Character(3) VARCHAR2(3) NOT NULL Admit Type

    Prompt Table: ADMIT_TYPE_TBL

    8 ADM_APPL_CTR Character(4) VARCHAR2(4) NOT NULL Application Center

    Prompt Table: ADM_APPLCTR_SVW

    9 ACAD_LOAD_APPR Character(1) VARCHAR2(1) NOT NULL Approved Academic Load
    B=Vocational Coaching (NLD)
    D=Dual (NLD)
    E=Part-time Vocational Tr (NLD)
    F=Full-Time
    O=Vocational Training (NLD)
    P=Part-Time
    10 ADM_APPL_METHOD Character(3) VARCHAR2(3) NOT NULL Application Method
    DSK=Diskette
    EDI=EDI
    HRD=Hard Copy
    OUA=Ontario University Application
    SRV=Application Service
    WWW=Web Application
    11 RECRUITING_STATUS Character(4) VARCHAR2(4) NOT NULL Recruiting Status
    APPL=Applicant
    INAC=Inactive
    INQR=Inquiry
    PAPL=Pre-Applicant
    PROS=Prospect
    SUSP=Suspect

    Default Value: INSTALLATION_AD.RECRUITING_STATUS

    12 ADM_RECR_CTR Character(4) VARCHAR2(4) NOT NULL Recruiting Center

    Prompt Table: ADM_RECRCTR_SVW

    13 ADM_REFRL_SRCE Character(4) VARCHAR2(4) NOT NULL Referral Source

    Default Value: INSTALLATION_AD.ADM_REFRL_SRCE

    Prompt Table: REFERL_SRCE_TBL

    14 ADM_COPY_PB Character(1) VARCHAR2(1) NOT NULL Copy History Values to New