DIM_DISPOSITION_PLAN
Updated
The DIM_DISPOSITION_PLAN dimension table stores configuration details for disposition plans used in case handling workflows. It includes identifiers, labels, and system values for dispositions and sub-dispositions, along with metadata such as plan name, owner, and last modified timestamps. This table is designed to manage and organize disposition hierarchies, enabling accurate categorization of cases, streamlined reporting, and improved workflow automation through structured disposition mapping. Below are some of the scenarios where this Report is beneficial:
Case Classification and Trend Analysis: Analyze disposition and sub-disposition data to identify the most common case outcomes, customer issues, and resolution trends across teams and channels.
Workflow Automation and Routing Optimization: Use structured disposition mappings to automate downstream actions, improve case categorization accuracy, and streamline service workflows.
Disposition Plan Governance and Reporting: Monitor disposition plan configurations, ownership, and updates to ensure consistent case classification, support audits, and enable standardized reporting across the organization.
Field Mapping/ Glossary
The report will include the following information:
Field Name | Description | Data Type | Nullable & Default Value | PII Field | Unique Key |
DISPOSITION_ID | Unique identifier for a disposition option under the plan. | VARCHAR | NO | No | Yes |
CLIENT_ID | Client identifier linked to the disposition plan. | VARCHAR | YES | NULL | No | No |
DISPOSITION_LABEL | Label of the disposition (display name shown to agents). | VARCHAR | NO | No | No |
DISPOSITION_NAME | Display name of the disposition option. | VARCHAR | NO | No | No |
DISPOSITION_PLAN_ID | Unique identifier for the disposition plan. | VARCHAR | NO | No | No |
DISPOSITION_PLAN_NAME | Name of the disposition plan (case-insensitive stored version in | VARCHAR | NO | No | No |
DISPOSITION_PLAN_OWNER_ID | User ID of the owner/creator of the disposition plan. | VARCHAR | NO | No | No |
DISPOSITION_VALUE | System value mapped for a disposition (may differ from display label). | VARCHAR | YES | null | No | No |
SUB_DISPOSITION_LABEL | Label assigned to a sub-disposition (nested under a disposition). | VARCHAR | NO | No | No |
SUB_DISPOSITION_VALUE | System value mapped for a sub-disposition. | VARCHAR | YES | null | 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.