ALEX_USER_GROUP_ACCESS (Staging table)

Column name Data type Required Default updateable Data target Comments
USER_GROUP_EKEY** VARCHAR (255) Yes* No ALCO_USER_GROUP_ACCESS.USER_GROUP_ID External key of group of type User
GROUP_EKEY** VARCHAR (255) Yes* No ALCO_USER_GROUP_ACCESS.GROUP_ID External key of the user’s group assignment
CONTEXT_NAME** VARCHAR (50) Yes* No ALCO_USER_GROUP_ACCESS.ACCESS_CONTEXT_ID The context in which the user-group assignment applies. These are the example values:
  • Roles
  • Client
  • Report
  • Admin
ACTIVE_STATUS SMALLINT Yes* Yes ALCO_USER_GROUP_ACCESS.ACTIVE_STATUS User group access assignment status
  • 1 = Active
  • 0 = Inactive

* System required field

** Combination of (user_group_ekey, group_ekey, context_name) must be unique