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 |