GPFR_GUIDE_VW (SQL View)	Index Back
Payees segm. list for reports Payees segments list for reports

GPFR_GUIDE_VW

(SQL View)

Payees segm. list for reports

Payees segments list for reports

SELECT B.EMPLID , B.EMPL_RCD , B.CAL_RUN_ID , B.GP_PAYGROUP , B.CAL_ID , B.ORIG_CAL_RUN_ID , B.RSLT_SEG_NUM , B.PYMT_KEY1 , B.PYMT_KEY2 , B.PYMT_KEY3 , B.PYMT_KEY4 , B.CALC_ACTION , A.PRD_TYPE , A.CURRENCY_CD FROM PS_GP_PYE_PRC_STAT A , PS_GP_PYE_SEG_STAT B 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.ORIG_CAL_RUN_ID = B.ORIG_CAL_RUN_ID AND A.CALC_TYPE = 'P' AND (A.PRD_TYPE = 'C' OR A.PRD_TYPE = 'R' AND NOT EXISTS ( SELECT 'X' FROM PS_GP_PYE_SEG_STAT C , PS_GP_PYE_PRC_STAT D WHERE C.EMPLID = D.EMPLID AND C.CAL_RUN_ID = D.CAL_RUN_ID AND C.EMPL_RCD = D.EMPL_RCD AND C.GP_PAYGROUP = D.GP_PAYGROUP AND C.CAL_ID = D.CAL_ID AND C.ORIG_CAL_RUN_ID = D.ORIG_CAL_RUN_ID AND D.CALC_TYPE = 'P' AND D.PRD_TYPE = 'C' AND C.EMPLID = A.EMPLID AND C.CAL_RUN_ID = A.CAL_RUN_ID AND C.EMPL_RCD = A.EMPL_RCD AND C.GP_PAYGROUP = A.GP_PAYGROUP AND C.PYMT_KEY1 = B.PYMT_KEY1 AND C.PYMT_KEY2 = B.PYMT_KEY2 AND C.PYMT_KEY3 = B.PYMT_KEY3 AND C.PYMT_KEY4 = B.PYMT_KEY4 ) AND B.RSLT_SEG_NUM = ( SELECT MIN(E.RSLT_SEG_NUM) FROM PS_GP_PYE_SEG_STAT E WHERE E.EMPLID = B.EMPLID AND E.CAL_RUN_ID = B.CAL_RUN_ID AND E.EMPL_RCD = B.EMPL_RCD AND E.GP_PAYGROUP = B.GP_PAYGROUP AND E.CAL_ID = B.CAL_ID AND E.ORIG_CAL_RUN_ID = B.ORIG_CAL_RUN_ID AND E.PYMT_KEY1 = B.PYMT_KEY1 AND E.PYMT_KEY2 = B.PYMT_KEY2 AND E.PYMT_KEY3 = B.PYMT_KEY3 AND E.PYMT_KEY4 = B.PYMT_KEY4 ) )

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr

3 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id

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 ORIG_CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Original Calendar Group ID

7 RSLT_SEG_NUM Number(4,0) SMALLINT NOT NULL Result Segment Number

8 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

9 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

10 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

11 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

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

13 PRD_TYPE Character(1) VARCHAR2(1) NOT NULL Period Type
C=Current
R=Retro

14 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
3	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id
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	ORIG_CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Original Calendar Group ID
7	RSLT_SEG_NUM	Number(4,0)	SMALLINT NOT NULL	Result Segment Number
8	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
9	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
10	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
11	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
12	CALC_ACTION	Character(1)	VARCHAR2(1) NOT NULL	Calculate Action C=Calculate R=Calculate and Replace V=Reverse W=Reverse and Replace
13	PRD_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Period Type C=Current R=Retro
14	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code