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

   

soapware_customizations_pharmacies

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>

               <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