transparency_provider_group

One provider group within a provider reference, identified by its tax identification number.

Primary Key:

• transparency_file_id
• provider_group_id
• provider_group_seq

Foreign Keys:

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

Indexes:

• transparency_provider_group_tin_value_idx - tin_value

Column	Data Type	Nullable	Indexed	Description
transparency_file_id	bigint	No	Yes	Link to the file this group came from. Reference IDs are only unique within a file.
provider_group_id	bigint	No	Yes	Link to the reference holding this group
provider_group_seq	integer	No	Yes	Position of this group within its reference. The payer gives the groups no IDs of their own, so position is the only thing distinguishing them.
tin_type	transparency_tin_type	No	No	Kind of identifier in tin_value
tin_value	text	No	Yes	The group's tax identification number, kept as text because EINs and NPIs have meaningful leading zeros
business_name	text	Yes	No	Name the payer records against the tax identification number, present for a little over half of groups