GPES_PP_RSLT

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: %EDITTABLE2
2	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id
3	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record Prompt Table: EMPLOYMENT
4	GP_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Global Payroll pay group
5	CAL_ID	Character(18)	VARCHAR2(18) NOT NULL	calendar id
6	ORIG_CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Original Calendar Group ID
7	RSLT_SEG_NUM	Number(4,0)	SMALLINT NOT NULL	Result Segment Number
8	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company Prompt Table: COMPANY_TBL
9	GPES_TAX_LOCATION	Character(5)	VARCHAR2(5) NOT NULL	Fiscal Territory. This field is used to populate the GP Write Array, which is used to generate the Tax Reports. Prompt Table: GPES_TAX_LOCATN
10	GPES_YEAR	Number(4,0)	SMALLINT NOT NULL	Year
11	GPES_MONTH	Number(2,0)	SMALLINT NOT NULL	Month
12	GPES_PP_ID	Character(10)	VARCHAR2(10) NOT NULL	Pension Plan Identifier
13	PAY_END_DT	Date(10)	DATE	Pay Period End Date
14	GPES_FISCAL_KEY	Character(2)	VARCHAR2(2) NOT NULL	Fiscal key. Used to identify the earnings. Prompt Table: GPES_PERCEP_KEY
15	GPES_FISCAL_SUBKEY	Character(2)	VARCHAR2(2) NOT NULL	Fiscal sub-key. Used to identify the earnings. Prompt Table: GPES_PERCP_SKEY
16	GPES_PP_FUND_PRVDR	Character(5)	VARCHAR2(5) NOT NULL	Pension plan provider
17	GPES_SALARY_INCOME	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Salary Income.
18	GPES_PP_REDCTN_OPT	Character(1)	VARCHAR2(1) NOT NULL	RDL 12/22 pension plan reducion flag Y/N Table Edit Default Value: N
19	GPES_PP_CNTRIBUTOR	Character(1)	VARCHAR2(1) NOT NULL	Pension Plan Contributor C=Company E=Employee Default Value: C
20	RSLT_VER_NUM	Number(4,0)	SMALLINT NOT NULL	Result Version Number
21	RSLT_REV_NUM	Number(4,0)	SMALLINT NOT NULL	Result Revision Number