SAD_TAC_SUS_PRF

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