Table: Global Collective Booking

This table is designed to store comprehensive information about collective bookings.

Table description

name	data_type	description
collective_booking_id		Unique identifier for a collective booking.
collective_stock_id		Identifier for the collective stock associated with the booking.
is_used_collective_booking		Boolean. Indicates if the collective booking has been used (the activity took place).
collective_offer_id		Identifier for the collective offer.
collective_offer_name		Name of the collective offer.
collective_offer_format		List of the different cultural formats of the collective offer.
venue_id		Unique identifier for the venue.
venue_name		Name of the venue.
venue_department_code		Department code of the venue.
venue_department_name		Department name where of the venue.
venue_region_name		Region name where the venue is located.
offerer_id		Unique identifier of the offerer.
partner_id		Unique identifier of the partner.
offerer_name		Name of the offerer.
venue_iris_internal_id		Internal IRIS identifier for the venue.
booking_amount		Total amount for the booking for one quantity.
collective_stock_number_of_tickets		Number of tickets available in the collective stock.
collective_stock_beginning_date_time		Scheduled date and time of the collective outing.
collective_stock_end_date_time		Scheduled end date and time for the collective outing. The outing can take place during several days. The collective_booking_used_date is automatically set 2 days after this end date.
educational_institution_id		Id of the educational institution.
educational_year_id		Id of the scholar year.
scholar_year		scholar year for which the grant was received
educational_redactor_id		Id of the educational redactor.
institution_program_name		Name of the program at the educational institution.
institution_internal_iris_id		Internal IRIS identifier for the educational institution.
institution_name		Name of the educational institution.
institution_academy_name		Academy name of the educational institution.
institution_region_name		Region name of the educational institution.
institution_department_code		Department code of the educational institution.
institution_department_name		Department name of the educational institution.
institution_postal_code		Postal code of the educational institution.
institution_city		City where the educational institution is located.
institution_epci		EPCI code of the educational institution.
institution_density_label		Density label of the educational institution's area.
institution_macro_density_label		Macro density label of the educational institution : rural or urban.
institution_density_level		Density level of the educational institution's area.
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_postal_code		Postal code of the venue.
collective_booking_creation_date		Creation date of the collective booking.
collective_booking_cancellation_date		Cancellation date of the collective booking.
collective_booking_is_cancelled		Boolean. Indicates if the collective booking is cancelled.
collective_booking_status		Status of the collective booking.
collective_booking_cancellation_reason		Reason for the cancellation of the collective booking.
collective_booking_confirmation_date		Date at which the booking has been confirmed by the head teacher.
collective_booking_confirmation_limit_date		Confirmation limit date for the collective booking.
collective_booking_used_date		Date when the collective booking was used (when the activity booked took place).
collective_booking_reimbursement_date		Reimbursement date for the collective booking.
collective_booking_rank_asc		Ascending rank of the collective booking in the school's booking history.
collective_booking_rank_desc		Descending rank of the collective booking in the school's booking history.
collective_offer_image_id		Image identifier for the collective offer.
is_current_year_booking		Indicates if the booking is for the current year.
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 during subscription. If you need to study bookings and offers per cultural sector, use the offer categories instead. "Autre" category contains many administrative venues of live performance actors and local authorities. NB : this venue_type_label segmentation is limited and currently being revised.