Dental Claims Data

Database Overview

Data Owner: Data Products
Storage Format: delta
Total Tables: 4
Total Columns: 165
Total Storage Size: ~75 GB

This data warehouse contains healthcare data with semantic tables.

Table Summary

Semantic Tables (4 tables)

Semantic tables containing measurable business events and metrics.

Note: Please click on the table link and select the preview tab to see the column level information such as column name, data type and column description.

Table Name	Primary Key	Columns	Row Count	Size (GB)	Description
sem_dental_capitation_payment	sem_dental_capitation_payment_key	38	14339202	0.6084	The table contains data related to dental capitation payments. It includes details such as payment identifiers, amounts paid, member demographics, and service locations. This data can be used for financial analysis of capitation agreements, tracking payment timelines, and assessing member coverage. Additionally, it allows for demographic profiling and geographic analysis, which can help in understanding service delivery and member engagement.
sem_dental_claim	sem_dental_claim_key	66	249079071	46.982	The table contains detailed records of dental claims, including unique identifiers for claims, members, and services. It tracks the status of each claim, payment amounts, and service dates. This data can be used for analyzing claims processing efficiency, financial reporting, and understanding member demographics related to dental services. Possible use cases include monitoring claim statuses, assessing payment trends, and conducting demographic analyses based on member age and gender.
sem_dental_encounter	sem_dental_encounter_key	19	58372138	3.2495	The table contains data related to dental encounters, including details such as encounter dates, claims, procedures, and payments. It can be used for analyzing dental service utilization, tracking claims processing, and understanding member demographics. This data is useful for reporting, operational analysis, and improving service delivery in dental care.
sem_dental_enrollment	sem_dental_enrollment_key	42	285733142	24.4224	The table contains data related to dental enrollment records. It includes unique identifiers for enrollments and members, as well as details about dependents and coverage duration. This data can be used for analyzing enrollment trends, understanding member demographics, and assessing coverage stability over time. Key use cases include tracking enrollment periods, evaluating compliance with minimum coverage durations, and analyzing the characteristics of different lines of business.

Notes

All these semantic tables use delta format for ACID compliance and these tables are created for the AI data explorer and Data Exchange.