transparency_plan_file

Which rate files carry a plan's rates, from one reporting structure of a table of contents. A table of contents lists files from other Blue Cross entities that are never downloaded, so a plan whose files are absent simply has no rows here.

Primary Key:

• transparency_plan_id
• transparency_file_id

Foreign Keys:

• transparency_file_id => transparency_file.transparency_file_id
• transparency_plan_id => transparency_plan.transparency_plan_id

Indexes:

• transparency_plan_file_file_idx - transparency_file_id, transparency_plan_id

Column	Data Type	Nullable	Indexed	Description
transparency_plan_id	bigint	No	Yes	Link to the plan
transparency_file_id	bigint	No	Yes	Link to a rate file carrying the plan's rates