GPFR_RSLT_GC_VW

(SQL View)
 Index Back

Result view: Gen PI Current

Result Table for generated positive inputs. View for the current calculation

SELECT 'CURRENT' , G.EMPLID , G.EMPL_RCD , G.CAL_RUN_ID , G.GP_PAYGROUP , G.CAL_ID , G.ORIG_CAL_RUN_ID , G.RSLT_SEG_NUM , G.PYMT_KEY1 , G.PYMT_KEY2 , G.PYMT_KEY3 , G.PYMT_KEY4 , G.CALC_ACTION , G.PRD_TYPE , G.CURRENCY_CD , G.CURRENCY_CD , B.SRC_CAL_RUN_ID , B.SRC_CAL_ID , 0 , A.RSLT_VER_NUM , A.RSLT_REV_NUM , B.ABS_BGN_DT , B.PIN_TK_NUM , B.PIN_NUM , B.GP_RATE , B.GP_UNIT , B.GP_BASE , B.GP_PCT , B.GP_AMT FROM PS_GP_PYE_SEG_STAT A , PS_GP_PI_GEN_DATA B , PS_GPFR_GUIDE_VW G WHERE A.EMPLID = B.EMPLID AND A.EMPL_RCD = B.EMPL_RCD AND A.CAL_RUN_ID = B.SRC_CAL_RUN_ID AND A.GP_PAYGROUP = B.GP_PAYGROUP AND A.CAL_ID = B.CAL_ID AND A.EMPLID = G.EMPLID AND A.EMPL_RCD = G.EMPL_RCD AND A.GP_PAYGROUP = G.GP_PAYGROUP AND A.CAL_ID = G.CAL_ID AND A.CAL_RUN_ID = G.CAL_RUN_ID AND A.ORIG_CAL_RUN_ID = G.ORIG_CAL_RUN_ID AND A.RSLT_SEG_NUM= G.RSLT_SEG_NUM AND A.PYMT_KEY1 = G.PYMT_KEY1 AND A.PYMT_KEY2 = G.PYMT_KEY2 AND A.PYMT_KEY3 = G.PYMT_KEY3 AND A.PYMT_KEY4 = G.PYMT_KEY4

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 DESCR15 Character(15) VARCHAR2(15) NOT NULL Short Description
2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
3 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
4 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id
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 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
10 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
11 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
12 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
13 CALC_ACTION Character(1) VARCHAR2(1) NOT NULL Calculate Action
C=Calculate
R=Calculate and Replace
V=Reverse
W=Reverse and Replace
14 PRD_TYPE Character(1) VARCHAR2(1) NOT NULL Period Type
C=Current
R=Retro
15 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
16 CURRENCY_CD2 Character(3) VARCHAR2(3) NOT NULL Currency Code
17 SRC_CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Source Calendar Run ID
18 SRC_CAL_ID Character(18) VARCHAR2(18) NOT NULL Source Calendar ID
19 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
20 RSLT_VER_NUM Number(4,0) SMALLINT NOT NULL Result Version Number
21 RSLT_REV_NUM Number(4,0) SMALLINT NOT NULL Result Revision Number
22 ABS_BGN_DT Date(10) DATE Absence Begin Date
23 PIN_TK_NUM Number(8,0) INTEGER NOT NULL Element number field
24 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
25 GP_RATE Signed Number(20,6) DECIMAL(18,6) NOT NULL Rate
26 GP_UNIT Signed Number(20,6) DECIMAL(18,6) NOT NULL Unit
27 GP_BASE Signed Number(20,6) DECIMAL(18,6) NOT NULL Base
28 GP_PCT Signed Number(11,6) DECIMAL(9,6) NOT NULL Percent
29 GP_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount