GPFR_RSLT_E3_VW (SQL View)	Index Back
Result view: Ern/Ded/Delta Result Table for earnings and deductions and deltas - Part 3

GPFR_RSLT_E3_VW

(SQL View)

Result view: Ern/Ded/Delta

Result Table for earnings and deductions and deltas - Part 3

SELECT B.EMPLID ,B.CAL_RUN_ID ,B.EMPL_RCD ,B.GP_PAYGROUP ,B.CAL_ID ,B.RSLT_SEG_NUM ,0 ,A.PIN_RTO_ADJ_NUM ,D.SEG_BGN_DT ,D.SEG_END_DT ,A.CALC_DELTA_VAL ,0 ,A.BASE_DELTA_VAL ,0 ,0 ,A.UNIT_DELTA_VAL ,0 ,0 ,0 ,0 ,0 ,0 ,' ' ,A.CAL_ID ,A.RSLT_SEG_NUM ,'C' FROM PS_GP_RSLT_DELTA A , PS_GP_PYE_SEG_STAT B , PS_GP_PYE_SEG_STAT D WHERE A.EMPLID = B.EMPLID AND A.CAL_RUN_ID = B.CAL_RUN_ID AND A.EMPL_RCD = B.EMPL_RCD AND A.GP_PAYGROUP = B.GP_PAYGROUP AND A.REPLACE_IND = 'Y' AND A.PYMT_KEY1 = B.PYMT_KEY1 AND A.PYMT_KEY2 = B.PYMT_KEY2 AND A.PYMT_KEY3 = B.PYMT_KEY3 AND A.PYMT_KEY4 = B.PYMT_KEY4 AND B.CALC_ACTION = 'C' AND B.RSLT_VER_NUM = 1 AND B.RSLT_REV_NUM = 1 AND B.RSLT_SEG_NUM = ( SELECT MIN(C.RSLT_SEG_NUM) FROM PS_GP_PYE_SEG_STAT C WHERE C.EMPLID = B.EMPLID AND C.CAL_RUN_ID = B.CAL_RUN_ID AND C.EMPL_RCD = B.EMPL_RCD AND C.GP_PAYGROUP = B.GP_PAYGROUP AND C.CAL_ID = B.CAL_ID AND C.PYMT_KEY1 = B.PYMT_KEY1 AND C.PYMT_KEY2 = B.PYMT_KEY2 AND C.PYMT_KEY3 = B.PYMT_KEY3 AND C.PYMT_KEY4 = B.PYMT_KEY4) AND A.EMPLID = D.EMPLID AND A.CAL_RUN_ID = D.CAL_RUN_ID AND A.EMPL_RCD = D.EMPL_RCD AND A.GP_PAYGROUP = D.GP_PAYGROUP AND A.CAL_ID = D.CAL_ID AND A.RSLT_SEG_NUM = D.RSLT_SEG_NUM

# 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

9 SLICE_BGN_DT Date(10) DATE Element Slice Begin Date

10 SLICE_END_DT Date(10) DATE Element Slice End Date

11 CALC_RSLT_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result

12 CALC_ADJ_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Adjustment Value

13 BASE_RSLT_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculated Base Value

14 BASE_ADJ_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Base Adjustment

15 RATE_RSLT_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Rate Result Value

16 UNIT_RSLT_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Number of units used in result calculation

17 UNIT_ADJ_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Unit Adjustment

18 PCT_RSLT_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Percent Result Value

19 RSLT_NOT_TKN Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount Not Taken

20 RSLT_ADD_ARR Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount Added To Arrears

21 RSLT_PAYBK Signed Number(20,6) DECIMAL(18,6) NOT NULL Payback Amount Result

22 RSLT_XFER_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Bank Transfer Value of Deduct

23 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

24 GPFR_CAL_ID Character(18) VARCHAR2(18) NOT NULL GPFR: Calendar ID

25 GPFR_RSLT_SEG_NUM Number(4,0) SMALLINT NOT NULL Used in the view giving the earnings and the deductions with retro

26 GPFR_ORIGIN_FLAG Character(1) VARCHAR2(1) NOT NULL Indicates if the result comes from a normal calculation, or a retro
C=Corrective delta
E=Earning or deduction
F=Forwarded delta
M=Retro net to be paid (minus)
P=Retro to be paid (plus)

#	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
9	SLICE_BGN_DT	Date(10)	DATE	Element Slice Begin Date
10	SLICE_END_DT	Date(10)	DATE	Element Slice End Date
11	CALC_RSLT_VAL	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Calculation Numeric Result
12	CALC_ADJ_VAL	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Calculation Adjustment Value
13	BASE_RSLT_VAL	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Calculated Base Value
14	BASE_ADJ_VAL	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Base Adjustment
15	RATE_RSLT_VAL	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Rate Result Value
16	UNIT_RSLT_VAL	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Number of units used in result calculation
17	UNIT_ADJ_VAL	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Unit Adjustment
18	PCT_RSLT_VAL	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Percent Result Value
19	RSLT_NOT_TKN	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Amount Not Taken
20	RSLT_ADD_ARR	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Amount Added To Arrears
21	RSLT_PAYBK	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Payback Amount Result
22	RSLT_XFER_VAL	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Bank Transfer Value of Deduct
23	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
24	GPFR_CAL_ID	Character(18)	VARCHAR2(18) NOT NULL	GPFR: Calendar ID
25	GPFR_RSLT_SEG_NUM	Number(4,0)	SMALLINT NOT NULL	Used in the view giving the earnings and the deductions with retro
26	GPFR_ORIGIN_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Indicates if the result comes from a normal calculation, or a retro C=Corrective delta E=Earning or deduction F=Forwarded delta M=Retro net to be paid (minus) P=Retro to be paid (plus)