Batch Demographics Export from SOAPwareXchange
This article will detail the instructions to perform a batch export of patient demographics information from SOAPware to a .csv file.
To perform a batch export of patient demographic information to a .csv file:
- Open SOAPwareXchange.
- Click Settings.
- Select Batch Export From SOAPware.
The batch export will be performed. Once it's complete, a pop-up window will appear stating the export has Finished. Click OK to continue.
The exported file will be saved to the following location: C:\ProgramData\SOAPwareXchange\Batch Export. Go to this file path to access the information.
Exported Information
Patient ID (PID) Format
| Field | Type | Length | Description |
|---|---|---|---|
| External ID | Text | 100 | SOAPware will return an external ID from another system if applicable. |
| SOAPware ID | SOAPware's internal unique patient ID. | ||
| Last Name | Text | 20 | |
| First Name | Text | 20 | |
| Sex | Text | 1 | |
| Birth Date | Text | 8 | YYYYMMDD |
| Social Security Number | Number/Text | 11 | XXX-XX-XXXX |
| Chart Number | Text | 20 |
The Patient ID (PID) segment of the file contains the information listed in the above table.
Sample Patient ID Segment:
PID,ExternalID,SOAPwareID,LastName,Firstname,Sex,Birthdate,SocialSecurityNumber,ChartNumber<CR><LF>
PID,EXTERNALID,SOAPWAREID,Doe,John,M,19721029,999-88-0000,1234-56743<CR><LF>
General Demographics (GDEM) Format
| Field | Type | Length | Description |
|---|---|---|---|
| Last Name | Text | 20 | |
| First Name | Text | 20 | |
| Middle Name | Text | 20 | |
| Title | Text | 5 | |
| Suffix | Text | 5 | |
| Street | Text | 20 | |
| Street 2 | Text | 20 | |
| City | Text | 20 | |
| State | Text | 5 | |
| Zip | Number | 5 | |
| Home Phone | Text | 20 | |
| Work Phone | Text | 20 | |
| Text | 20 | ||
| Sex | Text | 1 | |
| Marital Status* | Text | 1 | |
| Birth Date | Number | 8 | YYYYMMDD |
| Fax Number | Text | 20 | |
| Chart Number | Text | 20 | |
| Social Security Number | Text | 11 | XXX-XX-XXXX |
| Primary Physician ID | Text | 6 | |
| Ethnicity | Text | 6 | |
| Language | Text | 2 |
The General Demographics (GDEM) segment of the file contains the information listed in the above table.
Sample General Demographics Segment:
GDEM,LastName,FirstName,MiddleInitial,Title,Suffix,Steert1,Street2,City,State,Zip,HomePhone,WorkPhone,Email,Sex,MartialStatus,Birthdate,,ChartNumber,SocialSecurityNumber,ProviderID,Race,Ethnicity,Language<CR><LF>
GDEM,Doe,John,T,Mr,,111 South St.,Suite 1,Pittsburgh,PA,99999-0989,(999)999-...-88-7777,DrBob,2106-3,2186-3,en<CR><LF>
*Marital Status Values:
- I: Single
- M: Married
- S: Separated
- W: Widowed
- D: Divorced