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.