Tables

Payroll status rule configurations managing status-based rule applications for payroll processing workflows. This table defines which status conditions trigger payroll rule applications including status references and payroll application flags to support status-driven payroll processing, workflow automation, and conditional payroll rule enforcement based on claim or transaction status.

Rule error blocking configurations managing error messages and blocking conditions for business rule violations. This table defines specific error messages and blocking behaviors when business rules are violated, supporting automated error handling, user notifications, and workflow blocking for compliance and data quality enforcement.

User groups and security groups managing user group definitions, permissions, and access control for role-based security. This table defines groups with descriptions, creation tracking, update history, and locking capabilities to support user management, security administration, and access control for healthcare applications and organizational structure management.

Review due date tracking managing scheduled reviews and compliance monitoring for IFSP and other healthcare service reviews. This table tracks review schedules, due dates, actual completion dates, and review types to support regulatory compliance, quality assurance, and timely completion of required reviews for early intervention and healthcare services.

Referral source management storing information about individuals and organizations that refer patients to healthcare services. This table manages referral source contacts including names, agency associations, and notes, supporting referral tracking, source management, and relationship building for patient acquisition and service coordination in healthcare organizations.

Monthly balance tracking maintaining monthly financial balance summaries by site for accounts receivable management. This table captures monthly snapshots of billing amounts, payments, adjustments, and aging balances, supporting financial reporting, cash flow analysis, and accounts receivable management across different service delivery sites.

Claim summary counts providing aggregated patient and financial totals by site, program, and payment source for high-level reporting. This summary table maintains total charged amounts and patient counts to support executive reporting, financial analysis, and operational metrics for healthcare billing and patient volume tracking.

Patient evaluation management table for tracking comprehensive developmental assessments and evaluations in early intervention services. This table manages the complete evaluation lifecycle from initial assignment through completion, including evaluator assignments, scheduling, documentation tracking, outcome determination, and compliance monitoring. Essential for coordinating multidisciplinary evaluations, ensuring timely completion, and supporting eligibility determinations for early intervention services.

Custom program settings managing program-specific custom settings and configuration flags. This table controls whether custom settings are enabled for specific program types and defines the type of customization, supporting program-specific behavior customization and feature enablement for healthcare program management.

Individualized Family Service Plan management for early intervention services providing comprehensive IFSP lifecycle management from creation to closure. This table manages IFSP documents, review schedules, consent tracking, and status management for children receiving early intervention services, supporting regulatory compliance with IDEA Part C requirements, family-centered planning, and coordinated service delivery for developmental support and family empowerment.

Patient discharge reasons defining reasons for patient discharge from healthcare programs or services. This lookup table manages discharge reason codes and descriptions to support discharge planning, outcome tracking, and program completion documentation for healthcare case management and reporting.

Checklist document attachments managing documents and files attached to checklist field values. This table stores document metadata including file names, descriptions, and content types for documents uploaded or attached to checklist items, supporting document management and compliance documentation workflows.

Dashboard widget management storing configuration and content for user interface widgets and dashboard components. This table manages customizable widgets that display data, reports, and interactive elements on user dashboards, supporting personalized user experiences, data visualization, and quick access to key information and functionality.

Enrollment payment source management handling payment source assignments for patient enrollments. This table manages the payment sources associated with patient enrollments, supporting billing workflows and payment processing for enrolled patients across different programs and services.

Form submission history - Audit trail tracking changes and submissions for form data including version history, user tracking, and submission types. This table maintains a complete history of form modifications, data entry activities, and submission workflows to support data integrity, audit compliance, and change tracking for healthcare documentation.

Password policy management defining comprehensive password policies including expiration, length, complexity, and lockout settings for system security. This table manages password policy configurations including expiration periods, minimum lengths, complexity requirements, login attempt limits, and lockout settings, supporting comprehensive security policy enforcement and user account management.

Classroom definitions managing classroom information for educational and therapeutic programs. This table defines classrooms with their names, descriptions, capacity ratios, and site assignments to support classroom-based service delivery, enrollment management, and educational program administration in healthcare settings.

Claim custom fields table for storing extended claim information including session details, participant data, CPSE (Committee on Preschool Special Education) documentation, and specialized assessment information. This table captures detailed session progress notes, objectives addressed, caregiver coaching activities, routine activities, strategies used, and comprehensive documentation required for early intervention services, special education transitions, and regulatory compliance reporting.

System categories and navigation defining the main functional categories and navigation structure for the healthcare system. This table organizes system functionality into logical categories for user interface navigation, security permissions, and system organization.

Discharge reason program assignments linking discharge reasons to specific program types for program-specific discharge management. This junction table manages which discharge reasons are available for specific program types, enabling program-specific discharge reason configuration and tracking for healthcare service management.

Authorization custom information storing additional custom fields and extended information for service authorizations. This table captures authorization-specific details including comments, delay reasons, co-visit configurations, and service delivery specifications that extend beyond the standard authorization data structure.

Checklist field value assignments managing user assignments for specific checklist field values. This table tracks which users are assigned to complete or review specific checklist field values, enabling granular assignment control and responsibility tracking at the field level.

Plan tuition attendance code associations linking educational plans to tuition attendance codes for billing and attendance tracking. This junction table manages the relationship between educational plans and attendance codes used for tuition billing, supporting attendance-based billing, educational program administration, and tuition calculation for healthcare-related educational services.

Email queue management managing queued emails for automated sending with scheduling and status tracking. This table manages email queue operations including recipients, content, status tracking, and scheduled sending to support automated email notifications, communication workflows, and email delivery management.

Authorization room assignments linking service authorizations to specific rooms where services will be delivered. This table manages room reservations and assignments for authorized services, supporting facility management, scheduling coordination, and resource allocation for healthcare service delivery.

Legacy tag associations maintaining tag relationships for specific table fields in the healthcare system. This legacy table provides field-level tagging capabilities for specific database fields, supporting detailed categorization and annotation of data elements for compliance, workflow management, and data organization purposes.

Activity documentation storing notes and documentation related to scheduled activities. This table provides a foundation for clinical documentation, visit notes, and activity-related record keeping for healthcare service delivery.

New York Early Intervention rate schedule - Comprehensive rate table defining standardized payment rates for various early intervention services by county. This table establishes the financial framework for service delivery including evaluation rates, intervention rates, and specialized service rates used for billing, reimbursement calculations, and contract management across different New York counties and service types.

Patient medical conditions tracking managing comprehensive medical condition information for patients including diagnoses, descriptions, and medical history. This table stores detailed medical condition data, diagnostic information, and related medical links, supporting clinical care planning, medical history tracking, and comprehensive patient care management for healthcare services.

Text template management storing reusable text templates for documents, communications, and standardized content throughout the healthcare system. This table manages template content that can be used for generating consistent documentation, correspondence, and standardized text across various business processes and compliance requirements.

System test table for development and testing purposes. This simple table contains a single ID field and is used for system validation, database connectivity testing, and development workflows. Not used in production business processes.

User support level associations linking users to their assigned support levels and subscription tiers. This junction table establishes the relationship between users and their support level subscriptions, enabling support tier management, billing calculations, and feature access control based on subscription levels.

Document status definitions managing document status types for document workflow and approval processes. This table defines document status categories to support document lifecycle management, approval workflows, and status tracking for patient clinical documentation and administrative processes.

Field-level security controls - Security configuration table managing field-level access permissions and visibility controls. This table defines field-specific security rules, group-based access controls, and permission levels to ensure appropriate data access, maintain field-level security, and support role-based access control for sensitive healthcare information.

User pay category classification defining payment categories for staff compensation and payroll processing. This table manages different pay categories that determine compensation rates, benefits, and payroll processing rules for healthcare staff, supporting flexible payroll management and compensation structures across different roles and employment types.

User-patient assignments managing the relationships between healthcare providers and their assigned patients/clients. This table controls which providers have access to specific patients and defines their role in the patient’s care team (therapist, service coordinator, supervisor, etc.).

EI Hub import files managing uploaded files for Early Intervention Hub data import operations. This table tracks import files with metadata, status, and upload information to support file-based data import, file management, and import operation tracking for Early Intervention system integration.

EIHUB submitted data import table storing comprehensive early intervention data submitted from the Early Intervention Hub system for processing and integration. This table contains child demographics, service authorization details, IFSP information, provider data, session tracking, and billing information for early intervention services requiring import validation and system integration.

Internal messaging system - Communication platform for internal messages, notifications, and correspondence between healthcare system users. This table manages message content, delivery status, priority levels, and reply threading to support secure internal communication, task notifications, and collaborative workflows within the healthcare organization.

Stored procedure form associations linking stored procedures to flexible forms for automated form processing and validation. This junction table manages the relationship between stored procedures and flex forms including execution order to support form-driven stored procedure execution, automated data processing, and form validation workflows for healthcare data management.

Authorization waivers managing waiver programs and special authorization conditions for healthcare services. This table tracks waiver status, types, and visit configurations for authorizations that operate under special waiver programs or have modified service delivery requirements.

Patient diagnosis service type associations linking patient diagnoses to specific service types for treatment planning and service coordination. This junction table manages the relationship between patient diagnoses and applicable service types, supporting diagnosis-based service planning, treatment coordination, and appropriate service delivery for patient care management.

Activity category security permissions managing access control and permissions for different activity categories. This table implements role-based and user-based security for activity categories, controlling who can view, create, edit, or delete activities within specific categories.

Template change history tracking modifications and audit trail for template and form changes in the healthcare system. This table stores historical data including field-level changes, before/after values, and user tracking to support audit compliance, change management, and historical data recovery for template and form management workflows.

IFSP objective management storing detailed objectives linked to goals for Individualized Family Service Plans and early intervention services. This table manages objective descriptions, configuration settings, comments, and tracking information, supporting goal-based intervention planning, progress monitoring, and IFSP compliance for early intervention services and family-centered care planning.

Geographic region definitions managing regional classifications and geographic areas for service delivery and administrative organization. This lookup table defines regions with names and import identifiers, supporting geographic organization, regional reporting, service area management, and administrative structure for healthcare service delivery across different geographic areas.

Quality assurance note categories defining categories and classifications for QA notes and quality review documentation. This lookup table manages QA note categories with internal table and field mappings, supporting structured quality assurance documentation, note categorization, and systematic quality review processes for healthcare service delivery and compliance monitoring.

Application default reports defining which reports are available by default for specific applications. This table manages the relationship between applications and their default report sets, enabling application-specific reporting capabilities and streamlined report access for different healthcare modules.

Prescription type definitions managing categories and types of prescriptions for medication management and patient care. This lookup table defines prescription types including names, descriptions, and alert timing to support prescription tracking, medication management, and automated alert systems for healthcare providers and patient safety monitoring.

Service billing rates defining the rates charged for different healthcare services based on payer, procedure, service type, and other billing parameters. This table manages the complex rate structures used for medical billing and ensures accurate pricing for insurance claims and invoices.

IFSP review type definitions providing standardized review categories and descriptions for Individualized Family Service Plan review processes. This lookup table defines the types of reviews required for IFSP compliance including annual reviews, interim reviews, six-month reviews, and transition reviews, supporting systematic review scheduling and regulatory compliance with early intervention requirements.

Data source access restrictions managing data sources that are restricted from access for security or compliance purposes. This security table defines data sources that should not be accessible, supporting data access control, security compliance, and data source management for healthcare information systems.

Checklist field value data storing actual values and responses for checklist items. This table manages the data entered for checklist fields including dates, text, numbers, and boolean values with completion tracking, assignments, and audit information for comprehensive checklist data management and workflow tracking.

Checklist definitions and instances managing workflow checklists and task lists for healthcare processes. This comprehensive table defines checklists with their items, assignments, validation rules, and workflow automation for ensuring compliance, quality assurance, and standardized processes in healthcare service delivery.

Form designs management table for creating and configuring dynamic forms, electronic documents, and data collection instruments. This table supports comprehensive form management including field definitions, signature configurations, security settings, workflow integration, and multi-format publishing. Essential for healthcare documentation, compliance forms, assessment instruments, and custom data collection requirements in early intervention and healthcare services.

IP security group associations linking IP security rules to user groups for group-based network access control. This junction table manages the relationship between IP security rules and user groups, enabling group-based IP restrictions and network access policies to support role-based security and organizational network access management.

Data source report assignments linking data sources to their default reports for automated report generation. This table manages which default reports are associated with specific data sources, supporting automated reporting, report assignment, and data source-specific report configuration for healthcare analytics.

Payroll batch processing managing payroll batch creation, processing, and status tracking for healthcare provider compensation. This table coordinates payroll batch operations including batch dates, total invoice counts, batch amounts, processing status, and check dates, supporting systematic payroll processing, batch management, and financial reconciliation for healthcare staff compensation.

Document name definitions managing document names and types for patient document classification. This table defines document names and types to support document identification, categorization, and management for patient clinical documentation and administrative record keeping.

Patient administration custom backup data storing backup copies of extended patient administration information including referral details, caregiver information, and developmental concerns. This backup table preserves historical custom data for patient cases, supporting data recovery, audit trails, and compliance with data retention requirements for early intervention services.

Deleted invoices audit trail maintaining records of invoices that have been deleted from the system for audit and compliance purposes. This table preserves invoice information for financial reconciliation, audit trails, and regulatory compliance when invoices are removed from active billing.

User site assignments linking users to specific service delivery sites within programs. This junction table establishes which sites users are authorized to work at, supporting site-based access control, scheduling, and service delivery management across multiple locations within healthcare programs.

Clearing house information managing clearing house organizations used for electronic claims submission. This table stores clearing house contact information, communication details, and service parameters to support electronic billing, claims transmission, and clearing house integration for healthcare billing operations.

Report quality assurance note links managing associations between reports and quality assurance note categories. This table creates relationships between reports and QA note categories, supporting quality management workflows, report-based quality tracking, and integrated quality assurance processes for healthcare reporting and compliance monitoring.

Security permission assignments managing access control relationships between securable items and security principals. This table implements the core security model by linking securable items to users, groups, or roles with assignment tracking, criteria display options, and ordering controls to support comprehensive access control and permission management for healthcare system security.

Alert message content storing specific message content for alert configurations. This table manages the actual message text and content associated with alerts, enabling customizable alert messaging and multi-language support for alert notifications and displays.

Service gap analysis and tracking for identifying and managing gaps in healthcare service delivery between scheduled and actual services. This table supports quality assurance by tracking service interruptions, missed sessions, and gaps in care delivery, enabling providers to identify patterns, ensure compliance with service requirements, and maintain continuity of care for early intervention and therapy services through systematic gap analysis and resolution tracking.

Patient alias management storing alternative names and identifiers for patients to support name variations and identity management. This table manages patient aliases including alternative first and last names, alias types, primary alias designation, and comments, supporting patient identification, name variations, cultural naming practices, and identity management for healthcare services.

Alert priority level definitions defining the hierarchy and display order of alert priority levels. This lookup table manages priority classifications (High, Medium, Low, Critical) used for alert categorization, notification routing, and user interface display ordering.

Form security and access control managing user permissions, role-based access, and signature requirements for form access and modification. This table defines granular security settings for forms including view permissions, edit permissions, signature requirements, and role-based access control, supporting secure form workflows, compliance requirements, and audit trails for healthcare documentation and data protection.

Evaluation coordinator assignments linking patient evaluations to their assigned evaluation coordinators for early intervention assessment management. This junction table manages the assignment of evaluation coordinators to specific patient evaluations, supporting evaluation workflow coordination, responsibility tracking, and communication management for developmental assessments and early intervention eligibility determinations.

Aging calculation configuration options defining different methods and parameters for calculating accounts receivable aging. This table manages various aging calculation approaches, SQL join configurations, and hierarchical levels for flexible aging analysis and reporting across different business scenarios.

Patient evaluation ICD-9 diagnosis associations linking evaluations to specific diagnostic codes for clinical documentation and billing. This junction table manages the relationship between patient evaluations and ICD-9 diagnosis codes including ordering information, supporting accurate diagnosis coding, clinical documentation, and evaluation-based diagnosis tracking for healthcare services.

User field level associations linking custom user fields to specific organizational levels or security levels. This junction table determines which custom fields are applicable at different organizational levels, supporting level-based field visibility and data collection requirements based on user roles or organizational hierarchy.

Checklist entity linking defining how checklists are linked to different entities and database tables. This configuration table manages the relationships between checklists and various system entities such as patients, cases, visits, and other records, enabling flexible checklist application across different business objects.

Agency clearing house EDI configuration table for managing Electronic Data Interchange (EDI) parameters and settings for healthcare claims processing. This table stores comprehensive X12 EDI transaction configurations including interchange qualifiers, functional identifiers, entity codes, and segment terminators required for automated claims submission, remittance processing, and electronic communication between healthcare providers and insurance payers through clearing house intermediaries.

Quick note templates and shortcuts providing predefined note templates and quick text options for efficient documentation. This table manages agency-specific quick note templates including note codes and detailed text, supporting rapid documentation, standardized note templates, and efficient clinical documentation workflows for healthcare providers.

Claim flag options managing flag option definitions for claim flagging and review processes with descriptions and status tracking. This table defines available flag options for marking claims that require special attention, review, or processing with option descriptions and status management to support claim quality assurance and workflow management for healthcare billing operations.

Claim concatenated ICD codes storing concatenated ICD diagnosis codes and names for claims with multiple diagnoses. This denormalized table provides quick access to all ICD codes associated with a claim in concatenated format, supporting efficient reporting and display of multiple diagnosis codes per claim.

