DIM_ACCOUNT_GROUP
Updated
DIM_ACCOUNT_GROUP is a dimension table that stores metadata and grouping information for accounts, including group identifiers, associated account lists, ownership details, custom properties, and lifecycle timestamps. It supports account segmentation, management, and reporting across clients. Below are some of the scenarios where this Report is beneficial:
Account Segmentation and Organization: Group related accounts into logical business units, regions, or client portfolios for streamlined management and reporting.
Consolidated Performance Reporting: Analyze metrics across multiple accounts within a group to gain a unified view of customer, account, or business performance.
Ownership and Governance Tracking: Monitor account ownership, custom attributes, and lifecycle information to support account management, auditing, and operational oversight.
Field Mapping/ Glossary
The report will include the following information:
Expected Name | Definition | Data Type | Nullable & Default Value | PII Field | Unique Key |
ACCOUNT_GROUP_ID | Unique identifier of the account group | VARCHAR | No | No | Yes |
ACCOUNT_GROUP_NAME | Human-readable name assigned to the account group | VARCHAR | No | No | No |
ASSOCIATED_ACCOUNTS |
Variant object containing the list of account IDs associated with the account group Format: ["Value"] |
VARIANT |
No |
No |
No |
CLIENT_ID | Identifier of the client or tenant to which the account group belongs | VARCHAR | No | No | No |
CREATED_TIMESTAMP | Timestamp indicating when the account group record was created | TIMESTAMP_LTZ | No | No | No |
CUSTOM_PROPERTIES | Variant object storing additional account-group-specific configuration or metadata | VARIANT | Yes | null | No | No |
DESCRIPTION | Free-text description providing additional context or details about the account group | VARCHAR | Yes | null | No | No |
IS_DELETED_FLAG | Flag indicating whether the account group record has been soft-deleted Values: TRUE/FALSE |
BOOLEAN |
No |
No |
No |
MODIFIED_TIMESTAMP | Timestamp indicating when the account group record was last modified | TIMESTAMP_LTZ | No | No | No |
OWNER_AGENT_ID | Identifier of the agent responsible for managing or owning the account group | VARCHAR | No | No | No |
Intended Use and Prohibited Uses
DataStream is intended solely to support operational efficiency, service delivery, business intelligence, and process optimisation. The product is not designed or intended for employee monitoring, workplace surveillance, performance evaluation, profiling of individuals, or making decisions that materially affect an individual's employment, rights, opportunities, or access to services.
DataStream does not process biometric data for the purpose of identifying individuals and does not perform emotion recognition, affect detection, or emotion inference in the workplace.
Customers must not use DataStream in a manner inconsistent with these intended purposes and remain responsible for ensuring compliance with applicable legal and regulatory requirements as well as with Sprinklr's Acceptable Use Policy.