Skip to content

Table: User

This model exports user data for ministry use. It contains information about users including: - Basic information (ID, activity, civility, school type) - Status information (active status, current beneficiary status) - Personal information (age, birth date) - Account information (creation date, activation date, suspension reason) - Deposit information (first deposit date and type, current deposit type) - User seniority

Table description

name data_type description
user_id Unique identifier for a user.
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_civility Registered civility of the user (male, female).
user_school_type Type of school the user is enrolled in (public, private etc), for GRANT_15_17 users.
user_is_active Boolean. Indicates if the user's account is currently active (the user can access it, irrespective of grant status).
user_age Current age of the user.
user_birth_date Birth date of the user.
user_first_deposit_creation_date First deposit creation date.
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_created_at Date when the user account was created.
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_suspension_reason Reason for the user's suspension (upon user request, fraud suspicion etc).
user_is_current_beneficiary Boolean. Indicates if the user still has available grant to use.
user_seniority Days between user account creation date and current date.