JPM_CATITM_LNVW (SQL View)	Index Back
Catalog Items RLang Defines all of the Catalog Items for a particular Catalog Type. Important- All fields that are property fields yet not contained in the property subrecords (required properties) must exist before the property subrecords. All fields that are not properties but need to be fields in the record should be after the properties subrecord/s. Any field placed before the properties subrecords will become required properties for catalog types.

JPM_CATITM_LNVW

(SQL View)

Catalog Items RLang

Defines all of the Catalog Items for a particular Catalog Type. Important- All fields that are property fields yet not contained in the property subrecords (required properties) must exist before the property subrecords. All fields that are not properties but need to be fields in the record should be after the properties subrecord/s. Any field placed before the properties subrecords will become required properties for catalog types.

SELECT L.JPM_CAT_TYPE , L.JPM_CAT_ITEM_ID , L.LANGUAGE_CD , L.JPM_DESCR90 FROM PS_JPM_CAT_ITM_LNG L , PS_JPM_CAT_ITEMS B WHERE L.JPM_CAT_ITEM_ID = B.JPM_CAT_ITEM_ID AND L.JPM_CAT_TYPE = B.JPM_CAT_TYPE AND L.EFFDT = B.EFFDT AND %EffdtCheck(JPM_CAT_ITEMS B1, B, %CurrentDateIn) AND B.EFF_STATUS = 'A'

Related Language Record for JPM_CAT_ITMS_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_CT_NOHOC_VW

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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

4 JPM_DESCR90 Character(90) VARCHAR2(90) NOT NULL jpm

#	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_CT_NOHOC_VW
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	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
4	JPM_DESCR90	Character(90)	VARCHAR2(90) NOT NULL	jpm