AP_ACI

#	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	TEST_DT_AP	Character(2)	VARCHAR2(2) NOT NULL	AP Test Date
4	LAST_NAME_AP	Character(15)	VARCHAR2(15) NOT NULL	Last Name
5	FIRST_NAME_AP	Character(12)	VARCHAR2(12) NOT NULL	First Name
6	MIDDLE_INIT_AP	Character(1)	VARCHAR2(1) NOT NULL	Middle Initial
7	ADDRESS1_AP	Character(30)	VARCHAR2(30) NOT NULL	AP Address Line 1
8	ADDRESS2_AP	Character(30)	VARCHAR2(30) NOT NULL	AP Address Line 2
9	ADDRESS3_AP	Character(30)	VARCHAR2(30) NOT NULL	AP City
10	STATE_AP	Character(2)	VARCHAR2(2) NOT NULL	AP State
11	POSTAL_AP	Character(9)	VARCHAR2(9) NOT NULL	AP Postal Code
12	COUNTRY_CODE_AP	Character(3)	VARCHAR2(3) NOT NULL	AP Country Code
13	BIRTHDATE_AP	Character(6)	VARCHAR2(6) NOT NULL	AP Birthdate
14	SEX_AP	Character(1)	VARCHAR2(1) NOT NULL	AP Gender
15	SSN_AP	Character(9)	VARCHAR2(9) NOT NULL	AP SSN
16	ED_LEVEL_AP	Character(1)	VARCHAR2(1) NOT NULL	Education Level
17	EXPCTD_COL_ENTR_AP	Character(3)	VARCHAR2(3) NOT NULL	AP Expected College Entrance
18	ETHNICITY_AP	Character(1)	VARCHAR2(1) NOT NULL	AP Ethnicity
19	STDNT_SRCH_FLAG_AP	Character(1)	VARCHAR2(1) NOT NULL	AP Student Search Flag
20	BEST_LANGUAGE_AP	Character(1)	VARCHAR2(1) NOT NULL	AP Best Language
21	DT_GRADE_REL_AP	Character(6)	VARCHAR2(6) NOT NULL	AP Date Grade Released
22	DT_CAND_UPDT_AP	Character(6)	VARCHAR2(6) NOT NULL	AP Date of Last Candidate Update
23	DT_REPORT_AP	Character(6)	VARCHAR2(6) NOT NULL	AP Date of this Report
24	SRVC_TYPE_AP	Character(2)	VARCHAR2(2) NOT NULL	AP Service Type
25	SRVC_CODE_AP	Character(4)	VARCHAR2(4) NOT NULL	AP Service Code
26	ORDR_INST_KEY_AP	Character(8)	VARCHAR2(8) NOT NULL	AP Ordering Institution Key
27	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 Y/N Table Edit Default Value: N
28	REG_NBR_AP	Character(8)	VARCHAR2(8) NOT NULL	AP Registration Number
29	APLY_SPHMR_STND_AP	Character(1)	VARCHAR2(1) NOT NULL	AP Apply Sophmore Standing