ALEX_REVIEWER_PERMISSION (Staging table)
| Column name | Data type | Required | Default update able | Data target | Comments |
|---|---|---|---|---|---|
| REVIEWER_USER_EKEY** | VARCHAR (255) | No | No | ALWF_REVIEWER_PERMISSION.REVIEWER_USER_ID | The external key of the reviewer user. This column and reviewer_group_ekey are mutually exclusive. Each row must contain either reviewer_user_ekey or reviewer_group_ekey, but not both. |
| REVIEWER_GROUP_EKEY** | VARCHAR (50) | No | No | ALWF_REVIEWER_PERMISSION.REVIEWER_GROUP_ID | The external key of the reviewer user group. This column and reviewer_user_ekey are mutually exclusive. Each row must contain either reviewer_user_ekey or reviewer_group_ekey, but not both. |
| ACTIVITY_INTERNAL_NAME** | VARCHAR (50) | Yes* | No | ALWF_REVIEWER_PERMISSION.ACTIVITY_ID | The internal name of the workflow activity. |
| USER_GROUP_EKEY** | VARCHAR (50) | Yes* | No | ALWF_REVIEWER_PERMISSION.USER_GROUP_ID | The external key of the group of users whose documents the reviewer can access in the activity. |
| ACTIVE_STATUS | SMALLINT | Yes* | Yes | ALWF_REVIEWER_PERMISSION.ACTIVE_STATUS |
|
| ALEX_REVIEWER_PERMISSION_ID | INTEGER | Yes* | No | N/A | Identity PK column. No need to provide a value or a place holder. A value will be automatically generated. |
* System required field
** Combination of (reviewer_user_ekey, reviewer_group_ekey, activity_internal_name, user_group_ekey) must be unique