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.