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 | The 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. |
RoleName | varchar(255) | NULL | Name of the role. |
RoleDescription | varchar(255) | NULL | Description of the role. |
RoleCode | varchar(255) | NOT NULL | Unique Identifier for each role. For example - ED Nurse, ED Physician, Cardiology. |
SecurityRole | bit | NULL | When set to True, indicates that only the Security module in the application uses the role. Allowable Values: 0,1, or NULL. Key of allowable values: 0 - False, 1 - True. |
LastChanged | datetime | NULL | The most recent date and time when the role was modified. |
BeginTime | smalldatetime | NULL | The date and time when the role became valid. |
EndTime | smalldatetime | NULL | The last date and time when the role was valid. |
|