Table Detail Report

MIC_STAT_BIOCHEMICAL



Column Section Relationship Section Top of Page


Table-level Detail

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





Column Detail - MIC_STAT_BIOCHEMICAL


Column Name Type Null? Definition
DETAIL_BIO_CD DOUBLE N This field identifies the code value associated with the detail biochemical.
RESULT_CD DOUBLE N This field identifies the code value of the biochemical result. This field is only valued for coded type results.
RESULT_DT_NBR DOUBLE N The date number when the biochemical result 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 biochemical result was last updated.
RESULT_MIN_NBR DOUBLE N The minute number when the biochemical result 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 biochemical result. This could be used to join to the PRSNL table.
RESULT_TEXTUAL VARCHAR(500) Y This field identifies the textual biochemical results. This field is only valued for textual type results.
SEQUENCE DOUBLE N The field contains a value that uniquely identifies each biochemical and its results. This value will allow multiples of the same biochemical to be uniquely identified.
STATUS_CD DOUBLE N This field identifies the status of the biochemical result.
TASK_LOG_ID DOUBLE N This field contains the internal identification code assigned to the biochemical task from the MIC_STAT_TASK table thus associating the biochemical result with the appropriate biochemical 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.



Relationship Detail - MIC_STAT_BIOCHEMICAL


Child Column in MIC_STAT_BIOCHEMICAL(FK) Parent Table Name Parent Column Name
Parents: TASK_LOG_ID MIC_STAT_TASK TASK_LOG_ID
RESULT_PRSNL_ID PRSNL PERSON_ID


MIC_STAT_DUPLICATE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Microbiololgy Statistical Duplicate
Definition: This table contains Microbiology orders, previously written to the Microbiology statistical data model, that require the report and susceptibility duplicate checking to be re-evaluated.
Table Type: ACTIVITY





Column Detail - MIC_STAT_DUPLICATE


Column Name Type Null? Definition
COLLECT_DT_TM DATETIME N This field contains the date and time at which the orderable procedure was collected.
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_DUPLICATE


Child Column in MIC_STAT_DUPLICATE(FK) Parent Table Name Parent Column Name
Parents: PROCESS_ID MIC_STAT_PROCESS PROCESS_ID
ORDER_ID ORDERS ORDER_ID


MIC_STAT_FOOTNOTE



Column Section Relationship Section Top of Page


Table-level Detail

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





Column Detail - MIC_STAT_FOOTNOTE


Column Name Type Null? Definition
ANTIBIOTIC_CD DOUBLE N This field contains the internal identification code for the antibiotic being tested within a susceptibility task.
CHARTABLE_IND DOUBLE Y This field indicates whether or not the susceptibility footnote is to be included on patient reports and displayed in inquiry applications. Valid values include: 0 = Not chartable 1= Chartable
EKM_IND DOUBLE Y This field indicates whether or not the susceptibility footnote has been generated from an expert knowledge module. Valid values include: 0 = Not expert knowledge module generated 1= Expert knowledge module generated
LONG_TEXT_ID DOUBLE N This field contains the internal identification code to the LONG_TEXT row, which contains a textual value for susceptibility footnote text.
TASK_LOG_ID DOUBLE N This field contains the internal identification code assigned to the susceptibility task from the MIC_STAT_TASK table thus associating the susceptibility footnote with the appropriate susceptibility 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.



Relationship Detail - MIC_STAT_FOOTNOTE


Child Column in MIC_STAT_FOOTNOTE(FK) Parent Table Name Parent Column Name
Parents: LONG_TEXT_ID LONG_TEXT LONG_TEXT_ID
TASK_LOG_ID MIC_STAT_TASK TASK_LOG_ID


MIC_STAT_GROUP



Column Section Relationship Section Top of Page


Table-level Detail

Description: Stores the Statistical Groupings.
Definition: Code set 28020 contains the different Group Types. MIC_STAT_GROUP stores specific groups for an given group type.
Table Type: REFERENCE





Column Detail - MIC_STAT_GROUP


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
DISPLAY VARCHAR(40) N This field contains the display value for the statistical grouping.
DISPLAY_KEY VARCHAR(40) N This field contains the display key which is generated from the display field (converted to Uppercase, with all spaces and special characters removed).
GROUP_TYPE_CD DOUBLE N This field contains the internal identification code that uniquely identifies the type of statistical grouping (i.e. age days, encounter type, medical service, ...).
STAT_GROUP_ID DOUBLE N This field contains the internal identification code that uniquely identifies the statistical grouping (and its associated parameters). This value is used to join to other tables, such as the MIC_STAT_GROUP_DETAIL 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_GROUP




Parent Column in MIC_STAT_GROUP (PK) Child Table Name Child Column Name
Children: STAT_GROUP_ID MIC_STAT_GROUP_DETAIL STAT_GROUP_ID


MIC_STAT_GROUP_DETAIL



Column Section Relationship Section Top of Page


Table-level Detail

Description: Stores details of a Statistical Group.
Definition: This table stores the selected details of a Statistical Group stored on MIC_STAT_GROUP.
Table Type: REFERENCE





Column Detail - MIC_STAT_GROUP_DETAIL


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
BEG_EFFECTIVE_DT_TM DATETIME N The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
END_EFFECTIVE_DT_TM DATETIME N The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
FROM_VALUE VARCHAR(250) Y This field contains the lower bound of a specified range for determining the grouping criteria.
PARENT_ENTITY_ID DOUBLE N This field contains the identifier for parent table row this statistical group detail is associated to.
PARENT_ENTITY_NAME VARCHAR(32) N This field contains the name of the table that this statistical group detail is associated to (i.e. PERSON, CODE_VALUE, ...).
SEQUENCE DOUBLE N Defines the order this detail is listed under the group.
STAT_GROUP_DETAIL_ID DOUBLE N This field contains the internal identification code that uniquely identifies the statistical grouping detail.
STAT_GROUP_ID DOUBLE N This field contains the internal identification code that uniquely identifies the statistical grouping (and its associated parameters). This value is used to join to other tables, such as the MIC_STAT_GROUP table.
TO_VALUE VARCHAR(250) Y This field contains the upper bound of a specified range for determining the grouping 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_STAT_GROUP_DETAIL


Child Column in MIC_STAT_GROUP_DETAIL(FK) Parent Table Name Parent Column Name
Parents: STAT_GROUP_ID MIC_STAT_GROUP STAT_GROUP_ID