ALEX_USER_ACCESS (Staging table)
| Column name | Data type | Required | Default updateable | Data target | Comments |
|---|---|---|---|---|---|
| USER_EKEY** | VARCHAR (255) | Yes* | No | ALCO_USER_ACCESS.USER_ID | User external key |
| GROUP_EKEY** | VARCHAR (255) | Yes* | No | ALCO_USER_ACCESS.GROUP_ID | External key of group to assign user to |
| CONTEXT_NAME** | VARCHAR (50) | Yes* | No | ALCO_USER_ACCESS.ACCESS_CONTEXT_ID | The context in which this user-group assignment applies.
These are the example values:
|
| ACTIVE_STATUS | SMALLINT | Yes* | Yes | ALCO_USER_ACCESS.ACTIVE_STATUS | User access assignment status.
|
*System required field
** Combination (user_ekey, group_ekey, context_name) must be unique