Table Detail Report

CE_INV_TIME_RESULT



Column Section Top of Page


Table-level Detail

Description: CE INV TIME RESULT
Definition: Time result of a ce_inventory_result event.
Table Type: ACTIVITY





Column Detail - CE_INV_TIME_RESULT


Column Name Type Null? Definition
END_DT_TM DATETIME Y The item stop time.
EVENT_ID DOUBLE N Foreign key to the clinical_event table.
ITEM_ID DOUBLE N Foreign key to the item_definition table.
START_DT_TM DATETIME N The start time of the item.
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.
VALID_FROM_DT_TM DATETIME N The time at which the event became valid.
VALID_UNTIL_DT_TM DATETIME N Time at which the event ceased to be valid.


CE_IO_TOTAL_RESULT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Clinical Events I/O Total Result
Definition: This table is used to store the Intake/Output Total information for a given period of time.
Table Type: ACTIVITY





Column Detail - CE_IO_TOTAL_RESULT


Column Name Type Null? Definition
CE_IO_TOTAL_RESULT_ID DOUBLE N A Unique, generated number that is used to identify an individual IO Total Result
ENCNTR_FOCUSED_IND DOUBLE N Identifies whether the IO Total is encounter focused, meaning that the total only comes from the encntr_id on the table.
ENCNTR_ID DOUBLE N When IO Total is calculated for a specific encounter, encntr_id will be populated. When IO Total calculated for all encounters, encntr_id will be 0.
EVENT_ID DOUBLE N Identifies a logical IO Total Result. There may be more than one row with the same event_id and io_total_dt_tm values, but only one of those rows will be current as indicated by the valid_until_dt_tm field.
IO_TOTAL_DEFINITION_ID DOUBLE N A reference identifier of IO Total Definitions that is sued to calculate the IO Total.
IO_TOTAL_END_DT_TM DATETIME Y The clinical end date/time of the I&O Total.
IO_TOTAL_RESULT_VAL VARCHAR(255) Y The formatted string of the IO Total Value. Example: "100.0000"
IO_TOTAL_START_DT_TM DATETIME Y The clinical start date/time of the I&O Total.
IO_TOTAL_UNIT_CD DOUBLE N The unit of measure associated to the IO Total Value.
IO_TOTAL_VALUE DOUBLE N The value of the IO Total Result which is calculated by the system and ensured by the user.
LAST_IO_RESULT_CLINSIG_DT_TM DATETIME Y Contains the last clinically significant date time of the intake output result that went into the IO Total.
PERSON_ID DOUBLE N Unique identifier for the Person that the IO Total is associated to.
SUSPECT_FLAG DOUBLE N States whether the IO Total is classified as Suspect.
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.
VALID_FROM_DT_TM DATETIME Y Contains the Beginning Point of when a row in the table is valid.
VALID_UNTIL_DT_TM DATETIME Y 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.



Relationship Detail - CE_IO_TOTAL_RESULT


