Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HReferringInstitution Contains information about institution that referred the patient to the healthcare unit.
Column Name Column Datatype Column Null Option Column Comment
ObjectIDintNOT NULL ObjectId of HReferringInstitution Rows generated by Architecture
InstanceHFCIDsmallintNOT NULL Instance HFC(Healthcare Foundation Class) ID generated by Architecture
RecordIdintNULL Record Id of the Patient
Descriptionvarchar(25)NULL Can be vaued by client to the name of the institution that referred the patient to the healthcare unit.
IsVersionedbitNOT NULL Indicates if the row has been modified. Allowable values: 0 - false, 1 - Modified
CreatedUserIdintNULL UserId of the user who created the HReferringInstitution row
CreationTimesmalldatetimeNULL Date and time when the object is created.
Namevarchar(75)NULL Name of the institution that referred the patient to the healthcare unit.
Addressvarchar(35)NULL Address of the institution that referred the patient to the healthcare unit.
PhoneNumbervarchar(30)NULL Phone number of the institution that referred the patient to the healthcare unit.
Remarksvarchar(255)NULL Comments related to the institution that referred the patient to the healthcare unit.
StartDateOfValiditydatetimeNULL First date and time the patient is referred to the healthcare unit.
EndDateOfValiditydatetimeNULL Last date and time the patient is referred to the healthcare unit.
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