# Data Dictionary — index

Source: batch 0999


Per-dataset dictionaries (field, type, keys, expected & observed unique values, stats):

- [eligibility](dict_eligibility.md) — see also CSV: `dict_eligibility.csv`
- [revenue](dict_revenue.md) — see also CSV: `dict_revenue.csv`
- [medical_claims](dict_medical_claims.md) — see also CSV: `dict_medical_claims.csv`
- [rx_claims](dict_rx_claims.md) — see also CSV: `dict_rx_claims.csv`

Key conventions:

- **PK**: primary key (unique in dataset)
- **PK part**: part of composite primary key (e.g., `claim_id` + `claim_line_id`)
- **FK**: foreign key to another dataset (notation: `FK:dataset.field`)

**Composite primary keys:**
- eligibility: `(member_id, eligibility_year_month)`
- revenue: `(member_id, eligibility_year_month)` (FK to eligibility)
- medical_claims: `(claim_id, claim_line_id)`
- rx_claims: `(claim_id, claim_line_id)`

**Foreign keys to eligibility:**
- revenue.member_id, medical_claims.member_id, rx_claims.member_id
