HRS_JO_IN

(SQL View)
 Index Back

Job Opening Interface

Job opening interface view

SELECT A.HRS_JOB_OPENING_ID , A.OPRID , A.HRS_JO_TYPE , A.ORIGINATOR_ID , A.MANAGER_ID , A.RECRUITER_ID , A.OPEN_DT , A.STATUS_CODE , A.STATUS_REASON , A.STATUS_DT , A.OPENINGS_TARGET , A.HOT_JOB , A.BUSINESS_UNIT , A.DEPTID , A.COMPANY , A.JOBCODE , A.POSITION_NBR , A.LOCATION , A.HRS_LOCATION_ID , A.POSTING_TITLE , A.HRS_CONTACT_ID FROM PS_HRS_JO_ALL_I A , PS_HRS_EXTPOST_STS B , PS_HRS_STS_JO_I C WHERE A.HRS_JOB_OPENING_ID = B.HRS_JOB_OPENING_ID AND A.STATUS_CODE = C.STATUS_CODE AND C.OPEN_STS_IND = 'Y' AND B.HRS_SOURCE_ID IN ( SELECT D.HRS_SOURCE_ID FROM PS_HRS_SOURCE D WHERE D.HRS_SOURCE_STATUS = '10' AND (D.HRS_SOURCE_TYPE = '10' AND D.HRS_SOURCE_ID IN ( SELECT E.HRS_SOURCE_ID FROM PS_HRS_SOURCE E , PS_HRS_VENDOR F , PS_HRS_SOURCE_VNDR C WHERE D.EFFDT = E.EFFDT AND E.HRS_SOURCE_TYPE = '10' AND F.HRS_VENDOR_ID = C.HRS_VENDOR_ID AND E.HRS_SOURCE_ID = C.HRS_SOURCE_ID AND E.EFFDT = C.EFFDT AND F.HRS_TG_ID = 3 AND F.HRS_VENDOR_STATUS = '10')))

  • Related Language Record: HRS_JO_SEC_LN_I

    • # 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 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    3 HRS_JO_TYPE Character(1) VARCHAR2(1) NOT NULL Job Opening Type
    P=Continuous Job Opening
    R=Standard Requisition
    4 ORIGINATOR_ID Character(11) VARCHAR2(11) NOT NULL Originator's ID

    Prompt Table: HRS_ACT_PERS_I

    5 MANAGER_ID Character(11) VARCHAR2(11) NOT NULL Manager ID

    Prompt Table: HRS_ACT_PERS_I

    6 RECRUITER_ID Character(11) VARCHAR2(11) NOT NULL Recruiter ID

    Prompt Table: HRS_ACT_PERS_I

    7 OPEN_DT Date(10) DATE Created

    Default Value: %date

    8 STATUS_CODE Character(3) VARCHAR2(3) NOT NULL Identifies a status.

    Prompt Table: HRS_STS_JO_I

    9 STATUS_REASON Character(3) VARCHAR2(3) NOT NULL Identifies a reason associated with a particular status.

    Prompt Table: HRS_RSN_JO_I

    10 STATUS_DT Date(10) DATE Status Date

    Default Value: %date

    11 OPENINGS_TARGET Number(3,0) SMALLINT NOT NULL Tracks number of target openings

    Default Value: 1

    12 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

    Default Value: N

    13 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Default Value: OPR_DEF_TBL_HR.BUSINESS_UNIT

    Prompt Table: HRS_BS_UNT_HR_I

    14 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

    Prompt Table: HRS_DEPT_I

    15 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

    Prompt Table: HRS_COMPANY_I

    16 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code

    Prompt Table: HRS_JOBCODE_I

    17 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number

    Prompt Table: HRS_POS_DTA_C_I

    18 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

    Prompt Table: HRS_LOCATION_I

    19 HRS_LOCATION_ID Number(15,0) DECIMAL(15) NOT NULL Recruiting location area

    Prompt Table: HRS_LOC_I

    20 POSTING_TITLE Character(200) VARCHAR2(200) NOT NULL Job posting title
    21 HRS_CONTACT_ID Number(15,0) DECIMAL(15) NOT NULL Contact Id

    Prompt Table: HRS_CONTACT