Server (Cells) Architecture Home
Space shortcuts
Space Tools
Skip to end of metadata
Go to start of metadata

The WORKPLACE_ACCESS schema expands upon the WDO, containing security information for the root level work nodes. It is used to obtain a list of "Workplace" tables within the Persistent Storage Location (PSL). Each workplace table within the PSL is represented by a single row in this table. The primary identifier of each workplace table in the WORKPLACE_ACCESS table is in the _C_TABLE_CD_ column. All messages that need to point to a specific workplace table will use this identifier. For example, in the <key> element of many messages this identifier is represented as
C_TABLE_NAME_ (see messaging specification). Within the _C_TABLE_NAME
column is the actual name in the PSL of the workplace table. The _C_PROTECTED_ACCESS_ column designates whether one must have the protected access role (DATA_PROT) to obtain data from this table. The other columns are defined in a similar manner to the columns of the Metadata table, with the following special notes:
The _C_HLEVEL_ is almost always 0 in this table.

WORKPLACE_ACCESS

 

 

PK

C_INDEX

VARCHAR(255)

 

 

C_TABLE_CD

VARCHAR(255)

 

 

C_TABLE_NAME

VARCHAR(255)

 

 

C_PROTECTED_ACCESS

CHAR(1)

 

 

C_HLEVEL

INT

 

 

C_NAME

VARCHAR(255)

 

 

C_USER_ID

VARCHAR(255)

 

 

C_GROUP_ID

VARCHAR(255)

 

 

C_SHARE_ID

VARCHAR(255)

 

 

C_VISUALATTRIBUTES

CHAR(3)

 

 

C_PARENT_INDEX

VARCHAR(255)

 

 

C_TOOLTIP

VARCHAR(255)

 

 

C_ENTRY_DATE

DATE

 

 

C_CHANGE_DATE

DATE

 

 

C_STATUS_CD

CHAR(1)

 



  • No labels