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 |