Observations Job

All forms that are under the concept ALL OBSERVATION TEMPLATES will become separate tables in the mart database. Any multi select or add more sections under these forms will become separate tables by default. One can also choose the concepts they want to have as separate tables using separate Tables configuration in obs job.

Since we have 51 forms under All Observation Template of demo environment currently, there will be 51 separate tables. Additionally all multi select, add more sections and concepts from seperateTables config will become separate tables.

Below are the columns that are common in every form table

if we need to get those values as per the translations we need to add the below locale tag in the “/var/www/bahmni_config/bahmni-mart/bahmni-mart.json“ file.

Whenever we update the form name ( by updating concept set name in form1 and updating form name from implementer interface in form2 ) and run mart with incremental load a new table is created in mart with new form name. It also migrates the existing observation in old table to new table and any modifications to old observations or new observations are reflected/loaded into new form table only. This makes the old form table useless and inconsistent with current data in system. The old table can only be deleted by running mart on Full load.

Note: To avoid confusion it is always recommended to run mart on full load after the form name is updated.

Some Additional information in use-case view:-

1. When a form has a multi select coded answerSeparate table with the question name is created and the multi select answers are inserted in each row
2. If the same question is used in a separate form, then the data is inserted in the same table if the table is created for the multi select question.

When a form has a section which is not add more

1. The section data is inserted in the same form table without creating a new table

When a form has a section which is add more

1. Section data is inserted in a separate table.
2. Table name will be formname_Section name

When a form has a section which is not add more and a multi select coded answer

1. Section data is inserted in Form table
2. Multi select answer is inserted in a separate table

When a form has a section which is add more and a multi select coded answer

1. Section data is inserted in a separate section table
2. Multi select answer is inserted in a separate table

When the data is voided from the patient observation

1. The data is removed from the table column

When the form has translations added (From form builder implementer interface) and the mart is run in english

1. Data is inserted according to the english translations

When the form has translations added and the mart is run in french

1. Data is inserted according to the french translations
2. Previous data is also changed according to french translations

When the column name is added in columns to ignore, (Fully specified name of the concept)

1. The column is removed from the table
2. The entire table data is removed when there is only one column in the table and the same concept is added in columns to ignore.

When the entire form is reconstructed, (All the form fields are removed and now concepts are added)

1. Existing data is removed from the table, and the new columns are added to the table
2. New data is added to the form table when the observation is filled to a patient