Make your practice more efficient. Get in touch with our Sales team today at (415) 993-4977.

patient-insurances.tsv

Field Name Data type Field Description
PatientPracticeGuid Guid Unique identifier representing a patient
InsurancePlanGuid Guid Unique identifier for the insurance plan.
RelationshipToInsured String Type of relationship between the insured patient and the insurance plan (e.g., Self).
InsuranceId String Identifier for the patient’s insurance policy (Insurance ID).
GroupId String Group identifier associated with the patient’s insurance plan (Group ID).
OrderOfBenefits String Order of benefits (e.g., Primary) for the patient’s insurance plan.
InsurancePlanInactiveDate DateTime? Date when the patient’s insurance plan became inactive.
InsurancePlanIsActive Boolean Flag that determines if patient’s insurance is active.
EffectiveFromDate DateTime Effective start date of the patient’s insurance coverage.
EffectiveToDate DateTime? Effective end date of the patient’s insurance coverage (nullable).
CopayFixedAmount Decimal Fixed copayment amount that the patient is required to pay for healthcare services.
CopayPercentage Decimal Percentage of healthcare costs that the patient is responsible for as a copayment.
InsurancePlanName String Name or title of the patient’s insurance plan.
IsWorkerCompensation Boolean Indicates whether the insurance coverage is related to workers’ compensation.
PayerName String Name of the insurance payer or provider.
PayerContactFirstName String First name of the contact person at the insurance payer’s organization.
PayerContactLastName String Last name of the contact person at the insurance payer’s organization.
PayerAddress1 String Address line 1 for the insurance payer.
PayerAddress2 String Address line 2 for the insurance payer.
PayerCity String City of the insurance payer
PayerState String State where the insurance payer located.
PayerZip String ZIP code of the insurance payer.
PayerContactPhoneNumber String Payer contact’s phone number.
ClaimsPhoneNumberExtension String Extension associated with the Payer contact’s phone number.
ClaimsFaxNumber String Payer contact’s fax number.
ClaimsFaxExtension String Extension associated with the Payer contact’s fax number.
AttorneyFirstName String First name of the patient’s attorney.
AttorneyMiddleName String Middle name of the patient’s attorney.
AttorneyLastName String Last name of the patient’s attorney.
AttorneyAddress1 String Address Line 1 of the patient’s attorney.
AttorneyAddress2 String Address 2 of the patient’s attorney.
AttorneyCity String City where the patient’s attorney is located.
AttorneyState String State where the patient’s attorney is located.
AttorneyZip String ZIP code of the patient’s attorney’s location.
AttorneyPhoneNumber String Phone number of the patient’s attorney for contact.
AttorneyPhoneNumberExtension String Phone number extension of the patient’s attorney for contact.
AttorneyFaxNumber String Fax number of the patient’s attorney.
AttorneyFaxNumberExtension String Fax number extension of the patient’s attorney.
Notes String Additional notes or comments related to the patient’s insurance information.
EmployerName String Name of the patient’s employer.
EmployerAddress1 String Address line 1 of where the patient’s employer is located.
EmployerAddress2 String Address line 2 of where patient’s employer is located.
EmployerCity String City where the patient’s employer is located.
EmployerState String State where the patient’s employer is located.
EmployerZip String ZIP code of the patient’s employer’s location.
SubscriberFirstName String First name of the subscriber, if applicable.
SubscriberMiddleInitial String Middle initial of the subscriber, if applicable.
SubscriberLastName String Last name of the subscriber, if applicable.
SubscriberGender String Gender of the subscriber.
SubscriberDateOfBirth DateTime? Date of birth of the subscriber.
SubscriberAddress1 String Address Line 1 of the subscriber is located.
SubscriberAddress2 String Address line 2 of where the subscriber is located.
SubscriberCity String City of where the subscriber is located.
SubscriberState String State of the subscriber’s address.
SubscriberZip String ZIP code of the subscriber’s address.
SubscriberPrimaryPhoneNumber String Primary phone number of the subscriber for contact.
SubscriberPrimaryPhoneNumberExtension String Extension for Subscriber’s primary phone number.
SubscriberSecondaryPhoneNumber String Secondary phone number of the subscriber.
SubscriberSecondaryPhoneNumberExtension String Extension for the subscriber’s secondary phone number.
SubscriberSocialSecurityNumber String Social Security Number (SSN) or other identifier of the subscriber.
LastModifiedByUserGuid Guid? Unique identifier of the user who last modified this patient’s insurance information.
LastModifiedDateTimeUtc DateTime UTC date and time when this patient’s insurance information was last modified.
PatientInsurancePlanGuid Guid Unique identifier for the insurance plan associated with the patient.