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 |