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