Table Detail Report

AOAV_DIAGNOSES



Column Section Relationship Section Top of Page


Table-level Detail

Description: AOAV_DIAGNOSES
Definition: Activity table to store the diagnoses that are documented and considered for contribution to a patient's predictions. The list of diagnoses should match what is displayed on the SOI Mpage.
Table Type: ACTIVITY





Column Detail - AOAV_DIAGNOSES


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_DIAGNOSES_ID DOUBLE N PRIMARY KEY
AOAV_DIAGNOSIS_GROUP_CD DOUBLE N Unique generated number that identifies the code value of the AOAV_DIAGNOSIS_GROUP code set
AOAV_PERSON_ENCNTR_ID DOUBLE N #OBSOLETE in DBARCHDTL-22877 - Unique identifier from the AOAV_PERSON_ENCOUNTER table
DIAGNOSIS_DT_TM DATETIME Y Date/time diagnosis was determined for patient
ENCNTR_ID DOUBLE Y Unique Identifier of the encounter;
SOURCE_IDENTIFIER VARCHAR(50) Y ICU10 Diagnosis Equivalent code.
SOURCE_STRING VARCHAR(255) Y Description of the ICD10 diagnosis code indicated in SOURCE_IDENTIFIER
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_DIAGNOSES


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


AOAV_DIAG_GROUP_MAP_REF



Column Section Top of Page


Table-level Detail

Description: AOAV_DIAG_GROUP_MAP_REF
Definition: This table stores the mapping of standard ICD10 code patterns to the AOAV_DIAGNOSIS_GROUP
Table Type: REFERENCE





Column Detail - AOAV_DIAG_GROUP_MAP_REF


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N The table row is active or inactive.
AOAV_DIAGNOSIS_GROUP_CD DOUBLE N Unique generated number that identifies the code value of the AOAV_DIAGNOSIS_GROUP code set
AOAV_DIAG_GROUP_MAP_REF_ID DOUBLE N PRIMARY KEY
REGEX_NBR DOUBLE Y Number that orders and distinguishes src_regex patterns
SRC_REGEX_TXT VARCHAR(255) Y The regular expression pattern for a broad category or specific code patter of ICD10 codes
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.


AOAV_ENCNTR_LOC_HIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: AOAV_ENCNTR_LOC_HIST
Definition: This table stores the history of locations for every AOAV encounter
Table Type: ACTIVITY





Column Detail - AOAV_ENCNTR_LOC_HIST


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_ENCNTR_LOC_HIST_ID DOUBLE N PRIMARY KEY
AOAV_PERSON_ENCNTR_ID DOUBLE N #OBSOLETE in DBARCHDTL-22877 - ; Unique number that identifies a single row on the AOAV_PERS Unique number that identifies a single row on the AOAV_PERSON_ENCNTR table.
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.
CALCULATED_FLAG DOUBLE N The calculated flag giving the state of the person-encounter data.
ENCNTR_ID DOUBLE Y Unique Identifier of the encounter;
ENCNTR_LOC_HIST_ID DOUBLE N Foreign key to the encounter location history table.
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_NURSE_UNIT_CD DOUBLE N Nurse Unit location code
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_ENCNTR_LOC_HIST


Child Column in AOAV_ENCNTR_LOC_HIST(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_LOC_HIST_ID ENCNTR_LOC_HIST ENCNTR_LOC_HIST_ID
ENCNTR_ID ENCOUNTER ENCNTR_ID


AOAV_ENCNTR_RISK_HIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: AOAV ENCOUNTER RISK HISTORY
Definition: Table contains the history of risk level for an encounter
Table Type: ACTIVITY





Column Detail - AOAV_ENCNTR_RISK_HIST


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_ENCNTR_RISK_HIST_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.
CRITICAL_TIME_HOURS DOUBLE Y The number of hours for a High Alert to become a Critical alert at the time this risk episode was started
ENCNTR_ID DOUBLE N Unique generated number that identifies a single row on the ENCOUNTER table
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.
END_REASON_FLAG DOUBLE N Flag that denotes the reason the risk ended (e.g. transfer to ICU, no risk, etc.) - 1=NO RISK 2=MODERATE RISK 3= HIGH RISK 4=CRITICAL RISK 5=TRANSFER TO ICU 6=TRANSFER TO SDU 7=TRANSFER TO FLOOR 8=DEATH 9=HOSPITAL DISCHARGE
END_RISK_LEVEL_CD DOUBLE N Code value from AOAV_RISK_LEVEL code_set that represents the specific risk level: Moderate, High, Critical or Low Risk that is indicated at the end of this episode
END_RISK_VALUE DOUBLE Y The value of DI_12_24 or DI_GT_24 that is used to end the risk episode or is current when the episode ended.
HIGH_THRESHOLD_VALUE DOUBLE Y The threshold value for a High alert at the time this risk episode was started
LEVEL_OF_CARE_CD DOUBLE N Code value that defines the level of care for a location
MODERATE_THRESHOLD_VALUE DOUBLE Y The threshold value for a Moderate alert at the time this risk episode was started
RISK_LEVEL_CD DOUBLE N Code value that defines the risk level (e.g. MODERATE, HIGH, CRITICAL)
START_RISK_VALUE DOUBLE Y The value of DI_12_24 or DI_GT_24 that is used to start the risk episode
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_ENCNTR_RISK_HIST


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


AOAV_EVENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: AOAV_EVENT
Definition: Events such as clinical events pertaining to AOAV persons
Table Type: ACTIVITY





Column Detail - AOAV_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.
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_COMP_CD DOUBLE N Code value number that identifies the component for this event
AOAV_EVENT_ID DOUBLE N PRIMARY KEY
CALCULATED_FLAG DOUBLE N The calculated flag giving the state of the event.
ENCNTR_ID DOUBLE N Unique Identifier of the encounter
ERROR_STATUS_FLAG DOUBLE N Error status flag (0 = no error, 1 = in error)
EVENT_DT_TM DATETIME Y The date/time the event was documented.
PARENT_ENTITY_ID DOUBLE N Unique ID of the parent entity. For e.g. clinical_event_id if parent is a clinical event
PARENT_ENTITY_NAME VARCHAR(30) Y Type of parent entity, e.g. CLINICAL_EVENT
PERSON_ID DOUBLE N ** OBSOLETE ** This field is no longer used - DBARCHDTL-23349
RESULT_UNITS_CD DOUBLE N Code value number of the unit of measure of the event.
RESULT_VALUE DOUBLE Y The event result value.
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_EVENT


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




Parent Column in AOAV_EVENT (PK) Child Table Name Child Column Name
Children: AOAV_EVENT_ID AOAV_EVENT_CHILD AOAV_EVENT_ID
AOAV_OUTCOME_COMP_EVENT_R AOAV_EVENT_ID