Skip to content
offer.priceCurrencyoffer.pricebeta:isFirstSessionAccessibleForFreeisAccessibleForFreelocation.descriptionmeetingPointlocation.addresslocation.address.streetAddressphysical_address.cityphysical_address.state_provinceregular_schedule.freqregular_schedule.intervalgenderRestrictionactivity.inSchemegenderRestriction
OpenActive & Open Referral UK attribute comparison
Dominic Skinner
|
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
Open Referral UK attribute
maps to OpenActive SessionSeries model
Notes
accessibility_for_disabilities.accessibility
accessibilitySupport.prefLabel
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.
contact.title
cost_option.amount
Concatenate these fields:
cost_option.option
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.
cost_option.url
offer.url
cost_option.url currently doesn’t exist but we need it to represent booking URL’s
cost_option.valid_from
offer.validFromBeforeStartDate
This can be calculated by using the ISO_8601 duration value with the startDate as a reference
cost_option.valid_to
endDate
eligibility.minAge
ageRange.minValue
eligibility.maxAge
ageRange.maxValue
eligibility.eligibility
This property should not be used. If possible put any data in a taxonomy.
funding.source
holiday_schedule.closed
This is now deprecated.
holiday_schedule.opens_at
This is now deprecated.
holiday_schedule.closes_at
This is now deprecated.
holiday_schedule.start_date
This is now deprecated.
holiday_schedule.end_date
This is now deprecated.
language.language
location.description
Concatenate these fields:
location.latitude
location.geo.latitude
location.longitude
location.geo.longitude
organization.url
organizer.url
Organizer is either a Person or Organizaton object.
organization.logo
organizer.logo
Organizer is either a Person or Organizaton object.
organization.description
organizer.description
Organizer is either a Person or Organizaton object.
organization.uri
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:
phone.language
physical_address.address_1
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.
physical_address.postal_code
location.address.postalCode
The location.address object could be text in which case it isn’t used.
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.
location.address.addressRegion
This needs to be identified as a city or not to determine, which OR field to populate.
physical_address.attention
regular_schedule.description
attendeeInstructions
regular_schedule.startDate
eventSchedule.startDate
regular_schedule.endDate
eventSchedule.endDate
eventSchedule.repeatFrequency
Decode ISO_8601 format.
regular_schedule.byday
eventSchedule.byDay
regular_schedule.bymonthday
eventSchedule.byMonthDay
regular_schedule.valid_from
regular_schedule.valid_to
regular_schedule.opens_at
eventSchedule.startTime
regular_schedule.closes_at
eventSchedule.endTime
review.title
review.description
review.score
review.url
review.widget
service.url
url
service.description
description
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:
service.status
eventStatus
The event status types are defined here and would need to be converted to the enum “active", "inactive", "defunct", "temporarily closed”
service.fees
This is replaced by cost_option.
service.accreditations
service.deliverable_type
service.attending_type
service.attending_access
service.assured_date
service_area.service_area
service_area.extent
service_area.uri
Gender restrictions are defined here:
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.
taxonomy.vocabulary
There are no rows in this table
Relevant Porism Files
@#r22
@#r21
@#r8
Want to print your doc?
This is not the way.
This is not the way.
Try clicking the ··· in the right corner or using a keyboard shortcut (
CtrlP
) instead.