JPM_CATITMRD_VW (SQL View)	Index Back
Cat Item Rating Descriptions Catalog Item Rating Descriptions joined to the Catalog Item defintion to see the rating model the description is assigned to.

JPM_CATITMRD_VW

(SQL View)

Cat Item Rating Descriptions

Catalog Item Rating Descriptions joined to the Catalog Item defintion to see the rating model the description is assigned to.

SELECT B.JPM_CAT_TYPE ,B.JPM_CAT_ITEM_ID ,B.EFFDT ,A.RATING_MODEL ,B.REVIEW_RATING ,B.DESCRLONG FROM PS_JPM_CAT_ITEMS A , PS_JPM_CAT_ITEM_RD B WHERE A.JPM_CAT_TYPE = B.JPM_CAT_TYPE AND A.JPM_CAT_ITEM_ID = B.JPM_CAT_ITEM_ID AND A.EFFDT = B.EFFDT AND A.EFF_STATUS = 'A'

Related Language Record: JPM_CATITMRDLVW

# 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 RATING_MODEL Character(4) VARCHAR2(4) NOT NULL Rating Model

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

6 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	RATING_MODEL	Character(4)	VARCHAR2(4) NOT NULL	Rating Model
5	REVIEW_RATING	Character(1)	VARCHAR2(1) NOT NULL	Review Rating Prompt Table: JPM_RATING_VW
6	DESCRLONG	Long Character	CLOB	Long Description