JPM_CAT_I_RLA_I (SQL View)	Index Back
Catalog Rel - Interface View Interface view for the Catalog Item Interal Relationships record. This interface is used to expose the Catalog Item Interal Relationships information to other applications outside of JPM. Applications inside the HRMS db can access this view directly, while applications that reside outside the HRMS db must use an EIP built upon this view (or rather a derived record that is basically this view).

JPM_CAT_I_RLA_I

(SQL View)

Catalog Rel - Interface View

Interface view for the Catalog Item Interal Relationships record. This interface is used to expose the Catalog Item Interal Relationships information to other applications outside of JPM. Applications inside the HRMS db can access this view directly, while applications that reside outside the HRMS db must use an EIP built upon this view (or rather a derived record that is basically this view).

SELECT JPM_CAT_TYPE , JPM_CAT_ITEM_ID , JPM_CAT_TYPE2 , JPM_CAT_ITEM_ID2 , JPM_EFFDT , EFF_STATUS , JPM_CAT_RLAT_CD FROM PS_JPM_CAT_I_RLAT

Parent record: JPM_CAT_ITEMS

# 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_TYPE_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_ITMVW

5 JPM_EFFDT Date(10) DATE JPM effdt
Default Value: %DATE

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

7 JPM_CAT_RLAT_CD Character(1) VARCHAR2(1) NOT NULL Talent Mgmt - Describes the relationship of one Catalog Item to another Catalog Item.
C=Is a child of
I=Supports
P=Is a parent of
R=Is Supported By

#	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_TYPE_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_ITMVW
5	JPM_EFFDT	Date(10)	DATE	JPM effdt Default Value: %DATE
6	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
7	JPM_CAT_RLAT_CD	Character(1)	VARCHAR2(1) NOT NULL	Talent Mgmt - Describes the relationship of one Catalog Item to another Catalog Item. C=Is a child of I=Supports P=Is a parent of R=Is Supported By