Table Detail Report
MIC_SEQ_REPORT_R
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Microbiology Sequence Report Relationship |
Definition: | This reference table contains relationships between Microbiology Sequences and Microbiology Statistical and Management reports. This relationship defines which reports are available for a specific sequence. |
Table Type: | REFERENCE |
Column Detail - MIC_SEQ_REPORT_R
Column Name | Type | Null? | Definition |
---|---|---|---|
REPORT_CD | DOUBLE | N | This field contains the internal identification code of a Microbiology Statistical report. This could be used to join to the CODE_VALUE table. |
SEQUENCE_ID | DOUBLE | N | This field contains the internal identification code of a Microbiology sequence. This could be used to join to the MIC_SEQUENCE 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_SEQ_REPORT_R
Child Column in MIC_SEQ_REPORT_R(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | SEQUENCE_ID | MIC_SEQUENCE | SEQUENCE_ID |
MIC_SEQ_SERVICE_RESOURCE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Microbiology Sequence Service Resource |
Definition: | This reference table contains the service resources associated with a sequence. |
Table Type: | REFERENCE |
Column Detail - MIC_SEQ_SERVICE_RESOURCE
Column Name | Type | Null? | Definition |
---|---|---|---|
SEQUENCE_ID | DOUBLE | N | This field contains the foreign key value used to join to sequence information stored on the mic_sequence reference table. |
SERVICE_RESOURCE_CD | DOUBLE | N | This field contains the internal identification code of the service resource to which the sequence is assigned. This could be used to join to the service_resource 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_SEQ_SERVICE_RESOURCE
Child Column in MIC_SEQ_SERVICE_RESOURCE(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | SEQUENCE_ID | MIC_SEQUENCE | SEQUENCE_ID |
MIC_SEQ_SORT
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Microbiology Sequence Sort |
Definition: | This reference table contains the sorts associated with a sequence. |
Table Type: | REFERENCE |
Column Detail - MIC_SEQ_SORT
Column Name | Type | Null? | Definition |
---|---|---|---|
ASCENDING_IND | DOUBLE | Y | This indicator value specifies whether or not the report generated from the sequence should be ordered ascending or descending by the associated sort field. |
PAGE_BREAK_IND | DOUBLE | Y | This indicator value specifies whether or not the report generated from the sequence should page break on the associated sort field. |
SEQUENCE_ID | DOUBLE | N | This field contains the foreign key value used to join to sequence information stored on the mic_sequence reference table. |
SORT_CD | DOUBLE | N | If a sort was entered for the sequence, this field contains the internal identification code assigned to the sort. Sorts are stored on code_set 25213. |
SORT_SEQ | DOUBLE | Y | This field contains a numeric value that is used to order sorts used for a sequence. For example, this field would be used to sequence service resource #1 and task date/time #2. |
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_SEQ_SORT
Child Column in MIC_SEQ_SORT(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | SEQUENCE_ID | MIC_SEQUENCE | SEQUENCE_ID |
MIC_STAIN_CORRELATION
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Microbiology Stain Correlation |
Definition: | This reference table contains a single record for every correlation check for a stain at a service resource that needs to occur. |
Table Type: | REFERENCE |
Column Detail - MIC_STAIN_CORRELATION
Column Name | Type | Null? | Definition |
---|---|---|---|
CATALOG_CD | DOUBLE | N | This field contains the internal identification code of the procedure to which the correlation is assigned. This could be used to join to the order_catalog table. |
FAILURE_REASON_CD | DOUBLE | N | This field contains the internal identification code assigned to the type of failure the correlation rule is checking. |
FORMAT_CD | DOUBLE | N | This field contains the internal identification code assigned to display format of the correlation message. |
SERVICE_RESOURCE_CD | DOUBLE | N | This field contains the internal identification code of the service resource to which the sequence is assigned. This could be used to join to the service_resource table. |
STAIN_CD | DOUBLE | N | This field contains the internal identification code assigned to the stain associated for this correlation rule. Reports are stored on code_set 1000 and set up as a 'stain' on the mic_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_STAIN_CORRELATION
Child Column in MIC_STAIN_CORRELATION(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | CATALOG_CD | ORDER_CATALOG | CATALOG_CD |
SERVICE_RESOURCE_CD | SERVICE_RESOURCE | SERVICE_RESOURCE_CD |
MIC_STAT_ARCHIVE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Microbiology Statistical Archive |
Definition: | This table contains Microbiology orders, which require archiving into the Microbiology statistical data model. |
Table Type: | ACTIVITY |
Column Detail - MIC_STAT_ARCHIVE
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTION_FLAG | DOUBLE | N | This field identifies the level of at which level this order needs to be archived. |
ORDER_ID | DOUBLE | N | This field contains the unique value assigned to each orderable procedure associated with an order. For example: if there are two procedures on the same accession number, then each procedure will have a unique order id. |
PROCESS_ID | DOUBLE | N | This field contains the internal identification code of the process, which triggered the archiving of the order. This field contains a non-zero value only when archiving is triggered from the Statistical Preference tool. This could be used to join to the MIC_STAT_PROCESS 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_STAT_ARCHIVE
Child Column in MIC_STAT_ARCHIVE(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | PROCESS_ID | MIC_STAT_PROCESS | PROCESS_ID |
ORDER_ID | ORDERS | ORDER_ID |