HRS_DIAG_OFF_VW(SQL View) |
Index Back |
|---|---|
RS Diagnostic View |
| SELECT A.EOAWTHREAD_ID , A.EOAWPRCS_ID , A.HRS_OFF_ID , A.HRS_PERSON_ID , A.HRS_RCMNT_ID , B.EOAWSTEP_INSTANCE , C.OPRID FROM PS_HRS_OFFAPR_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_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 | 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. |
| 7 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |