ACCOMPLISHMENTS

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSONAL_DATA
2	ACCOMPLISHMENT	Character(8)	VARCHAR2(8) NOT NULL	Accomplishment Prompt Table: %RECNAME_EDIT
3	DT_ISSUED	Date(10)	DATE	Issue Date
4	MAJOR_CODE	Character(10)	VARCHAR2(10) NOT NULL	Major Code Prompt Table: MAJOR_TBL
5	SCORE	Number(7,2)	DECIMAL(6,2) NOT NULL	Test Score
6	PASSED	Character(1)	VARCHAR2(1) NOT NULL	Passed Test Y/N Table Edit Default Value: N
7	LICENSE_NBR	Character(15)	VARCHAR2(15) NOT NULL	License/Certification Number
8	ISSUED_BY	Character(30)	VARCHAR2(30) NOT NULL	Issued By
9	STATE	Character(6)	VARCHAR2(6) NOT NULL	State Prompt Table: STATE_TBL
10	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country Prompt Table: COUNTRY_TBL
11	EXPIRATN_DT	Date(10)	DATE	Expiration Date
12	LICENSE_VERIFIED	Character(1)	VARCHAR2(1) NOT NULL	License Verified Y/N Table Edit Default Value: N
13	RENEWAL	Character(1)	VARCHAR2(1) NOT NULL	Renewal in Progress Y/N Table Edit Default Value: N
14	NATIVE_LANGUAGE	Character(1)	VARCHAR2(1) NOT NULL	Native Language Y/N Table Edit Default Value: N
15	TRANSLATOR	Character(1)	VARCHAR2(1) NOT NULL	Able to Translate Y/N Table Edit Default Value: N
16	TEACHER	Character(1)	VARCHAR2(1) NOT NULL	Able to Teach Y/N Table Edit Default Value: N
17	SPEAK_PROFICIENCY	Character(1)	VARCHAR2(1) NOT NULL	Speaking Proficiency 1=Low 2=Moderate 3=High
18	READ_PROFICIENCY	Character(1)	VARCHAR2(1) NOT NULL	Reading Proficiency 1=Low 2=Moderate 3=High
19	WRITE_PROFICIENCY	Character(1)	VARCHAR2(1) NOT NULL	Writing Proficiency 1=Low 2=Moderate 3=High
20	EVALUATION_DT	Date(10)	DATE	Evaluation Date
21	MANDATE	Character(15)	VARCHAR2(15) NOT NULL	Mandate
22	MANDATE_FUNCTION	Character(15)	VARCHAR2(15) NOT NULL	Mandate Position
23	MANDATE_BEGIN_DATE	Date(10)	DATE	Mandate Begin Date
24	MANDATE_END_DATE	Date(10)	DATE	Mandate End Date
25	MAJOR	Character(30)	VARCHAR2(30) NOT NULL	Major
26	IPE_SW	Character(1)	VARCHAR2(1) NOT NULL	Intern. Professional Education Y/N Table Edit Default Value: N
27	AVERAGE_GRADE	Character(5)	VARCHAR2(5) NOT NULL	Average Grade
28	EDUCATOR	Character(50)	VARCHAR2(50) NOT NULL	Educator
29	GRADUATE_INDICATOR	Character(1)	VARCHAR2(1) NOT NULL	Graduated Y/N Table Edit Default Value: Y
30	SCHOOL_CODE	Character(10)	VARCHAR2(10) NOT NULL	School Code Prompt Table: SCHOOL_TBL
31	SCHOOL	Character(30)	VARCHAR2(30) NOT NULL	School Name
32	STATE_OTHER	Character(6)	VARCHAR2(6) NOT NULL	State Other Prompt Table: STATE_NAMES_OTH
33	COUNTRY_OTHER	Character(3)	VARCHAR2(3) NOT NULL	Country field for ADDR_OTR_SBR and DERIVED_ADDR_OT Prompt Table: COUNTRY_TBL
34	TERMINAL_DEGREE	Character(1)	VARCHAR2(1) NOT NULL	Terminal Degree for Discipline Y/N Table Edit Default Value: N
35	PRACTIC_GRADE_GER	Character(4)	VARCHAR2(4) NOT NULL	Practical Grade
36	THEORY_GRADE_GER	Character(4)	VARCHAR2(4) NOT NULL	Theoretical Grade
37	GRANTOR	Character(20)	VARCHAR2(20) NOT NULL	Grantor
38	END_DATE	Date(10)	DATE	End Date
39	BONUS_DT_FRA	Date(10)	DATE	Bonus Date
40	BONUS_AMOUNT_FRA	Number(8,2)	DECIMAL(7,2) NOT NULL	Bonus
41	GVT_CREDIT_HOURS	Character(3)	VARCHAR2(3) NOT NULL	Credit Hours
42	GVT_CRED_HRS_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Credit Hours Type
43	GPA	Number(5,2)	DECIMAL(4,2) NOT NULL	GPA
44	YR_ACQUIRED	Number(4,0)	SMALLINT NOT NULL	Year Acquired
45	SELECT_CMP	Character(1)	VARCHAR2(1) NOT NULL	Include Competency for Search Y/N Table Edit Default Value: Y