DIM_ACCOUNT_PROPERTY
Updated
The Account Property table stores descriptive and operational details related to Accounts created on the Sprinklr Platform (i.e. SMS, Sprinklr Voice, Live Chat, etc.) and their associated assets - including identifiers, status, ownership, channels, system configuration flags, custom fields, etc.
Below are some of the scenarios where this Report is beneficial:
Account and Asset Performance Analysis: Analyze interactions, cases, and messages by account, channel, or asset to understand performance and engagement across SMS, Voice, Live Chat, and other platforms.
Account Segmentation and Operational Reporting: Segment accounts based on status, ownership, channel, or custom attributes to support targeted reporting, monitoring, and business operations.
Customer Journey and Case Tracking: Link conversations, cases, and activities to the correct account or asset, providing a complete view of customer interactions and account history.
Field Mapping/ Glossary
The report will include the following information:
Field Name | Definition | Data Type | Nullable & Default Value | PII Fields | Unique Key |
ACCOUNT_HEALTH_STATUS | Indicates the current health status of the account. | VARCHAR | Yes | null | No | No |
ACCOUNT_ID | Unique identifier of the account within the platform. | VARCHAR | No | No | Yes |
ACCOUNT_TYPE | Type of Account (i.e. SPRINKLR_VOICE, SPRINKLR_LIVE_CHAT, SMS, etc.) | VARCHAR | No | No | No |
BUSINESS_CATEGORY | Business category associated with the account. | VARCHAR | Yes | null | No | No |
CHANNEL_NAME | Channel or social network associated with the account. Sample Values: SPRINKLR_VOICE, WHATSAPP_BUSINESS, INSTAGRAM. |
VARCHAR |
No |
No |
No |
CLIENT_ID | Unique Identifier of the Client (i.e. Workspace) associated to the Account. | VARCHAR | No | No | No |
CREATED_TIMESTAMP | Timestamp when the account was created in the system. | TIMESTAMP_LTZ | No | No | No |
CUSTOM_PROPERTIES | JSON Object that contains all custom properties associated with the account. Custom fields are referenced by ID; field names and values can be mapped using the DIM_CUSTOM_PROPERTY table. Format: "CustomFieldID": ["Field Value"] |
VARIANT |
Yes | null |
No |
No |
DEACTIVATION_REASON | Details of deactivation, if the Account has been deactivated on platform. Sample Values: deactivatedAt, reason, deactivatedBy. |
VARCHAR |
Yes | null |
No |
No |
DISPLAY_NAME | Human-readable display name of the account. i.e. Name of Account on Platform |
VARCHAR |
No |
No |
No |
IS_ACTIVE_FLAG | Indicates whether the account is currently active. Values: TRUE/FALSE |
BOOLEAN |
No |
No |
No |
IS_AUTO_IMPORT_ENABLED_FLAG | Indicates whether automatic data import is enabled for the account. Values: TRUE/FALSE |
BOOLEAN |
No |
No |
No |
IS_DELETED_FLAG | Indicates whether the account is marked as deleted. Values: TRUE/FALSE |
BOOLEAN |
No |
No |
No |
IS_MANUALLY_DEACTIVATED_FLAG | Indicates whether the account was manually deactivated by a user. | BOOLEAN | No | No | No |
MODIFIED_TIMESTAMP | Timestamp indicating when the asset/account record was last updated. | TIMESTAMP_LTZ | No | No | No |
OWNER_AGENT_ID | Agent ID of the user who owns or manages the account. | VARCHAR | No | No | No |
PARTNER_ID | Unique Identifier of the Partner/Environment the Account is associated to. | 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.