Creating a mapping file using the viewing function

85 views

Skip to first unread message

Com1 Software

unread,

Apr 1, 2010, 10:12:06 AM4/1/10

to X12 Parser

To create a basic mapping file for the parser.

1 ) Load the file you wish to map for using the the View function of
the Parser.

2) Once the file has been loaded you should see an Export Button on
the screen.

3) When you click on the Export Button you will be asked to select a
format. You
can select any one of the formats.

4) An Export Data Screen will be displayed. You can add and delete
fields from the
map here. When you click on the SAVE button a map file will be
created for the
type of file you have loaded.

C1837I.XML for Institutional
C1837P.XML for Professional
C1837D.XML for Dental
C1835.XML for Remittance

You can use notepad to modify the XML mapping file with what ever
fields you need
Here is a list of the available fields.

http://com1software.com/c1d0f252.htm#0613
http://com1software.com/c1d0f252.htm#0612

Here is a example of the contents of a C1837I.XML mapping file:

<?xml version="1.0" encoding="ISO-8859-1"?>
<CONFIGURATION>
<FIELD>SUBFNAME</FIELD>
<FIELD>SUBLNAME</FIELD>
<FIELD>SUBMI</FIELD>
<FIELD>SUBNAMEPREFIX</FIELD>
<FIELD>SUBNAMESUFIX</FIELD>
<FIELD>SUBIDCODE</FIELD>
<FIELD>SUBADDR1</FIELD>
<FIELD>SUBADDR2</FIELD>
<FIELD>SUBCITY</FIELD>
<FIELD>SUBST</FIELD>
<FIELD>SUBZIP</FIELD>
<FIELD>SUBSEX</FIELD>
<FIELD>SUBMSTATUS</FIELD>
<FIELD>SUBDOB</FIELD>
<FIELD>SUBREL</FIELD>
<FIELD>SUBORDER</FIELD>
<FIELD>PAYERNAME</FIELD>
<FIELD>PAYERADDR1</FIELD>
<FIELD>PAYERADDR2</FIELD>
<FIELD>PAYERCITY</FIELD>
<FIELD>PAYERST</FIELD>
<FIELD>PAYERZIP</FIELD>
<FIELD>PATFNAME</FIELD>
<FIELD>PATLNAME</FIELD>
<FIELD>PATMI</FIELD>
<FIELD>PATNAMEPREFIX</FIELD>
<FIELD>PATNAMESUFIX</FIELD>
<FIELD>PATADDR1</FIELD>
<FIELD>PATADDR2</FIELD>
<FIELD>PATCITY</FIELD>
<FIELD>PATST</FIELD>
<FIELD>PATZIP</FIELD>
<FIELD>PATSEX</FIELD>
<FIELD>PATMSTAT</FIELD>
<FIELD>PATDOB</FIELD>
<FIELD>PATREL</FIELD>
<FIELD>CLAIMID</FIELD>
<FIELD>CLAIMAMT</FIELD>
<FIELD>ADMISSIONDATETIME</FIELD>
<FIELD>ADMISSIONTYPE</FIELD>
<FIELD>ADMISSIONSOURCE</FIELD>
<FIELD>PATIENTSTATUS</FIELD>
<FIELD>DISCHARGEHOUR</FIELD>
<FIELD>STATEMENTDATE</FIELD>
<FIELD>MEDICALRECORDNUMBER</FIELD>
<FIELD>FACILITYCODEVALUE</FIELD>
<FIELD>FREQUENCYTYPECODE</FIELD>
<FIELD>PRINCIPALDX</FIELD>
<FIELD>ADMITDX</FIELD>
<FIELD>ATTENDLNAME</FIELD>
<FIELD>ATTENDFNAME</FIELD>
<FIELD>ATTENDID</FIELD>
<FIELD>ATTENDIDTYPE</FIELD>
<FIELD>ATTENDSECONDARYID1</FIELD>
<FIELD>ATTENDSECONDARYIDTYPE1</FIELD>
<FIELD>OPERATELNAME</FIELD>
<FIELD>OPERATEFNAME</FIELD>
<FIELD>OPERATEID</FIELD>
<FIELD>OPERATEIDTYPE</FIELD>
<FIELD>OPERATESECONDARYID1</FIELD>
<FIELD>OPERATESECONDARYIDTYPE1</FIELD>
<FIELD>OTHERDX01</FIELD>
<FIELD>OTHERDX02</FIELD>
<FIELD>OTHERDX03</FIELD>
<FIELD>OTHERDX04</FIELD>
<FIELD>OTHERDX05</FIELD>
<FIELD>OTHERDX06</FIELD>
<FIELD>OTHERDX07</FIELD>
<FIELD>OTHERDX08</FIELD>
<FIELD>OTHERDX09</FIELD>
<FIELD>OTHERDX10</FIELD>
<FIELD>OTHERDX11</FIELD>
<FIELD>OTHERDX12</FIELD>
<FIELD>PRINCIPLEPROC</FIELD>
<FIELD>PRINCIPLEPROCDATE</FIELD>
<FIELD>OTHERPROC01</FIELD>
<FIELD>OTHERPROC02</FIELD>
<FIELD>OTHERPROC03</FIELD>
<FIELD>OTHERPROC04</FIELD>
<FIELD>OTHERPROC05</FIELD>
<FIELD>OTHERPROC06</FIELD>
<FIELD>OTHERPROC07</FIELD>
<FIELD>OTHERPROC08</FIELD>
<FIELD>OTHERPROC09</FIELD>
<FIELD>OTHERPROC10</FIELD>
<FIELD>OTHERPROC11</FIELD>
<FIELD>OTHERPROC12</FIELD>
<FIELD>OCCURRENCESPAN01</FIELD>
<FIELD>OCCURRENCESPAN02</FIELD>
<FIELD>OCCURRENCESPAN03</FIELD>
<FIELD>OCCURRENCESPAN04</FIELD>
<FIELD>OCCURRENCESPAN05</FIELD>
<FIELD>OCCURRENCESPAN06</FIELD>
<FIELD>OCCURRENCESPAN07</FIELD>
<FIELD>OCCURRENCESPAN08</FIELD>
<FIELD>OCCURRENCESPAN09</FIELD>
<FIELD>OCCURRENCESPAN10</FIELD>
<FIELD>OCCURRENCESPAN11</FIELD>
<FIELD>OCCURRENCESPAN12</FIELD>
<FIELD>OCCURRENCECODE01</FIELD>
<FIELD>OCCURRENCEDATE01</FIELD>
<FIELD>OCCURRENCECODE02</FIELD>
<FIELD>OCCURRENCEDATE02</FIELD>
<FIELD>OCCURRENCECODE03</FIELD>
<FIELD>OCCURRENCEDATE03</FIELD>
<FIELD>OCCURRENCECODE04</FIELD>
<FIELD>OCCURRENCEDATE04</FIELD>
<FIELD>OCCURRENCECODE05</FIELD>
<FIELD>OCCURRENCEDATE05</FIELD>
<FIELD>OCCURRENCECODE06</FIELD>
<FIELD>OCCURRENCEDATE06</FIELD>
<FIELD>OCCURRENCECODE07</FIELD>
<FIELD>OCCURRENCEDATE07</FIELD>
<FIELD>OCCURRENCECODE08</FIELD>
<FIELD>OCCURRENCEDATE08</FIELD>
<FIELD>OCCURRENCECODE09</FIELD>
<FIELD>OCCURRENCEDATE09</FIELD>
<FIELD>OCCURRENCECODE10</FIELD>
<FIELD>OCCURRENCEDATE10</FIELD>
<FIELD>OCCURRENCECODE11</FIELD>
<FIELD>OCCURRENCEDATE11</FIELD>
<FIELD>OCCURRENCECODE12</FIELD>
<FIELD>OCCURRENCEDATE12</FIELD>
<FIELD>VALUECODE01</FIELD>
<FIELD>VALUEAMOUNT01</FIELD>
<FIELD>VALUEQTY01</FIELD>
<FIELD>VALUECODE02</FIELD>
<FIELD>VALUEAMOUNT02</FIELD>
<FIELD>VALUEQTY02</FIELD>
<FIELD>VALUECODE03</FIELD>
<FIELD>VALUEAMOUNT03</FIELD>
<FIELD>VALUEQTY03</FIELD>
<FIELD>VALUECODE04</FIELD>
<FIELD>VALUEAMOUNT04</FIELD>
<FIELD>VALUEQTY04</FIELD>
<FIELD>VALUECODE05</FIELD>
<FIELD>VALUEAMOUNT05</FIELD>
<FIELD>VALUEQTY05</FIELD>
<FIELD>VALUECODE06</FIELD>
<FIELD>VALUEAMOUNT06</FIELD>
<FIELD>VALUEQTY06</FIELD>
<FIELD>VALUECODE07</FIELD>
<FIELD>VALUEAMOUNT07</FIELD>
<FIELD>VALUEQTY07</FIELD>
<FIELD>VALUECODE08</FIELD>
<FIELD>VALUEAMOUNT08</FIELD>
<FIELD>VALUEQTY08</FIELD>
<FIELD>VALUECODE09</FIELD>
<FIELD>VALUEAMOUNT09</FIELD>
<FIELD>VALUEQTY09</FIELD>
<FIELD>VALUECODE10</FIELD>
<FIELD>VALUEAMOUNT10</FIELD>
<FIELD>VALUEQTY10</FIELD>
<FIELD>CONDITIONCODE01</FIELD>
<FIELD>CONDITIONDATE01</FIELD>
<FIELD>CONDITIONCODE02</FIELD>
<FIELD>CONDITIONDATE02</FIELD>
<FIELD>CONDITIONCODE03</FIELD>
<FIELD>CONDITIONDATE03</FIELD>
<FIELD>CONDITIONCODE04</FIELD>
<FIELD>CONDITIONDATE04</FIELD>
<FIELD>CONDITIONCODE05</FIELD>
<FIELD>CONDITIONDATE05</FIELD>
<FIELD>CONDITIONCODE06</FIELD>
<FIELD>CONDITIONDATE06</FIELD>
<FIELD>CONDITIONCODE07</FIELD>
<FIELD>CONDITIONDATE07</FIELD>
<FIELD>CONDITIONCODE08</FIELD>
<FIELD>CONDITIONDATE08</FIELD>
<FIELD>CONDITIONCODE09</FIELD>
<FIELD>CONDITIONDATE09</FIELD>
<FIELD>CONDITIONCODE10</FIELD>
<FIELD>CONDITIONDATE10</FIELD>
<FIELD>CONDITIONCODE11</FIELD>
<FIELD>CONDITIONDATE11</FIELD>
<FIELD>CONDITIONCODE12</FIELD>
<FIELD>CONDITIONDATE12</FIELD>
<FIELD>TREATMENTCODE01</FIELD>
<FIELD>TREATMENTCODE02</FIELD>
<FIELD>TREATMENTCODE03</FIELD>
<FIELD>TREATMENTCODE04</FIELD>
<FIELD>TREATMENTCODE05</FIELD>
<FIELD>TREATMENTCODE06</FIELD>
<FIELD>TREATMENTCODE07</FIELD>
<FIELD>TREATMENTCODE08</FIELD>
<FIELD>TREATMENTCODE09</FIELD>
<FIELD>TREATMENTCODE10</FIELD>
<FIELD>TREATMENTCODE11</FIELD>
<FIELD>TREATMENTCODE12</FIELD>
<FIELD>IREVCODE1</FIELD>
<FIELD>IPROC1</FIELD>
<FIELD>IMODA1</FIELD>
<FIELD>IMODB1</FIELD>
<FIELD>IMODC1</FIELD>
<FIELD>IAMT1</FIELD>
<FIELD>IUNITS1</FIELD>
<FIELD>IDOS1</FIELD>
<FIELD>IREVCODE2</FIELD>
<FIELD>IPROC2</FIELD>
<FIELD>IMODA2</FIELD>
<FIELD>IMODB2</FIELD>
<FIELD>IMODC2</FIELD>
<FIELD>IAMT2</FIELD>
<FIELD>IUNITS2</FIELD>
<FIELD>IDOS2</FIELD>
<FIELD>IREVCODE3</FIELD>
<FIELD>IPROC3</FIELD>
<FIELD>IMODA3</FIELD>
<FIELD>IMODB3</FIELD>
<FIELD>IMODC3</FIELD>
<FIELD>IAMT3</FIELD>
<FIELD>IUNITS3</FIELD>
<FIELD>IDOS3</FIELD>
<FIELD>IREVCODE4</FIELD>
<FIELD>IPROC4</FIELD>
<FIELD>IMODA4</FIELD>
<FIELD>IMODB4</FIELD>
<FIELD>IMODC4</FIELD>
<FIELD>IAMT4</FIELD>
<FIELD>IUNITS4</FIELD>
<FIELD>IDOS4</FIELD>
<FIELD>IREVCODE5</FIELD>
<FIELD>IPROC5</FIELD>
<FIELD>IMODA5</FIELD>
<FIELD>IMODB5</FIELD>
<FIELD>IMODC5</FIELD>
<FIELD>IAMT5</FIELD>
<FIELD>IUNITS5</FIELD>
<FIELD>IDOS5</FIELD>
<FIELD>IREVCODE6</FIELD>
<FIELD>IPROC6</FIELD>
<FIELD>IMODA6</FIELD>
<FIELD>IMODB6</FIELD>
<FIELD>IMODC6</FIELD>
<FIELD>IAMT6</FIELD>
<FIELD>IUNITS6</FIELD>
<FIELD>IDOS6</FIELD>
<FIELD>IREVCODE7</FIELD>
<FIELD>IPROC7</FIELD>
<FIELD>IMODA7</FIELD>
<FIELD>IMODB7</FIELD>
<FIELD>IMODC7</FIELD>
<FIELD>IAMT7</FIELD>
<FIELD>IUNITS7</FIELD>
<FIELD>IDOS7</FIELD>
<FIELD>IREVCODE8</FIELD>
<FIELD>IPROC8</FIELD>
<FIELD>IMODA8</FIELD>
<FIELD>IMODB8</FIELD>
<FIELD>IMODC8</FIELD>
<FIELD>IAMT8</FIELD>
<FIELD>IUNITS8</FIELD>
<FIELD>IDOS8</FIELD>
<FIELD>IREVCODE9</FIELD>
<FIELD>IPROC9</FIELD>
<FIELD>IMODA9</FIELD>
<FIELD>IMODB9</FIELD>
<FIELD>IMODC9</FIELD>
<FIELD>IAMT9</FIELD>
<FIELD>IUNITS9</FIELD>
<FIELD>IDOS9</FIELD>
<FIELD>IREVCODE10</FIELD>
<FIELD>IPROC10</FIELD>
<FIELD>IMODA10</FIELD>
<FIELD>IMODB10</FIELD>
<FIELD>IMODC10</FIELD>
<FIELD>IAMT10</FIELD>
<FIELD>IUNITS10</FIELD>
<FIELD>IDOS10</FIELD>
<FIELD>DRG</FIELD>
<FIELD>K3DATA</FIELD>
<FIELD>PATIENTAMOUNTPAID</FIELD>
<FIELD>TOTALPURCHASEDSERVICEAMOUNT</FIELD>
<FIELD>PROVSIGNATUREONFILE</FIELD>
<FIELD>PROVACCEPTASSIGNMENTCODE</FIELD>
<FIELD>BENEFITINDICATOR</FIELD>
<FIELD>RELEASEOFINFORMATION</FIELD>
<FIELD>RELATEDCAUSECODE</FIELD>
<FIELD>CLEARINGIDNUMBER</FIELD>
<FIELD>PRIMARYSUBLNAME</FIELD>
<FIELD>PRIMARYSUBFNAME</FIELD>
<FIELD>PRIMARYSUBMI</FIELD>
<FIELD>PRIMARYPAYERNAME</FIELD>
<FIELD>PRIMARYPAYERADDR1</FIELD>
<FIELD>PRIMARYPAYERADDR2</FIELD>
<FIELD>PRIMARYPAYERCITY</FIELD>
<FIELD>PRIMARYPAYERSTATE</FIELD>
<FIELD>PRIMARYPAYERZIP</FIELD>
<FIELD>PRIMARYGROUPNAME</FIELD>
<FIELD>PRIMARYGROUPID</FIELD>
<FIELD>PRIMARYSUBID</FIELD>
<FIELD>PRIMARYPAYERID</FIELD>
<FIELD>SECONDARYSUBLNAME</FIELD>
<FIELD>SECONDARYSUBFNAME</FIELD>
<FIELD>SECONDARYSUBMI</FIELD>
<FIELD>SECONDARYPAYERNAME</FIELD>
<FIELD>SECONDARYPAYERADDR1</FIELD>
<FIELD>SECONDARYPAYERADDR2</FIELD>
<FIELD>SECONDARYPAYERCITY</FIELD>
<FIELD>SECONDARYPAYERSTATE</FIELD>
<FIELD>SECONDARYPAYERZIP</FIELD>
<FIELD>SECONDARYGROUPNAME</FIELD>
<FIELD>SECONDARYGROUPID</FIELD>
<FIELD>SECONDARYSUBID</FIELD>
<FIELD>SECONDARYPAYERID</FIELD>
<FIELD>TERTIARYSUBLNAME</FIELD>
<FIELD>TERTIARYSUBFNAME</FIELD>
<FIELD>TERTIARYSUBMI</FIELD>
<FIELD>TERTIARYPAYERNAME</FIELD>
<FIELD>TERTIARYPAYERADDR1</FIELD>
<FIELD>TERTIARYPAYERADDR2</FIELD>
<FIELD>TERTIARYPAYERCITY</FIELD>
<FIELD>TERTIARYPAYERSTATE</FIELD>
<FIELD>TERTIARYPAYERZIP</FIELD>
<FIELD>TERTIARYGROUPNAME</FIELD>
<FIELD>TERTIARYGROUPID</FIELD>
<FIELD>TERTIARYSUBID</FIELD>
<FIELD>TERTIARYPAYERID</FIELD>
<FIELD>BILLINGPROVIDERNAME</FIELD>
<FIELD>BILLINGPROVIDERADDR1</FIELD>
<FIELD>BILLINGPROVIDERADDR2</FIELD>
<FIELD>BILLINGPROVIDERCITY</FIELD>
<FIELD>BILLINGPROVIDERST</FIELD>
<FIELD>BILLINGPROVIDERZIP</FIELD>
<FIELD>BILLINGPROVIDERID</FIELD>
<FIELD>BILLINGPROVIDERIDTYPE</FIELD>
<FIELD>BILLINGPROVIDERSECONDARYID1</FIELD>
<FIELD>BILLINGPROVIDERSECONDARYIDTYPE1</FIELD>
<FIELD>BILLINGPROVIDERSECONDARYID2</FIELD>
<FIELD>BILLINGPROVIDERSECONDARYIDTYPE2</FIELD>
<FIELD>BILLINGPROVIDERSECONDARYID3</FIELD>
<FIELD>BILLINGPROVIDERSECONDARYIDTYPE3</FIELD>
<FIELD>SUBMITTERNAME</FIELD>
<FIELD>SUBMITTERADDR1</FIELD>
<FIELD>SUBMITTERADDR2</FIELD>
<FIELD>SUBMITTERCITY</FIELD>
<FIELD>SUBMITTERST</FIELD>
<FIELD>SUBMITTERZIP</FIELD>
</CONFIGURATION>

Hesham Dabbas

unread,

May 15, 2016, 11:02:10 AM5/15/16

to X12 Parser

Is this function still available under ver. 1.22c-01?

Com1 Software

unread,

May 15, 2016, 12:36:29 PM5/15/16

to X12 Parser

Hesham,

Under the functions menu in the Parser there is Create Mapping File that replaces this process.

Once you select the transaction that you wish to create a map for it will step you though various field groups such as submitter, receiver, billing provider, subscriber, ect.
The mapping files created will still be named C1837I.XML,C1837P.XML,C1837D.XML, and C1835.XML.

When you run the parser it will auto detect the transaction type an use the appropriate map. You can edit your maps using notepad if you need to add a field that is not used in the create map process.

http://com1software.com/c1d0u252.htm#0684
http://com1software.com/c1d0u252.htm#0612

Thanks

Dave

Reply all

Reply to author

Forward

0 new messages