TL_SEQ_UPDATE

(SQL Table)
Index Back

Updated information on sent

Internal table used to record requests for information.

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