SAD_TAC_CD

(SQL Table)
 Index Back

TAC Student Profile

  • Parent Record Of SAD_TAC_CD_CAT SAD_TAC_CD_FACT SAD_TAC_CD_PRF SAD_TAC_CD_QUAL SAD_TAC_CD_RSL SAD_TAC_CD_SUB

    • # 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 CAUSE_CREATION Character(1) VARCHAR2(1) NOT NULL Personal Data Impacts
    N=No Personal Data Impact
    U=Caused Personal Data Update
    Y=Caused Personal Data Creation

    Default Value: N

    4 SAD_TAC_APP_FILING Character(15) VARCHAR2(15) NOT NULL TAC App Filing Number
    5 EXT_ADM_APPL_NBR Character(15) VARCHAR2(15) NOT NULL External Application Nbr
    6 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
    7 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
    8 MIDDLE_NAME Character(30) VARCHAR2(30) NOT NULL MIDDLE_NAME
    9 SAD_TAC_LAST_NAME Character(40) VARCHAR2(40) NOT NULL Last Name
    10 SAD_TAC_FIRST_NAME Character(40) VARCHAR2(40) NOT NULL First Name
    11 SAD_TAC_MIDDL_NAME Character(40) VARCHAR2(40) NOT NULL Middle Name
    12 SAD_TAC_OTR_NAME Character(40) VARCHAR2(40) NOT NULL Other Name
    13 SAD_TAC_OTR_NAME2 Character(40) VARCHAR2(40) NOT NULL TAC Other Name 2
    14 SAD_TAC_PREV_FIRST Character(40) VARCHAR2(40) NOT NULL TAC Previous First Name
    15 SAD_TAC_PREV_SEC Character(40) VARCHAR2(40) NOT NULL TAC Previous Second Name
    16 SEX Character(1) VARCHAR2(1) NOT NULL Gender
    F=Female
    M=Male
    U=Unknown
    X=Indeterminate/Intersex/Unspec
    17 NAME_PREFIX Character(4) VARCHAR2(4) NOT NULL Name Prefix
    18 BIRTHDATE Date(10) DATE Date of Birth
    19 SAD_TAC_STD_ADDR Character(1) VARCHAR2(1) NOT NULL Standard Address Format

    Default Value: N

    20 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
    21 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
    22 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
    23 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
    24 CITY Character(30) VARCHAR2(30) NOT NULL City
    25 STATE Character(6) VARCHAR2(6) NOT NULL State
    26 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
    27 SAD_TAC_COUNTRY4 Character(4) VARCHAR2(4) NOT NULL SACC Country Code (4-char)

    Prompt Table: COUNTRY_TBL

    28 SAD_TAC_OVRS_ZIP Character(12) VARCHAR2(12) NOT NULL TAC Overseas Zip
    29 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
    30 SAD_TAC_CURR_ADDR1 Character(55) VARCHAR2(55) NOT NULL TAC Current Address 1
    31 SAD_TAC_CURR_ADDR2 Character(55) VARCHAR2(55) NOT NULL TAC Current Address 2
    32 SAD_TAC_CURR_ADDR3 Character(55) VARCHAR2(55) NOT NULL TAC Current Address 3
    33 SAD_TAC_CURR_ADDR4 Character(55) VARCHAR2(55) NOT NULL TAC Current Address 4
    34 SAD_TAC_CURR_CITY Character(35) VARCHAR2(35) NOT NULL TAC Current City
    35 SAD_TAC_CURR_STATE Character(6) VARCHAR2(6) NOT NULL TAC Current State
    36 SAD_TAC_CURR_CNTRY Character(3) VARCHAR2(3) NOT NULL TAC Current Country
    37 SAD_TAC_CURR_ZIP Character(12) VARCHAR2(12) NOT NULL TAC Current Postal Code
    38 SAD_TAC_RES_ADDR1 Character(55) VARCHAR2(55) NOT NULL TAC Residence Address 1
    39 SAD_TAC_RES_ADDR2 Character(55) VARCHAR2(55) NOT NULL TAC Residence Address 2
    40 SAD_TAC_RES_ADDR3 Character(55) VARCHAR2(55) NOT NULL TAC Residence Address 3
    41 SAD_TAC_RES_ADDR4 Character(55) VARCHAR2(55) NOT NULL TAC Residence Address 4
    42 SAD_TAC_RES_CITY Character(30) VARCHAR2(30) NOT NULL TAC Residence City
    43 SAD_TAC_RES_STATE Character(6) VARCHAR2(6) NOT NULL TAC Residence State
    44 SAD_TAC_RES_CNTRY Character(3) VARCHAR2(3) NOT NULL TAC Residence Country
    45 SAD_TAC_RES_ZIP Character(12) VARCHAR2(12) NOT NULL TAC Residence Postal
    46 SAD_TAC_CIT_CNTRY Character(3) VARCHAR2(3) NOT NULL TAC Citizen Country
    47 SAD_TAC_CONSULATE Character(50) VARCHAR2(50) NOT NULL TAC Consulate
    48 SAD_TAC_DAY_AR_CD Character(11) VARCHAR2(11) NOT NULL TAC Day Area Code
    49 PHONE_DAY Character(30) VARCHAR2(30) NOT NULL Daytime Telephone
    50 PHONE_CNTRY_CD Character(3) VARCHAR2(3) NOT NULL Phone country code
    51 SAD_TAC_OTR_AR_CD Character(12) VARCHAR2(12) NOT NULL TAC Other Area Code
    52 SAD_TAC_OTR_PHONE Character(16) VARCHAR2(16) NOT NULL Business Phone Number
    53 SAD_TAC_MOBILE_PHN Character(24) VARCHAR2(24) NOT NULL TAC Mobile Phone
    54 SAD_TAC_FAX_NBR Character(24) VARCHAR2(24) NOT NULL TAC Fax Number
    55 EMAIL_ADDR Character(70) VARCHAR2(70) NOT NULL Email Address
    56 SAD_TAC_EMAIL_VERF Character(1) VARCHAR2(1) NOT NULL Email Verified

    Y/N Table Edit

    57 SAD_TAC_PSPT_LAST Character(30) VARCHAR2(30) NOT NULL TAC Passport Last Name
    58 SAD_TAC_PSPT_FIRST Character(30) VARCHAR2(30) NOT NULL TAC Passport First Name
    59 SAD_TAC_PSPT_MID Character(30) VARCHAR2(30) NOT NULL TAC Passport Middle Name
    60 BIRTHPLACE Character(30) VARCHAR2(30) NOT NULL Birth Location
    61 PASSPORT_NBR Character(15) VARCHAR2(15) NOT NULL Passport Number
    62 SAD_TAC_PSPT_CNTRY Character(36) VARCHAR2(36) NOT NULL Country of Passport
    63 COUNTRY_PASSPORT Character(3) VARCHAR2(3) NOT NULL Country Issuing Passport
    64 DT_ISSUED Date(10) DATE Issue Date
    65 EXPIRATN_DT Date(10) DATE Expiration Date
    66 CITY_PASSPORT Character(30) VARCHAR2(30) NOT NULL City
    67 SAD_TAC_PSPT_VERIF Character(1) VARCHAR2(1) NOT NULL Passport Verified

    Y/N Table Edit

    68 SAD_TAC_AGT_DTLS Character(100) VARCHAR2(100) NOT NULL Agent Details
    69 SAD_TAC_AGT_CODE Character(20) VARCHAR2(20) NOT NULL Agent Code
    70 SAD_TAC_AGT_DTTM DateTime(26) TIMESTAMP Agent Information Timestamp
    71 ADMIT_TYPE Character(3) VARCHAR2(3) NOT NULL Admit Type
    72 SCHOOL_CODE Character(10) VARCHAR2(10) NOT NULL School Code
    73 ADM_APPL_DT Date(10) DATE Application Date
    74 SAD_TAC_TER_SCORE Number(8,3) DECIMAL(7,3) NOT NULL TAC Score
    75 OFFER_DT Date(10) DATE Offer Date
    76 SAD_TAC_OFFR_ROUND Number(5,0) INTEGER NOT NULL TAC offer Round Number
    77 SAD_TAC_COURSE_CD Character(10) VARCHAR2(10) NOT NULL TAC Course Code
    78 SAD_TAC_OFFER_PREF Character(2) VARCHAR2(2) NOT NULL TAC Offer Preference Number
    79 SAD_TAC_OFF_CS_RNK Character(60) VARCHAR2(60) NOT NULL TAC Offer Course Rank
    80 SAD_TAC_OFF_CRS_SD Character(20) VARCHAR2(20) NOT NULL TAC Offer Course Schedule
    81 SAD_SELECTION_RANK Character(5) VARCHAR2(5) NOT NULL HEIMS E605 Selection Rank
    82 SAD_HIGHST_CRS_LAB Character(30) VARCHAR2(30) NOT NULL Highest CRS Label
    83 SAD_HIGHST_CRS_VAL Character(60) VARCHAR2(60) NOT NULL Highest CRS Value
    84 BASIS_ADMIT_CODE Character(5) VARCHAR2(5) NOT NULL Basis of Admission Code
    85 SAD_TAC_BASE_RANK Character(30) VARCHAR2(30) NOT NULL TAC Base Rank Set
    86 SAD_TAC_BASE_SCHED Character(20) VARCHAR2(20) NOT NULL TAC Base Schedule
    87 SAD_TAC_PERM_RES Character(6) VARCHAR2(6) NOT NULL TAC Permanent Residency
    88 SAD_TAC_APPL_CIT Character(4) VARCHAR2(4) NOT NULL TAC Citzen
    89 RESIDENCY Character(5) VARCHAR2(5) NOT NULL Residency
    90 SAD_TAC_BIRTH_CNTY Character(6) VARCHAR2(6) NOT NULL TAC Birth Country
    91 SAD_TAC_APPL_OAS Character(3) VARCHAR2(3) NOT NULL Overall Allocatability Status
    92 SAD_TAC_OAS_CMMT Character(120) VARCHAR2(120) NOT NULL TAC OAS Comment
    93 SAD_TAC_ADMIT_STAT Character(3) VARCHAR2(3) NOT NULL TAC Admit Status Type
    94 SAD_TAC_APPL_CHK Character(1) VARCHAR2(1) NOT NULL TAC Application Check
    95 ABORIGINAL Character(1) VARCHAR2(1) NOT NULL Aboriginal
    96 SAD_TAC_PRM_HM_RES Character(4) VARCHAR2(4) NOT NULL TAC Permanent Home Residency
    97 SAD_TAC_APP_PM_RES Character(1) VARCHAR2(1) NOT NULL TAC Applicant Permanent Residency
    98 SAD_TAC_PRM_RES_DT Date(10) DATE TAC Permanent Residency Date
    99 SAD_TAC_LNG_HM_IND Character(1) VARCHAR2(1) NOT NULL TAC Language Home Inidcator
    100 SAD_TAC_LNG_CD_HM Character(4) VARCHAR2(4) NOT NULL TAC Language Code Home
    101 SAD_TAC_METHOD_A Character(3) VARCHAR2(3) NOT NULL TAC Method A
    102 SAD_TAC_METHOD_B Character(3) VARCHAR2(3) NOT NULL TAC Method B
    103 SAD_TAC_APP_DEC Character(2) VARCHAR2(2) NOT NULL TAC Applicant Decision
    104 SAD_TAC_ENROLL_IND Character(1) VARCHAR2(1) NOT NULL TAC Enroll Indicator
    105 SAD_TAC_ACCEPT_IND Character(4) VARCHAR2(4) NOT NULL TAC Acceptance Indicator
    106 SAD_TAC_TORRES_STR Character(1) VARCHAR2(1) NOT NULL Torres Strait Islander
    107 SAD_TAC_APPL_BORN Character(1) VARCHAR2(1) NOT NULL TAC Appl Born
    108 SSR_YEAR_ARRIVAL Character(4) VARCHAR2(4) NOT NULL DEST Year Arrival Code
    109 SAD_TAC_ENROLL_PRF Character(1) VARCHAR2(1) NOT NULL TAC Enroll Preference Number
    110 SAD_TAC_FLD_POSN_A Character(2) VARCHAR2(2) NOT NULL TAC Field Position A
    111 SAD_TAC_FLD_POSN_B Character(2) VARCHAR2(2) NOT NULL TAC Field Position B
    112 SAD_TAC_FLD_POSN_C Character(2) VARCHAR2(2) NOT NULL TAC Field Position C
    113 SAD_TAC_FLD_POSN_D Character(2) VARCHAR2(2) NOT NULL TAC Field Position D
    114 SAD_TAC_FLD_POSN_E Character(2) VARCHAR2(2) NOT NULL TAC Field Position E
    115 SAD_TAC_OP_SCORE Character(2) VARCHAR2(2) NOT NULL TAC Score
    116 SAD_TAC_ATAR_CALC Character(5) VARCHAR2(5) NOT NULL ATAR Calculating Authority
    117 SAD_TAC_PROGRAM_CD Character(10) VARCHAR2(10) NOT NULL Program Code
    118 SAD_TAC_STREAM_CD Character(10) VARCHAR2(10) NOT NULL TAC Stream Code for SATAC
    119 SCC_USI Character(10) VARCHAR2(10) NOT NULL Unique Student Identifier
    120 SCC_CHESSN Character(10) VARCHAR2(10) NOT NULL Commonwealth Higher Education Student Support Number (CHESSN)
    121 SCC_SLE_USAGE Number(8,5) DECIMAL(7,5) NOT NULL Ordinary Student Learning Entitlement Usage
    122 SCC_FEE_HELP_BAL Number(10,2) DECIMAL(9,2) NOT NULL FEE-HELP Balance
    123 SCC_AT_DATE Date(10) DATE DEST As At Date
    124 SCC_ORD_SLE_BAL Number(8,5) DECIMAL(7,5) NOT NULL Ordinary SLE Balance
    125 SAD_TEST_ID Character(3) VARCHAR2(3) NOT NULL Admissions Test Load Ids
    ACT=ACT Assessment
    ADA=American Dental Association
    AMC=Medical College Admission Test
    AP=Advanced Placement
    CRS=Candidate Referral Service
    DAT=Dental Admission Test
    EOS=Educational Opportunity Srvc
    GMS=GMASS
    GMT=Grad Management Admission Test
    GRE=Graduate Record Exam
    LST=Law School Admission Test
    QTC=Queensland Tertiary Admissions
    SAT=Scholastic Assessment Test
    SSS=Student Search Service
    STC=South Australian Tertiary Adm.
    TFL=Test of Engl as a Foreign Lang
    UAC=UAC
    VTC=Victoria Teritory Acad Center
    126 SAD_TAC_APPL_TYPE Character(3) VARCHAR2(3) NOT NULL Application Type
    127 SAD_TAC_E493 Character(6) VARCHAR2(6) NOT NULL Dest Element
    128 SAD_LEVEL_LEFT_SCH Character(2) VARCHAR2(2) NOT NULL HEIMS E612 Level Left School
    10=Year 10
    11=Year 11
    12=Year 12
    9=Year 9
    99=Highest level unknown
    129 SAD_ETHNICITY_LD Character(2) VARCHAR2(2) NOT NULL Ethnicity
    130 SUBURB_E486_AUS Character(55) VARCHAR2(55) NOT NULL Year 12 Residence Location
    131 SAD_TAC_PCRS_LABEL Character(30) VARCHAR2(30) NOT NULL TAC Label
    132 PHONE_DAY_LONG Character(30) VARCHAR2(30) NOT NULL Phone_Day_Long
    133 SAD_TAC_SCH_POSTCD Character(4) VARCHAR2(4) NOT NULL TAC School Postcode
    134 METHOD_A_OFR_TYP1 Character(3) VARCHAR2(3) NOT NULL TAC Method A offered Type 1 Current GET Round
    135 METHOD_A_OFR_TYP2 Character(3) VARCHAR2(3) NOT NULL TAC Method A offered Type 2 Current GET Round
    136 METHOD_B_OFR_TYP1 Character(3) VARCHAR2(3) NOT NULL TAC Method B offered Type 1 Current GET Round
    137 METHOD_B_OFR_TYP2 Character(3) VARCHAR2(3) NOT NULL TAC Method B offered Type 2 Current GET Round
    138 OFR_TYP1_GET_RND Character(1) VARCHAR2(1) NOT NULL TAC Type of Offer Type 1 Current GET Round
    139 OFR_TYP2_GET_RND Character(1) VARCHAR2(1) NOT NULL TAC Type of Offer Type 2 Current GET Round
    140 COURSE_CD_OFR_TYP2 Character(5) VARCHAR2(5) NOT NULL TAC Course Code Offered Type 2 Current GET Round
    141 SAD_TAC_OFFR_MONTH Character(3) VARCHAR2(3) NOT NULL TAC Offer Period Month.
    142 SAD_TAC_OFFR_YEAR Number(4,0) SMALLINT NOT NULL TAC Offer Period Year
    143 SSR_HIGHST_EDU1 Character(3) VARCHAR2(3) NOT NULL Highest Edu Parent Guardian 1
    144 SSR_HIGHST_EDU2 Character(3) VARCHAR2(3) NOT NULL Highest Edu Parent Guardian 2
    145 SAD_AUS_MIL_SVC Character(1) VARCHAR2(1) NOT NULL Australian Military Service

    Y/N Table Edit

    146 SAD_TAC_PRMADRFRMT Character(1) VARCHAR2(1) NOT NULL Permanant Address Format

    Y/N Table Edit

    147 SAD_TAC_PERM_ADDR1 Character(55) VARCHAR2(55) NOT NULL Address 1
    148 SAD_TAC_PERM_ADDR2 Character(55) VARCHAR2(55) NOT NULL Address 2
    149 SAD_TAC_PERM_ADDR3 Character(55) VARCHAR2(55) NOT NULL Address 3
    150 SAD_TAC_PERM_ADDR4 Character(55) VARCHAR2(55) NOT NULL Address 4
    151 SAD_TAC_PERM_ADDR5 Character(55) VARCHAR2(55) NOT NULL Address 5
    152 SAD_TAC_PERM_CITY Character(35) VARCHAR2(35) NOT NULL TAC Current City
    153 SAD_TAC_PERM_CNTRY Character(3) VARCHAR2(3) NOT NULL TAC Current Country
    154 SAD_TAC_PERM_CTRY4 Character(4) VARCHAR2(4) NOT NULL TAC Current Country (4-char)

    Prompt Table: COUNTRY_TBL

    155 SAD_TAC_PERM_STATE Character(6) VARCHAR2(6) NOT NULL TAC Current State
    156 SAD_TAC_POSTAL_CD Character(12) VARCHAR2(12) NOT NULL Postal Code
    157 SAD_TAC_PERM_ZIP Character(12) VARCHAR2(12) NOT NULL TAC Overseas Zip
    158 SAD_QCE_ELIG Character(1) VARCHAR2(1) NOT NULL QCE Eligilibility
    159 SAD_CENTERLINK_ST Character(1) VARCHAR2(1) NOT NULL Centrelink Status
    160 SAD_WT_EAS_SCORE Character(5) VARCHAR2(5) NOT NULL Weighted EAS Score
    161 SAD_QTC_PERMADRTYP Character(4) VARCHAR2(4) NOT NULL Permanent Address Type

    Prompt Table: ADDRESS_TYP_TBL

    162 SAD_QTC_MOBILE_TYP Character(4) VARCHAR2(4) NOT NULL Mobile Phone Type
    BUSN=Business
    CAMP=Campus
    CELL=Mobile
    DORM=Dormitory
    FAX=FAX
    HOME=Home
    MAIN=Main
    OTR=Other
    PGR1=Pager 1
    PGR2=Pager 2
    TELX=Telex
    WORK=Work
    163 ATSI_STAT_CNF Character(1) VARCHAR2(1) NOT NULL ATSI Status Confirmed
    164 NAME_LOC_IND_CMNTY Character(100) VARCHAR2(100) NOT NULL Name and location of indigenous community
    165 SAD_TAC_PRXY_NAME Character(50) VARCHAR2(50) NOT NULL VTAC 2019: Proxy Name
    166 SAD_TAC_PRXY_REL Character(40) VARCHAR2(40) NOT NULL VTAC 2019: Proxy Relationship
    167 SAD_TAC_PRXY_DOB Date(10) DATE VTAC 2019: Proxy DOB
    168 SAD_TAC_PRXY_PHONE Character(24) VARCHAR2(24) NOT NULL VTAC 2019: Proxy Phone
    169 SAD_TAC_PRXY_EMAIL Character(70) VARCHAR2(70) NOT NULL VTAC 2019: Proxy Email
    170 SAD_TAC_QLD_FOR Long Character(300) VARCHAR2(300) QTAC 2019: Forced Offer Reason