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.