Tables

Market-specific items and services that define billable items and services available in specific markets or geographic regions, enabling market-based pricing and service offerings.

Object exclusion rules that define which database objects, fields, or data elements should be excluded from specific operations, reports, or data processing workflows.

Program and service type definitions that classify the different types of healthcare programs and services offered by agencies. This is the CENTRAL AUTHORITY table for program type definitions referenced across all client databases. Client databases like Sandbox reference this table through views such as agencySites_vw, CaseListing_VW, and PatientAdmin_vw to ensure consistent program classifications and billing rules across the entire multi-tenant healthcare system. Each program type defines specific billing rules, service codes, and regulatory requirements.

Confirmation type definitions that define the various types of confirmations, acknowledgments, and approvals required throughout the system for compliance and audit purposes.

Agency flat rate billing that defines fixed-rate billing arrangements for agencies that use flat-fee pricing instead of per-transaction or usage-based billing.

Adjustment reason codes that define the standardized codes and descriptions used for claim adjustments, denials, and payment modifications in medical billing processes.

Attendance tracking codes that define standardized codes for tracking client attendance, participation, and engagement in services and sessions.

Agency sub-tab configurations that define which user interface sub-tabs and navigation elements are available to specific agencies.

Market item type classifications that categorize market-specific items and services for organizational and billing purposes within different geographic markets.

Application add-on associations that define which add-on modules are available for specific applications, enabling modular functionality expansion.

Combo box data source definitions that specify the data sources and queries used to populate dropdown lists and combo boxes throughout the user interface.

Claim action definitions that define the various actions that can be performed on claims during processing, workflow management, and status updates.

Search category definitions that organize search functionality into categories, enabling categorized search capabilities and improved search result organization.

Formatted report templates that define the layout, styling, and presentation format for system reports, enabling professional document generation and customized report appearance.

Patient status codes that define the various status classifications for patients in the system, such as active, inactive, or discharged.

Data source criteria definitions that specify the filtering and selection criteria applied to data sources for reports and data retrieval operations.

Form signature tracking that manages electronic signatures on forms, including signature metadata, authentication details, and legal compliance information.

CPSE portal county codes that define the county codes and identifiers used for CPSE (Committee on Preschool Special Education) portal integration and reporting.

Export operation history that tracks all data export operations, including timestamps, user information, and export results for audit and monitoring purposes.

Payment sources and insurance payers that define the various insurance companies, government programs, and other payment sources that reimburse for healthcare services.

Procedure code packages that group related procedure codes together for billing efficiency and standardized service delivery packages.

User status codes that define the various status classifications for user accounts, such as active, inactive, suspended, or pending activation.

Scan form definitions that define the structure, fields, and processing rules for document scanning and optical character recognition (OCR) workflows.

Agreement type linkages that define relationships and dependencies between different agreement types, enabling complex contract structures and upgrade paths.

Field definitions and metadata that define the structure, properties, and validation rules for data fields used throughout forms, reports, and data collection interfaces.

Internal field definitions that define system-internal fields and metadata used for application processing, workflow management, and internal data operations.

Kinney service type mapping that maps standard service types to Kinney program-specific service classifications for specialized billing and reporting requirements.

Billing modifiers that define the modifier codes used in medical billing to provide additional information about services, procedures, or circumstances affecting billing and reimbursement. This is the CENTRAL AUTHORITY table for billing modifier definitions referenced across all client databases. Client databases like Sandbox reference this table through authorization views (Authorize_vw, AuthorizationWoutAssignments_vw, Authorize_Simple_vw) to ensure consistent modifier usage and billing compliance across the entire multi-tenant healthcare system.

Custom filter definitions that allow users to create and save personalized filter criteria for reports, searches, and data views to improve workflow efficiency.

Category-type associations that link categories to category types, enabling flexible categorization schemes and multi-dimensional classification.

Agency application assignments that track which application modules are enabled for specific agencies. This junction table manages the many-to-many relationship between agencies and available applications.

Rate code lookup table that provides standardized rate codes and their descriptions for billing and reimbursement rate management across different payers and programs.

Custom logic settings that store user-defined business logic and custom rules for specific agencies or use cases, enabling flexible system behavior.

Report category classifications that organize reports into logical categories for navigation, access control, and report management purposes.

Action-billing method associations that link system actions to specific billing methods and forms, enabling workflow-driven billing processes.