Password complexity requirements defining password strength rules and complexity criteria for system security. This table manages password complexity settings including character requirements, length specifications, and complexity rules, supporting security policy enforcement, password validation, and user account security for healthcare system access control.

Service coordination claim custom data storing extended custom fields and specialized information for service coordination claims. This table captures additional service coordination details including developmental domains, service types, transition planning, and specialized notes that support comprehensive early intervention service coordination documentation and reporting.

User activity timestamps tracking user login sessions and contract level access for audit and session management. This table records user activity timestamps including login dates, user identifiers, and contract levels to support session tracking, audit compliance, and user activity monitoring for healthcare system security and access control.

Tuition attendance code definitions managing attendance codes used for tuition billing and attendance tracking in daycare and educational programs. This lookup table defines attendance codes including names, descriptions, and archive status to support attendance-based billing, program participation tracking, and tuition calculation for daycare and educational services.

Payroll type classification defining types of payroll compensation and payment categories for healthcare staff. This lookup table manages payroll type definitions including descriptions, default amounts, lock settings, overtime flags, and application scope, supporting flexible payroll processing, compensation categorization, and systematic payroll management for healthcare organizations.

User custom configuration assignments linking users to personalized configuration settings and interface customizations. This junction table enables user-specific configuration of system behavior, interface layouts, and feature settings, supporting personalized user experiences and workflow optimization for healthcare staff.

Documentation templates - Template management system for standardized documentation, notes, and reporting across healthcare services. This table stores reusable templates for clinical notes, assessment forms, progress reports, and other documentation to ensure consistency, efficiency, and compliance in healthcare documentation workflows.

Activity calendar display options defining how activities appear on calendars and scheduling interfaces. This lookup table provides options for displaying activity time blocks (busy, free, tentative, out of office) to support calendar integration and scheduling coordination.

Remittance advice application tracking managing the application and processing of remittance advice data for healthcare claims and payments. This table tracks RA applications including payment source information, claim associations, transaction references, status tracking, and error handling, supporting comprehensive remittance processing, payment reconciliation, and financial management for healthcare billing operations.

Billing invoices grouping multiple claims into consolidated billing documents for submission to payers. This table manages invoice generation, submission tracking, payment processing, and financial reconciliation for batch billing and accounts receivable management.

Custom claim service rate extensions - Extended table storing additional custom fields and configurations for claim service rates and payroll calculations. This table provides flexible storage for custom rate parameters, stipend options, and specialized billing configurations to support complex payroll processing, custom rate structures, and organization-specific billing requirements.

Document digital signatures tracking digital signatures applied to documents for approval and authentication. This table manages document signing with user tracking and date stamps to support document approval workflows, electronic signatures, and audit trails for healthcare document management.

User field value storage storing actual values for custom user fields associated with specific users. This table maintains the data entered for custom fields, supporting personalized user profiles, compliance tracking, and organization-specific data collection requirements for healthcare staff management.

Aging type definitions defining different categories and methods for accounts receivable aging analysis. This lookup table manages various aging approaches and their associated database tables, enabling flexible aging calculations for different business scenarios and reporting requirements.

Student/client attendance tracking managing attendance records for educational programs, daycare services, and group activities. This table tracks daily attendance, sign-in/out times, and attendance status for clients enrolled in educational or group service programs.

Automated workflow actions defining automated actions and business rules that can be triggered by system events or scheduled processes. This table enables process automation, notification systems, and automated business rule enforcement for operational efficiency and compliance management.

Claim CPT procedure codes linking claims to specific CPT procedure codes for billing and documentation. This junction table manages the many-to-many relationship between claims and CPT codes, including unit quantities for each procedure performed during the healthcare service delivery.

Checklist item assignments managing assignments of checklist items to users, teams, and roles. This table tracks who is responsible for completing specific checklist items with support for individual, team, and role-based assignments for flexible workflow management and responsibility distribution.

Cancelled visit attendance codes defining which attendance codes represent cancelled or missed visits for reporting and billing purposes. This lookup table identifies attendance codes that indicate visit cancellations, enabling proper categorization of cancelled visits for attendance tracking, billing adjustments, and service delivery reporting.

Grid view filter management - User-defined filter storage system for customizing data grid displays and search criteria. This table manages saved filters, search parameters, and view configurations to support personalized data views, advanced filtering capabilities, and user-specific data presentation preferences across healthcare data management interfaces.

Specialty discipline associations linking provider specialties to specific disciplines for organizational and credentialing management. This junction table manages the relationship between specialties and disciplines to support multi-disciplinary care teams, provider organization, and discipline-specific specialty tracking for healthcare service delivery and provider management.

Quick filters and saved searches managing user-defined filter criteria and search parameters for data views and reports. This table stores filter definitions including names, descriptions, criteria, parent relationships, and marketplace flags to support customizable data filtering, saved searches, and user productivity features for healthcare data management and reporting.

Procedure code CPT associations linking internal procedure codes to standard CPT codes for billing and service documentation. This junction table manages the relationship between internal procedure codes and CPT codes including service type associations, supporting accurate billing, procedure coding, and service documentation for healthcare reimbursement and compliance.

Provider payment rates defining the rates paid to healthcare providers for delivering services. This table manages payroll rates, provider compensation, and payment calculations for staff based on service type, patient, and other factors affecting provider payment.

Insurance company directory - Master directory of insurance companies and payers providing coverage for healthcare services. This table stores insurance company contact information, addresses, and communication details to support billing operations, claims processing, prior authorization requests, and insurance verification workflows for healthcare service delivery.

Invoice grouping and organization managing invoice sets and collections for batch processing and reporting. This table groups invoices by patient and time period for organized invoice management, batch processing, and reporting workflows, supporting efficient invoice handling, monthly billing cycles, and administrative organization of healthcare billing operations.

Action market associations linking workflow actions to specific markets or business segments. This table enables market-specific action configurations and business rule processing for different healthcare markets or service areas.

Document storage and metadata managing uploaded documents with metadata, categorization, and tracking information. This table stores document information including file details, upload tracking, categorization, and soft delete capabilities to support comprehensive document management for healthcare organizations.

Category type assignments linking categories to specific category types for classification and organization. This table manages the assignment of categories to type classifications, enabling hierarchical category organization and type-based filtering for healthcare service categorization.

Attendance codes in claim types defining which attendance codes are valid for specific claim types and their billing configurations. This table manages the relationship between attendance tracking codes and billing claim types, controlling billability, payment rules, and verification requirements for different service delivery scenarios.

Error code payment source associations - Junction table linking clearing house error codes to specific payment source and program type combinations. This table manages error code applicability, enabling targeted error handling and resolution workflows based on payment source and program type contexts for billing operations.

Checklist case type associations linking checklists to specific case types and program types. This table manages which checklists are applicable to different case types and programs, enabling program-specific checklist workflows and ensuring appropriate checklists are applied based on case characteristics.

Agency configuration ID types by program defining which ID types are configured for different program types within agencies. This table manages the relationship between ID type configurations and program types, controlling which identification systems are used for different healthcare programs and enabling program-specific ID validation rules.

Tagged record associations linking tags to specific records across different tables in the healthcare system. This junction table enables flexible tagging of any record type, supporting cross-functional categorization, workflow management, and custom organizational structures for patients, claims, activities, and other business entities.

Declined reason program assignments linking declined reasons to specific program types for program-specific decline management. This junction table manages which decline reasons are available for specific program types, enabling program-specific decline reason configuration and tracking for healthcare service management.

Makeup visit attendance codes defining attendance codes specifically used for makeup sessions and visits. This lookup table provides standardized attendance codes for makeup sessions, supporting proper attendance tracking, billing compliance, and service documentation for makeup visits when regular sessions are missed or rescheduled.

Authorization reviews and renewals tracking periodic reviews of service authorizations for compliance and continued medical necessity. This table manages the review schedule, submission dates, and review types required for ongoing authorization maintenance.

Grid view configuration management - Configuration table storing grid view definitions, filters, settings, and customizations for data display interfaces. This table manages user interface configurations including filter content, grid settings, data sources, custom fields, and application assignments to support customizable data views and reporting interfaces across the healthcare system.

Invoice payment processing managing payment transactions, amounts, and status tracking for healthcare service invoices. This table processes payment applications to invoices including payment amounts, payment types, dates, voucher information, and status tracking, supporting comprehensive invoice payment management, financial reconciliation, and audit trails for healthcare billing operations.

Group application access - Junction table managing application access permissions for user groups including settings and beta testing privileges. This table controls group-based access to applications, feature settings, and beta testing programs to support role-based application access, feature rollouts, and testing coordination for healthcare system applications.

Patient diagnoses managing patient diagnosis assignments including ICD codes, diagnosis dates, and clinical tracking. This table links patients to their diagnoses with ordering, creation tracking, and status management to support clinical documentation, treatment planning, and medical record management for healthcare services and early intervention programs.

Invoice transaction configuration - Configuration table defining invoice transaction types, calculation methods, and processing options. This table stores transaction type definitions, calculation formulas, display settings, SQL queries, and exclusion criteria to support flexible invoice processing, custom billing calculations, and transaction management workflows.

Early Intervention escrow payment tracking managing escrow fund payments and reconciliation for Early Intervention services. This financial tracking table handles complex payment scenarios where funds are held in escrow pending insurance processing, enabling accurate financial reconciliation between multiple payment sources including insurance, Medicaid, and escrow funds.

IP address security management controlling network access through IP address range restrictions and security policies. This table manages IP address-based access control including IP ranges, network descriptions, and deletion tracking, supporting network security, access control, and compliance requirements for healthcare system security and data protection.

IFSP custom fields storing extended custom field data for Individualized Family Service Plans with consent tracking and plan numbering. This table captures additional IFSP information including consent dates, custom comments, early intervention service identifiers, and plan numbers to support comprehensive IFSP documentation and compliance tracking for early intervention services.

Scan temporary error tracking storing temporary error information for scanned claim processing. This table captures error details during the scanning and processing of service coordination claims, providing error tracking, debugging support, and audit trails for scan processing issues that require resolution or manual intervention.

Authorization type definitions defining different categories and types of service authorizations. This lookup table manages authorization type classifications such as evaluation, therapy, consultation, and other service categories for proper authorization categorization and workflow management.

Report output source configuration managing report output templates, processing files, and source configurations for report generation. This table stores output processing configurations including template names, source files, and processing parameters, supporting flexible report generation, template management, and output customization for healthcare reporting systems.

Flag reason lookup table defining standardized reasons for flagging claims, payroll entries, and other records for review, exception handling, and quality assurance processes. This lookup table provides consistent flagging categories used across the system for marking records that require special attention, manual review, compliance verification, or exception processing to support systematic quality management and audit workflows.

Data import audit log - Comprehensive audit trail for data import operations including source system mappings, import descriptions, and processing timestamps. This table tracks data migration activities, system integrations, and import operations to support data governance, troubleshooting, and compliance auditing for healthcare data management.

Case and service coordinator assignments tracking coordinator assignments for patient cases and service delivery. This table manages the assignment of service coordinators and case coordinators to patient admissions, supporting care coordination, case management, and service delivery oversight for healthcare programs.

Scheduled activities and appointments managing calendar events, appointments, and scheduled activities for healthcare providers and patients. This table serves as the foundation for scheduling, appointment management, and activity tracking within the healthcare system.

Case management records tracking individual cases or episodes of care for patients. This table manages the administrative aspects of patient cases including admission, discharge, program enrollment, case coordination, and case status throughout the service delivery lifecycle.

Patient insurance information managing insurance coverage details for patients including policy information, coverage periods, and billing parameters. This table stores comprehensive insurance data needed for claims processing, eligibility verification, and coordination of benefits across multiple insurance plans.

User group memberships managing users’ assignments to security groups for hierarchical permission management. This table supports legacy group-based security alongside the newer role-based system, allowing for complex permission structures.

Authorization diagnosis codes linking service authorizations to specific ICD-9 diagnosis codes for medical justification. This table manages the relationship between authorizations and their supporting medical diagnoses, enabling proper medical coding, insurance billing, and clinical documentation for healthcare service approvals.

Claim ICD diagnosis codes linking claims to specific ICD-9 diagnosis codes for medical justification and billing. This junction table manages the many-to-many relationship between claims and diagnosis codes, supporting multiple diagnoses per claim and proper medical coding for insurance billing and clinical documentation.

Patient allergy information storing detailed allergy records for patients receiving healthcare services. This table manages critical medical information including allergy names, descriptions, and tracking data to support safe care delivery, medication management, and clinical decision-making by healthcare providers.

Content section management organizing content sections for reports, documents, and user interface components. This table manages section definitions including names, types, source information, view types, options, and ordering to support modular content organization, dynamic document generation, and flexible user interface composition for healthcare applications and reporting systems.

Attendance code definitions managing standardized codes for tracking student and client attendance in educational and therapeutic programs. This lookup table provides attendance status codes (Present, Absent, Late, Early Dismissal) with descriptions and administrative tracking for attendance management and reporting.

User specialty assignments linking healthcare providers to their professional specialties and areas of expertise. This junction table establishes which specialties users are qualified to provide, supporting service matching, provider selection, and specialty-based scheduling for healthcare service delivery.

Alert threshold values storing specific threshold values and parameters for alert condition evaluation. This table manages the numeric values, thresholds, and parameters used in alert calculations and condition checking for automated alert triggering.

Payroll flagging system linking payroll records to flag reasons for payroll exception handling, review processes, and quality assurance. This junction table enables payroll entries to be marked with specific flags for manual review, calculation exceptions, compliance issues, or audit workflows, supporting systematic payroll management and ensuring appropriate review of payroll entries requiring special attention or validation.

Patient documents and files managing patient document uploads, file attachments, and document metadata with status tracking and categorization. This table stores patient-related documents including file names, upload dates, content types, status tracking, and grouping to support comprehensive patient record management, document organization, and clinical documentation for healthcare services.

User ID status definitions defining status values for user identification records and credentials. This table manages status classifications for user IDs such as Active, Expired, Pending, Suspended, supporting credential lifecycle management and compliance tracking for healthcare professional qualifications.

System-wide messaging - General messaging system for broadcasting announcements, alerts, and notifications to healthcare system users. This table manages system messages, billing-specific communications, and administrative announcements to support organizational communication, user notifications, and system-wide information distribution.

Healthcare discipline definitions managing healthcare disciplines and specialties for provider classification and service categorization. This master table defines disciplines such as Physical Therapy, Occupational Therapy, Speech Therapy, etc., with lock flags to support provider specialization and service delivery organization.

Custom report layouts - Repository for user-customized report layouts and formatting configurations. This table stores custom report designs, layout definitions, and formatting specifications to support personalized reporting, custom document generation, and user-specific report presentation requirements for healthcare data analysis and compliance reporting.

Patient referral management tracking referral information, sources, and outcomes for patients entering the healthcare system. This table manages referral data including referral dates, outside sources, declined reasons, referral contact information, and referral outcomes, supporting comprehensive referral tracking, source management, and referral outcome analysis for early intervention and healthcare services.

Checklist leadership assignments managing leadership roles and oversight responsibilities for checklists. This table assigns leaders at the user, team, and role levels to provide oversight, approval authority, and management responsibility for checklist completion and quality assurance in healthcare workflows.

Report calculation results storing computed values and results from report calculations and business intelligence queries. This table maintains calculated results for performance metrics, financial summaries, and analytical reports with user and market-specific tracking for dashboard displays and reporting systems.

Payment source management storing comprehensive information about payment sources, insurance providers, and funding entities for healthcare billing. This table manages payment source details including contact information, addresses, account numbers, departments, and billing configurations, supporting comprehensive billing management, insurance processing, and financial administration for healthcare services.

User status definitions defining status values for user accounts and employment status within the healthcare system. This table manages status classifications such as Active, Inactive, Terminated, On Leave, supporting user lifecycle management, access control, and human resources tracking for healthcare staff administration.

System status definitions managing standardized status codes and descriptions used throughout the healthcare system for workflow management and state tracking. This lookup table defines status values including names, descriptions, and status codes to support consistent status tracking, workflow automation, and system state management across all healthcare processes and data entities.

Language definitions and multilingual support managing language options for patients, providers, and system interfaces. This lookup table provides standardized language codes and descriptions for multilingual support, patient language preferences, provider language capabilities, and system localization, supporting diverse patient populations and regulatory compliance for language accessibility.

Data dictionary fields managing field definitions, data types, and lookup configurations for dynamic form generation and data validation. This table defines field metadata including names, descriptions, data types, lookup relationships, and semantic types to support flexible data collection, form generation, and data dictionary management for healthcare applications.

Flexible form configuration settings managing dynamic form field configurations, validation rules, and display properties for customizable forms throughout the healthcare system. This table enables dynamic form generation by defining field properties, validation requirements, control types, and display settings, supporting flexible data collection forms for patient assessments, clinical documentation, and administrative workflows with configurable field behaviors and validation rules.

Billing modifier relationships - Hierarchical relationship table defining parent-child relationships between billing modifiers for complex billing scenarios. This table manages modifier dependencies, inheritance rules, and hierarchical modifier structures to support advanced billing logic, modifier combinations, and compliance with healthcare billing regulations.

Custom ticket extensions storing additional custom fields and specialized information for centralized tickets. This table extends the core ticket functionality with agency-specific custom fields, additional documentation requirements, and specialized data collection needs for different healthcare programs and compliance requirements.

Remittance advice temporary processing table for staging and validating electronic remittance advice (ERA) data before final import. This temporary table mirrors the raimport structure to support batch processing, data validation, error checking, and quality assurance workflows for remittance data. Used for staging imported payment information, performing data transformations, and ensuring data integrity before committing remittance records to the permanent raimport table.

Claim flagging system linking healthcare service claims to flag reasons for quality assurance, review processes, and exception handling. This junction table enables claims to be marked with specific flags for manual review, billing exceptions, compliance issues, or quality assurance workflows, supporting systematic claim management and ensuring appropriate review of claims requiring special attention.

Checklist choice value definitions defining predefined choice values for checklist items with selection options. This lookup table manages standardized choice values such as Yes/No, Pass/Fail, or custom options that can be used in checklist items requiring selection from predefined options.

Remittance advice file management tracking uploaded remittance advice files and electronic payment notifications for claims processing. This table manages RA file metadata including file names, sender/receiver information, upload tracking, and check log associations to support electronic remittance processing, payment reconciliation, and automated claims adjudication workflows.

Stored procedure field associations - Junction table linking fields to stored procedures for dynamic form and report generation. This table manages the relationship between data fields and stored procedures, enabling dynamic field mapping, parameterized queries, and flexible data retrieval for custom forms and reports.

Agency report access permissions defining which reports each agency is authorized to access and generate. This table manages report-level security by controlling which agencies can view, generate, or access specific reports within the system for compliance and data privacy purposes.

Rate code rule management defining rate code rules and assignments for specific claim types and payment sources. This table manages rate code rule configurations including claim type associations, payment source assignments, rate code references, and audit tracking, supporting flexible rate management, billing rule configuration, and payment source-specific rate determination for healthcare billing operations.

Extended claim information - Supplementary table providing additional claim details including service location, rate codes, group information, and service settings. This table extends the core Claim table with specialized fields for complex billing scenarios, makeup sessions, group services, and location-specific service delivery to support comprehensive healthcare billing and service documentation.

Service claims with timing managing basic claim information with service dates and time tracking for billing and service documentation. This table stores essential claim data including service dates, start times, and end times to support time-based billing, service tracking, and claims processing for healthcare services and therapy sessions.

Daycare billing invoices managing invoices for daycare services including billing dates, payment status, and payment methods. This table handles daycare-specific billing with invoice tracking, due dates, payment methods, and paysource assignments to support daycare billing operations and financial management for childcare services.

Outside claims table for storing healthcare claims from external sources, partner organizations, or backup/archive purposes. This table mirrors the main Claim table structure to support data integration from external billing systems, claim reconciliation processes, historical data preservation, and cross-system claim management for comprehensive healthcare billing and revenue cycle management.

Claim service timing storing service timing information for healthcare claims including start and end times. This supplementary claim table captures detailed timing data for services, supporting time-based billing, duration tracking, and service delivery documentation for accurate claim processing and billing verification.

Clinical documentation and notes for healthcare service claims providing comprehensive note-taking capabilities for clinical documentation, billing support, and compliance requirements. This table stores multiple types of notes including clinical observations, session progress, billing justifications, and draft documentation to support healthcare service delivery, billing compliance, and clinical record-keeping for early intervention and therapy services.

User pay group management defining rate groups and compensation structures for staff payroll processing. This table manages pay groups that determine rate structures, compensation levels, and payroll processing rules for different categories of healthcare staff, supporting flexible rate management and payroll administration across various roles and programs.

Claim service timing archive storing archived service timing information for healthcare claims. This archive table maintains historical timing data for services including start and end times, supporting historical reporting, audit trails, and long-term data retention for claim timing analysis and billing verification.

Data source output mappings linking data sources to their output page configurations for report generation. This junction table manages the relationship between data sources and page outputs, supporting report configuration, output formatting, and data source presentation for healthcare reporting and analytics systems.

Transaction category classification defining categories for financial transactions and billing operations within the healthcare system. This table organizes transaction types into logical categories, supporting transaction management, financial reporting, and accounting processes for healthcare billing and revenue cycle management.

Procedure code definitions managing healthcare procedure codes, descriptions, and billing rates for service delivery and billing. This table defines procedure codes including names, descriptions, billing rates, and claim type associations to support procedure-based billing, service documentation, and healthcare service delivery management for clinical and administrative workflows.

Report output logging tracking report generation activities, page counts, and output processing for audit and monitoring purposes. This table logs report generation events including report types, creation timestamps, user tracking, and page counts, supporting report usage monitoring, audit trails, and system performance analysis for healthcare reporting and documentation systems.

Form configuration settings - Configuration table linking clinical providers with their authorized forms, visit codes, and categories. This table manages provider-specific form access, visit code assignments, and category permissions to control form availability, ensure appropriate documentation workflows, and maintain compliance with provider authorization and scope of practice requirements.

Agency billing identifier configuration managing billing ID assignments and configurations for healthcare agencies. This table tracks billing identifiers used by agencies for different payers and programs, including effective dates, status, and billing type associations for proper claims processing and reimbursement.

Checklist item assignment management tracking the assignment of checklist items to users with assignment type classification. This table manages the formal assignment process including assignment types, audit trail, and assignment lifecycle for comprehensive checklist workflow management and accountability.

Patient identifier management storing multiple identifier types and values for patients to support various identification systems and external integrations. This table manages patient identifiers including ID values, type classifications, and patient associations, supporting multiple identification systems, external system integration, and comprehensive patient identification for healthcare services.

Custom form templates defining reusable form templates for creating dynamic forms. This table manages form template definitions including structure, actions, and methods that can be used to generate multiple form instances with consistent layouts and functionality for healthcare documentation and data collection.

Form data source configuration - Configuration table defining data sources for dynamic forms and custom data collection instruments. This table manages the relationship between forms and their underlying database tables, field mappings, and data validation rules to support flexible form design, custom healthcare documentation, and automated data integration across the healthcare management system.

Client case rule assignments linking clients to specific case rules and rule values for business logic enforcement. This table manages the assignment of case rules to clients, enabling client-specific business rule enforcement, validation logic, and workflow customization for healthcare case management and compliance requirements.

Rate code rule payroll management defining payroll-specific rate code rules and configurations for staff compensation calculations. This table manages payroll rate code rules including claim type associations, rate titles, rate codes, payment source usage flags, and audit tracking, supporting flexible payroll rate management, compensation calculations, and payroll rule configuration for healthcare staff payment processing.

Service categories and classifications defining categories for organizing services, procedures, and healthcare activities. This table manages category classifications with program-specific assignments and type definitions to support service organization, reporting categorization, and workflow management across different healthcare programs.

Case type classifications defining the different categories or types of cases that can be managed in the system. This lookup table provides standardized case classifications for organizing and reporting on different types of healthcare service cases.

Temporary rate processing storing temporary rate data for rate calculations, updates, and migration processes. This temporary table supports rate management operations, bulk rate updates, and rate calculation processes during system maintenance and rate structure changes for healthcare service billing.

Deleted history records maintaining archived records of deleted history entries for comprehensive audit trails. This audit table preserves deleted history information including field changes, values, and metadata to support data integrity, audit compliance, and historical data recovery for healthcare information systems.

Remittance advice import Suffolk County managing imported remittance advice data specifically for Suffolk County healthcare claims processing. This table stores imported RA data including authorization information, charge amounts, payment details, billing dates, and processing status, supporting automated remittance processing, payment reconciliation, and financial management for Suffolk County healthcare billing operations.

Stored procedure definitions managing database stored procedures used for data processing, validation, and business logic execution. This table defines stored procedures including names, descriptions, threshold counts, and field associations to support automated data processing, business rule execution, and database-driven workflow automation for healthcare system operations.

Payment transaction details tracking individual financial transactions within payment checks. This table maintains a detailed audit trail of all payment-related transactions including applications to specific claims, adjustments, and payment allocations.

Report action configurations managing automated actions and triggers associated with reports. This table defines actions that can be executed when reports are generated, viewed, or meet specific conditions, supporting automated workflows, notifications, and business process integration for healthcare reporting and analytics.

Scanned document archive headers managing header information for archived scanned documents and forms. This table stores archive metadata including header IDs, timestamps, user information, patient identifiers, and update tracking to support document archival workflows, audit trails, and archived document management for healthcare documentation and compliance record keeping.

Patient outside source associations linking patients to external sources and referral agencies for service coordination and referral management. This junction table manages relationships between patients and outside sources including comments and source information, supporting referral tracking, external service coordination, and comprehensive patient care management across multiple providers.

Securable item definitions defining items that can be secured through the access control system. This lookup table manages securable items including names and descriptions for objects that can have security permissions applied, supporting comprehensive access control, permission management, and security administration for healthcare system components and data elements.

Action workflow rules defining business rules and status transitions for workflow automation. This table manages the conditional logic that determines how actions progress through different states based on error conditions, status changes, and business rule validation for automated workflow processing.

IFSP review scheduling - Core table managing review schedules and completion tracking for individualized family service plans. This table stores review types, due dates, submission dates, and actual completion dates to support IFSP compliance monitoring, review scheduling, and regulatory reporting for early intervention services.

User group client associations linking users to client groups for access control and data filtering. This junction table establishes which client groups users have access to, supporting multi-tenant data isolation, client-specific access control, and group-based data filtering for healthcare organizations serving multiple client populations.

Deleted billing records maintaining archived records of deleted billing batches for audit and recovery purposes. This audit table preserves deleted billing information including batch details, totals, and processing information to support financial auditing, billing integrity, and compliance tracking for healthcare billing operations.

Checklist assignment type definitions defining the types of assignments that can be made for checklist items. This lookup table manages assignment type classifications such as individual, team, role-based, or automatic assignments for organizing checklist workflow and responsibility distribution.

Patient evaluation CPT code associations linking evaluations to specific CPT codes and units for billing and service documentation. This junction table manages the relationship between patient evaluations and CPT codes including unit quantities, supporting accurate billing, service documentation, and evaluation coding for healthcare reimbursement and compliance.

Primary patient/client records containing core demographic and contact information for individuals receiving healthcare services. This central table manages patient enrollment, demographics, insurance information, and regulatory compliance documentation for clients across all healthcare programs.

Account code lookup table for financial categorization and billing code management. This lookup table provides standardized account codes used for financial reporting, billing categorization, and accounting integration to support proper revenue recognition and financial analysis.

IFSP outcomes management storing family-centered outcomes for Individualized Family Service Plans and early intervention services. This table manages outcome descriptions, creation tracking, update history, and soft deletion for IFSP outcomes, supporting family-centered planning, outcome-based intervention, and progress monitoring for early intervention services and developmental support.

Visit waiver and makeup code management defining codes for waiving co-visits and managing makeup visit requirements. This table manages special codes that allow for waiving required co-visits or scheduling makeup visits when standard visit requirements cannot be met, supporting flexible service delivery and compliance with program requirements.

Program addon associations linking healthcare programs to additional features, modules, or services that extend program functionality. This junction table manages the relationship between programs and their available addons including ordering information, supporting program customization, feature management, and modular program configuration for healthcare service delivery.

Claims aging analysis cube providing aggregated data for claims aging analysis and financial reporting. This analytical table summarizes claims data by site, service date, and program type with charged amounts to support aging reports, financial analysis, and accounts receivable management for healthcare billing operations.

Service delivery locations - Master table managing physical locations where healthcare services are provided including clinics, schools, homes, and community centers. This table stores location details, addresses, billing codes, and administrative information to support service delivery planning, billing compliance, and location-based reporting for healthcare service coordination.

Sub-claim CPT code associations linking service coordination sub-claims to Current Procedural Terminology codes. This junction table establishes many-to-many relationships between service coordination claims and CPT codes, supporting accurate billing, procedure coding, and compliance with healthcare coding standards for service coordination activities.

Educational plan rate management defining billing rates, schedules, and pricing structures for educational programs and classes. This table manages rate configurations including rate types, amounts, effective dates, billing intervals, and calculation methods, supporting flexible pricing models, billing automation, and financial management for healthcare-related educational services and program administration.

Case site associations linking patient cases to specific service delivery sites for location-based case management. This table manages the relationship between patient cases and the physical locations where services are provided, supporting site-specific reporting, resource allocation, and service delivery coordination.

NYEIS F-file import tracking - Import tracking table for New York Early Intervention System F-files managing import status, error handling, and data validation. This table tracks the import process for NYEIS F-files including error messages, reference numbers, claim details, and processing dates to support automated data import, error resolution, and compliance reporting for New York State early intervention data exchange.

EDI claim edit tracking managing electronic claim edits and status information from EDI processing. This table tracks claim edits from electronic data interchange processing including patient information, claim status, trace numbers, and program details to support EDI claim management and electronic billing workflows.

Remittance status codes managing status tracking for remittance advice processing and electronic payment notifications. This table defines status codes used throughout the remittance processing workflow including pending, processed, error, and completed states to support remittance tracking, payment reconciliation, and billing status management for healthcare claims processing.

Medical prescriptions and treatment orders - Core table managing medical prescriptions, treatment orders, and service authorizations for healthcare providers. This table tracks prescription details, provider assignments, treatment periods, and administrative information to support clinical care coordination, provider management, and treatment compliance for healthcare service delivery.

Reports management table for creating, configuring, and managing business intelligence reports and analytics. This table supports comprehensive reporting capabilities including SQL queries, HTML formatting, categorization, sharing, publishing, and custom data sources. Essential for healthcare analytics, compliance reporting, operational dashboards, and data-driven decision making in early intervention and healthcare services management.

Status level associations linking status definitions to specific application levels for hierarchical status management. This junction table manages the relationship between statuses and application levels to support level-specific status tracking, hierarchical workflow management, and context-appropriate status options for different areas of the healthcare system.

Payroll employee record management storing individual employee payroll records with detailed compensation information for healthcare staff. This table manages employee-specific payroll data including hours worked, pay rates, pay types, calculation dates, and processing status, supporting comprehensive payroll processing, employee compensation tracking, and detailed payroll reporting for healthcare organizations.

Report criteria definitions managing criteria files and parameters for report generation and data filtering. This table defines criteria files with their system names and user-friendly display names to support dynamic report generation, data filtering, and customizable reporting functionality for healthcare analytics.

Invoice archive tracking managing the archival status and history of billing invoices. This table tracks when invoices are archived, their status changes, and associated voucher information for audit trail purposes and invoice lifecycle management in the billing system.

User field choice options defining selectable options for custom user fields with dropdown or selection capabilities. This table provides choice lists for custom user fields, enabling standardized data entry, consistent option selection, and controlled vocabulary for user profile customization and data collection.

User password management storing encrypted passwords and authentication security information. This table maintains password history, security settings, and account lockout information for secure user authentication.

Extended patient case administration storing comprehensive custom fields and specialized administrative information for patient cases. This table extends the core PatientAdministration functionality with agency-specific custom fields, detailed case management data, clinical information, service coordination details, and specialized documentation requirements for different healthcare programs and compliance needs.

Payment source site associations linking payment sources to specific service delivery sites for location-based billing and financial management. This junction table manages the relationship between payment sources and service sites, supporting site-specific billing arrangements, payment source assignments, and financial tracking for healthcare services delivered at different locations.

Document and file management system providing comprehensive file storage, organization, and metadata management for healthcare documents, patient records, and administrative files. This table supports hierarchical folder structures, file versioning, access tracking, and document lifecycle management including upload, modification, and deletion tracking for compliance with healthcare documentation requirements and audit trails.

User pay type classification defining payment types and compensation methods for staff payroll processing. This table manages different pay types that determine how staff are compensated, including salary, hourly, contract, and other payment structures, supporting diverse compensation models and payroll processing requirements for healthcare organizations.

User discipline assignments linking healthcare providers to their professional disciplines and program types. This table establishes which disciplines users are qualified to provide within specific program contexts, supporting discipline-based service delivery, provider qualification tracking, and program-specific staff assignments.

EDI response files managing electronic data interchange response files from payers and clearinghouses with status tracking and error handling. This table stores EDI response files including file names, descriptions, upload tracking, processing status, and error information to support electronic billing, claims processing, and EDI transaction management for healthcare billing operations.

SQL query definitions storing dynamic SQL query components for report generation and data retrieval. This table manages SQL query parts including SELECT clauses, FROM statements, WHERE conditions, GROUP BY clauses, ORDER BY specifications, and paging controls to support dynamic query building, report generation, and flexible data retrieval for healthcare reporting and analytics.

Communication document associations linking internal communication messages to related documents and attachments. This junction table manages the relationship between communication messages and documents to support document sharing, attachment management, and comprehensive communication workflows with supporting documentation for healthcare team collaboration.

System configuration items defining customizable configuration options, business rules, and system settings. This flexible configuration table enables system administrators to customize system behavior, define business rules, and manage configurable options across different program types and disciplines.

Payroll exception rule type definitions defining types and rules for payroll exception processing and validation. This lookup table manages exception rule types including descriptions, field mappings, qualifiers, and table references, supporting systematic payroll exception processing, rule-based validation, and flexible exception handling for healthcare staff compensation management.

Form submissions tracking managing submitted form data with comprehensive metadata including user information, system details, and submission tracking. This table stores form submission data including field values, submission dates, user information, browser details, geographic information, and file associations to support form processing, audit trails, and submission analytics for healthcare data collection.

Report data sources managing data source definitions for reports including table queries, joins, and primary key specifications. This table defines data sources used by reporting systems with SQL queries, view names, join specifications, and audit tracking to support dynamic report generation, data visualization, and business intelligence for healthcare reporting and analytics.

Claim transaction check links linking claim transactions to specific payment checks for financial reconciliation. This junction table manages the relationship between claim transactions and payment checks, supporting check allocation, payment tracking, and financial reconciliation for healthcare billing operations.

Group addon associations linking user groups to addon features and extensions for enhanced functionality access. This junction table manages group-based access to addon features, extensions, and enhanced functionality modules, supporting role-based feature access control and addon management for different user groups within the healthcare system to enable customized functionality based on group permissions and organizational needs.

Custom outcomes extensions providing additional custom fields and extended data for IFSP outcomes management. This extension table stores organization-specific outcome data, custom tracking fields, and additional attributes to support specialized outcome management, progress tracking, and reporting requirements beyond standard outcome data for early intervention services.

Service authorizations defining approved healthcare services, treatment plans, and service parameters for patients. This central table manages the authorization of specific services including therapy sessions, evaluations, and other healthcare interventions with detailed service specifications, units, rates, and approval periods.

Healthcare service visits linking scheduled activities to specific patient visits and service delivery. This table connects calendar activities to actual healthcare service provision, enabling tracking of patient visits, service authorization, and clinical documentation.

Case category program assignments linking case categories to specific program types for program-specific case management. This table manages which case categories are available for each program type, enabling program-specific case classification and workflow management in healthcare service delivery.

Provider specialty definitions managing healthcare provider specialties and areas of expertise for service delivery and provider qualification tracking. This lookup table defines specialty categories including specialty names and locking controls to support provider credentialing, service matching, and specialty-based care coordination for healthcare and early intervention services.

Field linking and relationships managing connections between configuration fields and form elements for dynamic form behavior. This junction table links main configuration fields with sub-fields to create dependent field relationships, conditional form logic, and dynamic form behavior, supporting flexible form design and configuration management for healthcare documentation systems.

Agency billing type configurations defining billing type assignments and settings for healthcare agencies. This table manages the relationship between agencies and their billing types, including billing identifiers, effective periods, and configuration parameters for different payers and programs.

Business rule error definitions managing validation rules, error messages, and business logic enforcement for healthcare data processing. This table defines business rules including rule descriptions, actions, display settings, instructions, and provider permissions to support data validation, compliance checking, and automated business rule enforcement across healthcare workflows and claim processing.

Data field dictionary defining field metadata, descriptions, and custom naming for database fields. This data dictionary table manages field definitions with their descriptions, data types, categories, and custom names to support data documentation, field customization, and metadata management for healthcare data systems.

Payment source case associations linking payment sources to specific patient cases for billing and financial management. This junction table manages the relationship between payment sources and patient cases, supporting case-specific billing arrangements, payment source assignments, and financial tracking for individual patient cases across different healthcare programs and services.

Word form document history tracking versions and changes to Word document forms and templates used in the healthcare system. This table maintains audit trails for document modifications, supporting version control, compliance documentation, and tracking of form template changes for regulatory and quality assurance purposes.

Custom user field definitions defining configurable fields for extending user profiles with organization-specific data requirements. This table manages custom field definitions including validation rules, display properties, and data collection requirements, supporting flexible user profile customization and compliance with organizational data collection needs.

Deleted claim transaction records maintaining archived records of deleted claim transactions for audit and recovery purposes. This audit table preserves deleted transaction information including amounts, types, and processing details to support financial auditing, transaction integrity, and compliance tracking for healthcare claim processing.

Manual payroll rate management storing custom payroll rates, stipends, and compensation structures for various meeting types and payroll categories. This table manages manual rate overrides, special compensation rates, stipend types, and time-based payroll calculations, supporting flexible payroll management, special compensation scenarios, and administrative payroll processing for healthcare staff.

Rule error bypass permissions managing exceptions and bypass authorizations for business rule enforcement. This table tracks which claim procedures can bypass specific rule errors, supporting authorized exceptions, special circumstances, and administrative overrides for business rule compliance while maintaining audit trails and proper authorization controls.

EI Hub import status details tracking detailed status information for individual records in EI Hub import operations. This table manages granular import status for cases, authorizations, and plans with detailed error messages to support import troubleshooting and data validation for Early Intervention system integration.

Contact type definitions defining categories of contacts for patient and organizational communication. This lookup table manages contact type classifications such as emergency contact, family member, provider, or organization to support contact organization and communication management in healthcare settings.

Service decline reasons defining reasons why services or referrals are declined or rejected. This lookup table manages decline reason codes and descriptions to support referral management, service denial tracking, and decline reason reporting for healthcare service coordination and case management workflows.

Dashboard definitions managing dashboard configurations, layouts, and settings for data visualization and reporting. This table defines dashboard components with their XML configurations, permissions, data sources, and display settings to support customizable dashboards and business intelligence for healthcare organizations.

Patient prescription management storing comprehensive medication and prescription information for patients including dosage, refills, and administration details. This table manages patient prescriptions including prescription types, status tracking, start/end dates, refill information, dosage instructions, and administration routes, supporting medication management, prescription tracking, and comprehensive patient care coordination.

Status code definitions providing standardized status codes and descriptions used throughout the system. This lookup table defines the various status values used for claims processing, workflow management, and system state tracking with associated actions and processing rules.

Claim relationship links managing relationships and connections between related claims. This table tracks claim linkages such as corrected claims, voided claims, and related service claims to support claim relationship management, correction workflows, and billing integrity for healthcare claim processing.

Medical claims managing healthcare service claims for billing and reimbursement processing. This core billing table stores detailed claim information including service dates, procedures, diagnoses, and amounts for submission to insurance companies and government payers.

EDI claim status codes managing status codes and details for EDI claim processing. This table tracks claim status codes from electronic data interchange processing to support claim status tracking, EDI response processing, and electronic billing status management for healthcare claims.

Billing type definitions defining different methods and formats for submitting healthcare claims and billing information. This lookup table manages billing type classifications such as electronic, paper, and clearing house-specific billing methods to support various payer requirements and submission workflows.

Form submission records storing completed form data and submission metadata for dynamic forms. This table captures form responses, user session information, submission tracking, and form lifecycle management, supporting comprehensive form processing workflows, audit trails, and data collection for healthcare documentation and reporting.

Claim queue processing history maintaining historical records of claim queue processing activities. This audit table tracks when claims were processed, checked out, and archived from the processing queue, supporting workflow analysis, processing time tracking, and queue management reporting.

Enrollment case payment sources linking enrollments to payment sources with percentage allocations and invoice scheduling. This table manages the relationship between enrollments and payment sources including percentage splits and invoice scheduling to support multi-payer enrollment management and billing allocation.

Workflow tracking field definitions defining configurable tracking fields for business process management and compliance monitoring. This table enables agencies to create custom tracking fields for various business processes, regulatory requirements, and quality assurance workflows with automated triggers and notifications.

Agency configuration preferences storing customizable settings and business rules for each agency’s operations. This table manages agency-specific preferences for system behavior, reporting options, workflow configurations, and program-specific settings.

Custom form definitions managing dynamic form configurations and layouts for data collection. This table defines custom forms with their fields, validation rules, URLs, and behavior settings to support flexible data collection, custom workflows, and organization-specific forms for healthcare data management.

Payment source program associations linking payment sources to specific program types with authorization and billing requirements. This junction table manages the relationship between payment sources and program types including status tracking, authorization requirements, invoice logging, and claim site requirements, supporting program-specific billing configurations and payment source management.

Activity categories defining different categories or types of activities for organizational and security purposes. This table provides classification for activities, enabling categorization of appointments, meetings, and healthcare activities for reporting, security permissions, and workflow management.

Prescription custom data extensions storing additional custom fields and specialized information for medical prescriptions and treatment orders. This extension table captures organization-specific prescription data, custom tracking fields, and specialized prescription information that supports enhanced prescription management, custom workflows, and comprehensive treatment documentation for healthcare service delivery.

Alert refresh history tracking when alert data and calculations are refreshed or updated. This audit table maintains timestamps of alert system refresh cycles, supporting performance monitoring, troubleshooting, and ensuring alert data currency.

User language proficiency tracking languages spoken by healthcare staff for patient communication and service delivery. This junction table enables matching of multilingual staff with patients who speak specific languages, supporting culturally appropriate care and effective communication in diverse healthcare environments.

Billing batch statistics providing summary counts and totals for billing batches by claim type and billing type. This summary table aggregates billing data to support financial reporting, batch validation, and billing analytics for revenue cycle management and operational oversight.

Checklist items workflow management table for defining individual checklist items within workflow processes. This table supports comprehensive workflow automation including task assignments, due date calculations, conditional logic, recurring tasks, and automated completion rules. Essential for managing complex business processes, compliance workflows, case management tasks, and ensuring systematic completion of required activities in healthcare and early intervention services.

Diagnosis audit history maintaining comprehensive audit trail of changes to diagnosis records for clinical data integrity and compliance. This audit table tracks all modifications to diagnosis data including field-level changes, timestamps, user accountability, and before/after values, supporting clinical audit requirements, data integrity verification, and regulatory compliance for patient diagnosis management and medical record keeping.

Agency service locations representing the physical sites where healthcare services are delivered. This table manages multiple service locations for each agency, enabling site-based operations, reporting, and user assignments for decentralized healthcare delivery.

Business process management tracking automated processes, workflows, and system operations for healthcare business process automation. This table manages process definitions including process types, status tracking, file processing, and output generation, supporting workflow automation, document processing, and business process monitoring for healthcare operations and administrative tasks.

Invoice transaction reason tracking managing reasons and justifications for invoice transaction modifications and adjustments. This table tracks the business reasons for invoice transactions including voids, adjustments, corrections, and modifications, supporting audit requirements, compliance documentation, and transaction accountability for healthcare billing operations.

Detailed visit documentation containing comprehensive clinical notes and custom documentation for healthcare service visits. This table stores detailed visit notes, service documentation, and clinical observations for patient care activities.

Electronic signature records storing digital signatures and authentication data for healthcare documents and forms. This table manages signature capture including table associations, signature data, user authentication, geolocation tracking, and audit trails to support comprehensive electronic signature workflows, document authentication, and compliance with digital signature regulations for healthcare documentation.

User regional assignments linking healthcare staff to specific geographic regions for service delivery and coverage management. This junction table enables regional assignment of staff, supporting geographic service coverage, travel planning, and regional management of healthcare service delivery across different areas.

IFSP type classifications defining the categories and types of Individualized Family Service Plans for early intervention services. This lookup table provides standardized IFSP type definitions including Initial IFSP, Annual IFSP, Interim IFSP, and Transition IFSP, supporting proper IFSP categorization, workflow management, and regulatory compliance with early intervention service requirements.

System announcements and communications managing internal announcements and notifications sent to users, teams, and roles within the healthcare system. This table supports organizational communication, system notifications, and priority messaging for operational updates, policy changes, and important healthcare information distribution.

Custom form instances representing individual form instances created from form templates. This table manages actual form instances with their data, status, and relationships to templates, enabling dynamic form creation, data collection, and form lifecycle management for healthcare documentation and data entry.

Database diagram properties storing SQL Server database diagram properties and metadata. This system table manages database diagram information including object properties, values, and versioning to support database design documentation and diagram management for the healthcare database schema.

Patient case supply and incident tracking managing supplemental case information including hospitalization periods, lab charges, and incident documentation. This table stores additional case-related data including work restrictions, hospitalization dates, outside lab information, Medicaid resubmission codes, and incident tracking, supporting comprehensive case management and supplemental documentation for patient care coordination.

Workflow automation rules defining automated business processes and triggers for streamlining healthcare operations. This configuration table enables agencies to set up automated workflows, data validation rules, and business process automation to improve efficiency and ensure compliance with operational procedures.

User roles and permissions defining role-based access control and permission sets for healthcare system users. This table manages role definitions, descriptions, locking status, and discipline type associations to support comprehensive role-based security, user management, and access control for healthcare applications and organizational structure management.

Patient diagnosis audit history maintaining comprehensive audit trail of changes to patient diagnosis records for clinical accountability and regulatory compliance. This audit table tracks all modifications to patient diagnosis data including field-level changes, timestamps, healthcare provider accountability, and before/after values, supporting clinical audit requirements, medical record integrity, and compliance with healthcare regulations for patient diagnosis management.

Service type definitions managing healthcare service type classifications and descriptions for early intervention and healthcare services. This lookup table defines service types including codes and descriptions to support service categorization, billing classification, and service delivery management for therapy services, evaluations, and other healthcare interventions.

Discipline type program assignments linking disciplines to discipline types within specific program types. This junction table manages the complex relationship between disciplines, discipline types, and program types to support discipline-specific configuration and user assignment for healthcare service delivery.

EI Hub import history tracking Early Intervention Hub data import operations with status and audit information. This table manages import history for EI Hub data exchanges including import status, messages, and user tracking to support data integration, import monitoring, and audit trails for Early Intervention system integration.

Market-specific rule error configurations managing business rule applications for specific markets and claim types. This table defines market-specific rule enforcement including claim type associations, market identifiers, rule error codes, locking controls, and check order to support market-specific compliance requirements and regional business rule variations for healthcare billing and processing.

Trigger testing table used for testing database triggers and automated processes. This table supports development and testing of database triggers, stored procedures, and automated business rules to ensure proper functionality before deployment to production environments.

Aging period data storing historical aging information for specific time periods and service dates. This table maintains aging snapshots for accounts receivable analysis, tracking charged amounts and entry dates by site and patient for period-over-period aging trend analysis and financial reporting.

Claim financial transactions tracking all financial activities and status changes for individual claims. This table maintains a complete audit trail of claim processing including payments, adjustments, voids, and other financial transactions throughout the claim lifecycle.

Patient language preferences managing language associations for patients to support multilingual services and communication needs. This junction table links patients to their preferred languages including display order for multiple languages, supporting multilingual patient care, interpreter services, and culturally appropriate healthcare delivery for diverse patient populations.

User category classification defining categories for organizing and classifying users within the healthcare system. This table provides organizational structure for user management, enabling categorization by role type, employment status, or functional area to support user administration, reporting, and access control management.

Activity status category associations linking activity statuses to specific activity categories for workflow management. This table defines which statuses are available for activities within different categories, enabling category-specific workflow rules and status transitions.

Scan upload file tracking managing individual files within scan upload batches. This table tracks specific files that have been uploaded for scanning, including file names, page counts, and batch associations, supporting file management, batch processing, and audit trails for document scanning workflows.

Document group definitions managing document categories and groupings for patient document organization. This table defines document groups to support document categorization, organization, and access control for patient document management and clinical documentation workflows.

User favorite features managing user-specific favorite features and interface customizations with layer associations and deletion tracking. This table stores user preferences for favorite features, interface layers, and personalization settings to support customizable user interfaces, feature shortcuts, and personalized user experiences for healthcare applications.

Patient contact custom fields table for storing extended contact information including employment details, communication preferences, service coordination data, and IFSP (Individualized Family Service Plan) related information. This table captures comprehensive contact details beyond standard information, supporting family engagement, service delivery coordination, employment tracking, and specialized communication needs for early intervention and healthcare services.

Classroom teacher assignments managing the assignment of teachers to specific classrooms with date tracking. This table tracks which teachers are assigned to which classrooms including active and inactive dates to support teacher scheduling, classroom management, and educational program staffing coordination.

Daycare financial transactions managing all financial transactions for daycare services including charges, payments, and adjustments. This table tracks daycare billing transactions with service periods, transaction types, amounts, payment methods, and enrollment associations to support comprehensive daycare financial management and billing operations.

Action stored procedure associations linking workflow actions to database stored procedures for automated processing. This table enables actions to trigger specific database procedures as part of workflow automation and business process execution.

Client data layer management providing configurable data layers and filtering criteria for client-specific data views and reporting. This table manages custom data layers, filtering criteria, and client-specific configurations for data presentation, supporting customized reporting, data visualization, and client-specific data access patterns for healthcare analytics and reporting.

Activity status definitions defining the various states that activities can have throughout their lifecycle. This lookup table provides standardized status values for activities including scheduled, completed, cancelled, and other workflow states with associated display and processing rules.

Insurance carriers and payers managing insurance company information including contact details, addresses, and communication preferences. This table stores comprehensive insurance carrier data including company names, addresses, phone numbers, email contacts, and lock status to support insurance billing, claims processing, and payer relationship management for healthcare services.

Extended patient information containing additional custom fields and detailed medical/developmental information for patients. This table stores specialized information such as birth details, medical history, developmental assessments, and other clinical data required for comprehensive patient care.

Report export tracking - Audit trail for exported reports and data files including export metadata, user tracking, and deletion management. This table maintains a complete history of report exports, file generation activities, and data extraction operations to support compliance auditing, data governance, and export activity monitoring.

Billing batch management tracking billing batches and file generation for healthcare claims submission. This central billing table manages the creation, processing, and submission of billing batches to insurance companies and other payers, including batch totals, status tracking, and file generation details for revenue cycle management.

Service type CPT code associations linking service types to specific CPT procedure codes for billing and documentation. This junction table manages the relationship between service types and CPT codes, supporting accurate billing code assignment, service classification, and procedure code validation for healthcare service delivery and billing processes.

