DIM_CUSTOM_PROPERTY
Updated
The DIM_CUSTOM_PROPERTY dimension table defines and manages custom fields used across the platform. It stores metadata such as field identifiers, types, configuration details, default values, and visibility settings. This table also includes sharing rules, option lists, and additional attributes for UI behavior and validation. This table enables flexible customization of data models by allowing users to create and manage custom fields tailored to their business needs. Below are some of the scenarios where this Report is beneficial:
Custom Field Governance and Management: Track and manage custom field definitions, configurations, default values, and visibility settings to ensure consistent data collection across the platform.
Reporting and Data Model Customization: Leverage custom properties to tailor reporting, segmentation, and analytics based on business-specific attributes and requirements.
Configuration Auditing and Compliance: Monitor changes to custom fields, option lists, validation rules, and sharing settings to support governance, auditing, and data quality initiatives.
Field Mapping/ Glossary
The report will include the following information:
Field Name | Description | Data Type | Nullable & Default Value | PII Field | Unique Key |
RECORD_ID | Internal record identifier for this custom field entry. | VARCHAR | No | No | Yes |
CUSTOM_FIELD_ID | Unique identifier of the custom field. | VARCHAR | NO | No | No |
CUSTOM_FIELD_TYPE | Type of the custom field Sample Values: MULTI_PICKLIST, BOOLEAN, NUMBER |
VARCHAR |
NO |
No |
No |
CUSTOM_FIELD_NAME | System or display name of the custom field. | VARCHAR | NO | No | No |
CUSTOM_FIELD_OWNER | Identifier of the user or system that owns the custom field. | VARCHAR | NO | No | No |
OPTION_TYPE | Type of option values supported Sample Values: EXTERNAL, SYSTEM, GENERAL |
VARCHAR |
YES | null |
No |
No |
OPTION_LABEL | Display label for an individual option under the custom field. | VARCHAR | YES | null | No | No |
CREATION_SOURCE | Source from which the custom field was created (UI, API, Migration). | VARCHAR |
| 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.