AOAV_COMP_CHILD_MAP_REF



Column Section Top of Page


Table-level Detail

Description: AOAV COMPONENT CHILD MAPPING REFERENCE
Definition: This table stores the child components to concept_ckis mapping
Table Type: REFERENCE





Column Detail - AOAV_COMP_CHILD_MAP_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 for the component being mapped
AOAV_COMP_CHILD_MAP_REF_ID DOUBLE N PRIMARY KEY
CONCEPT_CKI VARCHAR(255) N Concept_cki 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.


AOAV_COMP_CHILD_REF



Column Section Relationship Section Top of Page


Table-level Detail

Description: AOAV_COMPONENT_CHILD_REFERENCE
Definition: This table stores the reference data build for a child component (such as SBP, DBP)
Table Type: REFERENCE





Column Detail - AOAV_COMP_CHILD_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 the child component (for e.g. SBP, DBP)
AOAV_COMP_CHILD_REF_ID DOUBLE N PRIMARY KEY
AOAV_COMP_PARENT_CD DOUBLE N Code value of the parent component (for e.g. MAP)
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_CHILD_REF




Parent Column in AOAV_COMP_CHILD_REF (PK) Child Table Name Child Column Name
Children: AOAV_COMP_CHILD_REF_ID AOAV_EVENT_CHILD AOAV_COMP_CHILD_REF_ID


AOAV_COMP_CODE_MAP_REF



Column Section Top of Page


Table-level Detail

Description: AOAV COMPONENT CODE MAPPING REFERENCE
Definition: This table stores the component code to concept_cki mapping
Table Type: REFERENCE





Column Detail - AOAV_COMP_CODE_MAP_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 for a component
AOAV_COMP_CODE_MAP_REF_ID DOUBLE N PRIMARY KEY
CONCEPT_CKI VARCHAR(255) N Concept_cki for a 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.


AOAV_COMP_COND_MAP_REF



Column Section Top of Page


Table-level Detail

Description: AOAV COMPONENT CONDITION MAPPING_REFERENCE
Definition: This table stores the mapping of standard ICD10 code patterns to the AOAV_COMPONENT for conditions
Table Type: REFERENCE





Column Detail - AOAV_COMP_COND_MAP_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_COND_MAP_REF_ID DOUBLE N PRIMARY KEY
REGEX_NBR DOUBLE Y Number that orders and distinguishes src_regex patterns.
SRC_REGEX_TXT VARCHAR(225) Y The regular expression pattern for a broad category or specific code pattern of ICD10 codes
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_COMP_DRUG_CAT_REF



Column Section Top of Page


Table-level Detail

Description: AOAV_COMPONENT_DRUG_CATEGORY_REFERENCE
Definition: This table stores the reference of AOAV Drug Component to multum drug category
Table Type: REFERENCE





Column Detail - AOAV_COMP_DRUG_CAT_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_DRUG_CAT_REF_ID DOUBLE N PRIMARY KEY
CATEGORY_NAME VARCHAR(60) N The multum category name
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.