HRS_DIAG_JO_VW(SQL View) |
Index Back |
|---|---|
RS Diagnostic View |
| SELECT A.PTAFTHREAD_ID , A.PTAFPRCS_ID , A.HRS_JOB_OPENING_ID , B.PTAFSTEP_INSTANCE , C.OPRID FROM PS_HRS_OPNAPR_XREF A , PS_PTAFAW_STEPINST B , PS_HRS_USERINST_I C WHERE A.PTAFPRCS_ID = B.PTAFPRCS_ID AND B.PTAFSTEP_INSTANCE = C.PTAFSTEP_INSTANCE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PTAFTHREAD_ID | Number(10,0) | DECIMAL(10) NOT NULL | Thread ID |
| 2 | PTAFPRCS_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 | 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. |
| 5 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |