Location.telecom[]). Each row is one element of the telecom array; anchor_index from stage drives ordering (telecom_rank).
Primary Keys:
- location_telecom_id
- location_id - links to the location table
† Metriport Platform added
| Column | Data Type | Description |
|---|---|---|
| location_telecom_id | varchar | Surrogate key for this telecom row |
| location_id | varchar | Parent location |
| system | varchar | Contact system: e.g. phone, fax, email, pager, url, sms, other |
| use | varchar | Purpose of contact: home, work, temp, old, mobile |
| value | varchar | The actual phone number, email address, URL, etc. |
| telecom_rank† | int | Stable order of this telecom within the location |