HRS_JO_HMGR_I

(SQL View)
 Index Back

Open Job Openings Interface

Interface for job openings that are in an open status and assigned to the current user as Hiring Manager.

SELECT A.HRS_JOB_OPENING_ID , TM.EMPLID , A.HRS_JO_TYPE , A.HRS_PRM_PST_TITLE , A.HRS_PRM_JOBCODE , A.HRS_PRM_POSITION , A.STATUS_CODE , A.OPEN_DT , A.BUSINESS_UNIT , A.COMPANY , A.DEPTID , A.HRS_PRM_LOCATION , A.HRS_PRM_LOC_AREA , A.HOT_JOB , A.ORIGINATOR_ID , A.MANAGER_ID , A.RECRUITER_ID , A.HRS_ROW_ADD_DTTM , A.HRS_ROW_ADD_OPRID , A.OPENINGS_TARGET , A.OPENINGS_CNT FROM PS_HRS_JOB_OPENING A , PS_HRS_JO_TEAM TM , PS_HRS_STS_TBL B WHERE TM.HRS_JOB_OPENING_ID = A.HRS_JOB_OPENING_ID AND B.STATUS_CODE = A.STATUS_CODE AND TM.HRS_JO_TM_TYPE = 'M' AND B.STATUS_AREA = '1' AND B.OPEN_STS_IND = 'Y'

  • Related Language Record: HRS_JO_SEC_LN_2

    • # 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 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    3 HRS_JO_TYPE Character(1) VARCHAR2(1) NOT NULL Job Opening Type
    P=Continuous Job Opening
    R=Standard Requisition
    4 POSTING_TITLE Character(200) VARCHAR2(200) NOT NULL Job posting title
    5 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code
    6 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number
    7 STATUS_CODE Character(3) VARCHAR2(3) NOT NULL Identifies a status.
    8 OPEN_DT Date(10) DATE Created
    9 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    10 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
    11 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
    12 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
    13 HRS_LOCATION_ID Number(15,0) DECIMAL(15) NOT NULL Recruiting location area
    14 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

    Y/N Table Edit

    15 ORIGINATOR_ID Character(11) VARCHAR2(11) NOT NULL Originator's ID
    16 MANAGER_ID Character(11) VARCHAR2(11) NOT NULL Manager ID
    17 RECRUITER_ID Character(11) VARCHAR2(11) NOT NULL Recruiter ID
    18 HRS_ROW_ADD_DTTM DateTime(26) TIMESTAMP Row Added DateTime
    19 HRS_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Added Operator Id
    20 OPENINGS_TARGET Number(3,0) SMALLINT NOT NULL Tracks number of target openings
    21 OPENINGS_CNT Number(3,0) SMALLINT NOT NULL Tracks number of openings