TL_XREF_TBL (SQL Table)	Index Back
Tl Payroll Cross reference

TL_XREF_TBL

(SQL Table)

Tl Payroll Cross reference

# 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 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number

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

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

5 TL_QUANTITY Signed Number(20,6) DECIMAL(18,6) NOT NULL This field represents the measure of Work in hrs,amount etc.,

#	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	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
3	XREF_NUM	Number(15,0)	DECIMAL(15) NOT NULL	T&L Xref Num
4	DISTRIB_PCT	Signed Number(18,10)	DECIMAL(16,10) NOT NULL	Overall Distribution Percent
5	TL_QUANTITY	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	This field represents the measure of Work in hrs,amount etc.,