Child Column in CE_IO_TOTAL_RESULT(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
IO_TOTAL_DEFINITION_ID IO_TOTAL_DEFINITION IO_TOTAL_DEFINITION_ID
PERSON_ID PERSON PERSON_ID


CE_LINKED_RESULT



Column Section Relationship Section Top of Page


Table-level Detail

Description: ce linked result
Definition: It is possible for a clinical event to have multiple parents. An example of this is a radiology report for multiple scans. Each scan has a distinct parent clinical event, and expects to have the same report as a sibling.
Table Type: ACTIVITY





Column Detail - CE_LINKED_RESULT


Column Name Type Null? Definition
ACCESSION_NBR VARCHAR(20) Y Accession number of parent event.
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.
ENCNTR_ID DOUBLE N This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number.
EVENT_CLASS_CD DOUBLE N Event class code of linked event.
EVENT_ID DOUBLE N See Clinical_Event->Event_Id
LINKED_EVENT_ID DOUBLE N Foreign key to the clinical event table.
ORDER_ID DOUBLE N Order id of parent event
REFERENCE_NBR VARCHAR(100) N Reference number of linked event.
SERIES_REF_NBR VARCHAR(100) Y Series reference number of linked event. Only applicable if event class is DOC.
SUB_SERIES_REF_NBR VARCHAR(60) Y Subseries reference number of linked event. Only applicable if event class is DOC.
SUCCESSION_TYPE_CD DOUBLE N Success type code of linked event. Only applicable if event class is DOC.
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.
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.



Relationship Detail - CE_LINKED_RESULT


Child Column in CE_LINKED_RESULT(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID


CE_MED_ADMIN_IDENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Clinical Event Medication Administration Identifier
Definition: Detail table used to store medication identifiers associated with formulary, dispense, or Multum.
Table Type: ACTIVITY





Column Detail - CE_MED_ADMIN_IDENT


Column Name Type Null? Definition
BARCODE_SOURCE_CD DOUBLE N The identifier type used to identify the type of medication stored.
CE_MED_ADMIN_IDENT_ID DOUBLE N Unique, generated number that identifies a single row on the CE_MED_ADMIN_IDENT table.
DISPENSE_HX_ID DOUBLE N Dispense history Id. This is the primary identifier to the dispense_hx table.
DRUG_IDENT VARCHAR(255) Y A generic or universal identifier captured from foreign systems to reflect product information given at administration time.
INV_FILL_LOCATION_CD DOUBLE Y The location that the medication product was acquired from for administration or the inventory location supplying the product used during the administration of the medication.Code Set 220.
ITEM_ID DOUBLE N The drug formulation. This is the primary identifier to the medication_definition table.
MED_ADMIN_BARCODE VARCHAR(200) N Represents the identifier that matches the product (required).
MED_PRODUCT_ID DOUBLE N Contains the specific manufacturer item identifier. This is the primary identifier to the med_product table.
PREV_CE_MED_ADMIN_IDENT_ID DOUBLE N This field contains the unique ID of the previous version of the current row.
SCAN_QTY DOUBLE N The number of items that were given to make up the dose. (must be greater than zero)
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.
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.



Relationship Detail - CE_MED_ADMIN_IDENT


Child Column in CE_MED_ADMIN_IDENT(FK) Parent Table Name Parent Column Name
Parents: PREV_CE_MED_ADMIN_IDENT_ID CE_MED_ADMIN_IDENT CE_MED_ADMIN_IDENT_ID
DISPENSE_HX_ID DISPENSE_HX DISPENSE_HX_ID
INV_FILL_LOCATION_CD LOCATION LOCATION_CD
ITEM_ID MEDICATION_DEFINITION ITEM_ID
MED_PRODUCT_ID MED_PRODUCT MED_PRODUCT_ID




Parent Column in CE_MED_ADMIN_IDENT (PK) Child Table Name Child Column Name
Children: CE_MED_ADMIN_IDENT_ID CE_MED_ADMIN_IDENT PREV_CE_MED_ADMIN_IDENT_ID
CE_MED_ADMIN_IDENT_RELTN CE_MED_ADMIN_IDENT_ID


CE_MED_ADMIN_IDENT_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Clinical Event Medication Administration Identifier Relation
Definition: Relational table used to store associations between medications (ce_med_results) and medication identifiers.
Table Type: ACTIVITY





Column Detail - CE_MED_ADMIN_IDENT_RELTN


Column Name Type Null? Definition
CE_MED_ADMIN_IDENT_ID DOUBLE N Primary key to the medication identifier table that represents the product being billed for.
CE_MED_IDENT_RELTN_ID DOUBLE N Unique, generated number that identifies a single row on the CE_MED_ADMIN_IDENT_RELTN table.
EVENT_ID DOUBLE N Identifier to a logical event row in the clinical_event table.
PREV_CE_MED_IDENT_RELTN_ID DOUBLE N This field contains the unique ID of the previous version of the current row.
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.
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.



Relationship Detail - CE_MED_ADMIN_IDENT_RELTN


Child Column in CE_MED_ADMIN_IDENT_RELTN(FK) Parent Table Name Parent Column Name
Parents: CE_MED_ADMIN_IDENT_ID CE_MED_ADMIN_IDENT CE_MED_ADMIN_IDENT_ID
PREV_CE_MED_IDENT_RELTN_ID CE_MED_ADMIN_IDENT_RELTN CE_MED_IDENT_RELTN_ID




Parent Column in CE_MED_ADMIN_IDENT_RELTN (PK) Child Table Name Child Column Name
Children: CE_MED_IDENT_RELTN_ID CE_MED_ADMIN_IDENT_RELTN PREV_CE_MED_IDENT_RELTN_ID