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 |