GP_PA_ERDD_TMP

(SQL Table)
Index Back

Payee Rpt for ERN/DED

Temporary table for the Earning Deduction Report Data Extract for Analytics.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
3 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id
4 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
5 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group
6 CAL_ID Character(18) VARCHAR2(18) NOT NULL calendar id
7 ORIG_CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Original Calendar Group ID
8 RSLT_SEG_NUM Number(4,0) SMALLINT NOT NULL Result Segment Number
9 GP_RPT_KEY Character(22) VARCHAR2(22) NOT NULL Output Result Key
10 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
11 RSLT_VER_NUM Number(4,0) SMALLINT NOT NULL Result Version Number
12 RSLT_REV_NUM Number(4,0) SMALLINT NOT NULL Result Revision Number
13 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
14 SLICE_BGN_DT Date(10) DATE Element Slice Begin Date
15 SLICE_END_DT Date(10) DATE Element Slice End Date
16 INSTANCE Number(3,0) SMALLINT NOT NULL Instance Number
17 GP_RPT_CAL_RUN Character(18) VARCHAR2(18) NOT NULL Calendar Run Id
18 GP_RPT_CAL_ID Character(18) VARCHAR2(18) NOT NULL calendar id
19 GP_RPT_ORIG_CAL Character(18) VARCHAR2(18) NOT NULL Field used in report generation from GP
20 GP_RPT_SEG_NUM Number(4,0) SMALLINT NOT NULL Field used in report generation from GP
21 GP_RPT_RETRO Character(1) VARCHAR2(1) NOT NULL Retroactivity Type
1=Original
2=Recalculation
3=Prior Calculation
4=Last Version/Revision
5=Result Delta - Corrective
6=Result Delta - Forwarded
22 GP_RPT_BGN_DT Date(10) DATE Payment begin date
23 GP_RPT_END_DT Date(10) DATE Payment end date
24 SEG_BGN_DT Date(10) DATE Payee Process Segment's Begin Date
25 SEG_END_DT Date(10) DATE Payee Process Segment's End Date
26 CALC_RSLT_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
27 CALC_ADJ_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Adjustment Value
28 CALC_DELTA_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount Delta
29 BASE_RSLT_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculated Base Value
30 BASE_ADJ_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Base Adjustment
31 BASE_DELTA_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Base Delta
32 UNIT_RSLT_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Number of units used in result calculation
33 UNIT_ADJ_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Unit Adjustment
34 UNIT_DELTA_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Unit Delta
35 RATE_RSLT_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Rate Result Value
36 PCT_RSLT_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Percent Result Value
37 RSLT_ADD_ARR Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount Added To Arrears
38 RSLT_PAYBK Signed Number(20,6) DECIMAL(18,6) NOT NULL Payback Amount Result
39 RSLT_NOT_TKN Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount Not Taken
40 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
41 FWD2_CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Forwarded To Cal Group
42 FWD2_CAL_ID Character(18) VARCHAR2(18) NOT NULL Forwarded to Calendar
43 GROUP_LIST_ID Character(10) VARCHAR2(10) NOT NULL Group List
44 STRM_NUM Number(4,0) SMALLINT NOT NULL Stream Number
45 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
46 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
47 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity
48 RUN_TYPE Character(10) VARCHAR2(10) NOT NULL Run Type Name
49 PYE_CALC_STAT Character(2) VARCHAR2(2) NOT NULL Calculation Status: field indicates the processing status of a segment (payment)
00=Identified
02=Calculation Error
03=Calculation Error - Bypassed
04=Calculation Error - By Rule
11=No Segment Created
50=Calculation Successful
55=Frozen For Further Calc
70=Finalized
75=Finalized - With Banking
50 PRC_ORD_TS DateTime(26) TIMESTAMP Process Order Timestamp
51 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
52 PYMT_DT Date(10) DATE Payment Date