HRS_JPST_LN_VW

(SQL View)
 Index Back

Search

Job Posting verity index view

SELECT A.HRS_JOB_OPENING_ID ,A.HRS_JO_PST_SEQ ,B.LANGUAGE_CD ,A.HRS_JO_PST_TYPE ,A.HRS_SOURCE_ID ,A.HRS_SOURCE_TYPE ,B.POSTING_TITLE ,A.HRS_JO_PRM_PST_FLG ,A.OPEN_DT ,A.CLOSE_DT ,A.HRS_JO_TYPE ,A.JOBCODE ,A.POSITION_NBR ,A.STATUS_CODE ,A.BUSINESS_UNIT ,A.COMPANY ,A.DEPTID ,A.LOCATION ,A.HRS_LOCATION_ID ,A.HOT_JOB ,A.ORIGINATOR_ID ,A.MANAGER_ID ,A.RECRUITER_ID FROM PS_HRS_JO_PSTBTH_I A , PS_HRS_JO_PST_LN_I B WHERE A.HRS_JOB_OPENING_ID = B.HRS_JOB_OPENING_ID AND A.HRS_JO_PST_SEQ = B.HRS_JO_PST_SEQ

# 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_JO_PST_SEQ Number(3,0) SMALLINT NOT NULL Job opening posting sequence

Prompt Table: HRS_JO_PST_I

3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
4 HRS_JO_PST_TYPE Character(1) VARCHAR2(1) NOT NULL Job Opening Posting Type
C=Contingent Workforce
E=External Posting
I=Internal Posting
L=Labor Office
R=Recruitment
5 HRS_SOURCE_ID Number(15,0) DECIMAL(15) NOT NULL Source ID
6 HRS_SOURCE_TYPE Character(3) VARCHAR2(3) NOT NULL Recruiting Source Type
10=Vendor
20=Marketing
30=Employee
40=Company
50=D-List
7 POSTING_TITLE Character(200) VARCHAR2(200) NOT NULL Job posting title
8 HRS_JO_PRM_PST_FLG Character(1) VARCHAR2(1) NOT NULL Primary posting title flag

Y/N Table Edit

Default Value: N

9 OPEN_DT Date(10) DATE Created
10 CLOSE_DT Date(10) DATE Date Closed
11 HRS_JO_TYPE Character(1) VARCHAR2(1) NOT NULL Job Opening Type
P=Continuous Job Opening
R=Standard Requisition
12 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code

Prompt Table: HRS_JOBCODE_I

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

Prompt Table: HRS_POS_DTA_C_I

14 STATUS_CODE Character(3) VARCHAR2(3) NOT NULL Identifies a status.

Prompt Table: HRS_STS_JO_I

15 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: HRS_BS_UNT_HR_I

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

Prompt Table: HRS_COMPANY_I

17 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

Prompt Table: HRS_DEPT_I

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

Prompt Table: HRS_LOCATION_I

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

Prompt Table: HRS_JO_LOC_AR_I

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

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

Prompt Table: HRS_ACT_PERS_I

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

Prompt Table: HRS_ACT_PERS_I

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

Prompt Table: HRS_ACT_PERS_I