Table: dbo.Subsidiary_Client_Collection_Type
The table enumerates the two different types of subsidiary client collections a master consolidated client can have associated with it. The first collection of subsidiary clients is called the User Selected to Consolidate collection and has a key value of 1. This type indicates those subsidiary clients that the user has selected to be consolidated. The second collection is called the Currently Consolidated collection and has a key value of 2. This type indicates those subsidiary clients that have been consolidated and are currently part of the master client's consolidated data.
Columns
NameTypeConstraintsDescription
subsidiary_client_collection_type_KEYint (4)NOT NULLPrimary key.
descriptionnvarchar (60)NOT NULLDescription of the subsidiary client collection type.
Primary key
NameColumnsDescription
PK_Subsidiary_Client_Collection_Typesubsidiary_client_collection_type_KEY
Unique constraints
NameColumnsDescription
UK_Subsidiary_Client_Collection_Type$descriptiondescription
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Client_N_Subsidiary_Client__Subsidiary_Client_Collection_Type__subsidiary_client_collection_type_KEYsubsidiary_client_collection_type_KEYClient_N_Subsidiary_Client

Schema diagram