Scan form name definitions that define the names and identifiers for various scanning forms and document templates used in document processing workflows.

ICD-9 diagnostic codes that store the International Classification of Diseases, 9th Revision codes used for medical diagnosis coding and billing in healthcare claims.

Application layer definitions that define the modular layers and components of the application architecture, enabling flexible system configuration and feature management.

Discipline type definitions that classify the different healthcare disciplines and professional specialties available within the system for service delivery and provider management.

Database properties - System table that stores metadata and properties about database objects, used for database management and version control.

Billable items and services that define the products, services, and charges that can be billed to agencies, including rates, descriptions, and billing categories.

Field-stored procedure associations that link data fields to stored procedures, enabling dynamic field processing and database operations.

Agency report assignments that define which reports are available to specific agencies based on their service agreements and access permissions.

Export data source definitions that define the data sources and connection parameters available for data export operations and external system integration.

User access logging and session tracking that records all user login attempts, session details, and authentication events for security auditing and system monitoring purposes.

Billing method program type associations that define which billing methods are available for specific program types, enabling program-specific billing configurations.

Week reference table that provides a calendar of weeks with associated metadata for scheduling, reporting, and time-based calculations and analysis.

User and system preferences that store customizable settings and preferences for users and system-wide configurations to personalize the user experience.

Stored procedure include file associations that link stored procedures to include files and dependencies for proper execution and deployment management.

User identifier types that define the different types of user identifiers and authentication methods available in the system for user management and security.

Sub-tab definitions that define the secondary navigation tabs and interface components available within the main application tabs for organized user interface structure.

Ticket form settings that configure the appearance, fields, and behavior of support ticket forms used for customer service and technical support workflows.

Agency bulletin board system credentials that store the login credentials and connection information for agencies to access electronic billing clearinghouses and data exchange systems.

Legal stamp and approval tracking that manages legal approvals, stamps, and certification marks applied to documents and forms for compliance and authentication purposes.

Data source output definitions that specify the fields, columns, and data elements returned by data sources for reports and data displays.

Service type definitions that classify the different types of healthcare services and interventions provided by agencies to clients. This is the CENTRAL AUTHORITY table for service type definitions referenced across all client databases. Client databases like Sandbox reference this table through views such as Authorize_Simple_vw, AuthorizationWoutAssignments_vw, and Authorize_vw to ensure consistent service type definitions and billing codes across the entire multi-tenant system.

Template report data source associations that link report templates to their data sources for dynamic report generation and data binding.

Claim type billing rates that define the specific billing rates and fee schedules associated with different claim types for accurate financial processing.

New York Early Intervention rates that store the official reimbursement rates for early intervention services in New York State, including rate schedules and effective dates.

Scan form billing type associations that link scanning forms to specific billing types, enabling billing-type-specific document processing workflows.

Procedure definitions that define the medical procedures and interventions available in the system, including their parameters and billing information.

Rule error market associations that link rule errors to specific markets or geographic regions, enabling market-specific error tracking and compliance monitoring.

Standard system settings that store default configuration values and standard parameters used across the system for consistent behavior and setup.

Output format definitions that specify the various formats available for data export, report generation, and document output, including file types and formatting options.

Procedure code claim type associations that define which procedure codes are valid for specific claim types, ensuring proper coding for different service categories.

Action-agency associations that define which system actions or workflows are available to specific agencies based on their service agreements and system configurations.

Client case rule assignments that apply specific business rules to individual client cases for customized validation and processing.

Category definitions that provide hierarchical classification and organization of various system entities for improved data management and reporting.

Report category associations that link reports to their categories, enabling categorized report navigation and access control based on category permissions.

Phone type classifications that define different types of phone numbers (home, work, mobile, etc.) for contact management and communication purposes.

Billing rates and fee schedules that define the monetary rates charged for different services, procedures, and billing methods across various payers and program types.

Invoice line items that represent individual billable items on agency invoices, including quantities, rates, and billing details for service charges and fees.

Stored procedure definitions that catalog the database stored procedures available for system operations, reporting, and data processing workflows.

Discipline type program type associations that define which healthcare disciplines are available within specific program types for service planning and delivery.

System roles definition that defines user roles and their associated permissions for role-based access control throughout the system.

Case rule values that store the specific values, parameters, and constants used by business rules for validation and calculation purposes.

