Tables

Marketplace item catalog storing items, applications, and services available in the marketplace for distribution and assignment.

Primary support and service request tracking system for all customer interactions across the platform. This is a SHARED RESOURCE table accessible across all client databases for unified support ticket management. The table is referenced by client databases through views and reports to provide centralized customer support while maintaining agency-specific data segregation through CreatedByCompany relationships. Each ticket represents a customer issue, feature request, bug report, or service inquiry that requires resolution. Tickets flow through various states from creation through resolution and include comprehensive tracking of assignments, communications, outcomes, and business impact. The system supports both public customer-facing tickets and internal development tickets with rich metadata for project management, SLA tracking, and business analytics.

Extended prescription data storage providing additional custom fields and extended information for prescriptions beyond the standard prescription data model. This extension table supports flexible prescription data management and custom field requirements.

Alert system refresh tracking recording when the alert monitoring system was refreshed or updated. This operational log helps track system maintenance, performance monitoring, and ensures alert data freshness for reliable business monitoring.

Deleted package assignment audit maintaining audit trail of deleted package assignments for tracking and compliance purposes. This system preserves package assignment history for audit trails and administrative oversight.

Marketplace item type definitions categorizing different types of items available in the marketplace.

Universal tag assignment system providing flexible tag associations for any system entity including tickets, applications, users, and content. This generic tagging mechanism supports dynamic categorization across the entire platform, enabling consistent labeling strategies and cross-entity business intelligence reporting.

User interface visibility configuration managing show/hide settings for various user interface elements and fields. This system provides granular control over interface element visibility based on custom settings and user preferences.

Individual checklist task definitions storing specific tasks, questions, and validation items that comprise complete checklists. Each item represents a discrete task or validation step with configuration for data types, requirements, due dates, and assignment rules for comprehensive workflow management.

Comprehensive user activity tracking and analytics recording detailed user interactions, feature usage, and system engagement across the platform. This system provides insights into user behavior, feature adoption, and system usage patterns for analytics and optimization.

Application packaging and bundling system defining how applications are grouped into packages for licensing, deployment, and marketplace presentation. Packages enable bulk application management, tiered pricing strategies, and simplified user access control across related application suites.

Formatted report layout and design management storing formatted report templates, layouts, and design configurations for professional report generation. This system manages report formatting, styling, and presentation for business intelligence and operational reporting.

Healthcare provider digital signature management storing digital signatures, authentication data, and location information for healthcare providers. This system supports electronic signature compliance, audit trails, and provider authentication for healthcare documentation and legal requirements.

Extended control template properties storing additional configuration properties for control templates that extend beyond base template definitions. This system enables complex template configurations and custom control behaviors.

Program-specific configuration management storing custom settings and preferences for different program types. This system enables program-specific customization and configuration management for flexible system behavior across different operational contexts.

Digital signature management for forms storing digital signatures, authentication data, and signature verification information for form submissions. This system ensures legal compliance, authentication, and non-repudiation for digitally signed forms.

Checklist document attachment system managing file attachments and documentation associated with checklist items. This system supports evidence collection, compliance documentation, and file management for checklist completion and audit trails.

Dashboard widget and component management storing configurable dashboard widgets, reports, and interactive components for personalized user interfaces. This system enables dynamic dashboard creation, widget configuration, and personalized user experience across the platform.

Form submission history and version control maintaining historical records of form submissions, changes, and processing status. This audit system supports form data tracking, version control, and compliance requirements for data collection processes.

Checklist completion status tracking maintaining the overall completion status and progress of checklists for specific entities or cases. This system tracks checklist lifecycle, completion dates, and associated entities for comprehensive workflow status management.

Calculation and aggregation configuration defining mathematical operations, summary calculations, and data aggregations used throughout the platform for reporting, alerts, and business intelligence. Each configuration specifies how data should be calculated, grouped, and presented for consistent metrics across the system.

Extended ticket metadata and workflow management containing additional business-specific fields that support detailed project management, technical solution tracking, and business process automation. This table provides a one-to-one relationship with CentralizedTicket to store specialized fields for development workflows, solution documentation, resource planning, and business analytics without cluttering the core ticket structure.

Educational facility and classroom management storing information about physical classrooms, learning spaces, and educational facilities. This system manages classroom capacity, status, ratios, and site assignments for educational program administration and scheduling.

Form control template definitions storing reusable control templates that define standard control configurations for consistent form design. These templates provide blueprints for creating controls with predefined properties and behaviors.

Checklist choice option definitions storing predefined choice values and options available for checklist items that require selection from specific options. This system ensures consistent data entry and standardized responses across checklist implementations.

User interface layer and navigation management defining interface layers, navigation structures, and user experience organization. This system manages how content and functionality are organized and presented to users across different interface layers and contexts.

Billing rule validation errors storing errors and exceptions encountered during billing rule processing and validation.

Dynamic form instance management storing individual form instances created from templates for data collection, user interaction, and business process automation. Each form represents a specific instance of a template with user data, workflow context, and processing state for flexible content management.

Business process automation and workflow engine defining automated actions, triggers, and business logic that execute based on system events and conditions. Rules enable sophisticated workflow automation, data processing, and business process optimization across the platform without manual intervention.

Daycare billing and invoice management storing invoice information for daycare services including billing dates, payment status, and financial tracking. This system manages the complete invoice lifecycle for daycare operations including payment processing and financial reporting.

Automated job execution history tracking the execution history and status of scheduled background jobs and maintenance tasks.

Program attendance code associations linking educational programs to specific attendance codes for tracking and billing purposes. This junction table enables flexible attendance tracking configurations for different program types and requirements.

System calendar and date reference providing calendar dates for scheduling, reporting, and date-based business logic. This utility table supports date calculations, business day determination, and calendar-based features across the platform.

Ticket categorization and organization defining sections or categories for organizing tickets within the user interface. This system provides structured organization of tickets for improved navigation and management efficiency.

Generic tagging system for entity relationships providing flexible tag associations for any system entity through a polymorphic relationship structure. This system enables dynamic categorization and labeling across different entity types with comment support and audit tracking.

Ticket voting and priority feedback system allowing users to vote on tickets to indicate priority, importance, or support for specific requests. This democratic feedback system helps prioritize development and support efforts based on user community input.

URL reference and link management storing URL references and links associated with various system entities. This system manages external links, reference URLs, and web resource associations for comprehensive link tracking and management.

Dynamic filter and query builder data source management storing data source definitions and configurations for building dynamic filters and queries. This system supports flexible data filtering and report generation across various data sources.

Package assignment management tracking which software packages or service packages are assigned to specific agencies or users.

Marketplace item version control managing different versions of marketplace items including version history, compatibility, and deployment tracking. This system supports item lifecycle management and version-specific deployments.

Form template definition system storing reusable form templates that define structure, layout, and behavior for dynamic form generation. Templates provide the blueprint for creating form instances with consistent design and functionality across the platform.

Ticket subscription and notification management tracking which users are following specific tickets for notification purposes. This system manages user subscriptions to ticket updates, enabling personalized notification delivery and stakeholder engagement tracking.

Form data source configuration managing data sources and database connections for dynamic forms and data collection. This system enables forms to connect to various data sources for population, validation, and submission.

User favorite feature tracking storing user preferences for frequently accessed features and functionality. This system enables personalized user experiences and quick access to commonly used features.

Classroom teacher assignment management tracking which teachers are assigned to specific classrooms with active periods and status information. This system manages teacher-classroom relationships for scheduling, capacity planning, and educational administration.

Daycare financial transaction management storing all financial transactions related to daycare services including charges, payments, adjustments, and refunds. This comprehensive system manages the complete financial transaction lifecycle for daycare billing and accounting.

