GPNL_PS_ERN_TMP

(SQL Table)
Index Back

Ern/Ded App.engine

Payslip Ern/Ded App.Engine

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 JOBINSTANCE Number(10,0) DECIMAL(10) NOT NULL Job 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 RSLT_SEG_NUM Number(4,0) SMALLINT NOT NULL Result Segment Number
8 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
9 INSTANCE Number(3,0) SMALLINT NOT NULL Instance 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 BASE_RSLT_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculated Base Value
14 RATE_RSLT_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Rate Result Value
15 UNIT_RSLT_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Number of units used in result calculation
16 PCT_RSLT_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Percent Result Value
17 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
18 CURRENCY_CD2 Character(3) VARCHAR2(3) NOT NULL Currency Code
19 SRC_CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Source Calendar Run ID
20 SRC_CAL_ID Character(18) VARCHAR2(18) NOT NULL Source Calendar ID
21 RSLT_SEG_NUM2 Number(4,0) SMALLINT NOT NULL Copy of field RSLT_SEG_NUM used when multiple segment (payment) numbers are needed joined into a single view
22 DESCR15 Character(15) VARCHAR2(15) NOT NULL Short Description
23 GPNL_PAYSLIP_ID Character(6) VARCHAR2(6) NOT NULL Pay Slip Identification
24 GPNL_PIN_TYPE Character(3) VARCHAR2(3) NOT NULL Element Type
25 GPNL_ELEMENT_ORD Number(9,2) DECIMAL(8,2) NOT NULL Print Order of the element in payslip
26 GPNL_RETRO_TYPE Character(2) VARCHAR2(2) NOT NULL Retro Type
10=Current and Deltas
20=Current and Adjustment
30=One Line
27 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