EAV (Entity Attribute Value) Job

We have EAV job in mart to get the attributes for Provider, Programs, Person, Visits and Operation Theatre. Also the identifier values for Patient. Below is the list of mart tables for the same.

provider_attributes table gives all the provider attribute information in an implementation.

Openmrs tables used: provider, provider_attribute, provider_attribute_type

provider.json:

patient_identifier is the mart table and the columns are the pivoted values in identifier_type table.

Openmrs tables used: patient, person, patient_identifier

The patient_identifier mart table has all the columns from patient_identifier_type openmrs table,

patient_id from patient_identifier;

patients.json:

person_attributes table contains all the patient attributes that where used in the registration page. Columns will be generated dynamically based on the attributes that were used as a part of that specific implementation.

Eg : givenName, familyName, isCaretakerRequired, caretakerGender

person.json:

program_attributes table gives all the program attributes enrolled for a particular patient.

Openmrs tables used: program_attribute_type, patient_program_attribute

programs.json:

visit_attributes table gives all the visit attributes for that particular visit type.

visitsAndEncounters.json:

surgical_appointment_attributes gives all the surgical attributes created for a surgery.

operationTheatre.json: