Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HDiagnosisSites Contains information about what side of the body diagnosis relate to
Column Name Column Datatype Column Null Option Column Comment
ObjectIDintNOT NULL ObjectId of HDiagnosisSites 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. Allowable Values: 0 - False, 1 - True(deleted)
Descriptionvarchar(1)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 HDiagnosisSites row
CreationTimesmalldatetimeNULL Date and time when the object is created.
DiagnosisOIDintNOT NULL Diagnosis Objectid related to Objectid in HDiagnosis table
BodySitevarchar(255)NULL Side of the body diagnosis relate to.
IsPrimarySiteSmallIntNOT NULL Indicator If the body site is the primary site for diagnosis. Allowable Values: 0 - No, 1 - Yes

Return to Table-Index

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