Description:
Represents organizational cost centers used for tracking financial responsibility and allocations. Each cost center can be linked to a user group and includes metadata such as external references, contact details, and lifecycle status.
🔑 Primary Key
id
| Field Name | Data Type | Description |
|---|---|---|
id |
NUMBER | Unique identifier for the cost center. |
name |
TEXT | Name of the cost center. |
description |
TEXT | Description or purpose of the cost center. |
user_group_id |
NUMBER | Identifier of the user group associated with the cost center. |
external_reference |
TEXT | External system reference or code for the cost center. |
created_at |
TIMESTAMP_TZ | Timestamp when the cost center was created. |
updated_at |
TIMESTAMP_TZ | Timestamp when the cost center was last updated. |
created_by |
NUMBER | Identifier of the user who created the cost center record. |
updated_by |
NUMBER | Identifier of the user who last updated the cost center record. |
contact_email |
TEXT | Contact email associated with the cost center. |
status |
TEXT | Current status of the cost center (ACTIVE or ARCHIVED). |
_snowflake_inserted_at |
TIMESTAMP_NTZ | System timestamp when the record was inserted into Snowflake. |
_snowflake_updated_at |
TIMESTAMP_NTZ | System timestamp when the record was last updated in Snowflake. |
_snowflake_deleted |
BOOLEAN | True if the record was deleted in the source. |