HRS_JO_I

(SQL View)
 Index Back

Job Opening Interface

Job opening interface view

SELECT A.HRS_JOB_OPENING_ID , A.HRS_RCRT_TMPL_ID , A.HRS_JO_TYPE , A.REFERRAL_PGM_ID , A.ORIGINATOR_ID , A.MANAGER_ID , A.RECRUITER_ID , A.GVT_SEL_OFFICIAL , A.OPEN_DT , A.CLOSE_DT , A.STATUS_CODE , A.STATUS_REASON , A.STATUS_DT , A.HRS_OPENING_LIMIT , A.OPENINGS_CNT , A.OPENINGS_TARGET , A.HOT_JOB , A.BUSINESS_UNIT , A.SETID_DEPT , A.DEPTID , A.COMPANY , A.HRS_PRM_JOBCODE , A.HRS_PRM_POSITION , A.HRS_PRM_LOCATION , A.HRS_PRM_LOC_AREA , A.HRS_PRM_PST_TITLE , A.DESIRED_START_DT , A.WC_COUNCIL_ID , A.ENCUMB_DT_INDC , A.PROJECTED_FILL_DT , A.ESTABID , A.COUNTRY , A.CITIZENSHIP_STATUS , A.MIN_AGE , A.MAX_AGE , A.SEX , A.HRS_CONTACT_ID , A.GVT_CONSIDER_AREA , A.GVT_DRAFT_STATUS , A.HRS_G_JO_TYPE , A.JOB_FAMILY , %subrec(HRS_AUDIT_SBR, A) FROM PS_HRS_JOB_OPENING A

  • Related Language Record: HRS_JO_LN_I

  • Parent Record Of HRS_JO_JOBCD_I HRS_JO_LOC_AR_I HRS_JO_NAME_I HRS_JO_POSN_I HRS_JO_PSTEXT_I HRS_JO_PSTINT_I HRS_JO_PST_I HRS_JO_ROWEXT_I HRS_JO_ROWINT_I HRS_JO_RQMTJC_I HRS_JO_RQMT_I HRS_JO_RQMT_VW HRS_JO_SITEXT_I HRS_JO_SITINT_I HRS_JO_TEAM_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_RCRT_TMPL_I

    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 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

    Default Value: 1

    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_I

    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 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code

    Prompt Table: HRS_JOBCODE_I

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

    Prompt Table: HRS_POS_DTA_C_I

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

    Prompt Table: HRS_LOCATION_I

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

    Prompt Table: HRS_LOC_I

    26 POSTING_TITLE Character(200) VARCHAR2(200) NOT NULL Job posting title
    27 DESIRED_START_DT Date(10) DATE Desired Start Date

    Default Value: %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 ESTABID Character(12) VARCHAR2(12) NOT NULL Establishment ID
    32 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
    33 CITIZENSHIP_STATUS Character(1) VARCHAR2(1) NOT NULL Citizenship Status

    Prompt Table: HRS_CTZN_STS_I

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

    Prompt Table: HRS_CONTACT

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