SAD_SSS_CD

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PEOPLE_SRCH
2	TEST_DT	Date(10)	DATE NOT NULL	Test Date
3	CAUSE_CREATION	Character(1)	VARCHAR2(1) NOT NULL	Personal Data Impacts N=No Personal Data Impact U=Caused Personal Data Update Y=Caused Personal Data Creation Default Value: N
4	SAD_LAST_NAME_LD	Character(32)	VARCHAR2(32) NOT NULL	Admissions Last Name from Test Load
5	SAD_FIRST_NAME_LD	Character(30)	VARCHAR2(30) NOT NULL	Admissions First Name from Test Load
6	SAD_MID_INIT_LD	Character(1)	VARCHAR2(1) NOT NULL	Admissions Middle Initial from Test Load
7	SAD_ADDRESS1_LD	Character(55)	VARCHAR2(55) NOT NULL	Address 1
8	SAD_CITY_LD	Character(40)	VARCHAR2(40) NOT NULL	Test Load City
9	SAD_STATE_LD	Character(60)	VARCHAR2(60) NOT NULL	Test Load State
10	SAD_POSTAL_LD	Character(15)	VARCHAR2(15) NOT NULL	Test Load Postal Code
11	SAD_COUNTRY_LD	Character(30)	VARCHAR2(30) NOT NULL	Test Load Country
12	SAD_BIRTHDATE_LD	Character(10)	VARCHAR2(10) NOT NULL	Admissions Birthdate from Test Load
13	SAD_SEX_LD	Character(1)	VARCHAR2(1) NOT NULL	Test Load Gender
14	SAD_SSN_LD	Character(9)	VARCHAR2(9) NOT NULL	Admissions Test Load SSN
15	HS_CODE_SSS	Character(6)	VARCHAR2(6) NOT NULL	High School Code
16	GRADE_LEVEL_SSS	Character(2)	VARCHAR2(2) NOT NULL	Grade Level
17	CLG_BRDRGNL_CD_SSS	Character(1)	VARCHAR2(1) NOT NULL	SSS College Board Regional Code
18	ZERO_SSS	Number(2,0)	SMALLINT NOT NULL	Zero
19	INST_CODE_SSS	Character(4)	VARCHAR2(4) NOT NULL	Institutional Code
20	RCPNT_CODE_SSS	Character(2)	VARCHAR2(2) NOT NULL	Recipient Code
21	YR_SRCH_CD_SSS	Character(2)	VARCHAR2(2) NOT NULL	SSS Year and Search Code
22	PRTCPTN_FRMNBR_SSS	Character(2)	VARCHAR2(2) NOT NULL	SSS Participation Form Number
23	EPS_MRKT_CD_SSS	Character(4)	VARCHAR2(4) NOT NULL	SSS EPS Market Code
24	PSTL_DLVRY_PNT_SSS	Character(2)	VARCHAR2(2) NOT NULL	Postal Delivery Point
25	PST_CRCTN_CHAR_SSS	Character(1)	VARCHAR2(1) NOT NULL	Postal Correction Character
26	SAD_ETHNICITY_LD	Character(2)	VARCHAR2(2) NOT NULL	Ethnicity
27	SAD_EMAIL_LD	Character(70)	VARCHAR2(70) NOT NULL	EMail Address
28	SAD_COUNTY_LD	Character(6)	VARCHAR2(6) NOT NULL	County Code
29	HS_CLUSTER_SSS	Character(2)	VARCHAR2(2) NOT NULL	SSS High School Cluster
30	EDUC_NBRHD_SSS	Character(2)	VARCHAR2(2) NOT NULL	SSS Educational Neighborhood
31	SAD_HS_CLUSTER_SSS	Character(2)	VARCHAR2(2) NOT NULL	New High School Cluster
32	SAD_EDUC_NBRHD_SSS	Character(2)	VARCHAR2(2) NOT NULL	New Educational Neighbourhood
33	SAD_SSS_CUST_ID	Character(6)	VARCHAR2(6) NOT NULL	SSS Customer ID
34	SAD_SSS_SRCH_YR	Character(2)	VARCHAR2(2) NOT NULL	SSS Search Year and Cycle
35	SAD_SSS_CYCLE	Character(1)	VARCHAR2(1) NOT NULL	Search Cycle
36	SAD_SSS_SRCH_FORM	Character(3)	VARCHAR2(3) NOT NULL	SSS Search Form Number
37	SAD_SSS_RUN_CODE	Character(3)	VARCHAR2(3) NOT NULL	Run Code
38	GRAD_YR_SSS	Character(2)	VARCHAR2(2) NOT NULL	SSS Graduation Year
39	SAD_SSS_DAT_SRC_CD	Number(2,0)	SMALLINT NOT NULL	Student Data Source Code
40	SAD_ADDRESS2_LD	Character(55)	VARCHAR2(55) NOT NULL	Address 2
41	SAD_ADDRESS3_LD	Character(55)	VARCHAR2(55) NOT NULL	Address 3
42	SAD_SSS_ORDERNBR	Character(10)	VARCHAR2(10) NOT NULL	Order Number
43	SAD_SSS_CBEXAM	Character(4)	VARCHAR2(4) NOT NULL	Most Recent CB Exam
44	SAD_SSS_LSTUPDT	Date(10)	DATE	Last Update Date
45	SAD_SSS_HOMESCHL	Character(1)	VARCHAR2(1) NOT NULL	Home Schooled
46	SAD_SSS_LOWSES	Character(2)	VARCHAR2(2) NOT NULL	Low SES
47	SAD_SSS_STDNT_ID	Character(32)	VARCHAR2(32) NOT NULL	Student ID