member_coverage_provider

Member provider selections for primary care, capitated physicians, pharmacy, etc.

Primary Key:

• member_coverage_id
• coverage_provider_number

Foreign Keys:

• member_coverage_id => member_coverage.member_coverage_id
• provider_seen_id => provider_seen.provider_seen_id

Indexes:

• member_coverage_provider_provider_seen_id_idx - provider_seen_id

Column	Data Type	Nullable	Indexed	Description
member_coverage_id	bigint	No	Yes	Link to member coverage record. Generated through expression:
coverage_provider_number	smallint	No	Yes	Sequential number of the provider (from Loop 2310 -> LX01). Generated through expression:
provider_seen_id	bigint	No	Yes	Link to provider seen record. Generated through expression:
provider_type	entity_identifier_type	No	No	Identifies the type of entity for this record (From NM101) Generated through expression:
effective_date	date	Yes	No	Date the provider selection is effective (From PLA03) Generated through expression:
change_reason	maintenance_reason_type	Yes	No	Reason for the change (From PLA05) Generated through expression: