JPM_SR_CATRL_LV

(SQL View)
 Index Back

Catalog Relationships

Talent Mgmt - Defines relationship between Catalog Items.

SELECT A.JPM_CAT_TYPE , A.JPM_CAT_ITEM_ID , A.JPM_CAT_TYPE2 , A.JPM_CAT_ITEM_ID2 , B.LANGUAGE_CD , B.JPM_DESCR90 FROM PS_JPM_CAT_I_RLAT A , PS_JPM_CAT_ITM_LNG B WHERE B.JPM_CAT_TYPE = A.JPM_CAT_TYPE AND B.JPM_CAT_ITEM_ID = A.JPM_CAT_ITEM_ID AND %EffdtCheck(JPM_CAT_ITM_LNG B1, B, %CurrentDateIn) AND A.EFF_STATUS='A'

  • Related Language Record for JPM_SR_CATRL_VW

  • Parent record: JPM_CAT_ITEMS

    • # 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_CAT_TYPES

    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_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).

    Prompt Table: JPM_CAT_TYP2_VW

    4 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).

    Prompt Table: JPM_CAT_ITM2_VW

    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 JPM_DESCR90 Character(90) VARCHAR2(90) NOT NULL jpm