ADM_OUAC_PARMS

(SQL Table)
 Index Back

ADM OUAC Parameters

SACE98-A NEW -AD01 - This table is used to Store parameters required for OUAC Processing SACE98-D MOD - Changed prompt for Law Admit Term to use Term_Yr_Vw

  • Parent Record Of OUAC_PRM_TRNSCP

    • # 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 FILE_INPUT Character(254) VARCHAR2(254) NOT NULL Test Score File Name and Path
    4 OUTPUTDEST Character(127) VARCHAR2(127) NOT NULL Output Destination
    5 OLSAS_ADMIT_TYPE Character(3) VARCHAR2(3) NOT NULL Admit Type for Law Applicants

    Prompt Table: ADMIT_TYPE_TBL

    6 PTIM_ADMIT_TYPE Character(3) VARCHAR2(3) NOT NULL Admit Type for PTIM Applicants

    Prompt Table: ADMIT_TYPE_TBL

    7 TEAS_ADMIT_TYPE Character(3) VARCHAR2(3) NOT NULL Admit Type for TEAS Applicants

    Prompt Table: ADMIT_TYPE_TBL

    8 UAS_ADMIT_TYPE Character(3) VARCHAR2(3) NOT NULL Admit Type for UAS Applicants

    Prompt Table: ADMIT_TYPE_TBL

    9 OLSAS_APPL_CTR Character(4) VARCHAR2(4) NOT NULL Application Center for Law

    Prompt Table: ADM_APPLCTR_TBL

    10 PTIM_APPL_CTR Character(4) VARCHAR2(4) NOT NULL Application Center for PTIM

    Prompt Table: ADM_APPLCTR_TBL

    11 TEAS_APPL_CTR Character(4) VARCHAR2(4) NOT NULL Application Center for TEAS

    Prompt Table: ADM_APPLCTR_TBL

    12 UAS_APPL_CTR Character(4) VARCHAR2(4) NOT NULL Application Center for UAS

    Prompt Table: ADM_APPLCTR_TBL

    13 OLSAS_ACAD_CAREER Character(4) VARCHAR2(4) NOT NULL Law Academic Career

    Prompt Table: ACAD_CAR_TBL

    14 PTIM_ACAD_CAREER Character(4) VARCHAR2(4) NOT NULL Parttime Academic Career

    Prompt Table: ACAD_CAR_TBL

    15 TEAS_ACAD_CAREER Character(4) VARCHAR2(4) NOT NULL Teacher's Academic Career

    Prompt Table: ACAD_CAR_TBL

    16 UAS_ACAD_CAREER Character(4) VARCHAR2(4) NOT NULL UAS Academic Career

    Prompt Table: ACAD_CAR_TBL

    17 OLSAS_CAMPUS Character(5) VARCHAR2(5) NOT NULL Law Campus

    Prompt Table: CAMPUS_TBL

    18 PTIM_CAMPUS Character(5) VARCHAR2(5) NOT NULL Parttime Campus

    Prompt Table: CAMPUS_TBL

    19 TEAS_CAMPUS Character(5) VARCHAR2(5) NOT NULL Teacher's Campus

    Prompt Table: CAMPUS_TBL

    20 UAS_CAMPUS Character(5) VARCHAR2(5) NOT NULL UAS Campus

    Prompt Table: CAMPUS_TBL

    21 NOTIFICATION_PLAN Character(4) VARCHAR2(4) NOT NULL Notification Plan
    ERLY=Early Admission Decision
    REG=Regular Admission Decision
    ROLL=Rolling Admission
    22 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
    23 APPL_FEE_TYPE Character(3) VARCHAR2(3) NOT NULL Application Fee Type
    INT=International
    STN=Standard
    24 OLSAS_ADMIT_TERM Character(4) VARCHAR2(4) NOT NULL Default Admit Term

    Prompt Table: TERM_VAL_TBL

    25 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
    26 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
    27 DEGREE_DT Date(10) DATE Admissions degree date.
    28 CRSE_GRADE_INPUT Character(3) VARCHAR2(3) NOT NULL Grade Input
    A=A
    29 BC_PROV_SCHL_STAT Character(1) VARCHAR2(1) NOT NULL School % Prov. Crse Trans Stat
    F=Final
    I=Incomplete
    M=Mid-Year Report
    W=Work in Progress
    30 BC_PROV_EXAM_STAT Character(1) VARCHAR2(1) NOT NULL Prov. Exam % Trans Stat
    F=Final
    I=Incomplete
    M=Mid-Year Report
    W=Work in Progress
    31 BC_PROV_BLND_STAT Character(1) VARCHAR2(1) NOT NULL Prov. Blended % Trans Stat
    F=Final
    I=Incomplete
    M=Mid-Year Report
    W=Work in Progress
    32 BC_PROV_INT_STAT Character(1) VARCHAR2(1) NOT NULL Prov. Interim % Trans Stat
    F=Final
    I=Incomplete
    M=Mid-Year Report
    W=Work in Progress
    33 BC_HONOURS_CAT Character(4) VARCHAR2(4) NOT NULL BC Honours Category
    CL=Cum Laude
    MCL=Magna Cum Laude
    NONE=None
    SCL=Summa Cum Laude