Quote Originally Posted by OBP
Mike, what are the names that you will want to use and most important of all which ones contain the DX data?
What about Admin DX ?
Here are the column headings so far:
1. Patient Name, Account No, Birth Date, SS #, Address1, Address 2, City, ST, Zip, Service, Diagnosis (this would be the only DX field), Charges

2. patno, pt name, adm date, tot chg amt, fc, hosp svc, acct bal, clasf icda code (this would be the only dx field), usr text, ins1 plan

3. (this is used in the sample database i attached earlier)

it is hard to predict what other column headings will come. It will be more common that the files will contain more than 1 dx field. I was trying to write a standard that i could map fields to but i never really completed cause i wanted to first focus on logic and making sure the application would function properly, then i was going to focus on summarizing and exporting and finally making the import work in a universal so that it didnt matter what the original file contained in terms of column headings.