HCTS_TILE_SEC (SQL Table)	Index Back
HCTS Tile Security Table Employee Snapshot Tile Security Table - This table stores the security roles that are able to access the activity guide tile table.

HCTS_TILE_SEC

(SQL Table)

HCTS Tile Security Table

Employee Snapshot Tile Security Table - This table stores the security roles that are able to access the activity guide tile table.

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 HCTS_ROLENAME Character(30) VARCHAR2(30) NOT NULL Employee Snapshot Role Name
Prompt Table: PSROLEDEFN_SRCH

3 DATA_TYPE_CD Character(1) VARCHAR2(1) NOT NULL Data Type Code
N=Customer Data
S=Sample Data
Y=System Data
Default Value: N

#	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	HCTS_ROLENAME	Character(30)	VARCHAR2(30) NOT NULL	Employee Snapshot Role Name Prompt Table: PSROLEDEFN_SRCH
3	DATA_TYPE_CD	Character(1)	VARCHAR2(1) NOT NULL	Data Type Code N=Customer Data S=Sample Data Y=System Data Default Value: N