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_JOHJHIS_HST HRS_JOLOCAR_HST HRS_JONOTLN_HST HRS_JO_ATCH HRS_JO_ATCH_HST HRS_JO_ATCH_LNG HRS_JO_EXP HRS_JO_EXP_HST HRS_JO_EXP_I HRS_JO_EXP_LNG HRS_JO_HJ_HIST HRS_JO_LOC HRS_JO_LOC_AREA HRS_JO_LOC_HST HRS_JO_LOC_I HRS_JO_NAME HRS_JO_NAME_HST HRS_JO_NOTE HRS_JO_NOTE_HST HRS_JO_NOTE_LNG HRS_JO_POSN HRS_JO_POSN_HST HRS_JO_POSTING HRS_JO_POST_HST HRS_JO_RPL HRS_JO_RPL_HST HRS_JO_RQMT HRS_JO_RQMT_HST HRS_JO_SCRSM_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_I

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

    Prompt Table: HRS_ACT_PERS_I

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

    Prompt Table: HRS_ACT_PERS_I

    8 GVT_SEL_OFFICIAL Character(11) VARCHAR2(11) NOT NULL Selecting Official

    Prompt Table: HRS_ACT_PERS_I

    9 OPEN_DT Date(10) DATE Created

    Default Value: %date

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

    Prompt Table: HRS_STS_JO_I

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

    Prompt Table: HRS_RSN_JO_I

    13 STATUS_DT Date(10) DATE NOT NULL Status Date

    Default Value: %date

    14 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

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

    Y/N Table Edit

    Default Value: N

    18 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

    19 SETID_DEPT Character(5) VARCHAR2(5) NOT NULL Department SetID
    20 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

    Prompt Table: HRS_DEPT_I

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

    Prompt Table: HRS_COMPANY_I

    22 HRS_PRM_JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code

    Prompt Table: %EDITTABLE

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

    Prompt Table: %EDITTABLE2

    24 HRS_PRM_LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

    Prompt Table: HRS_LOCATN_I

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

    Prompt Table: HRS_RECR_LOC_I

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

    Prompt Table: HRS_WC_CNCL_I

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

    Prompt Table: HRS_ESTAB_I

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

    Prompt Table: HRS_COUNTRY_VW

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

    Prompt Table: HRS_CTZN_STS_I

    35 MIN_AGE Number(3,0) SMALLINT NOT NULL Monimum age used for Benefits process.
    36 MAX_AGE Number(3,0) SMALLINT NOT NULL Max age used for Benefits process
    37 SEX Character(1) VARCHAR2(1) NOT NULL Gender
    F=Female
    M=Male
    U=Unknown
    X=Indeterminate/Intersex/Unspec
    38 HRS_CONTACT_ID Number(15,0) DECIMAL(15) NOT NULL Contact ID

    Prompt Table: HRS_RO_CNTCT_I

    39 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
    40 GVT_DRAFT_STATUS Character(1) VARCHAR2(1) NOT NULL Draft Status
    N=Not Yet Registered
    R=Registered
    X=Not Applicable
    41 HRS_G_JO_TYPE Character(1) VARCHAR2(1) NOT NULL Federal job requisition type
    I=Internal
    M=Merit Promotion
    O=Open Competition
    42 JOB_FAMILY Character(6) VARCHAR2(6) NOT NULL Job Family
    43 HRS_ROW_ADD_DTTM DateTime(26) TIMESTAMP Row Added DateTime
    44 HRS_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Added Operator Id
    45 HRS_ROW_UPD_DTTM DateTime(26) TIMESTAMP Row Updated DateTime
    46 HRS_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Updated Operator Id