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
NameTypeConstraintsDescription
form_1094c_aggregate_group_member_KEYint (4)NOT NULLPrimary key for table.
form_1094c_aggregate_group_KEYint (4)NOT NULLPrimary key of the form 1094c Aggregate group associated with aggregate group member.
client_KEYint (4)NOT NULLPrimary key of the client associated with aggregate group member.
Primary key
NameColumnsDescription
PK_Form_1094c_Aggregate_Group_Memberform_1094c_aggregate_group_member_KEY
Unique constraints
NameColumnsDescription
UK_Form_1094c_Aggregate_Group_Member$client_KEYclient_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Form_1094c_Aggregate_Group_Member__Client__client_KEYclient_KEYClient (client_KEY)
FK_Form_1094c_Aggregate_Group_Member__Form_1094c_Aggregate_Group__form_1094c_aggregate_group_KEYform_1094c_aggregate_group_KEYForm_1094c_Aggregate_Group (form_1094c_aggregate_group_KEY)

Schema diagram