ALEX_USER_GROUP (Staging table)

Column name Data type Required Default updateable Data target Comments
DATA_TYPE** VARCHAR (40) Yes* No ALCO_MEMBERSHIP.MEMBER_BOB_TYPE Data type of the member to be assigned to the group, for example, CostCenter, Client. Refer to the above table. These names are case-sensitive.
DATA_KEY** VARCHAR (255) Yes* No ALCO_MEMBERSHIP.MEMBER_BOB External key for this data type.
GROUP_EKEY** VARCHAR (255) Yes* No ALCO_MEMBERSHIP.GROUP_ID External key of group assignment.
ACTIVE_STATUS SMALLINT Yes* Yes ALCO_MEMBERSHIP.MEMBER_ACTIVE_STATUS Membership status
  • 1=active
  • 0=Inactive

*System required field

** Combination of (data_type, data_key, group_ekey) must be unique