Form design templates that define the visual layout, field arrangement, and user interface design for electronic forms used in data collection and documentation.

Kinney ICD-10 mapping that provides mapping between ICD-10 diagnostic codes and Kinney program-specific codes for specialized early intervention billing and reporting.

Clearinghouse error tracking that logs and tracks errors, rejections, and issues encountered during electronic data interchange with clearinghouses.

Identifier mapping table that maintains cross-references and mappings between different identifier systems for data integration and external system compatibility.

Active user session tracking that maintains a real-time list of currently active users and their session information for system monitoring and concurrent user management.

Client identifier mappings that store alternative client identifiers and cross-references for data integration and external system compatibility.

Payment source type classifications that categorize different types of payment sources and insurance types for billing and reimbursement purposes.

Application modules and system features that define the functional capabilities available to agencies. Each app represents a distinct module or feature set that can be enabled for specific agencies based on their service agreements and business needs.

Export data configuration settings that store user-defined settings and parameters for data export operations, enabling customized data extraction and reporting workflows.

Claim type program type associations that define which claim types are available for specific program types, enabling program-specific claim processing rules.

Billing status tracking that monitors the processing status of billing cycles, invoice generation, and payment collection for agency billing management.

CPT code definitions that store Current Procedural Terminology codes used for medical billing and procedure identification in healthcare claims.

Automated job settings that store configuration parameters and settings for automated jobs, enabling customizable job behavior and execution parameters.

Main tab definitions that define the primary navigation tabs and major interface sections of the application for organizing functionality and user workflows.

Clearinghouse definitions that store information about electronic billing clearinghouses and data exchange partners used for claims submission and processing.

Place of service codes that define the locations where healthcare services are provided, using standard place of service codes for billing and reporting.

Claim type classifications that define the different categories of medical claims and their associated billing rules, procedure codes, and reimbursement methods within each program type.

Program add-on associations that define which add-on modules and features are available for specific program types, enabling program-specific functionality.

User field formatting rules that define how user-defined fields should be formatted, validated, and displayed throughout the user interface.

Invoice user level tracking that tracks billing for users at different access levels within agencies, enabling tiered pricing based on user roles and permissions.

Account management assignments that define which employees are responsible for managing specific agencies and their billing relationships. This table establishes the business relationship between internal staff and client agencies.

Custom query definitions that store user-defined SQL queries and data retrieval logic for specialized reporting and data analysis needs.

Agency program type assignments that define which healthcare program types are available to specific agencies based on their service agreements and regulatory approvals.

Agency category type assignments that associate agencies with specific category types for business classification, reporting, and operational grouping purposes.

Agency add-on assignments that track which add-on modules are enabled for specific agencies. This junction table manages the many-to-many relationship between agencies and available add-ons.

Agency payment information that stores credit card, bank account, and other payment method details for agencies to facilitate automated billing and payment processing.

Billing methods and invoice processing that define how agencies are billed for system usage and services. Each billing method specifies the calculation approach, rates, and processing rules for generating invoices.

ICD-9 dictionary lookup that provides a comprehensive dictionary of ICD-9 codes with detailed descriptions and cross-references for medical coding and billing purposes.

TheraWow pre-signup tracking that manages pre-registration and signup tracking for the TheraWow application module, including lead management and conversion tracking.

Patient identifier types that define the different types of patient identifiers used in the system, such as SSN, Medicaid ID, or internal patient numbers.

Report include file associations that link reports to external files, templates, or resources required for report generation and formatting.

Agency confirmation tracking that records when agencies have confirmed or acknowledged specific system requirements, agreements, or compliance items.

User field access levels that define the access levels and permissions required to view or modify user-defined fields based on user roles and security requirements.

Remittance status codes that track the processing status of remittance advice (RA) files and electronic payment notifications from insurance payers.

Client layer configurations that define which application layers and interface components are available to specific clients based on their service agreements.

Report definitions and templates that provide structured data analysis, compliance reporting, and business intelligence capabilities for agencies and system administrators.

Insurance policy type classifications that define different types of insurance policies and coverage types for billing and eligibility verification purposes.

Service type claim type associations that define which service types are available for specific claim types, enabling proper billing and service documentation.

Email template definitions that store standardized email templates for automated communications, notifications, and correspondence with agencies and users.

Report group listing associations that define which reports belong to which report groups, enabling flexible report organization and categorization.

