AGC_TILE_SEC

(SQL Table)
Index Back

AGC Tile Security Table

Activity Guide Composer Tile Security Table - This table stores the security roles that are able to access the activity guide tile table.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 AGC_TILE_ID Character(15) VARCHAR2(15) NOT NULL Activity Guide Composer Tile Id
2 AGC_ROLENAME Character(30) VARCHAR2(30) NOT NULL Activity Guide Composer 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