Patient diagnosis and service type associations linking patient diagnoses to specific service types for treatment planning and billing.

General deletion audit trail maintaining comprehensive audit trail of deleted records across various system entities. This centralized deletion tracking system supports compliance, audit requirements, and data recovery operations.

Article categorization system linking articles to tags for content organization, discovery, and filtering. This many-to-many relationship enables flexible article categorization, topic-based navigation, and content recommendation systems within the knowledge base.

Dynamic form control management storing individual form controls (fields, buttons, inputs) within form instances. Each control represents a specific user interface element with its configuration, validation rules, and data binding for flexible form construction and user interaction.

Checklist item data and completion tracking storing actual values, responses, and completion status for individual checklist items. This comprehensive system tracks user inputs, completion dates, assignments, and all data associated with checklist execution and compliance.

Comprehensive checklist and workflow management system defining structured task lists, process workflows, and quality assurance procedures. Each checklist represents a series of tasks or validation steps that must be completed for specific business processes, ensuring consistency, compliance, and quality control across operations.

Form design and layout management storing visual designs, layouts, and styling configurations for custom forms. This comprehensive system manages form appearance, user interface design, and user experience optimization for data collection forms.

IP security group management organizing IP security rules into logical groups for easier management and policy application. This system enables grouped security policy management and simplified IP access control administration.

Comprehensive visit entry configuration system storing detailed settings and preferences for scheduled visit data entry interfaces. This extensive configuration system manages field visibility, default values, validation rules, and user interface behavior for visit entry forms across different program types and user roles.

Application marketplace and software catalog managing all software applications, tools, and services available within the iCentral platform. This is the CENTRAL AUTHORITY table for application definitions referenced across all client databases. Client databases like Sandbox reference this table through views such as CaseListing_VW via CategoryApp relationships to link cases with their associated billing applications for cross-system integration. Each app represents a distinct software module, third-party integration, or custom tool that can be deployed, licensed, and managed for agencies and users. The system supports comprehensive app lifecycle management including versioning, pricing, deployment, user access control, and marketplace presentation with rich metadata for discovery and management.

Deleted invoice audit trail preserving deleted invoice records for financial audit trails, compliance, and potential recovery. This system maintains comprehensive invoice history for financial reporting and regulatory compliance.

Deleted application assignment audit maintaining audit trail of deleted application assignments for compliance and recovery purposes. This system preserves historical assignment data for audit trails and potential data recovery operations.

Deleted billing record audit preserving deleted billing records for audit trails, compliance, and potential recovery. This system maintains historical billing data for financial auditing and regulatory compliance requirements.

HTML form content and template management storing HTML content, templates, and rich text content for forms and user interfaces. This system manages dynamic HTML content generation and template-based form rendering.

Flexible labeling and categorization system providing a centralized taxonomy for organizing and classifying tickets, applications, content, and other system entities. Tags enable dynamic categorization, filtering, search enhancement, and business intelligence across the platform. The system supports hierarchical tagging, tag relationships, and automated tag assignment for comprehensive content organization and discovery.

Visit waiver and makeup code management storing codes and classifications for waived co-visits and makeup visit arrangements. This system manages special visit circumstances, scheduling exceptions, and visit credit management for educational or healthcare programs.

Real-time user session and activity tracking maintaining current user login status, permissions, and session information across the platform. This table provides a snapshot of active users with their current roles, team assignments, and application access for security monitoring, license management, and user experience optimization.

Ticket file attachment management storing files, documents, and media attachments associated with support tickets. This comprehensive system manages file uploads, metadata, organization, and access control for ticket-related documentation and evidence.

Alert notification delivery tracking maintaining a historical record of alert notifications sent to users, including delivery timestamps and notification counts. This audit trail supports notification management, delivery verification, and user communication analytics for the automated alert system.

Program pricing and rate management storing detailed pricing information, billing rates, and financial parameters for educational programs and service plans. This system manages complex rate structures, billing intervals, and effective date ranges for comprehensive program financial management.

