EG_SPECIAL_PRJ (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 HRMS EG to JPM.

EG_SPECIAL_PRJ

(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 HRMS EG to JPM.

SELECT B.EMPLID ,A.EFFDT ,A.SETID_DEPT ,A.DEPTID ,%Substring(A.JPM_TEXT254_4,1,50) ,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 = 'EG SPCL PROJ' 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
Prompt Table: PERSON

2 DT_COMPLETED Date(10) DATE NOT NULL Date Completed

3 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Default Value: OPR_DEF_TBL_HR.SETID

4 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
Default Value: JOB.DEPTID
Prompt Table: DEPT_TBL

5 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50

6 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	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Default Value: OPR_DEF_TBL_HR.SETID
4	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department Default Value: JOB.DEPTID Prompt Table: DEPT_TBL
5	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50
6	DESCRLONG	Long Character	CLOB	Long Description