Table Detail Report

MIC_POS_STAIN_REPORT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Microbiology Positive Stain Report
Definition: This reference table contains a single record for every positive stain included in the PathNet Microbiology system. It is a child table to mic_pos_stain.
Table Type: REFERENCE





Column Detail - MIC_POS_STAIN_REPORT


Column Name Type Null? Definition
POS_STAIN_ID DOUBLE N This field contains a foreign key value used to join positive stain information stored on the mic_pos_stain table.
TASK_CD DOUBLE N This field contains the code value assigned to the task. This code value can come from several code sets depending on the type of task entered.
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_POS_STAIN_REPORT


Child Column in MIC_POS_STAIN_REPORT(FK) Parent Table Name Parent Column Name
Parents: POS_STAIN_ID MIC_POS_STAIN POS_STAIN_ID


MIC_QC_BIO_TEST_RESULT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Microbiology Quality Control Test Result
Definition: Contains the biochemical results for a microbiology quality control organism
Table Type: ACTIVITY





Column Detail - MIC_QC_BIO_TEST_RESULT


Column Name Type Null? Definition
DETAIL_BIOCHEMICAL_CD DOUBLE N The code set value that identifies the detail biochemical task associated with the row. (CS 1004)
GROUP_BIOCHEMICAL_CD DOUBLE N The code set value that identifies the group biochemical task associated with the row. (CS 1002)
QC_ORGANISM_ID DOUBLE N Unique internal identification ID assigned to the ordered quality control organism.
RESULT_CD DOUBLE N Identifies the code value of the biochemical result. (CS 1027)
RESULT_STATUS_CD DOUBLE N Identifies the status of the biochemical result. (CS 1901)
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_BIO_TEST_RESULT


Child Column in MIC_QC_BIO_TEST_RESULT(FK) Parent Table Name Parent Column Name
Parents: QC_ORGANISM_ID MIC_QC_ORGANISM QC_ORGANISM_ID


MIC_QC_COND_SCHEDULE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Micro Quality Control Conditional Schedule
Definition: This reference table contains a record for each microbiology QC conditional schedule.
Table Type: REFERENCE





Column Detail - MIC_QC_COND_SCHEDULE


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.
COND_SCHEDULE_ID DOUBLE N This field contains the unique value that identifies the QC conditional schedule.
COND_SCHEDULE_NAME VARCHAR(40) N This field contains the unique name for the QC conditional schedule.
COND_SCHEDULE_NAME_KEY VARCHAR(40) N This field is the same as the cond_schedule_name field, only converted to uppercase.
COND_SCHEDULE_NAME_KEY_A_NLS VARCHAR(160) Y COND_SCHEDULE_NAME_KEY_A_NLS column
COND_SCHEDULE_NAME_KEY_NLS VARCHAR(82) N This field is the cond_schedule_name_key with the length doubled and 2 added, for the purpose of sorting non-English.
PREACTIVE_IND DOUBLE N This field indicates whether a conditional schedule can be used only with pre-active lots.
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_COND_SCHEDULE




Parent Column in MIC_QC_COND_SCHEDULE (PK) Child Table Name Child Column Name
Children: COND_SCHEDULE_ID MIC_QC_NODE COND_SCHEDULE_ID
MIC_QC_TASK_DETAIL ACTIVE_COND_SCHEDULE_ID
MIC_QC_TASK_DETAIL PREACTIVE_COND_SCHEDULE_ID


MIC_QC_ITEM



Column Section Relationship Section Top of Page


Table-level Detail

Description: Microbiology Quality Control Item
Definition: This reference table contains the items that can be used and tracked for microbiology QC.
Table Type: REFERENCE





Column Detail - MIC_QC_ITEM


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.
MAXIMUM_SUB_NBR DOUBLE N This field contains the maximum number of times a QC organism can be sub cultured. This field should only be valued if the organism_ind = 1.
ORGANISM_IND DOUBLE N This field indicates whether a QC item is an organism.
QC_ITEM_ID DOUBLE N This field contains the unique value that identifies the QC item.
QC_ITEM_NAME VARCHAR(40) N This field contains the unique name for the QC name.
QC_ITEM_NAME_KEY CHAR(40) N This field is the same as the QC_ITEM_NAME field, only it is converted to uppercase.
QC_ITEM_NAME_KEY_A_NLS VARCHAR(160) Y QC_ITEM_NAME_KEY_A_NLS column
QC_ITEM_NAME_KEY_NLS CHAR(82) N This field is the same as the QC_ITEM_NAME_KEY field, only it is 2 x the length + 2. It is used to sort columns in non English environments.
SCHEDULE_ID DOUBLE N This field contains the foreign key reference back to MIC_QC_SCHEDULE.
SUB_MEDIA_TEXT VARCHAR(40) Y This field contains a text description of the media being used for a QC organism. This field should only be valued if the organism_ind = 1.
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_ITEM


Child Column in MIC_QC_ITEM(FK) Parent Table Name Parent Column Name
Parents: SCHEDULE_ID MIC_QC_SCHEDULE SCHEDULE_ID




Parent Column in MIC_QC_ITEM (PK) Child Table Name Child Column Name
Children: QC_ITEM_ID MIC_QC_TASK QC_ITEM_ID


MIC_QC_NODE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Microbiology Quality Control Node
Definition: This reference table contains QC schedules and their relationships to other QC schedules/rules.
Table Type: REFERENCE





Column Detail - MIC_QC_NODE


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.
COND_SCHEDULE_ID DOUBLE N This field contains the foreign key value used to join to the parent MIC_QC_COND_SCHEDULE table.
DISPLAY_ORDER DOUBLE N This field contains the display order of the individual nodes.
NODE_ID DOUBLE N This field contains the internal identification code that uniquely identifies the 'schedule step' and its associated parameters.
PARENT_NODE_ID DOUBLE N This field contains the reference to the parent MIC_QC_NODE row. This field defines relationships to schedule nodes within a conditional schedule pathway.
SCHEDULE_ID DOUBLE N This field contains the internal identification code of the schedule. A schedule_id only exist once within a pathway of a conditional schedule.
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


Child Column in MIC_QC_NODE(FK) Parent Table Name Parent Column Name
Parents: COND_SCHEDULE_ID MIC_QC_COND_SCHEDULE COND_SCHEDULE_ID
SCHEDULE_ID MIC_QC_SCHEDULE SCHEDULE_ID




Parent Column in MIC_QC_NODE (PK) Child Table Name Child Column Name
Children: NODE_ID MIC_QC_RESULT CURRENT_NODE_ID
MIC_QC_RESULT PREVIOUS_NODE_ID