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=Awaiting Further Approvals
T=Terminated
W=Canceled
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 | EOAWPRCS_ID | Character(30) | VARCHAR2(30) NOT NULL |
Approval Process ID
Prompt Table: HCSC_AWEPRCS_VW |
| 5 | EOAWDEFN_ID | Character(30) | VARCHAR2(30) NOT NULL |
Approval Framework Definition ID
Prompt Table: HCSC_AWEPRCS_VW |
| 6 | EOAWREQUESTOR_ID | Character(30) | VARCHAR2(30) NOT NULL | Requestor id |
| 7 | EOAWTHREAD_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=Awaiting Further Approvals T=Terminated W=Canceled X=Suspended/Pending Denial |
| 8 | BEGIN_DT | Date(10) | DATE | Begin Date |
| 9 | END_DT | Date(10) | DATE | end date |
| 10 | DATETIME_CREATED | DateTime(26) | TIMESTAMP | DateTime Created |