HRS_CE_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.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.DESIRED_START_DT , A.WC_COUNCIL_ID , A.ENCUMB_DT_INDC , A.PROJECTED_FILL_DT , A.ESTABID , A.CITIZENSHIP_STATUS , A.MIN_AGE , A.MAX_AGE , A.SEX , A.GVT_CONSIDER_AREA , A.GVT_DRAFT_STATUS , A.HRS_G_JO_TYPE , %subrec(HRS_AUDIT_SBR, A) FROM PS_HRS_JO_I A

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

5 ORIGINATOR_ID Character(11) VARCHAR2(11) NOT NULL Originator's ID
6 OPEN_DT Date(10) DATE Created

Default Value: %date

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

Prompt Table: HRS_STS_JO_I

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

Prompt Table: HRS_RSN_JO_I

10 STATUS_DT Date(10) DATE Status Date

Default Value: %date

11 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

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

Default Value: 1

14 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

15 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

16 SETID_DEPT Character(5) VARCHAR2(5) NOT NULL Department SetID
17 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

Prompt Table: HRS_DEPT_I

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

Prompt Table: HRS_COMPANY_I

19 DESIRED_START_DT Date(10) DATE Desired Start Date

Default Value: %date

20 WC_COUNCIL_ID Character(9) VARCHAR2(9) NOT NULL Works Council ID

Prompt Table: HRS_WC_CNCL_I

21 ENCUMB_DT_INDC Character(1) VARCHAR2(1) NOT NULL Encumbrance Date Indicator
A=Authorization Date
P=Project Fill Date
22 PROJECTED_FILL_DT Date(10) DATE Projected Fill Date
23 ESTABID Character(12) VARCHAR2(12) NOT NULL Establishment ID
24 CITIZENSHIP_STATUS Character(1) VARCHAR2(1) NOT NULL Citizenship Status
25 MIN_AGE Number(3,0) SMALLINT NOT NULL Monimum age used for Benefits process.
26 MAX_AGE Number(3,0) SMALLINT NOT NULL Max age used for Benefits process
27 SEX Character(1) VARCHAR2(1) NOT NULL Gender
F=Female
M=Male
U=Unknown
X=Indeterminate/Intersex/Unspec
28 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
29 GVT_DRAFT_STATUS Character(1) VARCHAR2(1) NOT NULL Draft Status
N=Not Yet Registered
R=Registered
X=Not Applicable
30 HRS_G_JO_TYPE Character(1) VARCHAR2(1) NOT NULL Federal job requisition type
I=Internal
M=Merit Promotion
O=Open Competition
31 HRS_ROW_ADD_DTTM DateTime(26) TIMESTAMP Row Added DateTime
32 HRS_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Added Operator Id
33 HRS_ROW_UPD_DTTM DateTime(26) TIMESTAMP Row Updated DateTime
34 HRS_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Updated Operator Id