Table Detail Report

MIC_STAT_SYSTEM_PREF



Column Section Top of Page


Table-level Detail

Description: Micro Statistical System Preferences
Definition: This statistical reference table contains the system preference information defined for a service resource.
Table Type: REFERENCE





Column Detail - MIC_STAT_SYSTEM_PREF


Column Name Type Null? Definition
BIOCHEMICAL_IND DOUBLE Y This field indicates if biochemicals are to be abstracted. 0 = biochemicals are not to be abstracted. 1 = biochemicals are to be abstracted.
FREETEXT_IND DOUBLE Y This field indicates if workcard free textis to be abstracted. 0 = workcard free textis not to be abstracted. 1 = workcard free textis to be abstracted.
NEGATIVE_PROCEDURE_IND DOUBLE Y This field indicates if negative or positive procedures are to be abstracted. 0 = negative procedures are not to be abstracted. 1 = negative procedures are to be abstracted.
OVERLAY_IND DOUBLE Y This field indicates if reports are to be abstracted using overlay. 0 = reports are to be abstracted not using overlay. 1 = reports are to be abstracted using overlay.
PERFORMED_BIO_IND DOUBLE Y This field indicates if performed biochemicals are to be abstracted. 0 = performed biochemicals are not to be abstracted. 1 = performed biochemicals are to be abstracted. If the value is 1 in this field, the value should also be 1 in biochemical_ind field.
SERVICE_RESOURCE_CD DOUBLE N This field contains the code_value of the service resource used to define system preference. The service resources are only at Institutions and Departments level.
STAIN_REPORT_IND DOUBLE Y This field indicates if stain reports are to be abstracted. 0 = stain reports are not to be abstracted. 1 = stain reports are to be abstracted.
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.


MIC_STAT_TASK



Column Section Relationship Section Top of Page


Table-level Detail

Description: Microbiology Statistical Task
Definition: This summary table is comprised of records extracted from the MIC_TASK_LOG table. This information is utilized by the Microbiology Statistical Reporting package.
Table Type: ACTIVITY





Column Detail - MIC_STAT_TASK


