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
|
*System required field
** Combination of (data_type, data_key, group_ekey) must be unique