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)

GPGB_PSLIP_PU_H

(SQL View)

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 Rcd Nbr

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
A=Standard Not C/Out
A1=IOM - CATEGORY A
AA=Standard Not C/Out in APP
AA=Standard Not C/Out in APP
B=Reduced Not C/Out
BA=Reduced Not C/Out in APP
BA=Reduced Not C/Out in APP
C=Retirement Age Exemption
CA=Co Deferrment in APPS
CO=C/Out Deferment in COSR Scheme
D=Standard C/Out Salary Related
D1=IOM - CATEGORY D
E=Reduced C/Out Salary Related
F=Standard C/Out Money Purchase
F=Standard C/Out Money Purchase
G=Reduced C/Out Money Purchase
G=Reduced C/Out Money Purchase
J=Deferment Not C/Out
L=Deferment C/Out Salary Related
N=Contracted-OSR-standard rate
O=Contracted-OUS-reduced rate
Q=Deferment
R=Standard Rate
S=Deferment C/Out Money Purchase
S=Deferment C/Out Money Purchase
T=Reduced Rate
W=Over State Pension Age
X=Other Exemption

44 TAX_BASIS_UK Character(1) VARCHAR2(1) NOT NULL Tax Basis
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

#	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 Rcd Nbr
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 A=Standard Not C/Out A1=IOM - CATEGORY A AA=Standard Not C/Out in APP AA=Standard Not C/Out in APP B=Reduced Not C/Out BA=Reduced Not C/Out in APP BA=Reduced Not C/Out in APP C=Retirement Age Exemption CA=Co Deferrment in APPS CO=C/Out Deferment in COSR Scheme D=Standard C/Out Salary Related D1=IOM - CATEGORY D E=Reduced C/Out Salary Related F=Standard C/Out Money Purchase F=Standard C/Out Money Purchase G=Reduced C/Out Money Purchase G=Reduced C/Out Money Purchase J=Deferment Not C/Out L=Deferment C/Out Salary Related N=Contracted-OSR-standard rate O=Contracted-OUS-reduced rate Q=Deferment R=Standard Rate S=Deferment C/Out Money Purchase S=Deferment C/Out Money Purchase T=Reduced Rate W=Over State Pension Age X=Other Exemption
44	TAX_BASIS_UK	Character(1)	VARCHAR2(1) NOT NULL	Tax Basis 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