PYTL_STG_SUB

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PUBNODE	Character(30)	VARCHAR2(30) NOT NULL	Application Messaging Publication Node. This refers to the Node that the Application Message Instance was published from.
2	PRCSINSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
3	PAY_SYSTEM	Character(4)	VARCHAR2(4) NOT NULL	Payroll System GP=Global Payroll NA=Payroll for North America
4	PAYROLL_REQ_NUM	Number(6,0)	INTEGER NOT NULL	Last payroll request number.
5	REQ_VALUE_1	Character(20)	VARCHAR2(20) NOT NULL	Required Payroll value 1
6	REQ_VALUE_2	Character(20)	VARCHAR2(20) NOT NULL	Required Payroll value 2
7	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
8	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
9	TO_DATE	Date(10)	DATE NOT NULL	Latest Date to be sent to PYR
10	FROM_DATE	Date(10)	DATE	From Date
11	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
12	REPEAT_REQ_NUM	Number(3,0)	SMALLINT NOT NULL	Repeat Request Number
13	REPEAT_REQ_FROM_DT	Date(10)	DATE	Repeat Request From Date
14	REPEAT_REQ_TO_DT	Date(10)	DATE	Repeat Request To Date
15	TL_ERNCD	Character(22)	VARCHAR2(22) NOT NULL	This field is an image of Earning code field or Payroll
16	NO_OFFSETS	Character(1)	VARCHAR2(1) NOT NULL	If we should send offsets