User Model

The mrt_global__user table contains user-level information for all users in the system.

Business Rules

Each row represents a unique user. All users are included in this table — general public, beneficiaries, and 15-16 — regardless of grant or credit status.

Table description

name	data_type	description
user_id	STRING	Unique identifier for a user.
user_creation_date	DATE	Date when the user account was created.
user_has_enabled_marketing_email	BOOLEAN	Indicates if the user has accepted to receive marketing emails.
user_activity	STRING	User's registered activity (student, apprentice, unemployed etc). Registered at first grant deposit and updated when the user applies for its GRANT_18.
user_civility	STRING	Registered civility of the user (male, female). Information collected during registration.
user_birth_date	DATE	Birth date of the user.
user_age	INT64	Current age of the user.
user_age_at_creation	INT64	The age of the user at the time of creation of the user profile, calculated as the difference between the user's creation date and the user's date of birth.
user_school_type	STRING	Type of school the user is enrolled in: Centre de formation apprentis, Collège privé, Collège public, Lycée agricole, Lycée maritime, Lycée militaire, Lycée privé, Lycée public, À domicile (CNED, institut de santé, etc.).
user_is_active	BOOLEAN	Boolean. Indicates if the user's account is currently active (the user can access it, irrespective of grant status).
user_role	STRING	Role assigned to the user (GRANT_18, GRANT_15_17, PRO, ADMIN).
user_is_email_validated	BOOLEAN	Boolean. Indicates if the user's email is validated.
user_phone_validation_status	STRING	Status of the user's phone validation step.
user_has_validated_email	BOOLEAN	Indicates if the user has validated their email.
user_has_enabled_marketing_push	BOOLEAN	Indicates if the user has accepted to received marketing push.
user_subscribed_themes	STRING	Users themes subscribed. Users can subscribe to themes (cinema, music) to receive custom communication related to those themes.
is_theme_subscribed	BOOLEAN	Boolean. Indicates whether a user has subscribed to at least one theme.
user_category	STRING	User category derived from the user's role and age. Possible values include: '15-16' (users aged 15 or 16 with no specific role), 'general_public' (users aged 14 or under, or 17 and above, with no specific role), or 'beneficiary' (for users with a non-null role).