Table Detail Report
CE_MED_RESULT
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | ce med result |
Definition: | There are two types of medication administration, continuous (IV, IVP) and intermittent. Each intermittent administration occupies one row in the ce_med_result table. For continuous administration, each action will be represented by a ce_med_result row, |
Table Type: | ACTIVITY |
Column Detail - CE_MED_RESULT
Column Name | Type | Null? | Definition |
---|---|---|---|
ADMIN_DOSAGE | DOUBLE | N | Actual volume or quantity of administration. |
ADMIN_END_DT_TM | DATETIME | Y | For continuous administrations, this field is the end of the time period in which this administration was active. If the administration is currently active, this field will be NULL. For intermittent administrations, this field does not apply. |
ADMIN_END_TZ | DOUBLE | Y | Time zone associated with the corresponding DT_TM column. |
ADMIN_METHOD_CD | DOUBLE | N | The method of the administration. i.e. chew, shampoo. |
ADMIN_NOTE | VARCHAR(120) | Y | Short note associated with this medication administration |
ADMIN_PROV_ID | DOUBLE | N | Personnel ID of provider administering medication. |
ADMIN_PT_LOC_CD | DOUBLE | N | The patient location when the medication was administered. |
ADMIN_ROUTE_CD | DOUBLE | N | Route of administration. i.e. PO, TOP, IM. |
ADMIN_SITE_CD | DOUBLE | N | For certain administration routes a body site might be needed to fully describe the method of administration. i.e. IM-Right Arm. |
ADMIN_START_DT_TM | DATETIME | N | The time at which this medication administration became active for continuous administrations. For intermittent, it is the time the administration happened. |
ADMIN_START_TZ | DOUBLE | Y | Time zone associated with the corresponding DT_TM column. |
ADMIN_STRENGTH | DOUBLE | Y | Use when medication_product_cd does not specify the strength. |
ADMIN_STRENGTH_UNIT_CD | DOUBLE | N | Units for admin_strength. This may be a compound unit (i.e. ml/hr). |
BOLUS_TYPE_CD | DOUBLE | Y | Bolus (an amount of IV medication administered rapidly to decrease the response time or to be used as a loading dose prior to an infusion) type. i.e. PCA, Loading. |
DILUENT_TYPE_CD | DOUBLE | N | The diluent if one was used. The diluent is an event code. |
DOSAGE_UNIT_CD | DOUBLE | N | Unit of measurement for dosage. i.e. tablet, ml. |
EVENT_ID | DOUBLE | N | Foreign key to the Event Table. |
IMMUNIZATION_TYPE_CD | DOUBLE | N | This field classifies the type of Immunization given. Some examples are Pediatric, Travel and Adult. |
INFUSED_VOLUME | DOUBLE | Y | The volume at any one point in time that remains in the IV Bag. |
INFUSED_VOLUME_UNIT_CD | DOUBLE | N | Unit of measure for infused volume |
INFUSION_RATE | DOUBLE | Y | For continuously administered medications, IV or IVP, the infusion rate and unit is used to capture the flow rate of the medication into the patient. |
INFUSION_TIME_CD | DOUBLE | N | The unit of measure for the duration of the administration. |
INFUSION_UNIT_CD | DOUBLE | N | The unit of measure for volume or quantity of the medication. i.e. ml, drip, tablet. |
INITIAL_DOSAGE | DOUBLE | N | Initial volume or quantity of the administered dose. |
INITIAL_VOLUME | DOUBLE | Y | Total volume medication and diluent at the beginning of the administration. |
IV_EVENT_CD | DOUBLE | N | Code to describe any change or activity on the iv for the patient. |
MEDICATION_FORM_CD | DOUBLE | N | Form of the medication (e.g., Caplet, Liquid, Ointment, etc.). Depending on how we going to allow clinicians to specify the actual product administered, this info might be moved to the product admin sub table. . |
PH_DISPENSE_ID | DOUBLE | N | *** OBSOLETE |
REASON_REQUIRED_FLAG | DOUBLE | Y | Whether the clinician is required to enter a reason for giving this medication. |
REFUSAL_CD | DOUBLE | N | Indicates the reason the patient refused the medical substance. Any entry in this field indicates that the patient did not take the substance. |
REMAINING_VOLUME | DOUBLE | Y | The remaining volume is the portion of the medication that is wasted after administering it to the patient. Used for reimbursement of the wasted amount. |
REMAINING_VOLUME_UNIT_CD | DOUBLE | N | The remaining volume unit code is the unit of measure for the portion of medication that was wasted after administering it to the patient. Used for reimbursement of the wasted amount. |
RESPONSE_REQUIRED_FLAG | DOUBLE | Y | Whether the clinician is required to document patient¿s response to the medication. |
SUBSTANCE_EXP_DT_TM | DATETIME | Y | Expiration date of the medical substance administered |
SUBSTANCE_LOT_NUMBER | VARCHAR(20) | Y | Lot number of the medical substance administered |
SUBSTANCE_MANUFACTURER_CD | DOUBLE | N | The manufacturer of the medical substance administered. |
SYNONYM_ID | DOUBLE | N | The synonym of the order ingredient for this medication result. |
SYSTEM_ENTRY_DT_TM | DATETIME | Y | Timestamp of when the administration information was entered into the source system. |
TOTAL_INTAKE_VOLUME | DOUBLE | Y | The amount that impacted the patient¿s intake volume. |
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. We need to determine what that value is. |
WEIGHT_UNIT_CD | DOUBLE | N | The unit of measurement for the weight value. |
WEIGHT_VALUE | DOUBLE | N | The value of the documented weight used in charting the medication result. |
Relationship Detail - CE_MED_RESULT
Child Column in CE_MED_RESULT(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ADMIN_PROV_ID | PERSON | PERSON_ID |
CE_MICROBIOLOGY
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | CE MICROBIOLOGY |
Definition: | ce microbiology |
Table Type: | ACTIVITY |
Column Detail - CE_MICROBIOLOGY
Column Name | Type | Null? | Definition |
---|---|---|---|
BIOTYPE | VARCHAR(20) | Y | The biotype number of a microorganism |
EVENT_ID | DOUBLE | N | Foreign key to the Event Table. |
MICRO_SEQ_NBR | DOUBLE | N | Used for uniqueness in cases where there are multiple micro records per clinical_event |
OBSERVATION_PRSNL_ID | DOUBLE | N | Name of the clinician who made the observation. |
ORGANISM_CD | DOUBLE | N | A unique identifier for organism. Foreign key to the Organism Table. |
ORGANISM_OCCURRENCE_NBR | DOUBLE | N | A unique number to identify parts of the same organism. |
ORGANISM_TYPE_CD | DOUBLE | N | The type of organism. |
POSITIVE_IND | DOUBLE | N | Indicates whether the organism was expected to be found in the culture. |
PROBABILITY | DOUBLE | Y | ** OBSOLTE** THIS COLUMN NO LONGER USED as of 3/18/05** Percent probability for this microorganism. This will be a floating point number with a value between 0 and 1. |
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. Current version of the result has an open "Until Dt Tm" value. We need to determine what that value is. |
Relationship Detail - CE_MICROBIOLOGY
Parent Column in CE_MICROBIOLOGY (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | EVENT_ID | CE_SUSCEPTIBILITY | EVENT_ID |
MICRO_SEQ_NBR | CE_SUSCEPTIBILITY | MICRO_SEQ_NBR | |
VALID_UNTIL_DT_TM | CE_SUSCEPTIBILITY | VALID_UNTIL_DT_TM |
CE_PENDING_RESULT
Column Section | Top of Page |
Table-level Detail
Description: | CE PENDING RESULT |
Definition: | Summary table of pending clinical events |
Table Type: | ACTIVITY |
Column Detail - CE_PENDING_RESULT
Column Name | Type | Null? | Definition |
---|---|---|---|
EVENT_CD | DOUBLE | N | Event code of pending result |
EVENT_ID | DOUBLE | N | Event id of pending clinical event |
CE_PRCS_QUEUE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Clinical Event Process Queue |
Definition: | This table is used to store items that are waiting to be processed by other subsystems such as Messaging Service. When an item is processed, the status is updated to Processed and the item will be removed from the queue after an item is endorsed. |
Table Type: | ACTIVITY |
Column Detail - CE_PRCS_QUEUE
Column Name | Type | Null? | Definition |
---|---|---|---|
CE_EVENT_ACTION_ID | DOUBLE | N | A unique identifier use to associate the queue row to a CE_EVENT_ACTION row. |
CE_PRCS_QUEUE_ID | DOUBLE | N | A unique, generated number that is used to identify an individual CE_PRCS_QUEUE row. |
CREATE_DT_TM | DATETIME | Y | This field identifies when the process queue row was created. |
EVENT_ID | DOUBLE | N | An identifier used to associate an action queue row to a clinical event row. |
PRCS_DT_TM | DATETIME | Y | This field identifies when the process queue row was processed by the subsystem such as Messaging Service. |
QUEUE_STATUS_CD | DOUBLE | N | This field identifies the status of the process queue row. |
QUEUE_TYPE_CD | DOUBLE | N | This field identifies the type of process queue item to be processed. |
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 - CE_PRCS_QUEUE
Child Column in CE_PRCS_QUEUE(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | CE_EVENT_ACTION_ID | CE_EVENT_ACTION | CE_EVENT_ACTION_ID |
CE_PREFS
Column Section | Top of Page |
Table-level Detail
Description: | Clinical Event Server Preference |
Definition: | This table is used to store clinical event server preferences. The preferences stored on this table will be read at server startup. |
Table Type: | REFERENCE |
Column Detail - CE_PREFS
Column Name | Type | Null? | Definition |
---|---|---|---|
CE_PREFS_ID | DOUBLE | N | Unique, generated key that is used to identify an individual ce_prefs row. |
PREF_NAME | VARCHAR(20) | N | The name portion of the name-value pair for this preference row. |
PREF_VALUE | VARCHAR(256) | N | The value portion of the name-value pair for this preference 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. |