Table Detail Report
MIC_CANCEL_REASON
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Microbiology Cancellation Reason |
Definition: | This table contains information regarding canceled microbiology tasks. |
Table Type: | ACTIVITY |
Column Detail - MIC_CANCEL_REASON
Column Name | Type | Null? | Definition |
---|---|---|---|
CANCEL_REASON_CD | DOUBLE | N | This field identifies the code value of code cancelation reason assigned to this task. Cancel reasons are defined on code set 1309. |
CREDIT_IND | DOUBLE | N | This field indicates whether or not the task being cancelled is to be credited for any charges that have already been incurred. Valid values include: 0 = Not credited 1= Credited |
DETAIL_SEQ | DOUBLE | N | This field when used with the task_log_id to query the mic_sus_order_detail table will identify thedetail susceptibility components that were cancelled. |
TASK_LOG_ID | DOUBLE | N | This field identifies the unique value assigned to the task from the mic_task_log table thus identifying the task being cancelled. |
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_CANCEL_REASON
Child Column in MIC_CANCEL_REASON(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | TASK_LOG_ID | MIC_TASK_LOG | TASK_LOG_ID |
MIC_CORRELATION_FOOTNOTE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Microbiology Correlation Footnote |
Definition: | This activity table contains all correlation warnings and/or actions that have occured on the specified report. This table is directly tied to the MIC_REPORT_RESPONSE table. |
Table Type: | ACTIVITY |
Column Detail - MIC_CORRELATION_FOOTNOTE
Column Name | Type | Null? | Definition |
---|---|---|---|
CORR_TASK_LOG_ID | DOUBLE | N | This field is used to correlate report footnotes to the previous report. |
FAILURE_REASON_CD | DOUBLE | N | This field contains the internal identification code assigned to the type of failure the correlation rule is checking. |
LONG_TEXT_ID | DOUBLE | N | This field identifies the long_text_id associated with the correlation footnote. The footnote text will be stored on the long_text table in an already formatted form so applications can pull this formatted text to display. |
NEW_IND | DOUBLE | N | Indicates whether the footnote is newly added or added onto a previous version of the report. |
ORG_TASK_LOG_ID | DOUBLE | N | This field is used to correlate report footnotes to linked organism responses in the mic_report_responses table. |
RESPONSE_SEQ | DOUBLE | N | This field contains the unique value assigned to the report response from the mic_report_response table thus associating the footnote with the appropriate report response. |
SEQUENCE | DOUBLE | N | This field contains the unique value assigned to the correlation footnote which along with the TASK_LOG_ID and RESPONSE_SEQ make up the unique key for this table. The sequence is also the footnote number in a chart view. |
TASK_LOG_ID | DOUBLE | N | This field contains the unique value assigned to the report task from the mic_report_response table thus associating the footnote with the appropriate report 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. |
WARNING_IND | DOUBLE | N | This field contains a value indicating that the correlation check issued a warning or appended a footnote to the end of the report. |
Relationship Detail - MIC_CORRELATION_FOOTNOTE
Child Column in MIC_CORRELATION_FOOTNOTE(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | LONG_TEXT_ID | LONG_TEXT | LONG_TEXT_ID |
RESPONSE_SEQ | MIC_REPORT_RESPONSE | RESPONSE_SEQ | |
TASK_LOG_ID | MIC_REPORT_RESPONSE | TASK_LOG_ID | |
CORR_TASK_LOG_ID | MIC_TASK_LOG | TASK_LOG_ID | |
ORG_TASK_LOG_ID | MIC_TASK_LOG | TASK_LOG_ID |
MIC_DETAIL_TASK
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Microbiology Detail Tasks |
Definition: | This table contains the detail components of group level tasks defined within the database. Detailcomponents of groups are also located on the mic_task table. |
Table Type: | REFERENCE |
Column Detail - MIC_DETAIL_TASK
Column Name | Type | Null? | Definition |
---|---|---|---|
CHART_BY_TRADE_IND | DOUBLE | Y | This field is not used at this time. |
CODED_RSLT_IND | DOUBLE | Y | This field indicates if the detail biochemical will utilize coded results or be a free-text biochemical. Valid values include: 0 = Free-text result 1 = Coded result |
MAX_VALUE | DOUBLE | Y | This field defines the maximum numeric value that can be entered for a task type 6 - Numeric Sensi Detail procedure. The maximum value is defined in the Susceptibility Tool. |
MED_TYPE | DOUBLE | Y | This field identifies the type of medication defined. Valid values include: 0 = Antibiotic 1 = Antifungal 2 = Antiviral |
NBR_DECIMALS | DOUBLE | Y | This field defines the number of decimal positions to be included in the result of a task type 6 - Numeric Sensi Detail procedure. |
NBR_DIGITS | DOUBLE | Y | This field defines the maximum number of digits that can be entered for the result of a task type 6 - Numeric Sensi Detail procedure. |
SUPPRESS_IND | DOUBLE | Y | This field indicates whether or not the susceptibility detail or antibiotic will be suppressed fromdisplaying in inquiry applications or included on patient reports. Valid values include: 0 = Chart 1 = Do not chart |
TASK_COMPONENT_CD | DOUBLE | N | This field identifies the code_value of the detail task. Valid detail tasks include biochemicals, susceptibility detail procedures and antibiotics. |
TASK_TYPE_FLAG | DOUBLE | Y | This field identifies a value that determines the task type associated with the task entered. The task type further categorizes similar tasks within each task class. For example the task class biochemicals has two task type associated: (3)Group Biochemicals and (4)Detail Biochemicals. |
UNITS_CD | DOUBLE | N | This field defines the units of measure associated with the task type 6 - Numeric Sensi Detail procedure. Units of measure are defined on code set 54 Units of Measure. |
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_DETAIL_TASK
Parent Column in MIC_DETAIL_TASK (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | TASK_COMPONENT_CD | MIC_ABN_SUS_RESULT | SUS_DETAIL_CD |
MIC_BIOCHEMICAL_TEST_RESULT | DETAIL_BIO_CD | ||
MIC_EVENT_DETAIL | DETAIL_SUS_CD | ||
MIC_INTERP | INTERP_TEST_CD | ||
MIC_MEDICATION_RANGE | MEDICATION_CD | ||
MIC_MEDS_ACTIVITY | MEDICATION_CD | ||
MIC_MED_TRADE_NAME | TASK_COMPONENT_CD | ||
MIC_REF_BILLING_AB | ANTIBIOTIC_CD | ||
MIC_REQUIRED_TASK | ANTIBIOTIC_CD | ||
MIC_REQUIRED_TASK | DETAIL_CD | ||
MIC_RESULT_FOOTNOTE_R | ANTIBIOTIC_CD | ||
MIC_SUS_FIRST_LEVEL_INTERP | MEDICATION_CD | ||
MIC_SUS_FIRST_LEVEL_INTERP | SUS_DETAIL_CD | ||
MIC_SUS_MED_RESULT | PANEL_MEDICATION_CD | ||
MIC_SUS_ORDER_DETAIL | DETAIL_SUS_CD | ||
MIC_TASK_DETAIL_R | TASK_COMPONENT_CD | ||
MIC_VALID_BIOCHEM_RESULT | TASK_COMPONENT_CD | ||
MIC_VALID_SUS_RESULT | SUS_TYPE_CD | ||
MIC_VALID_SUS_RESULT | TASK_COMPONENT_CD |
MIC_ERR_DATA_R
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Table that connects the mic_err_script to the long_text table. |
Definition: | If a particular error has data that it wants to store with it this table can handle multiple records from the long_text table. |
Table Type: | ACTIVITY |
Column Detail - MIC_ERR_DATA_R
Column Name | Type | Null? | Definition |
---|---|---|---|
DATA_ID | DOUBLE | N | Hook to the mic_err_script table that will attach the records on the long_text table to an error |
DATA_TEXT_ID | DOUBLE | N | Hook to the long_text table that will store the data for the error. |
DESCRIPTION | VARCHAR(12) | Y | Description of the data in the long_text table that this record refers to. |
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_ERR_DATA_R
Child Column in MIC_ERR_DATA_R(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | DATA_TEXT_ID | LONG_TEXT | LONG_TEXT_ID |
MIC_ERR_SCRIPT
Column Section | Top of Page |
Table-level Detail
Description: | MIC ERR SCRIPT |
Definition: | ERROR TABLE FOR FORMAT SCRIPTS. |
Table Type: | ACTIVITY |
Column Detail - MIC_ERR_SCRIPT
Column Name | Type | Null? | Definition |
---|---|---|---|
APPLICATION_NAME | VARCHAR(100) | Y | NAME OF THE APPLICATION THAT ERRORED OUT. |
DATA_ID | DOUBLE | N | Unique number to identify the groups of records that will be stored on the mic_err_data_r table. |
LOCATION | VARCHAR(40) | Y | iDENTIFIER IN SCRIPT WHERE IT ERRORED OUT. |
LOGICAL_IND | DOUBLE | N | INDICATOR TO DETERMINE IF THE ERROR IS A LOGICAL ERROR OR A CCL ERROR. |
MESSAGE | VARCHAR(255) | Y | The error that occurred. |
SCRIPT_NAME | VARCHAR(30) | N | NAME OF THE SCRIPT WHERE THE ERROR OCCURED. |
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. |
USER_NAME | VARCHAR(100) | Y | THE NAME OF THE USER. |