HRS_JO_INFO_R_I

(SQL View)
 Index Back

Job Opening Information

Job Opening Information

SELECT A1.HRS_PERSON_ID , A1.HRS_RCMNT_ID , A.HRS_JOB_OPENING_ID , A.HRS_JO_TYPE , A.HRS_PRM_PST_TITLE , A.ORIGINATOR_ID , A.MANAGER_ID , A.HRS_HIRING_MGR , A.RECRUITER_ID , A.HRS_RECRUITER , A.OPEN_DT , A.CLOSE_DT , A.STATUS_CODE , A.HRS_STATUS , A.STATUS_DT , A.HOT_JOB , A.BUSINESS_UNIT , A.DESCR , A.DEPTID , A.COMPANY , A.HRS_PRM_LOCATION , A.HRS_PRM_LOC_AREA , A.JOB_FAMILY , A.HRS_PRM_JOBCODE , A.JOBCODE_DESCR , A.HRS_ROW_UPD_DTTM , A.HRS_YEAR , A.HRS_MONTH , B.LOCATION_DESCR , B.CITY , B.STATE , B.COUNTRY , B.HRS_RECR_LOCATION , C.HRS_JOB_FAMILY , D.DESCR FROM ((((PS_HRS_RN_R_IDX_VW A1 LEFT OUTER JOIN PS_HRS_ALL_JOBS_VW A ON A1.HRS_JOB_OPENING_ID = A.HRS_JOB_OPENING_ID) LEFT OUTER JOIN PS_HRS_JOB_LOC_VW B ON A.HRS_JOB_OPENING_ID = B.HRS_JOB_OPENING_ID ) LEFT OUTER JOIN PS_HRS_JOB_FAM_VW C ON A.JOB_FAMILY = C.JOB_FAMILY ) LEFT OUTER JOIN PS_DEPT_TBL_EFF_VW D ON ( A.SETID_DEPT = D.SETID AND A.DEPTID = D.DEPTID) )

  • Related Language Record: HRS_RCR_JOBS_LV

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 HRS_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL Person Id
    2 HRS_RCMNT_ID Number(15,0) DECIMAL(15) NOT NULL App Tracking Recruitment ID
    3 HRS_JOB_OPENING_ID Number(15,0) DECIMAL(15) NOT NULL Job Opening Clone
    4 HRS_JO_TYPE Character(1) VARCHAR2(1) NOT NULL Job Opening Type
    P=Continuous Job Opening
    R=Standard Requisition
    5 HRS_PRM_PST_TITLE Character(200) VARCHAR2(200) NOT NULL Job posting title
    6 ORIGINATOR_ID Character(11) VARCHAR2(11) NOT NULL Originator's ID
    7 MANAGER_ID Character(11) VARCHAR2(11) NOT NULL Manager ID
    8 HRS_HIRING_MGR Character(50) VARCHAR2(50) NOT NULL Hiring manager
    9 RECRUITER_ID Character(11) VARCHAR2(11) NOT NULL Recruiter ID
    10 HRS_RECRUITER Character(50) VARCHAR2(50) NOT NULL Recruiter
    11 OPEN_DT Date(10) DATE Created
    12 CLOSE_DT Date(10) DATE Date Closed
    13 STATUS_CODE Character(3) VARCHAR2(3) NOT NULL Identifies a status.
    14 HRS_STATUS Character(30) VARCHAR2(30) NOT NULL Status
    15 STATUS_DT Date(10) DATE Status Date
    16 HOT_JOB Character(1) VARCHAR2(1) NOT NULL Indicates which Job requisitions are classed as urgent to fill. Hot Jobs are identified during the develop requisition process and used as an indicator for both the organization and applicant.
    N=No
    Y=Yes
    17 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    18 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    19 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
    20 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
    21 HRS_PRM_LOCATION Character(10) VARCHAR2(10) NOT NULL Primary Recruiting Location of Job Opening,
    22 HRS_PRM_LOC_AREA Number(15,0) DECIMAL(15) NOT NULL Primary recruiting location area
    23 JOB_FAMILY Character(6) VARCHAR2(6) NOT NULL Job Family
    24 HRS_PRM_JOBCODE Character(6) VARCHAR2(6) NOT NULL Primary Job Code of Job Opening.
    25 JOBCODE_DESCR Character(30) VARCHAR2(30) NOT NULL Job Code Description
    26 HRS_ROW_UPD_DTTM DateTime(26) TIMESTAMP Row Updated DateTime
    27 HRS_YEAR Character(4) VARCHAR2(4) NOT NULL Year - data type character
    28 HRS_MONTH Character(2) VARCHAR2(2) NOT NULL 2 digit month (character)
    29 LOCATION_DESCR Character(30) VARCHAR2(30) NOT NULL Location Description
    30 CITY Character(30) VARCHAR2(30) NOT NULL City
    31 STATE Character(6) VARCHAR2(6) NOT NULL State
    32 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
    33 HRS_RECR_LOCATION Character(30) VARCHAR2(30) NOT NULL Job opening recruiting location
    34 HRS_JOB_FAMILY Character(30) VARCHAR2(30) NOT NULL Job family description
    35 HRS_DESCR Character(30) VARCHAR2(30) NOT NULL Description