Column offerer

offerer_id: Unique identifier of the offerer.

offerer_name: Name of the offerer.

offerer_creation_date: Date when the offerer was created. Equals to the registration date of the offerer on the professional portal.

offerer_validation_date: Date when the offerer was validated (validation_status = ‘VALIDATED’).

offerer_postal_code: Postal code of the offerer.

offerer_department_code: Department code of the offerer.

offerer_academy_name: Academy name of the offerer.

offerer_siren: SIREN number of the offerer.

offerer_region_name: Region name of the offerer.

offerer_city: City of the offerer.

offerer_humanized_id: Unique identifier of the offerer used on Flaskadmin and Matomo.

offerer_legal_unit_business_activity_code: Business activity code of the legal unit of the offerer.

offerer_legal_unit_business_activity_label: Business activity label of the legal unit of the offerer.

offerer_legal_unit_legal_category_code: Legal category code of the legal unit of the offerer.

offerer_legal_unit_legal_category_label: Legal category label of the legal unit of the offerer.

offerer_is_local_authority: Indicates if the offerer is a local authority or not.

offerer_total_managed_venues: Total number of venues managed by the offerer.

offerer_total_physical_managed_venues: Total number of physical venues managed by the offerer.

offerer_total_permanent_managed_venues: Total number of permanent venues managed by the offerer.

offerer_total_venues: Total number of venues associated with the offerer.

offerer_first_dms_adage_status: First DMS adage status of the offerer.

offerer_dms_accepted_at: Date when the offerer was accepted in DMS.

offerer_dms_submitted_at: Date when the offerer sumitted his first DMS record.

offerer_is_reference_adage: Indicates if the offerer is a reference in adage.

offerer_is_synchro_adage: Indicates if the offerer is synchronized with adage.

offerer_validation_status: Validation status of the offerer.

offerer_is_active: Indicates if the offerer is active. Returns 'true' if offerer is active. Returns 'false' if the offerer has been deactivated.

offerer_rank_desc: Offerer rank in descending order.

offerer_rank_asc: Offerer rank in ascending order.

offerer_first_individual_offer_creation_date: The date when the offerer's first individual offer was created.

offerer_first_collective_offer_creation_date: The date when the offerer's first collective offer was created.

offerer_business_activity_label: The business activity label of the offerer.

offerer_legal_category_label: The legal category label of the offerer.

local_authority_type: When the offerer is a local authority, the type of the local authority, such as Commune, Département, or Région.

local_authority_is_priority: Indicates whether the local authority is internally seen as a priority partner.