GPGB_PSLIP_PU_H

(SQL View)
 Index Back

Self Service Payslip Header

This is the parent record for the on-line payslip. It is a view based on the record GP_PYE_SEG_STAT Modified by Jo Maye 27/7/2001. Modified peoplecode to use SEG accumulators for Net and gross (JMAYE)

SELECT A.EMPLID , A.CAL_RUN_ID , A.EMPL_RCD , A.GP_PAYGROUP , A.CAL_ID , A.RSLT_SEG_NUM , A.RSLT_VER_NUM , A.RSLT_REV_NUM , A.PYMT_KEY1 , A.PYMT_KEY2 , A.PYMT_KEY3 , A.PYMT_KEY4 , A.BUSINESS_UNIT ,A.SEG_BGN_DT ,A.SEG_END_DT , A.CALC_ACTION , A.PYE_CALC_STAT , A.GP_CALC_TS , A.SEG_STATUS , A.PIN_NET_NUM , A.PIN_NET_VAL ,A.PIN_GROSS_NUM , A.PIN_GROSS_VAL , A.CUR_RT_TYPE , A.GP_ASOF_DT_EXG_RT , A.FRST_SEG_IND , A.LAST_SEG_IND , A.SEG_SRC_ID , B.SEL_ACTION , C.address1 , C.address2 , C.address3 , C.address4 , C.county , C.postal , C.deptid ,C.location , C.jobcode , C.comprate , C.comp_frequency , C.tax_code_uk , C.national_id , C.gpgb_ni_category , C.tax_basis_uk , C.gpgb_tax_period , C.company , C.pay_entity , C.frequency_id ,C.gpgb_tax_bgn_yr FROM PS_GP_PYE_SEG_STAT A , PS_GP_PYE_PRC_STAT B , PS_GPGB_EE_RSLT C WHERE A.EMPLID = B.EMPLID AND A.CAL_RUN_ID=B.CAL_RUN_ID AND A.EMPL_RCD=B.EMPL_RCD AND A.GP_PAYGROUP=B.GP_PAYGROUP AND A.CAL_ID=B.CAL_ID AND A.EMPLID = C.EMPLID AND A.CAL_RUN_ID=C.CAL_RUN_ID AND A.EMPL_RCD=C.EMPL_RCD AND A.GP_PAYGROUP=C.GP_PAYGROUP AND A.CAL_ID=C.CAL_ID AND A.RSLT_SEG_NUM=C.RSLT_SEG_NUM AND A.CALC_ACTION='C' AND B.CALC_TYPE = 'P'

# 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 RSLT_VER_NUM Number(4,0) SMALLINT NOT NULL Result Version Number
8 RSLT_REV_NUM Number(4,0) SMALLINT NOT NULL Result Revision 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 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
14 SEG_BGN_DT Date(10) DATE Payee Process Segment's Begin Date
15 SEG_END_DT Date(10) DATE Payee Process Segment's End Date
16 CALC_ACTION Character(1) VARCHAR2(1) NOT NULL Calculate Action
C=Calculate
R=Calculate and Replace
V=Reverse
W=Reverse and Replace
17 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
18 GP_CALC_TS DateTime(26) TIMESTAMP Indicates when something (a segment) was calculated
19 SEG_STATUS Character(2) VARCHAR2(2) NOT NULL Segment Status
00=Active in Segment
01=Inactive in Segment
20 PIN_NET_NUM Number(8,0) INTEGER NOT NULL Element number field
21 PIN_NET_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Net Pay Value
22 PIN_GROSS_NUM Number(8,0) INTEGER NOT NULL Element number field
23 PIN_GROSS_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Gross Pay Value
24 CUR_RT_TYPE Character(5) VARCHAR2(5) NOT NULL Currency Rate Type
25 GP_ASOF_DT_EXG_RT Character(1) VARCHAR2(1) NOT NULL This field is used as a flag to determine whether to use a default exchange rate or not.
B=Pay Period Begin Date
E=Pay Period End Date
P=Payment Date
26 FRST_SEG_IND Character(1) VARCHAR2(1) NOT NULL First Segment Ind
27 LAST_SEG_IND Character(1) VARCHAR2(1) NOT NULL Last Segment Ind
28 SEG_SRC_ID Character(1) VARCHAR2(1) NOT NULL Segment Source
C=Calculate
I=Identify
29 SEL_ACTION Character(1) VARCHAR2(1) NOT NULL Select Action
A=Retro Add
C=Current Calculation
R=Retro Recalc
V=Retro Reversal
Z=Retro Rvr & Recalc
30 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
31 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
32 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
33 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
34 COUNTY Character(30) VARCHAR2(30) NOT NULL County
35 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
36 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
37 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
38 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code
39 COMPRATE Number(19,6) DECIMAL(18,6) NOT NULL Compensation Rate
40 COMP_FREQUENCY Character(5) VARCHAR2(5) NOT NULL Compensation Frequency
A=Annual
B=Biweekly
C=Contract
D=Daily
H=Hourly
M=Monthly
S=Semimonthly
W=Weekly
41 TAX_CODE_UK Character(15) VARCHAR2(15) NOT NULL Tax Code for UK
42 NATIONAL_ID Character(20) VARCHAR2(20) NOT NULL National ID
43 GPGB_NI_CATEGORY Character(2) VARCHAR2(2) NOT NULL NI Category Code
44 TAX_BASIS_UK Character(1) VARCHAR2(1) NOT NULL Tax Basis for the UK
0=Cumulative
1=Week 1/Month 1
45 GPGB_TAX_PERIOD Number(3,0) SMALLINT NOT NULL Tax Period
46 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
47 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity
48 FREQUENCY_ID Character(5) VARCHAR2(5) NOT NULL Defines a frequency and a set of parameters used for frequency conversion. Typically, these frequencies reflect how often an event occurs. Some examples are compensation frequency and pay frequency.
49 GPGB_TAX_BGN_YR Number(4,0) SMALLINT NOT NULL Tax Year Begins In This Calendar Year