HRS_JOB_OPENING

(SQL Table)
Index Back

Job Requisition Codes

Use JOB_REQUISITION to record information for job requisitons such as job code, department, position ID, authorization data, status, and status dates. This data is used primarily in Recruitment. You can create only one JOB_REQUISITION record per requisition.

  • Related Language Record: HRS_JO_LNG
  • Parent Record Of HRS_G_JOPRI_HST HRS_G_JO_PRI HRS_HJ_HISTD_VW HRS_JOATCLN_HST HRS_JOHJHIS_HST HRS_JOITEMSHST HRS_JOLOCAR_HST HRS_JONOTLN_HST HRS_JOPRF_TMP HRS_JOPROFLHST HRS_JO_APP_P_LN HRS_JO_APP_P_VW HRS_JO_ATCH HRS_JO_ATCH_HST HRS_JO_ATCH_LNG HRS_JO_EXLN_HST HRS_JO_EXP HRS_JO_EXP_HST HRS_JO_EXP_I HRS_JO_EXP_LNG HRS_JO_EXP_LNI HRS_JO_HJ_HIST HRS_JO_LAREA_VW HRS_JO_LOC HRS_JO_LOC_AREA HRS_JO_LOC_HST HRS_JO_LOC_I HRS_JO_LOC_VW HRS_JO_NAME HRS_JO_NAME_HST HRS_JO_NOTE HRS_JO_NOTE_HST HRS_JO_NOTE_LNG HRS_JO_POSN HRS_JO_POSNVW2L HRS_JO_POSN_HST HRS_JO_POSN_VW HRS_JO_POSTING HRS_JO_POST_HST HRS_JO_PRFL_WRK HRS_JO_PROFILE HRS_JO_PROFL_V2 HRS_JO_PROFL_VW HRS_JO_RPL HRS_JO_RPL_HST HRS_JO_RQMT HRS_JO_RQMT_HST HRS_JO_SCRSM_VW HRS_JO_SCR_S_VW HRS_JO_STS HRS_JO_STS_HST HRS_JO_TEAM HRS_JO_TEAM_HST HRS_PSN HRS_SCRTMPL_LNG HRS_SCR_LVL HRS_SCR_TMPL HRS_SCR_TMPL_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 HRS_RCRT_TMPL_ID Number(15,0) DECIMAL(15) NOT NULL Recruitment Template ID

    Prompt Table: HRS_RCRTTMPL_VW

    3 HRS_JO_TYPE Character(1) VARCHAR2(1) NOT NULL Job Opening Type
    P=Continuous Job Opening
    R=Standard Requisition
    4 REFERRAL_PGM_ID Character(12) VARCHAR2(12) NOT NULL Employee referral program ID

    Prompt Table: HRS_REF_PGM

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

    Prompt Table: HRS_ACT_PERS_I1

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

    Prompt Table: HRS_ACT_PERS_I1

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

    Prompt Table: HRS_ACT_PERS_I1

    8 HRS_JO_CLONE_ID Number(15,0) DECIMAL(15) NOT NULL Job Opening Clone
    9 GVT_SEL_OFFICIAL Character(11) VARCHAR2(11) NOT NULL Selecting Official

    Prompt Table: HRS_ACT_PERS_I1

    10 OPEN_DT Date(10) DATE Created

    Default Value: %date

    11 CLOSE_DT Date(10) DATE Date Closed
    12 STATUS_CODE Character(3) VARCHAR2(3) NOT NULL Identifies a status.

    Prompt Table: HRS_STS_JO_I

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

    Prompt Table: HRS_RSN_JO_I

    14 STATUS_DT Date(10) DATE NOT NULL Status Date

    Default Value: %date

    15 HRS_OPENING_LIMIT Character(1) VARCHAR2(1) NOT NULL Unlimited or limited number of job openings flag
    L=Limited Number of Openings
    U=Unlimited Number of Openings

    Default Value: L

    16 OPENINGS_CNT Number(3,0) SMALLINT NOT NULL Tracks number of openings
    17 OPENINGS_TARGET Number(3,0) SMALLINT NOT NULL Tracks number of target openings
    18 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

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

    Default Value: OPR_DEF_TBL_HR.BUSINESS_UNIT

    Prompt Table: HRS_BS_UNT_HR_J

    20 SETID_DEPT Character(5) VARCHAR2(5) NOT NULL Department Set ID
    21 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

    Prompt Table: HRS_DEPT_I

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

    Prompt Table: HRS_COMPANY_I

    23 HRS_PRM_JOBCODE Character(6) VARCHAR2(6) NOT NULL Primary Job Code of Job Opening.

    Prompt Table: %EDITTABLE

    24 HRS_PRM_POSITION Character(8) VARCHAR2(8) NOT NULL Position Number

    Prompt Table: %EDITTABLE2

    25 HRS_PRM_LOCATION Character(10) VARCHAR2(10) NOT NULL Primary Recruiting Location of Job Opening,

    Prompt Table: HRS_LOCATN_I

    26 HRS_PRM_LOC_AREA Number(15,0) DECIMAL(15) NOT NULL Primary recruiting location area

    Prompt Table: HRS_RECR_LOC_I

    27 HRS_PRM_PST_TITLE Character(200) VARCHAR2(200) NOT NULL Job posting title
    28 DESIRED_START_DT Date(10) DATE Desired Start Date
    29 WC_COUNCIL_ID Character(9) VARCHAR2(9) NOT NULL Works Council ID

    Prompt Table: HRS_WC_CNCL_I

    30 ENCUMB_DT_INDC Character(1) VARCHAR2(1) NOT NULL Encumbrance Date Indicator
    A=Authorization Date
    P=Project Fill Date
    31 PROJECTED_FILL_DT Date(10) DATE Projected Fill Date
    32 AUTHORIZATION_DT Date(10) DATE Date Authorized
    33 ESTABID Character(12) VARCHAR2(12) NOT NULL Establishment ID

    Prompt Table: HRS_ESTAB_I

    34 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: HRS_COUNTRY_VW

    35 CITIZENSHIP_STATUS Character(1) VARCHAR2(1) NOT NULL Citizenship Status

    Prompt Table: HRS_CTZN_STS_I

    36 MIN_AGE Number(3,0) SMALLINT NOT NULL Minimum age for employee benefits
    37 MAX_AGE Number(3,0) SMALLINT NOT NULL Maximum age for employee benefits
    38 SEX Character(1) VARCHAR2(1) NOT NULL Gender
    F=Female
    M=Male
    U=Unknown
    39 HRS_CONTACT_ID Number(15,0) DECIMAL(15) NOT NULL Contact Id

    Prompt Table: HRS_RO_CNTCT_I

    40 GVT_CONSIDER_AREA Character(1) VARCHAR2(1) NOT NULL Area of Consideration
    A=Agency
    E=External Government
    F=Federal Government
    N=Nationwide
    S=Subagency
    W=Worldwide
    41 GVT_DRAFT_STATUS Character(1) VARCHAR2(1) NOT NULL Draft Status
    N=Not Yet Registered
    R=Registered
    X=Not Applicable
    42 HRS_G_JO_TYPE Character(1) VARCHAR2(1) NOT NULL Federal job requisition type
    I=Internal
    M=Merit Promotion
    O=Open Competition
    43 JOB_FAMILY Character(6) VARCHAR2(6) NOT NULL Job Family
    44 HRS_RFRL_S_SRC_REQ Character(1) VARCHAR2(1) NOT NULL Used to define if Referral subsource is mandatory when applying for a job opening.
    45 HRS_RFRL_SRC_REQ Character(1) VARCHAR2(1) NOT NULL Used to define if Referral source is mandatory when applying for a job opening.
    46 HRS_JOB_MULT_LOCS Character(1) VARCHAR2(1) NOT NULL Multiple locations inidecator on Job openings
    N=No
    Y=Yes
    47 HRS_ASK_US_ELIG Character(1) VARCHAR2(1) NOT NULL Ask US Job Eligibility Information
    N=No
    Y=Yes

    Default Value: N

    48 HRS_US_ELIG_REQ Character(1) VARCHAR2(1) NOT NULL Ask US Job Eligibility Information
    N=Not Required
    Y=Required

    Default Value: N

    49 HRS_ASK_FORMER_EMP Character(1) VARCHAR2(1) NOT NULL Ask Former Employee Information
    N=No
    Y=Yes

    Default Value: Y

    50 HRS_FORMER_EMP_REQ Character(1) VARCHAR2(1) NOT NULL Ask Former Employee Information
    N=Not Required
    Y=Required

    Default Value: N

    51 HRS_ROW_ADD_DTTM DateTime(26) TIMESTAMP Row Added DateTime
    52 HRS_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Added Operator Id
    53 HRS_ROW_UPD_DTTM DateTime(26) TIMESTAMP Row Updated DateTime
    54 HRS_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Updated Operator Id
    55 HRS_TRG_UPD_DTTM DateTime(26) TIMESTAMP Search Index Updated DateTime

    Default Value: %datetime