Deposit
The Global Deposit model offers a detailed view of deposit-related data by integrating key attributes to support analysis and reporting.
This model aggregates data on cultural credits (or financial deposits) allocated to users, based on their age, eligibility, location, and activity within the cultural application. It draws from both the deposit and user tables, providing a comprehensive view of each user's deposit details alongside demographic and engagement information.
GRANT_15_17 refers to credits for users aged 15 to 17, capped at €80. This amount reflects specific age-based offers: €20 for users aged 15 and €30 for users aged 16 and 17.
GRANT_18 covers credits for users aged 18, ranging between €300 and €500, with a duration of two years, offering an extended cultural allowance for this age group.
In this context, a "deposit" signifies a cultural credit allocated individually to users aged 15-18 through the application, granting access to cultural resources like books, digital goods, and various experiences. These deposits serve as financial allowances that differ by age and grant type (e.g., individual or duo offers), empowering users to engage with cultural activities either alone or with a companion.
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. |
| user_civility | STRING | Registered civility of the user (male, female). |
| user_region_name | STRING | Region name of the user's registered address. |
| user_postal_code | STRING | Postal code of the user's registered address. |
| user_city | STRING | City associated with the user's registered address. |
| user_epci | STRING | EPCI code associated with the user's registered address. An EPCI is a French public body enabling municipalities to collaborate on shared local services and development. |
| user_academy_name | STRING | Academy name associated with the user's registered address. |
| user_density_label | STRING | String column.Density label (urban, rural) of the user's registered address. |
| user_macro_density_label | STRING | Macro density label of the user's registered address. |
| user_density_level | STRING | Integer column. Density level of the user's registered address. Ranges from 1 (highly urban) to 7 (highly rural). |
| user_is_in_qpv | BOOLEAN | Boolean. Indicates if the user's registered address is in a priority neighborhood (QPV). |
| user_is_unemployed | BOOLEAN | Boolean. Indicates if the user is unemployed as per its registered activity. |
| user_is_in_education | BOOLEAN | Boolean. Indicates if the user is in education, based on their registered activity. According to the INSEE, a user is considered to be in education if they fall under one of the following categories: Middle school student (Collégien), High school student (Lycéen), University student (Étudiant), Apprentice (Apprenti), Work-study student (Alternant). |
| user_is_priority_public | BOOLEAN | Boolean. Indicates if the user considered as a pass Culture priority public (users that are either residing in a rural area, in a QPV or are not in education). |
| user_department_code | STRING | Department code associated with the user's registered address. |
| user_department_name | STRING | Department name associated with the user's registered address. |
| user_age | INT64 | Current age of the user. |
| user_creation_date | DATE | Date when the user account was created. |
| deposit_source | STRING | Creation source of the deposit (educonnect, ubble, dms). |
| deposit_creation_date | DATE | The date when the deposit was created. |
| deposit_update_date | DATE | The date when the deposit was last updated (only for GRANT_15_17). |
| deposit_expiration_date | 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 | STRING | Type of the deposit, can be GRANT_18, GRANT_15_17, GRANT_17_18. |
| deposit_reform_category | STRING | 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 | INT64 | Ascending rank of the deposit in user's history. |
| deposit_rank_desc | INT64 | Descending rank of the deposit in user's history. |
| last_recredit_date | DATE | The most recent date on which the beneficiary received a new recredit. |
| total_recredit | INT64 | The total number of times the beneficiary received a new recredit. |
| total_recredit_amount | FLOAT64 | The total amount that has been recredited to the beneficiary. |
| total_theoretical_amount_spent | NUMERIC | Total theoretical amount that would have been spent based on expected transactions. |
| total_actual_amount_spent | NUMERIC | Total actual amount spent, reflecting real transactions. |
| total_theoretical_amount_spent_in_digital_goods | NUMERIC | Total theoretical amount spent on digital goods based on expected transactions. |
| total_non_cancelled_individual_bookings | INT64 | Total number of non-cancelled individual bookings made by the user. |
| total_diversity_score | INT64 | The total diversity score of the user or the deposit |
| first_individual_booking_date | DATE | Date of the first individual booking. |
| last_individual_booking_date | DATE | Date of the last individual booking. |
| deposit_seniority | INT64 | Total days between deposit_creation_date and today. Used for analytics purposes. |
| days_between_user_creation_and_deposit_creation | INT64 | Total days between user_creation_date (user activated its account) and deposit_creation_date (user received grant). |
| user_birth_date | DATE | Birth date of the user. |