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