PROCESS_INSTANCEPrompt Table: HCSC_AWEPRCS_VW
Prompt Table: HCSC_AWEPRCS_VW
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
HCSC_AWEADT_AET(SQL Table) |
Index Back |
|---|---|
AWE Audit ReportRun control record for the AWE Audit Report |
| # | 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 | PTAFPRCS_ID | Character(30) | VARCHAR2(30) NOT NULL |
Approval Process ID
Prompt Table: HCSC_AWEPRCS_VW |
| 5 | PTAFDEFN_ID | Character(30) | VARCHAR2(30) NOT NULL |
Definition ID
Prompt Table: HCSC_AWEPRCS_VW |
| 6 | BEGIN_DT | Date(10) | DATE | Begin Date |
| 7 | END_DT | Date(10) | DATE | end date |
| 8 | PTAFREQUESTOR_ID | Character(30) | VARCHAR2(30) NOT NULL | Requestor id |
| 9 | 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 |
| 10 | DATETIME_CREATED | DateTime(26) | TIMESTAMP | DateTime Created |