Skip to content

Table: Offerer Removed

This model exports offerer removed data for ministry use. It contains only removed offerers not longer available for booking in pass Culture apps.

Table description

name data_type description
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_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_siren SIREN number of the offerer.