SEQ_NBRPAY_SYSTEMGP=Global Payroll
NA=Payroll for North America
PAYROLL_REQ_NUMA=All Between Range
D=By Range of Dates
N=None
R=By Request Number
T=By Last Request
TL_PAYROLL_SENT(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 | SEQ_NBR |
Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 2 | PAY_SYSTEM |
Character(4) | VARCHAR2(4) NOT NULL |
Payroll System
GP=Global Payroll NA=Payroll for North America |
| 3 | PAYROLL_REQ_NUM |
Number(6,0) | INTEGER NOT NULL | Last payroll request number. |
| 4 | TO_DATE | Date(10) | DATE | Latest Date to be sent to PYR |
| 5 | FROM_DATE | Date(10) | DATE | From Date |
| 6 | REQ_VALUE_1 | Character(20) | VARCHAR2(20) NOT NULL | Required Payroll value 1 |
| 7 | REQ_VALUE_2 | Character(20) | VARCHAR2(20) NOT NULL | Required Payroll value 2 |
| 8 | REPEAT_REQ_CD | Character(1) | VARCHAR2(1) NOT NULL |
Refresh Request
A=All Between Range D=By Range of Dates N=None R=By Request Number T=By Last Request |