Population User Deposits
This table records deposit activity for users over time, including user details and transaction information.
Business Rules
- The table is incrementally updated using an insert-overwrite strategy.
- It tracks deposits between their creation date and expiration date.
- User age is calculated dynamically based on the transaction date.
Table description
| name | data_type | description |
|---|---|---|
| deposit_active_date | DATE | Active date of a deposit. |
| user_id | STRING | Unique identifier for a user. |
| user_department_code | STRING | Department code associated with the user's registered address. |
| user_region_name | STRING | Region name of the user's registered address. |
| user_birth_date | DATE | Birth date of the user. |
| deposit_id | STRING | Unique identifier for the deposit. |
| deposit_amount | FLOAT | 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). |
| deposit_creation_date | DATE | The date when the deposit was created. |
| deposit_type | STRING | Type of the deposit, can be GRANT_18, GRANT_15_17, GRANT_17_18, GRANT_FREE. |
| user_age | INTEGER | Current age of the user. |