PYRE_INVALID (SQL Table)	Index Back
Rapid Paysheets Invalid Data This record lists employees with errors on Rapid Paysheets.

PYRE_INVALID

(SQL Table)

Rapid Paysheets Invalid Data

This record lists employees with errors on Rapid Paysheets.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PYRE_TMPLT_TYPE Character(1) VARCHAR2(1) NOT NULL Rapid Paysheets Template Type
A=Amount
B=Hours or Amounts
H=Hours

2 PYRE_TMPLT_ID Character(15) VARCHAR2(15) NOT NULL Template ID for Rapid Entry Paysheets
Prompt Table: PYRE_TEMPLATE

3 RUN_ID Character(10) VARCHAR2(10) NOT NULL Pay Run ID
Prompt Table: PAY_RUN_TBL

4 OFF_CYCLE Character(1) VARCHAR2(1) NOT NULL Off Cycle ?
Y/N Table Edit
Default Value: N

5 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

6 EARNS_BEGIN_DT Date(10) DATE NOT NULL Earnings Begin Date

7 EARNS_END_DT Date(10) DATE NOT NULL Earnings End Date

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

9 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
Default Value: 0

10 SEQNO Number(5,0) INTEGER NOT NULL Sequence Number

11 ERNCD Character(3) VARCHAR2(3) NOT NULL Earnings Code

12 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.

13 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.

14 MESSAGE_TEXT Character(100) VARCHAR2(100) NOT NULL Message Text This field refers to the Text for a particular Message Number in the Message Catalog.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PYRE_TMPLT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Rapid Paysheets Template Type A=Amount B=Hours or Amounts H=Hours
2	PYRE_TMPLT_ID	Character(15)	VARCHAR2(15) NOT NULL	Template ID for Rapid Entry Paysheets Prompt Table: PYRE_TEMPLATE
3	RUN_ID	Character(10)	VARCHAR2(10) NOT NULL	Pay Run ID Prompt Table: PAY_RUN_TBL
4	OFF_CYCLE	Character(1)	VARCHAR2(1) NOT NULL	Off Cycle ? Y/N Table Edit Default Value: N
5	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
6	EARNS_BEGIN_DT	Date(10)	DATE NOT NULL	Earnings Begin Date
7	EARNS_END_DT	Date(10)	DATE NOT NULL	Earnings End Date
8	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
9	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record Default Value: 0
10	SEQNO	Number(5,0)	INTEGER NOT NULL	Sequence Number
11	ERNCD	Character(3)	VARCHAR2(3) NOT NULL	Earnings Code
12	MESSAGE_NBR	Number(5,0)	INTEGER NOT NULL	Message Number. This field refers to the Message Number in the Message Catalog.
13	MESSAGE_SET_NBR	Number(5,0)	INTEGER NOT NULL	Message Set Number. This field refers to the Message Set Number in the Message Catalog.
14	MESSAGE_TEXT	Character(100)	VARCHAR2(100) NOT NULL	Message Text This field refers to the Text for a particular Message Number in the Message Catalog.