Table Detail Report

MIC_ACT_ANG_SUM_RPT



Column Section Relationship Section Top of Page


Table-level Detail

Description: This tables houses temporary information to create the ANG Summary Report.
Definition: This table contains the content required to generate a summary report for ANG.
Table Type: ACTIVITY





Column Detail - MIC_ACT_ANG_SUM_RPT


Column Name Type Null? Definition
ANG_RUN_ID DOUBLE N This field identifies the unique value which associates this record with a particular run of the auto no growth reporting process.
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.
ENCNTR_ID DOUBLE N This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number.
ERROR_TEXT VARCHAR(150) Y This field contains the text associated with the error generated from the auto no growth process for this record.
LOAD_DT_TM DATETIME Y This field identifies either the start date and time of the orderable procedure or the initial load date and time of the media. Some blood culture instrument interfaces do not send and initial load date and time to the Cerner system, in which case the start date and time of the procedure is used inthis field.
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.
ORDER_LOCK_DT_TM DATETIME Y This field identifies the date and time the record was locked. When the user exits the microbiology application accessing the accession this field will be set to null.
ORDER_LOCK_ID DOUBLE N This field identifies the id of the person that currently has this order_id locked. The order_lock_id corresponds to the person_id on the prsnl table, which identifies the user. When the user exits the microbiology application accessing the accession this field will be set to null.
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
PRINT_REPORT_FLAG DOUBLE N This field indicates the type of error identified for the record. If this field is defined greater than 0, then the error_text field will also be defined. Valid values include: 0 = Successful 1 =Batch reporting process failed 2 = Accession locked 3 = Performed only report 4 = Report exceeds procedure's report limit 5 = Final report already issued, please review results.
PRINT_SEQ DOUBLE N This field identifies the sequence with which this record should be printed on the auto no growth summary report. If a record has already been printed on a summary report this field will be set to 0. When a record is first written to the table this field will be set to 1. As additional runs are created the previous runs print_seq number is incremented such that the records from the oldest run w
REPORT_CD DOUBLE N This field identifies the code value of the report task to be issued for this ang_id. Reports are defined on code set 1000, Microbiology Reports.
REPORT_STATUS_CD DOUBLE N This field identifies the current status of the report. The status code_value is from code set 1901Result Status.
SERVICE_RESOURCE_CD DOUBLE N This field identifies the code value of the instrument or bench for which automatic no growth times are defined.
SOURCE_CD DOUBLE N This field identifies the code_value of the source used to define auto no growth reporting parameters. All three levels of source hierarchy (source, section, category) can be used in defining auto nogrowth reporting parameters.
TASK_LOG_ID DOUBLE N This field contains the unique value assigned to the report task associated with the orderable procedure.
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_ACT_ANG_SUM_RPT


