Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
ObjectID | int | NOT NULL | Object Identifier of this record. This field is a primary key for the associated table. |
InstanceHFCID | smallint | NOT NULL | Healthcare Foundation Class(HFC) Identifier of the object. HFCID of this object is 1440. The value specified in the ObjectID field and in this field enables unique identification of an object instance across the application. |
RecordId | int | NULL | Not used. |
Description | varchar(64) | NULL | User entered free text description of the Status Modifier. |
IsDeleted | tinyint | NOT NULL | Not used. |
IsVersioned | bit | NOT NULL | When set to True, the object was modified. Once this field is set to True, you cannot reset it to False. Allowable Values: 0 - False, 1 - True. Note: The presence of this field in tables depends on the configuration at the time of table design. |
CreatedUserId | int | NULL | Object ID of the logged in user who created this record. This field is linked to HSUser table to get details about the user. For more information see the description of the HSUser table. |
CreationTime | smalldatetime | NULL | Date and time when the record was created. |
Modifier | varchar(64) | NOT NULL | Full or Long Name of the occurrence status modifier. |
ModifierCode | Smallint | NOT NULL | Internal code of the occurrence status modifier. |
OccStatus | varchar(64) | NOT NULL | External Value for system-defined occurrence status. |
| | | Allowable values: |
| | | Active |
| | | Suspend |
| | | Cancel |
| | | Discontinue |
| | | Complete |
| | | In Progress |
| | | Invalid |
| | | Not Complete |
|
OccStatusCode | smallint | NOT NULL | Code of the system-defined occurrence status. |
| | | Allowable values: |
| | | 0 - Active |
| | | 1 - Suspend |
| | | 2 - Cancel |
| | | 3 - Discontinue |
| | | 4 - Complete |
| | | 5 - In Progress |
| | | 6 - Invalid |
| | | 7 - Not Complete |
MedOrNonMed | tinyint | NOT NULL | When valued as 1 - Non Medication order status modifier |
| | | When valued as 0 - Medication order status modifier |
|
StartDateTime | smalldatetime | NULL | Date and time when the record is considered active. When creating a new modifier, the default value is the current date and time. |
EndDateTime | smalldatetime | NULL | Date and time when the record is no longer active. When creating a new modifier, if the user does not specify a value, this column will be valued with 1900-01-01 00:00:00. |
ObsoleteDateTime | smalldatetime | NULL | Date and time when the record was obsoleted. When the user has not entered a value for this column, it will be valued with 1900-01-01 00:00:00. |
ValidityStatus | varchar(16) | NOT NULL | Whether the occurrence modifier is Active or Inactive. Allowable values: Active, Inactive |
ValidityStatusCode | smallint | NOT NULL | Internal value indicating the row is Active or Inactive. |
| | | Allowable values: |
| | | 0 - Complete |
| | | 2 - Incomplete |
ModifierAbbreviation | varchar(4) | NOT NULL | Occurrence status modifier abbreviation. |
IsDefault | bit | NOT NULL | Indicates if this occurrence status modifier is a model status modifier. |
| | | Allowable values: |
| | | 1 - Model occurrence status modifier |
| | | 0 - Non-model occurrence status modifier |
LastCngDtime | DATETIME | NOT NULL | Current Universal Time Coordinate or Greenwich Mean Time |
|
|
|