PROCESS_INSTANCEA=All Between Range
D=By Range of Dates
N=None
R=By Request Number
T=By Last Request
F=Process Off-Cycle Checks
O=Process On-Cycle Checks
GP=Global Payroll
NA=North American Payroll
TL_PAYREQ_AET(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 3 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 4 | PUBNODE | Character(30) | VARCHAR2(30) NOT NULL | Application Messaging Publication Node. This refers to the Node that the Application Message Instance was published from. |
| 5 | PRCSINSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 6 | DATE_COUNT | Number(3,0) | SMALLINT NOT NULL | Date Counter |
| 7 | PAYSND_CNT | Number(3,0) | SMALLINT NOT NULL | Send To Payroll Counter |
| 8 | TOTERR_CNT | Number(3,0) | SMALLINT NOT NULL | Total Error Count |
| 9 | ACTERR_CNT | Number(3,0) | SMALLINT NOT NULL | Actual Error Count |
| 10 | REQUEST_NBR | Number(4,0) | SMALLINT NOT NULL | Request Number |
| 11 | 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 |
| 12 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 13 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
| 14 | REPEAT_REQ_FROM_DT | Date(10) | DATE | Repeat Request From Date |
| 15 | REPEAT_REQ_NUM | Number(3,0) | SMALLINT NOT NULL | Repeat Request Number |
| 16 | REPEAT_REQ_TO_DT | Date(10) | DATE | Repeat Request To Date |
| 17 | IMAGE_NUM | Number(2,0) | SMALLINT NOT NULL | Image Number |
| 18 | EXTRACT_DATA | Character(1) | VARCHAR2(1) NOT NULL | Extract Data |
| 19 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL | Company |
| 20 | PAYGROUP | Character(3) | VARCHAR2(3) NOT NULL | Pay Group |
| 21 | PAY_END_DT | Date(10) | DATE | Pay Period End Date |
| 22 | RUN_ID | Character(10) | VARCHAR2(10) NOT NULL | Pay Run ID |
| 23 | PROCESS_ON_OFF | Character(1) | VARCHAR2(1) NOT NULL |
Process On-Cycle or Off-Cycle
F=Process Off-Cycle Checks O=Process On-Cycle Checks |
| 24 | LD_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Labor Distribution Used |
| 25 | PAY_SYSTEM | Character(4) | VARCHAR2(4) NOT NULL |
Payroll System
GP=Global Payroll NA=North American Payroll |
| 26 | EXCEPTION_ID | Character(8) | VARCHAR2(8) NOT NULL | Exception ID |
| 27 | EXIST | Character(1) | VARCHAR2(1) NOT NULL | Currency Exist |
| 28 | PAYROLL_REQ_NUM | Number(6,0) | INTEGER NOT NULL | Last payroll request number. |
| 29 | DUR | Date(10) | DATE | Date Under Report associates time being reported, scheduled or paid, to a specific date. |
| 30 | SEQ_NBR | Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 31 | XREF_NUM | Number(15,0) | DECIMAL(15) NOT NULL | T&L Xref Num |