Data flow for sites from directory sources and providers

Our 2021Q1 prototype is sites-centered. So our most important production table is **sites_all**. It will get these kinds of information from datasource audit tables [fields in brackets], fields for 3. onwards = series of boolean columns:

1. **Location** [address, zip | lat, long]
2. **Direct info** [website | phone]
3. **Types of MAT** [mat_bupe, mat_mtd, mat_ntrex, mat_other, mat_any]
4. **Setting** [hospital, outpatient, residential, otp, etc.]
5. **Clients/groups served** [pregnant women, veterans, lgbtq, adolescents, seniors, active duty military, clients referred from court/judicial system, etc.]
6. **Insurance/payment options** [medicaid, private insurance, medicare, military insurance, low cost sliding scale, private pay, etc.]
7. **Services** [telehealth, primary care, childcare, housing, mental health counseling, individual counseling, group counseling, Spanish, etc.]

Provider data CONTRIBUTES this information to sites focus:
1. Additional **sites** with buprenorphine (including practices not listed in any site directory + some listed sites that directories don't recognize as offering bupe)
2. **Medical specialties**
3. A rough idea of **prescribing capacity** [waiver limit, reached patient limit]
4. Possibly helpful info re: **insurance** (I'm not sure we'll be able to process this information enough to do anything with it in our February delivery, but it's worth noting as a component of NPI entries that public health stakeholders may be able to use)

Providers get LINKED to sites through two factors:
- **Location** [address, zip | lat, long | sometimes phone, fax]
- **Buprenorphine** waivers
Noting the second factor matters, because sites that offer only **methadone** and/or **naltrexone** for MAT have no provider links. In 2020, we gave those less attention, because HFP had asked us to focus on buprenorphine. But for an MAT (treatment) finder, the other two options are just as important.

...

从 issue 中对 production 表 sites_all、datasource 审计字段以及 provider-to-site linking factors 的描述开始。在确定 implementation entry points 之前，先明确预期的数据流和二月的交付范围。完成时应包括一种已达成共识的方法，用于组合 directory 数据和 provider 数据，同时保留所述的 MAT 区分。

由索引模型根据 Issue 内容生成。