Need to add codelist validity checking for any fields in SuiteCRM that are sourced from dropdowns

[chrisarridge]

A number of our fields in the CRM are restricted to a codelist of values, but the SuiteCRM API apparently will let us set these fields to arbitrary free text. The consequences of this are that:

1. When we call the API again to retrieve these fields we will receive that same free text back.
2. The field will appear blank in the GUI.
3. We lose validation of these fields.

We need to add validity checking on record creation and update.

[simon-20]

This is a duplicate of #23, but I'll close the pre-existing issue as the description here is more extensive.

The following fields (and maybe more) are affected (RYD API field names): hq_country, organisation_type, licence_id, region.

See also the corresponding issue on the Bulk Data Service IATI/bulk-data-service#119, and the related issue on IATI SuiteCRM which pertains to when/how we update these lists: https://github.com/IATI/iati-suitecrm/issues/1

[simon-20]

@chrisarridge, I think we need to work out / decide whether the Registry / SuiteCRM is (at some point) going to periodically pull in the codelists from the relevant SSOT repository. If it is, then RYD should do the same, and the task here is to implement that. If it isn't and we're going to manually update the hardcoded lists in SuiteCRM on codelist changes, then either we just copy that approach here and store copies of the codelists in this repo, or we create a new custom endpoint in SuiteCRM and have RYD always pull the list direct from the running version of the Registry.

[simon-20]

Just also to note, we need to decide whether to let fields hq_country, licence_id and region take values from the previous versions of the standard.

The redis server used by the Validator and other services contains all this information, so we could have RYD connect to that to get the values.