HRS_MY_JO_OP_I2

(SQL View)
 Index Back

Open Job Openings Interface

Interface for job openings that are in an open status for current user.

SELECT DISTINCT A.HRS_JOB_OPENING_ID , SEC.OPRID , SEC.EMPLID , A.HRS_JO_TYPE , A.HRS_PRM_PST_TITLE , A.HRS_PRM_POSITION , A.STATUS_CODE , A.STATUS_DT , A.OPEN_DT , A.BUSINESS_UNIT , A.DEPTID , A.HOT_JOB , A.ORIGINATOR_ID , A.MANAGER_ID , A.RECRUITER_ID , A.HRS_CONTACT_ID , CASE WHEN CATG.HRS_JOBCAT_ID <> ' ' THEN CATG.HRS_JOBCAT_ID ELSE 'NO' END FROM PS_HRS_JOB_OPENING A , PS_HRS_JO_SEC_VW SEC LEFT OUTER JOIN PS_HRS_JO_JOB_CATG CATG ON CATG.HRS_JOB_OPENING_ID = SEC.HRS_JOB_OPENING_ID AND CATG.OPRID = SEC.OPRID WHERE SEC.HRS_JOB_OPENING_ID = A.HRS_JOB_OPENING_ID

  • 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 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    4 HRS_JO_TYPE Character(1) VARCHAR2(1) NOT NULL Job Opening Type
    P=Continuous Job Opening
    R=Standard Requisition
    5 POSTING_TITLE Character(200) VARCHAR2(200) NOT NULL Job posting title
    6 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number

    Prompt Table: HRS_POS_DTA_C_I

    7 STATUS_CODE Character(3) VARCHAR2(3) NOT NULL Identifies a status.
    8 STATUS_DT Date(10) DATE Status Date
    9 OPEN_DT Date(10) DATE Created
    10 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: HRS_BS_UNT_HR_I

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

    Prompt Table: HRS_DEPT_I

    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

    13 ORIGINATOR_ID Character(11) VARCHAR2(11) NOT NULL Originator's ID

    Prompt Table: HRS_ACT_PERS_I

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

    Prompt Table: HRS_ACT_PERS_I

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

    Prompt Table: HRS_ACT_PERS_I

    16 HRS_CONTACT_ID Number(15,0) DECIMAL(15) NOT NULL Contact Id
    17 HRS_JOBCAT_ID Character(4) VARCHAR2(4) NOT NULL Job Categoriation Id