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 |