GPGB_EE_PENSION

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSON
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
3	PAY_ENTITY	Character(10)	VARCHAR2(10) NOT NULL	Pay Entity
4	GP_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Global Payroll pay group
5	GPGB_QPEN_SCHEME	Character(10)	VARCHAR2(10) NOT NULL	Pension Scheme for GBR Prompt Table: GPGB_PEN_SCM_VW
6	GPGB_PEN_SCHEME	Character(4)	VARCHAR2(4) NOT NULL	Pension Scheme Code AVC1=AVC1 FIXA=Fixed Scheme A PCTB=Percentage Scheme B
7	START_DATE	Date(10)	DATE NOT NULL	Start Date for Gen Standing PO
8	GPGB_EE_PCTG_CONT	Number(6,2)	DECIMAL(5,2) NOT NULL	Employee's Percentage Contribution
9	GPGB_ER_PCTG_CONT	Number(6,2)	DECIMAL(5,2) NOT NULL	Employer's Percentage Contribution
10	GPGB_EE_PEN_AMT	Number(10,2)	DECIMAL(9,2) NOT NULL	Employers Flat Amount Contribution
11	GPGB_ER_PEN_AMT	Number(10,2)	DECIMAL(9,2) NOT NULL	Employers Pension Fixed Amount
12	END_DATE	Date(10)	DATE	End Date
13	GPGB_AUTO_ENROLL	Character(1)	VARCHAR2(1) NOT NULL	Auto Enrollment Flag for GBR 0=NO 1=YES
14	GPGB_PEN_REFUND	Character(1)	VARCHAR2(1) NOT NULL	Refund Flag for GBR 0=NO 1=YES
15	GPGB_OPTOUT_ST_DT	Date(10)	DATE	GBR pension optout start date field
16	GPGB_OPTOUT_END_DT	Date(10)	DATE	GBR pension optout date field
17	STATUS	Character(1)	VARCHAR2(1) NOT NULL	Status Indicator A=Active I=Inactive Default Value: A