PY_MSG_QC_VW (SQL View)	Index Back
Quick Calc Message View This record contains payroll messages from quick calculation.

PY_MSG_QC_VW

(SQL View)

Quick Calc Message View

This record contains payroll messages from quick calculation.

SELECT A.PY_QC_RUN_ID , A.COMPANY , A.PAYGROUP , A.PAY_END_DT , A.OFF_CYCLE , B.PAGE_NUM , B.LINE_NUM , B.SEPCHK , B.MSGID , B.MSGDATA1 , B.MSGDATA2 , B.MSGDATA3 , A.EMPLID , A.EMPL_RCD , A.LASTUPDDTTM FROM PS_PY_QC_RUNCTL A , PS_PY_MESSAGE_QC B WHERE A.PY_QC_RUN_ID = B.PY_QC_RUN_ID AND A.PY_QC_STATUS = '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 MSGID Character(6) VARCHAR2(6) NOT NULL Message ID

10 MSGDATA1 Character(30) VARCHAR2(30) NOT NULL Message Data

11 MSGDATA2 Character(30) VARCHAR2(30) NOT NULL Message Data

12 MSGDATA3 Character(30) VARCHAR2(30) NOT NULL Message Data

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

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

15 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	MSGID	Character(6)	VARCHAR2(6) NOT NULL	Message ID
10	MSGDATA1	Character(30)	VARCHAR2(30) NOT NULL	Message Data
11	MSGDATA2	Character(30)	VARCHAR2(30) NOT NULL	Message Data
12	MSGDATA3	Character(30)	VARCHAR2(30) NOT NULL	Message Data
13	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
14	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
15	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.