HCSC_ADT_USRINS(SQL View) |
Index Back |
|---|---|
AWE Audit ReportUsed to collect and display User Instance level information in the AWE Audit report gnerated by XMLP. Note: PTAFDTTM_COMPLETE isnt populated for header level transactions so we use PTAFDTTM_MODIFIED in the COMPLETE field to simulate the the timestamp of the participants action |
| SELECT A.PTAFPRCS_ID , A.PTAFDEFN_ID , A.PTAFTHREAD_ID , A.PTAFSTAGE_NBR , A.PTAFPATH_ID , A.PTAFSTEP_NBR , B.PTAFSTEP_INSTANCE , B.PTAFUSTEP_INST_ID , B.PTAFUSER_TYPE , C.XLATLONGNAME , B.OPRID , B.PTAFORIG_OPRID , B.PTAFSTEP_STATUS , D.XLATLONGNAME , B.DTTM_CREATED , B.PTAFDTTM_MODIFIED , B.PTAFDTTM_MODIFIED FROM PS_PTAFAW_STEPINST A , PS_PTAFAW_USERINST B , PSXLATITEM C , PSXLATITEM D WHERE B.PTAFSTEP_INSTANCE = A.PTAFSTEP_INSTANCE AND C.FIELDNAME = 'PTAFUSER_TYPE' AND C.FIELDVALUE = B.PTAFUSER_TYPE AND %EffdtCheck(PSXLATITEM,C,%CURRENTDATEIN) AND D.FIELDNAME = 'PTAFSTEP_STATUS' AND D.FIELDVALUE = B.PTAFSTEP_STATUS AND %EffdtCheck(PSXLATITEM,D,%CURRENTDATEIN) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PTAFPRCS_ID |
Character(30) | VARCHAR2(30) NOT NULL | Approval Process ID |
| 2 | PTAFDEFN_ID |
Character(30) | VARCHAR2(30) NOT NULL | Definition ID |
| 3 | PTAFTHREAD_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Thread ID |
| 4 | PTAFSTAGE_NBR |
Number(3,0) | SMALLINT NOT NULL | Stage Number |
| 5 | PTAFPATH_ID |
Character(30) | VARCHAR2(30) NOT NULL | Approval Path ID |
| 6 | PTAFSTEP_NBR |
Number(6,2) | DECIMAL(5,2) NOT NULL | Sequence number of step in its path |
| 7 | PTAFSTEP_INSTANCE |
Number(15,0) | DECIMAL(15) NOT NULL | Object id of a step instance. Generated off the main thread id for the approval process. |
| 8 | PTAFUSTEP_INST_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Object id of a step instance. Generated off the main thread id for the approval process. |
| 9 | PTAFUSER_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Approval Workflow Events for Notification
A=Approver R=Reviewer |
| 10 | USER_TYPE_DESCR | Character(30) | VARCHAR2(30) NOT NULL | User Type Description |
| 11 | OPRID | Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table: PSOPRDEFN |
| 12 | PTAFORIG_OPRID | Character(30) | VARCHAR2(30) NOT NULL | User ID |
| 13 | PTAFSTEP_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Step Instance Status
A=Approved B=Pushed back C=Auto Approved D=Denied E=Administrator denied F=Deleted G=Bypassed H=On Hold K=Skipped L=Terminated M=Administrator approved N=Not Active P=Pending R=No longer in role S=Skipped T=Terminated U=Auto approved X=Deleted Y=Bypassed |
| 14 | STEP_STAT_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Step Status Description |
| 15 | DTTM_CREATED | DateTime(26) | TIMESTAMP | Datetime Created |
| 16 | PTAFDTTM_MODIFIED | DateTime(26) | TIMESTAMP | Datetime modified |
| 17 | PTAFDTTM_COMPLETE | DateTime(26) | TIMESTAMP | Date/Time Completed |