HRS_JOB_OPENING_IDHRS_PRM_LOC_AREAHRS_JOB_LOC_VW2(SQL View) |
Index Back |
|---|---|
Job Opening LocationLocation of Job Opening |
| SELECT A.HRS_JOB_OPENING_ID , A.HRS_PRM_LOC_AREA , E.DESCR FROM PS_HRS_JOB_OPENING A , PS_SET_CNTRL_GROUP D , PS_HRS_LOCATION E WHERE A.BUSINESS_UNIT = %Substring(D.SETCNTRLVALUE,1,5) AND D.REC_GROUP_ID = 'RS_LOC' AND D.SETID = E.SETID AND A.HRS_PRM_LOC_AREA = E.HRS_LOCATION_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | HRS_JOB_OPENING_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Job Opening Clone |
| 2 | HRS_PRM_LOC_AREA |
Number(15,0) | DECIMAL(15) NOT NULL | Primary recruiting location area |
| 3 | HRS_RECR_LOCATION | Character(30) | VARCHAR2(30) NOT NULL | Job opening recruiting location |