GP_WC_CALGP_FIN

(SQL View)
 Index Back

GP Workcenter

GP Workcenter - Finalized calendar groups

SELECT DISTINCT ROW_NUMBER() OVER ( ORDER BY T.RUN_FINALIZED_TS DESC) , T.CAL_RUN_ID , T.DESCR ,T.RUN_OPEN_IND ,T.RUN_OPEN_TS ,T.RUN_FINALIZED_IND ,T.RUN_FINALIZED_TS , T.COUNTRY , T.OFF_CYCLE ,T.OPRID FROM ( SELECT DISTINCT A.CAL_RUN_ID ,A.DESCR ,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 GP_PAYGROUP = P.GP_PAYGROUP ) ) AND A.RUN_FINALIZED_IND = 'Y' AND A.OFF_CYCLE = 'N' ) T

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number
2 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id
3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
4 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

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

Y/N Table Edit

Default Value: N

7 RUN_FINALIZED_TS DateTime(26) TIMESTAMP Finalized Timestamp
8 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

Prompt Table: GP_COUNTRY_VW

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