JPM_CATITMRDLVW (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_CATITMRDLVW

(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 ,B.LANGUAGE_CD ,B.DESCRLONG FROM PS_JPM_CAT_ITEMS A , PS_JPM_CAT_IRD_LNG 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 for JPM_CATITMRD_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 EFFDT Date(10) DATE NOT NULL Effective Date

4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

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	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
5	DESCRLONG	Long Character	CLOB	Long Description