Officers Bulk File 'Appointment Type' Mapping to Officers Stream 'Role'

1

Hi Team !

Is there any mapping information between the ‘Appointment Type’ found in the Officers Bulk File and the ‘Role’ field in the Officers Stream / API ?

There are two different lists with varying fields that seem closely related.

Thanks !

2

Yes, I’ve done a mapping based on the table included in the word document describing the bulk file.

You can find my implementation here: https://github.com/mrbrianevans/companies-db/blob/master/services/officers/shared/recordParser/AppointmentType.ts

  0: 'secretary',
  1: 'director',
  2: 'secretary',
  3: 'director',
  4: 'llp-member',
  5: 'llp-designated-member',
  6: 'llp-member',
  7: 'llp-designated-member',
  11: 'judicial-factor',
  12: 'charities-act-receiver-or-manager',
  13: 'caice-act-manager',
  14: 'judicial-factor',
  15: 'charities-act-receiver-or-manager',
  16: 'caice-act-manager',
  17: 'member-of-an-administrative-organ',
  18: 'member-of-a-supervisory-organ',
  19: 'member-of-a-management-organ',
  20: 'member-of-an-administrative-organ',
  21: 'member-of-a-supervisory-organ',
  22: 'member-of-a-management-organ',
  99: 'errored-appointment'

There are multiple appointment type codes that map to the same officer role because the appointment type code is different for current/resigned officers.

The enumerated list of officer_role values can be found at https://github.com/companieshouse/api-enumerations/blob/master/constants.yml#L182

For the table mapping appointment type numbers to human readable roles, see Officer bulk data record types | CH Guide if you don’t have the word document.

3

This is awesome - thanks again @ebrian101 !