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) |
|