transparency_provider_set

Which provider sets a provider reference belongs to. A set is one distinct combination of references that rates apply to, so a rate names its combination with a provider_set_id instead of carrying a row per provider. The memberships are an array per reference because a row each costs over thirty times as much, nearly all of it per row overhead and index entries for a four byte value. A set is not a payer concept such as a network or a tier, a single reference belongs to thousands of them.

Primary Key:

• transparency_file_id
• provider_group_id

Checks:

• transparency_provider_set_ids_ascending_check - claims.array_is_ascending(provider_set_ids)
• transparency_provider_set_ids_distinct_check - claims.array_is_distinct(provider_set_ids)

Foreign Keys:

• transparency_file_id => transparency_provider_reference.transparency_file_id, provider_group_id => transparency_provider_reference.provider_group_id

Column	Data Type	Nullable	Indexed	Description
transparency_file_id	bigint	No	Yes	Link to the file these sets came from. Reference and set IDs are only unique within a file.
provider_group_id	bigint	No	Yes	The provider reference these sets contain
provider_set_ids	integer[]	No	No	Every set this reference belongs to, ascending. Assigned by the loader per file while deduplicating the reference lists.