SPECL_PROJECT (SQL View)	Index Back
EE Special Projects Use SPECL_PROJECT to identify an employee's out-of-the-ordinary projects or achievements that enhance his job skills. Release 9 Job Profile Managment (JPM): Table became a view to JPM data. Ownership of table transferred from Human Resources to JPM.

SPECL_PROJECT

(SQL View)

EE Special Projects

Use SPECL_PROJECT to identify an employee's out-of-the-ordinary projects or achievements that enhance his job skills. 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(A.JPM_TEXT254_4,1,30) ,A.JPM_TEXT1325_1 FROM PS_JPM_JP_ITEMS A , PS_JPM_PROFILE B WHERE A.JPM_PROFILE_ID = B.JPM_PROFILE_ID AND A.JPM_CAT_TYPE = 'SPECL PROJ' AND B.JPM_JP_TYPE = 'PERSON'

Related Language Record: SPECL_PROJ_LNG

Parent record: PERSON

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: PERSON

2 DT_COMPLETED Date(10) DATE NOT NULL Date Completed

3 EMPLOYER Character(30) VARCHAR2(30) NOT NULL Employer

4 DESCRLONG Long Character CLOB Long Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSON
2	DT_COMPLETED	Date(10)	DATE NOT NULL	Date Completed
3	EMPLOYER	Character(30)	VARCHAR2(30) NOT NULL	Employer
4	DESCRLONG	Long Character	CLOB	Long Description