HRS_JOBOPEN_HST

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

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PSARCH_ID Character(8) VARCHAR2(8) NOT NULL Archive ID (see PSARCHTEMPLATE).
2 PSARCH_BATCHNUM Number(30,0) DECIMAL(30) NOT NULL Archive Batch Number
3 HRS_JOB_OPENING_ID Number(15,0) DECIMAL(15) NOT NULL Job Opening Clone
4 HRS_RCRT_TMPL_ID Number(15,0) DECIMAL(15) NOT NULL Recruitment Template ID

Prompt Table: HRS_RCRTTMPL_VW

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

Prompt Table: HRS_REF_PGM

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

Prompt Table: HRS_PERSON_NM_I

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

Prompt Table: HRS_PERSON_NM_I

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

Prompt Table: HRS_PERSON_NM_I

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

Prompt Table: HRS_PERSON_NM_I

12 OPEN_DT Date(10) DATE Created

Default Value: %date

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

Prompt Table: HRS_STS_JO_I

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

Prompt Table: HRS_RSN_JO_I

16 STATUS_DT Date(10) DATE NOT NULL Status Date

Default Value: %date

17 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

18 OPENINGS_CNT Number(3,0) SMALLINT NOT NULL Tracks number of openings
19 OPENINGS_TARGET Number(3,0) SMALLINT NOT NULL Tracks number of target openings

Default Value: 1

20 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

21 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

22 SETID_DEPT Character(5) VARCHAR2(5) NOT NULL Department Set ID
23 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

Prompt Table: HRS_DEPT_I

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

Prompt Table: HRS_COMPANY_I

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

Prompt Table: HRS_JOBCODE_I

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

Prompt Table: HRS_POS_DTA_C_I

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

Prompt Table: HRS_LOCATION_I

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

Prompt Table: HRS_LOCATION

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

Prompt Table: HRS_WC_CNCL_I

32 ENCUMB_DT_INDC Character(1) VARCHAR2(1) NOT NULL Encumbrance Date Indicator
A=Authorization Date
P=Project Fill Date
33 PROJECTED_FILL_DT Date(10) DATE Projected Fill Date
34 AUTHORIZATION_DT Date(10) DATE Date Authorized
35 ESTABID Character(12) VARCHAR2(12) NOT NULL Establishment ID
36 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
37 CITIZENSHIP_STATUS Character(1) VARCHAR2(1) NOT NULL Citizenship Status

Prompt Table: HRS_CTZN_STS_I

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

Prompt Table: HRS_CONTACT

42 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
43 GVT_DRAFT_STATUS Character(1) VARCHAR2(1) NOT NULL Draft Status
N=Not Yet Registered
R=Registered
X=Not Applicable
44 HRS_G_JO_TYPE Character(1) VARCHAR2(1) NOT NULL Federal job requisition type
I=Internal
M=Merit Promotion
O=Open Competition
45 JOB_FAMILY Character(6) VARCHAR2(6) NOT NULL Job Family
46 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.
47 HRS_RFRL_SRC_REQ Character(1) VARCHAR2(1) NOT NULL Used to define if Referral source is mandatory when applying for a job opening.
48 HRS_JOB_MULT_LOCS Character(1) VARCHAR2(1) NOT NULL Multiple locations inidecator on Job openings
N=No
Y=Yes
49 HRS_ASK_US_ELIG Character(1) VARCHAR2(1) NOT NULL Ask US Job Eligibility Information
N=No
Y=Yes

Default Value: N

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

Default Value: N

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

Default Value: Y

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

Default Value: N

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