SAD_AMC_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	SAD_TEST_DT_LD	Character(10)	VARCHAR2(10) NOT NULL	Test Load Test Date
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_NAME_LD	Character(30)	VARCHAR2(30) NOT NULL	Middle Name
7	SAD_ADDRESS1_LD	Character(55)	VARCHAR2(55) NOT NULL	Address 1
8	SAD_ADDRESS2_LD	Character(55)	VARCHAR2(55) NOT NULL	Address 2
9	SAD_CITY_LD	Character(40)	VARCHAR2(40) NOT NULL	Test Load City
10	SAD_STATE_LD	Character(60)	VARCHAR2(60) NOT NULL	Test Load State
11	SAD_POSTAL_LD	Character(15)	VARCHAR2(15) NOT NULL	Test Load Postal Code
12	SAD_COUNTRY_LD	Character(30)	VARCHAR2(30) NOT NULL	Test Load Country
13	PREF_CNTRY_CD_AMCS	Character(3)	VARCHAR2(3) NOT NULL	Preferred Country Code
14	COUNTRY_AMCAS	Character(20)	VARCHAR2(20) NOT NULL	AMCAS Country
15	SAD_TELEPHONE_LD	Character(20)	VARCHAR2(20) NOT NULL	Telephone Number
16	SAD_BIRTHDATE_LD	Character(10)	VARCHAR2(10) NOT NULL	Admissions Birthdate from Test Load
17	SAD_SEX_LD	Character(1)	VARCHAR2(1) NOT NULL	Test Load Gender
18	SAD_SSN_LD	Character(9)	VARCHAR2(9) NOT NULL	Admissions Test Load SSN
19	ADMIT_TERM_AMCAS	Character(4)	VARCHAR2(4) NOT NULL	AMCAS Application Year
20	NOTFICTN_PLN_AMCAS	Character(1)	VARCHAR2(1) NOT NULL	AMCAS Early Decision Applicant
21	APPL_FEE_ST_AMCAS	Character(1)	VARCHAR2(1) NOT NULL	AMCAS Application Fee Waiver
22	STATE_RES_AMCAS	Character(2)	VARCHAR2(2) NOT NULL	AMCAS State of Residence
23	COUNTY_AMCAS	Character(20)	VARCHAR2(20) NOT NULL	AMCAS County of Residence
24	VISA_PERMIT_AMCAS	Character(2)	VARCHAR2(2) NOT NULL	Visa Permit Type
25	BIRTH_STATE_AMCAS	Character(6)	VARCHAR2(6) NOT NULL	AMCAS Birth State
26	BIRTH_CITY_AMCAS	Character(15)	VARCHAR2(15) NOT NULL	AMCAS Birth City
27	BIRTH_CNTRY_AMCAS	Character(20)	VARCHAR2(20) NOT NULL	AMCAS Birth Country
28	SAD_ETHNICITY_LD	Character(2)	VARCHAR2(2) NOT NULL	Ethnicity
29	ETHNICHISP_IND	Character(1)	VARCHAR2(1) NOT NULL	Ethnic Hispanic Indicator
30	MILITARY_ST_AMCAS	Character(1)	VARCHAR2(1) NOT NULL	AMCAS Military Service
31	CBC_MILITARY_DISCH	Character(1)	VARCHAR2(1) NOT NULL	Military Discharge
32	CBC_MILITARY_HON	Character(1)	VARCHAR2(1) NOT NULL	Honorable Discharge
33	FELONY_AMCAS	Character(1)	VARCHAR2(1) NOT NULL	Felony
34	CBC_FELONY_IND	Character(1)	VARCHAR2(1) NOT NULL	CBC Felony
35	CBC_MISDEMEANOR	Character(1)	VARCHAR2(1) NOT NULL	CBC Misdemeanor
36	SCHOOL_NBR_AMCAS	Character(3)	VARCHAR2(3) NOT NULL	AMCAS School Number
37	APPL_DATE_AMCAS	Character(8)	VARCHAR2(8) NOT NULL	AMCAS Date of Application
38	YR_APPL1_AMCAS	Character(4)	VARCHAR2(4) NOT NULL	AMCAS Year Previously Applied 1
39	YR_APPL2_AMCAS	Character(4)	VARCHAR2(4) NOT NULL	AMCAS Year Previously Applied 2
40	YR_APPL3_AMCAS	Character(4)	VARCHAR2(4) NOT NULL	AMCAS Year Previously Applied 3
41	YR_APPL4_AMCAS	Character(4)	VARCHAR2(4) NOT NULL	AMCAS Year Previously Applied 4
42	ADM_APPL_RUN	Character(1)	VARCHAR2(1) NOT NULL	Posting Application Option D=Duplicate Application N=Select For Applicatn Creation X=Do Not Use for Appl Creation Y=Created Application Default Value: N
43	ADM_APPL_NBR	Character(8)	VARCHAR2(8) NOT NULL	Application Nbr
44	ADM_APPL_DATE_RUN	Date(10)	DATE	Used as: - Run Date - Loaded Date - Effective Date
45	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
46	BRTH_CNTRYCD_AMCAS	Character(3)	VARCHAR2(3) NOT NULL	AMCAS Birth Country Code
47	AMCAS_FILNBR_AMCAS	Character(10)	VARCHAR2(10) NOT NULL	AMCAS File Number
48	EVALUATION_AMCAS	Character(1)	VARCHAR2(1) NOT NULL	Evaluation
49	SUFFIX_AMCAS	Character(3)	VARCHAR2(3) NOT NULL	Suffix
50	CNTY_RU_IND_AMCAS	Character(1)	VARCHAR2(1) NOT NULL	AMCAS County Rural Indicator
51	CNTY_CD_RES_AMCAS	Character(3)	VARCHAR2(3) NOT NULL	AMCAS Residency County Code
52	AGE_AMCAS	Number(2,0)	SMALLINT NOT NULL	Age
53	NBR_OF_DEPND_AMCAS	Number(2,0)	SMALLINT NOT NULL	Number of Dependents
54	MRTY_APL_RSN_AMCAS	Character(1)	VARCHAR2(1) NOT NULL	AMCAS Minority Applicant
55	MATRICULATED_AMCAS	Character(1)	VARCHAR2(1) NOT NULL	Previous Matriculation
56	RCPNT_ACTION_AMCAS	Character(1)	VARCHAR2(1) NOT NULL	Recipient of Any Action
57	PLUS_MNS_GRD_AMCAS	Character(1)	VARCHAR2(1) NOT NULL	Plus or Minus Grade
58	NBR_MCT_TKN_MCAT	Character(3)	VARCHAR2(3) NOT NULL	Number of MCATs Taken
59	NEXT_TEST_DT_MCAT	Character(6)	VARCHAR2(6) NOT NULL	Next MCAT Test Date
60	ADDL_MCAT_INTENT	Character(1)	VARCHAR2(1) NOT NULL	Addl MCAT Intent
61	ADDL_MCAT_INT_DT	Character(12)	VARCHAR2(12) NOT NULL	Addl MCAT Intent Date
62	SCHL_STATE_AMCAS	Character(2)	VARCHAR2(2) NOT NULL	School State
63	ADM_ACTN_CD_AMCAS	Character(2)	VARCHAR2(2) NOT NULL	Admission Action Code
64	ACTION_DT_AMCAS	Character(8)	VARCHAR2(8) NOT NULL	Action Date
65	MATRICULA_DT_AMCAS	Character(6)	VARCHAR2(6) NOT NULL	Matriculation Date
66	EXPCT_GRD_DT_AMCAS	Character(6)	VARCHAR2(6) NOT NULL	Expected Graduation Date
67	BIR_RUR_IND_AMCAS	Character(1)	VARCHAR2(1) NOT NULL	AMCAS Birth County Rural Indicator
68	URM_IND	Character(1)	VARCHAR2(1) NOT NULL	URM Indicator
69	BIO_NBR_AMCAS	Character(22)	VARCHAR2(22) NOT NULL	Bio Number
70	VERIFIED_IND	Character(1)	VARCHAR2(1) NOT NULL	Verified Indicator
71	EFFDT_AMCAS	Character(8)	VARCHAR2(8) NOT NULL	Effective Date
72	APPL_TYPE_AMCAS	Character(1)	VARCHAR2(1) NOT NULL	Application Type
73	SAD_EMAIL_LD	Character(70)	VARCHAR2(70) NOT NULL	EMail Address