SAD_TAC_SUS_OFF

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