Description:
Tracks user group membership requests within the platform, including both approval and rejection workflows. Captures the request details, reasons, and state transitions, providing visibility into the user-group enrollment process.
🔑 Primary Key
id
| Field Name | Data Type | Description |
|---|---|---|
id |
NUMBER | Unique identifier for the group request. |
created_at |
TIMESTAMP_TZ | Timestamp when the request was created. |
updated_at |
TIMESTAMP_TZ | Timestamp when the request was last updated. |
created_by |
NUMBER | Identifier of the user who created the request. |
updated_by |
NUMBER | Identifier of the user who last updated the request. |
group_id |
NUMBER | Identifier of the group the request relates to. |
guser_id |
NUMBER | Identifier of the user who submitted the request. |
state |
NUMBER | Current state of the request (enum): 0 => REQUESTED, 1 => APPROVED, 2 => REJECTED, 3 => RETRACTED. |
state_name |
TEXT | String label for state. |
direction |
NUMBER | Direction of the request (enum): 0 => GROUP_TO_USER, 1 => USER_TO_GROUP. |
direction_name |
TEXT | String label for direction. |
supplied_information |
NUMBER | Information supplied with the request (enum): 0 => UNKNOWN, 1 => EMAIL, 2 => PHONE, 3 => CODE, 4 => ALL. |
supplied_information_name |
TEXT | String label for supplied_information. |
request_reason |
TEXT | Reason the request was made. |
reject_reason |
TEXT | Reason provided for rejecting the request, if applicable. |
_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. |