Table Detail Report

AOAV_ICU_STAY



Column Section Relationship Section Top of Page


Table-level Detail

Description: AOAV ICU STAY
Definition: This table is for AOAV reporting. This table defines the AOAV ICU stay (time patient is in an AOAV ICU mapped level of care) for a patient transferred to an AOAV ICU.
Table Type: ACTIVITY





Column Detail - AOAV_ICU_STAY


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.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME N The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
AOAV_ICU_STAY_ID DOUBLE N PRIMARY KEY
ENCNTR_ID DOUBLE N The Encounter identifier from the ENCOUNTER record
ICU_ADMIT_DT_TM DATETIME Y ICU Admit Date and Time
ICU_DECEASED_IND DOUBLE N ICU Deceased Indicator
ICU_DISCH_DT_TM DATETIME Y ICU discharge date time
ICU_VENT_DURATION_ACTUAL_VALUE DOUBLE Y ICU vent duration actual value
INITIAL_LOC_NURSE_UNIT_CD DOUBLE N Initial location nurse unit code
PERSON_ID DOUBLE N ** OBSOLETE ** This field is no longer used - DBARCHDTL-23349
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.



Relationship Detail - AOAV_ICU_STAY


Child Column in AOAV_ICU_STAY(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
INITIAL_LOC_NURSE_UNIT_CD LOCATION LOCATION_CD




Parent Column in AOAV_ICU_STAY (PK) Child Table Name Child Column Name
Children: AOAV_ICU_STAY_ID AOAV_ICU_OUTCOMES AOAV_ICU_STAY_ID


AOAV_LOCATION_REF



Column Section Top of Page


Table-level Detail

Description: AOAV LOCATION REFERENCE
Definition: Reference table for AOAV Location and level of care
Table Type: REFERENCE





Column Detail - AOAV_LOCATION_REF


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.
AOAV_LOCATION_REF_ID DOUBLE N PRIMARY KEY
LEVEL_OF_CARE_CD DOUBLE N code value for AOAV level of care (such as ICU, FLOOR, SDU)
LOC_FACILITY_CD DOUBLE N Code value for location facility
LOC_NURSE_UNIT_CD DOUBLE N Code value for location nurse unit
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.


AOAV_MED_RESULT



Column Section Relationship Section Top of Page


Table-level Detail

Description: AOAV_MEDICATION_RESULT
Definition: Activity table to store the medication results that attributed to a patient's outcomes
Table Type: ACTIVITY





Column Detail - AOAV_MED_RESULT


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.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME N The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
ADMIN_DOSAGE DOUBLE Y The actual volume or quantity of administration.
ADMIN_DT_TM DATETIME Y The tme at which the medication administration became active or the time that the administration happened.
ADMIN_ROUTE_CD DOUBLE N The route of administration.
AOAV_COMP_CD DOUBLE N Code value for a component
AOAV_MED_RESULT_ID DOUBLE N PRIMARY KEY
CALCULATED_FLAG DOUBLE Y The calculated flag giving the state of the event.0-Needs to be calculated; 1- calculation in progress; 2-calculation done
CATALOG_CD DOUBLE N Foreign key to the order_catalog table which has column CATALOG_CD as its primary key (FK from CODE_VALUE)
DOSAGE_UNIT_CD DOUBLE N The unit of measurement for dosage.
ENCNTR_ID DOUBLE N Foreign key value from the encounter table.
ERROR_STATUS_FLAG DOUBLE Y The error status flag (0 = no error, 1 = in error, 2 = invalid)
EVENT_ID DOUBLE N EVENT_ID from the CLINICAL_EVENT table
PERSON_ID DOUBLE N ** OBSOLETE ** This field is no longer used - DBARCHDTL-23349
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.



Relationship Detail - AOAV_MED_RESULT


Child Column in AOAV_MED_RESULT(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
CATALOG_CD ORDER_CATALOG CATALOG_CD


AOAV_OUTCOME



Column Section Relationship Section Top of Page


Table-level Detail

Description: AOAV_OUTCOME
Definition: This table stores the outcomes generated such as PI score, etc.
Table Type: ACTIVITY





Column Detail - AOAV_OUTCOME


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.
ACTIVE_STATUS_CD DOUBLE Y Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME Y The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE Y The person who caused the active_status_cd to be set or change.
AOAV_OUTCOME_ID DOUBLE N PRIMARY KEY
CALCULATED_DT_TM DATETIME Y The date time the outcome is calculated
COMP_SCORE_VALUE DOUBLE Y Score value of the outcome
DAY_NUM DOUBLE Y The day of the patient's encounter stay after they entered the first level of care for which the outcome is generated
ENCNTR_ID DOUBLE N Unique identifier for the Encounter
EQUATION_CD DOUBLE N The AOAV equation code value
OUTCOME_STS_FLAG DOUBLE N The outcome status flag IN-PROGRESS = 0, COMPLETED = 1, SUMMARIZED = 2, MODIFIED = 3
OUTCOME_TYPE_CD DOUBLE N Code value for the type of outcome generated
PERSON_ID DOUBLE N ** OBSOLETE ** This field is no longer used - DBARCHDTL-23349
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.



Relationship Detail - AOAV_OUTCOME


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




Parent Column in AOAV_OUTCOME (PK) Child Table Name Child Column Name
Children: AOAV_OUTCOME_ID AOAV_OUTCOME_COMP AOAV_OUTCOME_ID


AOAV_OUTCOME_COMP



Column Section Relationship Section Top of Page


Table-level Detail

Description: AOAV_OUTCOME_COMPONENT
Definition: This table contains the relationship between an outcome to its corresponding components
Table Type: ACTIVITY





Column Detail - AOAV_OUTCOME_COMP


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
AOAV_COMP_REF_ID DOUBLE N Unique identifier for component
AOAV_OUTCOME_COMP_ID DOUBLE N PRIMARY KEY
AOAV_OUTCOME_ID DOUBLE N Unique identifier for the Outcome
COMP_SCORE_VALUE DOUBLE Y Score value for the component
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 - AOAV_OUTCOME_COMP


Child Column in AOAV_OUTCOME_COMP(FK) Parent Table Name Parent Column Name
Parents: AOAV_COMP_REF_ID AOAV_COMP_REF AOAV_COMP_REF_ID
AOAV_OUTCOME_ID AOAV_OUTCOME AOAV_OUTCOME_ID




Parent Column in AOAV_OUTCOME_COMP (PK) Child Table Name Child Column Name
Children: AOAV_OUTCOME_COMP_ID AOAV_OUTCOME_COMP_COND_R AOAV_OUTCOME_COMP_ID
AOAV_OUTCOME_COMP_EVENT_R AOAV_OUTCOME_COMP_ID