Clearing house error codes defining error codes and solutions for clearing house claim rejections. This table manages error code definitions, descriptions, and resolution guidance to support error handling, claim correction workflows, and clearing house communication for electronic billing operations.

Draft content management storing draft versions of various entry types with session tracking and version control. This table manages draft content for forms, documents, and other entries with user session tracking, parent-child relationships, and soft delete capabilities to support draft functionality across the healthcare system.

Payroll invoice management handling payroll invoice generation, processing, and tracking for healthcare staff compensation. This table manages individual payroll invoices including voucher information, invoice dates, claim totals, amounts, processing status, and batch associations, supporting systematic payroll invoice processing, payment tracking, and financial reconciliation for healthcare provider compensation.

Scheduled visit entry configuration table defining user interface settings, field visibility, default values, and business rules for scheduled visit entry forms. This table controls how visit entry screens behave for different claim type programs, including field requirements, default selections, validation rules, and workflow configurations to ensure consistent and efficient visit documentation across healthcare service delivery.

Custom form data entries storing submitted data from custom forms with audit tracking and key field relationships. This table manages form submission data including field values, key relationships, audit information, and submission tracking to support custom form functionality and data collection for healthcare organizations.

Workflow tracking instances storing individual tracking field instances and their current status for business process monitoring. This table maintains the actual tracking records for compliance items, quality assurance tasks, and business process milestones with assignment and status tracking.

Claim type program configuration defining claim type configurations and business rules for specific program types. This configuration table manages claim type settings including authorization requirements, unit limits, display options, and default behaviors for different program types to support program-specific billing workflows and claim validation.

Training program management storing training courses, materials, and educational content for healthcare staff development. This table manages training programs, compliance training, continuing education requirements, and professional development resources to ensure staff competency and regulatory compliance in healthcare service delivery.

CPT procedure code definitions managing Current Procedural Terminology codes for healthcare services and procedures. This master table defines CPT and HCPCS codes with descriptions, unit definitions, and classification flags to support accurate medical billing, procedure documentation, and service coding for healthcare claims processing.

Room and facility management storing information about service delivery locations, therapy rooms, and facility spaces used for healthcare services. This table manages room details including titles, addresses, and location information to support facility management, scheduling coordination, and service delivery location tracking for healthcare and early intervention services.

Activity assignment type UI controls defining user interface controls and form elements for different activity assignment types. This table manages the dynamic form controls, field configurations, and user interface elements used when creating or editing activity assignments for different types of healthcare activities.

Application client settings storing configuration settings and preferences for different client applications accessing the healthcare system. This table manages client-specific configurations, user interface preferences, and application behavior settings for various healthcare applications and modules.

Invoice transaction check associations linking invoice transactions to check payments for payment tracking and reconciliation. This junction table connects invoice transactions with check log entries, supporting check payment processing, payment reconciliation, and audit trails for check-based payments in healthcare billing operations.

System audit trail maintaining a comprehensive audit log of all data changes across the system for compliance, security, and troubleshooting purposes. This central audit table tracks field-level changes with before/after values, timestamps, and user attribution for regulatory compliance and data integrity monitoring.

Payroll exception management handling special payroll cases, rate overrides, and exception processing for healthcare staff compensation. This table manages payroll exceptions including custom rates, special pay types, effective date ranges, and exception status tracking, supporting flexible payroll processing, rate adjustments, and special compensation scenarios for healthcare organizations.

Voided claims tracking maintaining records of claims that have been voided or cancelled in the healthcare billing system. This table tracks which claims have been voided, the reasons for voiding, and timestamps for audit purposes, supporting proper billing management, compliance reporting, and financial reconciliation processes.

Alert notification history tracking the delivery and timing of alert notifications sent to users. This audit table maintains records of notification events including recipient information, notification counts, and delivery timestamps for monitoring alert system performance and user engagement.

Patient ID correction tracking managing the correction of invalid or duplicate patient identifiers in the system. This data quality table tracks problematic patient IDs that need correction, mapping bad IDs to correct ones with patient identification information to support data cleanup and patient record consolidation efforts.

Internal communication messages managing internal messaging and communication between healthcare system users. This table stores communication messages including subjects, content, priorities, categories, and audit tracking to support internal messaging workflows, team communication, and information sharing for healthcare staff coordination and organizational communication.

Monthly aging balance for outside sources tracking outstanding balances by aging periods specifically for external or outside source billing and accounts receivable. This specialized aging table manages balance analysis for outside source billing including aging periods, site-specific balances, and collection tracking, supporting financial management and accounts receivable processes for external billing relationships.

Custom column name mappings managing user-defined column names and display labels for database tables and fields. This customization table allows organizations to override default column names with custom labels, supporting user interface customization, localization, and organization-specific terminology for healthcare data presentation.

System alerts and notifications defining automated alerts based on report data and business conditions. This table manages alert configurations including condition thresholds, visual styling, notification settings, and action triggers for proactive monitoring of key business metrics and operational indicators.

Document folder templates - Template management system for organizing and structuring document folders across healthcare workflows. This table stores reusable folder structures, organizational hierarchies, and configuration settings to standardize document management, ensure consistent filing systems, and support automated folder creation for patient records, administrative documents, and clinical documentation.

User screen access control managing group-based permissions for specific screens, tabs, and interface elements. This table defines which user groups have access to specific parts of the application interface, supporting granular security control, role-based interface customization, and feature-level access management for healthcare system users.

Claim transaction change history tracking field-level changes made to claim transactions for audit and compliance purposes. This audit table maintains a complete history of transaction modifications including before and after values, change dates, and user tracking to support financial auditing and transaction integrity verification.

Sub-claim ICD-9 diagnosis associations linking service coordination sub-claims to diagnostic codes. This junction table establishes many-to-many relationships between service coordination claims and ICD-9 diagnosis codes, supporting accurate medical billing, diagnosis coding, and compliance with healthcare coding standards for service coordination activities.

Daycare transaction audit history maintaining comprehensive audit trail of changes to daycare transaction records for compliance and data integrity. This audit table tracks all modifications to daycare transaction data including field-level changes, timestamps, user accountability, and before/after values, supporting regulatory compliance, data integrity verification, and audit requirements for daycare billing and transaction management.

Communication status definitions managing status codes and actions for internal communication message workflows. This lookup table defines status names and associated actions for communication messages to support message lifecycle management, workflow automation, and status-based processing for internal healthcare team communication and messaging systems.

Monthly aging balance reporting tracking outstanding balances by aging periods for accounts receivable management and financial reporting. This table stores aging analysis data including balance amounts across different aging periods (30, 60, 90+ days), supporting financial management, collections processes, and accounts receivable reporting for healthcare billing operations.

Payroll city professional processing managing payroll calculations and processing for city-based professional services. This table handles complex payroll calculations including rates, hours, mileage, and various payroll types for professional staff providing services across different sites and programs, supporting comprehensive payroll management and reporting.

Report attachment configurations managing file attachments and document associations for reports. This table defines which forms, columns, and categories can be attached to reports, supporting document management, report supplementation, and comprehensive reporting with supporting documentation for healthcare analytics and compliance.

Email template definitions managing reusable email templates for automated communications. This table defines email templates with HTML content and subjects organized by type and group to support standardized communications, automated notifications, and consistent messaging for healthcare organizations.

Referral agency definitions managing organizations and agencies that refer patients to healthcare services. This lookup table defines referral agencies with names and identifiers, supporting referral source tracking, agency relationship management, and referral pattern analysis for patient acquisition and service coordination in healthcare organizations.

Flexible form definitions - Master table defining flexible, configurable forms for dynamic data collection and custom documentation. This table stores form metadata, validation scripts, hierarchical relationships, and addon configurations to support customizable healthcare forms, assessment instruments, and data collection workflows.

SQL control definitions managing SQL queries and control logic for activity assignment type controls. This table stores SQL statements and control logic used in activity assignment workflows, enabling dynamic control behavior, data validation, and business rule enforcement for healthcare activity management and assignment processes.

Dynamic grid configuration - Configuration table for dynamic grid layouts, filtering capabilities, and data presentation settings. This table stores grid definitions, filter content, column configurations, and data source mappings to support flexible data visualization, user-customizable grids, and advanced filtering interfaces for healthcare data management.

Quality assurance notes and documentation storing detailed QA notes, reviews, and approval tracking for quality assurance processes. This table manages QA documentation including notes content, category assignments, approval workflows, report associations, and audit trails, supporting comprehensive quality assurance documentation, review processes, and compliance monitoring for healthcare service delivery.

IFSP review scheduling and tracking managing review timelines, due dates, and completion status for Individualized Family Service Plans. This table tracks IFSP review requirements including periodic reviews, annual reviews, and interim reviews, supporting regulatory compliance with IDEA Part C review mandates and ensuring timely IFSP updates and family engagement in the review process.

Tag group organization defining groups for organizing and categorizing tags within the healthcare system. This table enables hierarchical organization of tags into logical groups, supporting better tag management, user interface organization, and systematic categorization of business entities across different functional areas.

Custom form control extensions storing additional properties and extended attributes for custom form controls. This table provides flexible property storage for form controls, enabling custom attributes, validation rules, styling properties, and behavior configurations beyond the standard control definition.

Early Intervention Hub import table for importing comprehensive child enrollment, authorization, and service coordination data from the New York State Early Intervention Hub system. This table supports data integration between external EI Hub systems and iCentral, facilitating automated import of child demographics, service authorizations, IFSP information, provider assignments, and enrollment tracking for early intervention services.

Scan upload history tracking maintaining audit trail and metadata for scan upload sessions. This table records upload sessions including user information, agency context, timestamps, processing status, and error checking flags, supporting upload management, audit trails, and quality control for document scanning workflows.

Company-wide system settings managing global configuration settings and feature toggles for the healthcare organization. This configuration table controls system-wide behaviors, feature enablement, and operational parameters to customize system functionality across the entire healthcare organization and enable or disable specific features.

Special conditions and care requirements managing patient-specific special conditions, accommodations, and care requirements for individualized service delivery. This table stores special condition details including names, descriptions, and audit tracking to support personalized care planning, accommodation management, and specialized service delivery for patients with unique needs or circumstances.

Patient evaluation attempt tracking managing evaluation attempt records including dates, comments, and completion status for patient assessments. This table tracks individual evaluation attempts including attempt dates, evaluation references, and detailed comments, supporting evaluation scheduling, attempt tracking, and comprehensive documentation for patient assessment processes.

Support level fee structure defining detailed pricing and user limits for different support tiers. This table manages the fee structure for support levels, including user quotas, maximum limits, monthly charges, and support level associations, supporting flexible pricing models and subscription billing calculations.

Testing table used for development and testing purposes within the healthcare system. This table supports system testing, development activities, and quality assurance processes, providing a safe environment for testing database operations and application functionality without affecting production data.

Borough and district lookup defining geographic boroughs or districts for location-based reporting and service area management. This lookup table supports geographic categorization of patients, providers, and services for regional reporting, compliance tracking, and service area analysis in healthcare delivery.

Authorization monthly amounts tracking monthly financial amounts and rates for service authorizations. This table manages monthly billing rates, calculated totals, and time-based financial tracking for authorizations, supporting monthly billing cycles, rate management, and financial reporting for healthcare services.

Outside source program associations linking external sources to specific program types for service delivery and referral management. This junction table manages the relationship between outside sources and program types, supporting program-specific external relationships, referral networks, and service coordination for healthcare delivery and community partnerships.

Educational program plans - Core table managing educational program plans, classes, and service configurations for healthcare-related educational services. This table defines program types, age ranges, capacity limits, and administrative details for educational programs including special education, early intervention, and therapeutic educational services.

IFSP objectives management - Detailed objectives supporting IFSP outcomes for individualized family service plans. This table stores specific, measurable objectives that support broader outcomes, tracking objective descriptions, creation and modification history, and deletion status to support comprehensive IFSP planning, progress monitoring, and early intervention service delivery.

Regular expression validation patterns managing validation rules and patterns for data input validation across the healthcare system. This table stores regular expression patterns with names, descriptions, and warning messages, supporting data validation, input formatting, and data quality control for forms, fields, and user input throughout the healthcare application.

Void reason definitions managing specific reasons and justifications for voiding claims and transactions. This table defines detailed void reasons within categories, supporting comprehensive audit trails, compliance reporting, and proper documentation of why claims or transactions were cancelled in the healthcare billing system.

Scanned form header information managing metadata and header details for scanned healthcare forms and documents. This table stores essential information about scanned forms including timestamps, user identification, patient references, service details, and processing status, supporting document management workflows, form processing automation, and audit trails for scanned healthcare documentation.

Group configuration options linking user groups to specific configuration settings and options for customized system behavior. This junction table manages group-based access to configuration options, system settings, and customization features, enabling different user groups to have tailored system configurations and feature access based on their organizational roles and requirements.

Objective-goal relationship mapping linking objectives to their associated goals for IFSP management and goal tracking. This junction table manages the many-to-many relationship between objectives and goals, supporting flexible goal structure, objective organization, and comprehensive IFSP planning for early intervention services and family-centered care coordination.

Dynamic data sources managing configurable data sources with custom queries for reporting and analytics. This table defines dynamic data sources with SQL queries to support flexible reporting, custom data views, and configurable analytics for healthcare data analysis and business intelligence.

Form action security controls - Security configuration table managing access permissions for form actions and operations. This table defines action-level security, team-based access controls, and visibility options to ensure appropriate form permissions, maintain data security, and support role-based access control for healthcare documentation workflows.

Early intervention escrow remittance applications managing remittance applications for early intervention escrow payments with claim tracking and status management. This table processes escrow payment applications including claim references, transaction tracking, remittance status, error handling, and audit information to support early intervention escrow payment processing and financial reconciliation.

Scanned early intervention data storing detailed early intervention service information extracted from scanned forms. This table captures early intervention session details including staff identification, patient references, service types, modifiers, dates, and processing status, supporting automated data extraction from scanned early intervention forms and integration with billing and documentation systems.

Agency billing batch submission log tracking electronic billing file submissions and processing for healthcare agencies. This audit table maintains records of billing batch files submitted to payers, including file details, record counts, billing amounts, and processing status for financial reconciliation and submission tracking.

Date field calculation logic defining calculated date fields based on existing date fields with interval logic. This table manages date field calculations including interval types, lengths, and source fields to support dynamic date calculations, reporting periods, and date-based business logic for healthcare analytics.

Payment source identifier management storing various identifier types and transmission IDs for payment sources across different programs. This table manages payment source identifiers including source IDs, ID types, transmitter IDs, and program associations, supporting electronic billing, claims transmission, and payment source identification for healthcare billing and reimbursement processes.

Healthcare provider organizations representing the primary agencies that deliver healthcare services. This table stores the core organizational information for multi-tenant healthcare providers including early intervention programs, special education services, therapy providers, and other healthcare organizations using the system.

Foster care agency directory - Directory of foster care agencies and placement organizations providing services for children in foster care. This table stores agency contact information, addresses, and representative details to support foster care coordination, placement management, and inter-agency communication for child welfare and family services.

Temporary case cleanup processing storing temporary data for case relationship cleanup and data migration processes. This temporary table supports data maintenance operations, case assignment cleanup, and relationship status updates during system maintenance and data quality improvement processes.

Child summary label definitions defining labels and categories for child summary statistics. This lookup table manages the labels and descriptions used in child summary reports, providing standardized categorization for pediatric healthcare statistics and child-focused program reporting.

Training category classification organizing training programs into logical categories for better management and navigation. This table provides organizational structure for training content, enabling categorization by topic, compliance requirement, role, or department to support systematic training program management and staff development planning.

Fee and discount management - Configuration table for managing fees, discounts, and financial adjustments applied to healthcare services. This table stores fee structures, discount rates, payment types, and billing intervals to support flexible pricing models, promotional discounts, and financial assistance programs for healthcare service delivery.

Rate code place of service definitions managing place of service codes and descriptions for healthcare billing and rate determination. This lookup table defines place of service codes with values and descriptions, supporting accurate billing, rate calculations, and service location tracking for healthcare claims processing and reimbursement management.

Referral custom fields table for storing extended referral information and outcome rating scale (ORS) data. This table captures custom fields, assessment scores, outcome measurements, and additional referral-specific data that extends beyond the standard referral information. Used for tracking referral outcomes, assessment results, custom workflow data, and specialized reporting requirements in early intervention and healthcare referral management processes.

Checklist system settings managing global configuration settings for the checklist system. This configuration table controls checklist system behavior, feature toggles, and operational parameters to customize checklist functionality across the healthcare organization and enable or disable specific checklist features.

Service coordination claims managing detailed service coordination session information and billing data. This table stores comprehensive information about service coordination visits including time tracking, contact codes, case notes, outcome documentation, and billing details, supporting service coordination workflows, documentation requirements, and billing processes for early intervention services.

Remittance advice 835 import data storing electronic remittance advice information from insurance payers. This table captures detailed payment and adjustment information from EDI 835 transactions, including claim payments, denials, adjustments, and error codes, supporting automated payment posting and accounts receivable management for healthcare billing.

Alert report configuration defining the relationship between alerts and reports with notification settings. This table manages alert configurations including report associations, notification preferences, scheduling options, and condition definitions for automated alert processing.

Tracking field categories providing organizational structure for tracking fields by functional area or compliance domain. This lookup table enables grouping of related tracking fields for better organization and reporting of business process compliance and quality assurance activities.

