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.
user_id	STRING	Unique identifier for a user.
deposit_source		Creation source of the deposit (educonnect, ubble, dms).
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. 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.
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).