Table: dbo.Form_1094c_Aggregate_Group_Member
A client in the database that is associated with an aggregrate group for Affordable Care Act purposes.
Columns
Name | Type | Constraints | Description
form_1094c_aggregate_group_member_KEY | int (4) | NOT NULL | Primary key for table.
form_1094c_aggregate_group_KEY | int (4) | NOT NULL | Primary key of the form 1094c Aggregate group associated with aggregate group member.
client_KEY | int (4) | NOT NULL | Primary key of the client associated with aggregate group member.

Primary key
Name | Columns | Description
PK_Form_1094c_Aggregate_Group_Member | form_1094c_aggregate_group_member_KEY |
Unique constraints
Name | Columns | Description
UK_Form_1094c_Aggregate_Group_Member$client_KEY | client_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Form_1094c_Aggregate_Group_Member__Client__client_KEY | client_KEY | Client (client_KEY) |
FK_Form_1094c_Aggregate_Group_Member__Form_1094c_Aggregate_Group__form_1094c_aggregate_group_KEY | form_1094c_aggregate_group_KEY | Form_1094c_Aggregate_Group (form_1094c_aggregate_group_KEY) |