Table: Collective Offer

The mrt_global__collective_offer table is designed to store comprehensive information about collecttives offers.

Cultural partners can create two types of collective offers : - collectives offers that can directly be booked by school teachers, with a set price and date. Those collective offers can be linked exclusively to a specific school (in this case, institution_id is not null). Those collective offers can be identified using the column collective_offer_is_template = 'False'. - collective offer templates, with no set price and date. Those collective offers enable cultural partners to be visible towards school teachers, the latter being able to contact cultural partners to co-create a specific collective offer. Those collective offers can be identified using the column collective_offer_is_template = 'True'.

Table description

name	data_type	description
collective_offer_id		Identifier for the collective offer.
collective_offer_humanized_id		Human-readable identifier for the collective offer.
collective_offer_name		Name of the collective offer.
venue_id		Unique identifier for the venue.
partner_id		Unique identifier of the partner.
institution_id		Id of the institution.
institution_program_name		Name of the program at the educational institution.
venue_name		Name of the venue.
venue_region_name		Region name where the venue is located.
venue_department_code		Department code of the venue.
venue_department_name		Department name where of the venue.
venue_postal_code		Postal code of the venue.
venue_city		City where the venue is located.
venue_epci		EPCI code of the venue.
venue_academy_name		Academy of the venue.
venue_density_label		Detailed density label of the venue's location.
venue_macro_density_label		Macro density label of the venue's location (urbain, rural)
venue_density_level		ID of the density level of the venue (cf venue_density_label).
venue_is_virtual		Indicates if the venue is virtual. Each offerer has a virtual venue, it is only used to publish digital offers.
offerer_id		Unique identifier of the offerer.
offerer_name		Name of the offerer.
venue_iris_internal_id		Internal IRIS identifier for the venue.
collective_offer_creation_date		Creation date of the collective offer.
collective_offer_date_updated		Date when the collective offer was last updated.
collective_offer_format		List of the different cultural formats of the collective offer.
collective_offer_students		Number of students that this collective offer can host.
collective_offer_is_active		Boolean. Indicates if the collective offer is active (has not been deactivated) .
collective_offer_is_bookable		Indicates if the collective offer is bookable (is visible in-app and can be booked by users).
total_collective_bookings		Total number of collective bookings.
total_non_cancelled_collective_bookings		Total number of collective bookings that were not cancelled.
total_used_collective_bookings		Total number of collective bookings that were used.
passculture_pro_url		URL to the offer on PassCulture Pro.
collective_offer_is_template		Indicates if the collective offer is a template offer.
collective_offer_image_id		Image identifier for the collective offer.
provider_id		The unique identifier for the synchronization provider.
national_program_id		Identifier for the national program associated with the collective offer.
national_program_name		Name of the national program associated with the collective offer.
template_id		Identifier for the template associated with the collective offer.
collective_offer_address_type		Type of address where the collective offer takes place (at school, at the offerer's venue or elsewhere ).
collective_offer_contact_url		Contact URL for the collective offer.
collective_offer_contact_form		Contact form for the collective offer.
collective_offer_contact_email		Contact email for the collective offer's owner.
collective_offer_contact_phone		Contact phone number for the collective offer's owner.
institution_internal_iris_id		Internal IRIS identifier for the educational institution.
collective_stock_beginning_date_time		Scheduled date and time of the collective outing.
collective_stock_booking_limit_date_time		Limit booking date time for the collective stock offer.
collective_offer_template_beginning_date		Beginning publication date for template offer (if null : permanent).
collective_offer_template_ending_date		Ending publication date for template offer (if null : permanent).
collective_stock_price		Stock price of the collective offer.
collective_stock_number_of_tickets		Number of tickets available in the collective stock.
is_local_authority	BOOLEAN	Indicates if the offerer is a local authority or not.
venue_is_permanent	BOOLEAN	Indicates if the venue is permanent. A permanent venue is a venue that can receive public permanently, that can propose offers, and that is managed by the partner. Permanent venues exemple : a library, a cinema. Non permanent venues example : a public garden that hosted a festival once, or a theater that hosted a concert once - it can be permanent for the partner who owns the theater, but not for the partner who is hosted once in this place.
venue_type_label	STRING	Type of the venue ('Musée', 'Cinéma','Librairie', etc). Selected by the partner in a drop-down list.