Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HAssociateModifiers Contains associated procedure for clinical coding.
Column Name Column Datatype Column Null Option Column Comment
ObjectIDintNOT NULL ObjectId of HAssociateModifiers Rows generated by Architecture
InstanceHFCIDsmallintNOT NULL Instance HFC(Healthcare Foundation Class) ID generated by Architecture
RecordIdintNULL Not Used
Descriptionvarchar(255)NULL Not Used
IsDeletedtinyintNOT NULL Indicates if the row has been deleted. Allowable Values: 0 - False, 1 - True(deleted)
IsVersionedbitNOT NULL Indicates if the row has been modified. Allowable Values: 0 - Not Modified 1 - Modified
CreatedUserIdintNULL UserId of the user who created the HAssociateModifiers row
CreationTimesmalldatetimeNULL Date and time when the object is created.
Codevarchar(64)NULL Procedure associate code
CodeStatustinyintNULL Procedure associate code status
Procedure_oidintNULL Procedure Objectid
LastCngDtimeDATETIMENOT NULLCurrent Universal Time Coordinate or Greenwich Mean Time

Return to Table-Index

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