GPDE_RP_COOP_WK

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PAY_ENTITY	Character(10)	VARCHAR2(10) NOT NULL	Pay Entity
2	ACCIDENT_INS	Character(15)	VARCHAR2(15) NOT NULL	Accident Insurance Default Value: DEPT_TBL.ACCIDENT_INS
3	SI_ACCIDENT_NUM	Character(15)	VARCHAR2(15) NOT NULL	Social Insurance Accident Nbr
4	HAZARD	Character(8)	VARCHAR2(8) NOT NULL	Hazard Prompt Table: ACCDT_INS_HAZ
5	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
6	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
7	HIRE_DT	Date(10)	DATE	First Start Date
8	TERMINATION_DT	Date(10)	DATE	Termination Date
9	PRD_END_DT	Date(10)	DATE	Pay Period End Date
10	SEG_END_DT	Date(10)	DATE	Payee Process Segment's End Date
11	GP_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Global Payroll pay group
12	GPDE_RP_A2_9190	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Total of Gross
13	GPDE_RP_WRKDHRS	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Total of Worked Hours
14	GPDE_SI_MX_ACC_INC	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Accident Insurance Limit
15	PERFORM_GROUP_GER	Character(2)	VARCHAR2(2) NOT NULL	This field is used for German employees to track the Performance Group associated to the Job Labor agreement. A1=Blue Collar Performance Grp. 1 A2=Blue Collar Performance Grp. 2 A3=Blue Collar Performance Grp. 3 K1=Commercial White Collar Grp. 1 K2=Commercial White Collar Grp. 2 K3=Commercial White Collar Grp. 3 K4=Commercial White Collar Grp. 4 K5=Commerical White Collar Grp. 5 T1=Technical White Collar Grp. 1 T2=Technical White Collar Grp. 2 T3=Technical White Collar Grp. 3 T4=Technical White Collar Grp. 4 T5=Technical White Collar Grp. 5