CONCEPT_IDENT_MIC_RPT
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Concept Identifier Micro Report |
Definition: | Stores reference data linking unique microbiology report and source combinations with concept identifier codes (LOINC). |
Table Type: | REFERENCE |
Column Detail - CONCEPT_IDENT_MIC_RPT
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 | N | 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 | N | The date and time that the active_status_cd was set. |
ACTIVE_STATUS_PRSNL_ID | DOUBLE | N | The person who caused the active_status_cd to be set or change. |
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. |
CATALOG_CD | DOUBLE | N | A code value that identifies the specific microbiology order catalog item associated with the concept identifier. |
CONCEPT_CKI | VARCHAR(255) | Y | The concept identifier. Used to link to the nomenclaure row containing additional information about the concept identifier. |
CONCEPT_IDENT_MIC_RPT_ID | DOUBLE | N | Uniquely identifies data linking a microbiology report and source combinations with concept identifier codes (LOINC). |
CONCEPT_TYPE_FLAG | DOUBLE | N | Identifies the type of concept identifier associated to the antibiotic and susceptibility method. 1 = LOINC Analyte Code 2 - LOINC Attachment Code |
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. |
IGNORE_IND | DOUBLE | N | Identifies that the row will be ignored by the LOINC service. |
ORG_CLASS_FLAG | DOUBLE | N | Identifies the organism type associated with the concept identifier. 0 - N/A 1 - Bacteria 2 - Mycobacteria 3 - Fungus 4 - Parasite 5 - Virus 6 - Yeast |
SERVICE_RESOURCE_CD | DOUBLE | N | A code value that identifies the specific microbiology service resource associated witth the concept identifier If the row is for a LOINC Analyte code, a service_resource_cd = 0.0 indicates all service resources. |
SOURCE_CD | DOUBLE | N | A code value that identifies the specific microbiology source/specimen type associated with the concept identifier. |
TASK_CD | DOUBLE | N | A code value that identifies the specific microbiology stain report task associated with the concept identifier. If the row is for a LOINC Analyte code a task_cd = 0.0 indicates a non-stain report. |
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 - CONCEPT_IDENT_MIC_RPT
Child Column in CONCEPT_IDENT_MIC_RPT(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | CONCEPT_CKI | CMT_CONCEPT | CONCEPT_CKI |
CONCEPT_IDENT_MIC_SUSC
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Concept Identifier Microbiology Susceptibility |
Definition: | Stores reference data linking unique microbiology antibiotic and susceptibility method combinations with concept identifier codes (LOINC). |
Table Type: | REFERENCE |
Column Detail - CONCEPT_IDENT_MIC_SUSC
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 | N | 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 | N | The date and time that the active_status_cd was set. |
ACTIVE_STATUS_PRSNL_ID | DOUBLE | N | The person who caused the active_status_cd to be set or change. |
ANTIBIOTIC_CD | DOUBLE | N | A code value that identifies the specific antibiotic associated with the concept identifier. |
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. |
CONCEPT_CKI | VARCHAR(255) | Y | The concept identifier. Used to link to the nomenclature row containing additional information about the concept identifier. |
CONCEPT_IDENT_MIC_SUSC_ID | DOUBLE | N | Uniquely identifies the data linking a microbiology antibiotic and susceptibility method combination with a concept identifier code. |
CONCEPT_TYPE_FLAG | DOUBLE | N | Identifies the type of concept identifier associated to the antibiotic and susceptibility method. 1 = LOINC Analyte Code 2 - LOINC Attachment Code |
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. |
IGNORE_IND | DOUBLE | N | Identifies that the row will be ignored by the LOINC service. |
METHOD_CD | DOUBLE | N | A code value that identifies the specific microbiology susceptibility method associated with the concept identifier. |
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 - CONCEPT_IDENT_MIC_SUSC
Child Column in CONCEPT_IDENT_MIC_SUSC(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | CONCEPT_CKI | CMT_CONCEPT | CONCEPT_CKI |
MIC_ABNORMAL_LIST
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Microbiology Abnormal Organisms and Responses |
Definition: | This table associates the abnormal report responses with the procedure/source/service resource combination defined on the mic_abn_org_response_code table. |
Table Type: | REFERENCE |
Column Detail - MIC_ABNORMAL_LIST
Column Name | Type | Null? | Definition |
---|---|---|---|
ABNORMAL_CD | DOUBLE | N | This field identifies the code value of the report response that is defined as abnormal for the procedure/source/service resource. Abnormal results can be organisms or coded responses. |
CRITERIA_ID | DOUBLE | N | This field identifies the unique value for each set of abnormal results defined for a procedure/source/service resource combination defined on the mic_abn_org_response_code table. |
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 - MIC_ABNORMAL_LIST
Child Column in MIC_ABNORMAL_LIST(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | CRITERIA_ID | MIC_ABN_ORG_RESPONSE_CODE | CRITERIA_ID |
MIC_ABN_ORG_RESPONSE_CODE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Microbiology Abnormal Organism Criteria |
Definition: | This table takes the combination of procedure/source/service resource and creates a unique identifier which is used to define abnormal result parameters. |
Table Type: | REFERENCE |
Column Detail - MIC_ABN_ORG_RESPONSE_CODE
Column Name | Type | Null? | Definition |
---|---|---|---|
AGE_GROUP_CD | DOUBLE | N | This field is not used at this time. |
CATALOG_CD | DOUBLE | N | This field contains the code value assigned to the procedure as defined in the DCPtools.exe application. Ordered procedure code values are stored on code set 200 Order Catalog. |
CRITERIA_ID | DOUBLE | N | This field identifies a unique value for each set of abnormal results defined for a procedure/source/service resource combination. |
DIAGNOSIS_CD | DOUBLE | N | This field is not used at this time. |
ETHNIC_GROUP_CD | DOUBLE | N | This field is not used at this time. |
INCLUDE_EXCLUDE_IND | DOUBLE | Y | This field is not used at this time. |
SERVICE_RESOURCE_CD | DOUBLE | N | This field identifies the code value of the service resource to which abnormal results are defined. Service resources are defined on code set 221. |
SOURCE_GROUPING_CD | DOUBLE | N | This field identifies the code_value of the source used to define abnormal results. All three levels of source hierarchy (source, section, category) can be used to define interpretations. |
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 - MIC_ABN_ORG_RESPONSE_CODE
Child Column in MIC_ABN_ORG_RESPONSE_CODE(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | CATALOG_CD | ORDER_CATALOG | CATALOG_CD |
SERVICE_RESOURCE_CD | SERVICE_RESOURCE | SERVICE_RESOURCE_CD |
Parent Column in MIC_ABN_ORG_RESPONSE_CODE (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | CRITERIA_ID | MIC_ABNORMAL_LIST | CRITERIA_ID |
MIC_ABN_SUS_RESULT
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Microbiology Abnormal Susceptibility Results |
Definition: | This table takes the combination of procedure/source/organism/susceptibility type and service resource and creates a unique identifier that is used to define abnormal susceptibility result parameters. |
Table Type: | REFERENCE |
Column Detail - MIC_ABN_SUS_RESULT
Column Name | Type | Null? | Definition |
---|---|---|---|
ABN_SUS_ID | DOUBLE | N | This field identifies a unique value for each set of abnormal susceptibility results defined for a procedure/source/organism/susceptibility type and service resource combination. |
CATALOG_CD | DOUBLE | N | This field contains the code value assigned to the procedure as defined in the DCPtools.exe application. Ordered procedure code values are stored on code set 200 Order Catalog. |
ORGANISM_CD | DOUBLE | N | This field identifies the code value of the organism for which susceptibility abnormal results are defined. Organisms are defined on code set 1021, Organisms. |
SERVICE_RESOURCE_CD | DOUBLE | N | This field identifies the code value of the service resource to which abnormal results are defined. Service resources are defined on code set 221. |
SOURCE_GROUPING_CD | DOUBLE | N | This field identifies the code_value of the source used to define abnormal results. All three levels of source hierarchy (source, section, and category) can be used to define interpretations. |
SUS_DETAIL_CD | DOUBLE | N | This field identifies of the susceptibility detail procedure for which susceptibility interpretations are defined. Susceptibility detail procedures are defined on code set 1004. |
SUS_METHOD_CD | DOUBLE | N | This field identifies the code value of the susceptibility method for which susceptibility abnormal results are defined. Susceptibility methods are defined on code set 65. |
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 - MIC_ABN_SUS_RESULT
Child Column in MIC_ABN_SUS_RESULT(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | SUS_DETAIL_CD | MIC_DETAIL_TASK | TASK_COMPONENT_CD |
ORGANISM_CD | MIC_ORGANISM_DATA | ORGANISM_ID | |
SUS_METHOD_CD | MIC_TASK | TASK_ASSAY_CD | |
CATALOG_CD | ORDER_CATALOG | CATALOG_CD | |
SERVICE_RESOURCE_CD | SERVICE_RESOURCE | SERVICE_RESOURCE_CD |
Parent Column in MIC_ABN_SUS_RESULT (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | ABN_SUS_ID | MIC_MEDICATION_RANGE | ABN_SUS_ID |