location_telecom

Normalized contact points for the location (Location.telecom[]). Each row is one element of the telecom array; anchor_index from stage drives ordering (telecom_rank).

Primary Keys:

• location_telecom_id

Foreign Keys:

• 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

Related Tables:

Parent:

• location