---
# System prepended metadata

title: MVNO Churn Data Dictionary

---

# MVNO Churn Data Dictionary

## MVNO Customer Tenure Data Dictionary
AWS Table Name: `mvno_customer_tenure_agg`
PV Table Name: `mvno_customer_tenure`

1. `mobl_srvc_line_key_aes256`: The mobl_srvc_line_key associated with an account's Phone. Only phones that had a start and end date were allowed in this table. 
2. `wearable_mobl_srvc_line_key_aes256`: A wearables (watches) mobl_srvc_line_key associated with the phone line. In the case of multiple ids the MAX(id) is taken ordering by text.
3. `tablet_mobl_srvc_line_key_aes256`: A tablets mobl_srvc_line_key associated with the phone line. In the case of multiple ids the MAX(id) is taken ordering by text.
4. `mobl_acct_key_aes256`: Additional identifier used in the case mobl_srvc_line duplicates.
5. `encrypted_account_key_256`: The Spectrum Account Key used across Spectrum platforms
6. `earliest_line_activation_date`: Takes the earliest line_activation_date that appears in the last 13 months of data. 
7. `earliest_prr_date`: Takes the earliest PRR date available unless it equals the earliest PRR partition available.
8. `first_deactive_date`: This date corresponds to the first date - within the past 13 months  that an account went from an active to deactive status.
9. `first_deactive_bill_cycle_date`: This date corresponds to the first billing cycle date - within the past 13 months - that an account went from an active to deactive status.
10. `first_deactive_prev_status`: The status a line had before it entered its first deactive status. Can be PR - Prospect, TD - Temporarily Deactivated, SU - Suspended, or AC - Active.
11. `last_deactive_date`: This date corresponds to the last date - within the past 13 months - that an account went from an active to deactive status.
12. `last_deactive_bill_cycle_date`: This date corresponds to the last billing cycle date - within the past 13 months - that an account went from an active to deactive status.
13. `last_deactive_prev_status`: The status a line had before it entered its last deactive status. Can be PR - Prospect, TD - Temporarily Deactivated, SU - Suspended, or AC - Active.
14. `temp_deactive_date`: Corresponds to the first date a line Temporarily Deactivated since its start_date
15. `is_not_active_date`: The first date a line went from is_active=True to is_active=False
16. `last_internet_date`: The last active internet account date from prod.atom_accounts_snapshot table.
17. `port_in_date`: If a line ported-in after 8/2021 then this will record its port-in date. 
18. `port_out_date`: If a line ported-out after 8/2021 then this will record its port-out date.
19. `churn_status`: If the end date represents a churn date (deactivation date or port-out)
20. `start_date`: Prioritizes line_activation_date then earliest_prr_date
21. `end_date`: Chooses the first_deactivation_date then port-out date
22. `tenure_in_days`: Dates between start_date and end_date
23. `temporarily_deactive_line_status_reason`: Reflects the deactivation status reason associated with the temporarily deactive date 
24. `first_deactive_line_status_reason` Reflects the deactivation status reason associated with the first_deactive_date' 
25. `last_deactive_line_status_reason` Reflects the deactivation status reason associated with the last_deactive_date', 
26. `current_status` The line status at run_date
  
## Data Science Model Features
- 5G/LTE ratios
- 5G Usage flag
- mmWave/s6 ratio  (how good their 5g was)
- text/voice preference
- distance to nearest tower
- total tonnage