SAD_TAC_CD_OFFR

(SQL Table)
Index Back

VTAC Offers

# 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_OFFR_NBR Number(9,0) DECIMAL(9) NOT NULL TAC Offer Number
5 SAD_TAC_PROGRAM_CD Character(10) VARCHAR2(10) NOT NULL Program Code
6 ADMIT_TYPE Character(3) VARCHAR2(3) NOT NULL Admit Type
7 SCHOOL_CODE Character(10) VARCHAR2(10) NOT NULL School Code
8 OFFER_DT Date(10) DATE Offer Date
9 SAD_TAC_TER_SCORE Number(8,3) DECIMAL(7,3) NOT NULL TAC Score
10 SAD_TAC_ADMIT_STAT Character(3) VARCHAR2(3) NOT NULL TAC Admit Status Type
11 ADM_APPL_DT Date(10) DATE Application Date
12 SAD_TAC_COND_OFFR Character(1) VARCHAR2(1) NOT NULL Conditional Offer
13 SAD_TAC_OFFER_STAT Character(1) VARCHAR2(1) NOT NULL TAC Offer Status
14 SAD_TAC_OFFR_ROUND Number(5,0) INTEGER NOT NULL TAC offer Round Number
15 SAD_TAC_OFFR_MONTH Character(3) VARCHAR2(3) NOT NULL TAC Offer Period Month.
16 SAD_TAC_OFFR_YEAR Number(4,0) SMALLINT NOT NULL TAC Offer Period Year
17 SAD_TAC_FLD_POSN_A Character(2) VARCHAR2(2) NOT NULL TAC Field Position A
18 SAD_TAC_FLD_POSN_B Character(2) VARCHAR2(2) NOT NULL TAC Field Position B
19 SAD_TAC_FLD_POSN_C Character(2) VARCHAR2(2) NOT NULL TAC Field Position C
20 SAD_TAC_FLD_POSN_D Character(2) VARCHAR2(2) NOT NULL TAC Field Position D
21 SAD_TAC_FLD_POSN_E Character(2) VARCHAR2(2) NOT NULL TAC Field Position E
22 BASIS_ADMIT_CODE Character(5) VARCHAR2(5) NOT NULL Basis of Admission Code
23 SAD_TAC_APPL_TYPE Character(3) VARCHAR2(3) NOT NULL Application Type
24 SAD_TAC_APPL_OAS Character(3) VARCHAR2(3) NOT NULL Overall Allocatability Status
25 SAD_TAC_OAS_CMMT Character(120) VARCHAR2(120) NOT NULL TAC OAS Comment
26 SAD_TAC_PCRS_LABEL Character(30) VARCHAR2(30) NOT NULL TAC Label
27 SAD_TAC_BASE_RANK Character(30) VARCHAR2(30) NOT NULL TAC Base Rank Set
28 SAD_TAC_BASE_SCHED Character(20) VARCHAR2(20) NOT NULL TAC Base Schedule
29 SAD_TAC_OFF_CS_RNK Character(60) VARCHAR2(60) NOT NULL TAC Offer Course Rank
30 SAD_TAC_OFF_CRS_SD Character(20) VARCHAR2(20) NOT NULL TAC Offer Course Schedule
31 SAD_TAC_OP_SCORE Character(2) VARCHAR2(2) NOT NULL TAC Score
32 SAD_TAC_STREAM_CD Character(10) VARCHAR2(10) NOT NULL TAC Stream Code for SATAC
33 SAD_TAC_OFF_METH_A Character(3) VARCHAR2(3) NOT NULL TAC Offer Method A
34 SAD_TAC_OFF_METH_B Character(3) VARCHAR2(3) NOT NULL TAC Offer Method B
35 SAD_TAC_METHOD_A Character(3) VARCHAR2(3) NOT NULL TAC Method A
36 SAD_TAC_METHOD_B Character(3) VARCHAR2(3) NOT NULL TAC Method B