Account Receivables File Field Specification (CSV)

File name: receivables_in.csv
Response file name: receivables_in.csv.resp

File format is standard CSV (http://www.ietf.org/rfc/rfc4180.txt).

Field Index	Description	Format	Required	Max Len
1	Date of Service	mm/dd/yyyy	No	10
2	Encounter ID		No	50
3	Patient ID		Yes	50
4	First Name		Yes	50
5	Last Name		Yes	50
6	Balance Due	99999999.99	No	12
7	Date of Birth	mm/dd/yyyy	No	10
8	Gender	M = Male, F = Female	No	1
9	Address Line 1		No	50
10	Address Line 2		No	50
11	City		No	50
12	State		No	2
13	ZIP Code	999999999	No	9
14	Primary Phone Number	9999999999	No	10
15	Mobile Phone Number	9999999999	No	10
16	Email Address		No	128

Example record

"05/03/2011","CLG.11224*66","CLG.11224",,"SMITH","JOHN","107.16","11/28/1971","M","1400 BIRCH ST","","HINESVILLE","GA",
"31313","9123211234","9123211235",

Response File

A response file will be generated during the import of the receivables file. There will be a row in the response file for each record processed. The row will contain the line number in the receivables file being processed, the Patient ID, and the Encounter ID. If an exception occurs during the processing of a record, the details of the exception will be included at the end of the row.

Example response file

"1","CLG.11224","CLG.11224*66"
"2","CLG.11233","CLG.11233*170","Data too long for field ZIP Code"