Table Detail Report
MIC_SCRIPT_CRITERIA
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Microbiology Script Criteria |
Definition: | This reference table contains the criteria that an associated script is assigned to. |
Table Type: | REFERENCE |
Column Detail - MIC_SCRIPT_CRITERIA
Column Name | Type | Null? | Definition |
---|---|---|---|
BODY_SITE_CD | DOUBLE | N | This field contains the internal identification code of the 'body site' to which the MIC_SCRIPT is assigned. |
CATALOG_CD | DOUBLE | N | This field contains the internal identification code of the orderable procedure to which the MIC_SCRIPT is assigned. This could be used to join to the ORDER_CATALOG table. |
ORGANISM_CD | DOUBLE | N | This field contains the internal identification code of the 'organism' to which the MIC_SCRIPT is assigned. |
ORGANISM_QUANTITY_CD | DOUBLE | N | This field contains the internal identification code of the 'organism quantity' to which the MIC_SCRIPT is assigned. |
PATIENT_LOCATION_CD | DOUBLE | N | This field contains the internal identification code of the patient location to which the MIC_SCRIPT is assigned. This could be used to join to the LOCATION table. |
SCRIPT_ID | DOUBLE | N | This field contains the foreign key value used to join to the parent MIC_SCRIPT table. |
SERVICE_RESOURCE_CD | DOUBLE | N | This field contains the internal identification code of the service resource to which the MIC_SCRIPT is assigned. This could be used to join to the SERVICE_RESOURCE table. |
SOURCE_CD | DOUBLE | N | This field contains the internal identification code of the 'source' to which the MIC_SCRIPT is assigned. |
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_SCRIPT_CRITERIA
Child Column in MIC_SCRIPT_CRITERIA(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | SCRIPT_ID | MIC_SCRIPT | SCRIPT_ID |
MIC_SCRIPT_NODE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Microbiology Script Node |
Definition: | This reference table contains biochemical tasks and their relationships to other biochemical tasks in order to defined pathways for a script. |
Table Type: | REFERENCE |
Column Detail - MIC_SCRIPT_NODE
Column Name | Type | Null? | Definition |
---|---|---|---|
BIOCHEMICAL_TASK_CD | DOUBLE | N | This field contains the internal identification code of the biochemical task, both group and detail biochemicals are valid. A biochemical task can only exist once within a pathway of a script. |
NODE_ID | DOUBLE | N | This field contains the internal identification code that uniquely identifies the 'biochemical step' and its associated parameters. This value is used to join to the MIC_SCRIPT_NODE_* tables. |
PARENT_NODE_ID | DOUBLE | N | This field contains the reference to the parent MIC_SCRIPT_NODE row. This field defines relationships to biochemical nodes within a script pathway. |
SCRIPT_ID | DOUBLE | N | This field contains the foreign key value used to join to the parent MIC_SCRIPT 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_SCRIPT_NODE
Child Column in MIC_SCRIPT_NODE(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | SCRIPT_ID | MIC_SCRIPT | SCRIPT_ID |
PARENT_NODE_ID | MIC_SCRIPT_NODE | NODE_ID |
Parent Column in MIC_SCRIPT_NODE (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | NODE_ID | MIC_SCRIPT_NODE | PARENT_NODE_ID |
MIC_SCRIPT_NODE_ACTION | NODE_ID | ||
MIC_SCRIPT_NODE_RESULT | NODE_ID |
MIC_SCRIPT_NODE_ACTION
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Microbiology Script Node Action |
Definition: | This reference table contains actions that will be taken when the defined results are entered for the parent biochemical (MIC_SCRIPT_NODE). |
Table Type: | REFERENCE |
Column Detail - MIC_SCRIPT_NODE_ACTION
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTION_ID | DOUBLE | N | This field contains the internal identification code that uniquely identifies the 'biochemical node action'. |
ACTION_TYPE_FLAG | DOUBLE | N | This field is used to identify the type of action. Valid actions include: ordering microbiology task, displaying a message box, and adding a free-text comment. |
DISPLAY_ORDER | DOUBLE | N | This field is used to determine the order in which the actions are taken. |
LONG_TEXT_ID | DOUBLE | N | This field contains the internal identification code to the LONG_TEXT row, which contains a textual value for a message box and free-text comment action. |
NODE_ID | DOUBLE | N | This field contains the internal identification code to the parent MIC_SCRIPT_NODE row. |
TASK_CD | DOUBLE | N | This field contains the internal identification code to a microbiology task. Valid 'action' tasks include: susceptibilities, reports, automated identifications, and organism name changes. |
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_SCRIPT_NODE_ACTION
Child Column in MIC_SCRIPT_NODE_ACTION(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | LONG_TEXT_ID | LONG_TEXT | LONG_TEXT_ID |
NODE_ID | MIC_SCRIPT_NODE | NODE_ID |
MIC_SCRIPT_NODE_RESULT
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Microbiology Script Node Result |
Definition: | This reference table contains the biochemical result values for the parent biochemical (MIC_SCRIPT_NODE) which will cause associated 'actions' to be taken as well as ordering the next biochemical within a pathway. |
Table Type: | REFERENCE |
Column Detail - MIC_SCRIPT_NODE_RESULT
Column Name | Type | Null? | Definition |
---|---|---|---|
DETAIL_BIOCHEMICAL_CD | DOUBLE | N | This field contains the internal identification code of a detail biochemical task. If the biochemical_task_cd on the parent MIC_SCRIPT_NODE table is a group biochemical then this is a detail of that group, otherwise this is the same value as on the MIC_SCRIPT_NODE table. |
NODE_ID | DOUBLE | N | This field contains the internal identification code to the parent MIC_SCRIPT_NODE row. |
RESULT_CD | DOUBLE | N | This field contains the internal identification code for a biochemical result. |
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_SCRIPT_NODE_RESULT
Child Column in MIC_SCRIPT_NODE_RESULT(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | NODE_ID | MIC_SCRIPT_NODE | NODE_ID |
MIC_SCRIPT_TECH
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Microbiology Script Tech |
Definition: | This reference table contains Microbiology techs for which the associated script will or will not (exclude) run. |
Table Type: | REFERENCE |
Column Detail - MIC_SCRIPT_TECH
Column Name | Type | Null? | Definition |
---|---|---|---|
SCRIPT_ID | DOUBLE | N | This field contains the foreign key value used to join to the parent MIC_SCRIPT table. |
TECH_PRSNL_ID | DOUBLE | N | This field contains the foreign key value used to join to the PRSNL table. This value is used to determine whether a tech can run a script or not. |
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_SCRIPT_TECH
Child Column in MIC_SCRIPT_TECH(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | SCRIPT_ID | MIC_SCRIPT | SCRIPT_ID |
TECH_PRSNL_ID | PRSNL | PERSON_ID |