GPFR_ONPAY_C_VW (SQL View)	Index Back
View of Calced Cal Runs View of Cal Runs that have are relevant for GP France (onpay payslip)

GPFR_ONPAY_C_VW

(SQL View)

View of Calced Cal Runs

View of Cal Runs that have are relevant for GP France (onpay payslip)

SELECT DISTINCT PRC.CAL_RUN_ID , OPR.OPRID FROM PS_GPFR_P_SLIP_GRP PSL %Sql(GPFR_SEC_IDNTCALRUNDTL_SQL, PRC) AND PRC.GP_PAYGROUP = PSL.GP_PAYGROUP

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id
2	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).