HCTS_TILE_HPG

(SQL Table)
 Index Back

HCTS Tile Homepage Table

Employee Snapshot Homepage Table - This table stores the homepages the tile has been published to.

  • Parent record: HCTS_CFG_CAT_FL

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

    Default Value: HCTS_CFG_CAT_FL.JPM_CAT_TYPE

    2 PORTAL_OBJNAME Character(30) VARCHAR2(30) NOT NULL Homepage

    Prompt Table: HCTS_HPG_VW

    3 HCTS_DASHBOARD_NM Character(1) VARCHAR2(1) NOT NULL Employee Snapshot Dashboards
    1=Summary
    2=Promotion Readiness
    3=Compensation Review
    4=Performance Review
    5=Career Planning
    4 HCTS_TILE_SEQUENCE Number(4,0) SMALLINT NOT NULL Employee Snapshot Tile Sequence
    5 HCTS_TILE_SIZE Character(1) VARCHAR2(1) NOT NULL Employee Snapshot Tile Size
    1=2x1 Tile
    2=2x2 Tile
    3=1x1 Tile
    6 HCTS_TILE_PUBLISH Character(1) VARCHAR2(1) NOT NULL Employee Snapshot Published
    N=No
    Y=Yes

    Default Value: N

    7 PORTAL_FLDR_NAME Character(30) VARCHAR2(30) NOT NULL Folder Name
    8 PORTAL_CREF_NAME Character(30) VARCHAR2(30) NOT NULL Content reference name
    9 DATA_TYPE_CD Character(1) VARCHAR2(1) NOT NULL Data Type Code
    N=Customer Data
    S=Sample Data
    Y=System Data

    Default Value: N