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:
  • Roles
  • Client
  • Report
  • Admin
ACTIVE_STATUS SMALLINT Yes* Yes ALCO_USER_ACCESS.ACTIVE_STATUS User access assignment status.
  • 1=Active
  • 0=Inactive

*System required field

** Combination (user_ekey, group_ekey, context_name) must be unique