HRS_JO_BASE_LN

(SQL View)
 Index Back

Ext and Int Job Openings

Related language record for data that is used in job posting search

SELECT A.HRS_JOB_OPENING_ID , A.HRS_JO_PST_SEQ , A.HRS_JO_PST_TYPE , A.HRS_SOURCE_ID ,I.LANGUAGE_CD , I.POSTING_TITLE ,COALESCE( ( SELECT D.DESCR FROM PS_DEPT_TBL_LANG D WHERE D.SETID = A.SETID_DEPT AND D.DEPTID = A.DEPTID AND D.LANGUAGE_CD = I.LANGUAGE_CD AND D.EFFDT = ( SELECT MAX(D1.EFFDT) FROM PS_DEPT_TBL_LANG D1 WHERE D.SETID=D1.SETID AND D.DEPTID=D1.DEPTID AND D.LANGUAGE_CD=D1.LANGUAGE_CD AND D1.EFFDT<=%CurrentDateIn)) ,( SELECT D.DESCR FROM PS_DEPT_TBL D WHERE D.SETID = A.SETID_DEPT AND D.DEPTID = A.DEPTID AND D.EFFDT = ( SELECT MAX(D1.EFFDT) FROM PS_DEPT_TBL D1 WHERE D.SETID = D1.SETID AND D.DEPTID = D1.DEPTID AND D1.EFFDT <= %CurrentDateIn)), ' ') , COALESCE(( SELECT JF.DESCR FROM PS_JOB_FAMILY_LNG JF WHERE JF.JOB_FAMILY = A.JOB_FAMILY AND JF.LANGUAGE_CD = I.LANGUAGE_CD AND JF.EFFDT = ( SELECT MAX(JF1.EFFDT) FROM PS_JOB_FAMILY_LNG JF1 WHERE JF.JOB_FAMILY = JF1.JOB_FAMILY AND JF.LANGUAGE_CD = JF1.LANGUAGE_CD AND JF1.EFFDT<=%CurrentDateIn)) ,( SELECT JF.DESCR FROM PS_JOB_FAMILY_TBL JF WHERE JF.JOB_FAMILY = A.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 =A.COUNTRY AND CN.LANGUAGE_CD = I.LANGUAGE_CD),( SELECT CN.DESCR FROM PS_COUNTRY_TBL CN WHERE CN.COUNTRY = A.COUNTRY), ' ') , COALESCE(( SELECT ST.DESCR FROM PS_STATE_TBL_LANG ST WHERE ST.COUNTRY=A.COUNTRY AND ST.STATE =A.STATE AND ST.LANGUAGE_CD = I.LANGUAGE_CD),( SELECT ST.DESCR FROM PS_STATE_TBL ST WHERE ST.COUNTRY = A.COUNTRY AND ST.STATE = A.STATE), ' ') , COALESCE(( SELECT LOC.DESCR FROM PS_HRS_JO_LOC_LN LOC WHERE A.HRS_JOB_OPENING_ID=LOC.HRS_JOB_OPENING_ID AND LOC.LOCATION =A.LOCATION AND LOC.LANGUAGE_CD = I.LANGUAGE_CD ),( SELECT LOC.DESCR FROM PS_HRS_JO_LOC_DTLS LOC WHERE A.HRS_JOB_OPENING_ID = LOC.HRS_JOB_OPENING_ID AND LOC.LOCATION = A.LOCATION),' ' ) , COALESCE(( SELECT RLOC.HRS_RECR_LOCATION FROM PS_HRS_JOB_LOC_LV RLOC WHERE A.HRS_JOB_OPENING_ID=RLOC.HRS_JOB_OPENING_ID AND RLOC.LANGUAGE_CD = I.LANGUAGE_CD ),( SELECT RLOC.HRS_RECR_LOCATION FROM PS_HRS_JOB_LOC_VW RLOC WHERE A.HRS_JOB_OPENING_ID = RLOC.HRS_JOB_OPENING_ID),' ' ) FROM PS_HRS_JPST_TBL A , PS_HRS_JO_PST_LNG I WHERE A.HRS_JOB_OPENING_ID=I.HRS_JOB_OPENING_ID AND A.HRS_JO_PST_SEQ=I.HRS_JO_PST_SEQ

  • Related Language Record for HRS_JO_BASE_VW

    • # 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 HRS_JO_PST_SEQ Number(3,0) SMALLINT NOT NULL Job opening posting sequence

    Prompt Table: HRS_JO_PST_I

    3 HRS_JO_PST_TYPE Character(1) VARCHAR2(1) NOT NULL Job Opening Posting Type
    C=Contingent Workforce
    E=External Posting
    I=Internal Posting
    L=Labor Office
    R=Recruitment
    4 HRS_SOURCE_ID Number(15,0) DECIMAL(15) NOT NULL Source ID
    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 POSTING_TITLE Character(200) VARCHAR2(200) NOT NULL Job posting title
    7 DEPT_DESCR Character(30) VARCHAR2(30) NOT NULL Department Description
    8 HRS_JOB_FAMILY Character(30) VARCHAR2(30) NOT NULL Job family description
    9 COUNTRY_DESCR Character(30) VARCHAR2(30) NOT NULL Country Description
    10 STATE_DESCR Character(30) VARCHAR2(30) NOT NULL State Description
    11 LOCATION_DESCR Character(30) VARCHAR2(30) NOT NULL Location Description
    12 HRS_RECR_LOCATION Character(30) VARCHAR2(30) NOT NULL Job opening recruiting location