Table: dbo.Firm_Transitory_Information
This table stores firm information that changes often. Updates to the firm table can cause blocking if other long running queries are ongoing.
Columns
NameTypeConstraintsDescription
firm_transitory_information_KEYtinyint (1)NOT NULLThe primary key.
firm_KEYint (4)NOT NULLThe corresponding firm key.
last_vo_staff_sync_datenvarchar (46)NOT NULLLast instance in time we synchronized client staff data with Web Services.
last_vo_profile_sync_datenvarchar (46)NOT NULLLast instance in time we synchronized data location profile data with Web Services.
Primary key
NameColumnsDescription
PK_Firm_Transitory_Informationfirm_transitory_information_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Firm_Transitory_Information__Firm__firm_KEYfirm_KEYFirm (firm_KEY)

Schema diagram