SAD_TAC_CD_VIC(SQL Table) |
Index Back |
---|---|
Victorian TAC TableThe 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 | Character(11) | VARCHAR2(11) NOT NULL | Employee ID | |
2 | 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 |