PY_EE_REG_RATE (SQL Table)	Index Back
Employee Regular Rate of Pay This record contains employee Regular Rate of Pay information.

PY_EE_REG_RATE

(SQL Table)

Employee Regular Rate of Pay

This record contains employee Regular Rate of Pay information.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: PERSON_NAME

2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
Prompt Table: PER_ORG_ASGN_VW

3 FLSA_END_DT Date(10) DATE NOT NULL FLSA End Date

4 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
Prompt Table: COMPANY_TBL

5 PAYGROUP Character(3) VARCHAR2(3) NOT NULL Pay Group
Prompt Table: PAYGROUP_TBL

6 PAY_END_DT Date(10) DATE NOT NULL Pay Period End Date
Prompt Table: PAY_CALENDAR

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

8 PAGE_NUM Number(5,0) INTEGER NOT NULL Page Nbr

9 LINE_NUM Number(3,0) SMALLINT NOT NULL Line Nbr

10 ADDL_NBR Number(3,0) SMALLINT NOT NULL Additional Pay Line Nbr

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

12 STATE Character(6) VARCHAR2(6) NOT NULL State

13 PY_REG_RT Number(19,6) DECIMAL(18,6) NOT NULL Regular Rate of Pay.

14 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	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSON_NAME
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record Prompt Table: PER_ORG_ASGN_VW
3	FLSA_END_DT	Date(10)	DATE NOT NULL	FLSA End Date
4	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company Prompt Table: COMPANY_TBL
5	PAYGROUP	Character(3)	VARCHAR2(3) NOT NULL	Pay Group Prompt Table: PAYGROUP_TBL
6	PAY_END_DT	Date(10)	DATE NOT NULL	Pay Period End Date Prompt Table: PAY_CALENDAR
7	OFF_CYCLE	Character(1)	VARCHAR2(1) NOT NULL	Off Cycle ? Y/N Table Edit
8	PAGE_NUM	Number(5,0)	INTEGER NOT NULL	Page Nbr
9	LINE_NUM	Number(3,0)	SMALLINT NOT NULL	Line Nbr
10	ADDL_NBR	Number(3,0)	SMALLINT NOT NULL	Additional Pay Line Nbr
11	SEPCHK	Number(2,0)	SMALLINT NOT NULL	Separate check number.
12	STATE	Character(6)	VARCHAR2(6) NOT NULL	State
13	PY_REG_RT	Number(19,6)	DECIMAL(18,6) NOT NULL	Regular Rate of Pay.
14	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.