SAD_TAC_SUS

(SQL Table)
 Index Back

TAC Suspense

  • Parent Record Of SAD_TAC_ERRORS SAD_TAC_SUS_CAT SAD_TAC_SUS_FCT SAD_TAC_SUS_OFF SAD_TAC_SUS_PRF SAD_TAC_SUS_QL SAD_TAC_SUS_RSL SAD_TAC_SUS_SUB SSR_CART_ERRORS

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 TEST_ID Character(11) VARCHAR2(11) NOT NULL Test ID

    Prompt Table: SAD_TAC_SCTY_VW

    2 EXT_ADM_APPL_NBR Character(15) VARCHAR2(15) NOT NULL External Application Nbr
    3 DATE_LOADED Date(10) DATE Date Loaded
    4 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name
    5 FIRST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL First Name
    6 EDIT_PROC_OPTN Character(1) VARCHAR2(1) NOT NULL Processsing Options
    C=Complete
    E=Error
    P=Perform

    Default Value: C

    7 SRCH_PROC_OPTN Character(1) VARCHAR2(1) NOT NULL Search Match processing option
    C=Complete
    E=Error
    P=Perform

    Default Value: P

    8 POST_PROC_OPTN Character(1) VARCHAR2(1) NOT NULL Post Processing Option
    A=Awaiting Search/Match
    D=Delete Existing ID
    E=Error
    N=New ID Add
    P=Purge
    T=Take No Action
    U=Update Existing ID

    Default Value: A

    9 SAD_LAST_NM_SRCH Character(40) VARCHAR2(40) NOT NULL Last Name
    10 SAD_FIRST_NM_SRCH Character(40) VARCHAR2(40) NOT NULL First Name
    11 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PEOPLE_SRCH

    12 SAD_TAC_APP_FILING Character(15) VARCHAR2(15) NOT NULL TAC App Filing Number
    13 SEARCH_ORDER_NBR Number(3,0) SMALLINT NOT NULL This field identifies the Search Order Number where potential duplicate ID(s) is/are encountered by Search/Match when run as part of a batch process.
    14 MATCH_NBR Number(6,0) INTEGER NOT NULL Number of Matches
    15 SAD_TAC_LOAD_BIO Character(1) VARCHAR2(1) NOT NULL OK to Post w/o Course Data

    Y/N Table Edit

    Default Value: N

    16 LAST_NAME_ERROR Character(1) VARCHAR2(1) NOT NULL Last Name Error

    Y/N Table Edit

    Default Value: N

    17 FIRST_NAME_ERROR Character(1) VARCHAR2(1) NOT NULL First Name Error

    Y/N Table Edit

    Default Value: N

    18 BIRTHDATE_ERROR Character(1) VARCHAR2(1) NOT NULL Birthdate Error

    Y/N Table Edit

    Default Value: N

    19 SAD_TAC_PROG_ERROR Character(1) VARCHAR2(1) NOT NULL Academic Program Error

    Y/N Table Edit

    Default Value: N

    20 SAD_TAC_ADMT_ERR Character(1) VARCHAR2(1) NOT NULL Admit Term Error

    Y/N Table Edit

    Default Value: N

    21 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
    22 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
    23 MIDDLE_NAME Character(30) VARCHAR2(30) NOT NULL MIDDLE_NAME
    24 SAD_TAC_LAST_NAME Character(40) VARCHAR2(40) NOT NULL Last Name
    25 SAD_TAC_FIRST_NAME Character(40) VARCHAR2(40) NOT NULL First Name
    26 SAD_TAC_MIDDL_NAME Character(40) VARCHAR2(40) NOT NULL Middle Name
    27 SAD_TAC_OTR_NAME Character(40) VARCHAR2(40) NOT NULL Other Name
    28 SAD_TAC_OTR_NAME2 Character(40) VARCHAR2(40) NOT NULL TAC Other Name 2
    29 SAD_TAC_PREV_FIRST Character(40) VARCHAR2(40) NOT NULL TAC Previous First Name
    30 SAD_TAC_PREV_SEC Character(40) VARCHAR2(40) NOT NULL TAC Previous Second Name
    31 SEX Character(1) VARCHAR2(1) NOT NULL Gender
    F=Female
    M=Male
    U=Unknown
    X=Indeterminate/Intersex/Unspec
    32 NAME_PREFIX Character(4) VARCHAR2(4) NOT NULL Name Prefix

    Prompt Table: NAME_PREFIX_TBL

    33 SAD_BIRTHDATE_LD Character(10) VARCHAR2(10) NOT NULL Admissions Birthdate from Test Load
    34 BIRTHDATE Date(10) DATE Date of Birth
    35 SAD_TAC_STD_ADDR Character(1) VARCHAR2(1) NOT NULL Standard Address Format

    Y/N Table Edit

    Default Value: N

    36 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
    37 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
    38 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
    39 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
    40 CITY Character(30) VARCHAR2(30) NOT NULL City
    41 STATE Character(6) VARCHAR2(6) NOT NULL State

    Prompt Table: STATE_NAMES_TBL

    42 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: COUNTRY_TBL

    43 SAD_TAC_COUNTRY4 Character(4) VARCHAR2(4) NOT NULL SACC Country Code (4-char)

    Prompt Table: COUNTRY_TBL

    44 SAD_TAC_OVRS_ZIP Character(12) VARCHAR2(12) NOT NULL TAC Overseas Zip
    45 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
    46 SAD_TAC_CURR_ADDR1 Character(55) VARCHAR2(55) NOT NULL TAC Current Address 1
    47 SAD_TAC_CURR_ADDR2 Character(55) VARCHAR2(55) NOT NULL TAC Current Address 2
    48 SAD_TAC_CURR_ADDR3 Character(55) VARCHAR2(55) NOT NULL TAC Current Address 3
    49 SAD_TAC_CURR_ADDR4 Character(55) VARCHAR2(55) NOT NULL TAC Current Address 4
    50 SAD_TAC_CURR_CITY Character(35) VARCHAR2(35) NOT NULL TAC Current City
    51 SAD_TAC_CURR_STATE Character(6) VARCHAR2(6) NOT NULL TAC Current State

    Prompt Table: CURR_STATE_TBL

    52 SAD_TAC_CURR_CNTRY Character(3) VARCHAR2(3) NOT NULL TAC Current Country

    Prompt Table: COUNTRY_TBL

    53 SAD_TAC_CURR_ZIP Character(12) VARCHAR2(12) NOT NULL TAC Current Postal Code
    54 SAD_TAC_RES_ADDR1 Character(55) VARCHAR2(55) NOT NULL TAC Residence Address 1
    55 SAD_TAC_RES_ADDR2 Character(55) VARCHAR2(55) NOT NULL TAC Residence Address 2
    56 SAD_TAC_RES_ADDR3 Character(55) VARCHAR2(55) NOT NULL TAC Residence Address 3
    57 SAD_TAC_RES_ADDR4 Character(55) VARCHAR2(55) NOT NULL TAC Residence Address 4
    58 SAD_TAC_RES_CITY Character(30) VARCHAR2(30) NOT NULL TAC Residence City
    59 SAD_TAC_RES_STATE Character(6) VARCHAR2(6) NOT NULL TAC Residence State

    Prompt Table: RES_STATE_TBL

    60 SAD_TAC_RES_CNTRY Character(3) VARCHAR2(3) NOT NULL TAC Residence Country

    Prompt Table: COUNTRY_TBL

    61 SAD_TAC_RES_ZIP Character(12) VARCHAR2(12) NOT NULL TAC Residence Postal
    62 SAD_TAC_CIT_CNTRY Character(3) VARCHAR2(3) NOT NULL TAC Citizen Country

    Prompt Table: COUNTRY_TBL

    63 SAD_TAC_DAY_AR_CD Character(11) VARCHAR2(11) NOT NULL TAC Day Area Code
    64 PHONE_DAY Character(30) VARCHAR2(30) NOT NULL Daytime Telephone
    65 SAD_TAC_OTR_AR_CD Character(12) VARCHAR2(12) NOT NULL TAC Other Area Code
    66 SAD_TAC_OTR_PHONE Character(16) VARCHAR2(16) NOT NULL Business Phone Number
    67 SAD_TAC_MOBILE_PHN Character(24) VARCHAR2(24) NOT NULL TAC Mobile Phone
    68 SAD_TAC_FAX_NBR Character(24) VARCHAR2(24) NOT NULL TAC Fax Number
    69 EMAIL_ADDR Character(70) VARCHAR2(70) NOT NULL Email Address
    70 SAD_TAC_EMAIL_VERF Character(1) VARCHAR2(1) NOT NULL Email Verified

    Y/N Table Edit

    71 SAD_TAC_CONSULATE Character(50) VARCHAR2(50) NOT NULL TAC Consulate
    72 SAD_TAC_PSPT_LAST Character(30) VARCHAR2(30) NOT NULL TAC Passport Last Name
    73 SAD_TAC_PSPT_FIRST Character(30) VARCHAR2(30) NOT NULL TAC Passport First Name
    74 SAD_TAC_PSPT_MID Character(30) VARCHAR2(30) NOT NULL TAC Passport Middle Name
    75 BIRTHPLACE Character(30) VARCHAR2(30) NOT NULL Birth Location
    76 PASSPORT_NBR Character(15) VARCHAR2(15) NOT NULL Passport Number
    77 SAD_TAC_PSPT_CNTRY Character(36) VARCHAR2(36) NOT NULL Country of Passport
    78 COUNTRY_PASSPORT Character(3) VARCHAR2(3) NOT NULL Country Issuing Passport
    79 DT_ISSUED Date(10) DATE Issue Date
    80 EXPIRATN_DT Date(10) DATE Expiration Date
    81 CITY_PASSPORT Character(30) VARCHAR2(30) NOT NULL City
    82 SAD_TAC_PSPT_VERIF Character(1) VARCHAR2(1) NOT NULL Passport Verified

    Y/N Table Edit

    83 SAD_TAC_AGT_DTLS Character(100) VARCHAR2(100) NOT NULL Agent Details
    84 SAD_TAC_AGT_CODE Character(20) VARCHAR2(20) NOT NULL Agent Code
    85 SAD_TAC_AGT_DTTM DateTime(26) TIMESTAMP Agent Information Timestamp
    86 ADMIT_TYPE Character(3) VARCHAR2(3) NOT NULL Admit Type
    87 SCHOOL_CODE Character(10) VARCHAR2(10) NOT NULL School Code
    88 SAD_TAC_ADM_DT_LD Character(10) VARCHAR2(10) NOT NULL SAD_TACADMIT_DT_LD
    89 ADM_APPL_DT Date(10) DATE Application Date
    90 SAD_TAC_TER_SCORE Number(8,3) DECIMAL(7,3) NOT NULL TAC Score
    91 SAD_TAC_OFFR_DT_LD Character(10) VARCHAR2(10) NOT NULL SAD_TACOFFER_DT_LD
    92 OFFER_DT Date(10) DATE Offer Date
    93 SAD_TAC_OFFR_ROUND Number(5,0) INTEGER NOT NULL TAC offer Round Number
    94 SAD_TAC_COURSE_CD Character(10) VARCHAR2(10) NOT NULL TAC Course Code
    95 SAD_TAC_OFFER_PREF Character(2) VARCHAR2(2) NOT NULL TAC Offer Preference Number
    96 SAD_TAC_OFF_CS_RNK Character(60) VARCHAR2(60) NOT NULL TAC Offer Course Rank
    97 SAD_TAC_OFF_CRS_SD Character(20) VARCHAR2(20) NOT NULL TAC Offer Course Schedule
    98 SAD_SELECTION_RANK Character(5) VARCHAR2(5) NOT NULL HEIMS E605 Selection Rank
    99 SAD_HIGHST_CRS_LAB Character(30) VARCHAR2(30) NOT NULL Highest CRS Label
    100 SAD_HIGHST_CRS_VAL Character(60) VARCHAR2(60) NOT NULL Highest CRS Value
    101 BASIS_ADMIT_CODE Character(5) VARCHAR2(5) NOT NULL Basis of Admission Code
    102 SAD_TAC_BASE_RANK Character(30) VARCHAR2(30) NOT NULL TAC Base Rank Set
    103 SAD_TAC_BASE_SCHED Character(20) VARCHAR2(20) NOT NULL TAC Base Schedule
    104 SAD_TAC_PERM_RES Character(6) VARCHAR2(6) NOT NULL TAC Permanent Residency
    105 SAD_TAC_APPL_CIT Character(4) VARCHAR2(4) NOT NULL TAC Citzen
    106 RESIDENCY Character(5) VARCHAR2(5) NOT NULL Residency

    Prompt Table: RESIDENCY_TBL

    107 SAD_TAC_BIRTH_CNTY Character(6) VARCHAR2(6) NOT NULL TAC Birth Country

    Prompt Table: COUNTRY_TBL

    108 SAD_TAC_APPL_OAS Character(3) VARCHAR2(3) NOT NULL Overall Allocatability Status
    109 SAD_TAC_OAS_CMMT Character(120) VARCHAR2(120) NOT NULL TAC OAS Comment
    110 SAD_TAC_ADMIT_STAT Character(3) VARCHAR2(3) NOT NULL TAC Admit Status Type
    111 SAD_TAC_APPL_CHK Character(1) VARCHAR2(1) NOT NULL TAC Application Check
    112 ABORIGINAL Character(1) VARCHAR2(1) NOT NULL Aboriginal
    113 SAD_TAC_PRM_HM_RES Character(4) VARCHAR2(4) NOT NULL TAC Permanent Home Residency
    114 SAD_TAC_APP_PM_RES Character(1) VARCHAR2(1) NOT NULL TAC Applicant Permanent Residency
    115 SAD_TAC_PRM_RES_DT Date(10) DATE TAC Permanent Residency Date
    116 SAD_TAC_LNG_HM_IND Character(1) VARCHAR2(1) NOT NULL TAC Language Home Inidcator
    117 SAD_TAC_LNG_CD_HM Character(4) VARCHAR2(4) NOT NULL TAC Language Code Home
    118 SAD_TAC_METHOD_A Character(3) VARCHAR2(3) NOT NULL TAC Method A
    119 SAD_TAC_METHOD_B Character(3) VARCHAR2(3) NOT NULL TAC Method B
    120 SAD_TAC_APP_DEC Character(2) VARCHAR2(2) NOT NULL TAC Applicant Decision
    121 SAD_TAC_ENROLL_IND Character(1) VARCHAR2(1) NOT NULL TAC Enroll Indicator
    122 SAD_TAC_ACCEPT_IND Character(4) VARCHAR2(4) NOT NULL TAC Acceptance Indicator
    123 SAD_TAC_TORRES_STR Character(1) VARCHAR2(1) NOT NULL Torres Strait Islander
    124 SAD_TAC_APPL_BORN Character(1) VARCHAR2(1) NOT NULL TAC Appl Born
    125 SAD_TAC_YEAR_ARR Character(4) VARCHAR2(4) NOT NULL Year Arrival
    126 SAD_TAC_ENROLL_PRF Character(1) VARCHAR2(1) NOT NULL TAC Enroll Preference Number
    127 SAD_TAC_FLD_POSN_A Character(2) VARCHAR2(2) NOT NULL TAC Field Position A
    128 SAD_TAC_FLD_POSN_B Character(2) VARCHAR2(2) NOT NULL TAC Field Position B
    129 SAD_TAC_FLD_POSN_C Character(2) VARCHAR2(2) NOT NULL TAC Field Position C
    130 SAD_TAC_FLD_POSN_D Character(2) VARCHAR2(2) NOT NULL TAC Field Position D
    131 SAD_TAC_FLD_POSN_E Character(2) VARCHAR2(2) NOT NULL TAC Field Position E
    132 SAD_TAC_OP_SCORE Character(2) VARCHAR2(2) NOT NULL TAC Score
    133 SAD_TAC_ATAR_CALC Character(5) VARCHAR2(5) NOT NULL ATAR Calculating Authority
    134 SAD_TAC_PROGRAM_CD Character(10) VARCHAR2(10) NOT NULL Program Code
    135 SAD_TAC_STREAM_CD Character(10) VARCHAR2(10) NOT NULL TAC Stream Code for SATAC
    136 SCC_USI Character(10) VARCHAR2(10) NOT NULL Unique Student Identifier
    137 SCC_CHESSN Character(10) VARCHAR2(10) NOT NULL Commonwealth Higher Education Student Support Number (CHESSN)
    138 SCC_SLE_USAGE Number(8,5) DECIMAL(7,5) NOT NULL Ordinary Student Learning Entitlement Usage
    139 SCC_FEE_HELP_BAL Number(10,2) DECIMAL(9,2) NOT NULL FEE-HELP Balance
    140 SCC_AT_DATE Date(10) DATE DEST As At Date
    141 SCC_ORD_SLE_BAL Number(8,5) DECIMAL(7,5) NOT NULL Ordinary SLE Balance
    142 SAD_ETHNICITY_LD Character(2) VARCHAR2(2) NOT NULL Ethnicity
    143 SAD_TAC_APPL_TYPE Character(3) VARCHAR2(3) NOT NULL Application Type
    144 SUBURB_E486_AUS Character(55) VARCHAR2(55) NOT NULL Year 12 Residence Location
    145 SAD_TAC_PCRS_LABEL Character(30) VARCHAR2(30) NOT NULL TAC Label
    146 SAD_TAC_E493 Character(6) VARCHAR2(6) NOT NULL Dest Element
    147 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
    148 PHONE_CNTRY_CD Character(3) VARCHAR2(3) NOT NULL Phone country code
    149 PHONE_DAY_LONG Character(30) VARCHAR2(30) NOT NULL Phone_Day_Long
    150 SAD_TAC_SCH_POSTCD Character(4) VARCHAR2(4) NOT NULL TAC School Postcode
    151 METHOD_A_OFR_TYP1 Character(3) VARCHAR2(3) NOT NULL TAC Method A offered Type 1 Current GET Round
    152 METHOD_A_OFR_TYP2 Character(3) VARCHAR2(3) NOT NULL TAC Method A offered Type 2 Current GET Round
    153 METHOD_B_OFR_TYP1 Character(3) VARCHAR2(3) NOT NULL TAC Method B offered Type 1 Current GET Round
    154 METHOD_B_OFR_TYP2 Character(3) VARCHAR2(3) NOT NULL TAC Method B offered Type 2 Current GET Round
    155 OFR_TYP1_GET_RND Character(1) VARCHAR2(1) NOT NULL TAC Type of Offer Type 1 Current GET Round
    156 OFR_TYP2_GET_RND Character(1) VARCHAR2(1) NOT NULL TAC Type of Offer Type 2 Current GET Round
    157 COURSE_CD_OFR_TYP2 Character(5) VARCHAR2(5) NOT NULL TAC Course Code Offered Type 2 Current GET Round
    158 SAD_TAC_OFFR_MONTH Character(3) VARCHAR2(3) NOT NULL TAC Offer Period Month.
    159 SAD_TAC_OFFR_YEAR Number(4,0) SMALLINT NOT NULL TAC Offer Period Year
    160 SSR_HIGHST_EDU1 Character(3) VARCHAR2(3) NOT NULL Highest Edu Parent Guardian 1

    Prompt Table: SSR_HIGH_ED1_VW

    161 SSR_HIGHST_EDU2 Character(3) VARCHAR2(3) NOT NULL Highest Edu Parent Guardian 2

    Prompt Table: SSR_HIGH_ED1_VW

    162 SAD_AUS_MIL_SVC Character(1) VARCHAR2(1) NOT NULL Australian Military Service

    Y/N Table Edit

    163 NAME_LOC_IND_CMNTY Character(100) VARCHAR2(100) NOT NULL Name and location of indigenous community
    164 SAD_TAC_PRMADRFRMT Character(1) VARCHAR2(1) NOT NULL Permanant Address Format

    Y/N Table Edit

    165 SAD_TAC_PERM_ADDR1 Character(55) VARCHAR2(55) NOT NULL Address 1
    166 SAD_TAC_PERM_ADDR2 Character(55) VARCHAR2(55) NOT NULL Address 2
    167 SAD_TAC_PERM_ADDR3 Character(55) VARCHAR2(55) NOT NULL Address 3
    168 SAD_TAC_PERM_ADDR4 Character(55) VARCHAR2(55) NOT NULL Address 4
    169 SAD_TAC_PERM_ADDR5 Character(55) VARCHAR2(55) NOT NULL Address 5
    170 SAD_TAC_PERM_CITY Character(35) VARCHAR2(35) NOT NULL TAC Current City
    171 SAD_TAC_PERM_STATE Character(6) VARCHAR2(6) NOT NULL TAC Current State

    Prompt Table: PERM_STATE_TBL

    172 SAD_TAC_PERM_CNTRY Character(3) VARCHAR2(3) NOT NULL TAC Current Country

    Prompt Table: COUNTRY_TBL

    173 SAD_TAC_PERM_CTRY4 Character(4) VARCHAR2(4) NOT NULL TAC Current Country (4-char)

    Prompt Table: COUNTRY_TBL

    174 SAD_TAC_POSTAL_CD Character(12) VARCHAR2(12) NOT NULL Postal Code
    175 SAD_TAC_PERM_ZIP Character(12) VARCHAR2(12) NOT NULL TAC Overseas Zip
    176 SAD_QCE_ELIG Character(1) VARCHAR2(1) NOT NULL QCE Eligilibility
    177 SAD_CENTERLINK_ST Character(1) VARCHAR2(1) NOT NULL Centrelink Status
    178 SAD_WT_EAS_SCORE Character(5) VARCHAR2(5) NOT NULL Weighted EAS Score
    179 SAD_TAC_MOBILEQTAC Character(30) VARCHAR2(30) NOT NULL TAC Mobile Phone
    180 ATSI_STAT_CNF Character(1) VARCHAR2(1) NOT NULL ATSI Status Confirmed
    181 SAD_TAC_PRXY_NAME Character(50) VARCHAR2(50) NOT NULL VTAC 2019: Proxy Name
    182 SAD_TAC_PRXY_REL Character(40) VARCHAR2(40) NOT NULL VTAC 2019: Proxy Relationship
    183 SAD_TAC_PRXY_DOB Date(10) DATE VTAC 2019: Proxy DOB
    184 SAD_TAC_PRXY_PHONE Character(24) VARCHAR2(24) NOT NULL VTAC 2019: Proxy Phone
    185 SAD_TAC_PRXY_EMAIL Character(70) VARCHAR2(70) NOT NULL VTAC 2019: Proxy Email
    186 SAD_TAC_QLD_FOR Long Character(300) VARCHAR2(300) QTAC 2019: Forced Offer Reason