Prepare and submit claims data
Importing Claims data
Fieldworker accepts Medicaid claims using the following data.
DDD ID
Client’s DDD ID
Patient First Name
Client’s First Name
Patient Last Name
Client’s Last Name
Patient DOB
Client’s Date of Birth
Patient Gender
Client’s Gender
Prior Authorization
Client’s Prior Authorization Number
Patient ICD_10 Code
Client’s Diagnosis Code/ ICD_10 Code
Medicaid ID
Client’s Medicaid ID
Service start date
Start Date of billing period
Service end date
End Date of billing period
Authorized amount
Authorized Billing amount
Authorized units
Authorized Number of Units
Procedure code
Client Procedure Code
Procedure code modifiers
Procedure Code Modifier
Starting with a sample data file in Google Sheets, the data appears as
ID
First Name
Last Name
Date of Birth
Gender
Medicaid ID
1001
Mike
Once
Jan 1 2000
M
902002587301
1002
Mike
Twice
Jan 2 2000
F
902002587302
1003
Mike
Thrice
Jan 3 2000
F
902002587303
1004
Mike
Forth
Jan 4 2000
M
902002587304
1005
Mike
Fifth
Jan 5 2000
M
902002587305
Download this file as a csv
Download the file as a xlsx
Open the CSV file in a text editor
ID,First Name,Last Name,Date of Birth,Gender,Medicaid ID,Primary Diagnosis Code,Service start,Service end,Authorized amounts,Authorized units,Prior Authorization,Procedure Code,Procedure Code Modifiers
1001,Mike,Once,Jan 1 2000,M,902002587301,,,,,,,,
1002,Mike,Twice,Jan 2 2000,F,902002587302,,,,,,,,
1003,Mike,Thrice,Jan 3 2000,F,902002587303,,,,,,,,
1004,Mike,Forth,Jan 4 2000,M,902002587304,,,,,,,,
1005,Mike,Fifth,Jan 5 2000,M,902002587305,,,,,,,,
Open the xls file in Excel
ID
First Name
Last Name
Date of Birth
Gender
Medicaid ID
1001
Mike
Once
Jan 1 2000
M
9.02003E+11
1002
Mike
Twice
Jan 2 2000
F
9.02003E+11
1003
Mike
Thrice
Jan 3 2000
F
9.02003E+11
1004
Mike
Forth
Jan 4 2000
M
9.02003E+11
1005
Mike
Fifth
Jan 5 2000
M
9.02003E+11
However, the cell value is still correct and can be checked using the formula bar.
Open the CSV file in Excel
Save the xls file as CSV as is, and open it in a text editor
ID,First Name,Last Name,Date of Birth,Gender,Medicaid ID,Primary Diagnosis Code,Service start,Service end,Authorized amounts,Authorized units,Prior Authorization,Procedure Code,Procedure Code Modifiers,,,,,,,,,,,,
1001,Mike,Once,Jan 1 2000,M,9.02003E+11,,,,,,,,,,,,,,,,,,,,
1002,Mike,Twice,Jan 2 2000,F,9.02003E+11,,,,,,,,,,,,,,,,,,,,
1003,Mike,Thrice,Jan 3 2000,F,9.02003E+11,,,,,,,,,,,,,,,,,,,,
1004,Mike,Forth,Jan 4 2000,M,9.02003E+11,,,,,,,,,,,,,,,,,,,,
1005,Mike,Fifth,Jan 5 2000,M,9.02003E+11,,,,,,,,,,,,,,,,,,,,
Change the format of the Medicaid ID column to
Text
Number with no decimal
Save the xls file as CSV after this conversion (8.1)
Save the xls file as CSV after this conversion (8.2)
Open the CSV file after 8.1 in a text editor
ID,First Name,Last Name,Date of Birth,Gender,Medicaid ID,Primary Diagnosis Code,Service start,Service end,Authorized amounts,Authorized units,Prior Authorization,Procedure Code,Procedure Code Modifiers,,,,,,,,,,,,
1001,Mike,Once,Jan 1 2000,M,9.02003E+11,,,,,,,,,,,,,,,,,,,,
1002,Mike,Twice,Jan 2 2000,F,9.02003E+11,,,,,,,,,,,,,,,,,,,,
1003,Mike,Thrice,Jan 3 2000,F,9.02003E+11,,,,,,,,,,,,,,,,,,,,
1004,Mike,Forth,Jan 4 2000,M,9.02003E+11,,,,,,,,,,,,,,,,,,,,
1005,Mike,Fifth,Jan 5 2000,M,9.02003E+11,,,,,,,,,,,,,,,,,,,,
Open the CSV file after 8.2 in a text editor
ID,First Name,Last Name,Date of Birth,Gender,Medicaid ID,Primary Diagnosis Code,Service start,Service end,Authorized amounts,Authorized units,Prior Authorization,Procedure Code,Procedure Code Modifiers,,,,,,,,,,,,
1001,Mike,Once,Jan 1 2000,M,902002587301,,,,,,,,,,,,,,,,,,,,
1002,Mike,Twice,Jan 2 2000,F,902002587302,,,,,,,,,,,,,,,,,,,,
1003,Mike,Thrice,Jan 3 2000,F,902002587303,,,,,,,,,,,,,,,,,,,,
1004,Mike,Forth,Jan 4 2000,M,902002587304,,,,,,,,,,,,,,,,,,,,
1005,Mike,Fifth,Jan 5 2000,M,902002587305,,,,,,,,,,,,,,,,,,,,
If you need to open the CSV file, see if you can use a text editor.
If you open the CSV file in Excel or any other similar spreadsheet software, please ensure that the ‘Medicaid ID’ column is correctly displaying the ID.
The entries in the Medicaid ID column should look like 902002587301 and not like this 9.02003E+11
Last updated
Was this helpful?