GP_NRP_RSDLT_VW

(SQL View)
 Index Back

Retro Deltas - View

This contains the retro deltas generated for a payee - Packaging View

SELECT EMPLID ,CAL_RUN_ID ,EMPL_RCD ,GP_PAYGROUP ,CAL_ID ,ORIG_CAL_RUN_ID ,RSLT_SEG_NUM ,PIN_NUM + 50000000 ,DELTA_NUM ,CALC_DELTA_VAL ,UNIT_DELTA_VAL ,BASE_DELTA_VAL ,REPLACE_IND ,FORWARD_IND ,RTO_MATCH_ACTN ,TRGT_CAL_ID ,TRGT_PAYGROUP ,PIN_RTO_ADJ_NUM + 50000000 ,FWD2_CAL_RUN_ID ,FWD2_PAYGROUP ,FWD2_CAL_ID ,PAY_ENTITY ,PRC_ORD_TS ,RUN_TYPE ,CURRENCY_CD ,PYMT_KEY1 ,PYMT_KEY2 ,PYMT_KEY3 ,PYMT_KEY4 ,RSLT_VER_NUM ,RSLT_REV_NUM ,ENTRY_TYPE_RTO_ADJ ,USER_FLD1 ,USER_FLD2 ,USER_FLD3 ,USER_FLD4 ,USER_FLD5 ,USER_FLD6 FROM PS_GP_RSLT_DELTA

# 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 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
9 DELTA_NUM Number(3,0) SMALLINT NOT NULL Uniquely defined deltas for the same payee/pin
10 CALC_DELTA_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount Delta
11 UNIT_DELTA_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Unit Delta
12 BASE_DELTA_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Base Delta
13 REPLACE_IND Character(1) VARCHAR2(1) NOT NULL Replace Indicator

Y/N Table Edit

14 FORWARD_IND Character(1) VARCHAR2(1) NOT NULL Y/N indicates whether the delta from a retroactive recalc should be forwarded into the current calculation or not

Y/N Table Edit

15 RTO_MATCH_ACTN Character(1) VARCHAR2(1) NOT NULL Retro Delta Match Action
C=Apply to Calendar
D=Default Match
N=Do Not Process
16 TRGT_CAL_ID Character(18) VARCHAR2(18) NOT NULL Calendar to which retro deltas are targeted or forwarded
17 TRGT_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Pay group to which retro deltas are targeted or forwarded
18 PIN_RTO_ADJ_NUM Number(8,0) INTEGER NOT NULL Element number field
19 FWD2_CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Forwarded To Cal Group
20 FWD2_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Forwarded To Paygroup
21 FWD2_CAL_ID Character(18) VARCHAR2(18) NOT NULL Forwarded to Calendar
22 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity
23 PRC_ORD_TS DateTime(26) TIMESTAMP Process Order Timestamp
24 RUN_TYPE Character(10) VARCHAR2(10) NOT NULL Run Type Name
25 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
26 PYMT_KEY1 Character(25) VARCHAR2(25) NOT NULL Payment key field. Used for optional tracking of a payment per Department, Company, Establishment or Contract Number
27 PYMT_KEY2 Character(25) VARCHAR2(25) NOT NULL Payment key field. Used for optional tracking of a payment per Department, Company, Establishment or Contract Number
28 PYMT_KEY3 Character(25) VARCHAR2(25) NOT NULL Payment key field. Used for optional tracking of a payment per Department, Company, Establishment or Contract Number
29 PYMT_KEY4 Character(25) VARCHAR2(25) NOT NULL Payment key field. Used for optional tracking of a payment per Department, Company, Establishment or Contract Number
30 RSLT_VER_NUM Number(4,0) SMALLINT NOT NULL Result Version Number
31 RSLT_REV_NUM Number(4,0) SMALLINT NOT NULL Result Revision Number
32 ENTRY_TYPE_RTO_ADJ Character(3) VARCHAR2(3) NOT NULL Entry (element) type field
33 USER_FLD1 Character(25) VARCHAR2(25) NOT NULL User Field 1
34 USER_FLD2 Character(25) VARCHAR2(25) NOT NULL User Field 2
35 USER_FLD3 Character(25) VARCHAR2(25) NOT NULL User Field 3
36 USER_FLD4 Character(25) VARCHAR2(25) NOT NULL User Field 4
37 USER_FLD5 Character(25) VARCHAR2(25) NOT NULL User FIeld 5
38 USER_FLD6 Character(25) VARCHAR2(25) NOT NULL User Field 6