Table: dbo.Form_1094c_Aggregate_Group_Member_Outside_Database
Aggregate group members who are not stored as a client in the database
Columns
NameTypeConstraintsDescription
form_1094c_aggregate_group_member_outside_database_KEYint (4)NOT NULLPrimary key for table.
form_1094c_aggregate_group_KEYint (4)NOT NULLPrimary key of the form 1094c Aggregate group associated with outside aggregate group member.
namenvarchar (100)It is use to store name of aggregate group member who was not stored as a client in the database. ["BR"] It allows null values because User may not enter any value. It can be null and empty.["BR"] User may not know that information at the time of entering it.
einnvarchar (22)It is use to stroe ein of aggregate group member who was not stored as a client in the database.["BR"] It allows null values because User may not enter any value. It can be null and empty.["BR"] User may not know that information at the time of entering it.
average_full_time_employeesint (4)It is use to store average full time employees for aggregate group member who was not stored as a client in the database.["BR"] It allows null values because User may not enter any value.
Primary key
NameColumnsDescription
PK_Form_1094c_Aggregate_Group_Member_Outside_Databaseform_1094c_aggregate_group_member_outside_database_KEY
Foreign keys
NameColumnsReferenced 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 (form_1094c_aggregate_group_KEY)

Schema diagram