Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HClinicalNote Details about the patient's clinical notes.
Column Name Column Datatype Column Null Option Column Comment
ObjectIDintNOT NULL The primary key for the associated table.
InstanceHFCIDsmallintNOT NULL The 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. Once this field is set to True, you cannot reset it to False.
CreatedUserIdintNULL The ID of the user who created the clinical note. This field is linked to HSUser table to get details about the user.
CreationTimesmalldatetimeNULL The date and time when the clinical note was created.
PatientIDintNOT NULL The ID of the patient.
UserRolevarchar(30)NULL The role of the staff type of the user who entered the clinical note for the patient.
CollectedDTsmalldatetimeNOT NULL The date and time when the clinical note was collected.
ClinNoteIDintNOT NULL The unique ID assigned to the clinical note.
EnteredDTsmalldatetimeNOT NULL The date and time when the clinical note was entered in the application.
EndDTdatetimeNULL The last date and time when the clinical note is available to users for selection and processing.
LinkObjectIDBigIntNULL The unique ID of the HFC object to which the user attaches the clinical note. For example, if we attach a clinical note to an assessment, the assessment ID is stored.
LinkObjectHFCIDintNULL The HFC ID of the object to which the user attaches the clinical note.
NoteStatusintNOT NULL The status of the clinical note. Allowable Values: 0, 1, 2, 3. Key of allowable values: 0 - Erroneous, 1 - Draft 2, - InProgress 3 - Complete.
NoteStatusTextvarchar(30)NOT NULL Description of the status of the clinical note. Refer to NoteStatus for values.
NoteTextvarchar(3500)NULL Contents of the clinical note.
RevisedReasonvarchar(30)NULL The reason the clinical note was modified.
RevisedUserAbbrNamevarchar(30)NULL The abbreviation for the name of the user who modified the clinical note.
RevisedUserRolevarchar(30)NULL The staff type of the user who modified the clinical note.
UserNamevarchar(92)NOT NULL The name of the user who entered the clinical note
UserIDintNOT NULL The ID of the user who entered the clinical note.
VisitIDintNULL The ID of the patient visit during which the clinical note was entered.
UserTitlevarchar(30)NULL The title(such as Mr or Ms) for the user who entered the clinical note.
HistoryIndtinyintNULL When set to 0, indicates that a new clinical note was entered. When set to 1, indicates that the clinical note was modified. Allowable Values: 0, 1, or NULL. Key of allowable values: 0 - New Clinical Note Entered, 1 - Clinical Note Modified.
LastCngDtimeDATETIMENOT NULLCurrent Universal Time Coordinate or Greenwich Mean Time

Return to Table-Index

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