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. Note: 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. Not valued in this table. Column exists as part of persistence framework implementation. |
Description | varchar(1) | NULL | User defined information provided by the modules in the application. Not valued in this table. |
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 | 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. |
MappingString | varchar(255) | NULL | String that maps the security object to the HFC object, stored procedures. |
MappingStringDes | varchar(255) | NULL | Description of the string that maps the security object to the HFC object, stored procedures. |
SOType | tinyint | NULL | Type of security object. Allowable Values: 0, 1 and 2. Key of allowable values: 0 - HFCObject, 1 - Stored Procedure and 2 - Event. |
SOGroup | tinyint | NULL | Group to which the security object belongs. Allowable Values: 0, 1, 2 and 3. Key of allowable values: 0 - Other, 1 - Patient related , 2 - Patient + visit related, 3 - Unit Bound |
LastChanged | datetime | NULL | Most recent date and time when the security object was modified. |
BeginTime | smalldatetime | NULL | Date and time when the security object became valid. |
EndTime | smalldatetime | NULL | Last date and time when the security object was valid. |
|