Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
ObjectID | int | NOT NULL | The primary key for the table. |
InstanceHFCID | smallint | NOT NULL | HFC(Healthcare Foundation Class) ID of the object. |
RecordId | int | NULL | This column is not used. |
Description | varchar(1) | NULL | This column is not used. |
IsVersioned | bit | NOT NULL | When set to True(1), indicates that the object was modified. |
CreatedUserId | int | NULL | ID of the user who created the object. |
CreationTime | smalldatetime | NULL | Date and time when the object was created. |
Unit | varchar(16) | NOT NULL | Type of unit of measure used ex: Cel,F. |
Observation_oid | bigint | NOT NULL | ID of the observation for which the UOM was used. |
Level | smallint | NOT NULL | When set to 1, indicates whether a base unit of measure(ex:kelvin) or a derived unit of measure(Celsius,Fahrenheit) was used. |
ObservationID | bigint | NOT NULL | ID of the observation for which UOM was used. |
UnitCode | varchar(16) | NOT NULL | Code for the Unit of Measure used. ex. The code for Fahrenheit(F) is "degF". |
LastCngDtime | datetime | NULL | The date and time of the last change. |
|