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). Information collected during registration. | |
| user_school_type | 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. 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, can be GRANT_18, GRANT_15_17, GRANT_17_18, GRANT_FREE. | |
| 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. Possible values include: end of eligibility – The user no longer meets the criteria to be eligible for a deposit; fraud suspicion – Suspicious activity detected, requiring investigation; hacking fraud – Confirmed or suspected account compromise; upon user request – The user has explicitly requested the suspension or deletion of their account. | |
| 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. |