Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HDPAttributes Contains attributes for diagnoses and procedures.
Column Name Column Datatype Column Null Option Column Comment
ObjectIDintNOT NULL ObjectId of HDPAttributes Rows generated by Architecture
InstanceHFCIDsmallintNOT NULL Instance HFC(Healthcare Foundation Class) ID generated by Architecture
RecordIdintNULL Not Used
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 HDPAttributes row.
CreationTimesmalldatetimeNULL Date and time when the object is created.
Procedure_oidintNULL Procedure Objectid related to objectid in hprocedure table.
Categoryvarchar(64)NULL Category of diagnosis and procedure.
Attributevarchar(255)NULL Attribute associated with the category.
AttributeTypetinyintNULL Type of attribute. Allowable Values: 0 - DPAttribute 1 - SpecializedAttribute or NULL
Diagnosis_oidintNULL Dignosis Objectid related to objectid in HDiagnosis table
IsDeletedtinyintNOT NULL Indicates if the row has been deleted. Allowable Values: 0 - False, 1 - True(deleted)
DiagnosisTypetinyintNULL Diagnosis type or "Type" from the HDiagnosis Table(Registration, Admitting, Working, Discharge, Billing).
LastCngDtimeDATETIMENOT NULLCurrent Universal Time Coordinate or Greenwich Mean Time

Return to Table-Index

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