GPES_F_BS_CNTRB

#	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	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id
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	SLICE_BGN_DT	Date(10)	DATE	Element Slice Begin Date
9	GPES_MONTH_PMNT	Number(2,0)	SMALLINT NOT NULL	Month in which an earning is paid.
10	GPES_YEAR_PMNT	Number(4,0)	SMALLINT NOT NULL	Year in which an earning is paid.
11	GPES_MONTH	Number(2,0)	SMALLINT NOT NULL	Month
12	GPES_YEAR	Number(4,0)	SMALLINT NOT NULL	Year
13	GPES_ORDINAL	Number(3,0)	SMALLINT NOT NULL	It allows several earnings accrued in more than one month (equal or different) in the process month.
14	PIN_NM	Character(18)	VARCHAR2(18) NOT NULL	Element Name field
15	ED_ASSIGN_INSTANCE	Number(3,0)	SMALLINT NOT NULL	Earn/Ded Assignment Instance
16	GPES_NBR_MONTHS	Number(3,0)	SMALLINT NOT NULL	Number of months to prorate the compensation accrued in more than one month.
17	GPES_TOTAL_F_BSE	Number(14,2)	DECIMAL(13,2) NOT NULL	Total amount corresponding to compensation accrued in more than one month
18	GPES_PEND_F_BSE	Number(14,2)	DECIMAL(13,2) NOT NULL	The pending amount to contribute corresponding to compensation accrued in more than one month
19	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Default Value: EUR Prompt Table: CURRENCY_CD_TBL
20	GPES_FLAG_F_BS	Number(1,0)	SMALLINT NOT NULL	Flag of Future base to contribute
21	RSLT_VER_NUM	Number(4,0)	SMALLINT NOT NULL	Result Version Number
22	RSLT_REV_NUM	Number(4,0)	SMALLINT NOT NULL	Result Revision Number