Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
TBEventLogOid | INT | NOT NULL | This is the unique ID of the milestone event log item. |
PatientVisitOid | INT | NOT NULL | This is a foreign key to HPatientVisit. |
TBVisitOid | INT | NOT NULL | This is a foreign key to HTBVisit. |
TBVisitStatus | SMALLINT | NOT NULL | This is a foreign key to HTBVisit, it indicates the status of this visit. Allowable values: 0 - active, 1 - ended. |
AutoUpdateKeyType | VARCHAR(40) | NULL | This is the ED Auto-Update key type to support certain milestones that require updating. This field identifies what type of information is stored in the AutoUpdateKeyValue field. |
AutoUpdateKeyValue | VARCHAR(40) | NULL | This is the ED Auto-Update key to support certain milestones that require updating. This is the state information that identifies the original Soarian event that caused this patient event to be saved. |
EventName | VARCHAR(40) | NOT NULL | This is the name of the milestone event item, as defined in the HTBEventDefinitionTable. |
TriggerName | VARCHAR(64) | NOT NULL | This is the name of the trigger item, as defined in the HTBEventTriggerDefinitionTable. |
EventDateTime | DATETIME | NOT NULL | This indicates the date/time of the milestone event occurrence. |
EventLogUpdatedByUserOid | INT | NULL | This is the user object ID of the user who added/updated the milestone event log item. |
EventLogUpdatedByLoginId | VARCHAR(100) | NULL | This is the user name of the user who added/updated milestone event log item. |
EventLogManuallyUpdated | SMALLINT | NOT NULL | This is the flag indicating if the milestone event log item is manually updated, so automatic updates should not be applied. |
CreateDTimeMins | SMALLDATETIME | NOT NULL | This indicates the date/time when the milestone event log was created/started. |
LastCngDtime | DATETIME | NOT NULL | This indicates the current Universal Time Coordinate or Greenwich Mean Time. |