Claim processing queue managing the queue of claims waiting for processing or review. This table tracks claims that are checked out for processing, supporting workflow management, claim assignment, and processing coordination to prevent duplicate work and ensure efficient claim processing workflows.

Show/hide display settings managing user interface visibility controls and display preferences for forms and system components. This table stores custom settings for showing or hiding interface elements, supporting personalized user experiences, role-based interface customization, and flexible display configuration for healthcare applications and user workflows.

Aging bucket definitions for accounts receivable aging analysis and financial reporting. This lookup table defines the time intervals (buckets) used for aging outstanding balances, supporting financial analysis, collection management, and accounts receivable reporting by categorizing unpaid amounts by age ranges.

Authentication code management storing temporary authentication codes and access tokens for secure system login and authentication processes. This table manages authentication codes, temporary access tokens, and login verification codes with deletion tracking, supporting secure authentication workflows, two-factor authentication, and temporary access management for healthcare system security.

Patient status definitions providing standardized status classifications for patient management and case tracking. This lookup table defines patient status options including status names, open/closed classifications, and archival settings, supporting consistent patient status management, case workflow control, and reporting for healthcare service delivery and patient care coordination.

Provider electronic signature management storing digital signatures and authentication data for healthcare providers during service documentation and billing processes. This table manages electronic signatures including signature data, timestamps, location tracking, device information, and IP addresses, supporting electronic signature compliance, provider authentication, and audit trails for healthcare documentation and billing verification.

Control template extensions storing additional properties for custom form control templates. This table provides flexible property storage for control templates, enabling extended attributes, validation rules, and configuration options that can be inherited by controls created from the template.

Form categorization system - Classification system for organizing forms, documents, and data collection instruments by functional categories. This table manages form categories, system codes, and display settings to support form organization, user interface navigation, and administrative workflows for healthcare documentation and data collection systems.

Payment information summary tracking applied and unapplied payment amounts for claims and invoices by check log. This table provides financial summary data including applied amounts for claims and invoices, unapplied balances, and update tracking to support payment reconciliation, financial reporting, and payment management for healthcare billing and accounts receivable.

Student enrollment management - Core table managing student enrollments in educational programs and classes with comprehensive tracking of enrollment details, rates, schedules, and administrative information. This table supports enrollment workflows, class management, billing calculations, and educational program administration for healthcare-related educational services.

Form signature configurations managing digital signature requirements and settings for electronic forms with attestation and validation controls. This table defines signature requirements, signature types, attestation content, and validation rules for forms to support electronic signature compliance, document integrity, and regulatory requirements for healthcare documentation.

Remittance advice import table for processing electronic remittance advice (ERA) and explanation of benefits (EOB) data from insurance payers. This table stores comprehensive payment information including claim details, payment amounts, adjustment codes, error tracking, and patient identification to support automated payment posting, claim reconciliation, denial management, and revenue cycle optimization in healthcare billing operations.

Digital signature images storing electronic signature image data for healthcare providers and users. This table manages signature images including user associations and binary image data to support electronic signature workflows, document authentication, and compliance with electronic signature requirements for healthcare documentation and legal validation.

Application layer configuration managing the layered architecture and display settings for healthcare applications. This table controls how different application layers are presented, their visibility, ordering, and client-side behavior for modular application design and user interface customization.

Default report assignments linking applications to their default reports for automated report access. This table manages which reports are set as defaults for specific applications, supporting automated report assignment, application-specific reporting, and default report configuration for healthcare information systems.

Report page configuration managing page definitions, data sources, and output settings for report generation and document processing. This table stores page configurations including page names, descriptions, data source connections, output settings, and criteria strings, supporting flexible report design, page-level customization, and dynamic report generation for healthcare reporting systems.

Billing modifier management storing CPT and billing modifiers used for healthcare service billing and reimbursement. This table manages billing modifiers including modifier codes, descriptions, rates, and billing type associations, supporting accurate billing, reimbursement processing, and compliance with healthcare billing standards and payer requirements.

Checklist completion status tracking the overall completion status of checklists for specific entities. This table manages checklist completion at the entity level, tracking when entire checklists are completed, who completed them, and maintaining completion audit trails for compliance and reporting purposes.

Visit entry configuration settings defining how visit entry forms are displayed, validated, and configured for different claim types and programs. This table controls user interface behavior, field visibility, validation rules, default values, and workflow settings for healthcare service visit documentation and billing entry processes.

Report calculation configuration defining calculation rules and formatting for report columns and summary fields. This configuration table enables customizable calculations, aggregations, and formatting for business intelligence reports and financial summaries across different user groups and applications.

New remittance application processing managing the application of remittance advice to claims using updated processing workflows. This table tracks remittance applications with enhanced processing capabilities including claim associations, transaction links, status tracking, rule error handling, and comprehensive audit trails to support modern remittance processing and automated payment application workflows.

Contact code definitions defining standardized codes for different types of contacts and communication methods. This lookup table manages contact type codes and descriptions to support contact categorization, communication tracking, and standardized contact management for healthcare organizations and patient interactions.

Custom form control templates defining reusable control templates for form creation. This table manages template definitions for form controls that can be reused across multiple forms, providing standardized control configurations, validation rules, and display properties for consistent form design.

External organization directory - Comprehensive registry of external organizations, referral sources, and partner entities that interact with the healthcare system. This table manages contact information, organizational details, and relationship data for schools, medical facilities, government agencies, and other external entities involved in patient care coordination, referrals, and service delivery.

Non-billable rule error tracking managing rule violations and errors for non-billable services and activities. This table tracks rule errors, validation failures, and compliance issues for non-billable activities, supporting quality assurance, rule enforcement, and error resolution for healthcare service management and regulatory compliance.

Configuration discipline assignments linking custom configuration items to specific healthcare disciplines. This junction table manages which configuration options are available for specific disciplines, enabling discipline-specific customization and configuration management for healthcare service delivery and clinical workflows.

Treatment goals and objectives - Core table managing therapeutic goals, treatment objectives, and outcome measures for patient care plans. This table stores detailed goal descriptions, configuration settings, progress tracking, and administrative information to support individualized treatment planning, progress monitoring, and outcome measurement for healthcare service delivery.

Patient pre-referral tracking managing pre-referral activities and communications before formal referral processes. This table tracks pre-referral dates, outside source contacts, and comments for patients in the pre-referral phase, supporting early intervention outreach, referral preparation, and comprehensive tracking of patient engagement before formal service initiation.

Automated job execution history - Audit trail for nightly batch jobs and automated processes including data changes, job execution results, and system maintenance activities. This table tracks field-level changes made by automated processes, job execution timestamps, and company-specific job processing to support system monitoring, troubleshooting, and compliance auditing.

Tab security and access control managing user group permissions for tab access within the application. This table defines which user groups have access to specific tabs and their access rights, supporting role-based security, permission management, and interface customization based on user roles and security requirements.

Patient picture management storing patient photo file names and image references for patient identification and record management. This table manages patient photograph files including file names and patient associations, supporting patient identification, visual record keeping, and enhanced patient care through photo-based patient recognition for healthcare services.

Sub-tab navigation configuration managing sub-tab definitions and navigation structure within the application interface. This table defines sub-tabs, their descriptions, associated files, parent tab relationships, and display ordering, supporting dynamic user interface generation and navigation customization for different user roles and workflows.

Payroll preview calculations providing preview and staging area for payroll calculations before final processing. This table allows users to review, modify, and approve payroll calculations before they are finalized, supporting payroll validation workflows, error correction, and approval processes for staff compensation across different programs and sites.

Filter builder data source configuration - Configuration table managing data source definitions for dynamic filter building and report generation. This table stores filter criteria, data source connections, and hierarchical filter relationships to support flexible reporting, data analysis, and user-defined filtering capabilities across healthcare data management systems.

Early Intervention insurance remittance applications tracking the application of insurance remittance advice to claims and transactions. This table manages the processing of insurance remittance data including claim associations, transaction links, status tracking, rule error handling, and audit trails to support automated remittance processing and payment application for Early Intervention insurance claims.

User session tracking for monitoring user login/logout activities and session management. This audit table tracks user access patterns, session durations, and login history for security monitoring, compliance reporting, and system usage analytics.

Group action permissions linking user groups to specific actions and operations for granular access control. This junction table manages group-based permissions for specific actions, operations, and functions within the healthcare system, supporting fine-grained access control and role-based security by defining which actions each user group can perform across different system modules and workflows.

User phone number management storing multiple phone numbers and contact information for healthcare staff. This table manages various phone numbers for users including work, mobile, home, and emergency contacts, supporting comprehensive contact management and communication workflows for healthcare staff coordination and emergency notifications.

Status program type associations linking patient status definitions to specific program types for program-specific status management. This junction table manages the relationship between patient statuses and program types including status types to support program-specific status tracking, enrollment management, and program-appropriate status workflows for healthcare and early intervention services.

Custom form controls defining individual form controls and input elements for dynamic custom forms. This table manages form controls including text fields, dropdowns, checkboxes, and other input elements with their properties, validation rules, and display characteristics for flexible form creation in healthcare documentation.

Patient contact information managing contact details for family members, guardians, and other important contacts associated with patients. This table stores comprehensive contact information including multiple phone numbers, addresses, and relationship types to support care coordination, emergency contacts, and family communication needs.

Source type definitions managing categories of external data sources and referral sources for healthcare services. This lookup table defines source types including descriptions to support source categorization, referral tracking, and external data integration for healthcare service coordination and patient referral management.

Claim transaction invoice links linking claim transactions to specific invoices for billing organization. This junction table manages the relationship between claim transactions and invoices, supporting invoice compilation, billing organization, and financial reporting for healthcare billing operations.

Activity change audit trail tracking changes to scheduled activities and appointments for compliance and operational monitoring. This specialized audit table maintains detailed change history for calendar events, appointments, and service delivery activities.

Payroll flag option definitions managing available flag options for payroll exception handling and review workflows. This lookup table defines the specific flag options that can be applied to payroll entries, providing standardized flagging categories for payroll processing exceptions, compliance issues, and quality assurance workflows to ensure consistent payroll review and exception management.

Provider assignments to authorizations linking healthcare providers (therapists, specialists) to specific service authorizations. This table manages which providers are assigned to deliver authorized services, their schedules, rates, and provider-specific service parameters.

Tab navigation configuration managing main tab definitions and navigation structure within the application interface. This table defines primary tabs, their descriptions, associated images, and navigation properties, supporting dynamic user interface generation and role-based navigation customization for the healthcare management system.

HTML form content storage managing dynamic HTML content and form submissions for web-based forms and documentation. This table stores HTML content, form submission data, and dynamic form content for web-based data collection, electronic forms, and online documentation workflows, supporting flexible form rendering, content management, and form submission processing for healthcare documentation and data collection systems.

Checklist visit code associations linking checklists to specific visit attendance codes. This table manages which checklists should be triggered or applied based on specific visit attendance codes, enabling automatic checklist activation based on visit types and attendance patterns.

Digital signature initials managing electronic initials and signature metadata for form submissions and document authentication. This table stores signature initials including form submission associations, signature types, creation tracking, and deletion audit trails to support electronic signature workflows, document validation, and compliance with digital signature requirements for healthcare documentation.

Template content storage managing content and data for document templates and report templates used throughout the healthcare system. This table stores template content, formatting, and configuration data that can be used to generate standardized documents, reports, and forms for various business processes and compliance requirements.

Query/report option security management controlling access to specific report options and query parameters based on user security levels. This security table manages access control for report options, query parameters, and securable items, supporting role-based access control for reporting features, query customization, and data access restrictions for healthcare reporting and analytics.

Tagging and categorization system for organizing and categorizing records across the healthcare system. This flexible tagging system enables users to create custom labels, categories, and organizational structures for patients, claims, activities, and other business entities to support workflow management, reporting, and data organization.

Early Intervention Medicaid remittance data storing detailed remittance information from Medicaid for Early Intervention services. This table captures Medicaid-specific remittance data including patient information, authorization numbers, service dates, billing amounts, payment amounts, and claim adjustment reason codes to support Medicaid claims processing, payment reconciliation, and compliance reporting for Early Intervention services.

Payment check tracking managing the receipt and processing of payments from insurance companies, government payers, and other payment sources. This table tracks check deposits, payment amounts, adjustments, and financial reconciliation for accounts receivable management and cash flow tracking.

Claims archive maintaining historical records of claims that have been processed, paid, adjusted, or voided. This audit table preserves claim transaction history for financial reconciliation, compliance reporting, and historical analysis of billing activities and payment processing.

Authorization status definitions defining the various states that service authorizations can have throughout their lifecycle. This lookup table provides standardized status values for authorizations including active, pending, closed, and other workflow states for authorization management and reporting.

Agency program configurations linking agencies to the specific healthcare programs they offer. This table defines which program types (Early Intervention, Special Education, Therapy Services, etc.) each agency is authorized to provide and their associated billing configurations.

Configuration program type assignments linking custom configuration items to specific program types with ordering. This junction table manages which configuration options are available for specific program types, enabling program-specific customization and ordered configuration presentation for healthcare program management.

Deleted claim service rates maintaining archived records of deleted claim service rate calculations for audit and recovery purposes. This audit table preserves deleted payroll and rate calculation records with complete historical data to support financial auditing, error recovery, and compliance tracking for healthcare provider compensation.

Aging calculation results storing computed aging amounts and groupings for accounts receivable analysis. This table contains the calculated aging data organized by time variables, grouping categories, and transaction types to support detailed financial analysis and aging reports.

Claim service rate calculations managing payroll rate calculations and processing for individual service claims. This table stores calculated rates, payroll processing status, and related information for each claim, supporting automated payroll processing, rate management, and financial tracking for service providers across different programs and sites.

Date field definitions defining date fields available for reporting and filtering across the system. This metadata table manages date field definitions with their internal names, display names, types, and source tables to support dynamic date filtering, reporting, and date-based analytics for healthcare data analysis.

User article reading tracking maintaining records of articles and content read by users for training and compliance purposes. This table tracks which users have read specific articles, supporting training completion verification, compliance documentation, and knowledge management for healthcare staff education and professional development.

Claim column definitions defining column metadata and display configurations for claim-related reports and user interfaces. This configuration table manages column identifiers and names for customizable claim views, supporting dynamic report generation and user interface customization for claims management screens.

Report include file configurations managing file inclusions and dependencies for report generation. This table defines which files should be included when generating reports, supporting modular report design, template management, and report composition for complex healthcare reporting requirements.

Early Intervention Medicaid remittance applications tracking the application of Medicaid remittance advice to claims and transactions. This table manages the processing of Medicaid remittance data including claim associations, transaction links, status tracking, rule error handling, and audit trails to support automated Medicaid remittance processing and payment application for Early Intervention Medicaid claims.

Payroll rule error configurations managing business rule applications for payroll processing and validation. This table defines which rule errors apply to payroll processing including rule error references and payroll application flags to support payroll-specific business rule enforcement, validation workflows, and compliance checking for staff compensation and payroll management.

Automation execution history tracking the execution and results of automated workflow processes and business rules. This audit table maintains a complete history of automation rule executions, including logs, outcomes, and submission tracking for compliance monitoring and troubleshooting automated healthcare workflows.

Program custom form associations linking healthcare programs to custom forms and documentation templates for program-specific data collection. This junction table manages the relationship between programs and custom forms including form types, supporting program-specific documentation, custom data collection, and tailored form workflows for different healthcare service programs.

CPT code change history - Audit trail table tracking all changes made to CPT code records for compliance and data integrity purposes. This table maintains a complete history of field-level changes including before/after values, timestamps, and user information to support regulatory compliance, data auditing, and change tracking for medical procedure coding.

Sticky note management providing user interface sticky notes and reminders for healthcare system users. This table manages sticky notes including sub-tab associations, linked records, note descriptions, and creation tracking to support user reminders, workflow notes, and contextual information display for healthcare applications and user productivity enhancement.

Void category classification defining categories for voiding claims and transactions in the healthcare billing system. This table manages different types of void categories that classify why claims or transactions are being voided, supporting proper audit trails, reporting, and compliance with healthcare billing regulations and organizational policies.

Attendance modification history tracking all changes made to attendance records for audit and accountability purposes. This audit table maintains a complete history of attendance modifications including who made changes, when they were made, and what actions were performed for compliance and data integrity.

Digital signature type definitions managing categories and types of electronic signatures available in the healthcare system. This lookup table defines signature types including type names, audit tracking, and lifecycle management to support various signature workflows, authentication methods, and compliance requirements for healthcare documentation and legal validation.

Checklist conditional logic defining conditional rules and actions for dynamic checklist behavior. This table manages conditional logic that determines when checklist items should be shown, hidden, required, or automatically completed based on other checklist responses or system conditions.

User role assignments linking users to their system roles for permission-based access control. This table implements role-based security by associating users with predefined roles that determine their system capabilities and data access permissions.

Medical diagnosis codes managing ICD diagnosis codes and descriptions for medical billing and clinical documentation. This master table defines diagnosis codes with their descriptions to support accurate medical coding, claim justification, and clinical documentation for healthcare services and billing operations.

Service coordination scan archive managing archived scanned service coordination documents and session records. This table stores archived scan data including service dates, times, error codes, scan status, and session duration to support service coordination documentation archival, audit trails, and historical record management for early intervention service coordination activities.

