Posts

CONVERT HL7 MESSAGE INTO JSON USING MS .NET C#

Image
This is pretty straight forward and fast way to parse HL7 message into JSON string then can be uses as their needs as in Mobile APP or Web App or Automation services at any part of healthcare.It is fast because, it uses C# 4.5 async and await feature and neat, slick and smooth WPF windows APP. How to Use : 1) Select or Browse HL7 Message file with only .hl7 extension from drive 2) Then just click on Convert button and within a second corresponding output with JSON format will be ready.



to view formatted JSON just go to the JSONLINT and paste Json output and click on validate Json, after json validation results will be like below : { "hl7": { "@xml-space": "preserved", "MSH": { "@fieldDelimiter": "|", "@componentDelimiter": "^", "@repeatDelimiter": "~", "@escapeDelimiter": "\\", "@subcomponentDelimiter": "&", "field": ["CERNER", null, &qu…

SQL - Queries Tuning and Optimization Techniques

In SQL, it is very difficult to write complex SQL queries involving joins across many (at least 3-4) tables and involving several nested conditions because a SQL statement, once it reaches a certain level of complexity, is basically a little program in and of itself.  A database index is a data structure that improves the speed of operations on a database table. Indexes can be created using one or more columns of a database table, providing the basis for both rapid random look ups and efficient access of ordered records. Indexing is incredibly important when working with large tables, however, occasionally smaller tables should be indexed, if they are expected to grow.


Try to consistently indent and don't be afraid to use multiple lines. You don't have to write it all at once. Complex queries can sometimes just be a collection of simple queries. You need to follow some basic guidelines and Take the time to think these through such as-
List all of the columns that are to be return…

Create 270 X12 Eligibility Request Message using C# (MS .NET)

Image
Introduction:


Health Care Eligibility Benefit Inquiry and Response (270/271)



This post helps the provider to determine whether the information source (payer) has a particular subscriber or dependent on file and the health care eligibility and/or benefit information about that subscriber and/or dependent(s). 

The post provides the provider with the information at the time the patient checks in and makes the information available instantaneously, which is not possible through other methods like paper and phone. 

1.Create 270 Request using C#


Sample 270 Eligibility Request:

ISA*00* *00* *ZZ*SUBMITTERID *ZZ*CMS *140831*0734*^*00501*000005014*1*P*|~
GS*HS*SUBMITTERID*CMS*20140831*073411*5014*X*005010X279A1~
ST*270*000000001*005010X279A1~
BHT*0022*13*TRANSA*20140831*073411~
HL*1**20*1~
NM1*PR*2*CMS*****PI*CMS~
HL*2*1*21*1~
NM1*1P*2*IRNAME*****XX*1234567893~
HL*3*2*22*0~
TRN*1*TRACKNUM*ABCDEFGHIJ~
NM1*IL*1*LNAME*FNAME****MI*123456789A~
DMG*D8*19400401~
DTP*291*RD8*20140201-20141031~
EQ*10^14^30^42^45^48^67^A7^…