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.
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.
client_w2_filing_KEYint (4)NOT NULLclient w2 filing KEY
Primary key
NameColumnsDescription
PK_Client_W2_State_Overrideclient_w2_state_override_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Client_W2_State_Override__Client_W2_Filing__client_w2_filing_KEYclient_w2_filing_KEYClient_W2_Filing (client_w2_filing_KEY)FOREIGN KEY constraint of client_w2_filing_KEY for the Client_W2_State_Override table
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)

Schema diagram