Digital signature type definitions that classify the different types of electronic signatures and approval methods used throughout the system for compliance and authentication.

Application layer associations that define the hierarchical structure and layered architecture of applications, enabling modular design and component organization.

Action-data source associations that connect system actions to specific data sources, enabling data-driven workflows and automated processes.

Search and filter criteria definitions that define reusable criteria and filter conditions for reports, searches, and data queries throughout the system.

Tagging and categorization system that provides flexible labeling and organization capabilities across the system. Tags enable users to categorize, filter, and organize various entities for improved data management and reporting.

System configuration options that store global system settings, preferences, and configuration parameters that control application behavior and features.

Action-stored procedure associations that link system actions to database stored procedures, enabling automated database operations as part of workflows.

Scan form include file links that associate scanning forms with include files and external resources required for form processing and validation.

Service agreements and contracts that define the terms, conditions, and service levels between iCentral and healthcare provider agencies. Agreements specify pricing, features, support levels, and compliance requirements.

Category type definitions that define different types of categorization schemes and classification systems used throughout the application.

Service type classifications that provide additional categorization and classification of service types for specialized reporting and billing purposes.

Modifier claim type associations that define which billing modifiers are applicable to specific claim types, ensuring proper modifier usage in medical billing.

Output definitions that define the various outputs, reports, and data exports available in the system, including their parameters and generation rules.

Place of service program type associations that define which places of service are valid for specific program types, ensuring appropriate service location coding.

SQL query builder components that store reusable SQL query parts and components for dynamic report generation and data retrieval operations.

Scan include files that define external files, templates, and resources used in document scanning and processing workflows.

Employer status lookup that defines the various employment status codes and classifications used for tracking provider and staff employment information.

Reference lookup table that provides cross-references and lookup values for various system codes, identifiers, and classification systems used throughout the application.

Prescription status codes that track the status of medical prescriptions and treatment orders within the healthcare system.

Template type definitions that classify different types of templates used throughout the system for forms, reports, and document generation.

Agency form assignments that track which forms are available or required for specific agencies based on their program types and service agreements.

Date reference table that provides a comprehensive calendar of dates with associated metadata for reporting, scheduling, and date-based calculations.

Automated job definitions that define scheduled tasks, background processes, and automated workflows that run within the system for maintenance and data processing.

Report group definitions that organize related reports into groups for easier navigation and management within the reporting system.

Comprehensive client data that aggregates and stores consolidated client information from multiple sources for reporting and data analysis.

Relationship definitions that define the various types of relationships between individuals (parent, guardian, spouse, etc.) for contact and demographic management.

Package detail specifications that define the components, features, and services included in different service packages offered to agencies.

Sliding scale billing buckets that define income-based fee structures and payment tiers for agencies that use sliding scale billing based on client financial circumstances.

Client average metrics that store calculated average values and statistical data across all clients for reporting and analytics purposes.

Criteria inclusion rules that define which criteria are included or applied in specific contexts, enabling flexible and dynamic filtering capabilities.

Scan status codes that track the processing status of scanned documents through various stages of the document processing workflow.

ISC business rules that define specialized business rules and validation logic for ISC (Integrated Service Coordination) processes and workflows.

Kinney service delivery modes that define the different modes of service delivery available in the Kinney early intervention program, such as individual, group, or consultation services.

835 EDI adjustment reasons that provide specific adjustment reason codes and descriptions used in electronic remittance advice (835) transactions from insurance payers.

State and province lookup that provides a comprehensive list of states, provinces, and geographic regions for address validation and geographic reporting.

Enhanced claim actions that provide an updated framework for claim processing actions with improved workflow capabilities and extended functionality.

Agency billing type assignments that track the billing methods and types assigned to agencies over time, including effective dates for billing method changes.

Service order management that tracks service orders, authorizations, and service delivery requests within the healthcare system for proper service coordination and billing.

Support level type definitions that classify the different levels of technical support and service levels available to agencies based on their agreements.

Medical claims and billing transactions that represent individual service claims submitted for reimbursement. Each claim contains detailed information about services provided, billing codes, patient information, and processing status for insurance reimbursement.

Case business rules that define automated business logic and validation rules for case management, ensuring data integrity and compliance with business processes.

Rule error claim program associations that link rule errors to specific claim programs, enabling program-specific error tracking and resolution.

Rule error tracking that logs and tracks business rule violations, validation errors, and compliance issues encountered during data processing and workflow execution.

