Table Detail Report

MIC_VALID_BIO_PROFILE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Microbiology Valid Biochemical Profile
Definition: This reference table defines whether block/profile and percent positive data has been built for a group biochemical.
Table Type: REFERENCE





Column Detail - MIC_VALID_BIO_PROFILE


Column Name Type Null? Definition
BLOCK_PROFILE_IND DOUBLE N This field indicates whether or not the block/profile data built for a group biochemical is complete. Block/profile data is not considered complete until block/profile values have been entered for ALL detail biochemicals for a specific group biochemical.
GROUP_BIOCHEMICAL_CD DOUBLE N This field identifies the code value associated with the group biochemical.
PERCENT_POSITIVE_IND DOUBLE N This field indicates whether or not the percent positive data built for a group biochemical is complete. Percent positive data is not considered complete until ALL percent positive values have been entered for organism/detail biochemical combinations.
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_VALID_BIO_PROFILE




Parent Column in MIC_VALID_BIO_PROFILE (PK) Child Table Name Child Column Name
Children: GROUP_BIOCHEMICAL_CD MIC_BIO_BLOCK_PROFILE GROUP_BIOCHEMICAL_CD


MIC_VALID_CODED_RESPONSE



Column Section Top of Page


Table-level Detail

Description: Valid coded responses
Definition: Associates the service_resource/procedure/source combination to a valid_response_id on the mic_valid_response_mbr table
Table Type: REFERENCE





Column Detail - MIC_VALID_CODED_RESPONSE


Column Name Type Null? Definition
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.
SERVICE_RESOURCE_CD DOUBLE N This field contains the code value assigned to the service resource . Service resource code values are stored on code set 221.
SOURCE_CD DOUBLE N This field contains the code value assigned to the source. Source code values are stored on code sets 2052, 1150,1151.
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.
VALID_RESPONSE_ID DOUBLE N This is represents a unique combination of service_resource, procedure, and source for valid responses


MIC_VALID_ORGANISM



Column Section Top of Page


Table-level Detail

Description: Valid Organisms
Definition: This table associates the service_resource/procedure/source combination to the valid_organism_id on the mic_valid_organism_mbr table.
Table Type: REFERENCE





Column Detail - MIC_VALID_ORGANISM


Column Name Type Null? Definition
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.
SERVICE_RESOURCE_CD DOUBLE N This field contains the code value assigned to the service resource. Service resource code values are stored on code set 221.
SOURCE_CD DOUBLE N This field contains the code value assigned to the source. Source code values are stored on code set 2052, 1150, 1151.
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.
VALID_ORGANISM_ID DOUBLE N Id that represents a unique service resource, procedure, and source combination for valid organisms.


MIC_VALID_ORGANISM_MBR



Column Section Top of Page


Table-level Detail

Description: Valid organism members
Definition: This table lists the organisms which are valid for a given valid_organism_id.
Table Type: REFERENCE





Column Detail - MIC_VALID_ORGANISM_MBR


Column Name Type Null? Definition
ORGANISM_CD DOUBLE N Code value for organism on codeset 1021.
STATISTICS_IND DOUBLE Y Determines whether or not an organism should be sent to archive for statistics. 1 - Yes 0 - No
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.
VALID_ORGANISM_ID DOUBLE N Id that represents the service resource, procedure, and source combination for valid organisms


MIC_VALID_PANEL



Column Section Relationship Section Top of Page


Table-level Detail

Description: Microbiology Valid Panels
Definition: This table associates the antibiotic and ID panels with the procedure/service resource/source and organism combination defined on the mic_valid_sus_panel table.
Table Type: REFERENCE





Column Detail - MIC_VALID_PANEL


Column Name Type Null? Definition
DEFAULT_PANEL_IND DOUBLE Y This field indicates if the selected valid panel should be defined as a default panel and automatically display in result entry when the susceptibility method is ordered. Valid values include: 0 = Not a default panel 1 = Default panel
ID_ONLY_IND DOUBLE Y This field indicates if the selected panel is a detail automated ID biochemical. Valid values include: 0 = Not an automated ID biochemical. 1 = Automated ID biochemical.
PANEL_CD DOUBLE N This field identifies the code_value of the antibiotic panel defined as valid for the valid_panel_id.
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.
VALID_PANEL_ID DOUBLE N This field identifies a unique value for each set of valid susceptibility panels defined for an orderable procedure/service resource/source and organism combination.



Relationship Detail - MIC_VALID_PANEL


Child Column in MIC_VALID_PANEL(FK) Parent Table Name Parent Column Name
Parents: VALID_PANEL_ID MIC_VALID_SUS_PANEL VALID_PANEL_ID