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 |