Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HGuarantor Contains patient's Guarantor Information
Column Name Column Datatype Column Null Option Column Comment
ObjectIDintNOT NULL ObjectId of HGuarantor Rows generated by Architecture
InstanceHFCIDsmallintNOT NULL Instance HFC(Healthcare Foundation Class) ID generated by Architecture
RecordIdintNULL RecordId of the Patient
Descriptionvarchar(13)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 HGuarantor row
CreationTimesmalldatetimeNULL Date and time when the object is created.
GuarantorNovarchar(50)NULL Unique ID number assigned to the guarantor.
StartDatedatetimeNULL The first date and time when the guarantor is liable to be financially responsible for some or all of the charges of the patient's billing account.
EndDatedatetimeNULL The last date and time when the guarantor is liable to be financially responsible for some or all of the charges of the patient's billing account.
Patient_oidintNULL Patient Oid the same as Objectid in Hpatient Table
Relationvarchar(64)NULL Relationship between the guarantor and the patient.
LastCngDtimedatetimeNULL Last system UTC date /time when row was updated.

Return to Table-Index

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