HRS_DIAG_JO_VW(SQL View) |
Index Back |
|---|---|
RS Diagnostic View |
| SELECT A.EOAWTHREAD_ID , A.EOAWPRCS_ID , A.HRS_JOB_OPENING_ID , B.EOAWSTEP_INSTANCE , C.OPRID FROM PS_HRS_OPNAPR_XREF A , PS_EOAW_STEPINST B , PS_HRS_USERINST_I C WHERE A.EOAWPRCS_ID = B.EOAWPRCS_ID AND B.EOAWSTEP_INSTANCE = C.EOAWSTEP_INSTANCE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EOAWTHREAD_ID | Number(15,0) | DECIMAL(15) NOT NULL | Approval Framework Thread ID |
| 2 | EOAWPRCS_ID | Character(30) | VARCHAR2(30) NOT NULL | Approval Process ID |
| 3 | HRS_JOB_OPENING_ID | Number(15,0) | DECIMAL(15) NOT NULL | Job Opening Clone |
| 4 | EOAWSTEP_INSTANCE | Number(15,0) | DECIMAL(15) NOT NULL | Object id of a step instance. Generated off the main thread id for the approval process. |
| 5 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |