HR_SP_JPM_JOB_I (SQL View)	Index Back
Succession Planning Processing used as interface view into JPM searches by interest list

HR_SP_JPM_JOB_I

(SQL View)

Succession Planning Processing

used as interface view into JPM searches by interest list

SELECT SEC.OPRID , a.EMPLID ,b.EMPL_RCD ,a.JPM_CAT_SETID ,a.JPM_RLAT_KEY1 FROM PS_JPM_JOB_INT_I a ,PS_JOB_CURR_VW b , PS_EMPLMT_SRCH_COR SEC WHERE a.EMPLID = b.EMPLID AND b.EMPLID = SEC.EMPLID AND b.EMPL_RCD = SEC.EMPL_RCD AND SEC.HR_STATUS = 'A' GROUP BY SEC.OPRID, a.EMPLID ,b.EMPL_RCD ,a.JPM_CAT_SETID ,a.JPM_RLAT_KEY1

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

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

3 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record

4 JPM_CAT_SETID Character(5) VARCHAR2(5) NOT NULL Optional property of an item in Profiles to provide a setid value, often used in conjunction with another property that is setid based.

5 JPM_RLAT_KEY1 Character(30) VARCHAR2(30) NOT NULL Key value identifying the external data being related to JPM data. Example- Job Codes (external data) being related to a Profile of a Job (JPM data).

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
4	JPM_CAT_SETID	Character(5)	VARCHAR2(5) NOT NULL	Optional property of an item in Profiles to provide a setid value, often used in conjunction with another property that is setid based.
5	JPM_RLAT_KEY1	Character(30)	VARCHAR2(30) NOT NULL	Key value identifying the external data being related to JPM data. Example- Job Codes (external data) being related to a Profile of a Job (JPM data).