Offer Model
The mrt_global__offer table is designed to store comprehensive information about offer nor product metadata.
Table description
| name | data_type | description |
|---|---|---|
| offer_id | STRING | Unique identifier for the offer. |
| offer_product_id | STRING | Identifier for the product associated with the offer. |
| offer_product_humanized_id | STRING | Human-readable identifier for the product associated with the offer. |
| offer_id_at_providers | STRING | Identifier for the offer at external providers. |
| is_synchronised | BOOLEAN | Indicates whether the offer is synchronized with API systems and has a product_id. |
| offer_name | STRING | Name of the offer as it appears in the application. |
| offer_description | STRING | Offer description (synopsis, further details on the show) as provided by thecultural partner and displayed in app. |
| offer_category_id | STRING | Identifier for the category of the offer. Determined by the cultural partner via a list of pre-set options in a drop down menu. |
| last_stock_price | NUMERIC | The last recorded stock price for the offer. |
| offer_creation_date | DATE | Date when the offer was created. |
| offer_created_at | DATETIME | Timestamp when the offer was created. |
| offer_updated_date | DATETIME | Timestamp when the offer was last updated. |
| offer_is_duo | BOOLEAN | Indicates if the offer can be booked as a duo. |
| item_id | STRING | Identifier for the item associated with the offer used internally by the data science team. |
| offer_is_underage_selectable | BOOLEAN | Indicates if the offer is selectable for underage users. |
| offer_type_domain | STRING | Deprecated: The offer's category type,as many metadata info are specific to certain |
| offer types. Can be either "BOOK", "MUSIC", "SHOW" or "MOVIE". | ||
| offer_is_bookable | BOOLEAN | Indicates if the offer is bookable (the offer has non expired and non depleted stock, and can thus still be booked by users in app). |
| venue_is_virtual | BOOLEAN | Indicates if the venue is virtual. Each offerer has a virtual venue, it is only used to publish digital offers. NB : digital venues will soon be deleted, their offers/bookings/stocks will be transferred to other venues of the offerer. |
| digital_goods | BOOLEAN | Indicates if the offer includes digital goods. |
| physical_goods | BOOLEAN | Indicates if the offer includes physical goods. |
| event | BOOLEAN | Indicates if the offer is an event. |
| offer_humanized_id | STRING | Human-readable identifier for the offer used in various platforms. |
| passculture_pro_url | STRING | URL to the offer on PassCulture Pro. |
| webapp_url | STRING | URL to the offer on the web application. |
| offer_subcategory_id | STRING | Identifier for the subcategory of the offer. Determined by the cultural partner via a list of pre-set options. |
| offer_url | STRING | URL to the offer. |
| is_national | BOOLEAN | Indicates if the offer is available nationally. This Information is originally filled by pass Culture teams but is no longer used. It will be decommissioned soon. |
| is_active | BOOLEAN | Indicates if the offer is active (the offer has been deactivated and is no longer visible in app). |
| offer_validation | STRING | Current status of the offer validation by internal teams. The offer may be: |
| - "DRAFT" (yet to be published by the cultural partner) | ||
| - "PENDING" (published, yet to be reviewed by the pass Culture Fraud team) | ||
| - "VALIDATED" (validated by pass Culture fraud team, ready to be made available to users) | ||
| - "REJECTED" (rejected and not made available to users) | ||
| author | STRING | The offer's author (a book's author, a music's singer, a movie's director). |
| performer | STRING | Performers involved in this offer. |
| stage_director | STRING | Stage director, if applicable. |
| theater_movie_id | STRING | Allociné identifier for the movie, if applicable. |
| theater_room_id | STRING | Allociné identifier for the theater room, if applicable. |
| speaker | STRING | Speaker or professor, if applicable. |
| movie_type | STRING | Type of movie, if applicable (e.g., feature film, short film). |
| visa | STRING | Film visa number, if applicable. |
| release_date | STRING | Release date, if applicable. |
| genres | STRING | Genres of the film, if applicable. |
| companies | STRING | Companies involved in the production or distribution of the film, if applicable. |
| countries | STRING | Countries where the film was produced, if applicable. |
| casting | STRING | Actors in the film, if applicable. |
| isbn | STRING | ISBN of the book, if applicable. |
| titelive_gtl_id | STRING | Unique identifier of the Genre Tite Live (GTL) associated to this offer. |
| rayon | STRING | Literary genre, if applicable. |
| book_editor | STRING | Editor of the book, if applicable. |
| type | STRING | Type of the offer. |
| sub_type | STRING | Sub-type of the offer. |
| mediation_humanized_id | STRING | Human-readable identifier for mediation. |
| total_individual_bookings | INT64 | Total number of individual bookings. |
| total_cancelled_individual_bookings | INT64 | Total number of cancelled individual bookings. |
| total_used_individual_bookings | INT64 | Total number of used individual bookings. |
| total_favorites | INT64 | Total number of times this offer was favorited. |
| total_stock_quantity | INT64 | Total remaining stock quantity. |
| total_first_bookings | INT64 | Total number of bookings that are first bookings. |
| venue_id | STRING | Unique identifier for the venue. |
| venue_name | STRING | Name of the venue. |
| venue_department_code | STRING | Department code of the venue. |
| venue_region_name | STRING | Region name where the venue is located. |
| venue_postal_code | STRING | Postal code of the venue. |
| venue_city | STRING | City where the venue is located. |
| venue_epci | STRING | EPCI code of the venue. |
| venue_academy_name | STRING | Academy of the venue. |
| venue_density_label | STRING | Detailed density label of the venue's location. |
| venue_macro_density_label | STRING | Macro density label of the venue's location (urbain, rural) |
| venue_label | STRING | Label of the venue. The label is appended by the Ministry as token of quality and standing in its category. |
| partner_id | STRING | Unique identifier of the partner. |
| offerer_id | STRING | Unique identifier of the offerer. |
| offerer_name | STRING | Name of the offerer. |
| venue_type_label | STRING | Type of the venue ('Musée', 'Cinéma','Librairie', etc). Selected by the partner in a drop-down list during subscription. If you need to study bookings and offers per cultural sector, use the offer categories instead. "Autre" category contains many administrative venues of live performance actors and local authorities. NB : this venue_type_label segmentation is limited and currently being revised. |
| venue_iris_internal_id | STRING | Internal IRIS identifier for the venue. |
| offerer_address_id | STRING | The unique identifier for the mapping between an offerer and an address where he created offers. |
| offer_publication_date | DATETIME | Publication date of the offer on the app, bookable or not (coming soon). Data available only from July 2025. |
| is_future_scheduled | BOOLEAN | Indicates if the offer's publication is scheduled in the future. |
| total_headlines | INT64 | Number of different times the offer was headlined on the app venue page. (an offer headline can be desactivated and reactivated) |
| is_headlined | BOOLEAN | Indicates if the offer is currently headlined on the app venue page. |
| is_coming_soon | BOOLEAN | Indicates if the offer is published in the app but not bookable yet (coming soon). |
| first_headline_date | DATETIME | First date of headline on the app venue page. |
| offer_finalization_date | DATETIME | Finalization date of the offer creation. If offer_creation_date is not null and offer_finalization_date is null, then it is draft. Data available only from July 2025. |
| scheduled_offer_bookability_date | DATETIME | Date of bookability of the offer. This field is filled only if the offer is scheduled. |
| last_headline_date | DATETIME | Last date of headline on the app venue page. |
| venue_density_level | STRING | ID of the density level of the venue (cf venue_density_label). |
| venue_department_name | STRING | Department name where of the venue. |
| 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. |
| offer_last_provider_id | STRING | Id of the offer's last provider. |
| is_local_authority | BOOLEAN | Indicates if the offerer is a local authority or not. |
| offerer_is_epn | BOOLEAN | Boolean true when the offerer is flagged as a national public structure. |