GPDE_AL_ERN_DED

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id
3	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
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	RSLT_SEG_NUM	Number(4,0)	SMALLINT NOT NULL	Result Segment Number
7	INSTANCE	Number(3,0)	SMALLINT NOT NULL	Instance Number
8	PIN_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number Prompt Table: %RECNAME_EDIT
9	ENTRY_TYPE_ELEM	Character(3)	VARCHAR2(3) NOT NULL	entry type element Prompt Table: GP_ENT_E_D_VW
10	SLICE_BGN_DT	Date(10)	DATE	Element Slice Begin Date
11	SLICE_END_DT	Date(10)	DATE	Element Slice End Date
12	CALC_RSLT_VAL	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Calculation Numeric Result
13	CALC_ADJ_VAL	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Calculation Adjustment Value
14	BASE_RSLT_VAL	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Calculated Base Value
15	BASE_ADJ_VAL	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Base Adjustment
16	RATE_RSLT_VAL	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Rate Result Value
17	UNIT_RSLT_VAL	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Number of units used in result calculation
18	UNIT_ADJ_VAL	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Unit Adjustment
19	PCT_RSLT_VAL	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Percent Result Value
20	RSLT_NOT_TKN	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Amount Not Taken
21	RSLT_ADD_ARR	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Amount Added To Arrears
22	RSLT_PAYBK	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Payback Amount Result
23	RSLT_XFER_VAL	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Bank Transfer Value of Deduct
24	FORCED_RECALC_IND	Character(1)	VARCHAR2(1) NOT NULL	Indicator field on Result table. A "Y" indicates that the value was recalculated during (a retro period) pay calc even though the definition says not to recalc. This may occur if the segments of the pay period differs between the original and the re-calced run. Y/N Table Edit Default Value: N