PYTL1_STG_SUB (SQL Table)	Index Back
Updated information on sent Internal table used to record requests for information.

PYTL1_STG_SUB

(SQL Table)

Updated information on sent

Internal table used to record requests for information.

# 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=North American Payroll

4 PAYROLL_REQ_NUM Number(6,0) INTEGER NOT NULL Last payroll request number.

5 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number

6 XREF_NUM Number(15,0) DECIMAL(15) NOT NULL T&L Xref Num

7 MAPPING_ACTION Character(1) VARCHAR2(1) NOT NULL Add,reject,delete for seq num
A=Add
D=Delete
R=Reject

8 DISTRIB_PCT Signed Number(18,10) DECIMAL(16,10) NOT NULL Overall Distribution Percent

9 REPL_XREF_NUM Character(15) VARCHAR2(15) NOT NULL Replacement Xref Number

#	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=North American Payroll
4	PAYROLL_REQ_NUM	Number(6,0)	INTEGER NOT NULL	Last payroll request number.
5	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
6	XREF_NUM	Number(15,0)	DECIMAL(15) NOT NULL	T&L Xref Num
7	MAPPING_ACTION	Character(1)	VARCHAR2(1) NOT NULL	Add,reject,delete for seq num A=Add D=Delete R=Reject
8	DISTRIB_PCT	Signed Number(18,10)	DECIMAL(16,10) NOT NULL	Overall Distribution Percent
9	REPL_XREF_NUM	Character(15)	VARCHAR2(15) NOT NULL	Replacement Xref Number