GPDE_ALDLT_NRVW

(SQL View)
 Index Back

Retro Deltas

This contains the retro deltas generated for a payee.

SELECT EMPLID , CAL_RUN_ID , EMPL_RCD , GP_PAYGROUP , CAL_ID , RSLT_SEG_NUM , PIN_NUM + 50000000 , ENTRY_TYPE_ELEM , 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 FROM PS_GPDE_AL_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 RSLT_SEG_NUM Number(4,0) SMALLINT NOT NULL Result Segment Number
7 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number

Prompt Table: %RECNAME_EDIT

8 ENTRY_TYPE_ELEM Character(3) VARCHAR2(3) NOT NULL entry type element

Prompt Table: GP_ENT_NUMER_VW

9 CALC_DELTA_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount Delta
10 UNIT_DELTA_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Unit Delta
11 BASE_DELTA_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Base Delta
12 REPLACE_IND Character(1) VARCHAR2(1) NOT NULL Replace Indicator

Y/N Table Edit

Default Value: N

13 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

Default Value: N

14 RTO_MATCH_ACTN Character(1) VARCHAR2(1) NOT NULL Retro Delta Match Action
C=Apply to Calendar
D=Default Match
N=Do Not Process
15 TRGT_CAL_ID Character(18) VARCHAR2(18) NOT NULL Calendar to which retro deltas are targeted or forwarded
16 TRGT_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Pay group to which retro deltas are targeted or forwarded
17 PIN_RTO_ADJ_NUM Number(8,0) INTEGER NOT NULL Element number field
18 FWD2_CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Forwarded To Cal Group
19 FWD2_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Forwarded To Paygroup
20 FWD2_CAL_ID Character(18) VARCHAR2(18) NOT NULL Forwarded to Calendar
21 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity
22 PRC_ORD_TS DateTime(26) TIMESTAMP Process Order Timestamp
23 RUN_TYPE Character(10) VARCHAR2(10) NOT NULL Run Type Name
24 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
25 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
26 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
27 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
28 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
29 RSLT_VER_NUM Number(4,0) SMALLINT NOT NULL Result Version Number
30 RSLT_REV_NUM Number(4,0) SMALLINT NOT NULL Result Revision Number
31 ENTRY_TYPE_RTO_ADJ Character(3) VARCHAR2(3) NOT NULL Entry (element) type field