EMPLIDEMPL_RCDTRCPAY_SYSTEMGP=Global Payroll
NA=Payroll for North America
DURTL_PAYTIME_ERRF(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 3 | TRC |
Character(5) | VARCHAR2(5) NOT NULL | Time Reporting Code used to report time in Time and Labor |
| 4 | PAY_SYSTEM |
Character(4) | VARCHAR2(4) NOT NULL |
Payroll System
GP=Global Payroll NA=Payroll for North America |
| 5 | DUR |
Date(10) | DATE | Date Under Report associates time being reported, scheduled or paid, to a specific date. |
| 6 | REASON | Character(30) | VARCHAR2(30) NOT NULL | Reason |