Description:
Manages the relationship between users and groups within the platform. Tracks membership, roles, states, and organizational hierarchy, enabling group-based permissions, reporting, and cost center management.
🔑 Primary Key
Composite of guser_id + group_id
| Field Name | Data Type | Description |
|---|---|---|
guser_id |
NUMBER | Identifier of the user associated with the group. |
group_id |
NUMBER | Identifier of the group to which the user belongs. |
created_at |
TIMESTAMP_TZ | Timestamp when the group membership was created. |
updated_at |
TIMESTAMP_TZ | Timestamp when the group membership was last updated. |
state |
NUMBER | Current state of the group membership (enum): 0 => ACTIVE, 1 => INACTIVE. |
state_name |
TEXT | String label for state. |
default_cost_center_id |
NUMBER | Default cost center associated with the user’s group membership. |
role |
NUMBER | Role of the user within the group (enum): 0 => OWNER, 1 => ADMIN, 2 => MEMBER. |
role_name |
TEXT | String label for role. |
superior_email |
TEXT | Email of the superior or manager for the user in the group. |
_snowflake_inserted_at |
TIMESTAMP_NTZ | Timestamp when the record was inserted into Snowflake. |
_snowflake_updated_at |
TIMESTAMP_NTZ | Timestamp of last record update in Snowflake. |
_snowflake_deleted |
BOOLEAN | True if the record was deleted in the source. |