Table Detail Report
MIC_ANG_TIMES
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Microbiology Automatic No Growth Times |
Definition: | This table contains information regarding the times of the day when the automatic no growth reporting process should issue reports. |
Table Type: | REFERENCE |
Column Detail - MIC_ANG_TIMES
Column Name | Type | Null? | Definition |
---|---|---|---|
CATALOG_CD | DOUBLE | N | This field contains the code value assigned to the procedure as defined in the DCPtools.exe application. Ordered procedure code values are stored on code set 200 Order Catalog. |
DAY_OF_WEEK | DOUBLE | N | This field identifies the day of the week for which automatic no growth reporting are defined. Valid values include: 1 = Sunday 2 = Monday 3 = Tuesday 4 = Wednesday 5 = Thursday 6 = Friday 7 = Saturday |
PERFORM_ONLY_IND | DOUBLE | Y | This field indicates if the reports issued via the automatic no growth process should be performed or verified. Valid values include: 0 = Verify the reports 1 = Perform the reports |
PRINTER_CD | DOUBLE | N | This field identifies the code value of the printer where the ANG summary report should be printed.This field corresponds to the output destination code of the printer from the output destination table. |
PRINT_RPT_IND | DOUBLE | Y | This field indicates if a automatic no growth summary report should be generated for the specified time. Valid values include: 0 = Do not print the summary report 1 = Print the summary report |
RUN_IND | DOUBLE | Y | This field indicates if the automatic no growth process should activate and run for the time specified. Valid values include: 0 = Do not run 1 = Run |
SERVICE_RESOURCE_CD | DOUBLE | N | This field identifies the code value of the instrument or bench for which automatic no growth times are defined. |
TIME_SEQ | DOUBLE | N | This field indicates the time of day as a number between 1 and 24 as shown below: 00:00 = 1 01:00 = 2 02:00 = 3 03:00 = 4 04:00 = 5 05:00 = 6 06:00 = 7 07:00 = 8 08:00 = 9 09:00 = 10 10:00 = 11 11:00 = 12 12:00 = 13 13:00 = 14 14:00 = 15 15:00 = 16 16:00 = 17 17:00 = 18 18:00 = 19 19:00 = 20 20:00 = 21 21:00 = |
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_ANG_TIMES
Child Column in MIC_ANG_TIMES(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | CATALOG_CD | ORDER_CATALOG | CATALOG_CD |
PRINTER_CD | OUTPUT_DEST | OUTPUT_DEST_CD | |
SERVICE_RESOURCE_CD | SERVICE_RESOURCE | SERVICE_RESOURCE_CD |
MIC_BIOCHEMICAL_TEST_RESULT
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Microbiology Biochemical Test Results |
Definition: | This table contains the biochemical results for a microbiology orderable procedure. |
Table Type: | ACTIVITY |
Column Detail - MIC_BIOCHEMICAL_TEST_RESULT
Column Name | Type | Null? | Definition |
---|---|---|---|
COMMENT_SEQ | DOUBLE | Y | This field is not used at this time. |
CORRECTED_IND | DOUBLE | Y | This field is not used at this time. |
DETAIL_BIO_CD | DOUBLE | N | This field identifies the code value associated with the detail biochemical. Detail biochemicals are defined on code set 1005. |
GROUP_BIO_CD | DOUBLE | N | The Group Biochemical code is the codes set value that identifies the group biochemical task associated with the row. |
GROUP_LOT_INFORMATION_ID | DOUBLE | N | This field specifies the lot information Identifier for the group biochemical, if the biochemical is a group. The field will be 0.0 if the biochemical is a detail (if group_bio_cd = 0.0. |
LOT_INFORMATION_ID | DOUBLE | N | This field contains the unique identifier to reference the PCS_LOT_INFORMATION table. |
RESULT_CD | DOUBLE | N | This field identifies the code value of the biochemical result. Only coded result biochemicals will have this field filled out. Coded biochemical results are defined on code set 1027. |
RESULT_CURRENT_IND | DOUBLE | Y | This field is not used at this time. |
RESULT_SCHEDULE_ID | DOUBLE | N | This field contains the unique identifier of the related MIC_QC_RESULT_SCHEDULE row. |
RESULT_SEQ | 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. |
RESULT_STATUS_CD | DOUBLE | N | This field identifies the status of the biochemical result. Result statuses are defined on code set 1901. |
RESULT_TEXTUAL | VARCHAR(60) | Y | This field identifies the textual biochemical results. Coded result biochemicals will NOT have this field filled out. |
TASK_LOG_ID | DOUBLE | N | This field contains the unique value assigned to the biochemical task from the mic_task_log 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_BIOCHEMICAL_TEST_RESULT
Child Column in MIC_BIOCHEMICAL_TEST_RESULT(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | DETAIL_BIO_CD | MIC_DETAIL_TASK | TASK_COMPONENT_CD |
TASK_LOG_ID | MIC_TASK_LOG | TASK_LOG_ID | |
GROUP_LOT_INFORMATION_ID | PCS_LOT_INFORMATION | LOT_INFORMATION_ID | |
LOT_INFORMATION_ID | PCS_LOT_INFORMATION | LOT_INFORMATION_ID |
MIC_BIO_BLOCK_PROFILE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Microbiology Biochemical Block Profile |
Definition: | This reference table contains block/profile data for a specific group biochemical and detail biochemical combination. |
Table Type: | REFERENCE |
Column Detail - MIC_BIO_BLOCK_PROFILE
Column Name | Type | Null? | Definition |
---|---|---|---|
BLOCK_NUMBER | DOUBLE | N | This field contains a numeric value, which is used to group the PROFILE_NUMBER. |
DETAIL_BIOCHEMICAL_CD | DOUBLE | N | This field identifies the code value associated with the detail biochemical. |
GROUP_BIOCHEMICAL_CD | DOUBLE | N | This field identifies the code value associated with the group biochemical. |
PROFILE_NUMBER | DOUBLE | N | This field contains a numeric value, which is similar to the biotype number generated by automated systems. |
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_BIO_BLOCK_PROFILE
Child Column in MIC_BIO_BLOCK_PROFILE(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | GROUP_BIOCHEMICAL_CD | MIC_VALID_BIO_PROFILE | GROUP_BIOCHEMICAL_CD |
MIC_BIO_PROFILE
Column Section | Top of Page |
Table-level Detail
Description: | Microbiology Biochemical Profile |
Definition: | This reference table contains a combination of an organism and group biochemical for which percent positive data is defined. The actual percent positive data is contained in the MIC_BIO_PROFILE_DETAIL table. |
Table Type: | REFERENCE |
Column Detail - MIC_BIO_PROFILE
Column Name | Type | Null? | Definition |
---|---|---|---|
FREQUENCY_VALUE | DOUBLE | N | This field contains the 'typical profile' value for the group biochemical/organism combination. |
GROUP_BIOCHEMICAL_CD | DOUBLE | N | This field identifies the code value associated with the group biochemical. |
ORGANISM_CD | DOUBLE | N | This field identifies the code value associated with the organism. |
PROFILE_ID | DOUBLE | N | This field contains the internal identification code that uniquely identifies the 'percent positive' data for a group biochemical/organism combination. This value is used to join to the MIC_BIO_PROFILE_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. |
MIC_BIO_PROFILE_DETAIL
Column Section | Top of Page |
Table-level Detail
Description: | Microbiology Biochemical Profile Detail |
Definition: | This reference table contains percent positive data for a specific organism, group biochemical, and detail biochemical combination. |
Table Type: | REFERENCE |
Column Detail - MIC_BIO_PROFILE_DETAIL
Column Name | Type | Null? | Definition |
---|---|---|---|
DETAIL_BIOCHEMICAL_CD | DOUBLE | N | This field identifies the code value associated with the detail biochemical. |
NEG_FREQUENCY_VALUE | DOUBLE | Y | This field contains the calculated 'negative' frequency of the PERCENT_POS column. |
PERCENT_POS | DOUBLE | N | This field contains the organism's percentage positive value for a detail biochemical. Valid values are from 0 to 100. |
POS_FREQUENCY_VALUE | DOUBLE | Y | This field contains the calculated 'positive' frequency of the PERCENT_POS column. |
PROFILE_ID | DOUBLE | N | This field contains the foreign key value used to join to the parent MIC_BIO_PROFILE_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. |