Wiki Spaces

Documentation
Projects
Resources

Get Help from Others

Q&A: Ask OpenMRS
Discussion: OpenMRS Talk
Real-Time: IRC Chat | Slack

Projects

Page tree
TableColumnUsage
providerMinimum data re provider
national_idThis is the provider ID used within the national system, used where uuid cannot be used
provider_attributeThis is analogous to person_attribute. It might be good to have provider_attribute extend person_attribute.
provider_attribute_typeThis is analogous to person_attribute_type. It might be good to have provider_attribute extend person_attribute.
ISCO_codesThis is a reference table for the codes in job_title. It is an international standard using a 4-digit hierarchical-by-digit format; the codes without the other fields are on another tab, but there is a fuller version on the ILO website.
localeThe table already exists in several translations, all of which will be imported, so translation will be handled by selecting the locale to be used.
educationThis maintains all degrees earned by the provider
job_titleThis is a selectable list of job titles
national_idThis is the job title ID used within the national system, used where uuid cannot be used
code_ISCOThis is the ISCO code for this job title
category1, 2This is the 2-level hierarchy for selecting job titles as described in the functionality tab
cadreMany countries divide their staff into cadres such as doctors, nurses, etc. with an internal reporting structure
postThis is the national level assignment of a job to a location, and the provider who is/was the incumbent; a provider who serves more than one facility can have more than one post
provider_id0 if vacant
national_idThis is the post ID used within the national system, used where uuid cannot be used
time_basisFull-time, half-time, etc.
action_typeThe type of personnel action which caused the creation of the entry
funding_sourceFunding source for this post
subpostThis is a more detailed, lower-level assignment record. For example, the national level may assign a nurse to a clinic, but the clinic may assign her to an in-patient ward. A provider who served more than one facility can have more than one subpost.
competencyThis is a skill which a person can possess or learn and on which s/he can be evaluated
national_idThis is the competency ID used within the national system, used where uuid cannot be used
name, subnameThe two-level structure allows both competencies and language skills to use the same table; for a competency, it could be nursing/infection control, while for a language it could be Spanish/writing
levelsThese are the values which an evaluation of a competency can have e.g. intermediate, advanced, satisfactory
edit_privilegePrivilege necessary to create/edit an evaluation of this competency
evaluationThis is the evaluation of a competency. May also be used for post-training testing.
levelOne of the competency level values
edit_privilegeThis permits the limitation of who can alter evaluations, initially copied from competency
provider_tagThis is for folksonomies that classify or characterize the provider
provider_tag_mapThis connects provider_tags with providers
certificateThis is a certification by a certifying board, such as a board of medical examiners
national_idThis is the certificate ID used within the national system, used where uuid cannot be used
levelsThese are the levels at which a certificate can be issued e.g. nurse, nurse-midwife, nurse-practitioner
provider_certThese are the certificates held by a provider
cert_cancelIf a certificate has been cancelled, this is the reason
trainingThis is a particular training content which can be taught and which can provide certain competencies
national_idThis is the training ID used within the national system, used where uuid cannot be used
categoryThis is a one-level categorization for presenting lists of trainings
sort_orderThis is a sort order for presenting lists of trainings
training_competencyThis relates a training to the competencies it provides
training_classThis is a presentation of a training
durationThis is the number of days of a training
ceunitsContinuing education units provided by the class
locationThis is a text location where the class is to be held
organizationThis is the sponsoring organization
cost_courseThis is the cost of sponsoring the course which does not vary with the number of participants For costing.
cost_registerThis is the per-participant cost of the course. For costing.
cost_travelThis is the per-participant cost of travel to the class location For costing
cost_perdiemThis is the lodging/meals allowance for the class location For costing
train_personThis is the assignment of a person to a training class
completedDid the participant complete the course
reasonReason the participant did not complete the course (null if course is in future)