PY_QCLOCK_USVW

(SQL View)
 Index Back

Quick Calc Lock for US


SELECT A.RUN_ID , A.COMPANY , A.PAYGROUP , A.PY_PROCESS , A.PAY_END_DT , A.OFF_CYCLE , A.SINGLE_CHECK , A.LASTUPDDTTM FROM PS_PY_QC_LOCK_TBL A WHERE EXISTS ( SELECT 'X' FROM PS_PAYGROUP_TBL B WHERE B.COMPANY = A.COMPANY AND B.PAYGROUP = A.PAYGROUP AND B.EFFDT= ( SELECT MAX(Z.EFFDT) FROM PS_PAYGROUP_TBL Z WHERE B.COMPANY=Z.COMPANY AND B.PAYGROUP=Z.PAYGROUP AND Z.EFFDT<=A.PAY_END_DT) AND B.INDUSTRY_SECTOR IN ('CORE', 'PBSC') AND A.COUNTRY = 'USA' )

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 RUN_ID Character(10) VARCHAR2(10) NOT NULL Pay Run ID

Prompt Table: PAY_RUN_VW

2 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

Prompt Table: COMPANY_TBL

3 PAYGROUP Character(3) VARCHAR2(3) NOT NULL Pay Group

Prompt Table: PAYGROUP_TBL

4 PY_PROCESS Character(1) VARCHAR2(1) NOT NULL Payroll Process
Q=Quick Calculation
R=Pay Calculation
5 PAY_END_DT Date(10) DATE Pay Period End Date
6 OFF_CYCLE Character(1) VARCHAR2(1) NOT NULL Off Cycle ?

Y/N Table Edit

7 SINGLE_CHECK Character(1) VARCHAR2(1) NOT NULL Multiple State Employer

Y/N Table Edit

8 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.