PUBNODEPRCSINSTANCEPAY_SYSTEMGP=Global Payroll
NA=Payroll for North America
PAYROLL_REQ_NUMSEQ_NBRXREF_NUMA=Add
D=Delete
R=Reject
PYTL1_STG_SUB(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 | 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 | 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 |