Column Name Type Null? Definition
ABNORMAL_IND DOUBLE Y This field indicates whether the report task included a coded response that is defined as abnormal. Valid values include: 0 = Normal 1 = Abnormal
CONTRIBUTOR_SYSTEM_CD DOUBLE N Contributor system identifies the source feed of data from which a row was populated. This is mainly used to determine how to update a set of data that may have originated from more than one source feed.
CORRELATION_IND DOUBLE Y This field indicates whether the correlation has occurred on a report task. Valid values include: 0 = No correlation 1 = Correlation
DISPLAY_ORDER DOUBLE N This field contains a numeric value that uniquely identifies the display order of the tasks associated with the orderable procedure.
DUP_ORGANISM_IND DOUBLE Y This field indicates whether an 'organism' task is considered to be a duplicate organism. The setting of the field is based on susceptibility duplicate checking rules.
EVENT_ID DOUBLE N This field contains the internal identification code for the result event to which this task is associated. This could be used to join to the CLINICAL_EVENT table.
FREETEXT_RESULT_ID DOUBLE N This field contains the internal identification code to the LONG_TEXT row, which contains a textual value for a report or a free text comment.
INSTR_ID_NBR VARCHAR(20) Y This field identifies the identification number assigned to the susceptibility task for use in identifying specimens performed on an automated susceptibility analyzer.
MOST_RECENT_REPORT_IND DOUBLE Y This field indicates whether a report task is the most recent report issued.
ORDER_DT_NBR DOUBLE N The date number when the task was ordered. Used to gather date information from the OMF_DATE table.
ORDER_DT_TM DATETIME Y This field contains the date and time at which the task was ordered.
ORDER_ID DOUBLE N This field contains the internal identification code for the order to which this task is associated. This could be used to join to the MIC_STAT_ORDER table.
ORDER_MIN_NBR DOUBLE N The minute number when the task was ordered. Used to get time information from the OMF_TIME table.
ORDER_PRSNL_ID DOUBLE N This field contains the internal identification code for the person whom ordered the task. This could be used to join to the PRSNL table.
ORGANISM_CD DOUBLE N This field identifies the code_value of the organism associated with the task. Organism observations, biochemical, ID's and susceptibility tasks are associated with an organism.
ORGANISM_QUAL DOUBLE N This field identifies a sequence number for each organism code_value entered. For example, if there are two GPC organisms identified for this procedure the first GPC organism would have an organism qualifier of "01" and the second GPC organism would have a qualifier of "02".
POSITIVE_IND DOUBLE Y This field indicates whether the report task included a coded response that is defined as positive. Valid values include: 0 = Negative 1 = Positive
RESULT_DT_NBR DOUBLE N The date number when the task was last updated. Used to gather date information from the OMF_DATE table.
RESULT_DT_TM DATETIME Y This field contains the date and time at which the task was last updated.
RESULT_MIN_NBR DOUBLE N The minute number when the task was last updated. Used to get time information from the OMF_TIME table.
RESULT_PRSNL_ID DOUBLE N This field contains the internal identification code for the person whom last updated the task. This could be used to join to the PRSNL 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. Task related code sets include: 65 = Susceptibility Methods 1000 = Reports 1002 = Group Biochemicals 1005 = Detail Biochemicals 1019 = Group Report Responses 1021 = Organisms
TASK_CLASS_FLAG DOUBLE Y This field identifies a value that determines the class associated with the task entered. Tasks are grouped into classes as a means of categorizing the tasks into logical groupings such as reports, biochemicals, etc.
TASK_LOG_ID DOUBLE N This field contains the unique value assigned to the specific task associated with the orderable procedure.
TASK_QUAL DOUBLE N This field contains a numeric value that uniquely identifies multiple occurrences of the same TASK_CD. For example if there are multiple preliminary reports on a procedure this number identifies each preliminary report uniquely. The first preliminary report would have a TASK_QUAL value of 01 and the subsequent occurrences would have the qualifier assigned in sequential order, i.e., 02, 03, 04.
TASK_STATUS_CD DOUBLE N This field identifies the current status of the task.
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.
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_TASK


Child Column in MIC_STAT_TASK(FK) Parent Table Name Parent Column Name
Parents: FREETEXT_RESULT_ID LONG_TEXT LONG_TEXT_ID
ORDER_ID MIC_STAT_ORDER ORDER_ID
ORDER_PRSNL_ID PRSNL PERSON_ID
RESULT_PRSNL_ID PRSNL PERSON_ID




Parent Column in MIC_STAT_TASK (PK) Child Table Name Child Column Name
Children: TASK_LOG_ID MIC_STAT_BIOCHEMICAL TASK_LOG_ID
MIC_STAT_FOOTNOTE TASK_LOG_ID
MIC_STAT_ORGANISM_ID TASK_LOG_ID
MIC_STAT_ORG_OBSERVATION TASK_LOG_ID
MIC_STAT_REPORT_RESPONSE ORG_TASK_LOG_ID
MIC_STAT_REPORT_RESPONSE TASK_LOG_ID
MIC_STAT_SUSCEPTIBILITY TASK_LOG_ID


MIC_SUS_DELTA_NUMERIC_RESULT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Microbiology Susceptibility Delta Checking Numeric Result
Definition: Contains the numeric result values for susceptibility results delta checking.
Table Type: REFERENCE





Column Detail - MIC_SUS_DELTA_NUMERIC_RESULT


Column Name Type Null? Definition
ANTIBIOTIC_CD DOUBLE N Code_value of the antibiotic used to define susceptibility delta checking value criteria.
BEGIN_RANGE DOUBLE N This field indicates the beginning value in the range. This value cannot exceed the maximum value defined for the numeric susceptibility detail.
END_RANGE DOUBLE N This field indicates the ending value in the range. This value cannot exceed the maximum value defined for the numeric susceptibility detail.
SUS_DELTA_VALUE_ID DOUBLE N This field contains a foreign key value used to join susceptibility delta checking value information.
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.
VALUE_NBR DOUBLE N This field indicates the delta checking value assigned to the particular result.



