PY_CHK_QC_VW (SQL View)	Index Back
Quick Calc Check View This record contains employee paycheck key information from quick calculation.

PY_CHK_QC_VW

(SQL View)

Quick Calc Check View

This record contains employee paycheck key information from quick calculation.

SELECT B.PY_QC_RUN_ID ,A.COMPANY ,A.PAYGROUP ,A.PAY_END_DT ,A.OFF_CYCLE ,A.PAGE_NUM ,A.LINE_NUM ,A.SEPCHK ,A.EMPLID ,A.EMPL_RCD ,A.NAME ,A.TOTAL_GROSS ,A.TOTAL_TAXES ,A.TOTAL_DEDUCTIONS ,A.NET_PAY ,A.CHECK_DT ,A.PAYCHECK_STATUS ,C.LASTUPDDTTM FROM PS_PAY_CHECK A , PS_PY_CHECK_QC B , PS_PY_QC_RUNCTL C WHERE A.COMPANY = B.COMPANY AND A.PAYGROUP = B.PAYGROUP AND A.PAY_END_DT = B.PAY_END_DT AND A.OFF_CYCLE = B.OFF_CYCLE AND A.PAGE_NUM = B.PAGE_NUM AND A.LINE_NUM = B.LINE_NUM AND A.SEPCHK = B.SEPCHK AND B.PY_QC_RUN_ID = C.PY_QC_RUN_ID AND C.PY_QC_STATUS IN ('Q', 'M')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PY_QC_RUN_ID Character(95) VARCHAR2(95) NOT NULL Quick Calc Run ID

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 PAY_END_DT Date(10) DATE NOT NULL Pay Period End Date
Prompt Table: PAY_CALENDAR

5 OFF_CYCLE Character(1) VARCHAR2(1) NOT NULL Off Cycle ?
Y/N Table Edit

6 PAGE_NUM Number(5,0) INTEGER NOT NULL Page Nbr
Prompt Table: PAY_PAGE

7 LINE_NUM Number(3,0) SMALLINT NOT NULL Line Nbr
Prompt Table: PAY_LINE

8 SEPCHK Number(2,0) SMALLINT NOT NULL Separate check number.

9 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

10 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record

11 NAME Character(50) VARCHAR2(50) NOT NULL Name

12 TOTAL_GROSS Signed Number(12,2) DECIMAL(10,2) NOT NULL Total Gross

13 TOTAL_TAXES Signed Number(12,2) DECIMAL(10,2) NOT NULL Total Taxes

14 TOTAL_DEDUCTIONS Signed Number(12,2) DECIMAL(10,2) NOT NULL Total Deductions

15 NET_PAY Signed Number(12,2) DECIMAL(10,2) NOT NULL Net Pay

16 CHECK_DT Date(10) DATE Check date.

17 PAYCHECK_STATUS Character(1) VARCHAR2(1) NOT NULL Paycheck status.
A=Adjusted
C=Calculated
F=Confirmed
R=Reversed
V=Reversing Check

18 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	PY_QC_RUN_ID	Character(95)	VARCHAR2(95) NOT NULL	Quick Calc Run ID
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	PAY_END_DT	Date(10)	DATE NOT NULL	Pay Period End Date Prompt Table: PAY_CALENDAR
5	OFF_CYCLE	Character(1)	VARCHAR2(1) NOT NULL	Off Cycle ? Y/N Table Edit
6	PAGE_NUM	Number(5,0)	INTEGER NOT NULL	Page Nbr Prompt Table: PAY_PAGE
7	LINE_NUM	Number(3,0)	SMALLINT NOT NULL	Line Nbr Prompt Table: PAY_LINE
8	SEPCHK	Number(2,0)	SMALLINT NOT NULL	Separate check number.
9	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
10	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
11	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
12	TOTAL_GROSS	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Total Gross
13	TOTAL_TAXES	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Total Taxes
14	TOTAL_DEDUCTIONS	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Total Deductions
15	NET_PAY	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Net Pay
16	CHECK_DT	Date(10)	DATE	Check date.
17	PAYCHECK_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Paycheck status. A=Adjusted C=Calculated F=Confirmed R=Reversed V=Reversing Check
18	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.