Adding a new static patient identifier


I am currently looking to customize Bahmni for a projcet of mine. At this point I have a new request to add several patient identifiers such as:

  1. Passport ID
  2. Social Security Number
  3. Driving License

The way I am looking to add it is via an SQL Query. So, I have a OpenMrsClient and OpenMrsClientDB an via Python I’ll try to execute the insertion of these identifiers so when the patients are registered they can be registered via one of these Identifiers. I’d appreciate if you help me with the Query.

Thanks, AD