Table: dbo.Client_W2_State_Override | |||
The table used to store the overrides for a Client's state id numbers. | |||
Columns | |||
Name | Type | Constraints | Description |
client_w2_state_override_KEY | int (4) | NOT NULL | Primary key. |
client_KEY | int (4) | NOT NULL | Foreign key into the client table. |
ste_state_code_KEY | nvarchar (4) | NOT NULL | Foreign key into the Ste state code table. |
state_id_number | nvarchar (50) | NOT NULL | The override for the client's state id. |
client_w2_state_override_type_KEY | int (4) | NOT NULL | The type of override. |
w2_override_type_KEY | int (4) | NOT NULL | The foreign key into the W2_Override_Type table. |
Primary key | |||
Name | Columns | Description | |
PK_Client_W2_State_Override | client_w2_state_override_KEY | ||
Unique constraints | |||
Name | Columns | Description | |
UK_Client_W2_State_Override$client_KEY$ste_state_code_KEY$w2_override_type_KEY | client_KEY, ste_state_code_KEY, w2_override_type_KEY |