Column collective booking

collective_booking_id: Unique identifier for a collective booking.

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_booking_is_used: Boolean. Indicates if the collective booking has been used (the activity took place).

first_collective_booking_date: Date of the first collective booking.

last_collective_booking_date: Date of the last collective booking.

is_current_scholar_year_booking: Whether or not the booking is associated to the current scholar year (scholar year = a year from 1st Sept to 31 Aug, ex : 2024-2025, from 1st Sept 2024 to 31th Aug 2025).

is_current_calendar_year_booking: Whether or not the booking is associated to the current calendar year (calendar year = a year from 1st of Jan to 31th of dec, ex : 2025 from 01/01 to 12/31).

is_current_deposit_booking: Whether or not the booking is associated to the current deposit (it can be a period : sept-dec, jan-aug, all_year = sept-aug.