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 |