HCTS_CFG_CAT_VW

(SQL View)
 Index Back

Configure JPM Content Types

Configuration for JPM Content Types used by Employee Snapshot

SELECT JPM_CAT_TYPE , HCTS_TILE_TITLE , HCTS_TILE_PUBLISH , DATA_TYPE_CD FROM PS_HCTS_CFG_CAT_FL WHERE DATA_TYPE_CD = 'N'

  • Related Language Record: HCTS_CFG_CATLVW

    • # 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: HCTS_CAT_TYP_VW

    2 HCTS_TILE_TITLE Character(30) VARCHAR2(30) NOT NULL Employee Snapshot Tile Title
    3 HCTS_TILE_PUBLISH Character(1) VARCHAR2(1) NOT NULL Employee Snapshot Published
    N=No
    Y=Yes

    Default Value: N

    4 DATA_TYPE_CD Character(1) VARCHAR2(1) NOT NULL Data Type Code
    N=Customer Data
    S=Sample Data
    Y=System Data

    Default Value: N