Patient Demographics and Insurance Data Structure

    Table of contents
    No headers

     

    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

       

    Page last modified 23:55, 22 Apr 2009 by bdorsey
    Page Tags:
    • No tags
    Comments
    Copyright © 2008 SOAPware, Inc. All rights reserved. Contact UsNews Blog RSS Feed