QCK_ADM_PROG

(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: SAD_APP_PRG_VW

    6 CREATE_HISTORY Character(1) VARCHAR2(1) NOT NULL Create History

    Y/N Table Edit

    Default Value: N

    7 CREATE_NEW Character(1) VARCHAR2(1) NOT NULL Create New Records

    Y/N Table Edit

    Default Value: N

    8 CREATE_APPL Character(1) VARCHAR2(1) NOT NULL Create Application
    A=Inst, Career, Prog, Admit Term
    C=Institution, Career
    P=Institution, Career, Program

    Y/N Table Edit

    Default Value: N

    9 CREATE_PRSPCT Character(1) VARCHAR2(1) NOT NULL Create Prospect if no Match

    Y/N Table Edit

    Default Value: N

    10 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
    11 ADMIT_TERM Character(4) VARCHAR2(4) NOT NULL Admit Term

    Prompt Table: TERM_TBL

    12 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

    Prompt Table: ADM_ACTION_SCTY

    13 PROG_STATUS Character(4) VARCHAR2(4) NOT NULL Academic Program Status
    AC=Active in Program
    AD=Admitted
    AP=Applicant
    CM=Completed Program
    CN=Cancelled
    DC=Discontinued
    DE=Deceased
    DM=Dismissed
    LA=Leave of Absence
    PM=Prematriculant
    SP=Suspended
    WT=Waitlisted
    14 PROG_REASON Character(4) VARCHAR2(4) NOT NULL Action Reason

    Prompt Table: PROG_RSN_TBL

    15 ADMIT_TYPE Character(3) VARCHAR2(3) NOT NULL Admit Type

    Prompt Table: ADMIT_TYPE_TBL

    16 CREATE_DELETE Character(1) VARCHAR2(1) NOT NULL Create / Delete
    C=Create Applicant / Prospect
    D=Delete from Holding Table

    Default Value: C

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

    Prompt Table: ADM_APPLCTR_SVW

    18 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
    19 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
    20 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

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

    Prompt Table: ADM_RECRCTR_SVW

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

    Default Value: INSTALLATION_AD.ADM_REFRL_SRCE

    Prompt Table: REFERL_SRCE_TBL