TL_SEQ_UPDATE(SQL Table) |
Index Back |
---|---|
Updated information on sentInternal 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 |