HRS_JOB_OPENING(SQL Table) |
Index Back |
---|---|
Job Requisition CodesUse 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 | 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 |