SQL Queries - jProg Support

We are currently loading content. Thank you for your patience as we transition our content to this page.

Home > Documents > SQL Queries

SQL Queries

Kevin Ricciardo

May 25, 2023

219

Advanced Indexing Options

Cleaning Holding Tanks

Create Database

Delete Orphaned Clients

Error adding labs in 172

Financial Report Totals correction query

HL7 Index out of range error HL7PIDSegment is null

Import Error Resolution to Allow Nulls for Data Source Columns

Maintenance Query

Missing Client Custom Query

Missing HL7 Mappings Query

Orphaned Record Cleanup Query for services

Resolve error for merge client

Unmapped HL7 Providers Fix

Feedback

0 out of 0 found this helpful

Need additional information

Hard to understand

Inaccurate/irrelevant content

Missing/broken link

Attachments

Import_Error_Resolution_to_Allow_Nulls_for_Data_Source_Columns.pdf

Financial_Report_Totals_correction_query.pdf

Delete_Orphaned_Clients_3_20_23.zip

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

Missing_Client_Custom_Query.pdf

Maintenace_Query.pdf

Advanced_Indexing_Options.pdf