User talk:Bmckown

Proposed OpenMRS Mascot

Form2Program Module

Notes for expansion of form2program module (my earlier edit of this section did not get saved)

create table form2program_transition (
 program_id int(11) NOT NULL,
 program_workflow_id int(11) NOT NULL,
 program_workflow_state_id int(11) NOT NULL,
 form2program_action_id int(11) NOT NULL,
 from_state int(11) NOT NULL,
 to_state int(11) NOT NULL
 )

create table form2program_action (
 form2program_action_id int(11) NOT NULL,
 action_name varchar(250),
 action_parent int(11),
 concept_id int(11),
 value_coded int(11),
 value_drug int(11),
 value_datetime datetime,
 value_numeric float(15),
 value_modifier varchar(2),
 value_text text
 ) 

Program Workflow

ProgramWorkflowTransition Table right now. Pro: Flexibility. Con: No foreign key dependency for rule (transition_id, transition_class).

create table program_workflow_transition (
 transition_id int(11) NOT NULL,
 transition_class varchar(255) NOT NULL,
 program_workflow_id int(11) NOT NULL,
 current_state int(11) NOT NULL,
 next_state int(11) NOT NULL,
 creator int(11) NOT NULL,
 date_created datetime NOT NULL,
 changed_by int(11) NOT NULL,
 date_changed datetime NOT NULL,
 voided tinyint(4) default NULL,
 voided_by int(11) default NULL,
 date_voided datetime default NULL,
 void_reason varchar(255) default NULL,
 PRIMARY KEY  (`transition_id`,`transition_class`,`program_workflow_id`,`current_state`)

Possible Alternative: (This is a very rough estimate)

create table program_workflow_transition (
 `encounter_type_id NOT NULL, /* primary key, foreign key on encounter_type_id */
 `concept_id` NOT NULL, /* primary key, foreign key on obs.concept_id */
 `value_coded` NOT NULL, /* primary key, foreign key on obs.value_coded */
 `program_workflow_id` int(11) NOT NULL,
 `current_state` int(11) NOT NULL,
 `next_state` int(11) NOT NULL,
 `scheduled_task` /* foreign key on scheduler_task_config */
 `creator` int(11) NOT NULL,
 `date_created` datetime NOT NULL,
 `changed_by` int(11) NOT NULL,
 `date_changed` datetime NOT NULL,
 `voided` tinyint(4) default NULL,
 `voided_by` int(11) default NULL,
 `date_voided` datetime default NULL,
 `void_reason` varchar(255) default NULL,
 PRIMARY KEY  (`concept_id`,`value_coded`,`program_workflow_id`,`current_state`)

TODO: 2007-05-02 1. Blog. 2. DataDeletion Module. 3. OpenMRSBot2.

<xfeeds titlecolour="#B0C4DE" contentcolour="#eeeeee" feedlimit="3" totallimit="10"> http://blog.openmrs.org/?feed=rss2 http://blog.openmrs.org/?feed=comments-rss2 </xfeeds>