Table Detail Report

AOAV_EVENT_CHILD



Column Section Relationship Section Top of Page


Table-level Detail

Description: AOAV_EVENT_CHILD
Definition: The child event associated with AOAV_EVENT
Table Type: ACTIVITY





Column Detail - AOAV_EVENT_CHILD


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_CHILD_REF_ID DOUBLE N Unique identifier for AOAV COMPONENT CHILD
AOAV_EVENT_CHILD_ID DOUBLE N PRIMARY KEY
AOAV_EVENT_ID DOUBLE N Unique identifier for AOAV EVENT
PARENT_ENTITY_ID DOUBLE N unique identifier for the parent entity i.e. AOAV EVENT ID
PARENT_ENTITY_NAME VARCHAR(30) Y Name of the parent entity i.e. AOAV EVENT
RESULT_DT_TM DATETIME Y The result date/time of this child event.
RESULT_UNITS_CD DOUBLE N The result units of measure of this child event.
RESULT_VALUE DOUBLE Y The result value of this child 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 - AOAV_EVENT_CHILD


Child Column in AOAV_EVENT_CHILD(FK) Parent Table Name Parent Column Name
Parents: AOAV_COMP_CHILD_REF_ID AOAV_COMP_CHILD_REF AOAV_COMP_CHILD_REF_ID
AOAV_EVENT_ID AOAV_EVENT AOAV_EVENT_ID


AOAV_FACILITY_PREF



Column Section Relationship Section Top of Page


Table-level Detail

Description: AOAV_FACILITY_PREFERENCE
Definition: Table contains the preferences for an AOAV facility
Table Type: REFERENCE





Column Detail - AOAV_FACILITY_PREF


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_FACILITY_PREF_ID DOUBLE N PRIMARY KEY
BEG_EFFECTIVE_DT_TM DATETIME N The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
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.
LOC_FACILITY_CD DOUBLE N The code value of the facility location.Value from LOCATION table and Code Set 220
PREF_CD DOUBLE N The code value of the Deterioration alerting preference. from code set 4644010
PREF_VALUE DOUBLE N The numeric value of the Deterioration alerting preference.
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_FACILITY_PREF


Child Column in AOAV_FACILITY_PREF(FK) Parent Table Name Parent Column Name
Parents: LOC_FACILITY_CD LOCATION LOCATION_CD


AOAV_FACILITY_REF



Column Section Relationship Section Top of Page


Table-level Detail

Description: AOAV FACILITY REF
Definition: FACILITY REFERENCE
Table Type: REFERENCE





Column Detail - AOAV_FACILITY_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.
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.
AOAV_FACILITY_REF_ID DOUBLE N PRIMARY KEY
BEG_EFFECTIVE_DT_TM DATETIME N The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
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.
HOSP_BEDS_CNT DOUBLE Y Hospital beds count
HOSP_TEACHING_IND DOUBLE N Hospital teaching indicator
LOC_FACILITY_CD DOUBLE N The location code of the facility
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_FACILITY_REF


Child Column in AOAV_FACILITY_REF(FK) Parent Table Name Parent Column Name
Parents: LOC_FACILITY_CD LOCATION LOCATION_CD


AOAV_HOSP_OUTCOMES



Column Section Relationship Section Top of Page


Table-level Detail

Description: AOAV HOSPITAL OUTCOMES
Definition: This table stores normalized and summarized AOAV outcomes for hospital scores and predictions by AOAV day.
Table Type: ACTIVITY





Column Detail - AOAV_HOSP_OUTCOMES


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_HOSP_OUTCOMES_ID DOUBLE N PRIMARY KEY
DAY_BEG_DT_TM DATETIME Y Day begin date time
DAY_END_DT_TM DATETIME Y Day end date time
DAY_NUM DOUBLE N The day number for the outcome values
ENCNTR_ID DOUBLE N The encounter identifier on ENCOUNTER
HOSP_LOS_PRED_VALUE DOUBLE Y Hospital length of stay predictioin
HOSP_MORTALITY_PRED_VALUE DOUBLE Y Hospital mortality prediction
NORMALIZED_CI_SCORE_VALUE DOUBLE Y Normalized comorbidity index score
NORMALIZED_PI_SCORE_VALUE DOUBLE Y Normalized physiology index score
NORMALIZED_SI_SCORE_VALUE DOUBLE Y Normalized support index score
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_HOSP_OUTCOMES


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


AOAV_ICU_OUTCOMES



Column Section Relationship Section Top of Page


Table-level Detail

Description: AOAV ICU OUTCOMES
Definition: This table is for AOAV reporting. This table stores the AOAV Outcomes for patients defined in the corresponding AOAV_ICU_STAY table.
Table Type: ACTIVITY





Column Detail - AOAV_ICU_OUTCOMES


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_ICU_OUTCOMES_ID DOUBLE N PRIMARY KEY
AOAV_ICU_STAY_ID DOUBLE N AOAV ICU stay identifier
ICU_DAY_BEG_DT_TM DATETIME Y ICU day begin date time
ICU_DAY_END_DT_TM DATETIME Y ICU day end date time
ICU_DAY_NUM DOUBLE N ICU Predictive Day Number. ICU Predictive Day 1 starts when a patient is transferred into an AOAV ICU mapped level of care.
ICU_LOS_PRED_VALUE DOUBLE Y ICU length of stay prediction - the predicted length of stay in the ICU AOAV level of care.
ICU_MORTALITY_PRED_VALUE DOUBLE Y ICU mortality prediction - the probability of dying before transfer from the ICU AOAV Level of care.
ICU_VENT_DURATION_PRED_VALUE DOUBLE Y ICU vent duration prediction
NORMALIZED_ICU_CI_SCORE_VALUE DOUBLE Y Normalized ICU comorbidity index score. This is the portion of the Severity of Illness (SOI) that is based on the patient's comorbidities.
NORMALIZED_ICU_PI_SCORE_VALUE DOUBLE Y Normalized ICU physiology index score. This is the portion of the Severity of Illness (SOI) that is based on the patient's physiology values.
NORMALIZED_ICU_SI_SCORE_VALUE DOUBLE Y Normalized ICU support index score. This is the portion of the Severity of Illness (SOI) that is based on the patient's support therapies.
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_OUTCOMES


Child Column in AOAV_ICU_OUTCOMES(FK) Parent Table Name Parent Column Name
Parents: AOAV_ICU_STAY_ID AOAV_ICU_STAY AOAV_ICU_STAY_ID