PAY_SYSTEMGP=Global Payroll
NA=North American Payroll
PAYROLL_REQ_NUMREQ_VALUE_1REQ_VALUE_2EMPLIDEMPL_RCDTO_DATEA=All Between Range
D=By Range of Dates
N=None
R=By Request Number
T=By Last Request
TL_PAYREQ_E(SQL Table) |
Index Back |
|---|
| # | 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 | REQ_VALUE_1 |
Character(20) | VARCHAR2(20) NOT NULL | Required Payroll value 1 |
| 4 | REQ_VALUE_2 |
Character(20) | VARCHAR2(20) NOT NULL | Required Payroll value 2 |
| 5 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 6 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
| 7 | TO_DATE |
Date(10) | DATE NOT NULL | Latest Date to be sent to PYR |
| 8 | FROM_DATE | Date(10) | DATE | From Date |
| 9 | 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 |
| 10 | TL_ERNCD | Character(22) | VARCHAR2(22) NOT NULL | This field is an image of Earning code field or Payroll |
| 11 | NO_OFFSETS | Character(1) | VARCHAR2(1) NOT NULL | If we should send offsets |