Dynamic column naming system allowing agencies to customize display names for database columns and fields throughout the system. This white-label feature enables client-specific terminology and branding for improved user experience and system adoption.

Software and service package definitions storing package information, features, and configurations for distribution and assignment.

Automated monitoring and notification system managing business rule-based alerts, thresholds, and automated notifications across the platform. Alerts monitor key performance indicators, system metrics, and business conditions to trigger notifications, actions, and workflow automation when specified criteria are met. Essential for proactive system management and business process automation.

Article reading tracking recording which users have read specific articles for completion tracking and analytics. This system supports mandatory reading requirements, knowledge base analytics, and user engagement measurement.

Claim modification audit trail maintaining detailed history of all changes made to healthcare claims for compliance, audit, and tracking purposes. Each record captures field-level changes with before/after values and transaction context.

Healthcare prescription and treatment order management storing detailed prescription information including medications, treatments, provider assignments, and authorization details. This comprehensive system manages the complete prescription lifecycle from ordering through delivery for healthcare compliance and patient care coordination.

Client interface layer configuration managing how client-specific items and content are organized and displayed within different interface layers. This system supports multi-tenant customization and client-specific interface arrangements.

Program-specific form associations linking educational programs to custom forms for data collection, assessment, and program-specific documentation. This system enables flexible form assignment and program-specific data collection requirements.

Comprehensive reporting system and business intelligence storing report definitions, configurations, and metadata for dynamic report generation and business analytics. This extensive system manages report creation, data sources, formatting, and distribution for comprehensive business intelligence and operational reporting.

Email template management system storing reusable email templates for automated communications, notifications, and user correspondence. This system supports dynamic content, personalization, and consistent messaging across the platform.

Claim ICD code aggregation storing concatenated International Classification of Diseases (ICD) codes and names associated with healthcare claims. This denormalized view supports efficient reporting and billing operations by providing pre-aggregated diagnosis information for claims processing.

Digital signature classification system defining types of digital signatures used throughout the platform for authentication, approval, and legal compliance. This system supports various signature methods and ensures proper categorization for audit trails and regulatory compliance.

Application layer configuration and presentation management defining how applications are organized, displayed, and accessed within the platform interface. Each record represents a specific layer or section where an application appears, controlling user experience, navigation flow, and application discoverability across different user contexts and interface areas.

Application update and version management tracking content updates, feature releases, and version history for applications in the marketplace. This system maintains detailed records of what changed, when, and who made updates for user communication and rollback capabilities.

Ticket communication and discussion thread storing all comments, discussions, and communication history for support tickets. This system maintains complete conversation threads with rich content support, user attribution, and visibility controls for comprehensive ticket communication management.

Standardized attendance classification system defining attendance codes used for educational sessions and tutoring activities. These codes provide consistent categorization of attendance types, reasons for absence, and participation levels for educational compliance and reporting.

Financial transaction processing managing payment and charge transactions for billing and accounting operations.

Extended form control properties storing additional configuration properties for form controls that extend beyond the base control definition. This system provides flexible property extension for complex control behaviors and custom configurations.

Multi-tenant company configuration storing company-specific settings, preferences, and customizations that control system behavior and appearance for each organization. These settings enable white-label customization, business rule configuration, and tenant-specific feature control.

Student attendance tracking and educational session management recording attendance for educational programs, training sessions, and tutoring activities. This comprehensive system tracks student participation, session details, and attendance patterns for educational compliance, billing, and performance analytics.

Ticket interface customization storing user interface layout preferences and customization settings for ticket displays. This system enables personalized ticket views and interface configurations for improved user experience and productivity.

Visit cancellation classification defining standardized codes for cancelled visits or appointments. These codes provide consistent categorization of cancellation reasons for reporting, analytics, and operational management.

Marketplace item assignment management tracking which marketplace items are assigned to specific markets, agencies, or user groups. This system manages item availability, distribution, and access control within the marketplace ecosystem.

