Column collective offer

• Collective offer related *

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.

collective_offer_creation_date: Creation date of the collective offer.

collective_offer_date_updated: Date when the collective offer was last updated.

collective_offer_subcategory_id: Subcategory identifier for the collective offer.

collective_offer_category_id: Category identifier for the collective offer.

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).

collective_offer_is_template: Indicates if the collective offer is a template offer.

collective_offer_image_id: Image identifier for 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.

first_collective_offer_creation_date: Date of the first collective offer creation.

last_collective_offer_creation_date: Date of the last collective offer creation.

first_collective_bookable_offer_date: Date of the first collective bookable offer.

last_collective_bookable_offer_date: Date of the last collective bookable 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_offer_rejection_reason: For offers rejected by pass Culture team, rejection's reason (ineligble offers, missing information etc).

• To migrate to more specific files *

template_id: Identifier for the template associated with the collective offer.

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.