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 !
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.