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
Name | Type | Constraints | Description
subsidiary_client_collection_type_KEY | int (4) | NOT NULL | Primary key.
description | nvarchar (60) | NOT NULL | Description of the subsidiary client collection type.

Primary key
Name | Columns | Description
PK_Subsidiary_Client_Collection_Type | subsidiary_client_collection_type_KEY |
Unique constraints
Name | Columns | Description
UK_Subsidiary_Client_Collection_Type$description | description |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Client_N_Subsidiary_Client__Subsidiary_Client_Collection_Type__subsidiary_client_collection_type_KEY | subsidiary_client_collection_type_KEY | Client_N_Subsidiary_Client |