Column deposit

deposit_id: Unique identifier for the deposit.

deposit_date: The date when the deposit was made.

deposit_amount: The total amount of the deposit.

deposit_source: Creation source of the deposit (educonnect, ubble, dms).

deposit_creation_date: The date when the deposit was created.

deposit_active_date: Active date of a deposit.

deposit_update_date: The date when the deposit was last updated (only for GRANT_15_17).

deposit_expiration_date: The expiration date of the deposit. 24 months after deposit creation for GRANT_18; at the user's 18th birthday for GRANT_15_17.

deposit_type: Type of the deposit, can be GRANT_18, GRANT_15_17, GRANT_17_18.

deposit_reform_category: Categorizes deposits following the reform, allowing distinction between 17 and 18-year-old beneficiaries for the new GRANT_17_18 credit. This field also differentiates between deposits granted before and after the reform. Values are : 15_17_pre_reform, 18_pre_reform, 18_experiment_phase, 17_post_reform, 18_post_reform.

deposit_rank_asc: Ascending rank of the deposit in user's history.

deposit_rank_desc: Descending rank of the deposit in user's history.

deposit_seniority: Total days between deposit_creation_date and today. Used for analytics purposes.

days_between_user_creation_and_deposit_creation: Total days between user_creation_date (user activated its account) and deposit_creation_date (user received grant).

user_first_deposit_creation_date: First deposit creation date.