Table Detail Report

MIC_QC_SEQUENCE



Column Section Top of Page


Table-level Detail

Description: Microbiology Quality Control Sequence
Definition: This reference table contains a record for each microbiology QC sequence.
Table Type: REFERENCE





Column Detail - MIC_QC_SEQUENCE


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_TIME_NBR DOUBLE N This field contains the time of day that a sequence begins.
END_TIME_NBR DOUBLE N This field contains the time of day that a sequence ends.
SEQUENCE_ID DOUBLE N This field contains the unique value that identifies the QC sequence.
SEQUENCE_NAME VARCHAR(40) N This field contains the unique name for the QC sequence.
SEQUENCE_NAME_KEY VARCHAR(40) N This field is the same as the sequence_name field, only converted to uppercase.
SEQUENCE_NAME_KEY_A_NLS VARCHAR(160) Y SEQUENCE_NAME_KEY_A_NLS column
SEQUENCE_NAME_KEY_NLS VARCHAR(82) N This field is 2 times the length of the key + 2. It is used for sorting the name field when in a non-English environment.
SERVICE_RESOURCE_CD DOUBLE N This field contains the unique identifier of the service resource code associated with the sequence.
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.


MIC_QC_TASK



Column Section Relationship Section Top of Page


Table-level Detail

Description: Microbiology Quality Control Task
Definition: This reference table contains a record for each microbiology QC task.
Table Type: REFERENCE





Column Detail - MIC_QC_TASK


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.
QC_ITEM_ID DOUBLE N This field contains the QC item identifier associated with the QC task from the MIC_QC_ITEM table.
SERVICE_RESOURCE_CD DOUBLE N This field contains the service resource code associated with the QC task.
TASK_ID DOUBLE N This field contains the unique value that identifies the QC task.
TESTING_METHOD_FLAG DOUBLE N This column indicates what type of QC item testing is associated with the QC task.
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_QC_TASK


Child Column in MIC_QC_TASK(FK) Parent Table Name Parent Column Name
Parents: QC_ITEM_ID MIC_QC_ITEM QC_ITEM_ID




Parent Column in MIC_QC_TASK (PK) Child Table Name Child Column Name
Children: TASK_ID MIC_QC_TASK_DETAIL TASK_ID


MIC_QC_TASK_DETAIL



Column Section Relationship Section Top of Page


Table-level Detail

Description: Microbiology Quality Control Task Detail
Definition: This reference table contains a record for each component related to a microbiology QC task.
Table Type: REFERENCE





Column Detail - MIC_QC_TASK_DETAIL


Column Name Type Null? Definition
ACTIVE_COND_SCHEDULE_ID DOUBLE N This column provides a unique reference back to the MIC_QC_COND_SCHEDULE table.
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_COMPONENT_CD DOUBLE N This field contains the unique identifier of the QC component associated with the QC task detail. The value will represent antibiotic.
BIOCHEMICAL_COMPONENT_CD DOUBLE N This field contains the unique identifier of the QC component associated with the QC task detail. The value will represent biochemical.
GROUP_BIOCHEMICAL_CD DOUBLE N This field contains the unique identifier of the group biochemical associated with the QC task detail. This value will only be valued if the component is a biochemical component code.
INCUBATION_HOURS_NBR DOUBLE N This column contains the number of the incubation hours required for a specific QC task detail.
INSTRUMENT_IND DOUBLE N This will indicate whether the QC results for the task need to be uploaded/downloaded from an instrument.
MEDIA_COMPONENT_CD DOUBLE N This column contains the unique identifier of the QC component associated with the QC task detail for the media components.
MIC_SUS_METHOD_CD DOUBLE N This will store the internal identifier for the susceptibility method associated with the QC task.
PANEL_CD DOUBLE N This column contains the unique identifier of the panel associated with the QC task detail.
PREACTIVE_COND_SCHEDULE_ID DOUBLE N This column contains a unique identifier to reference the MIC_QC_COND_SCHEDULE table.
SUS_DETAIL_CD DOUBLE N This column contains the unique identifier of the susceptibility detail associated with the QC task Detail.
TASK_DETAIL_ID DOUBLE N This column provides a unique identifier for the MIC_QC_TASK_DETAIL table.
TASK_ID DOUBLE N This column contains the unique identifier that ties the MIC_QC_TASK_DETAIL to the MIC_QC_TASK 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_QC_TASK_DETAIL


