ACCESSION_NBR |
VARCHAR(20) |
Y |
Keyed (along with contributor_system). Allows access to events/groups of events via Accession Number. Scope and use of Accession Number is application-specific. |
AUTHENTIC_FLAG |
DOUBLE |
N |
Determines whether the information stored in the event record has been authenticated. Valid values: 1 if event_status=authenticated, modified, or superseded; 0 for all others. |
CATALOG_CD |
DOUBLE |
N |
Foreign key to the order_catalog table. Catalog_cd does not exist in the code_value table and does not have a code set.. |
CE_DYNAMIC_LABEL_ID |
DOUBLE |
N |
The label_id of the dynamic label that this clinical event is associated with. (From CE_DYNAMIC_LABEL.label_id) |
CE_GROUPING_ID |
DOUBLE |
Y |
An identifier for grouping related clinical events to facilitate their display together. |
CE_GROUPING_TYPE_TFLG |
VARCHAR(30) |
Y |
The Grouping type which is used to identify grouped clinical events. |
CE_GROUPING_VERSION_NBR |
DOUBLE |
Y |
Version used to indicate that a particular event has been processed by the grouping service.; The service will add a value into the field as it processes items so it knows what rows have been processed. When the grouping service is updated, the version number will be increased so that the service can reprocess rows that have a lower value than the new version number.; |
CLINICAL_EVENT_ID |
DOUBLE |
N |
unique row identifier Unique identifier generated for each row of data in the clinical_event table. |
CLINICAL_SEQ |
VARCHAR(40) |
Y |
This field describes the sequence of an event in a series. For example, 1,2,3 is one sequence or Post Op 1, Post Op2, Post Op3 could be another separate sequence. |
CLINSIG_UPDT_DT_TM |
DATETIME |
Y |
Represents the update date/time that tracks when clinically significant updates are made to the Clinical Event and should only be used to check for updates. This field is used to notify audiences when a clinically significant update is made to an existing clinical event, such as when XR Clinical Reporting re-prints a lab result due to an update of the result value or when a result is resent to a provider's Message Center with the result update. This date should NOT be displayed as the clinically |
COLLATING_SEQ |
VARCHAR(40) |
Y |
Used to define an ordering of sections within an MDOC. |
CONTRIBUTOR_SYSTEM_CD |
DOUBLE |
N |
Contributor system identifies the source feed of data from which a row was populated. This is mainly used to determine how to update a set of data that may have originated from more than one source feed. |
CRITICAL_HIGH |
VARCHAR(20) |
Y |
Critical high value |
CRITICAL_LOW |
VARCHAR(20) |
Y |
Critical low value. |
DEVICE_FREE_TXT |
VARCHAR(255) |
Y |
A free text field that may be used to store the identifier for the device used to capture the event information. (Ex: IV Pump, Oral Fluid Pump, Ventilator, Glucometer) |
ENCNTR_FINANCIAL_ID |
DOUBLE |
N |
The encounter financial id for the result |
ENCNTR_ID |
DOUBLE |
N |
This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number. |
ENTRY_MODE_CD |
DOUBLE |
N |
Used to identify the method in which a result was entered. |
EVENT_CD |
DOUBLE |
N |
It is the code that identifies the most basic unit of the storage, i.e. RBC, discharge summary, image. |
EVENT_CLASS_CD |
DOUBLE |
N |
Coded value which specifies how the event is stored in and retrieved from the event table's sub-tables. For example, Event_Class_CDs identify events as numeric results, textual results, calculations, medications, etc. |
EVENT_END_DT_TM |
DATETIME |
N |
Represents the clinically relevant date/time that is important to a clinical event. Should always be used as the date/time value for a result. It is the time the lab was drawn, or the temperature taken. Also referred to as the clinically relevant date, the service date, or the effective date. This date is intended to be displayed as the result date and used to qualify on the most recent result for a patient. The event_end_dt_tm is the field used in the Flowsheet if it is set to Clinical Range. |
EVENT_END_DT_TM_OS |
DOUBLE |
Y |
If the event_end_dt_tm is precise, then this field is null. If the event_end_dt_tm is a "fuzzy" date, the event_end_dt_tm refers to the earliestdate/time that the event could have occurred, and the event_end_dt_tm_os is a fractional number of days representing the total range of fuzziness. |
EVENT_END_TZ |
DOUBLE |
Y |
Time zone associated with the corresponding DT_TM column. |
EVENT_ID |
DOUBLE |
N |
Unique identifier for an event. Uniquely identifies a logical clinical event row. There may be more than one row with the same event_id, but only one of those rows will be current as indicated by the valid_until_dt_tm field. |
EVENT_RELTN_CD |
DOUBLE |
N |
Relationship code: Parent, Child, Orphan |
EVENT_START_DT_TM |
DATETIME |
Y |
Optional clinical date time for the start of the event. |
EVENT_START_TZ |
DOUBLE |
Y |
Time zone associated with the corresponding DT_TM column. |
EVENT_TAG |
VARCHAR(255) |
N |
Brief text string to describe the event and to be displayed on the flowsheet. Calculated based on event class and status. |
EVENT_TAG_SET_FLAG |
DOUBLE |
Y |
Event Tag Set Flag |
EVENT_TITLE_TEXT |
VARCHAR(255) |
Y |
The title for document results. |
EXPIRATION_DT_TM |
DATETIME |
Y |
The date on which the result no longer becomes clinically relevant. |
INQUIRE_SECURITY_CD |
DOUBLE |
N |
Level of security required to view the content of the record. This is a denormalization for performance. |
MODIFIER_LONG_TEXT_ID |
DOUBLE |
N |
ID of Long Text row containing modifier text. Sequence: LONG_TEXT_SEQ |
NOMEN_STRING_FLAG |
DOUBLE |
N |
Identifies which nomenclature table field will be used to calculate the event_tag. |
NORMALCY_CD |
DOUBLE |
N |
States whether the result is normal. This can be used to determine whether to display the event tag in different color on the flowsheet. For group results, this represents an "overall" normalcy. i.e. Is any result in the group abnormal? Also allows different purge criteria to be applied based on result. |
NORMALCY_METHOD_CD |
DOUBLE |
N |
The method used to interpret normalcy. |
NORMAL_HIGH |
VARCHAR(20) |
Y |
Normal high value |
NORMAL_LOW |
VARCHAR(20) |
Y |
Normal low value |
NORMAL_REF_RANGE_TXT |
VARCHAR(2000) |
Y |
Stores normal reference text for results in which the normal cannot be defined using a numeric range supported by the NORMAL_LOW and NORMAL_HIGH fields. |
NOTE_IMPORTANCE_BIT_MAP |
DOUBLE |
Y |
Contains bits for each note importance assigned to an attached note |
ORDER_ACTION_SEQUENCE |
DOUBLE |
N |
A sequence number used to identify the order of the actions. |
ORDER_ID |
DOUBLE |
N |
Unique foreign key to Order Table. |
PARENT_EVENT_ID |
DOUBLE |
N |
Provides a mechanism for logical grouping of events. i.e. supergroup and group tests. Same as event_id if current row is the highest level parent. |
PERFORMED_DT_TM |
DATETIME |
Y |
Date this result was performed (or authored). |
PERFORMED_PRSNL_ID |
DOUBLE |
N |
Personnel id of provider who performed this result. |
PERFORMED_TZ |
DOUBLE |
Y |
Time zone associated with the corresponding DT_TM column. |
PERSON_ID |
DOUBLE |
N |
This is the value of the unique primary identifier of the person table. It is an internal system assigned number. |
PUBLISH_FLAG |
DOUBLE |
N |
States whether the item in this record is viewable via "normal" applications (e.g., charts, on-line inquiries, etc.). Audit and/or administrative applications would be able to view non-publishable results. |
QC_REVIEW_CD |
DOUBLE |
N |
Result flagged for Review because value is outside review limits, or result was selected for QC review based on percentage or other selection algorithm. Values: no action, selected for review by limit exception, selected for review by algorithm, reviewed. There has not been a code set defined for this code yet. |
RECORD_STATUS_CD |
DOUBLE |
N |
Record status code. Valid values: active, inactive, deleted combined away, needs review. |
REFERENCE_NBR |
VARCHAR(100) |
N |
The combination of the reference nbr and the contributor system code provides a unique identifier to the origin of the data. |
RESOURCE_CD |
DOUBLE |
N |
Service resource code for this event. |
RESOURCE_GROUP_CD |
DOUBLE |
N |
Group service resource code for this event. |
RESULT_STATUS_CD |
DOUBLE |
N |
Result status code. Valid values: authenticated, unauthenticated, unknown, cancelled, pending, in lab, active, modified, superseded, transcribed, not done. |
RESULT_TIME_UNITS_CD |
DOUBLE |
N |
If the result refers to a rate, this field is the time component of the rate. |
RESULT_UNITS_CD |
DOUBLE |
N |
The units of the result. |
RESULT_VAL |
VARCHAR(255) |
Y |
The value of the result |
SERIES_REF_NBR |
VARCHAR(100) |
Y |
Indicates a series of blobs; used to define the context within which replacement/succession of subsequent blobs can occur. |
SOURCE_CD |
DOUBLE |
N |
Source from which a result value originated. For example the source can be father or mother or calculated etc. |
SRC_CLINSIG_UPDT_DT_TM |
DATETIME |
Y |
The update date time of the source clinical event that is being copied to the target clinical event. |
SRC_EVENT_ID |
DOUBLE |
N |
The event_id of the source clinical event that is being copied to the target clinical event. |
SUBTABLE_BIT_MAP |
DOUBLE |
Y |
Each bit of this bit map is an indicator for existence of a row or a particular class of rows in a sub-table. |
SUBTABLE_BIT_MAP2 |
DOUBLE |
Y |
Extension of the SUBTABLE_BIT_MAP column; identifies the sub-tables that are associated with the event; |
TASK_ASSAY_CD |
DOUBLE |
N |
Foreign key to the discrete_task_assay table. Task_assay_cd does not exist in the code_value table and does not have a code set. |
TASK_ASSAY_VERSION_NBR |
DOUBLE |
Y |
The version of the discrete task assay code. |
TRAIT_BIT_MAP |
DOUBLE |
Y |
Represents traits about this clinical event, specifying types of information available for this event. |
UPDT_APPLCTX |
DOUBLE |
N |
The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_CNT |
DOUBLE |
N |
Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_DT_TM |
DATETIME |
N |
The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_ID |
DOUBLE |
N |
The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_TASK |
DOUBLE |
N |
The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
VALID_FROM_DT_TM |
DATETIME |
N |
Contains the Beginning Point of when a row in the table is valid. |
VALID_UNTIL_DT_TM |
DATETIME |
N |
Contains the "End Point" of when a row in the table is valid. Current version of the result has an open 'Until Dt Tm" value. |
VERIFIED_DT_TM |
DATETIME |
Y |
Date this result was verified. |
VERIFIED_PRSNL_ID |
DOUBLE |
N |
Personnel id of provider who verified this result. |
VERIFIED_TZ |
DOUBLE |
Y |
Time zone associated with the corresponding DT_TM column. |
VIEW_LEVEL |
DOUBLE |
N |
Controls viewability of an Event row. Some rows are only used for grouping, etc. and should never be seen. Viewable results can vary depending on their importance. e.g., If the intellistrip is at the "Life" scale, only results which have meaning at the life granularity should appear. If the intellistrip is at the "Day" scale, then all results should be viewable. 0 = Not Viewable. 1 = Viewable at the lowest granularity of time. . . 9=Viewable at the highest granularity of time. |