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 |