Child Column in MIC_ACT_ANG_SUM_RPT(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
ANG_RUN_ID MIC_ANG_STATUS ANG_RUN_ID
ORDER_ID MIC_ORDER_LAB ORDER_ID
REPORT_CD MIC_TASK TASK_ASSAY_CD
TASK_LOG_ID MIC_TASK_LOG TASK_LOG_ID
CATALOG_CD ORDER_CATALOG CATALOG_CD
PERSON_ID PERSON PERSON_ID
SERVICE_RESOURCE_CD SERVICE_RESOURCE SERVICE_RESOURCE_CD


MIC_ANG_AUTOMATED



Column Section Relationship Section Top of Page


Table-level Detail

Description: Activity tbl, if a record is put on here then that means a report will be order
Definition: This table contains information for each procedure for which auto no growth reporting processing should be applied.
Table Type: ACTIVITY





Column Detail - MIC_ANG_AUTOMATED


Column Name Type Null? Definition
ANG_ID DOUBLE N Hooks back to the specific ang reference record.
ANG_NEG_SEQ DOUBLE N Foreign key from mic_ref_ang_report
ANG_RUN_ID DOUBLE N This field identifies the unique value which associates this record with a particular run of the auto no growth reporting process.
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.
COMPLETE_IND DOUBLE N whether or not the report will make the order complete
END_REPORT_RANGE DOUBLE N This field identifies the ending time value for the ang report defined. If the first report was issued after 24 hours this field would be set to 24.
INSTR_RESOURCE_CD DOUBLE N This field identifies the code value of the instrument or bench for which automatic no growth times are defined.
LAST_PRINT_DT_TM DATETIME Y Date/Time that this culture was printed on a summary report.
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.
POSITIVE_IND DOUBLE N This field indicates whether or not the procedure is considered positive. Microbiology procedures are considered positive when a preliminary or final report is issued that includes a positive response or organism. Valid values include: 0 = Not positive 1 = Positive
PRINT_RPT_IND DOUBLE N This field indicates whether or not this report procedure should be printed on an auto no growth summary report. Valid values include: 0 = Do not print 1 = Print on the summary report
SERVICE_RESOURCE_CD DOUBLE N This field identifies the code value of the instrument or bench for which automatic no growth times are defined.
SOURCE_CD DOUBLE N This field identifies the code_value of the source used to define auto no growth reporting parameters. All three levels of source hierarchy (source, section, category) can be used in defining auto nogrowth reporting parameters.
START_DT_TM DATETIME N This field identifies the start date and time of the orderable procedure. This field is updated when the procedure is received into its performing service resource.
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_AUTOMATED


Child Column in MIC_ANG_AUTOMATED(FK) Parent Table Name Parent Column Name
Parents: ANG_RUN_ID MIC_ANG_STATUS ANG_RUN_ID
ORDER_ID MIC_ORDER_LAB ORDER_ID
ANG_ID MIC_REF_ANG_REPORT ANG_ID
ANG_NEG_SEQ MIC_REF_ANG_REPORT AUTO_NEG_SEQ
CATALOG_CD ORDER_CATALOG CATALOG_CD
INSTR_RESOURCE_CD SERVICE_RESOURCE SERVICE_RESOURCE_CD
SERVICE_RESOURCE_CD SERVICE_RESOURCE SERVICE_RESOURCE_CD


MIC_ANG_DISQUAL



Column Section Relationship Section Top of Page


Table-level Detail

Description: Microbiology Auto No Growth Disqaualify Codes
Definition: This table contains information regarding coded responses that will cause a procedure to be disqualified from the automatic no growth reporting process.
Table Type: REFERENCE





Column Detail - MIC_ANG_DISQUAL


Column Name Type Null? Definition
ANG_ID DOUBLE N This field identifies the unique value for each procedure/service resource/source combination assigned on the mic_ref_ang table for which automatic no growth reporting parameters and disqualifications are defined.
DISQUAL_RESPONSES_CD DOUBLE N This field identifies the code_value of the negative coded report response or organism which if issued in a report should disqualify the procedure from the automatic no growth reporting process.
DISQUAL_SEQ DOUBLE N This field is not used at this time.
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_DISQUAL


Child Column in MIC_ANG_DISQUAL(FK) Parent Table Name Parent Column Name
Parents: ANG_ID MIC_REF_ANG ANG_ID


MIC_ANG_REPORT



Column Section Top of Page


Table-level Detail

Description: Microbiology Automatic No Growth Reporting
Definition: This reference table holds the criteria and parameters for determining when a report is issued, and the coded responsed used to build the report.
Table Type: REFERENCE





Column Detail - MIC_ANG_REPORT


Column Name Type Null? Definition
ANG_ID DOUBLE N This is the value of the unique primary identifier of the MIC_ANG_REPORT table. It is an internal system assigned number.
APPEND_TIME_IND DOUBLE Y Indicates whether the system should use the system calculated time to the automatic no growth report.
AUTOMATED_IND DOUBLE Y Indicates whether the row will be performed by an automated instrument.
AUTO_NEG_SEQ DOUBLE N This is the numeric sequence that determines the uniqueness of a row when more than one automatic no growth report is associated with the the same ANG_ID.
BEGIN_RANGE DOUBLE Y Identifies the beginning time range for which the report is issued.
CATALOG_CD DOUBLE N The catalog code is the code set value that identifies the procedure that is associated with the row.
END_RANGE DOUBLE Y Identifies the ending time range for which the report is issued.
REPORT_TYPE_CD DOUBLE N The type of report.
RESPONSE_CD DOUBLE N Individual response unit
SERVICE_RESOURCE_CD DOUBLE N The Service Resource code is the code set value that identifies the location (facility,instrument, etc.) at which the procedure is performed.
SOURCE_GROUPING_CD DOUBLE N The source grouping code is the code set value that identifies the source group of the procedures associated with the ANG_ID.
UNITS_CD DOUBLE N The Units code is the code set value that identifies the time units (hours, days, weeks) that will be appended to the automatic no growth report.
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.
VERIFY_IND DOUBLE Y Indicates whether the system should verify the report.


MIC_ANG_STATUS



Column Section Relationship Section Top of Page


Table-level Detail

Description: Activity tbl, if a row is added here it means that a ANG run has occured.
Definition: The status of an ANG run.
Table Type: ACTIVITY





Column Detail - MIC_ANG_STATUS


Column Name Type Null? Definition
ANG_ID DOUBLE N This field identifies a unique value for each procedure/service resource/source combination. This identifier is then used to uniquely identify the parameters on tables such as mic_ang_ref_report and mic_ang_disqual tables.
ANG_RUN_ID DOUBLE N Uniquely Identifies an ANG Execution.
RUN_DT_TM DATETIME N Date/Time of the ANG Execution
RUN_STATUS_IND DOUBLE N Determines the status of an ANG run. 0 - Not Started, 1 - In Process, 2 - Successful, 3 - Error.
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_STATUS


Child Column in MIC_ANG_STATUS(FK) Parent Table Name Parent Column Name
Parents: ANG_ID MIC_REF_ANG ANG_ID




Parent Column in MIC_ANG_STATUS (PK) Child Table Name Child Column Name
Children: ANG_RUN_ID MIC_ACT_ANG_SUM_RPT ANG_RUN_ID
MIC_ANG_AUTOMATED ANG_RUN_ID