PY_QCLOCK_CANVW (SQL View)	Index Back
Quick Calc Lock for Canada

PY_QCLOCK_CANVW

(SQL View)

Quick Calc Lock for Canada

SELECT RUN_ID , COMPANY , PAYGROUP , PY_PROCESS , PAY_END_DT , OFF_CYCLE , SINGLE_CHECK , LASTUPDDTTM FROM PS_PY_QC_LOCK_TBL WHERE COUNTRY = 'CAN'

# 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.

#	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.