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