Table: Client_Financial_Data
Columns
Name | Type | Constraints | Description
create__changeset_KEY | int | NOT NULL |
update__changeset_KEY | int | NOT NULL |
client_financial_data_KEY | int | NOT NULL | Assigned by COMMON_dp_Allocate_Unique_Identifiers. primary key for this table
client_KEY | int | NOT NULL | Client this data refers to
client_financial_data_description_KEY | int | NOT NULL | Description of this financial data
integration_application_KEY | int | NOT NULL | The application that provided this data
integration_application_year | int | NOT NULL | The version year of the application that provided this data
tax_year | int | NOT NULL |
financial_value | decimal (25, 6) |  | Whole percentages or whole dollar amounts
entry_date_utc | datetime | NOT NULL | The date the integration application provided this data, in UTC.

Primary key
Name | Columns | Description
PK_Client_Financial_Data$client_KEY$client_financial_data_description_KEY$tax_year | client_KEY, client_financial_data_description_KEY, tax_year | CLUSTERED
Unique constraints
Name | Columns | Description
UK_Client_Financial_Data$client_financial_data_KEY | client_financial_data_KEY |
Indexes
Name | Columns | Description
IX_Client_Financial_Data$client_financial_data_description_KEY | client_financial_data_description_KEY | Index supports foreign key FK_Client_Financial_Data__Client_Financial_Data_Description__client_financial_data_description_KEY
IX_Client_Financial_Data$integration_application_KEY | integration_application_KEY | Index supports foreign key FK_Client_Financial_Data__Integration_Application__integration_application_KEY

Foreign keys
Name | Columns | Referenced table | Description
FK_Client_Financial_Data__Client__client_KEY | client_KEY | Client | on delete cascade;
FK_Client_Financial_Data__Client_Financial_Data_Description__client_financial_data_description_KEY | client_financial_data_description_KEY | Client_Financial_Data_Description |
FK_Client_Financial_Data__Integration_Application__integration_application_KEY | integration_application_KEY | Integration_Application |