The WORKPLACE_ACCESS table lists all the workplaces assigned to a project. This includes information needed to display the root node of a user's workplace tree based upon the user's role.
WORKPLACE_ACCESS TABLE |
|
|
|
|---|---|---|---|
|
COLUMN NAME |
DATA TYPE |
DESCRIPTION |
PK |
C_INDEX |
VARCHAR(255) |
Unique index of workplace item |
|
C_TABLE_CD |
VARCHAR(255) |
Code mapping to the workplace table |
|
C_TABLE_NAME |
VARCHAR(255) |
Name of workplace table |
|
C_PROTECTED_ACCESS |
CHAR(1) |
(null) or "Y" or "N" |
|
C_HLEVEL |
INT |
Number representing a level in the tree (0) |
|
C_NAME |
VARCHAR(255) |
Name of workplace item |
|
C_USER_ID |
VARCHAR(255) |
User id |
|
C_GROUP_ID |
VARCHAR(255) |
Project name |
|
C_SHARE_ID |
VARCHAR(255) |
(null) or "Y" or "N" |
|
C_PARENT_INDEX |
VARCHAR(255) |
(null) |
|
C_VISUALATTRIBUTES |
CHAR(3) |
Code representing which icon to display |
|
C_TOOLTIP |
VARCHAR(255) |
i2b2Type: annotation (or name) |
|
C_ENTRY_DATE |
DATE |
(null) or specified |
|
C_CHANGE_DATE |
DATE |
(null) or specified |
|
C_STATUS_CD |
CHAR(1) |
(null) or "D" (deleted) |
