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
Name | Type | Constraints | Description
firm_transitory_information_KEY | tinyint (1) | NOT NULL | The primary key.
firm_KEY | int (4) | NOT NULL | The corresponding firm key.
last_vo_staff_sync_date | nvarchar (46) | NOT NULL | Last instance in time we synchronized client staff data with Web Services.
last_vo_profile_sync_date | nvarchar (46) | NOT NULL | Last instance in time we synchronized data location profile data with Web Services.

Primary key
Name | Columns | Description
PK_Firm_Transitory_Information | firm_transitory_information_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Firm_Transitory_Information__Firm__firm_KEY | firm_KEY | Firm (firm_KEY) |