GP_CAL_RUN5_VW (SQL View)	Index Back
View CAL RUNs for GL Reset Used by GP GL RESET. View of open or finalized (in calc) CAL RUNs containing at least one payroll process stat.

GP_CAL_RUN5_VW

(SQL View)

View CAL RUNs for GL Reset

Used by GP GL RESET. View of open or finalized (in calc) CAL RUNs containing at least one payroll process stat.

SELECT B.OPRID ,A.CAL_RUN_ID ,A.DESCR FROM PS_GP_CAL_RUN A ,PS_GP_OPR_RULE_PRF B WHERE (A.RUN_FINALIZED_IND = 'Y' OR A.RUN_OPEN_IND = 'Y') AND (B.USED_BY = 'A' OR A.COUNTRY = B.COUNTRY) AND EXISTS ( SELECT 1 FROM PS_GP_PYE_PRC_STAT PPS WHERE A.CAL_RUN_ID = PPS.CAL_RUN_ID AND PPS.CALC_TYPE = 'P')

# 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 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id

3 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	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	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description