Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HAssessmentEdit Populated when a revert action is performed on an assessment.
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 object.
CreationTimesmalldatetimeNULL Date and time when the object was created.
ReasonRevisedvarchar(255)NULL The reason the assessment was revised.
UserTitlevarchar(20)NULL Title of the user.
UserAbbrNamevarchar(92)NULL Abbreviation name of the user.
User_oidintNULL ID of the user.
Assessment_oidintNOT NULL ID for the HAssessment table.
VersionPtrsmallintNULL Current version of the assessment before a revert operation.
ToVersionPtrsmallintNULL Specifies to which version the assessment was reverted to.
LastCngDtimeDATETIMENOT NULLCurrent Universal Time Coordinate or Greenwich Mean Time

Return to Table-Index

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