JPM_CAT_I_RL_VW (SQL View)	Index Back
Catalog Relationships Talent Mgmt - Defines relationship between Catalog Items.

JPM_CAT_I_RL_VW

(SQL View)

Catalog Relationships

Talent Mgmt - Defines relationship between Catalog Items.

SELECT JPM_CAT_TYPE , JPM_CAT_ITEM_ID , JPM_CAT_TYPE2 , JPM_CAT_ITEM_ID2 FROM PS_JPM_CAT_I_RLAT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 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.
Prompt Table: JPM_CAT_TYPES

2 JPM_CAT_ITEM_ID Character(12) VARCHAR2(12) NOT NULL Catalog Item Id. Identifies a unique catalog item defintion within a catalog type.
Prompt Table: JPM_CAT_ITEMS

3 JPM_CAT_TYPE2 Character(12) VARCHAR2(12) NOT NULL Secondary content item type (as in a related item- such as a child or a supporting item of another item).
Prompt Table: JPM_CAT_TYP2_VW

4 JPM_CAT_ITEM_ID2 Character(12) VARCHAR2(12) NOT NULL Secondary content item id (as in a related item- such as a child or a supporting item of another item).
Prompt Table: JPM_CAT_ITM2_VW

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	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. Prompt Table: JPM_CAT_TYPES
2	JPM_CAT_ITEM_ID	Character(12)	VARCHAR2(12) NOT NULL	Catalog Item Id. Identifies a unique catalog item defintion within a catalog type. Prompt Table: JPM_CAT_ITEMS
3	JPM_CAT_TYPE2	Character(12)	VARCHAR2(12) NOT NULL	Secondary content item type (as in a related item- such as a child or a supporting item of another item). Prompt Table: JPM_CAT_TYP2_VW
4	JPM_CAT_ITEM_ID2	Character(12)	VARCHAR2(12) NOT NULL	Secondary content item id (as in a related item- such as a child or a supporting item of another item). Prompt Table: JPM_CAT_ITM2_VW