SCC_ACCOM_MBR_I

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSON
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
5	ACCOMP_CATEGORY	Character(3)	VARCHAR2(3) NOT NULL	Accomplishment Category DEG=Degree HON=Honor or Award LIC=License or Certification LNG=Language MEM=Membership NVQ=NVQ TST=Test
6	SCORE	Number(7,2)	DECIMAL(6,2) NOT NULL	Test Score
7	PASSED	Character(1)	VARCHAR2(1) NOT NULL	Passed Test Y/N Table Edit Default Value: N
8	LICENSE_NBR	Character(15)	VARCHAR2(15) NOT NULL	License/Certification Number
9	ISSUED_BY	Character(30)	VARCHAR2(30) NOT NULL	Issued By
10	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country Default Value: OPR_DEF_TBL_HR.COUNTRY Prompt Table: COUNTRY_TBL
11	STATE	Character(6)	VARCHAR2(6) NOT NULL	State Prompt Table: HCR_STONLY_I
12	EXPIRATN_DT	Date(10)	DATE	Expiration Date
13	LICENSE_VERIFIED	Character(1)	VARCHAR2(1) NOT NULL	License Verified Y/N Table Edit Default Value: N
14	RENEWAL	Character(1)	VARCHAR2(1) NOT NULL	Renewal in Progress Y/N Table Edit Default Value: N
15	NATIVE_LANGUAGE	Character(1)	VARCHAR2(1) NOT NULL	Native Language Y/N Table Edit Default Value: N
16	TRANSLATOR	Character(1)	VARCHAR2(1) NOT NULL	Able to Translate Y/N Table Edit Default Value: N
17	TEACHER	Character(1)	VARCHAR2(1) NOT NULL	Able to Teach Y/N Table Edit Default Value: N
18	SPEAK_PROFICIENCY	Character(1)	VARCHAR2(1) NOT NULL	Speaking Proficiency 1=Low 2=Moderate 3=High
19	READ_PROFICIENCY	Character(1)	VARCHAR2(1) NOT NULL	Reading Proficiency 1=Low 2=Moderate 3=High
20	WRITE_PROFICIENCY	Character(1)	VARCHAR2(1) NOT NULL	Writing Proficiency 1=Low 2=Moderate 3=High
21	EVALUATION_DT	Date(10)	DATE	Evaluation Date
22	MANDATE	Character(15)	VARCHAR2(15) NOT NULL	Mandate
23	MANDATE_FUNCTION	Character(15)	VARCHAR2(15) NOT NULL	Mandate Position
24	MANDATE_BEGIN_DATE	Date(10)	DATE	Mandate Begin Date
25	MANDATE_END_DATE	Date(10)	DATE	Mandate End Date
26	MAJOR	Character(30)	VARCHAR2(30) NOT NULL	Major
27	IPE_SW	Character(1)	VARCHAR2(1) NOT NULL	Intern. Professional Education Y/N Table Edit Default Value: N
28	AVERAGE_GRADE	Character(5)	VARCHAR2(5) NOT NULL	Average Grade
29	EDUCATOR	Character(50)	VARCHAR2(50) NOT NULL	Educator
30	GRADUATE_INDICATOR	Character(1)	VARCHAR2(1) NOT NULL	Graduated Y/N Table Edit Default Value: N
31	COUNTRY_OTHER	Character(3)	VARCHAR2(3) NOT NULL	Country field for ADDR_OTR_SBR and DERIVED_ADDR_OT Default Value: OPR_DEF_TBL_HR.COUNTRY Prompt Table: COUNTRY_TBL
32	STATE_OTHER	Character(6)	VARCHAR2(6) NOT NULL	State Other Prompt Table: HCR_STONLY_OT_I
33	SCHOOL_CODE	Character(10)	VARCHAR2(10) NOT NULL	School Code Prompt Table: SCHOOL_TBL_VW
34	SCHOOL	Character(30)	VARCHAR2(30) NOT NULL	School Name
35	TERMINAL_DEGREE	Character(1)	VARCHAR2(1) NOT NULL	Terminal Degree for Discipline Y/N Table Edit Default Value: N
36	PRACTIC_GRADE_GER	Character(4)	VARCHAR2(4) NOT NULL	Practical Grade
37	THEORY_GRADE_GER	Character(4)	VARCHAR2(4) NOT NULL	Theoretical Grade
38	GRANTOR	Character(20)	VARCHAR2(20) NOT NULL	The name of the person granting the award
39	END_DATE	Date(10)	DATE	End Date
40	BONUS_DT_FRA	Date(10)	DATE	Bonus Date
41	BONUS_AMOUNT_FRA	Number(8,2)	DECIMAL(7,2) NOT NULL	Bonus
42	GVT_CREDIT_HOURS	Character(3)	VARCHAR2(3) NOT NULL	Credit Hours
43	GVT_CRED_HRS_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Credit Hours Type C=Continuing Education O=Other Pay Q=Quarter Hours S=Semester Hours
44	GPA	Number(5,2)	DECIMAL(4,2) NOT NULL	GPA
45	YR_ACQUIRED	Number(4,0)	SMALLINT NOT NULL	Year Acquired
46	EDUC_LVL_AUS	Character(1)	VARCHAR2(1) NOT NULL	This field refers to the highest education attained by the member of staff. This is an Australia specific code which is needed for DETYA electronic reporting purposes. 0=Non-Academic 1=Higher Degree 2=Bachelor's Degree 3=Other 4=No Info
47	APS_HEDUC_CD_AUS	Character(2)	VARCHAR2(2) NOT NULL	The APS maintains a list of education codes that should be used for reporting purposes. Users should select the APS code to an existing education code in the system. 01=Doctorate 02=Masters 03=Postgraduate Diploma 04=Bachelor Degree 05=Undergraduate Diploma 06=Associate Diploma 07=Skilled Vocational Qualificatn 08=Basic Vocational Qualification 09=Year 12 (Higher School Cert) 11=Year 11 12=Year 10 (Leaving/School Cert) 13=Less than Year 10 97=Chose not to Give Default Value: 97
48	APS_MINOR_CODE_AUS	Character(10)	VARCHAR2(10) NOT NULL	Employee undertake multiple qualifications that can be classified as Major and Minor qualification. Minor code identifies the minor qualification undertaken by an employee. Prompt Table: MAJOR_TBL
49	APS_MINOR_AUS	Character(30)	VARCHAR2(30) NOT NULL	This field holds the description of the minor degree attained by an individual.
50	FP_SUBJECT_CD	Character(3)	VARCHAR2(3) NOT NULL	Subject Prompt Table: FPMSUBJECTS
51	FACULTY_CODE	Character(10)	VARCHAR2(10) NOT NULL	Faculty Code (Japan HR) Prompt Table: FACULTY_TBL_JPN
52	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
53	SUBFACULTY_CODE	Character(10)	VARCHAR2(10) NOT NULL	Sub Faculty Code(Japan HR) Prompt Table: SBFCLTY_TBL_JPN
54	SUBFACULTY_NAME	Character(50)	VARCHAR2(50) NOT NULL	Sub Faculty Name(Description)(Japan HR)
55	MAJOR_CATEGORY	Character(1)	VARCHAR2(1) NOT NULL	Major Category(Japan HR) H=Humanities S=Sciences