Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
ObjectID | int | NOT NULL | Unique Identifier that is used for referencing records in this table. |
InstanceHFCID | smallint | NOT NULL | HFC(Healthcare Foundation Class) ID of the object. |
RecordId | int | NULL | The Record ID. Not valued in this table. Column exists as part of persistence framework implementation. |
Description | varchar(255) | NULL | User defined information provided by the modules in the application |
IsDeleted | tinyint | NOT NULL | When set to 1, indicates that the object was deleted. Allowable Values: 0, 1, or NULL. Key of allowable values: 0 - False, 1 - True. |
IsVersioned | bit | NOT NULL | When set to True, indicates that the object was modified. Once this field is set to True, you cannot reset it to False. Allowable Values: 0, 1, or NULL. Key of allowable values: 0 - False, 1 - True. |
CreatedUserId | int | NULL | Object ID of the user who created the object |
CreationTime | smalldatetime | NULL | Date and Time when the object was created. |
Accessible | bit | NULL | When set to True, indicates that a user can always access the patient visit. Allowable Values: 0, 1, or NULL. Key of allowable values: 0 - False 1 - True. |
TimeRestrictionType | tinyint | NULL | Type of time restriction. Allowable Values: 0, 1, or NULL. Key of allowable values: 0 - AbsoluteTime 1 - VisitDuration. |
BeginTime | smalldatetime | NULL | Date and time when the access definition becomes valid. |
EndTime | smalldatetime | NULL | Date and time when the access definition is no longer valid. |
LastChanged | datetime | NULL | Most recent date and time when the access definition was modified. |
Visit_oid | int | NOT NULL | Object ID for the HPatientVisit. |
UserGroup_oid | int | NOT NULL | Object ID for the user HSUserGroup. |
|