RUNCNTL_HCSCAWE(SQL Table) |
Index Back |
|---|---|
Supplier CI run controlRun control record for the Supplier CI EBNX_EXTRACT process |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | PTAFPRCS_ID | Character(30) | VARCHAR2(30) NOT NULL |
Approval Process ID
Prompt Table: HCSC_AWETXN_VW |
| 4 | PTAFDEFN_ID | Character(30) | VARCHAR2(30) NOT NULL |
Definition ID
Prompt Table: HCSC_AWEPRCS_VW |
| 5 | BEGIN_DT | Date(10) | DATE | Begin Date |
| 6 | END_DT | Date(10) | DATE | end date |
| 7 | PTAFREQUESTOR_ID | Character(30) | VARCHAR2(30) NOT NULL |
Requestor id
Prompt Table: HCSC_PERS_SRCH |
| 8 | PTAFTHREAD_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Thread Status
A=Approved C=Complete D=Denied E=Pending Denial H=Hard Deny I=Initial N=Not Active P=Pending S=Suspended T=Terminated X=Suspended/Pending Denial |