You are using an unsupported browser. Please update your browser to the latest version on or before July 31, 2020.
close
Welcome to the CAREWare FAQ Page
announcement close button
Home > Documents > SQL Queries
SQL Queries
print icon

Advanced Indexing Options

Business Tier service stops due to Performance Measure issue

Cleaning Holding Tanks

Create Database

Custom Field Usage by Provider

Delete Orphaned Clients

Delete Duplicate Tests

Error adding labs in 172

Financial Report Totals correction query

Find Client Issues missing client custom records

HL7 Index out of range error HL7PIDSegment is null

Import Error Resolution to Allow Nulls for Data Source Columns

Maintenance Query

Merge Client Error Resolution

Missing HL7 Mappings Query

Orphaned Record Cleanup Query for services

Unmapped HL7 Providers Fix

Feedback
0 out of 0 found this helpful

Attachments

Custom_Field_Usage_by_Provider_query.txt Business_Tier_stops_Query_to_detect_performance_measure_issue.pdf Orphaned_Record_Cleanup_Query_Updated_2024222.pdf Merge_Client_Error_Resolution.pdf Find_Client_issues_Update_missing_client_custom_records_to_resolve.pdf Delete_Duplicate_Tests_2023_8_14.pdf Delete_Duplicate_Tests_2023_8_14.pdf Import_Error_Resolution_to_Allow_Nulls_for_Data_Source_Columns.pdf Financial_Report_Totals_correction_query.pdf Hl7_Index_out_of_Range_Error_HL7PIDSegment_null_query.zip HL7DuplicateImportSettingFix.zip HL7_missing_mappings.zip Orphaned_Record_Cleanup_for_Services.pdf Qualitative_test_result_code_table_query_to_fix_error_adding_labs_screenings_screening_labs_annual_screenings.pdf Resolve_error_for_merge_client.pdf Cleaning_Holding_Tanks.pdf Create_Database.pdf Maintenace_Query.pdf Advanced_Indexing_Options.pdf
scroll to top icon