Skip to content
Comparing OpenActive & Open Referral

OpenActive & Open Referral UK attribute comparison

DS
Dominic Skinner
|
MT
Mike Thacker
ODI initial mapping from
to Open Referral UK. This will list all of the main Open Referral UK fields, not including keys and joining tables etc. A lot of the gaps in the Open Active to Open Referral Mapping can be explained by this document covering the
. Serious issues with the mapping are
highlighted in red
.
ODI - OA & OR mapping
0
Open Referral UK attribute
maps to OpenActive SessionSeries model
Notes
1
accessibilitySupport.@id
2
accessibility_for_disabilities.accessibility
accessibilitySupport.prefLabel
3
beta:contactPoint.name
The OpenActive Beta Extension is defined as a convenience to help document properties that are in active testing and review by the community.

This is probably the best contact information for a service, even though it is currently in beta. As the data is the contact information for the service and not general organization information:

Note there was talk about using the leader property. However this is probably not a good idea as it is not clear from that property if a leader of a event should necessarily be the point of contact.
4
contact.title
5
cost_option.amount
Concatenate these fields:
offer.priceCurrency
offer.price
6
cost_option.option
beta:isFirstSessionAccessibleForFree
isAccessibleForFree
The OpenActive Beta Extension is defined as a convenience to help document properties that are in active testing and review by the community.

Use the boolean flags to create cost option text. So is accessible free and/or first session is free.
7
cost_option.amount_description
8
cost_option.url
offer.url
cost_option.url currently doesn’t exist but we need it to represent booking URL’s
9
cost_option.valid_from
offer.validFromBeforeStartDate
This can be calculated by using the ISO_8601 duration value with the startDate as a reference
10
cost_option.valid_to
endDate
11
eligibility.minAge
ageRange.minValue
12
eligibility.maxAge
ageRange.maxValue
13
eligibility.eligibility
This property should not be used. If possible put any data in a taxonomy.
14
funding.source
15
holiday_schedule.closed
This is now deprecated.
16
holiday_schedule.opens_at
This is now deprecated.
17
holiday_schedule.closes_at
This is now deprecated.
18
holiday_schedule.start_date
This is now deprecated.
19
holiday_schedule.end_date
This is now deprecated.
20
language.language
22
location.description
Concatenate these fields:
location.description
meetingPoint
23
location.latitude
location.geo.latitude
24
location.longitude
location.geo.longitude
25
organization.url
organizer.url
Organizer is either a Person or Organizaton object.
26
organizer.legalName
Organizer is either a Person or Organizaton object.
27
organization.logo
organizer.logo
Organizer is either a Person or Organizaton object.
28
organization.description
organizer.description
Organizer is either a Person or Organizaton object.
29
organization.uri
30
phone.number
beta:contactPoint.telephone
The OpenActive Beta Extension is defined as a convenience to help document properties that are in active testing and review by the community.

This is probably the best contact information for a service, even though it is currently in beta. As the data is the contact information for the service and not general organization information:
31
phone.language
32
physical_address.address_1
location.address
location.address.streetAddress
This could be text in which case this is all copied into address_1 I am not sure how wise it is to attempt to break this down.
33
physical_address.postal_code
location.address.postalCode
The location.address object could be text in which case it isn’t used.
34
physical_address.country
location.address.addressCountry
The location.address object could be text in which case it isn’t used. Needs to be converted to full country name as it is currently a two-letter ISO 3166-1 alpha-2 country code.
35
physical_address.city
physical_address.state_province
location.address.addressRegion
This needs to be identified as a city or not to determine, which OR field to populate.
36
physical_address.attention
37
regular_schedule.description
attendeeInstructions
38
regular_schedule.startDate
eventSchedule.startDate
39
regular_schedule.endDate
eventSchedule.endDate
40
regular_schedule.freq
regular_schedule.interval
eventSchedule.repeatFrequency
Decode ISO_8601 format.
41
regular_schedule.byday
eventSchedule.byDay
42
regular_schedule.bymonthday
eventSchedule.byMonthDay
43
regular_schedule.valid_from
44
regular_schedule.valid_to
45
regular_schedule.opens_at
eventSchedule.startTime
46
regular_schedule.closes_at
eventSchedule.endTime
47
review.title
48
review.description
49
50
review.score
51
review.url
52
review.widget
53
service.url
url
54
name
55
service.description
description
56
beta:contactPoint.email
The OpenActive Beta Extension is defined as a convenience to help document properties that are in active testing and review by the community.

This is probably the best contact information for a service, even though it is currently in beta. As the data is the contact information for the service and not general organization information:
57
service.status
eventStatus
The event status types are defined here
and would need to be converted to the enum “active", "inactive", "defunct", "temporarily closed”
58
service.fees
This is replaced by cost_option.
59
service.accreditations
60
service.deliverable_type
61
service.attending_type
62
service.attending_access
63
service.assured_date
64
service_area.service_area
65
service_area.extent
66
service_area.uri
67
genderRestriction

We can convert these to a suitable taxonomy such as circumstance. So https://openactive.io/NoRestriction converts to no eligibility
converts to male,
converts to female etc.
68
activity.prefLabel
genderRestriction
69
taxonomy.vocabulary
activity.inScheme
genderRestriction
There are no rows in this table

Relevant Porism Files

@#r22

@#r21

@#r8

Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.