GP_NRP_RSERD_VW

(SQL View)
 Index Back

Result View for ERN and DED

Result Packaging View for ERN and DED

SELECT EMPLID ,CAL_RUN_ID ,EMPL_RCD ,GP_PAYGROUP ,CAL_ID ,ORIG_CAL_RUN_ID ,RSLT_SEG_NUM ,INSTANCE ,PIN_NUM + 50000000 ,SLICE_BGN_DT ,SLICE_END_DT ,CALC_RSLT_VAL ,CALC_ADJ_VAL ,BASE_RSLT_VAL ,BASE_ADJ_VAL ,RATE_RSLT_VAL ,UNIT_RSLT_VAL ,UNIT_ADJ_VAL ,PCT_RSLT_VAL ,RECIPIENT_ID ,RECIPIENT_TAG ,RSLT_NOT_TKN ,RSLT_ADD_ARR ,RSLT_PAYBK ,RSLT_XFER_VAL ,FORCED_RECALC_IND ,USER_FLD1 ,USER_FLD2 ,USER_FLD3 ,USER_FLD4 ,USER_FLD5 ,USER_FLD6 ,ED_ASSIGN_INSTANCE ,PI_INSTANCE ,DRIVER_EXISTS_IND ,CALC_RSLT_SRC ,BASE_RSLT_SRC ,PCT_RSLT_SRC ,RATE_RSLT_SRC ,UNIT_RSLT_SRC FROM PS_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

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