TL_PAYROLL_REQ

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PAY_SYSTEM	Character(4)	VARCHAR2(4) NOT NULL	Payroll System GP=Global Payroll NA=North American Payroll
2	PAYROLL_REQ_NUM	Number(6,0)	INTEGER NOT NULL	Last payroll request number.
3	REQ_VALUE_1	Character(20)	VARCHAR2(20) NOT NULL	Required Payroll value 1
4	REQ_VALUE_2	Character(20)	VARCHAR2(20) NOT NULL	Required Payroll value 2
5	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
6	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
7	TO_DATE	Date(10)	DATE NOT NULL	Latest Date to be sent to PYR
8	FROM_DATE	Date(10)	DATE	From Date
9	REPEAT_REQ_CD	Character(1)	VARCHAR2(1) NOT NULL	Refresh Request A=All Between Range D=By Range of Dates N=None R=By Request Number T=By Last Request
10	REPEAT_REQ_NUM	Number(3,0)	SMALLINT NOT NULL	Repeat Request Number
11	REPEAT_REQ_FROM_DT	Date(10)	DATE	Repeat Request From Date
12	REPEAT_REQ_TO_DT	Date(10)	DATE	Repeat Request To Date
13	TL_ERNCD	Character(22)	VARCHAR2(22) NOT NULL	This field is an image of Earning code field or Payroll
14	NO_OFFSETS	Character(1)	VARCHAR2(1) NOT NULL	If we should send offsets