Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
ObjectID | int | NOT NULL | The object ID of the object. This field is always a primary key for the associated table. |
InstanceHFCID | smallint | NOT NULL | The HFC(Healthcare Foundation Class) ID of the object. The value specified in the ObjectID field and in this field enables unique identification of an object across the application. |
RecordId | int | NULL | The record ID. Modules in the application can use this field to group all objects having something in common and then assign the same RecordId to all the objects. For example, all related information for a patient, such as patient address, patient visits, patient name, etc., can be assigned the same RecordId. The modules can then query on this RecordId to retrieve the related information for that patient. |
Description | varchar(255) | NULL | User-defined information provided by the end user from SecurityTool while creating the Patient Level Chart Limitation. |
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 | Indicates the object ID of the user who created the object. This field is linked to HSUser table to get details about the user. |
CreationTime | smalldatetime | NULL | Date and time when the object was created. |
Accessible | smallint | NULL | The type of Patient Level Chart Limitation. Allowable Values: 0, 1, or 2. Key of allowable values: 0 - Restriction, 1 - Permission, 2 - AllowOnly. |
TimeRestrictionType | tinyint | NULL | The type of Restriction. Allowable Values:0, 1 Key of allowable values: 0 - Absolute Time, 1 - Visit Duration |
BeginTime | smalldatetime | NULL | The Begin Time of the Chart Limitation |
EndTime | smalldatetime | NULL | The End Time of the Chart Limitation |
LastChanged | datetime | NULL | The Time the Last Change happened to the row |
UserGroup_oid | int | NOT NULL | The ObjectId of the HUserGroup table |
TimeRefVisit_oid | int | NULL | The ObjectId of the HPatientVisit table if the Chart Limitation type is set on Visit Level |
Patient_oid | int | NOT NULL | The ObjectId of the HPatient table |
|