Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HLetterComment This table stores the information for all comments added to the clinical letter.
Column Name Column Datatype Column Null Option Column Comment
ObjectIDintNOT NULL The primary key.
InstanceHFCIDsmallintNOT NULL The HFC(Healthcare Foundation Class) ID of the object.
RecordIdintNULL The ID of the record.
Descriptionvarchar(1)NULL Column is not used.
IsVersionedbitNOT NULL Valued to 1 if a comment was modified. Allowable values: 0 and 1.
CreatedUserIdintNULL The ID of the user who created the comment in the clinical letter.
CreationTimesmalldatetimeNULL The date and time of the creation of the comment in the clinical letter.
CommentTextvarchar(2000)NULL The text which was added by the user in the comment.
CommentSeqintNULL The sequence of the comment for a particular letter. Value starts at 1 and increases for every new comment on the same letter.
CommentStatusvarchar(1)NULL The status of the comment will be 'A' when the comment is saved.
Letter_oidintNOT NULL The foreign key to HLetterInstance table.
ReadStatussmallintNULL Set to 0 when a comment is added directly in a clinical letter. This indicates that the comment is active.
When a comment is added to a letter which was already sent to the worklist then the ReadStatus for all older comments of that letter will be 1 indicating that they are not active.
LastCngDtimeDATETIMENOT NULLCurrent Universal Time Coordinate or Greenwich Mean Time

Return to Table-Index

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