GP_WC_CALGP_OPN

(SQL View)
 Index Back

GP Workcenter

GP Workcenter - Open calendar groups

SELECT DISTINCT A.CAL_RUN_ID ,A.RUN_OPEN_IND ,A.RUN_OPEN_TS ,A.RUN_FINALIZED_IND ,A.RUN_FINALIZED_TS , A.COUNTRY , A.OFF_CYCLE ,P.OPRID FROM PS_GP_CAL_RUN A , PS_GP_WC_USR_PYGRP P WHERE EXISTS ( SELECT 1 FROM PS_GP_CAL_RUN_DTL B WHERE B.CAL_RUN_ID = A.CAL_RUN_ID AND B.GP_PAYGROUP IN ( SELECT GP_PAYGROUP FROM PS_GP_WC_USR_PYGRP WHERE OPRID = P.OPRID ) ) AND A.RUN_OPEN_IND = 'Y' AND A.OFF_CYCLE = 'N'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id
2 RUN_OPEN_IND Character(1) VARCHAR2(1) NOT NULL Y/N Indicates that processing has been initiated for given run (calendar group).

Y/N Table Edit

Default Value: N

3 RUN_OPEN_TS DateTime(26) TIMESTAMP Records the time when processing was first initiated for a given calendar group
4 RUN_FINALIZED_IND Character(1) VARCHAR2(1) NOT NULL Finalized Run

Y/N Table Edit

Default Value: N

5 RUN_FINALIZED_TS DateTime(26) TIMESTAMP Finalized Timestamp
6 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

Prompt Table: GP_COUNTRY_VW

7 OFF_CYCLE Character(1) VARCHAR2(1) NOT NULL Off Cycle ?
8 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).