Payment and charge transaction linkage managing associations between payment transactions and charge transactions for comprehensive financial tracking. This table links payment transactions to their corresponding charge transactions, supporting payment allocation, financial reconciliation, audit trails, and comprehensive transaction tracking for healthcare billing and accounts receivable management.

Transaction option configurations managing calculation options and display settings for financial transactions and billing processes. This table defines transaction types, calculation methods, and display controls to support flexible transaction processing, billing calculations, and financial workflow customization for healthcare billing and payment management.

Custom form file sources managing file sources and templates for form generation and document management. This table links payment sources and program types to specific file paths and form templates, enabling automated form generation and document processing workflows for different payers and programs.

Action custom data source associations linking workflow actions to custom data sources for dynamic data integration. This table enables actions to access and process data from custom data sources, supporting flexible workflow automation and business intelligence integration.

Output page configuration managing output page definitions, file names, and output settings for report generation and document processing. This table stores output page configurations including page names, output files, and processing parameters, supporting flexible output management, page-level customization, and document generation for healthcare reporting and documentation systems.

Payroll employee hour tracking managing daily hour records for healthcare staff payroll processing. This table tracks individual employee hours worked by day sequence, supporting detailed time tracking, payroll calculations, and labor cost management for healthcare providers across different service delivery periods and payroll cycles.

User group definitions managing security groups and organizational units for user access control and data filtering. This table defines groups that users can be assigned to, supporting hierarchical security models, data access control, and organizational structure management within the healthcare system.

Activity assignments linking scheduled activities to specific assignments or cases for healthcare service delivery. This table connects calendar activities to patient assignments, enabling tracking of which activities are associated with specific patient cases or service assignments.

Custom objective extensions - Extended table for storing custom fields and additional data for IFSP objectives. This table provides flexible storage for organization-specific objective data, custom tracking fields, and extended attributes to support specialized objective management, progress tracking, and reporting requirements beyond standard objective data.

User identification list storing various identification numbers and credentials for healthcare staff. This table manages multiple ID types for users including license numbers, certification IDs, employee numbers, and other professional identifiers, supporting credential tracking, compliance verification, and professional qualification management.

Extended user-patient relationship information storing additional custom fields and detailed relationship data for provider-patient assignments. This table captures specialized relationship information such as guardian status, payment responsibilities, pickup permissions, and emergency contact designations for comprehensive care coordination.

Claim summary aggregation providing summarized claim data by site, claim type, status, program, and payment source for reporting and analytics. This summary table aggregates claim totals, payment amounts, and counts to support financial reporting, operational dashboards, and billing analysis for healthcare management.

Patient custom configuration associations linking patients to specific custom configuration options for personalized system behavior and data collection. This junction table manages patient-specific configuration settings including display order and configuration associations, supporting personalized patient data collection, custom form behavior, and patient-specific system configurations for healthcare services.

Claim transaction void tracking managing void operations for claim transactions with audit trail and user tracking. This table tracks when transactions are voided, who performed the void, and maintains void references to support financial integrity, audit compliance, and transaction reversal management.

Payment and procedure data managing comprehensive payment information, procedure details, and billing status for healthcare services. This table stores payment processing data including ICN numbers, patient information, service dates, paid amounts, billed amounts, procedure codes, error codes, and claim status to support payment reconciliation, billing analysis, and financial reporting for healthcare operations.

IFSP provider review submissions managing provider review submissions for Individualized Family Service Plans with service type tracking and submission dates. This table tracks when providers submit their reviews for IFSP evaluations, including service types, submission dates, actual dates, and comments to support comprehensive IFSP review processes and provider accountability for early intervention services.

Data import tracking details managing field-level import information and audit trails for data migration and integration operations. This table tracks specific field imports, source table mappings, import timestamps, and user accountability for data import processes, supporting data governance, troubleshooting, and audit requirements for healthcare data management and system integration workflows.

Category application assignments linking payment sources to specific applications for billing and processing workflows. This table manages which applications are used for processing claims and billing for different payment sources, enabling application-specific billing workflows and system integration management.

Claim concatenated CPT codes storing concatenated CPT procedure codes and names for claims with multiple procedures. This denormalized table provides quick access to all CPT codes associated with a claim in concatenated format, supporting efficient reporting and display of multiple procedure codes per claim.

Document header and footer configuration managing formatting, styling, and content settings for document headers and footers across the healthcare system. This table stores font settings, colors, signature configurations, agency branding, and layout options for consistent document presentation, supporting professional document formatting, branding requirements, and signature management for clinical documentation and reports.

Checklist category definitions defining categories for organizing and classifying checklists. This lookup table manages checklist categories such as compliance, quality assurance, onboarding, and clinical workflows to support checklist organization and filtering in the healthcare system.

Communication message properties - User-specific properties and status tracking for iCommunicate messages including read status, delivery tracking, and user-specific message management. This table manages per-user message states, system status updates, and group-based message distribution to support comprehensive internal communication workflows and message lifecycle management.

Primary user accounts for all healthcare providers, administrators, and staff who access the system. This central table manages authentication, authorization, and core user profile information for therapists, service coordinators, administrators, and other healthcare professionals working within the agencies.

Scanned service coordination data storing detailed service coordination information extracted from scanned forms. This table captures service coordination session details including dates, times, claim references, verification status, and processing information, supporting automated data extraction from scanned service coordination forms and integration with billing and documentation systems.

Payroll employee period management defining payroll periods and processing cycles for healthcare staff compensation. This table manages payroll period definitions including payroll dates, week numbers, and processing status, supporting systematic payroll processing, period-based compensation cycles, and payroll administration for healthcare organizations.

Individual service claims representing billable healthcare services delivered to patients. This central billing table manages the complete claim lifecycle from service delivery through payment processing, including claim submission, adjudication, payment tracking, and financial reconciliation for medical billing and insurance processing.

Makeup session configuration managing policies and rules for makeup sessions when regular therapy sessions are missed or cancelled. This table defines makeup session parameters including time limits, maximum allowances, and program-specific rules, supporting flexible makeup session management, compliance with service requirements, and continuity of care for early intervention and therapy services.

Patient custom insurance information table for storing comprehensive insurance details, policy information, periodic review schedules, and secondary insurance coverage. This table supports complex insurance management including policy holder details, employer information, plan types, review tracking, and regulatory compliance for healthcare billing and coverage verification in early intervention and healthcare services.

Control type definitions defining types of user interface controls and form elements. This lookup table manages control type classifications such as textbox, dropdown, checkbox, and other UI control types to support dynamic form generation, user interface customization, and form control management.

Rule error claim procedure associations linking business rules to specific claim procedures with field-level validation and locking controls. This table manages the application of business rules to claim procedures including field names, default values, check order, and application status to support granular rule enforcement and claim procedure validation workflows.

Report application pinning managing which reports are pinned or featured within specific applications. This table controls report visibility and accessibility within different application contexts, supporting personalized dashboards, application-specific reporting, and streamlined report access for healthcare users and administrators.

Support level configuration defining different tiers of technical support and subscription options for system users. This table manages support level definitions, user limits, pricing structures, and feature inclusions, supporting subscription management, billing calculations, and access control based on support tier selections.

Form market associations linking forms to specific markets or geographic regions for market-specific form availability and configuration. This junction table enables forms to be deployed and configured differently across various markets, supporting multi-market healthcare operations with region-specific documentation requirements, regulatory compliance, and localized form workflows for different service areas or geographic markets.

Extended user profile information containing additional custom fields and professional details for healthcare providers. This table stores specialized information such as credentials, certifications, training records, and other professional qualifications required for healthcare service delivery.

Room therapist assignments linking healthcare providers to specific rooms for service delivery and scheduling coordination. This junction table manages the assignment of therapists and providers to specific rooms, supporting facility scheduling, resource allocation, and provider-room associations for healthcare service delivery and therapy session management.

Invoice transactions and adjustments tracking financial transactions, payments, adjustments, and modifications applied to invoices. This table manages transaction history including amounts, transaction types, dates, user tracking, and comments to support comprehensive invoice management, payment processing, and financial audit trails for healthcare billing operations.

Category group assignments linking categories to user groups for access control and workflow management. This table manages which user groups have access to specific categories, enabling role-based access control and group-specific category visibility in the healthcare system.

Application level definitions defining hierarchical levels and access tiers within healthcare applications. This table manages application-specific level structures, supporting role-based access control, workflow hierarchies, and graduated access permissions for different user types and responsibilities.

Custom gap analysis extensions providing additional custom fields and family communication tracking for service gap management. This extension table stores organization-specific gap analysis data including family notification dates, family preferences for provider replacement, and custom tracking fields to support enhanced gap resolution workflows and family communication management for service continuity planning.

Activity assignment type definitions defining different types of activity assignments and their data storage configurations. This table manages the various types of assignments that can be linked to activities, including their database table mappings and SQL query configurations for dynamic data retrieval.

Form definitions - Master table defining available forms for data collection and documentation. This table stores form metadata, categories, actions, and billing associations to support form management, data collection workflows, and billing integration for healthcare documentation and service delivery.

Claim objectives tracking linking claims to specific treatment objectives and outcomes for clinical documentation. This table manages the relationship between service claims and the therapeutic objectives being addressed, supporting outcome tracking, progress monitoring, and evidence-based treatment documentation for healthcare services.

Claim error tracking managing errors and validation issues identified during claim processing and submission. This table tracks claim errors from various sources including clearinghouse rejections, internal validation failures, and business rule violations to support error resolution and claim reprocessing workflows.

Dynamic dropdown values managing configurable dropdown list values for various system components. This table stores dropdown options with types and values to support dynamic user interface elements, configurable lists, and customizable dropdown menus throughout the healthcare system with audit tracking.

Rate type classifications defining different types of rates used in billing and payroll calculations for healthcare services. This lookup table manages rate type categories and descriptions, supporting rate classification, billing configuration, and payroll management for different types of compensation and billing structures in healthcare organizations.

Child summary statistics providing summary counts and statistics for child-related data and reports. This summary table aggregates child information with result counts and URL references to support dashboard displays, quick statistics, and summary reporting for pediatric healthcare services and child-focused programs.

Site program type associations linking agency sites to specific program types for service delivery and organizational management. This junction table manages the relationship between sites and programs including site identifiers and program associations to support multi-site program management, service delivery coordination, and organizational structure for healthcare and early intervention services.

Clearing house error unified view providing a consolidated view of error codes from both iCS2 and local systems. This view combines system-defined and custom error codes to provide comprehensive error code management and resolution guidance for clearing house claim processing and error handling workflows.

Filtered activity category security view providing the highest effective security permissions for each user-category combination. This view resolves conflicts between user-based and group-based permissions by selecting the maximum permission level, ensuring users receive the highest access rights available.

Missing signature claims identification view identifying claims with incomplete or missing required signatures for compliance monitoring. This view analyzes form submissions and signature requirements to identify claims that lack required signatures, supporting quality assurance, compliance monitoring, and signature completion workflows for healthcare documentation and regulatory compliance.

Outside source view providing consolidated information about external referral sources and their program associations. This view combines data from OutsideSource, SourceType, and OutsidesourceInProgramType tables to support referral source reporting, program-specific source tracking, and external source management for healthcare referral and coordination workflows.

Scanned early intervention claim view providing formatted view of scanned early intervention claim forms and documents. This view consolidates scanned form header information with standardized field mappings for early intervention claims, supporting document processing workflows, claim validation, and integration with billing systems for scanned paper forms.

Comprehensive claims with custom data view providing a unified view of claims, patient information, custom claim fields, and detailed claim processing data. This view consolidates data from Patient, ClaimCustom, Claim, and Claim_VW tables to support comprehensive claims reporting, billing analysis, custom documentation requirements, and detailed claim management for healthcare service delivery and reimbursement.

Patient ID types backup view providing backup access to ID type configurations with program associations for system recovery and data integrity. This backup view maintains ID type configurations, program associations, and patient identifier data to support system backup, recovery operations, and data integrity verification for patient identifier management systems.

Billing rates view providing comprehensive rate lookup for healthcare services across different payment sources and service configurations. This business intelligence view combines rate codes with payment source information, enabling accurate billing calculations based on service type, procedure codes, and payer-specific rate structures.

Program types comprehensive information view - Complex view aggregating program type details with associated custom forms, payment sources, billing forms, and billing methods. This view provides complete program configuration information including custom form assignments, payment source relationships, billing form configurations, and billing method logic to support program administration and billing workflow management.

Case date values view providing actual date values for all patients and cases across different date types. This view consolidates date information from multiple tables to provide a unified view of case dates including birth dates, aging out dates, referral dates, and custom dates for comprehensive case date analysis.

Early Intervention Escrow files view - Filtered view of raFiles table showing only active Early Intervention Escrow files for financial management and payment processing. This view provides access to EIEscrow file types with active status, supporting escrow account management, payment tracking, and financial reconciliation for early intervention services requiring escrow fund management.

Patient administration with special conditions view providing comprehensive patient information combined with special condition details. This view joins PatientAdmin_vw with SpecialConditions to support case management workflows that require visibility into both patient demographics and special medical or behavioral conditions affecting service delivery.

Billing patient information view providing consolidated patient data for billing and invoicing purposes. This view combines patient demographics, insurance information, and invoice details to support billing operations, patient account management, and financial reporting for healthcare services.

Covansys CSV remittance files view - Filtered view of raFiles table showing only active Covansys CSV files for specialized payment processing and data exchange. This view provides access to files with empty sender, non-empty receiver, CLH-1 source, and Covansys CSV file type, supporting automated payment posting, claim reconciliation, and specialized billing workflows for Covansys system integration.

Simplified authorization view providing streamlined access to service authorization information with essential lookup values for reporting and operational use. This cross-database view combines authorization data with modifier and service type details from iCS2.dbo.ServiceType and iCS2.dbo.Modifier, plus place of service information from iCS2.dbo.placeservice to support simplified authorization reporting, service planning, and operational dashboards for healthcare service management.

Claim transaction view providing comprehensive tracking of financial transactions associated with healthcare claims. This business intelligence view combines claim transaction details with related information, enabling monitoring of payments, adjustments, voids, and other financial activities for accurate claim reconciliation and financial reporting.

Authorization assignment view providing comprehensive information about therapist assignments to patient authorizations. This view consolidates authorization data with provider assignments, patient relationships, and service parameters to support care coordination, provider scheduling, and authorization management for healthcare service delivery.

User identification list view providing formatted user identification information for reporting and display purposes. This view consolidates user identification data with status information and ID type descriptions, supporting credential verification, compliance reporting, and professional qualification tracking for healthcare staff management.

Patient status program view providing patient status information filtered by program type for program-specific status management. This view consolidates data from PatientStatus and StatusInProgramType tables to support program-specific patient status tracking, enrollment management, and status-based reporting for healthcare program administration and patient care coordination.

User list view providing formatted user information for selection lists and reporting. This view consolidates user data with role-based discipline types, program associations, and status information, supporting user selection interfaces, reporting workflows, and role-based filtering for healthcare staff management and assignment processes.

Comprehensive patient information view providing a unified view of patient demographics, case administration, referral information, and program enrollment details. This view consolidates data from Patient, PatientAdministration, PatientReferral, AgencySite, Borough, ProgramType, CaseCategory, and PatientStatus tables to support comprehensive patient management, case tracking, and program administration for healthcare service delivery.

CHType status view providing filtered status options for CHType application level. This view consolidates status information from Statuses, StatusInLevel, and AppLevels tables specifically for CHType functionality, supporting context-appropriate status selection, workflow management, and application-specific status filtering for healthcare type categorization and management.

Payroll rate rule view providing comprehensive payroll rate rule information for healthcare staff compensation calculations. This view consolidates rate rule data with claim types, programs, rate groups, modifiers, and pay group information to support complex payroll rate determination, compensation calculations, and rate management for healthcare provider payment processing.

Report include file view providing unified access to report file inclusions across multiple systems. This view consolidates include file configurations from different sources, supporting cross-system report generation, file dependency management, and unified report composition for healthcare analytics and business intelligence.

Comprehensive IFSP view combining Individualized Family Service Plan data with review information and type classifications for complete IFSP reporting. This view joins IFSP, IFSPReview, IFSPReviewType, and configuration tables to provide a unified interface for IFSP reporting, review tracking, and status monitoring, supporting comprehensive IFSP management and regulatory compliance reporting for early intervention services.

Patient list view providing comprehensive patient information for case management and reporting. This view consolidates data from Patient, PatientAdministration, and CaseSite tables to support patient listing, case tracking, program management, and patient search functionality for healthcare case management and administrative workflows.

Scanned service coordination claims view providing comprehensive information about scanned service coordination claim documents with signature verification and processing status. This view combines claim data with scanning information, signatures, processing status, and error tracking to support document management, claim validation, and service coordination billing for early intervention and healthcare services.

Patient provider relationship view displaying provider assignments and associations for patients with provider group filtering. This view joins patient-provider relationships with user information to show provider names, IDs, and group associations, supporting provider assignment tracking, patient care coordination, and provider-specific patient management for healthcare services.

Combined output source view providing unified access to output source configurations from multiple databases for comprehensive report management. This view combines output source data from different database instances to provide a complete view of output configurations, supporting cross-database report management and template access for healthcare reporting systems.

Discharge reason program view providing discharge reasons with their associated program types for program-specific discharge tracking. This view combines discharge reasons with program assignments to support program-specific discharge reason management and reporting for healthcare service coordination.

