Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HNextofKinDetails Contains patient's next of kin (NOK) relationship.
Column Name Column Datatype Column Null Option Column Comment
ObjectIDintNOT NULL ObjectId of HNextofKinDetails
InstanceHFCIDsmallintNOT NULL Instance HFC(Healthcare Foundation Class)
RecordIdintNULL RecordId of the Patient
Descriptionvarchar(184)NULL Client entered value. Can be the name of the person(Format : First name, Last Name).
IsVersionedbitNOT NULL Indicates if the row has been modified. Allowable Values: 0 - Not Modified 1 - Modified
CreatedUserIdintNULL UserId of the user who created the HNextofKinDetails row
CreationTimesmalldatetimeNULL Date and time when the object was created.
Relationshipvarchar(50)NULL The particulars of the relationship that the patient and the related or the associated party share. Free text entered by the user. For example: Spouse, wife, etc.
ContactRolevarchar(50)NULL The role that the related or the associated party plays with the patient. The possible roles can be emergency contact or other. This is entered by the user on the master ADT system. For example : EMCON for emergency contact.
StartDatedatetimeNULL The first date and time when the related or the associated party of the patient can be contacted.
EndDatedatetimeNULL The last date and time when the related or the associated party of the patient can be contacted.
ContactPersonvarchar(75)NULL The names of the people that the related or the associated party(a healthcare organization) should contact in the event of a patient emergency.
ConsentBeforeContactingbitNULL Indicates if consent is required before contacting the related or the associated party of the patient. Allowable Values: 0 - False, 1 - True, or Null
ExternalIDvarchar(20)NULL External ID of the related or the associated party of the patient.
PrimaryContactbitNULL Indicates that the related or the associated party of the patient is the primary contact during an emergency. Allowable Values: 0 - False 1 - True
Patient_oidintNULL ObjectID of the patient the next of kin is related to. It must be the same as Objectid in HPatient table.
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