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_offer_address_type		Type of address where the collective offer takes place (at school, at the offerer's venue or elsewhere ).
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.