Table Detail Report
AOAV_COMP_EQUATION_REF
Column Section | Top of Page |
Table-level Detail
Description: | AOAV COMP EQUATION REF |
Definition: | AOAV COMPONENT EQUATION REFERENCE |
Table Type: | REFERENCE |
Column Detail - AOAV_COMP_EQUATION_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_COMP_CD | DOUBLE | N | Code value for the AOAV component |
AOAV_COMP_EQUATION_REF_ID | DOUBLE | N | PRIMARY KEY |
COEFFICIENT_VALUE | DOUBLE | Y | The coefficient value |
EQUATION_CD | DOUBLE | N | Code value for the AOAV equation |
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_COMP_POINTS_REF
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | AOAV_COMPONENT_POINTS_REFERENCE |
Definition: | This table stores the points for different ranges for each component contributing to a score |
Table Type: | REFERENCE |
Column Detail - AOAV_COMP_POINTS_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_COMP_POINTS_REF_ID | DOUBLE | N | PRIMARY KEY |
AOAV_COMP_REF_ID | DOUBLE | N | Unique number that identifies an AOAV Component |
COMP_POINTS | DOUBLE | Y | Points for the component that contribute to a score |
LIMIT_FLAG | DOUBLE | N | Flag values for the type of limit (0-None, 1-Upper only, 2-lower only, 3-both) |
LOWER_LIMIT | DOUBLE | N | Lower limit for the value range |
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. |
UPPER_LIMIT | DOUBLE | N | Upper limit for the value range |
Relationship Detail - AOAV_COMP_POINTS_REF
Child Column in AOAV_COMP_POINTS_REF(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | AOAV_COMP_REF_ID | AOAV_COMP_REF | AOAV_COMP_REF_ID |
AOAV_COMP_REF
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | AOAV_COMPONENT_REFERENCE |
Definition: | Table contains the reference data for an AOAV Component |
Table Type: | REFERENCE |
Column Detail - AOAV_COMP_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 |
AOAV_COMP_CD | DOUBLE | N | Code value of AOAV Component |
AOAV_COMP_REF_ID | DOUBLE | N | Primary Key |
AOAV_COMP_TYPE_CD | DOUBLE | N | Code value that defines the type of aoav component (for example- high, low, median ) |
CALC_TYPE_CD | DOUBLE | N | Code value that defines the type of calculation (for example- PI ) |
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_COMP_REF
Parent Column in AOAV_COMP_REF (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | AOAV_COMP_REF_ID | AOAV_COMP_POINTS_REF | AOAV_COMP_REF_ID |
AOAV_OUTCOME_COMP | AOAV_COMP_REF_ID |
AOAV_COMP_RULE_REF
Column Section | Top of Page |
Table-level Detail
Description: | AOAV_COMPONENT_RULE_REFERENCE |
Definition: | This table stores the AOAV component rules |
Table Type: | REFERENCE |
Column Detail - AOAV_COMP_RULE_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_COMP_CD | DOUBLE | N | Code value for a component |
AOAV_COMP_RULE_REF_ID | DOUBLE | N | PRIMARY KEY |
RULE_CONTEXT | VARCHAR(12) | N | The contextof the rule |
RULE_NBR | DOUBLE | N | Number that identifies the rule |
RULE_TXT | VARCHAR(4000) | Y | The rule |
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_CONDITION
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | AOAV_CONDITION |
Definition: | Activity table to store the conditions that attributed to a patient's outcomes |
Table Type: | ACTIVITY |
Column Detail - AOAV_CONDITION
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 that identifies an AOAV Component. Code Set 400806 |
AOAV_CONDITION_ID | DOUBLE | N | PRIMARY KEY |
AOAV_PERSON_ENCNTR_ID | DOUBLE | N | #OBSOLETE in DBARCHDTL-22877 -; Unique identifier of an AOAV_PERSON_ENCNTR |
BEG_EFFECTIVE_DT_TM | DATETIME | Y | 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 event.0-Needs to be calculated; 1- calculation in progress; 2-calculation done |
ENCNTR_ID | DOUBLE | Y | Unique Identifier of the encounter; |
END_EFFECTIVE_DT_TM | DATETIME | Y | 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. |
ERROR_STATUS_FLAG | DOUBLE | N | The error status flag (0 = no error, 1 = in error, 2 = invalid) |
NOMENCLATURE_ID | DOUBLE | N | Foreign Key value from the NOMENCLATURE table |
PERSON_ID | DOUBLE | Y | Unique Identifier of the person; |
SOURCE_ENTITY_COLUMN | VARCHAR(30) | Y | Column name of the SOURCE_ENTITY_ID E.g. DIAGNOSIS_GROUP, PROBLEM_ID, PROCEDURE_ID |
SOURCE_ENTITY_ID | DOUBLE | N | Unique identifier of source condition from the SOURCE_ENTITY_NAME. |
SOURCE_ENTITY_NAME | VARCHAR(30) | Y | Name of the table of SOURCE_ENTITY_ID , SOURCE_ENTITY_COLUMN ( I.e. DIAGNOSIS, PROBLEM, PROCEDURE) |
STATUS_FLAG | DOUBLE | N | Status flag to represent the Active(0), Inactive (1), Canceled (2), Resolved(3) status of the condition. |
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_CONDITION
Child Column in AOAV_CONDITION(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ENCNTR_ID | ENCOUNTER | ENCNTR_ID |
NOMENCLATURE_ID | NOMENCLATURE | NOMENCLATURE_ID | |
PERSON_ID | PERSON | PERSON_ID |
Parent Column in AOAV_CONDITION (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | AOAV_CONDITION_ID | AOAV_OUTCOME_COMP_COND_R | AOAV_CONDITION_ID |