GP_PYE_RUN (SQL Table)	Index Back
GP Payee Run The GP Payee Run table is the parent table for Payee Calendar Run Overrides.

GP_PYE_RUN

(SQL Table)

GP Payee Run

The GP Payee Run table is the parent table for Payee Calendar Run Overrides.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: GP_EMP_SEC_VW

2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
Prompt Table: EMPLMT_SRCH_GBL

3 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id
Prompt Table: GP_CAL_NFIN_VW

4 PRC_BGN_DT Date(10) DATE NOT NULL The Processing Begin Date is the Beginning Date of the Period when Processing is taking place. It usually is the same as the Period Begin Date (PRD_BGN_DT), except in cases of Advance Payment.

5 PRC_END_DT Date(10) DATE NOT NULL The Processing End Date is the End Date of the Period when Processing is taking place. It usually is the same as the Period End Date (PRD_END_DT), except in cases of Advance Payment.

6 PYMT_DT Date(10) DATE NOT NULL Payment Date

7 OVRD_CAL_RUN_IND Character(1) VARCHAR2(1) NOT NULL Override Calendar Run Indicator. 'Y" indicates entire Calendar Run level Identify is to be skipped. 'N' indicates override of Identify occurs at the Calendar level instead.
N=Cal ID Level Override
Y=Cal Run Level Override
Default Value: N

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: GP_EMP_SEC_VW
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record Prompt Table: EMPLMT_SRCH_GBL
3	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id Prompt Table: GP_CAL_NFIN_VW
4	PRC_BGN_DT	Date(10)	DATE NOT NULL	The Processing Begin Date is the Beginning Date of the Period when Processing is taking place. It usually is the same as the Period Begin Date (PRD_BGN_DT), except in cases of Advance Payment.
5	PRC_END_DT	Date(10)	DATE NOT NULL	The Processing End Date is the End Date of the Period when Processing is taking place. It usually is the same as the Period End Date (PRD_END_DT), except in cases of Advance Payment.
6	PYMT_DT	Date(10)	DATE NOT NULL	Payment Date
7	OVRD_CAL_RUN_IND	Character(1)	VARCHAR2(1) NOT NULL	Override Calendar Run Indicator. 'Y" indicates entire Calendar Run level Identify is to be skipped. 'N' indicates override of Identify occurs at the Calendar level instead. N=Cal ID Level Override Y=Cal Run Level Override Default Value: N