SAD_TAC_CD_PRF

(SQL Table)
Index Back

TAC Preference

  • Parent record: SAD_TAC_CD
  • # 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_COURSE_CD Character(10) VARCHAR2(10) NOT NULL TAC Course Code
    4 SAD_TAC_PREF_NBR Number(9,0) DECIMAL(9) NOT NULL TAC Preference Number
    5 SAD_TAC_PLAN Character(10) VARCHAR2(10) NOT NULL TAC Plan
    6 COURSE_TITLE Character(30) VARCHAR2(30) NOT NULL Course Title
    7 SAD_TAC_STREAM_CD Character(10) VARCHAR2(10) NOT NULL TAC Stream Code for SATAC
    8 SAD_TAC_STREAM_TTL Character(50) VARCHAR2(50) NOT NULL TAC Stream Title
    9 SAD_TAC_OFFR_ROUND Number(5,0) INTEGER NOT NULL TAC offer Round Number
    10 OFFER_DT Date(10) DATE Offer Date
    11 SAD_TAC_OFFER_RSP Character(2) VARCHAR2(2) NOT NULL TAC Offer Response
    12 SAD_TAC_PRF_CAS_TP Character(3) VARCHAR2(3) NOT NULL TAC Preference Type
    13 SAD_TAC_PRF_CAS_VL Character(30) VARCHAR2(30) NOT NULL TAC Preference Value
    14 SAD_TAC_PRF_CAS_RS Character(120) VARCHAR2(120) NOT NULL TAC Preference Reason
    15 SAD_TAC_PRF_OFF_BS Character(120) VARCHAR2(120) NOT NULL TAC Pref Offer Basis
    16 SAD_TAC_PREF_ADM Character(2) VARCHAR2(2) NOT NULL TAC Admission Preference
    17 SAD_TAC_PREF_DT Date(10) DATE TAC Preference Date
    18 SAD_TAC_OFF_ST_NBR Character(1) VARCHAR2(1) NOT NULL TAC Offer Stream Number
    19 SAD_TAC_RANK_POS Character(5) VARCHAR2(5) NOT NULL TAC Rank Position
    20 SAD_TAC_SYSTEM_RNK Character(4) VARCHAR2(4) NOT NULL TAC System Rank
    21 SAD_TAC_OFFER_STAT Character(1) VARCHAR2(1) NOT NULL TAC Offer Status
    22 SAD_TAC_SPEC_ADM Character(2) VARCHAR2(2) NOT NULL TAC Spec. Admission
    23 SAD_TAC_METHOD_A Character(3) VARCHAR2(3) NOT NULL TAC Method A
    24 SAD_TAC_METHOD_B Character(3) VARCHAR2(3) NOT NULL TAC Method B
    25 SAD_TAC_ALT_METHOD Character(3) VARCHAR2(3) NOT NULL TAC Alt Method
    26 SAD_TAC_OFF_METH_A Character(3) VARCHAR2(3) NOT NULL TAC Offer Method A
    27 SAD_TAC_OFF_METH_B Character(3) VARCHAR2(3) NOT NULL TAC Offer Method B
    28 SAD_TAC_PROGRAM_CD Character(10) VARCHAR2(10) NOT NULL Program Code