FO_JOBTITLE_VW2 (SQL View)	Index Back
Jobtitle View for People Match has JOBTITLE as the main key instead of the job category.

FO_JOBTITLE_VW2

(SQL View)

Jobtitle View for People Match

has JOBTITLE as the main key instead of the job category.

SELECT FO_JOBTITLE ,JOB_CAT ,DESCR100 FROM PS_FO_JOBTITLE

Related Language Record: FO_JOBTTL_LNGVW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 FO_JOBTITLE Character(9) VARCHAR2(9) NOT NULL Job Title Code

2 JOB_CAT Character(3) VARCHAR2(3) NOT NULL Job Category

3 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	FO_JOBTITLE	Character(9)	VARCHAR2(9) NOT NULL	Job Title Code
2	JOB_CAT	Character(3)	VARCHAR2(3) NOT NULL	Job Category
3	DESCR100	Character(100)	VARCHAR2(100) NOT NULL	Length 100 Description