Table Detail Report

DSCPLN_EVENT_R



Column Section Top of Page


Table-level Detail

Description: Discipline Event Reltn
Definition: Discipline (Role) and Event Set Code (Primitive) Relationship
Table Type: REFERENCE





Column Detail - DSCPLN_EVENT_R


Column Name Type Null? Definition
DISCIPLINE_CD DOUBLE N Discipline (ROLE_TYPE_CD) code value. The Discipline (Role) inherited from POSITION_ROLE_TYPE
DSCPLN_EVENT_ID DOUBLE N Primary Key
EVENT_SET_CD DOUBLE N Event set code, inherited from V500_EVENT_SET_CODE
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.


INFUSION_BILLING_EVENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Infusion Billing Event
Definition: Stores infusion billing event information for a specific order such as the start and stop of the infusion.
Table Type: ACTIVITY





Column Detail - INFUSION_BILLING_EVENT


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
BEGIN_EFFECTIVE_DT_TM DATETIME N Date and time when the row became valid.
COMMENT_LONG_TEXT_ID DOUBLE N Reference to a long text table that holds a comment entered during the infusion documentation process.
CREATE_PRSNL_ID DOUBLE N Id of the person who entered the infusion record.
ENCNTR_ID DOUBLE N The encounter associated with the billing event.
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.
INFUSED_VOLUME_VALUE DOUBLE N The volume in mL that was infused for this infusion event.
INFUSION_BILLING_EVENT_ID DOUBLE N Unique, generated number that identifies a single row on the INFUSION_BILLING_EVENT table.
INFUSION_DURATION_MINS DOUBLE N A value in minutes that represents the actual infusion time. This may be different from the time period between the infusion start and stop if there are short pauses in the administration.
INFUSION_END_DT_TM DATETIME N The date and time representing the end of the infusion.
INFUSION_END_TZ DOUBLE N Time zone associated with the infusion end date and time.
INFUSION_START_DT_TM DATETIME N The date and time representing the start of the infusion.
INFUSION_START_TZ DOUBLE N Time zone associated with the infusion start date and time.
ORDER_ID DOUBLE N The order associated with the billing event.
PREV_INFUSION_BILLING_EVENT_ID DOUBLE N The infusion billing id for the latest version of a given infusion record.
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 - INFUSION_BILLING_EVENT


