GPFR_ILL_WAGES

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
3	ORIG_BEGIN_DT	Date(10)	DATE	original begin date
4	GPFR_ILL_REASON	Character(1)	VARCHAR2(1) NOT NULL	Different families of absence codes 1=Illness 2=Maternity 3=Paternity
5	GPFR_ASS_PPAY_FDT	Date(10)	DATE	GPFR: Begin Date of Period Pay
6	GPFR_ASS_PPAY_TDT	Date(10)	DATE	GPFR: End Date of Period Pay
7	GROSS_PAY	Number(9,2)	DECIMAL(8,2) NOT NULL	GPFR: Gross pay
8	GPFR_ILL_EURO_1	Character(1)	VARCHAR2(1) NOT NULL	GPFR: Payment in Euro Y/N Table Edit Default Value: N
9	GPFR_ILL_EURO	Character(1)	VARCHAR2(1) NOT NULL	GPFR: Payment in Euro Y/N Table Edit
10	GPFR_ILL_ABS_CD	Character(7)	VARCHAR2(7) NOT NULL	Used on the Illness certificate, coming from the absence setup for the reports Prompt Table: GPFR_ILL_C6_VW
11	GPFR_ASS_NBRWRKHRS	Number(6,2)	DECIMAL(5,2) NOT NULL	GPFR: Nbr of Worked Hours
12	GPFR_ILL_COMHRS	Number(6,2)	DECIMAL(5,2) NOT NULL	GPFR: Nbr of Hoursequal to Full Time
13	GPFR_ILL_CALC_SAL	Number(12,2)	DECIMAL(11,2) NOT NULL	GPFR: Calculated Wage
14	GPFR_ILL_EURO_2	Character(1)	VARCHAR2(1) NOT NULL	GPFR: Payment in Euro Y/N Table Edit Default Value: N
15	GPFR_ILL_EURO_3	Character(1)	VARCHAR2(1) NOT NULL	Payment in Euro Y/N Table Edit