| Table: dbo.Tax_Jurisdiction | |||
| Columns | |||
| Name | Type | Constraints | Description |
| tax_jurisdiction_KEY | int (4) | NOT NULL | Primary key of this table. |
| description | nvarchar (160) | NOT NULL | Description of Tax_Jurisdiction record. |
| client_KEY | int (4) | NOT NULL | Key of associated client. |
| tax_jurisdiction_type_KEY | nvarchar (30) | NOT NULL | Type of tax jurisdiction. |
| parent__tax_jurisdiction_KEY | int (4) | parent__tax_jurisdiction_KEY | |
| ste_state_code_KEY | nvarchar (4) | NOT NULL | STE state code |
| do_not_consolidate | bit (1) | NOT NULL | A flag to mark certain jurisdictions as not consolidated.["BR"] If this flag is true, payroll tax forms should be filed at an individual client level. |
| Primary key | |||
| Name | Columns | Description | |
| PK_Tax_Jurisdiction | tax_jurisdiction_KEY | ||
| Unique constraints | |||
| Name | Columns | Description | |
| UK_Tax_Jurisdiction$client_KEY$description$tax_jurisdiction_type_KEY$ste_state_code_KEY | client_KEY, description, tax_jurisdiction_type_KEY, ste_state_code_KEY | ||