Child Column in INFUSION_BILLING_EVENT(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
PREV_INFUSION_BILLING_EVENT_ID INFUSION_BILLING_EVENT INFUSION_BILLING_EVENT_ID
COMMENT_LONG_TEXT_ID LONG_TEXT LONG_TEXT_ID
ORDER_ID ORDERS ORDER_ID
CREATE_PRSNL_ID PRSNL PERSON_ID




Parent Column in INFUSION_BILLING_EVENT (PK) Child Table Name Child Column Name
Children: INFUSION_BILLING_EVENT_ID INFUSION_BILLING_EVENT PREV_INFUSION_BILLING_EVENT_ID
INFUSION_CE_RELTN INFUSION_BILLING_EVENT_ID


INFUSION_CE_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Infusion Clinical Event Relation
Definition: Stores all the cliincal events related to a particular infusion event.
Table Type: ACTIVITY





Column Detail - INFUSION_CE_RELTN


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
BEGIN_EFFECTIVE_DT_TM DATETIME N Date and time when the row became valid.
CLINICAL_EVENT_ID DOUBLE N The specific version of a clinical event that makes up a given infusion.
CLINICAL_EVENT_SEQ DOUBLE N Maintains the relative ordering of the clinical events associated to a given infusion event.
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.
INFUSION_BILLING_EVENT_ID DOUBLE N Foreign key to the INFUSION_BILLING_EVENT table that holds the details about the infusion this clinical event is related to.
INFUSION_CE_RELTN_ID DOUBLE N Unique, generated number that identifies a single row on the INFUSION_CE_RELTN table.
PREV_INFUSION_CE_RELTN_ID DOUBLE N The infusion clinical event relation id for the latest version of a given infusion record.
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 - INFUSION_CE_RELTN


Child Column in INFUSION_CE_RELTN(FK) Parent Table Name Parent Column Name
Parents: CLINICAL_EVENT_ID CLINICAL_EVENT CLINICAL_EVENT_ID
INFUSION_BILLING_EVENT_ID INFUSION_BILLING_EVENT INFUSION_BILLING_EVENT_ID
PREV_INFUSION_CE_RELTN_ID INFUSION_CE_RELTN INFUSION_CE_RELTN_ID




Parent Column in INFUSION_CE_RELTN (PK) Child Table Name Child Column Name
Children: INFUSION_CE_RELTN_ID INFUSION_CE_RELTN PREV_INFUSION_CE_RELTN_ID


IO_DEVICE_INTERRUPT



Column Section Relationship Section Top of Page


Table-level Detail

Description: IO_DEVICE_INTERRUPT
Definition: Stores device interruptions or stoppage event information related to an intake/output device, e.g. infusion pump.
Table Type: ACTIVITY





Column Detail - IO_DEVICE_INTERRUPT


Column Name Type Null? Definition
ENCNTR_ID DOUBLE N The ID of the Encounter. FK from ENCOUNTER table
ENTRY_MODE_CD DOUBLE N Used to identify the method in which a result was entered.
EVENT_ID DOUBLE N The parent event id associated with clinical result. EVENT_ID from CLINICAL_EVENT table.
INTERRUPT_END_DT_TM DATETIME N The date and time the IO device stopped experiencing an intteruption in service,i.e. resumed normal normal service operation.
INTERRUPT_START_DT_TM DATETIME N The date and time the IO device began to experience an interruption in service.
IO_DEVICE_INTERRUPT_ID DOUBLE N PRIMARY KEY
IO_TYPE_FLAG DOUBLE N States whether the data is patient intake or output.0 = UNKNOWN1 = INTAKE2 = OUTPUT
ORDER_ACTION_SEQUENCE DOUBLE N Indicates the order action the event was documented against.
ORDER_ID DOUBLE N Unique foreign key to the ORDERS table.
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number. Identifies person who is associated with the intake output result. SEQUENCE NAME:PERSON_ONLY_SEQ
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 in time for 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.



Relationship Detail - IO_DEVICE_INTERRUPT


Child Column in IO_DEVICE_INTERRUPT(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
ORDER_ID ORDERS ORDER_ID
PERSON_ID PERSON PERSON_ID


MED_ADMIN_ALERT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Medication Administration Alert
Definition: Medication Administration Alert Table
Table Type: ACTIVITY





Column Detail - MED_ADMIN_ALERT


Column Name Type Null? Definition
ALERT_SEVERITY_CD DOUBLE N The severity of the recorded alert.
ALERT_TYPE_CD DOUBLE N The type of alert recorded.
CAREAWARE_USED_IND DOUBLE N Maintains whether CareAware was used to obtain drug related information.
EVENT_DT_TM DATETIME N The date/time that the alert was presented to the user.
MED_ADMIN_ALERT_ID DOUBLE N The ID of the medication administration alert event.
MED_ADMIN_EVENT_ID DOUBLE N A unique ID that identifies a specific medication event on the med_admin_event Table
NEXT_CALC_DT_TM DATETIME Y Date and time of the next calculated administration.
NEXT_CALC_TZ DOUBLE N Time zone for the next calculated administration.
NURSE_UNIT_CD DOUBLE N The nurse unit of the device the user is using to enter the medication admin event.
POSITION_CD DOUBLE N The position of the user documenting the medication admin event.
PRSNL_ID DOUBLE N The ID of the user documenting the medication admin event.
SOURCE_APPLICATION_FLAG DOUBLE Y Identification for source application used to chart med event.
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 - MED_ADMIN_ALERT


Child Column in MED_ADMIN_ALERT(FK) Parent Table Name Parent Column Name
Parents: MED_ADMIN_EVENT_ID MED_ADMIN_EVENT MED_ADMIN_EVENT_ID
PRSNL_ID PRSNL PERSON_ID




Parent Column in MED_ADMIN_ALERT (PK) Child Table Name Child Column Name
Children: MED_ADMIN_ALERT_ID MED_ADMIN_MED_ERROR MED_ADMIN_ALERT_ID
MED_ADMIN_PT_ERROR MED_ADMIN_ALERT_ID