Child Column in MIC_QC_TASK_DETAIL(FK) Parent Table Name Parent Column Name
Parents: ACTIVE_COND_SCHEDULE_ID MIC_QC_COND_SCHEDULE COND_SCHEDULE_ID
PREACTIVE_COND_SCHEDULE_ID MIC_QC_COND_SCHEDULE COND_SCHEDULE_ID
TASK_ID MIC_QC_TASK TASK_ID




Parent Column in MIC_QC_TASK_DETAIL (PK) Child Table Name Child Column Name
Children: TASK_DETAIL_ID MIC_QC_NUMERIC_TASK_DETAIL TASK_DETAIL_ID
MIC_QC_RESULT TASK_DETAIL_ID
MIC_QC_TASK_RESULT TASK_DETAIL_ID


MIC_QC_TASK_RESULT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Microbiology Quality Control Task Result
Definition: This reference table contains a row for each task result related to a QC task detail.
Table Type: REFERENCE





Column Detail - MIC_QC_TASK_RESULT


Column Name Type Null? Definition
ABNORMAL_IND DOUBLE N This field indicates whether the result should be flagged as normal or abnormal.
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.
BIOCHEMICAL_RESULT_CD DOUBLE N This column contains the abnormal/normal result related to a biochemical QC detail task.
MEDIA_RESULT_CD DOUBLE N This column contains the abnormal/normal result related to a media QC detail task.
SUS_ALPHA_RESULT_CD DOUBLE N This column contains the abnormal/normal result related to a susceptibility alpha QC detail task.
SUS_INTERP_RESULT_CD DOUBLE N This column contains the abnormal/normal result related to a susceptibility interpretation QC detail task.
TASK_DETAIL_ID DOUBLE N This field contains the unique value that identifies the QC numeric detail task.
TASK_RESULT_ID DOUBLE N This is the unique identifier for the MIC_QC_TASK_RESULT 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_QC_TASK_RESULT


Child Column in MIC_QC_TASK_RESULT(FK) Parent Table Name Parent Column Name
Parents: TASK_DETAIL_ID MIC_QC_TASK_DETAIL TASK_DETAIL_ID


MIC_REF_ANG



Column Section Relationship Section Top of Page


Table-level Detail

Description: The criteria table for Auto No Growth
Definition: This table takes the combination of service resource/procedure/source and creates a unique identifier that is used to define the report and disqualification parameters for automatic no growth reporting.
Table Type: REFERENCE





Column Detail - MIC_REF_ANG


Column Name Type Null? Definition
ANG_ID DOUBLE N This field identifies a unique value for each procedure/service resource/source combination. Thisidentifier is then used to uniquely identify the parameters on tables such as mic_ang_ref_report and mic_ang_disqual tables.
AUTOMATED_IND DOUBLE N This field indicates whether or not the procedure/service resource/source combination will have automated auto no growth reporting performed for this combination. If this field is not set to Yes thenthis combination will not be included in automatic no growth report processing. Valid values include: 0 = Not include in automatic no growth report processing 1 = Included in automatic no growth re
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.
PRESUMPTIVE_POSITIVE_IND DOUBLE N This field indicates whether or not the System allows for stopping the automatic no growth process for the culture when a presumptive positive message is received from an interfaced instrument. valid values include: 1 = System allows Stopping ANG
SERVICE_RESOURCE_CD DOUBLE N This field identifies the code value of the instrument or bench for which automatic no growth times are defined.
SOURCE_CD DOUBLE N This field identifies the code_value of the source used to define auto no growth reporting parameters. All three levels of source hierarchy (source, section, category) can be used in defining auto nogrowth reporting parameters.
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_REF_ANG


Child Column in MIC_REF_ANG(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_REF_ANG (PK) Child Table Name Child Column Name
Children: ANG_ID MIC_ANG_DISQUAL ANG_ID
MIC_ANG_STATUS ANG_ID
MIC_REF_ANG_REPORT ANG_ID