Table: Deposit

This model exports deposit data for ministry use. It contains information about user beneficiary deposits including: - Deposit details (ID, amount, type, source) - Temporal information (creation, update, expiration dates) - User association - Recredit information (total recredit and amount) - User creation timing information

Table description

name	data_type	description
deposit_id	STRING	Unique identifier for the deposit.
deposit_amount	NUMERIC	The total amount of the deposit. Amount varies by deposit_type. GRANT_15_17: 20€ in the year the user turns 15, 30€ at 16, 30€ at 17, 30€ in the year they turn 17; GRANT_18: 300€ before the reform, 500€ during the experimental phase; GRANT_17_18: 150€; GRANT_FREE: 0€ for 15–16-year-olds (allows free bookings).
user_id	STRING	Unique identifier for a user.
deposit_source		Creation source of the deposit. Possible values: educonnect – Deposit initiated via the French national education authentication system; ubble – Deposit created following a remote identity verification process via Ubble.
		dms – Deposit imported from a Document Management System (internal or third-party document repository).
deposit_creation_date		The date when the deposit was created.
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. GRANT_18: 24 months after creation; GRANT_15_17: On the user’s 18th birthday; GRANT_17_18: The day before the user turns 21.
deposit_type		Type of the deposit, can be GRANT_18, GRANT_15_17, GRANT_17_18, GRANT_FREE.
total_recredit		The total number of times the beneficiary received a new recredit.
total_recredit_amount		The total amount that has been recredited to the beneficiary.
days_between_user_creation_and_deposit_creation		Total days between user_creation_date (user activated its account) and deposit_creation_date (user received grant).