Design C# program to generate text file compatible with ANSI X12 837 standard for EDI

Closed

Description

Design C# Program With The Following Requirements:

A program to take information from a database with several input tables, map the fields from the input tables to fields in an output table and generate a text file using the names of the fields on the output table combined with the data coming from the input tables.

EDI (Electronic Data Interchange) 837 is a standard created by ANSI called X12 837. This standard is used to transmit medical billing information to insurance carriers. It takes information from a table or multiple tables, such as patients names, last names, address, insurance company, doctor who saw the patient, procedure performed on the patient, dates, etc. All this information is placed in the text file with specific codes and the file is prepared to be sent to the insurance company. Programmer must research the standard to understand it.

There will be 20 Input tables in the input database, named table 1, table 2, ..... thru table 20. Each table will contain 20 columns labeled Field 1, Field 2, ..... thru Field 20. The type of data to be contained by the fields will be String (Text)

There will be an output table in the database called EDI 837 records.

The program will take data from the 20 input tables, map/associate it with a code coming from the ANSI X12 837 Standard and place the data from the input tables into the output tables field accordingly.

Ex.: Table 1 Contains Field 8 which holds information Billing Provider Address

X12 837 Specifications defines 2010AA N3: Street Address Of Billing Provider

Translation table should contain a relation between Table 1 Field 8 and Output Table Field 2010AAN3. When the text file is generated, the text file should have the info 2010AAN3StreetAddressOfBillingProvider.

Output table must contain all variables listed in X12 837 specification. These variables will get filled up depending on the data in the input tables. Mappings should be saved with a name.

Ex. Mapping/Association of Table 1 Field 8 to Output table field 2010AAN3 can be saved and assigned a name. In other cases Table 1 Field 8 can be associated to a different field in Output table and this Mapping/Association table should be saved with a different name.

There will be a text file generated from the results of the Mapping table. This text file will come from the results of running the Translation Table. The resulting record will be saved to the Output table and a text file matching the EDI standard for X12 837 should be generated.

The final result consists of two parts.

Part one.- A program to perform what was described. Program with GUI to used manually by end user

Part two.- A DLL to be used with a C# program. DLL must have the methods and procedures needed to accept information passed on to it from another C# application and output information to the same.

You can view examples of these files in the following documents (use at your own risk)

We are not associated to any of these organizations and cannot distribute their information. Links are mentioned here for illustration only.

The Evolution of the ANSI ASC X12N 837 format from the UB-92 Flat file format Page 8

[url removed, login to view]

Company specific - Not affiliated to this company - For instructional use only -

BCBSNC Companion Guide to X12 5010 Transactions – 837 Institutional Health Care Claims v.1.1 Page 14

[url removed, login to view]

Company specific - Not affiliated to this company - For instructional use only -

837 Professional EDI Specifications & Companion Guide

[url removed, login to view]

Sparcs From New York State Dept Of Health X12-837 INPUT DATA SPECIFICATIONS 2011

[url removed, login to view]

Skills: C# Programming, Software Architecture

See more: x12 insurance, design edi ansi, 837, edi files, generate x12, www programming org com, www bcbsnc com, what is string matching, what is research design, what is instructional design, what is a string in programming, what is a research design, valueoptions, the standard insurance, text to string, string standard, string matching in c, statistics architecture, standard up, standard string, standard programming, standard programmer, standard insurance company, research design methods, requirements specification documents

Project ID: #5044129

8 freelancers are bidding on average $191 for this job

aaravsoft

Hello, I have an 12 years of experience in .net technology with C#.Net, VB.Net, Asp.Net, Kendo UI, Asp.Net MVC with Sql Server, MySql, Oracle and Access. I have also same experience in HTML5, Css, Jquery and Ja More

$150 USD in 4 days
(25 Reviews)
4.8
szymszteinsl

Hi! I am professional C/C++/C#/Java programmer. I can do this project with highest quality. Best Regards, Szymszteinsl

$250 USD in 3 days
(10 Reviews)
4.3
grigiq

Hello, I am skilled enough to complete this task.Please get in touch as soon as possible so I could start working on the project. Regards, Grig

$250 USD in 5 days
(6 Reviews)
3.4
jeffreyferg

Hello! Thank you for considering my bid. My deliverables to you would include: * An application front-end that can be used to launch the X12 837 text file generation, usable in any operating system supporting .NET 4 More

$200 USD in 7 days
(3 Reviews)
3.1
pallavibk

hi I am experienced .net developer. I can work on this project. I have .net 2010 installed on my machine. Which Database are you using to save data? Will you be available for me to understand the EDI 837 standard ? More

$222 USD in 5 days
(6 Reviews)
3.1
amanthakur87

Dear Sir, Good Day!! I think i can make this application for you, if you can provide the required DLLs to me. But i will need to know a more clear picture of the application you are looking to develop. Let's dis More

$147 USD in 3 days
(2 Reviews)
1.4
maheshmeka16

I am senior developer having 9 + years of experience in Microsoft technologies , with skills like C#, Asp.net , Vb.net , Jquery , jquery UI , Javascript , Microsoft SSRS and CSS with HTML

$155 USD in 3 days
(0 Reviews)
0.0
RuchiInfotechLtd

NO need to PAY in ADVANCE. Once COMPLETE the requested task, then PAY TO US. We are a team of 30+ WEB and WINDOWS applications developers and designers with 3+ years of average experience. Expertise to work on ASP. More

$155 USD in 5 days
(0 Reviews)
0.0