FT_CAT_IRD_LNG

(SQL Table)
Index Back

Cat Item Rating Descrip RLang

# 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 REVIEW_RATING Character(1) VARCHAR2(1) NOT NULL Review Rating

Prompt Table: JPM_RATING_VW

4 EFFDT Date(10) DATE Effective Date

Default Value: %date

5 JPM_EFFDT Date(10) DATE JPM effdt

Default Value: FT_CAT_ITEM_RD.EFFDT

6 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
7 FT_DESCRLONG Long Character(1325) VARCHAR2(1325) Long Description