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 |