JPM_JP_ITEM_V3 (SQL View)	Index Back
Catalog Items - Talent Mgmt Defines all of the Catalog Items for a particular Catalog Type

JPM_JP_ITEM_V3

(SQL View)

Catalog Items - Talent Mgmt

Defines all of the Catalog Items for a particular Catalog Type

SELECT A.JPM_PROFILE_ID , A.JPM_CAT_TYPE , A.JPM_CAT_ITEM_ID , A.JPM_CAT_ITEM_QUAL , A.EFFDT , A.EFF_STATUS , A.JPM_JP_ITEM_SRC , A.JPM_SOURCE_ID1 , A.JPM_SOURCE_ID2 , A.JPM_SOURCE_ID3 , B.JPM_SUBSCRIBE FROM PS_JPM_JP_ITEMS A , PS_JPM_PROFILE B WHERE B.JPM_PROFILE_ID = A.JPM_PROFILE_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 JPM_PROFILE_ID Character(12) VARCHAR2(12) NOT NULL The id, autoassigned or user assigned of the profile. This id is used to group items and other related material together into one coherent profile.

2 JPM_CAT_TYPE Character(12) VARCHAR2(12) NOT NULL The name of the type of items that will be used in a Catalog and or in a Profile.

3 JPM_CAT_ITEM_ID Character(12) VARCHAR2(12) NOT NULL Catalog Item Id. Identifies a unique catalog item defintion within a catalog type.

4 JPM_CAT_ITEM_QUAL Character(12) VARCHAR2(12) NOT NULL Low Order Item key for Catalog Items when appearing in a Profile. For most Catalog Types, this will be blank - but is available if an Item needs to have multiple instances for a given Effdt in a Profile. Example: for CatalogType = Compentency, there can be multiple instances for a particular Competency, each representing a different evaluation source (Self-Eval, Mgr Eval, Approved/Official, Learning, Recruiting).

5 EFFDT Date(10) DATE Effective Date
Default Value: %date

6 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive

7 JPM_JP_ITEM_SRC Character(4) VARCHAR2(4) NOT NULL Indicates the source of a JPM profile item
CGRP=Catalog Group
ELM=Learning Management
EP=ePerformance
PROF=Another Profile

8 JPM_SOURCE_ID1 Character(12) VARCHAR2(12) NOT NULL JPM Profile Item Source ID1

9 JPM_SOURCE_ID2 Character(12) VARCHAR2(12) NOT NULL JPM Profile Item Source ID3

10 JPM_SOURCE_ID3 Character(12) VARCHAR2(12) NOT NULL JPM Profile Item Source ID3

11 JPM_SUBSCRIBE Character(1) VARCHAR2(1) NOT NULL JPM Subscribe field
Y/N Table Edit

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	JPM_PROFILE_ID	Character(12)	VARCHAR2(12) NOT NULL	The id, autoassigned or user assigned of the profile. This id is used to group items and other related material together into one coherent profile.
2	JPM_CAT_TYPE	Character(12)	VARCHAR2(12) NOT NULL	The name of the type of items that will be used in a Catalog and or in a Profile.
3	JPM_CAT_ITEM_ID	Character(12)	VARCHAR2(12) NOT NULL	Catalog Item Id. Identifies a unique catalog item defintion within a catalog type.
4	JPM_CAT_ITEM_QUAL	Character(12)	VARCHAR2(12) NOT NULL	Low Order Item key for Catalog Items when appearing in a Profile. For most Catalog Types, this will be blank - but is available if an Item needs to have multiple instances for a given Effdt in a Profile. Example: for CatalogType = Compentency, there can be multiple instances for a particular Competency, each representing a different evaluation source (Self-Eval, Mgr Eval, Approved/Official, Learning, Recruiting).
5	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
6	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive
7	JPM_JP_ITEM_SRC	Character(4)	VARCHAR2(4) NOT NULL	Indicates the source of a JPM profile item CGRP=Catalog Group ELM=Learning Management EP=ePerformance PROF=Another Profile
8	JPM_SOURCE_ID1	Character(12)	VARCHAR2(12) NOT NULL	JPM Profile Item Source ID1
9	JPM_SOURCE_ID2	Character(12)	VARCHAR2(12) NOT NULL	JPM Profile Item Source ID3
10	JPM_SOURCE_ID3	Character(12)	VARCHAR2(12) NOT NULL	JPM Profile Item Source ID3
11	JPM_SUBSCRIBE	Character(1)	VARCHAR2(1) NOT NULL	JPM Subscribe field Y/N Table Edit