Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HInsuranceDetails Contains visit Insurance Information.
Column Name Column Datatype Column Null Option Column Comment
ObjectIDintNOT NULL ObjectId of HInsuranceDetails Rows generated by Architecture
InstanceHFCIDsmallintNOT NULL Instance HFC(Healthcare Foundation Class) ID generated by Architecture
RecordIdintNULL Not Used.
IsDeletedbitNOT NULL Indicates if the row has been deleted.
Descriptionvarchar(255)NULL Not Used.
IsVersionedbitNOT NULL Indicates if the row has been modified. Allowable Values: 0 - Not Modified 1 - Modified
CreatedUserIdintNULL UserId of the user who created the HInsuranceDetails row
CreationTimesmalldatetimeNULL Date and time when the object is created.
InsPlanvarchar(64)NULL Specific insurance plan that the subscriber has for insurance coverage.
InsCoNamevarchar(64)NULL The name of the insurance company.
Referralvarchar(75)NULL The referral number from the payer. This number is assigned to the authorization provided by the payer to pay for certain services rendered to the subscriber.
CoPayvarchar(75)NULL The copayment charge for the patient's visit that is collected at the time of visit.
Policyvarchar(75)NULL The insurance number of the payer responsible for paying the subscriber's billing account.
VerificationIndvarchar(64)NULL The status of the subscriber's billing account. The status of an account can be active, inactive, temporary, or closed.
Priorityvarchar(2)NULL The priority for paying the subscriber's billing account. If the priority is high, the payer responsible for the subscriber's billing account will be required to settle the account immediately.
GroupNovarchar(20)NULL The group number of the organization that has subscribers to a particular insurance plan.
GroupNamevarchar(75)NULL The group name of the organization that has subscribers for the insurance policies of an insurance company.
GroupEmpIDvarchar(30)NULL The group ID of the organization that has subscribers to a particular insurance plan.
PayerIDvarchar(30)NULL The unique ID assigned to the payer.
TreatAuthvarchar(75)NULL The authorization code from the payer when the payer authorizes to pay for the services rendered to the patient.
SubscriberIDvarchar(30)NULL Unique ID assigned to the subscriber by the payer.
SubscriberRelationToPtvarchar(5)NULL Relationship of the subscriber to the patient. For example: 'Self', or 'Patient'.
SubscriberSextinyintNULL Gender of the subscriber. Allowable Values: 0 - Male, 1 - Female, 2 - Other, 3 - Unknown, 4 - AllType, 5 - Nothing or NULL
SubscriberDOBdatetimeNULL Date of Birth of the subscriber
SubscriberSSNvarchar(20)NULL The Social Security Number(SSN) of the subscriber.
SubscriberEmployerNamevarchar(64)NULL The name of the subscriber's employer.
PatientVisit_oidintNOT NULL Patient Visit OID associated with provided insurance information. This must match objectID in HPatientVisit Table.
InsCoContactName_oidintNULL Name of the person designated as a contact for the insurance company.
SubscriberName_oidintNULL ObjectID for the patient name object. This should be linked to the ObjectID in HName table.
SubscriberAddress_oidintNULL ObjectID for the patient address object. This should be linked to the Objectid in HAddress table.
SubscriberEmployerAddress_oidintNULL ObjectID for the patient employer address object. This should be linked to the Objectid in HAddress table
InsCoAddress_oidintNULL insurance company address oid related to objectid in HAddress table
LastCngDtimedatetimeNULL Last system UTC date /time when row was updated.
PlanTypevarchar(64)NULL Plan type. For example: Medicare, Medicaid, BlueCross, etc.

Return to Table-Index

  Soarian Clinicals Schema Documentation  
Copyright © 2023, Oracle and/or its affiliates