HRS_JOB_LOC_LN2(SQL View) |
Index Back |
---|---|
Job Opening LocationLocation of Job Opening |
SELECT A.HRS_JOB_OPENING_ID , E.language_cd , A.HRS_PRM_LOC_AREA , E.DESCR FROM PS_HRS_JOB_OPENING A , PS_SET_CNTRL_GROUP D , PS_HRS_LOC_lng 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 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
3 | HRS_PRM_LOC_AREA | Number(15,0) | DECIMAL(15) NOT NULL | Primary recruiting location area |
4 | HRS_RECR_LOCATION | Character(30) | VARCHAR2(30) NOT NULL | Job opening recruiting location |