Table Detail Report
MIC_QC_NODE_OUTCOME
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Microbiology Quality Control Node Outcome |
Definition: | This reference table contains outcomes that will occur when the defined rules fail or succeed the parent schedule. |
Table Type: | REFERENCE |
Column Detail - MIC_QC_NODE_OUTCOME
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTION_STATUS_CD | DOUBLE | N | This field contains the internal identification code for the lot status change associated with the outcome. |
ACTION_TEXT_ID | DOUBLE | N | This field contains the internal identification code to the LONG_TEXT row, which contains a textual value for a corrective action. |
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. |
NODE_ID | DOUBLE | N | This field contains the internal identification code to the parent MIC_QC_NODE table. |
OUTCOME_ID | DOUBLE | N | This field contains the internal identification code that uniquely identifies the schedule node outcome. |
OUTCOME_TYPE_FLAG | DOUBLE | N | This field is used to identify the type of outcome. |
TARGET_NODE_ID | DOUBLE | N | This field contains the internal identification code to the parent MIC_QC_NODE row of the schedule that should be executed as a result of the outcome of the current schedule. |
UNSUCCESSFUL_IND | DOUBLE | N | This field indicates whether the outcome should be displayed if the corresponding rule fails or succeeds. |
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_NODE_OUTCOME
Child Column in MIC_QC_NODE_OUTCOME(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ACTION_TEXT_ID | LONG_TEXT | LONG_TEXT_ID |
MIC_QC_NODE_RULE_RELTN
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Microbiology Quality Control Node Rule Relation |
Definition: | This is an association table between MIC_QC_NODE and MIC_QC_RULE tables. |
Table Type: | REFERENCE |
Column Detail - MIC_QC_NODE_RULE_RELTN
Column Name | Type | Null? | Definition |
---|---|---|---|
NODE_ID | DOUBLE | N | This field contains a unique value that relates back to the MIC_QC_NODE table. |
NODE_RULE_ID | DOUBLE | N | This field is the unique identifier for the MIC_QC_NODE_RULE_RELTN association table. |
RULE_ID | DOUBLE | N | This field contains a unique reference back to the MIC_QC_RULE 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_NODE_RULE_RELTN
Child Column in MIC_QC_NODE_RULE_RELTN(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | RULE_ID | MIC_QC_RULE | RULE_ID |
MIC_QC_NUMERIC_TASK_DETAIL
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Microbiology Quality Control Numeric Task Detail |
Definition: | This reference table contains a record for each numeric component related to a microbiology quality control task. |
Table Type: | REFERENCE |
Column Detail - MIC_QC_NUMERIC_TASK_DETAIL
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. |
HIGH_NBR | DOUBLE | N | This field contains the high value of the numeric range of a task detail. |
LOW_NBR | DOUBLE | N | This field contains the low value of the numeric range of a task detail. |
MEAN_NBR | DOUBLE | N | This field contains the mean value of the numeric task detail. |
NUMERIC_TASK_DETAIL_ID | DOUBLE | N | This field contains the unique value for the MIC_QC_NUMERIC_TASK_DETAIL table. |
NUM_OF_STD_DEV_NBR | DOUBLE | N | This field contains the number of standard deviations away from the mean that a numeric value can fall into. |
RANGE_NBR | DOUBLE | N | This field contains the valid range of numeric values in a task detail. |
STD_DEV_NBR | DOUBLE | N | This field contains the standard deviation of the numeric task detail. |
TASK_DETAIL_ID | DOUBLE | N | This field contains the unique value that identifies the QC numeric detail 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_NUMERIC_TASK_DETAIL
Child Column in MIC_QC_NUMERIC_TASK_DETAIL(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | TASK_DETAIL_ID | MIC_QC_TASK_DETAIL | TASK_DETAIL_ID |
MIC_QC_ORGANISM
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Microbiology Quality Control Organism |
Definition: | This table stores the quality control organisms that have been ordered for resulting |
Table Type: | ACTIVITY |
Column Detail - MIC_QC_ORGANISM
Column Name | Type | Null? | Definition |
---|---|---|---|
ORGANISM_CD | DOUBLE | N | Internal identification code for the quality control organism. (CS 1021) |
QC_ORGANISM_ID | DOUBLE | N | Unique internal identification ID assigned to the ordered quality control organism. |
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_ORGANISM
Parent Column in MIC_QC_ORGANISM (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | QC_ORGANISM_ID | MIC_QC_BIO_TEST_RESULT | QC_ORGANISM_ID |
MIC_QC_RESULT
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Microbiology Quality Control Result Schedule |
Definition: | This table contains the schedule information for the Microbiology QC setup/results and sub-media tasks. |
Table Type: | ACTIVITY |
Column Detail - MIC_QC_RESULT
Column Name | Type | Null? | Definition |
---|---|---|---|
ABNORMAL_IND | DOUBLE | N | This field indicates whether or not the recorded result is abnormal based on the database settings. |
BIOCHEMICAL_RESULT_CD | DOUBLE | N | This filed contains the unique identifier for the biochemical result recorded for the scheduled QC result. |
COMMENT_TEXT_ID | DOUBLE | N | This field contains the unique identifier from the LONG_TEXT table for the associated result comment. |
CORRECTION_TEXT_ID | DOUBLE | N | This field contains the unique identifier from the LONG_TEXT table for the associated troubleshooting step. |
CURRENT_NODE_ID | DOUBLE | N | This field contains the unique identifier of the schedule node that the lot is currently associated with. |
CURRENT_SUB_NBR | DOUBLE | N | This field contains the current number of sub-media that have been created for the associated QC Item (organism). |
INSTRUMENT_IDENT | VARCHAR(20) | N | This field contains the unique identifier used to associate the instrument results back to the QC result. |
ITEM_LOT_INFO_ID | DOUBLE | N | This field contains the unique identifier of the QC Item lot associated with the scheduled QC result. |
MEDIA_RESULT_CD | DOUBLE | N | This field contains the unique identifier for the media result recorded for the scheduled QC result. |
PREVIOUS_NODE_ID | DOUBLE | N | This field contains the unique identifier of the schedule node that the lot was associated with prior to the result being entered. This value could be the same as the current_node_id |
PRIMARY_REVIEW_DT_TM | DATETIME | Y | This field contains the date and time that the initial review of the result was completed. |
PRIMARY_REVIEW_PRSNL_ID | DOUBLE | N | This field contains the unique identifier of the personnel that completed the initial review of the setup/sub-media result. |
QC_ITEM_ID | DOUBLE | N | This field contains the unique identifier for the QC result. |
RESULT_DT_TM | DATETIME | Y | This field contains the date and time that the QC setup/sub-media was completed. |
RESULT_ID | DOUBLE | N | This field contains the unique identifier for the QC result. |
RESULT_NBR | DOUBLE | N | This field contains the numeric result recorded for the scheduled QC result. |
RESULT_PERSONNEL_ID | DOUBLE | N | This field contains the unique identifier associated with the personnel that completed the associated setup/sub-media. |
RESULT_SCHEDULE_ID | DOUBLE | N | This field contains the unique identifier of the associated MIC_QC_RESULT_SCHEDULE row. |
SECONDARY_REVIEW_DT_TM | DATETIME | Y | This field contains the date and time that the second review of the result was completed. |
SECONDARY_REVIEW_PRSNL_ID | DOUBLE | N | This field contains the unique identifier of the personnel that completed the second review of the setup/sub-media result. |
SETUP_DT_TM | DATETIME | Y | This field contains the date and time that the QC setup/sub-media was completed. |
SETUP_PERSONNEL_ID | DOUBLE | N | This field contains the date and time that the QC setup/sub-media was completed. |
STATUS_CD | DOUBLE | N | This field contains the unique identifier for the current status of the QC result. |
SUS_ALPHA_RESULT_CD | DOUBLE | N | This field contains the unique identifier for the susceptibility alpha result recorded for the scheduled QC result. |
SUS_INTERP_RESULT_CD | DOUBLE | N | This field contains the unique identifier for the susceptibility interpretation result recorded for the scheduled QC result. |
TASK_DETAIL_ID | DOUBLE | N | This field contains the unique identifier form the MIC_QC_TASK_DETAIL table associated with the QC result. |
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_RESULT
Child Column in MIC_QC_RESULT(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | COMMENT_TEXT_ID | LONG_TEXT | LONG_TEXT_ID |
CORRECTION_TEXT_ID | LONG_TEXT | LONG_TEXT_ID | |
CURRENT_NODE_ID | MIC_QC_NODE | NODE_ID | |
PREVIOUS_NODE_ID | MIC_QC_NODE | NODE_ID | |
TASK_DETAIL_ID | MIC_QC_TASK_DETAIL | TASK_DETAIL_ID | |
ITEM_LOT_INFO_ID | PCS_LOT_INFORMATION | LOT_INFORMATION_ID | |
PRIMARY_REVIEW_PRSNL_ID | PRSNL | PERSON_ID | |
RESULT_PERSONNEL_ID | PRSNL | PERSON_ID | |
SECONDARY_REVIEW_PRSNL_ID | PRSNL | PERSON_ID | |
SETUP_PERSONNEL_ID | PRSNL | PERSON_ID |