User discipline list view providing formatted user information with discipline types and role assignments for selection lists and reporting. This view consolidates user data with role-based discipline classifications, supporting user selection interfaces, assignment workflows, and role-based filtering for healthcare staff management and service coordination.

Claim program type view providing a consolidated view of claims with their associated claim types, program types, and payment source information. This view combines claim data with program configuration to support claim validation, billing rules enforcement, and program-specific claim processing workflows.

Comprehensive patient identifier view combining patient identifiers with configuration settings and patient demographics for complete ID management. This view joins patient ID lists with configuration settings, ID types, and patient information to provide a unified interface for patient identifier management, supporting comprehensive ID tracking and patient identification workflows.

Remittance file status view providing filtered status options for remittance file processing workflows. This view consolidates status information specifically for remittance file management, supporting file processing status tracking, workflow automation, and status-based processing for healthcare remittance file handling and electronic payment processing.

Enhanced patient information view providing comprehensive patient demographics combined with detailed custom patient information including medical history, birth details, family assessments, and clinical observations. This view consolidates data from Patient and PatientCustom tables to support comprehensive patient care management, clinical documentation, and family-centered service planning for healthcare delivery.

Patient administration comprehensive view providing complete patient management information by joining PatientAdministration, Patient, CaseSite, PatientIDList, PaysourceInCase, PatientInOutsideSource, and PatientReferral tables. This view consolidates demographics, case details, program information, site assignments, payment sources, and referral data to support comprehensive patient management, reporting, and administrative functions for early intervention and healthcare services.

Program type user access view providing user-specific program access and security information for role-based program management. This view consolidates program types with user access permissions, group associations, and security ordering to support user-specific program filtering, access control, and role-based program visibility for healthcare service delivery and administrative functions.

Tracking field management view providing comprehensive tracking field configuration and value management for workflow and compliance monitoring. This business intelligence view combines tracking field definitions with their current values and status, enabling agencies to monitor compliance requirements, workflow milestones, and custom tracking needs across different business processes.

IFSP outcomes view - Filtered view of Outcomes table showing active IFSP outcomes with sequential ordering for display and reporting. This view excludes deleted outcomes and temporary custom form entries, providing a clean dataset for outcome tracking, progress monitoring, and IFSP compliance reporting with automatic row numbering for consistent presentation.

Case category program view providing a consolidated view of case categories and their associated program types. This view combines case category definitions with program type assignments to support case classification, program-specific workflows, and case management reporting across different healthcare programs.

Remittance application status view providing filtered status options for remittance application processing. This view consolidates status information specifically for remittance application workflows, supporting status tracking, application processing, and workflow management for healthcare remittance advice processing and electronic payment notifications.

Case date field options view providing available date field configurations for case-based reporting and filtering. This view consolidates various date types available for cases including birth dates, aging out dates, referral dates, and custom date fields to support flexible case date filtering and reporting.

Payment source unified view - Comprehensive view consolidating all payment sources including patient insurance, institutional payers, clearinghouses, Department of Health sources, and guardians. This view provides a unified interface for payment source management, billing workflows, and financial reporting by combining data from PatientInsurance, PaySource, ClearingHouse, and AccessUser tables with standardized identifiers and contact information.

User information reporting view providing comprehensive user data for reporting and analytics. This view consolidates user profile information, roles, disciplines, contact details, and organizational assignments for administrative reporting, user management dashboards, and compliance reporting.

Agency billing information view providing comprehensive billing configuration data for agencies across different programs. This view consolidates agency billing types, effective dates, program associations, and user assignments to support billing setup, configuration management, and multi-program billing operations for healthcare providers.

Claim status summary view providing aggregated claim data by patient, claim type, and status for reporting and analysis. This analytical view summarizes claim amounts by status categories using cube aggregation to support financial reporting, status tracking, and claim volume analysis for healthcare billing operations.

Payroll employee record view - Comprehensive view combining payroll period information with individual employee payroll records for payroll processing and reporting. This view joins PayrollEmployeePeriod and PayrollEmployeeRecord tables to provide complete payroll data including hours worked, rates, pay types, and calculation details for healthcare provider compensation management.

NYEIS F-Files view - Filtered view of raFiles table showing only New York Early Intervention System F-type files that are active and ready for processing. This view provides access to NYEIS F-files with empty sender/receiver fields and active status, supporting file management, processing workflows, and data exchange with the New York State Early Intervention System for compliance reporting and data submission.

System reports catalog providing a unified view of available reports across the system. This view consolidates report definitions from multiple sources, enabling report management, user access control, and report catalog maintenance for business intelligence and regulatory reporting.

Patient ID types configuration view providing comprehensive ID type settings with program associations and patient data for identifier management. This view combines ID type configurations with program associations and patient identifier values to support ID type management, configuration display, and patient identifier administration across different programs.

Action workflow view providing comprehensive action information for workflow management and business process automation. This cross-database view consolidates action data from the centralized iCS2.dbo.ClaimActionsNew system with billing methods (iCS2.dbo.ActionInBillingMethod), program types, and level configurations (iCS2.dbo.ActionInLevel) to support workflow automation, business rule processing, and action tracking across healthcare service delivery processes. The view bridges local payment source configurations with centralized action management for multi-tenant workflow coordination.

Tuition invoice applied amounts view providing aggregated applied amounts from tuition transactions by check log for financial reporting and reconciliation. This view consolidates transaction amounts from TuitionTransactionChecklog and DaycareTransactions tables to support tuition payment tracking, invoice reconciliation, and financial reporting for daycare and tuition management.

Rate code rules view providing comprehensive rate rule information with claim, program, and payment source details for billing validation and rate determination. This view combines rate code rules with related lookup data to support billing rule validation, rate calculation, and payment processing for healthcare services and early intervention programs.

Rule error unified view providing consolidated access to business rule errors across multiple systems. This view combines rule errors from current and legacy systems, consolidating rule IDs, descriptions, display settings, and instructions to support unified rule management, cross-system rule enforcement, and comprehensive business rule reporting for healthcare compliance and validation.

Streamlined claims view providing essential claim information with lookup values and provider details for efficient claim processing and reporting. This view extends the base Claim table with descriptive names, status information, provider details, and business rule validation results to support claim management workflows and simplified claim data access for healthcare billing operations.

IFSP review schedule view - Enhanced view of IFSP reviews with calculated pre-due and post-submission dates for compliance monitoring. This view extends the IfspReview table with computed date fields to support proactive review scheduling, compliance tracking, and automated notification workflows for individualized family service plan reviews.

Case notes view providing service coordination notes and visit details for case documentation. This view combines claim data with service coordination details to support case note documentation, visit tracking, and service delivery reporting for healthcare providers and case managers.

Attendance code unified view providing a consolidated view of attendance codes from both iCS2 and local systems. This view combines system-defined attendance codes with custom attendance codes, indicating which codes are locked (system-defined) versus editable (custom) for comprehensive attendance code management.

Comprehensive patient administration view providing a unified view of patient demographics, case management, and administrative information. This view consolidates data from Patient, PatientCustom, PatientAdministrationCustom, and PatientAdmin_vw tables to support comprehensive patient reporting, case management dashboards, and administrative analytics for healthcare service delivery.

Claims reporting view providing comprehensive claim information for billing analysis, financial reporting, and operational dashboards. This view consolidates claim data with related information for management reporting, revenue analysis, and billing performance metrics.

Classroom information view providing a consolidated view of active classrooms with site information. This view combines classroom data with site names to support classroom management, reporting, and user interface displays for educational program administration and classroom assignment workflows.

Flexible form configuration view providing comprehensive form field definitions and settings for dynamic form generation. This view consolidates flex form settings with field definitions, stored procedures, validation rules, and control types to support dynamic form creation, field validation, and user interface customization for healthcare data collection workflows.

Agency and outside source unified view providing a consolidated list of agencies and external organizations for referral and coordination purposes. This cross-database view combines internal healthcare agencies from iCS2.dbo.agency with local outside sources (referral sources, partner organizations) to create a unified directory for patient referrals, service coordination, and inter-agency communication. The view uses UNION to merge both data sources with calculated company IDs for unified identification.

Activity category security view providing a unified view of security permissions for activity categories by user and group. This view consolidates user-based and group-based permissions to determine effective access rights for activity categories, supporting security evaluation and permission management.

Comprehensive service coordination claims with custom data view providing a unified view of service coordination claims, patient information, custom claim fields, and detailed claim processing data. This view consolidates data from Patient, ScClaimCustom, scClaim, and Claim_VW tables to support comprehensive service coordination claims reporting, billing analysis, custom documentation requirements, and detailed claim management for early intervention and special education service delivery.

Scanned evaluation claim view providing formatted view of scanned evaluation claim forms and documents. This view consolidates scanned form header information with standardized field mappings for evaluation claims, supporting document processing workflows, evaluation billing, and integration with assessment and billing systems for scanned evaluation forms.

NYEIS remittance files view - Filtered view of raFiles table showing only active files from the New York Early Intervention System (NYEIS) for payment processing and data exchange. This view provides access to files with NYEIS as sender and active status, supporting automated payment posting, claim reconciliation, and compliance reporting for New York State early intervention services.

Declined reason program view providing declined reasons with their associated program types for program-specific decline tracking. This view combines declined reasons with program assignments to support program-specific decline reason management and reporting for healthcare service coordination.

Comprehensive patient insurance information view providing a unified view of patient demographics and detailed insurance coverage information including policy details, coverage types, member identification, and billing information. This view consolidates data from Patient and PatientCustomInsurance tables to support insurance verification, billing processes, and coverage management for healthcare service delivery.

Patient evaluation comprehensive view providing complete information about patient evaluations including assessment tracking, coordinator assignments, evaluator details, and service recommendations. This view consolidates data from PatientEvaluation, Patient, AccessUser, ProcCode, ServiceType, and OutsideSource tables to support evaluation management, progress tracking, compliance monitoring, and reporting for early intervention assessment processes and developmental evaluations.

Comprehensive gap analysis view combining service gap data with custom extensions for complete gap management reporting. This view joins Gaps and GapsCustom tables to provide a unified interface for gap analysis reporting, family communication tracking, and resolution management, supporting comprehensive gap analysis workflows and reporting for service delivery quality assurance and continuity of care management.

Authorization comprehensive view providing complete service authorization information including provider assignments, service details, room allocations, and utilization tracking. This view consolidates data from Authorize, AuthorizeTherapist, AccessUser, Modifier, ServiceType, Rooms, and related tables to support authorization management, provider scheduling, service delivery tracking, and compliance monitoring for early intervention and healthcare services.

Patient administration allergies view providing comprehensive patient information combined with allergy data. This view joins Allergies and PatientAdmin_vw tables to support clinical care coordination, allergy management, safety protocols, and comprehensive patient care planning. Essential for healthcare providers to access complete patient profiles including demographics, case information, and critical allergy information in a single consolidated view for safe and effective treatment delivery.

Streamlined patient information view providing essential patient demographics combined with case administration details, program enrollment, and status information. This view consolidates data from Patient, PatientAdministration, ProgramType, and PatientStatus tables to support simplified patient management, case tracking, and program administration for healthcare service delivery with optimized performance.

Payment application analytics providing financial analysis of payment applications by check and claim type. This view supports accounts receivable reporting, payment analysis, and financial reconciliation by categorizing payment applications across different service types.

Comprehensive patient contact information view providing a unified view of patient demographics and all associated contact persons including family members, guardians, emergency contacts, and healthcare providers. This view consolidates data from Patient, PatientContact, and PatientContactCustom tables to support comprehensive contact management, communication planning, and family engagement for healthcare service delivery.

Payroll rates configuration view providing comprehensive payroll rate management for healthcare providers across different service types, programs, and payment sources. This business intelligence view combines rate definitions with their associated rules, modifiers, and organizational parameters to support accurate payroll processing and financial management.

Service coordinator patient assignments view providing comprehensive information about service coordinator assignments to patients for care coordination and case management. This view consolidates data from AccessUserPatient, AccessUser, and Agency tables to support service coordinator reporting, patient assignment tracking, and care team coordination for early intervention and healthcare services.

User snapshot view providing a historical snapshot of user data for legacy system compatibility and reporting. This view maintains a subset of user information for users with IDs below 1400, supporting legacy system integration, historical data access, and migration processes for older user records.

Case listing view providing comprehensive case information for case management dashboards and reporting. This multi-database view consolidates patient administration data with program types from iCS2.dbo.ProgramType, case coordinators, payment sources, and billing applications from iCentralMarketPlace.dbo.Apps to support case management workflows, status tracking, and operational reporting across healthcare service delivery. The view includes calculated fields for case sequencing and program ID concatenation.

Case rule configuration view providing business rule definitions and values for case management automation. This view consolidates case rules from the iCS2 system with their associated values and configurations to support automated case processing, business rule validation, and case management workflow automation.

Enhanced claims view providing comprehensive claim information with calculated fields, error details, lookup values, and provider information. This view extends the base Claim table with additional business logic, error tracking, status descriptions, and formatted data for reporting and claim management workflows in healthcare billing and reimbursement processes.

Patient administration medical conditions view providing comprehensive patient information combined with medical conditions data. This view joins MedicalConditions and PatientAdmin_vw tables to support clinical care coordination, medical history tracking, condition-based reporting, and comprehensive patient management for early intervention services. Essential for healthcare providers to access complete patient profiles including demographics, case information, and associated medical conditions in a single consolidated view.

Daycare invoice summary view providing aggregated financial information for daycare invoices including totals, payments, and outstanding balances. This analytical view calculates invoice totals, charges, adjustments, payments, and outstanding amounts with status determination to support daycare financial reporting and accounts receivable management.

Agency sites with program information view providing comprehensive site and program data for healthcare service locations. This cross-database view consolidates local agency sites (AgencySite) with their associated program types from iCS2.dbo.ProgramType through SiteInProgramType relationships, supporting site-based reporting, program management, and service delivery coordination across multiple locations with centralized program definitions.

Early Intervention Medicaid files view - Filtered view of raFiles table showing only active Early Intervention Medicaid files for billing and reimbursement processing. This view provides access to EIMedicaid file types with active status, supporting Medicaid claims processing, reimbursement tracking, and compliance reporting for early intervention services covered by Medicaid programs.

Authorization therapist assignment view providing a comprehensive view of therapist assignments to patient authorizations. This business intelligence view combines therapist profile information with their authorization assignments, including scheduling preferences, service delivery parameters, and provider-specific settings for healthcare service coordination.

Configuration options view providing a comprehensive view of custom configuration options with program associations for system configuration management. This view joins custom configurations with program types to display configuration options, descriptions, comments, and program-specific settings, supporting system configuration, option management, and program-specific customization for healthcare applications.

Simplified action workflow view providing streamlined action information for reporting and operational dashboards. This cross-database view consolidates action data from iCS2.dbo.ClaimActionsNew with market and level information (iCS2.dbo.ActionInLevel) from the centralized iCS2 system, offering a simplified interface for action tracking and workflow monitoring without billing method complexity. The view provides market-specific action filtering through local ActionInMarket associations.

Support inquiry management view providing comprehensive support ticket and task management information for customer service, technical support, and issue resolution. This view consolidates data from inquiry, task management, correspondence, and agency tables to support help desk operations, issue tracking, customer communication, and support analytics for healthcare system maintenance and user assistance.

Case assignment workflow view providing comprehensive information about staff assignments to patient cases for workflow management and care coordination. This view consolidates data from AccessUser, AccessUserPatient, UserInRole, and related tables to support case management, staff scheduling, care team coordination, and assignment tracking for healthcare service delivery.

Billing rates view providing comprehensive rate management for healthcare services across different providers, service types, and payment sources. This business intelligence view combines rate configurations with provider and service information, enabling accurate billing calculations and rate management for various healthcare programs and funding sources.

Invoice summary view providing comprehensive invoice information with payment status, outstanding amounts, and program details for billing management. This view combines invoice data with payment information, source details, program information, and claim status to support invoice management, payment tracking, and financial reporting for healthcare billing operations.

Patient custom configuration view - Comprehensive view joining patient-specific custom configurations with their configuration definitions. This view combines PatientInCustomConfig and CustomConfig tables to provide complete configuration details including descriptions, types, and display ordering for patient-specific customizations, form configurations, and personalized healthcare settings.

Authorizations without staff assignments view providing comprehensive information about service authorizations that have not yet been assigned to specific healthcare providers. This cross-database view consolidates authorization data with service details from iCS2.dbo.Modifier and iCS2.dbo.ServiceType, plus room information to support workflow management, staff assignment planning, and service delivery coordination for healthcare authorization management. The view includes calculated fields for remaining units and plan dates from associated IFSP records.

Billing batch log by application view providing comprehensive tracking of billing batch processing across different applications and programs. This business intelligence view combines billing batch information with application-specific details, enabling monitoring of billing file generation, submission status, and financial reconciliation across multiple program types and payment sources.

Rate setting comprehensive view - Complex view providing complete billing rate information by joining BillingRate, PaymentSource, ClaimType, ProgramType, and related tables. This view consolidates rate configurations, payment sources, program details, modifiers, procedures, and service types to support rate management, billing configuration, contract administration, and financial reporting for healthcare service delivery.

Discipline program type view providing a comprehensive view of disciplines with their associated program types, discipline types, and configuration details. This view combines discipline information with program and type assignments to support discipline-based user assignment and service delivery configuration.