HRS_DIAG_OFF_VW(SQL View) |
Index Back |
|---|---|
RS Diagnostic View |
| SELECT A.PTAFTHREAD_ID , A.PTAFPRCS_ID , A.HRS_OFF_ID , A.HRS_PERSON_ID , A.HRS_RCMNT_ID , B.PTAFSTEP_INSTANCE , C.OPRID FROM PS_HRS_OFFAPR_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_OFF_ID | Number(15,0) | DECIMAL(15) NOT NULL | Offer ID |
| 4 | HRS_PERSON_ID | Number(15,0) | DECIMAL(15) NOT NULL | Person Id |
| 5 | HRS_RCMNT_ID | Number(15,0) | DECIMAL(15) NOT NULL | App Tracking Recruitment ID |
| 6 | 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. |
| 7 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |