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 1666. 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 Valued in this table. Column exists as part of persistence framework implementation. |
Description | varchar(1) | NULL | Not Valued in this table. Column exists as part of persistence framework implementation. |
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 description of HSUser table |
CreationTime | smalldatetime | NULL | Date and time when the record is created. |
SessionID | int | NULL | Identifier of the Ordering session in which the Alert was Created. |
AlertID | varchar(30) | NULL | Identifier of the Alert which got generated for the Order |
AlertType | tinyint | NULL | Type of Alert |
| | | Allowable Values |
| | | 100 - EHCheckType.ordTypeDuplicateCheck(Duplicate Check Alert) |
| | | 101 - EHCheckType.ordTypeMNC(Medical Necessity Check Alert) |
AlertDescription | varchar(64) | NULL | Description of the Alert |
OrderOID | int | NULL | ObjectID of the Order(HOrder) for which the alert is generated. |
OverrideComments | varchar(64) | NULL | Comments entered by the user while overriding/Ignoring the Alert. |
AlertStatus | tinyint | NULL | Final Status of the Alert |
| | | Allowable Values |
| | | 100 - EHAlertAction.ordAlertPresented |
| | | 101 - EHAlertAction.ordAlertResolutionInprogress |
| | | 102 - EHAlertAction.ordAlertResolutionComplete |
| | | 103 - EHAlertAction.PartialOverride |
| | | 104 - EHAlertAction.CompleteOverride |
Patient_oid | int | NULL | ObjectID of the patient(HPatient) |
Visit_oid | int | NULL | ObjectID of the patientVisit(HPatientVisit) |
CreatedDateTime | smalldatetime | NULL | DateTime when the Alert was created |
CreatedUserOID | int | NULL | UserOID which created the Alert |
TriggerOrderOID | int | NULL | ObjectID of Order(HOrder) which triggered this Alert processing. This field is only valued when Order is getting placed from AutoSign public service and the public service passes an OrderOID as input |
LastCngDtime | DATETIME | NOT NULL | Current Universal Time Coordinate or Greenwich Mean Time |
|