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. |