GP_RSLT_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 Record
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	INSTANCE	Number(3,0)	SMALLINT NOT NULL	Instance Number
9	PIN_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number
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	RECIPIENT_ID	Character(8)	VARCHAR2(8) NOT NULL	Payment recipient ID
21	RECIPIENT_TAG	Number(3,0)	SMALLINT NOT NULL	Used to identify recipients for E/D, PI
22	RSLT_NOT_TKN	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Amount Not Taken
23	RSLT_ADD_ARR	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Amount Added To Arrears
24	RSLT_PAYBK	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Payback Amount Result
25	RSLT_XFER_VAL	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Bank Transfer Value of Deduct
26	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
27	USER_FLD1	Character(25)	VARCHAR2(25) NOT NULL	User Field 1
28	USER_FLD2	Character(25)	VARCHAR2(25) NOT NULL	User Field 2
29	USER_FLD3	Character(25)	VARCHAR2(25) NOT NULL	User Field 3
30	USER_FLD4	Character(25)	VARCHAR2(25) NOT NULL	User Field 4
31	USER_FLD5	Character(25)	VARCHAR2(25) NOT NULL	User FIeld 5
32	USER_FLD6	Character(25)	VARCHAR2(25) NOT NULL	User Field 6
33	ED_ASSIGN_INSTANCE	Number(3,0)	SMALLINT NOT NULL	Earn/Ded Assignment Instance
34	PI_INSTANCE	Number(3,0)	SMALLINT NOT NULL	Positive Input Instance
35	DRIVER_EXISTS_IND	Character(1)	VARCHAR2(1) NOT NULL	Driver Accumulator Row Exists during resolution indicator Y/N Table Edit Default Value: N
36	CALC_RSLT_SRC	Character(1)	VARCHAR2(1) NOT NULL	Source of Amount or Calculated Result A=Assigned via Element E=Earn Ded Assignment F=Post Formula N=Not Applicable P=Positive Input R=Rule Definition
37	BASE_RSLT_SRC	Character(1)	VARCHAR2(1) NOT NULL	Source of Base on Result A=Assigned via Element E=Earn Ded Assignment F=Post Formula N=Not Applicable P=Positive Input R=Rule Definition
38	PCT_RSLT_SRC	Character(1)	VARCHAR2(1) NOT NULL	Source of Percent on Result A=Assigned via Element E=Earn Ded Assignment F=Post Formula N=Not Applicable P=Positive Input R=Rule Definition
39	RATE_RSLT_SRC	Character(1)	VARCHAR2(1) NOT NULL	Source of Rate on Result A=Assigned via Element E=Earn Ded Assignment F=Post Formula N=Not Applicable P=Positive Input R=Rule Definition
40	UNIT_RSLT_SRC	Character(1)	VARCHAR2(1) NOT NULL	Source of Unit on Result A=Assigned via Element E=Earn Ded Assignment F=Post Formula N=Not Applicable P=Positive Input R=Rule Definition