Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
ObjectID | int | NOT NULL | ObjectId of HLocation Rows generated by Architecture |
InstanceHFCID | smallint | NOT NULL | Instance HFC(Healthcare Foundation Class) ID generated by Architecture |
RecordId | int | NULL | Record ID valued to 0. |
Description | varchar(255) | NULL | Not Used |
IsVersioned | bit | NOT NULL | Indicates if the row has been modified. Allowable Values: 0 - Not Modified 1 - Modified |
CreatedUserId | int | NULL | UserId of the user who created the HLocation row |
CreationTime | smalldatetime | NULL | Date and time when the object is created. |
StartDate | datetime | NULL | The starting date and time when the location is active. Can be NULL. |
EndDate | datetime | NULL | The ending date and time when the location is active. Can be NULL. |
Name_oid | int | NULL | Valued to Object id in the HdataDictionaryItem table. The DDI name represents Location Name. Item type code for this DDI entry is 'HospitalOrganization.HLocation.Location'. DDI name |
LocationAddress_oid | int | NULL | ObjectID in HAddress Table entry that contains address information for the location. |
LastCngDtime | datetime | NULL | Last system UTC date /time when row was updated. |
|