JPM_CAT_TYPE2JPM_CAT_ITEM_ID2JPM_CAT_TYPE3JPM_CAT_ITEM_ID3LANGUAGE_CDJPM_CATI_RL_LV3(SQL View) |
Index Back |
|---|---|
Catalog RelationshipsTalent Mgmt - Defines relationship between Catalog Items. |
| SELECT DISTINCT A.JPM_CAT_TYPE2 , A.JPM_CAT_ITEM_ID2 , A.JPM_CAT_TYPE ,A.JPM_CAT_ITEM_ID ,B.LANGUAGE_CD ,B.JPM_DESCR90 FROM PS_JPM_CAT_I_RLAT A , PS_JPM_CAT_ITM_LNG B , PS_JPM_CAT_ITEMS C WHERE A.JPM_CAT_TYPE=B.JPM_CAT_TYPE AND A.JPM_CAT_ITEM_ID=B.JPM_CAT_ITEM_ID AND A.EFF_STATUS='A' AND C.EFF_STATUS='A' AND %EffdtCheck(JPM_CAT_ITEMS C1, C, %CurrentDateIn) AND B.JPM_CAT_TYPE = C.JPM_CAT_TYPE AND B.JPM_CAT_ITEM_ID = C.JPM_CAT_ITEM_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | JPM_CAT_TYPE2 |
Character(12) | VARCHAR2(12) NOT NULL | Secondary content item type (as in a related item- such as a child or a supporting item of another item). |
| 2 | JPM_CAT_ITEM_ID2 |
Character(12) | VARCHAR2(12) NOT NULL | Secondary content item id (as in a related item- such as a child or a supporting item of another item). |
| 3 | JPM_CAT_TYPE3 |
Character(12) | VARCHAR2(12) NOT NULL | Secondary content item type (as in a related item- such as a child or a supporting item of another item). |
| 4 | JPM_CAT_ITEM_ID3 |
Character(12) | VARCHAR2(12) NOT NULL | Secondary content item id (as in a related item- such as a child or a supporting item of another item). |
| 5 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 6 | JPM_DESCR90 | Character(90) | VARCHAR2(90) NOT NULL | jpm |