GPGB_PSLIP_SS_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_SS_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 B.OPRID , A.EMPLID , A.CAL_RUN_ID , A.EMPL_RCD , A.GP_PAYGROUP , A.CAL_ID , A.RSLT_SEG_NUM , D.PYMT_DT , 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 , 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 , PSOPRDEFN B , PS_GPGB_EE_RSLT C , PS_GP_PYE_PRC_STAT D WHERE A.CALC_ACTION = 'C' AND D.CALC_TYPE = 'P' AND A.EMPLID = B.EMPLID 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.EMPLID = D.EMPLID AND A.CAL_RUN_ID = D.CAL_RUN_ID AND A.EMPL_RCD = D.EMPL_RCD AND A.GP_PAYGROUP = D.GP_PAYGROUP AND A.CAL_ID = D.CAL_ID AND A.RSLT_REV_NUM = 1 AND A.RSLT_VER_NUM = ( SELECT MAX(RSLT_VER_NUM) FROM PS_GP_PYE_SEG_STAT A1 WHERE A1.EMPLID = A.EMPLID AND A1.CAL_RUN_ID = A.CAL_RUN_ID AND A1.EMPL_RCD = A.EMPL_RCD AND A1.GP_PAYGROUP = A.GP_PAYGROUP AND A1.CAL_ID = A.CAL_ID AND A1.RSLT_SEG_NUM = A.RSLT_SEG_NUM ) AND (A.PYE_CALC_STAT = '60' OR A.PYE_CALC_STAT = '65' OR A.PYE_CALC_STAT = '70' OR A.PYE_CALC_STAT = '75')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

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 PAYMENT_DT Date(10) DATE Payment Date

9 RSLT_VER_NUM Number(4,0) SMALLINT NOT NULL Result Version Number

10 RSLT_REV_NUM Number(4,0) SMALLINT NOT NULL Result Revision Number

11 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

12 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

13 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

14 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

15 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

16 SEG_BGN_DT Date(10) DATE Payee Process Segment's Begin Date

17 SEG_END_DT Date(10) DATE Payee Process Segment's End Date

18 CALC_ACTION Character(1) VARCHAR2(1) NOT NULL Calculate Action
C=Calculate
R=Calculate and Replace
V=Reverse
W=Reverse and Replace

19 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

20 GP_CALC_TS DateTime(26) TIMESTAMP Indicates when something (a segment) was calculated

21 SEG_STATUS Character(2) VARCHAR2(2) NOT NULL Segment Status
00=Active in Segment
01=Inactive in Segment

22 PIN_NET_NUM Number(8,0) INTEGER NOT NULL Element number field

23 PIN_NET_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Net Pay Value

24 PIN_GROSS_NUM Number(8,0) INTEGER NOT NULL Element number field

25 PIN_GROSS_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Gross Pay Value

26 CUR_RT_TYPE Character(5) VARCHAR2(5) NOT NULL Currency Rate Type

27 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

28 FRST_SEG_IND Character(1) VARCHAR2(1) NOT NULL First Segment Ind

29 LAST_SEG_IND Character(1) VARCHAR2(1) NOT NULL Last Segment Ind

30 SEG_SRC_ID Character(1) VARCHAR2(1) NOT NULL Segment Source
C=Calculate
I=Identify

31 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1

32 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2

33 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3

34 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4

35 COUNTY Character(30) VARCHAR2(30) NOT NULL County

36 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal

37 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

38 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

39 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code

40 COMPRATE Number(19,6) DECIMAL(18,6) NOT NULL Compensation Rate

41 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

42 TAX_CODE_UK Character(15) VARCHAR2(15) NOT NULL Tax Code for UK

43 NATIONAL_ID Character(20) VARCHAR2(20) NOT NULL National ID

44 GPGB_NI_CATEGORY Character(2) VARCHAR2(2) NOT NULL NI Category Code

45 TAX_BASIS_UK Character(1) VARCHAR2(1) NOT NULL Tax Basis for the UK
0=Cumulative
1=Week 1/Month 1

46 GPGB_TAX_PERIOD Number(3,0) SMALLINT NOT NULL Tax Period

47 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

48 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity

49 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.

50 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	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
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	PAYMENT_DT	Date(10)	DATE	Payment Date
9	RSLT_VER_NUM	Number(4,0)	SMALLINT NOT NULL	Result Version Number
10	RSLT_REV_NUM	Number(4,0)	SMALLINT NOT NULL	Result Revision Number
11	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
12	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
13	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
14	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
15	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
16	SEG_BGN_DT	Date(10)	DATE	Payee Process Segment's Begin Date
17	SEG_END_DT	Date(10)	DATE	Payee Process Segment's End Date
18	CALC_ACTION	Character(1)	VARCHAR2(1) NOT NULL	Calculate Action C=Calculate R=Calculate and Replace V=Reverse W=Reverse and Replace
19	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
20	GP_CALC_TS	DateTime(26)	TIMESTAMP	Indicates when something (a segment) was calculated
21	SEG_STATUS	Character(2)	VARCHAR2(2) NOT NULL	Segment Status 00=Active in Segment 01=Inactive in Segment
22	PIN_NET_NUM	Number(8,0)	INTEGER NOT NULL	Element number field
23	PIN_NET_VAL	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Net Pay Value
24	PIN_GROSS_NUM	Number(8,0)	INTEGER NOT NULL	Element number field
25	PIN_GROSS_VAL	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Gross Pay Value
26	CUR_RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Currency Rate Type
27	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
28	FRST_SEG_IND	Character(1)	VARCHAR2(1) NOT NULL	First Segment Ind
29	LAST_SEG_IND	Character(1)	VARCHAR2(1) NOT NULL	Last Segment Ind
30	SEG_SRC_ID	Character(1)	VARCHAR2(1) NOT NULL	Segment Source C=Calculate I=Identify
31	ADDRESS1	Character(55)	VARCHAR2(55) NOT NULL	Address 1
32	ADDRESS2	Character(55)	VARCHAR2(55) NOT NULL	Address 2
33	ADDRESS3	Character(55)	VARCHAR2(55) NOT NULL	Address 3
34	ADDRESS4	Character(55)	VARCHAR2(55) NOT NULL	Address 4
35	COUNTY	Character(30)	VARCHAR2(30) NOT NULL	County
36	POSTAL	Character(12)	VARCHAR2(12) NOT NULL	Postal
37	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
38	LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Location Code
39	JOBCODE	Character(6)	VARCHAR2(6) NOT NULL	Job Code
40	COMPRATE	Number(19,6)	DECIMAL(18,6) NOT NULL	Compensation Rate
41	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
42	TAX_CODE_UK	Character(15)	VARCHAR2(15) NOT NULL	Tax Code for UK
43	NATIONAL_ID	Character(20)	VARCHAR2(20) NOT NULL	National ID
44	GPGB_NI_CATEGORY	Character(2)	VARCHAR2(2) NOT NULL	NI Category Code
45	TAX_BASIS_UK	Character(1)	VARCHAR2(1) NOT NULL	Tax Basis for the UK 0=Cumulative 1=Week 1/Month 1
46	GPGB_TAX_PERIOD	Number(3,0)	SMALLINT NOT NULL	Tax Period
47	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
48	PAY_ENTITY	Character(10)	VARCHAR2(10) NOT NULL	Pay Entity
49	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.
50	GPGB_TAX_BGN_YR	Number(4,0)	SMALLINT NOT NULL	Tax Year Begins In This Calendar Year