CCUBS Rows per table11.29.23.xlsx

The file CCUBS Rows per table11.29.23.xlsx is a comprehensive database inventory for the Montana Access to Quality Childcare System (MAQCS), containing 249 distinct data tables with varying row counts across multiple operational domains. The database supports child care licensing, provider management, financial transactions, authorization tracking, and program eligibility, with extensive tables covering areas such as care providers (20,938 records), contracts (23,710 records), authorizations (658,396 records), and invoice details (30,252,664 records). The system appears designed to manage complex interactions between care providers, financial transactions, licensing, and program eligibility with granular data tracking across multiple state-level child care administrative functions.

The database demonstrates significant scale and complexity, with robust tracking mechanisms for financial transactions, notifications, and provider interactions. Key statistical highlights include 994,145 financial transactions, 4,005,983 notifications, 232,767 persons records, and comprehensive subsystems for tracking worker roles, licenses, inspections, and program eligibility. The data infrastructure supports multiple interconnected processes including provider licensing (117,285 license approvals), background investigations (481,305 records), complaint management (35,383 information complaints), and extensive invoice and warrant processing systems. The database appears to be a sophisticated, comprehensive state-level child care management system with extensive data capture and transaction tracking capabilities.