Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
ObjectID | int | NOT NULL | Object ID and primary key of the table, HFlowSheet. |
InstanceHFCID | smallint | NOT 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. |
RecordId | int | NULL | Indicates the record ID. |
Description | varchar(64) | NULL | User-defined description for the row. |
IsDeleted | tinyint | NOT NULL | Indicates whether the Flowsheet is deleted. Allowable Values: 0 - No, 1 - Yes. |
IsVersioned | bit | NOT NULL | Indicates whether the Flowsheet is modified. Allowable Values: 0 - No, 1 - Yes. |
CreatedUserId | int | NULL | Object ID of the user who created the Flowsheet. This field is linked to the HSUser table to get details about the user. |
CreationTime | smalldatetime | NULL | Date and time when the Flowsheet is created. |
Abbreviation | varchar(16) | NOT NULL | Abbreviation of the Flowsheet. |
FlowSheetName | varchar(64) | NOT NULL | Name of the flowsheet. |
StartDateTime | smalldatetime | NULL | Date and time when the flowsheet becomes available to users for selection and processing. |
EndDateTime | smalldatetime | NULL | Last date and time when the flowsheet is available to users for selection and processing. |
ObsoleteDateTime | smalldatetime | NULL | Date and time when the flowsheet is no longer available to users for selection and processing. |
ContainsDisplayGroup | bit | NULL | Indicates whether the display group is directly associated with the flowsheet. Allowable Values: 0 - False, 1 - True. |
ValidityStatus | varchar(16) | NOT NULL | Validity status of the flowsheet. The status can be active, inactive, incomplete, or obsolete. |
ValidityStatusCode | smallint | NULL | Code associated with the validity status of the flowsheet. Allowable values: 1 - Active, 2 - Inactive, 3 - Incomplete, 4 - Obsolete. |
EnablePrintInPR | tinyint | NULL 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. |
EnableShowAllMicro | smallint | NOT NULL | Indicates whether the shown in all micro enabled for that Flowsheet. Allowable values : 1-Yes, 0-No. |
LastCngDtime | datetime | NULL | Current Universal Time Coordinate or Greenwich Mean Time. |
|