Table: dbo.Form_1094c_Aggregate_Group
An aggregate group is made up of related companies that have different EINs but must be considered one entity ["BR"] for determining if they are subject to the Affordable Care Act. ["BR"] Example: TRTA and myPay have their own EINs but are considered part of Thomson Reuters for purposes of the Affordable Care Act.
Columns
NameTypeConstraintsDescription
form_1094c_aggregate_group_KEYint (4)NOT NULLPrimary key for table.
Primary key
NameColumnsDescription
PK_Form_1094c_Aggregate_Groupform_1094c_aggregate_group_KEY
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Form_1094c_Aggregate_Group_Member_Outside_Database__Form_1094c_Aggregate_Group__form_1094c_aggregate_group_KEYform_1094c_aggregate_group_KEYForm_1094c_Aggregate_Group_Member_Outside_Database
FK_Form_1094c_Aggregate_Group_Member__Form_1094c_Aggregate_Group__form_1094c_aggregate_group_KEYform_1094c_aggregate_group_KEYForm_1094c_Aggregate_Group_Member

Schema diagram