HRS_JO_LOC_DTLS

(SQL View)
 Index Back

SELECT A.HRS_JOB_OPENING_ID ,B.LOCATION ,B.DESCR ,B.COUNTRY ,C.DESCR ,B.STATE ,D.DESCR ,B.CITY FROM PS_HRS_JOB_OPENING A , PS_LOCATION_TBL B ,PS_COUNTRY_TBL C ,PS_STATE_TBL D WHERE A.HRS_PRM_LOCATION=B.LOCATION AND B.COUNTRY= C.COUNTRY AND B.STATE=D.STATE AND C.COUNTRY=D.COUNTRY AND B.SETID=( SELECT G.SETID FROM PS_SET_CNTRL_GROUP G WHERE G.SETCNTRLVALUE = A.BUSINESS_UNIT AND G.REC_GROUP_ID = ( SELECT H.REC_GROUP_ID FROM PS_REC_GROUP_REC H WHERE H.RECNAME = 'LOCATION_TBL')) AND B.EFFDT = ( SELECT MAX(A.EFFDT) FROM PS_HRS_LOCATION_I A WHERE A.SETID = B.SETID AND A.LOCATION = B.LOCATION AND A.EFFDT <= %CurrentDateIn) AND ((D.COUNTRY = 'USA' AND D.NUMERIC_CD > ' ') OR (D.COUNTRY = 'CAN' AND D.NUMERIC_CD > ' ') OR D.COUNTRY NOT IN ('USA','CAN'))

  • Related Language Record: HRS_JO_LOC_LN

    • # 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 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
    5 COUNTRY_DESCR Character(30) VARCHAR2(30) NOT NULL Country Description
    6 STATE Character(6) VARCHAR2(6) NOT NULL State
    7 STATE_DESCR Character(30) VARCHAR2(30) NOT NULL State Description
    8 CITY Character(30) VARCHAR2(30) NOT NULL City