Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HAssessmentCategory Information on the type of formusage used to chart the assessment, mainly used for chaptered assessments.
Column Name Column Datatype Column Null Option Column Comment
ObjectIDintNOT NULL The primary key for the table.
InstanceHFCIDsmallintNOT NULL HFC(Healthcare Foundation Class) ID of the object.
RecordIdintNULL This column is not used.
Descriptionvarchar(1)NULL This column is not used.
IsVersionedbitNOT NULL When set to True(1), indicates that the object was modified.
CreatedUserIdintNULL Object ID of the user who created the assessment
CreationTimesmalldatetimeNULL Date and time when the assessment was created.
AssessmentIDintNOT NULLID of the assessment.
FormTypeIDintNULL ID of the form type as defined in the Documentation Builder module.
FormUsageIDintNULL ID of the form usage as defined in the Documentation Builder module.
Form_oidintNULL ID of the form associated with the assessment.
FormUsageDisplayNamevarchar(100)NULL Name of the form associated with the assessment.
FormDateTimesmalldatetimeNULL Date and time used to instantiate the form from the Documentation Builder module.
CategoryStatusintNOT NULLCategory to which the assesssment belongs.
SequenceNumberintNOT NULLSequence number of each chapter in a chaptered assessment.
FormUsagevarchar(50)NULL Form usage that was assigned to the assessment as defined in the Documentation Builder Module.
IsLatesttinyintNULL When set to 1 then it is the latest version.
Assessment_oidintNOT NULL ID of the object(HAssessment).
VersionsmallintNOT NULL Version of the observation. The version is incremented by one every time the observation is modified. When a new assessment is charted, the initial version of the observation is 1 if the observation is valued, and 0 if the observation is not valued.
MandatorytinyintNULL When set to 1 the assessment has mandatory elements.
FormVersionsmallintNULL Version of the form used.
LastCngDtimeDATETIMENOT NULLCurrent Universal Time Coordinate or Greenwich Mean Time

Return to Table-Index

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