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. |