Relationship Detail - MIC_SUS_DELTA_NUMERIC_RESULT


Child Column in MIC_SUS_DELTA_NUMERIC_RESULT(FK) Parent Table Name Parent Column Name
Parents: SUS_DELTA_VALUE_ID MIC_SUS_DELTA_VALUE SUS_DELTA_VALUE_ID


MIC_SUS_DELTA_PARAMETER



Column Section Relationship Section Top of Page


Table-level Detail

Description: Microbiology Susceptibility Delta Checking Parameter Antibiotic
Definition: Contains antibiotic and parameter information for susceptibility delta checking.
Table Type: REFERENCE





Column Detail - MIC_SUS_DELTA_PARAMETER


Column Name Type Null? Definition
ACROSS_ENCOUNTER_IND DOUBLE Y This field indicates if delta checking should occur within encounters or across encounters. Default 0 = delta checking should be within encounters. 1 = delta checking should be across encounters.
ACROSS_SOURCE_IND DOUBLE Y This field indicates if delta checking should occur within the same source or across sources. Default 0 = delta checking should be within sources. 1 = delta checking should be across sources.
ANTIBIOTIC_CD DOUBLE N Code_value of the antibiotic used to define susceptibility delta checking parameter criteria.
LOOKBACK_HOURS_NBR DOUBLE N How many days to look back for delta checking from the update date and time of the current susceptibility method. This column will only be valued if the across_encounter_ind = 1.
REQUIRE_FOOTNOTE_IND DOUBLE Y Indicates if a delta checking failure requires the user to enter a footnote. Default 0 = no footnote required. 1= footnote required.
SHOW_MESSAGE_IND DOUBLE Y Indicates if the delta checking warning message should be displayed when a failure occurs. Default 0 = do not show warning message. 1 = show warning message.
SUS_DELTA_PARAM_ID DOUBLE N Unique value that identifies susceptibility delta checking parameter criteria.
TOLERANCE_LIMIT_NBR DOUBLE N The tolerance limit for the delta checking values.
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_SUS_DELTA_PARAMETER


Child Column in MIC_SUS_DELTA_PARAMETER(FK) Parent Table Name Parent Column Name
Parents: SUS_DELTA_PARAM_ID MIC_SUS_DELTA_PARAM_CRITERIA SUS_DELTA_PARAM_ID




Parent Column in MIC_SUS_DELTA_PARAMETER (PK) Child Table Name Child Column Name
Children: ANTIBIOTIC_CD MIC_SUS_DELTA_XREF ANTIBIOTIC_CD
SUS_DELTA_PARAM_ID MIC_SUS_DELTA_XREF SUS_DELTA_PARAM_ID


MIC_SUS_DELTA_PARAM_CRITERIA



Column Section Relationship Section Top of Page


Table-level Detail

Description: Microbiology Susceptibility Delta Checking Parameters
Definition: This reference table contains criteria information for susceptibility delta checking parameters.
Table Type: REFERENCE





Column Detail - MIC_SUS_DELTA_PARAM_CRITERIA


Column Name Type Null? Definition
ORGANISM_CD DOUBLE N Code_value of the organism used to define susceptibility delta checking parameter criteria.
SERVICE_RESOURCE_CD DOUBLE N Code_value of the service resource used to define susceptibility delta checking parameter criteria.
SOURCE_CD DOUBLE N Code_value of the source used to define susceptibility delta checking parameter criteria.
SUS_DELTA_PARAM_ID DOUBLE N Unique value that identifies susceptibility delta checking parameter criteria.
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_SUS_DELTA_PARAM_CRITERIA




Parent Column in MIC_SUS_DELTA_PARAM_CRITERIA (PK) Child Table Name Child Column Name
Children: SUS_DELTA_PARAM_ID MIC_SUS_DELTA_PARAMETER SUS_DELTA_PARAM_ID