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