Patient Demographics and Insurance Data Structure

SOAPware 2008 

Version as of April 22, 2009

Patient Demographics 

soapware_charts_generaldemographics 

• defaultproviderid = soapware_admin_providers.id 
• referringproviderid = soapware_customizations_contacts.id 
• primarycareproviderid = soapware_customizations_contacts.id 
• studentstatusid = soapware_customizations_customstrings.itemid 
• financialclass = soapware_customizations_customstrings.itemid 
• defaultpharmacy = soapware_customizations_pharmacies.pharmid 
• epocratesformularyid = soapware_customizations_epocformularies.id 
• sex; 2=female, 1=male 
• martialstatus; 4=divorced, 3=separated, 2=single, 1=married, 0=widowed 

soapware_charts_generaldemographicsaddress 

• patientid = soapware_charts_generaldemographics.patientid 

soapware_charts_generaldemographicsemail 

• patientid = soapware_charts_generaldemographics.patientid 

soapware_charts_generaldemographicsphone 

• patientid = soapware_charts_generaldemographics.patientid 

Referring Physicians/Contacts 

soapware_customizations_contacts 

• specialityid = soapware_customizations_customstrings.itemid 

 Pharmacies 

soapware_customizations_pharmacies 

 Patient Insurance 

soapware_charts_documents 

• patientid = soapware_charts_generaldemographics.patientid 
• documenttype = "SOAPware_Documents_InsuranceDemographics" 

soapware_charts_xmldocumentitems 

• documentid = soapware_charts_documents.documentid 
• itemdata =  

<?xml version="1.0" encoding="utf-8"?> 

<ItemData> 

     <InsurancePolicyList> 

          <InsurancePolicy> 

               <CompanyID>576a8b49-ddc6-4a4e-a615-91e3f631fcfd</CompanyID> 

               <PolicyID>c1f93f55-2cb5-4fa2-b831-aed35d2274bf</PolicyID> 

               <InsuranceType>63f3662b-ed37-4ce1-b740-fc0bf58cae46</InsuranceType> 

               <InsuredFirstName>JENNIFER</InsuredFirstName> 

               <InsuredMiddleName>L</InsuredMiddleName> 

               <InsuredLastName>JAMES</InsuredLastName> 

               <InsuredRelationID>00</InsuredRelationID> 

               <InsuredAddress>23 Forest Ave</InsuredAddress> 

               <InsuredCity>New York</InsuredCity> 

               <InsuredState>AR</InsuredState> 

               <InsuredZip>72703</InsuredZip> 

               <InsuredPhone>(660) 429-2199</InsuredPhone> 

               <InsuredBirthdate>1975-12-21T06:00:00.0Z</InsuredBirthdate> 

               <InsuredGender>female</InsuredGender> 

               <PolicyNumber>1234X</PolicyNumber> 

               <PolicyName>LotsMoney</PolicyName> 

               <GroupNumber>Group14</GroupNumber> 

               <GroupName>BigGroup</GroupName> 

               <EffectiveDate>2009-04-05T05:00:00.0Z</EffectiveDate> 

               <ExpirationDate>2020-04-22T05:00:00.0Z</ExpirationDate> 

               <OtherInfo>She has insurance</OtherInfo> 

               <Copay>0.00</Copay> 

               <CoInsurance>0</CoInsurance> 

               <Employer>DOCS, Inc.</Employer> 

               <PolicyStatus>1</PolicyStatus> 

               <FeeScheduleID>00000000-0000-0000-0000-000000000000</FeeScheduleID> 

          </InsurancePolicy> 

     </InsurancePolicyList> 

</ItemData> 

• CompanyID = soapware_customizations_insurancecos.internalid 
• PolicyID = soapware_customizations_customstrings.itemid 
• InsuranceType = soapware_customizations_customstrings.itemid 
• PolicyStatus; 1=Primary, 2=Secondary, 3=Tertiary, 100=Inactive