Table Detail Report

CE_UUID



Column Section Relationship Section Top of Page


Table-level Detail

Description: Clinical Event Universal Unique Identifier
Definition: Stores mappings of events to identifiers unique across all client domains.
Table Type: ACTIVITY





Column Detail - CE_UUID


Column Name Type Null? Definition
CE_UUID_ID DOUBLE N Unique generated number that identifies a single row on the CE_UUID table.
CLIENT_IDENT VARCHAR(100) Y A unique client identifier for FHIR applications
EVENT_ID DOUBLE N The event_id from Clinical_event that this UUID is defined for.
EVENT_UUID VARCHAR(100) N Universally unique identifier for a clinical event across all client domains.
LOGICAL_DOMAIN_ID DOUBLE Y The unique identifier for a logical domain. This identifier allows the data to be grouped by logical domain. For example, If you assign clients a logical_domain_id this would allow you to store data for multiple clients on this table.
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.



Relationship Detail - CE_UUID


Child Column in CE_UUID(FK) Parent Table Name Parent Column Name
Parents: LOGICAL_DOMAIN_ID LOGICAL_DOMAIN LOGICAL_DOMAIN_ID


CE_VERSION_PARMS



Column Section Top of Page


Table-level Detail

Description: CE VERSION PARMS
Definition: CE VERSION PARMS
Table Type: REFERENCE





Column Detail - CE_VERSION_PARMS


Column Name Type Null? Definition
ENTITY_NAME VARCHAR(32) N
FIELD_NAME VARCHAR(32) N
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
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.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
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.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.


CLINICAL_EVENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: clinical event
Definition: Stores patient related clinical information exclusively for clinical decision making. The information is part of the official medical record and discoverable. This information describes a point in time, not a duration. Individual rows can be a historical or current result or multiple rows can be connected to represent a larger structure (diagnostic documents, lab reports, medication administrations, etc.). See our structure diagrams for more information https://wiki.cerner.com/x/rIOSWQ
Table Type: ACTIVITY





Column Detail - CLINICAL_EVENT


Column Name Type Null? Definition
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.



Relationship Detail - CLINICAL_EVENT


Child Column in CLINICAL_EVENT(FK) Parent Table Name Parent Column Name
Parents: CE_GROUPING_ID CLINICAL_EVENT CLINICAL_EVENT_ID
ENCNTR_ID ENCOUNTER ENCNTR_ID
MODIFIER_LONG_TEXT_ID LONG_TEXT LONG_TEXT_ID
PERSON_ID PERSON PERSON_ID
PERFORMED_PRSNL_ID PRSNL PERSON_ID
VERIFIED_PRSNL_ID PRSNL PERSON_ID




Parent Column in CLINICAL_EVENT (PK) Child Table Name Child Column Name
Children: CLINICAL_EVENT_ID CAC_DOCUMENT CLINICAL_EVENT_ID
CLINICAL_EVENT CE_GROUPING_ID
INFUSION_CE_RELTN CLINICAL_EVENT_ID
SA_ANESTHESIA_RECORD CLINICAL_EVENT_ID
SA_DISPLAY_RESULT CLINICAL_EVENT_ID


OUTBOUND_RESULT_GROUP



Column Section Relationship Section Top of Page


Table-level Detail

Description: Outbound Result Group
Definition: The Outbound Result Group table stores non-clinically relevant groupings for clinical events that designate results marked for outbound notification.
Table Type: ACTIVITY





Column Detail - OUTBOUND_RESULT_GROUP


Column Name Type Null? Definition
EVENT_ID DOUBLE N The clinical_event that this group is defined for.
OUTBOUND_RESULT_GROUP_ID DOUBLE N Unique, generated number that identifies a single row on the OUTBOUND_RESULT_GROUP table.
RESULT_GROUP_ID DOUBLE N A Result Group will be defined as an arbitrary group of results that are batched together when sending a notification outbound through FSI.
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.



Relationship Detail - OUTBOUND_RESULT_GROUP


Child Column in OUTBOUND_RESULT_GROUP(FK) Parent Table Name Parent Column Name
Parents: RESULT_GROUP_ID OUTBOUND_RESULT_GROUP OUTBOUND_RESULT_GROUP_ID




Parent Column in OUTBOUND_RESULT_GROUP (PK) Child Table Name Child Column Name
Children: OUTBOUND_RESULT_GROUP_ID OUTBOUND_RESULT_GROUP RESULT_GROUP_ID


REF_CD_MAP_DETAIL



Column Section Relationship Section Top of Page


Table-level Detail

Description: Reference Code Mapping Detail
Definition: Detail table used to store associations between results (events, orders, etc.) and reference codes (nomenclature_ids)
Table Type: ACTIVITY





Column Detail - REF_CD_MAP_DETAIL


Column Name Type Null? Definition
ASSIGNMENT_METHOD_CD DOUBLE N Assignment method which was used to make the reference code assignment.
BEGIN_EFFECTIVE_DT_TM DATETIME N Contains the beginning point at which a row in the table is valid.
END_EFFECTIVE_DT_TM DATETIME N The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
ENTITY_CD DOUBLE N Reference code entity value. Identifies the type of result.
ENTITY_COLUMN_VALUE DOUBLE N Value to identify a specific result (used along with entity_cd) related to the reference code.
NOMENCLATURE_ID DOUBLE N The reference information associated to a result.
PARENT_REF_CD_MAP_DETAIL_ID DOUBLE N Provides a mechanism for logically grouping reference codes. Will be the same as REF_CD_MAP_DETAIL_ID if current row is the highest level parent.
PREV_REF_CD_MAP_DETAIL_ID DOUBLE N This field contains the unique ID of the previous version of the current row.
REF_CD_MAP_DETAIL_ID DOUBLE N Unique, generated number that identifies a single row on the REF_CD_MAP_DETAIL table.
REF_CD_MAP_HEADER_ID DOUBLE N Foreign key to the REF_CD_MAP_HEADER table, which identifies the result that was evaluated for reference coding.
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
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.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
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.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - REF_CD_MAP_DETAIL


Child Column in REF_CD_MAP_DETAIL(FK) Parent Table Name Parent Column Name
Parents: NOMENCLATURE_ID NOMENCLATURE NOMENCLATURE_ID
PARENT_REF_CD_MAP_DETAIL_ID REF_CD_MAP_DETAIL REF_CD_MAP_DETAIL_ID
PREV_REF_CD_MAP_DETAIL_ID REF_CD_MAP_DETAIL REF_CD_MAP_DETAIL_ID
REF_CD_MAP_HEADER_ID REF_CD_MAP_HEADER REF_CD_MAP_HEADER_ID




Parent Column in REF_CD_MAP_DETAIL (PK) Child Table Name Child Column Name
Children: REF_CD_MAP_DETAIL_ID REF_CD_MAP_DETAIL PARENT_REF_CD_MAP_DETAIL_ID
REF_CD_MAP_DETAIL PREV_REF_CD_MAP_DETAIL_ID