Data import operation tracking storing details and status information for data import operations and batch processing. This system manages import job tracking, error handling, and processing status for bulk data operations.

Application categorization system linking applications to payment sources or billing categories for financial management and application organization. This system supports billing categorization, cost allocation, and financial reporting for application usage.

Claim CPT code aggregation storing concatenated Current Procedural Terminology (CPT) codes and names associated with healthcare claims. This denormalized view supports efficient reporting and billing operations by providing pre-aggregated CPT information for claims processing.

Educational program and service plan management defining structured programs, classes, and service plans with age requirements, capacity limits, and operational parameters. This system manages the complete lifecycle of educational and service programs including enrollment criteria and program administration.

Program type assignment and deployment tracking managing which program types are assigned to specific agencies with assignment dates and administrative details. This system supports multi-tenant program deployment and agency-specific program availability management.

Application assignment and licensing management tracking which applications are assigned to specific agencies, including assignment dates, costs, and administrative details. This system manages application licensing, deployment tracking, and billing for multi-tenant application access control.

Application messaging and notification content storing system messages, notifications, and communication templates used throughout the platform. These messages support multi-language content, dynamic personalization, and consistent communication across different application contexts and user interactions.

Make-up session scheduling and management for tracking and scheduling make-up sessions for missed appointments or educational activities.

Article version control and audit trail maintaining historical versions of article content for change tracking, rollback capability, and editorial workflow management. Each record represents a snapshot of article content at a specific point in time with full attribution and timestamp information.

Document form version control maintaining historical versions of Word documents and forms for audit trails, change tracking, and document management. This system supports document versioning, rollback capabilities, and comprehensive document lifecycle management.

Make-up visit code definitions storing codes and classifications for make-up visits and rescheduled appointments.

Deleted claim transaction audit maintaining audit trail of deleted claim transactions for healthcare billing compliance and audit purposes. This system preserves transaction history for regulatory compliance and financial auditing.

Database diagram metadata storing SQL Server database diagram definitions and visual representations of database schema relationships. This system table supports database design documentation and visual schema management tools.

Dashboard configuration and layout management storing dashboard definitions, layouts, and configurations for personalized user interfaces and business intelligence displays. This comprehensive system manages dashboard creation, widget placement, data source integration, and user-specific dashboard customization for enhanced user experience and data visualization.

IP-based security and access control managing IP address restrictions and security policies for system access. This security system controls access based on network location and implements IP-based security policies for enhanced system protection.

Knowledge base and content management system storing articles, documentation, tutorials, and informational content for customer self-service and internal knowledge sharing. Articles support rich content formatting, media attachments, publication workflows, and integration with ticket systems for solution documentation and customer communication.

Tag-to-ticket relationship mapping establishing many-to-many associations between tags and centralized tickets. This junction table enables flexible ticket categorization, advanced filtering, and business intelligence reporting by allowing multiple tags per ticket and multiple tickets per tag. Essential for ticket organization, search functionality, and automated workflow routing based on tag-based business rules.

Case and service coordination management storing coordinator assignments and responsibilities for cases, patients, or service delivery. This system manages the assignment of service coordinators and case coordinators for comprehensive care management.

Form submission management and processing storing submitted form data, processing status, and submission metadata for all custom forms. This comprehensive system manages the complete form submission lifecycle from initial submission through final processing and approval.

Claim processing queue history tracking the historical processing status and workflow of healthcare claims through various processing queues. This audit trail supports claims management, processing analytics, and workflow optimization.

Dynamic form builder and management system storing custom form definitions, layouts, and configurations for flexible data collection and user interaction. This comprehensive system supports form design, field configuration, validation rules, and integration with various data sources for adaptable business processes.

Daycare invoice summary view providing aggregated financial summary information for daycare invoices including totals, payments, adjustments, and outstanding balances. This view supports financial reporting and invoice status tracking for daycare billing operations.