EDUC_AREA_STUDY (SQL View)	Index Back
School Area of Study - GER School Area of Study - GER Release 9 Job Profile Managment (JPM): Table became a view to JPM data. Ownership of table transferred from Human Resources to JPM.

EDUC_AREA_STUDY

(SQL View)

School Area of Study - GER

School Area of Study - GER Release 9 Job Profile Managment (JPM): Table became a view to JPM data. Ownership of table transferred from Human Resources to JPM.

SELECT B.EMPLID ,A.EFFDT ,%Substring(JPM_ADHOC_DESCR, 1, 50) ,%Substring(A.AVERAGE_GRADE,1,4) FROM PS_JPM_JP_ITEMS A , PS_JPM_PROFILE B WHERE A.JPM_PROFILE_ID = B.JPM_PROFILE_ID AND A.JPM_CAT_TYPE = 'AREA STUDY' AND B.JPM_JP_TYPE = ( SELECT JPM_PRI_PERS_TYPE FROM PS_JPM_JP_PRI_TYPE)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

2 DATE_ACQUIRED Date(10) DATE Date Acquired

3 AREA_OF_STUDY Character(50) VARCHAR2(50) NOT NULL Area of Study

4 AREA_OF_STDY_GRADE Character(4) VARCHAR2(4) NOT NULL Area Of Study Grade

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	DATE_ACQUIRED	Date(10)	DATE	Date Acquired
3	AREA_OF_STUDY	Character(50)	VARCHAR2(50) NOT NULL	Area of Study
4	AREA_OF_STDY_GRADE	Character(4)	VARCHAR2(4) NOT NULL	Area Of Study Grade