JPM_PROFILE_IDJPM_CAT_TYPEJPM_CAT_ITEM_IDPrompt Table: JPM_CAT_ITMS_VW
LANGUAGE_CDJPM_SYND_EXLVW(SQL View) |
Index Back |
|---|
| SELECT DISTINCT T.JPM_PROFILE_ID ,T.JPM_CAT_TYPE ,T.JPM_CAT_ITEM_ID ,P.LANGUAGE_CD ,P.DESCR FROM PS_JPM_JP_SYND_SRC A ,PS_JPM_JP_ITEMS S ,PS_JPM_JP_ITEMS T ,PS_JPM_PROFILE_LNG 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 <> ' ') |
| # | 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 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |