HRS_JOBOPENLVW3 (SQL View)	Index Back
JOB OPEN HEADER VIEW Fluid Approval - Job opening

HRS_JOBOPENLVW3

(SQL View)

JOB OPEN HEADER VIEW

Fluid Approval - Job opening

SELECT DISTINCT J.HRS_JOB_OPENING_ID , RL.LANGUAGE_CD , RL.HRS_PRM_PST_TITLE FROM PS_HRS_JOB_OPENING J , PS_HRS_JO_LNG RL WHERE J.HRS_JOB_OPENING_ID = RL.HRS_JOB_OPENING_ID

Related Language Record for HRS_JOBOPEN_VW3

# 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

3 POSTING_TITLE Character(200) VARCHAR2(200) NOT NULL Job posting title

#	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	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
3	POSTING_TITLE	Character(200)	VARCHAR2(200) NOT NULL	Job posting title