HRS_JO_SEC_I

(SQL View)
Index Back

Job Opening Interface

Job opening interface view

SELECT A.HRS_JOB_OPENING_ID , OPR.OPRID , 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 , PSOPRDEFN OPR WHERE A.HRS_JOB_OPENING_ID IN ( SELECT TM.HRS_JOB_OPENING_ID FROM PS_HRS_JO_TEAM TM WHERE TM.EMPLID = OPR.EMPLID AND TM.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 HRS_RCRT_TMPL_ID Number(15,0) DECIMAL(15) NOT NULL Recruitment Template ID

    Prompt Table: HRS_RCRT_TMPL_I

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

    Prompt Table: HRS_REF_PGM

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

    Prompt Table: HRS_ACT_PERS_I

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

    Prompt Table: HRS_ACT_PERS_I

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

    Prompt Table: HRS_ACT_PERS_I

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

    Prompt Table: HRS_ACT_PERS_I

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

    Default Value: 1

    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_I

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

    Prompt Table: HRS_JOBCODE_I

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

    Prompt Table: HRS_POS_DTA_C_I

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

    Prompt Table: HRS_LOCATION_I

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

    Prompt Table: HRS_LOC_I

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

    Default Value: %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 ESTABID Character(12) VARCHAR2(12) NOT NULL Establishment ID
    33 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
    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 Minimum age for employee benefits
    36 MAX_AGE Number(3,0) SMALLINT NOT NULL Maximum age for employee benefits
    37 SEX Character(1) VARCHAR2(1) NOT NULL Gender
    F=Female
    M=Male
    U=Unknown
    38 HRS_CONTACT_ID Number(15,0) DECIMAL(15) NOT NULL Contact Id

    Prompt Table: HRS_CONTACT

    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