HRS_EXT_POST_IDOPRIDHRS_JO_PSTBRD_I(SQL View) |
Index Back |
|---|---|
Job Openings Avail to Pst IntJob openings with postings that are available to post externally to a job board. |
| SELECT E.HRS_EXT_POST_ID ,SEC.OPRID FROM PS_HRS_JOB_OPENING A , PS_HRS_JO_SEC_VW SEC , PS_HRS_STS_JO_I D , PS_HRS_EXTPOST_STS E WHERE A.HRS_JOB_OPENING_ID = SEC.HRS_JOB_OPENING_ID AND A.HRS_JOB_OPENING_ID = E.HRS_JOB_OPENING_ID AND A.STATUS_CODE = D.STATUS_CODE AND D.OPEN_STS_IND = 'Y' AND E.HRS_SOURCE_ID IN ( SELECT F.HRS_SOURCE_ID FROM PS_HRS_SRC_VND_V_I F WHERE F.HRS_SOURCE_STATUS = '10') AND E.HRS_EXT_POST_STS NOT IN ('10', '60') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | HRS_EXT_POST_ID |
Number(15,0) | DECIMAL(15) NOT NULL | External Posting ID |
| 2 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |