JPM_SYND_EX_VW

(SQL View)

SELECT DISTINCT T.JPM_PROFILE_ID ,T.JPM_CAT_TYPE ,T.JPM_CAT_ITEM_ID ,P.DESCR FROM PS_JPM_JP_SYND_SRC A ,PS_JPM_JP_ITEMS S ,PS_JPM_JP_ITEMS T ,PS_JPM_PROFILE P WHERE A.JPM_PROFILE_ID2=S.JPM_PROFILE_ID AND A.JPM_PROFILE_ID=T.JPM_PROFILE_ID AND A.JPM_PROFILE_ID=P.JPM_PROFILE_ID AND T.JPM_CAT_TYPE = S.JPM_CAT_TYPE AND T.JPM_CAT_ITEM_ID = S.JPM_CAT_ITEM_ID AND T.JPM_CAT_ITEM_QUAL=S.JPM_CAT_ITEM_QUAL AND T.JPM_CAT_ITEM_QUAL2 = S.JPM_CAT_ITEM_QUAL AND (T.JPM_SOURCE_ID2<>S.JPM_PROFILE_ID AND T.JPM_SOURCE_ID2 <> ' ')

Related Language Record: JPM_SYND_EXLVW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 JPM_PROFILE_ID Character(12) VARCHAR2(12) NOT NULL The id, autoassigned or user assigned of the profile. This id is used to group items and other related material together into one coherent profile.

2 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.

3 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_ITMS_VW

4 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	JPM_PROFILE_ID	Character(12)	VARCHAR2(12) NOT NULL	The id, autoassigned or user assigned of the profile. This id is used to group items and other related material together into one coherent profile.
2	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.
3	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_ITMS_VW
4	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description