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