Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HFlowSheet This table stores information related to the Flowsheets that are defined.
Column Name Column Datatype Column Null Option Column Comment
ObjectIDintNOT NULL Object ID and primary key of the table, HFlowSheet.
InstanceHFCIDsmallintNOT NULL HFC(Healthcare Foundation Class) ID of the object. Note: The value specified in the ObjectID field and in this field enables unique indentification of an object across the application.
RecordIdintNULL Indicates the record ID.
Descriptionvarchar(64)NULL User-defined description for the row.
IsDeletedtinyintNOT NULL Indicates whether the Flowsheet is deleted. Allowable Values: 0 - No, 1 - Yes.
IsVersionedbitNOT NULL Indicates whether the Flowsheet is modified. Allowable Values: 0 - No, 1 - Yes.
CreatedUserIdintNULL Object ID of the user who created the Flowsheet. This field is linked to the HSUser table to get details about the user.
CreationTimesmalldatetimeNULL Date and time when the Flowsheet is created.
Abbreviationvarchar(16)NOT NULLAbbreviation of the Flowsheet.
FlowSheetNamevarchar(64)NOT NULL Name of the flowsheet.
StartDateTimesmalldatetimeNULL Date and time when the flowsheet becomes available to users for selection and processing.
EndDateTimesmalldatetimeNULL Last date and time when the flowsheet is available to users for selection and processing.
ObsoleteDateTimesmalldatetimeNULL Date and time when the flowsheet is no longer available to users for selection and processing.
ContainsDisplayGroupbitNULL Indicates whether the display group is directly associated with the flowsheet. Allowable Values: 0 - False, 1 - True.
ValidityStatusvarchar(16)NOT NULLValidity status of the flowsheet. The status can be active, inactive, incomplete, or obsolete.
ValidityStatusCodesmallintNULL Code associated with the validity status of the flowsheet. Allowable values: 1 - Active, 2 - Inactive, 3 - Incomplete, 4 - Obsolete.
EnablePrintInPRtinyintNULL default Indicates whether the flowsheet can be printed in patient record. Allowable values: 0 - Can be printed in patient record, 1 - Cannot be printed in patient record.
EnableShowAllMicrosmallintNOT NULL Indicates whether the shown in all micro enabled for that Flowsheet. Allowable values : 1-Yes, 0-No.
LastCngDtimedatetimeNULL Current Universal Time Coordinate or Greenwich Mean Time.

Return to Table-Index

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