Table: dbo.Client_W2_State_Override
The table used to store the overrides for a Client's state id numbers.
Columns
NameTypeConstraintsDescription
client_w2_state_override_KEYint (4)NOT NULLPrimary key.
client_KEYint (4)NOT NULLForeign key into the client table.
ste_state_code_KEYnvarchar (4)NOT NULLForeign key into the Ste state code table.
state_id_numbernvarchar (50)NOT NULLThe override for the client's state id.
client_w2_state_override_type_KEYint (4)NOT NULLThe type of override.
w2_override_type_KEYint (4)NOT NULLThe foreign key into the W2_Override_Type table.
Primary key
NameColumnsDescription
PK_Client_W2_State_Overrideclient_w2_state_override_KEY
Unique constraints
NameColumnsDescription
UK_Client_W2_State_Override$client_KEY$ste_state_code_KEY$w2_override_type_KEYclient_KEY, ste_state_code_KEY, w2_override_type_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Client_W2_State_Override__Client__client_KEYclient_KEYClient (client_KEY)
FK_Client_W2_State_Override__Client_W2_State_Override_Type__client_w2_state_override_type_KEYclient_w2_state_override_type_KEYClient_W2_State_Override_Type (client_w2_state_override_type_KEY)
FK_Client_W2_State_Override__Ste_State_Code__ste_state_code_KEYste_state_code_KEYSte_State_Code (ste_state_code_KEY)
FK_Client_W2_State_Override__W2_Override_Type__w2_override_type_KEYw2_override_type_KEYW2_Override_Type (w2_override_type_KEY)

Schema diagram