GPDE_AL_ED_NRVW

(SQL View)
 Index Back

Result Table for ERN and DED

Result Table for ERN and DED

SELECT EMPLID , CAL_RUN_ID , EMPL_RCD , GP_PAYGROUP , CAL_ID , RSLT_SEG_NUM , INSTANCE , PIN_NUM + 50000000 , ENTRY_TYPE_ELEM , 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 , RSLT_NOT_TKN , RSLT_ADD_ARR , RSLT_PAYBK , RSLT_XFER_VAL , FORCED_RECALC_IND FROM PS_GPDE_AL_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 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

Prompt Table: %RECNAME_EDIT

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

Prompt Table: GP_ENT_E_D_VW

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 RSLT_NOT_TKN Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount Not Taken
21 RSLT_ADD_ARR Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount Added To Arrears
22 RSLT_PAYBK Signed Number(20,6) DECIMAL(18,6) NOT NULL Payback Amount Result
23 RSLT_XFER_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Bank Transfer Value of Deduct
24 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

Default Value: N