JPM_CAT_I_RL_V3

(SQL View)
 Index Back

Catalog Relationships

Talent 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 ,A.JPM_CAT_RLAT_CD , A.JPM_MANDATORY ,B.JPM_DESCR90 FROM PS_JPM_CAT_I_RLAT A , PS_JPM_CAT_ITEMS B 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 B.EFF_STATUS='A'

  • Related Language Record: JPM_CATI_RL_LV3

  • Parent record: JPM_CAT_ITEMS

    • # 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 JPM_CAT_RLAT_CD Character(1) VARCHAR2(1) NOT NULL Talent Mgmt - Describes the relationship of one Catalog Item to another Catalog Item.
    C=Is a child of
    I=Supports
    P=Is a parent of
    R=Is Supported By
    6 JPM_MANDATORY Character(1) VARCHAR2(1) NOT NULL jpm
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    7 JPM_DESCR90 Character(90) VARCHAR2(90) NOT NULL jpm