You are using an unsupported browser. Please update your browser to the latest version on or before July 31, 2020.
close
You are viewing the article in preview mode. It is not live at the moment.
Welcome to the CAREWare FAQ Page
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

Custom Report Field List

Delete Orphaned Clients
Select 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

Orphaned_Record_List_Query_Updated_10_17_2024.doc Orphaned_Record_Cleanup_Query_Updated_10_17_2024.doc Find_Client_issues_Update_missing_client_custom_records_to_resolve.zip Custom_Field_List_with_descriptions.rtf Custom_Field_Usage_by_Provider_query.txt Business_Tier_stops_Query_to_detect_performance_measure_issue.pdf Merge_Client_Error_Resolution.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