GPES_CC_EE_DTA

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
3	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
4	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
5	SSN_EMPLOYER	Character(13)	VARCHAR2(13) NOT NULL	Employer Social Security number Prompt Table: GPES_CCC_VW
6	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
7	GPES_SCHEME_CCC	Character(15)	VARCHAR2(15) NOT NULL	Scheme ID + SSN Employer.
8	RESPONSIBLE_ID	Character(11)	VARCHAR2(11) NOT NULL	Responsible ID Prompt Table: PERSON
9	JOBCODE_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Job Code Description
10	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
11	NATIONAL_ID	Character(20)	VARCHAR2(20) NOT NULL	National ID
12	SOC_SEC_WRK_GRP_CD	Character(2)	VARCHAR2(2) NOT NULL	Social Security Work Group
13	CONTRACT_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Contract Type
14	HIRE_DT	Date(10)	DATE	First Start Date
15	TERMINATION_DT	Date(10)	DATE	Termination Date
16	TERMINATION_REASON	Character(3)	VARCHAR2(3) NOT NULL	The action reason from the JOB row that terminated the employee. Used in discounts and perks eligibility file.
17	GPES_LITIG_DAYS	Character(5)	VARCHAR2(5) NOT NULL	Litigation salary days. Default Value: 00000
18	GPES_LITIG_BGN_DT	Date(10)	DATE	Litigation salary begin date.
19	GPES_LITIG_END_DT	Date(10)	DATE	Litigation salary end date.
20	GPES_VACTN_DAYS	Character(3)	VARCHAR2(3) NOT NULL	Paid vacation contribution days for terminations.
21	GPES_VACTN_BS_CC	Character(9)	VARCHAR2(9) NOT NULL	Common Contingencies Base for Paid Vacation for Terminations. Last two digits are the decimal part.
22	GPES_VACTN_BS_CP	Character(9)	VARCHAR2(9) NOT NULL	Professional contingencies base for paid vacation for terminations. Last two digits are the decimal part.
23	GPES_CNT_DURATION	Character(5)	VARCHAR2(5) NOT NULL	Contract Duration.
24	GPES_CNT_FREQ	Character(1)	VARCHAR2(1) NOT NULL	Contract Frequency Duration.
25	GPES_CNO_CODE_8	Character(8)	VARCHAR2(8) NOT NULL	National occupation code (CNO) 8 Digits
26	FISCAL_ID_CD	Character(10)	VARCHAR2(10) NOT NULL	Fiscal Identification Code
27	GPES_WRK_CNCL_FUNC	Character(4)	VARCHAR2(4) NOT NULL	Works council function.
28	GPES_CNCL_PCT	Character(4)	VARCHAR2(4) NOT NULL	Work council percentage.
29	GPES_ERE_ID	Character(9)	VARCHAR2(9) NOT NULL	ERE Identification code.
30	GPES_ERE_REDN_PCT	Character(4)	VARCHAR2(4) NOT NULL	ERE Reduction percentage.
31	GPES_ERE_SUS_ENDDT	Date(10)	DATE	ERE Suspension end date.
32	GPES_REDN_PCT_OTH	Character(4)	VARCHAR2(4) NOT NULL	Reduction percentage other.
33	GPES_REDN_RSN	Character(2)	VARCHAR2(2) NOT NULL	Reduction percentage reson.