Table: Client_Financial_Data
Columns
NameTypeConstraintsDescription
create__changeset_KEYintNOT NULL
update__changeset_KEYintNOT NULL
client_financial_data_KEYintNOT NULLAssigned by COMMON_dp_Allocate_Unique_Identifiers. primary key for this table
client_KEYintNOT NULLClient this data refers to
client_financial_data_description_KEYintNOT NULLDescription of this financial data
integration_application_KEYintNOT NULLThe application that provided this data
integration_application_yearintNOT NULLThe version year of the application that provided this data
tax_yearintNOT NULL
financial_valuedecimal (25, 6)Whole percentages or whole dollar amounts
entry_date_utcdatetimeNOT NULLThe date the integration application provided this data, in UTC.
Primary key
NameColumnsDescription
PK_Client_Financial_Data$client_KEY$client_financial_data_description_KEY$tax_yearclient_KEY, client_financial_data_description_KEY, tax_yearCLUSTERED
Unique constraints
NameColumnsDescription
UK_Client_Financial_Data$client_financial_data_KEYclient_financial_data_KEY
Indexes
NameColumnsDescription
IX_Client_Financial_Data$client_financial_data_description_KEYclient_financial_data_description_KEYIndex supports foreign key FK_Client_Financial_Data__Client_Financial_Data_Description__client_financial_data_description_KEY
IX_Client_Financial_Data$integration_application_KEYintegration_application_KEYIndex supports foreign key FK_Client_Financial_Data__Integration_Application__integration_application_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Client_Financial_Data__Client__client_KEYclient_KEYClienton delete cascade;
FK_Client_Financial_Data__Client_Financial_Data_Description__client_financial_data_description_KEYclient_financial_data_description_KEYClient_Financial_Data_Description
FK_Client_Financial_Data__Integration_Application__integration_application_KEYintegration_application_KEYIntegration_Application

Schema diagram