Column user

user_academy_name: Academy name associated with the user's registered address.

user_activated_at: Date when the user's account was activated. Corresponds to the first booking date for users in experiment phase, and to user creation date for all users after the experiment phase.

user_activity: User's registered activity (student, apprentice, unemployed etc). Registered at first grant deposit and updated when the user applies for its GRANT_18.

user_age: Current age of the user.

user_birth_date: Birth date of the user.

user_civility: Registered civility of the user (male, female).

user_city: City associated with the user's registered address.

user_city_code: The INSEE code of the city associated with the user's registered address.

user_created_at: Date when the user account was created.

user_department_code: Department code associated with the user's registered address.

user_department_name: Department name associated with the user's registered address.

user_density_label: String column.Density label (urban, rural) of the user's registered address.

user_density_level: Integer column. Density level of the user's registered address. Ranges from 1 (highly urban) to 7 (highly rural).

user_epci: EPCI code associated with the user's registered address. An EPCI is a French public body enabling municipalities to collaborate on shared local services and development.

user_humanized_id: Human-readable identifier for the user.

user_id: Unique identifier for a user.

user_iris_internal_id: Internal IRIS identifier associated with the user's registered address. IRIS (Ilots Regroupés pour l'Information Statistique) are small, standardized geographic units used for detailed statistical analysis in France.

user_is_active: Boolean. Indicates if the user's account is currently active (the user can access it, irrespective of grant status).

user_is_current_beneficiary: Boolean. Indicates if the user still has available grant to use.

user_is_in_education: Boolean. Indicates if the user is in education, based on their registered activity. According to the INSEE, a user is considered to be in education if they fall under one of the following categories: Middle school student (Collégien), High school student (Lycéen), University student (Étudiant), Apprentice (Apprenti), Work-study student (Alternant).

user_is_in_qpv: Boolean. Indicates if the user's registered address is in a priority neighborhood (QPV).

user_is_priority_public: Boolean. Indicates if the user considered as a pass Culture priority public (users that are either residing in a rural area, in a QPV or are not in education).

user_is_unemployed: Boolean. Indicates if the user is unemployed as per its registered activity.

user_macro_density_label: Macro density label of the user's registered address.

user_postal_code: Postal code of the user's registered address.

user_region_name: Region name of the user's registered address.

user_school_type: Type of school the user is enrolled in (public, private etc), for GRANT_15_17 users.

user_seniority: Days between user account creation date and current date.

user_suspension_reason: Reason for the user's suspension (upon user request, fraud suspicion etc).

user_has_enabled_marketing_email: Indicates if the user has accepted to receive marketing emails.

user_has_enabled_marketing_push: Indicates if the user has accepted to received marketing push.

user_role: Role assigned to the user (GRANT_18, GRANT_15_17, PRO, ADMIN).

user_address: User's registered address. Registered at first grant deposit and updated when the user applies for its GRANT_18.

user_last_connection_date: Date of the user's last connection.

user_is_email_validated: Boolean. Indicates if the user's email is validated.

user_has_seen_pro_tutorials: Boolean. Indicates if the user has seen professional tutorials.

user_phone_validation_status: Status of the user's phone validation step.

user_has_validated_email: Indicates if the user has validated their email.

user_currently_subscribed_themes: Users themes subscribed. Users can subscribe to themes (cinema, music) to receive custom communication related to those themes.

user_is_theme_subscribed: Boolean. Indicates whether a user has subscribed to at least one theme.

user_last_deposit_expiration_date: Expiration date of the user's last deposit.

user_last_deposit_amount: Amount of the last deposit received by the user.

user_first_deposit_type: Type of the user's first deposit (GRANT_18 or GRANT_15_17).

user_current_deposit_type: Type of the user's current deposit.

user_first_deposit_reform_category: The first deposit reform category associated with the user.

user_current_deposit_reform_category: The current deposit reform category associated with the user.

user_expiration_month: Month of the user's credit expiration

days_between_activation_date_and_first_booking_date: Number of days between the user's activation date and their first booking date.

days_between_activation_date_and_first_booking_paid: Number of days between the user's activation date and their first paid booking.

user_first_booking_type: Offer category of the user's first booking.

user_first_paid_booking_type: Offer category of the user's first paid booking.

user_first_deposit_amount: Amount of the user's first deposit received.

user_has_added_offer_to_favorites: Boolean. Indicates if the user has added any offer to their favorites.

user_qpi_subcategories: QPI stands for 'Initial Practice Questionnaires'. We asked young users about their cultural practices before using the Pass, resulting in a list of subcategories used during the cold start to display offers based on these initial practices.

user_modified_at: Timestamp at which user has updated its informations.

user_age_at_booking: The age of the user at the time of booking, calculated as the difference between the booking date and the user's date of birth.

user_address_geocode_type: Geocode precision type (street, municipality, etc) of the user's registered address.

user_address_latitude: Latitude of the user's registered address.

user_address_longitude: Longitude of the user's registered address.

user_address_raw: Raw address of the user's registered address.