JPM_CAT_ITMS_VW (SQL View)	Index Back
Catalog Items - Talent Mgmt Dynamic View of the Catalog Items for a particular Catalog Type. This is used as a Prompt table for the Profile Items record Item ID field. The dynamic SQL is extended to exclude all Items that already exist in the Profile from the prompt list.

JPM_CAT_ITMS_VW

(SQL View)

Catalog Items - Talent Mgmt

Dynamic View of the Catalog Items for a particular Catalog Type. This is used as a Prompt table for the Profile Items record Item ID field. The dynamic SQL is extended to exclude all Items that already exist in the Profile from the prompt list.

SELECT I.JPM_CAT_TYPE , I.JPM_CAT_ITEM_ID , I.JPM_DESCR90 FROM PS_JPM_CAT_ITEMS I WHERE %EffdtCheck(JPM_CAT_ITEMS I1, I, %CurrentDateIn) AND I.EFF_STATUS = 'A'

Related Language Record: JPM_CATITM_LNVW

Parent record: JPM_CAT_TYPES

# 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 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	JPM_DESCR90	Character(90)	VARCHAR2(90) NOT NULL	jpm