JPM_CAT_ITEM_RD (SQL Table)	Index Back
Cat Item Rating Descriptions Catalog Item Rating Descriptions. This table permits alternate rating descriptions for each rating for each catalog item.

JPM_CAT_ITEM_RD

(SQL Table)

Cat Item Rating Descriptions

Catalog Item Rating Descriptions. This table permits alternate rating descriptions for each rating for each catalog item.

Related Language Record: JPM_CAT_IRD_LNG

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 EFFDT Date(10) DATE NOT NULL Effective Date

4 REVIEW_RATING Character(1) VARCHAR2(1) NOT NULL Review Rating
Prompt Table: JPM_RATING_VW

5 DESCRLONG Long Character CLOB Long Description

#	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	EFFDT	Date(10)	DATE NOT NULL	Effective Date
4	REVIEW_RATING	Character(1)	VARCHAR2(1) NOT NULL	Review Rating Prompt Table: JPM_RATING_VW
5	DESCRLONG	Long Character	CLOB	Long Description