SAD_TAC_CD_VIC

(SQL Table)
Index Back

Victorian TAC Table

The Victorian Tertiary Admission Centre Suspense Table is used as a temporary holding table for all additional VTAC information for an applicant.

  • Parent record: PERSON
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 DATE_LOADED Date(10) DATE Date Loaded
    3 SAD_TAC_VIC_CAT Character(3) VARCHAR2(3) NOT NULL TAC Victoria Category
    4 SAD_TAC_VIC_EX_IND Character(1) VARCHAR2(1) NOT NULL TAC Victoria Exempt. Indicator
    5 SAD_TAC_VIC_SP_IND Character(1) VARCHAR2(1) NOT NULL TAC Victoria Supp. indicator
    6 SAD_TAC_VIC_UN_IND Character(1) VARCHAR2(1) NOT NULL TAC Victoria Unit Indicator
    7 SAD_TAC_VIC_YEAR12 Character(3) VARCHAR2(3) NOT NULL TAC Victoria Year12 Indicator
    8 SAD_TAC_VIC_STAT Character(3) VARCHAR2(3) NOT NULL TAC Victoria Stat.
    9 SAD_TAC_VIC_ST_TYP Character(1) VARCHAR2(1) NOT NULL TAC Victoria Stat. Type
    10 SAD_TAC_HEAR_PROB Character(1) VARCHAR2(1) NOT NULL TAC Hearing Problem
    11 SAD_TAC_LEARN_PROB Character(1) VARCHAR2(1) NOT NULL TAC Learning Prob.
    12 SAD_TAC_MED_PROB Character(1) VARCHAR2(1) NOT NULL TAC Medical Problem
    13 SAD_TAC_MOBIL_PROB Character(1) VARCHAR2(1) NOT NULL TAC Mobility Problem
    14 SAD_TAC_VISN_PROB Character(1) VARCHAR2(1) NOT NULL TAC Vision Problem
    15 SAD_TAC_INTEL_PROB Character(1) VARCHAR2(1) NOT NULL TAC Intellectual Problem
    16 SAD_TAC_MENTL_PROB Character(1) VARCHAR2(1) NOT NULL TAC Mental Problem
    17 SAD_TAC_BRAIN_PROB Character(1) VARCHAR2(1) NOT NULL TAC Brain Problem
    18 SAD_TAC_NEURO_PROB Character(1) VARCHAR2(1) NOT NULL TAC Neurological Problem
    19 SAD_TAC_OTHER_PROB Character(1) VARCHAR2(1) NOT NULL TAC Other Problem
    20 SAD_TAC_DISABL_ADV Character(1) VARCHAR2(1) NOT NULL TAC Disability Advice Required Indicator
    21 SAD_TAC_ENTER Number(6,2) DECIMAL(5,2) NOT NULL TAC Enter
    22 SAD_TAC_ENTER_TYPE Character(1) VARCHAR2(1) NOT NULL TAC Enter Type
    23 SAD_TAC_UMAT_ISAT Character(1) VARCHAR2(1) NOT NULL UCAT/ISAT Type
    24 SAD_TAC_UMAT_IDENT Character(16) VARCHAR2(16) NOT NULL TAC UMAT Identification
    25 SAD_TAC_SEAS_APPL Character(1) VARCHAR2(1) NOT NULL TAC related field
    26 SAD_TAC_ASSESS1 Character(3) VARCHAR2(3) NOT NULL TAC ASSESS1
    27 SAD_TAC_ASSESS2 Character(3) VARCHAR2(3) NOT NULL TAC Assess 2
    28 SAD_TAC_ASSESS3 Character(3) VARCHAR2(3) NOT NULL TAC Assess 3
    29 SAD_TAC_ASSESS4 Character(3) VARCHAR2(3) NOT NULL TAC Assess 4
    30 SAD_TAC_ASSESS5 Character(3) VARCHAR2(3) NOT NULL VTAC Assessment 5
    31 SAD_TAC_MINOR1 Character(3) VARCHAR2(3) NOT NULL TAC MINOR1
    32 SAD_TAC_MINOR2 Character(3) VARCHAR2(3) NOT NULL TAC MINOR2
    33 SAD_TAC_MINOR3 Character(3) VARCHAR2(3) NOT NULL TAC MINOR3
    34 SAD_TAC_MINOR4 Character(3) VARCHAR2(3) NOT NULL TAC MINOR4
    35 SAD_TAC_MINOR5 Character(3) VARCHAR2(3) NOT NULL TAC MINOR5
    36 SAD_TAC_AUS_EQUIVL Character(2) VARCHAR2(2) NOT NULL TAC Australian Equivalent
    37 SAD_TAC_ATAR_CALC Character(5) VARCHAR2(5) NOT NULL ATAR Calculating Authority
    38 SAD_TAC_VTAC_NBR Character(1) VARCHAR2(1) NOT NULL TAC VTAC No.
    39 SAD_TAC_YR_APPL Character(8) VARCHAR2(8) NOT NULL Year of application
    40 SAD_TAC_AGR_SCO Number(6,2) DECIMAL(5,2) NOT NULL Aggregate Score
    41 SAD_TAC_ASGS_RAT Character(1) VARCHAR2(1) NOT NULL ASGS Rating
    42 SAD_TAC_CEN_DIS Character(7) VARCHAR2(7) NOT NULL Census District
    43 SAD_TAC_SEIFA_CCD Number(3,0) SMALLINT NOT NULL SEIFA % for CCD
    44 SAD_TAC_SEIFA_PC Number(2,0) SMALLINT NOT NULL SEIFA % for PC
    45 SAD_TAC_FEE_ELIG Character(1) VARCHAR2(1) NOT NULL Fee eligibility for Type 4
    46 SAD_TAC_SCH_APPLN Character(1) VARCHAR2(1) NOT NULL VTAC Scholarship Application
    47 SAD_INST_DATA_OFFR Character(5) VARCHAR2(5) NOT NULL Institution Data Current Offer
    48 SAD_CRSE_DAT_OFFR1 Character(5) VARCHAR2(5) NOT NULL Course Data 1 Current Offer
    49 SAD_CRSE_DAT_OFFR2 Character(5) VARCHAR2(5) NOT NULL Course Data 2 Current Offer
    50 SAD_TAC_OFFER_RANK Character(5) VARCHAR2(5) NOT NULL Offer Rank
    51 SAD_TAC_VIC_RANK Character(5) VARCHAR2(5) NOT NULL VTAC 2019: Selection Rank
    52 SAD_TAC_BASIS_ADM Character(2) VARCHAR2(2) NOT NULL Basis for Admission Current Offer