Database Properties
Database Type: Microsoft SQL Server - 16.00.1000
Schema dbo
**POC Database System**
Proof of Concept database containing analytical views for data analysis and reporting. This database provides
access to core business data through specialized views that exclude deleted records and support comprehensive
reporting across key business entities.
**Available Data Sources:**
- **Authorization Data**: AIAuthorizeSource_vw - Auth data where status is not in Deleted
- **Case and Patient Data**: AICaseAndPatientSource_vw - Case and Patients where status is not Deleted
- **Claims Data**: AIClaimSource_vw - Claim data except the deleted claims
- **Staff Data**: AIPeopleSource_vw - Staff member information and performance metrics
- **Support Ticket Data**: AITicketSource_vw - Ticket data where status is not in Deleted
- **Ticket Comments**: AITicketCommentSource_vw - Ticket comment data where status is not in Deleted
Tables
| Table / View | Children | Parents | Columns | Type | Comments |
|---|---|---|---|---|---|
| AIClaimSource_vw | 0 | 0 | 51 | View | Claims analytics view - Returns claim data excluding deleted claims, providing comprehensive analytical view combining claims data with patient information, provider details, financial metrics, and processing status. Designed to support AI-powered analytics for claims processing, provider performance analysis, financial reporting, and billing optimization across the healthcare service delivery system. |
| AIAuthorizeSource_vw | 0 | 0 | 37 | View | Authorization analytics view - Show the auth data where status is not in Deleted. Comprehensive analytical view combining authorization data with patient demographics, service details, provider assignments, and utilization metrics. Designed to support AI-powered analytics for service authorization management, utilization tracking, and provider performance analysis across the early intervention and healthcare service delivery system. |
| AITicketSource_vw | 0 | 0 | 63 | View | Support ticket analytics view - Show the ticket data where status is not in Deleted. Comprehensive analytical view combining support ticket data with customer information, resolution details, development metrics, and performance tracking. Designed to support AI-powered analytics for customer support optimization, development workflow analysis, and service improvement across the iCentral platform and marketplace ecosystem. |
| AICaseAndPatientSource_vw | 0 | 0 | 30 | View | Case and patient analytics view - Showing Case and Patients where status is not Deleted. Comprehensive analytical view integrating patient demographics with case management data, payment sources, and administrative details. Designed to support AI-powered analytics for case coordination, patient tracking, and care management across the early intervention system with complete patient and case lifecycle information. |
| AIPeopleSource_vw | 0 | 0 | 43 | View | Staff analytics view - Comprehensive analytical view combining staff member information with performance metrics, role assignments, productivity data, and financial performance. Designed to support AI-powered analytics for human resources management, provider performance analysis, and workforce optimization across the healthcare service delivery organization. |
| AITicketCommentSource_vw | 0 | 0 | 9 | View | Support ticket comments analytics view - Comprehensive analytical view of ticket comment data excluding deleted comments. Designed to support AI-powered analytics for customer communication analysis, support interaction tracking, and service quality assessment across the iCentral platform and marketplace ecosystem. |