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 |