Marital status lookup that provides standardized marital status codes and descriptions for client demographic information and reporting purposes.

Legal content and documentation that stores legal text, terms of service, privacy policies, and compliance documentation required for system operation and regulatory compliance.

Kinney early intervention titles that define the professional titles and credentials used in the Kinney early intervention program for provider classification and billing purposes.

Action-level associations that define which system actions are available at different organizational or access levels within agencies.

Data source definitions that define the various data sources, databases, and data connections used throughout the system for reporting and data integration.

Dynamic data source definitions that provide flexible, configurable data sources for reports and queries that can be modified without code changes.

System diagrams - SQL Server system table that stores database diagrams and visual representations of database schema and relationships.

Agency billing transmission log that tracks all electronic billing file transmissions between agencies and clearinghouses, including file details, transmission status, and billing amounts.

Claim type payment rates that define the payment rates and reimbursement amounts for different claim types across various payers and contracts.

Dashboard file configurations that define the files, documents, and resources displayed on user dashboards for quick access and workflow efficiency.

ID type program type associations that define which identifier types are required or available for specific program types, enabling program-specific identification requirements.

Billing type field definitions that specify which data fields are required or available for each billing type, enabling flexible billing data collection.

Status type definitions that define the various status codes and classifications used throughout the system for tracking entity states and workflow progress.

Electronic forms and templates that define the structure, fields, and workflows for data collection, documentation, and reporting within the healthcare system.

Primary healthcare provider organizations that use the iCentral system. This is the CENTRAL AUTHORITY table for agency information referenced across all client databases (Sandbox, iCentralMarketPlace, etc.). Each agency represents a distinct organization (clinic, therapy center, school district, etc.) that provides services to clients and submits claims for reimbursement. Agencies have their own configurations, billing settings, user access controls, and reporting requirements. This table serves as the master agency directory for the entire multi-tenant system.

Form include file associations that link forms to external files, templates, or resources required for form processing and display.

Output source definitions that define the data sources and queries used to generate outputs, reports, and exports, enabling flexible output generation.

System groups definition that defines user groups and access control groups for organizing users and managing permissions across the system.

Form program type associations that define which forms are available for specific program types, enabling program-specific documentation and data collection requirements.

Agency scan form configurations that define which scanning forms and templates are available to specific agencies for document processing and data capture.

Billing type definitions that classify different approaches to billing and define the rules and parameters for each billing methodology.

Dropdown value definitions that store the predefined values and options available in dropdown lists and selection controls throughout the user interface.

Procedure codes that store medical procedure codes (CPT, HCPCS) used for billing and documentation of healthcare services and interventions.

System add-on modules and features that extend the core functionality of the iCentral platform. Add-ons provide specialized capabilities that can be enabled for specific agencies based on their service agreements and business needs.

Path lookup table that stores file paths, directory locations, and resource paths used throughout the system for file management and resource location.

Case rule value associations that link business rules to specific values or parameters, enabling dynamic rule configuration and value-based rule execution.

RA update information view - Operational view providing remittance advice update information and connection details for automated RA processing workflows.

Service type view - Business intelligence view that combines service type information with claim type and program associations for reporting and selection purposes.

Weekly BBS information view - Operational view providing weekly billing transmission schedules and connection information for automated clearinghouse processes.

Claim type program type view - Business intelligence view that shows the relationships between claim types and program types with market classifications for reporting and analysis.

Agency dashboard metrics view - Comprehensive dashboard view providing key performance indicators, signup URLs, and operational metrics for agency management and business intelligence.

Invoice item view - Business intelligence view that combines invoice line items with agency and item details for comprehensive billing reporting and invoice generation.

BBS download information view - Operational view providing connection details and credentials for automated downloading of billing data from clearinghouse bulletin board systems.

Active agencies view - Business intelligence view providing a filtered list of currently active healthcare provider agencies for operational reporting and system management.

Procedures view - Business intelligence view that combines procedure information with associated codes and program types for reporting and selection purposes.

Agency script view - Operational view providing agency categories for automated script execution and system maintenance processes.

Agency RA import view - Operational view that provides a filtered list of agency categories for remittance advice (RA) import processes and automated billing workflows.

Enhanced invoice item view - Extended business intelligence view that includes additional agency details, billing addresses, and tax information for comprehensive invoice processing.