Table Detail Report

MIC_REF_ANG_REPORT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Microbiology Automatic No Growth Reporting
Definition: This table contains information regarding the automatic no growth reports that should be issued for each procedure/service resource/source combination and at what time intervals the reports should besent.
Table Type: REFERENCE





Column Detail - MIC_REF_ANG_REPORT


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 are defined.
APPEND_TIME_IND DOUBLE N This field indicates whether or not the current time should be append to the end of the report taskissued. Valid values include: 0 = Do Not Append Time 1 = Append Current Time
AUTO_NEG_SEQ DOUBLE N If multiple reports are defined for a particular ang_id this field is used to sequence and uniquely identify each report. The first report defined for an ang_id is assigned sequence 1, the second report 2, etc.
BEGIN_RANGE DOUBLE N This field identifies the beginning time value for the ang report defined. If this is the first report being defined this value will always be 0.
CODED_RESPONSE_CD DOUBLE N This field identifies the coded response to be used for the report task issued for this ang_id. Coded responses are defined on code set 1022, Coded Responses.
END_RANGE DOUBLE N This field identifies the ending time value for the ang report defined. If the first report shouldbe issued after 24 hours this field would be set to 24.
GROUP_RESPONSE_ID DOUBLE N This field identifies the unique value for group response from the mic_group_response table.
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.
UNITS_CD DOUBLE N This field identifies the unit of time associated with the beginning and ending range fields. Units are defined on code set 54, Age Units.
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 N This field indicates whether or not the report task should be verified. Valid values include: 0 =Perform the report 1 = Verify the report



Relationship Detail - MIC_REF_ANG_REPORT


Child Column in MIC_REF_ANG_REPORT(FK) Parent Table Name Parent Column Name
Parents: GROUP_RESPONSE_ID MIC_GROUP_RESPONSE GROUP_RESPONSE_ID
ANG_ID MIC_REF_ANG ANG_ID
REPORT_CD MIC_TASK TASK_ASSAY_CD




Parent Column in MIC_REF_ANG_REPORT (PK) Child Table Name Child Column Name
Children: ANG_ID MIC_ANG_AUTOMATED ANG_ID
AUTO_NEG_SEQ MIC_ANG_AUTOMATED ANG_NEG_SEQ


MIC_REF_BILLING_AB



Column Section Relationship Section Top of Page


Table-level Detail

Description: Microbiology Reference Billing Antibiotic
Definition: This reference table contains a single record for every susceptibility antibiotic that needs a charge sent to billing. Charges can be sent over every time they are ordered or once per organism.
Table Type: REFERENCE





Column Detail - MIC_REF_BILLING_AB


Column Name Type Null? Definition
ANTIBIOTIC_CD DOUBLE N If an antibiotic was entered for billing, this field contains the internal identification code assigned to the antibiotic. Antibiotics are stored on code_set 1011.
ONCE_PER_ORG_IND DOUBLE N This field includes an indicator documenting whether or not the antibiotic should be billed every time or once per organism.
SERVICE_RESOURCE_CD DOUBLE N This field contains the internal identification code of the service resource to which the susceptibility antibiotic bill item is assigned. This could be used to join to the service_resource 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_REF_BILLING_AB


Child Column in MIC_REF_BILLING_AB(FK) Parent Table Name Parent Column Name
Parents: ANTIBIOTIC_CD MIC_DETAIL_TASK TASK_COMPONENT_CD
SERVICE_RESOURCE_CD SERVICE_RESOURCE SERVICE_RESOURCE_CD


MIC_REF_BILLING_PANEL



Column Section Relationship Section Top of Page


Table-level Detail

Description: Microbiology Reference Billing Panel
Definition: This reference table contains a single record for every panel defined on mic_valid_sus_panel. An indicator on the table determines if a charge needs to be sent to billing.
Table Type: REFERENCE





Column Detail - MIC_REF_BILLING_PANEL


Column Name Type Null? Definition
BILL_IND DOUBLE N This field includes an indicator documenting whether or not the panel should be billed.
PANEL_CD DOUBLE N If a panel or antibiotic was entered for billing, this field contains the internal identification code assigned to the panel/antibiotic.
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.
VALID_PANEL_ID DOUBLE N This field contains the foreign key value used to join to panel billing information stored on the mic_valid_sus_panel reference table.



Relationship Detail - MIC_REF_BILLING_PANEL


Child Column in MIC_REF_BILLING_PANEL(FK) Parent Table Name Parent Column Name
Parents: VALID_PANEL_ID MIC_VALID_SUS_PANEL VALID_PANEL_ID


MIC_REF_BILLING_SUS



Column Section Relationship Section Top of Page


Table-level Detail

Description: Microbiology Reference Billing Susceptibility
Definition: This reference table contains a single record for every susceptibility method that needs a charge sent to billing. Charges can be sent over every time they are ordered or once per organism.
Table Type: REFERENCE





Column Detail - MIC_REF_BILLING_SUS


Column Name Type Null? Definition
ONCE_PER_ORG_IND DOUBLE N This field includes an indicator documenting whether or not the susceptibility method should be billed every time or once per organism.
SERVICE_RESOURCE_CD DOUBLE N This field contains the internal identification code of the service resource to which the susceptibility method bill item is assigned. This could be used to join to the service_resource table.
SUS_METHOD_CD DOUBLE N If a susceptibility method was entered for billing, this field contains the internal identificationcode assigned to the method. Susceptibility methods are stored on code_set 65.
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_REF_BILLING_SUS


Child Column in MIC_REF_BILLING_SUS(FK) Parent Table Name Parent Column Name
Parents: SUS_METHOD_CD MIC_TASK TASK_ASSAY_CD
SERVICE_RESOURCE_CD SERVICE_RESOURCE SERVICE_RESOURCE_CD


MIC_REF_BIO_FORMAT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Microbiology reference biochmical format.
Definition: This reference table contains formats for biochemical groups defined by test site.
Table Type: REFERENCE





Column Detail - MIC_REF_BIO_FORMAT


Column Name Type Null? Definition
FORMAT_ORDER_TYPE DOUBLE Y This field stores the order type of the specified task_assay_cd at a service_resource_cd. There will be two values in this field. 0 = over, then down. 1 = down, then over.
SERVICE_RESOURCE_CD DOUBLE N This is the service resource where the biochemical format can be applied.
TASK_ASSAY_CD DOUBLE N This field identifies a unique value assigned to each task defined on the mic_task 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.
WRAP DOUBLE Y The wrap indicates the maximum number of column or rows (depending on biochemical format) before wrapping to a new column or row. A value of zero indicates no wrapping.



Relationship Detail - MIC_REF_BIO_FORMAT


Child Column in MIC_REF_BIO_FORMAT(FK) Parent Table Name Parent Column Name
Parents: TASK_ASSAY_CD MIC_TASK TASK_ASSAY_CD
SERVICE_RESOURCE_CD SERVICE_RESOURCE SERVICE_RESOURCE_CD