HRS_JOB_OPENING_IDPrompt Table: HRS_JO_I
LANGUAGE_CDHRS_JO_BASE_LN2(SQL View) |
Index Back |
|---|---|
Ext and Int Job OpeningsJob openings with postings that are available for external and internal applicants. |
| SELECT JO.HRS_JOB_OPENING_ID , PNL.LANGUAGE_CD , COALESCE(( SELECT DEPTL.DESCR FROM PS_DEPT_TBL_LANG DEPTL WHERE DEPTL.SETID = JO.SETID_DEPT AND DEPTL.DEPTID = JO.DEPTID AND DEPTL.LANGUAGE_CD = PNL.LANGUAGE_CD AND %EffdtCheck (DEPT_TBL_LANG X1, DEPTL, %CURRENTDATEIN)), ( SELECT DEPT.DESCR FROM PS_DEPT_TBL DEPT WHERE DEPT.SETID = JO.SETID_DEPT AND DEPT.DEPTID = JO.DEPTID AND DEPT.EFFDT = ( SELECT MAX (D1.EFFDT) FROM PS_DEPT_TBL D1 WHERE DEPT.SETID = D1.SETID AND DEPT.DEPTID = D1.DEPTID AND D1.EFFDT <= %CurrentDateIn))) , COALESCE(( SELECT JF.DESCR FROM PS_JOB_FAMILY_LNG JF WHERE JF.JOB_FAMILY = JO.JOB_FAMILY AND JF.LANGUAGE_CD = PNL.LANGUAGE_CD AND %EffdtCheck (JOB_FAMILY_LNG X2, JF, %CURRENTDATEIN)), ( SELECT JF.DESCR FROM PS_JOB_FAMILY_TBL JF WHERE JF.JOB_FAMILY = JO.JOB_FAMILY AND JF.EFFDT = ( SELECT MAX (JF1.EFFDT) FROM PS_JOB_FAMILY_TBL JF1 WHERE JF.JOB_FAMILY = JF1.JOB_FAMILY AND JF1.EFFDT <= %CurrentDateIn))) , COALESCE(( SELECT CN.DESCR FROM PS_COUNTRYTBL_LANG CN WHERE CN.COUNTRY = JO.COUNTRY AND CN.LANGUAGE_CD = PNL.LANGUAGE_CD), ( SELECT CTRY.DESCR FROM PS_COUNTRY_TBL CTRY WHERE CTRY.COUNTRY = JO.COUNTRY)) , COALESCE(( SELECT ST.DESCR FROM PS_STATE_TBL_LANG ST WHERE ST.COUNTRY = JO.COUNTRY AND ST.STATE = JO.STATE AND ST.LANGUAGE_CD = PNL.LANGUAGE_CD), ( SELECT ST.DESCR FROM PS_STATE_TBL ST WHERE ST.COUNTRY = JO.COUNTRY AND ST.STATE = JO.STATE)) , ' ' , COALESCE(( SELECT LOC.DESCR FROM PS_LOCATION_LANG LOC WHERE LOC.SETID = JO.SETID_DEPT AND LOC.LOCATION = JO.LOCATION AND LOC.LANGUAGE_CD = PNL.LANGUAGE_CD AND %EffdtCheck (LOCATION_LANG X3, LOC, %CURRENTDATEIN)), ( SELECT LOC1.DESCR FROM PS_LOCATION_TBL LOC1 WHERE LOC1.SETID = JO.SETID_DEPT AND LOC1.LOCATION = JO.LOCATION AND LOC1.EFFDT = ( SELECT MAX (X4.EFFDT) FROM PS_LOCATION_TBL X4 WHERE LOC1.SETID = X4.SETID AND LOC1.LOCATION = X4.LOCATION AND X4.EFFDT <= %CurrentDateIn)) ) , COALESCE(( SELECT RLOC.DESCR FROM PS_HRS_LOC_LNG RLOC WHERE RLOC.SETID = JO.SETID_DEPT AND RLOC.HRS_LOCATION_ID = JO.HRS_PRM_LOC_AREA AND RLOC.LANGUAGE_CD = PNL.LANGUAGE_CD), ( SELECT HLOC.DESCR FROM PS_HRS_LOCATION HLOC WHERE HLOC.SETID = JO.SETID_DEPT AND HLOC.HRS_LOCATION_ID = JO.HRS_PRM_LOC_AREA)) FROM PS_HRS_JO_BASE_VW2 JO , PSPNLGDEFNLANG PNL WHERE PNL.PNLGRPNAME = 'HRS_JO_360' |
| # | 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
Prompt Table: HRS_JO_I |
| 2 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 3 | DEPT_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Department Description |
| 4 | HRS_JOB_FAMILY | Character(30) | VARCHAR2(30) NOT NULL | Job family description |
| 5 | COUNTRY_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Country Description |
| 6 | STATE_DESCR | Character(30) | VARCHAR2(30) NOT NULL | State Description |
| 7 | CITY | Character(30) | VARCHAR2(30) NOT NULL | City |
| 8 | LOCATION_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Location Description |
| 9 | HRS_RECR_LOCATION | Character(30) | VARCHAR2(30) NOT NULL | Job opening recruiting location |