Table: dbo.State_Definition
Columns
NameTypeConstraintsDescription
state_definition_KEYint (4)NOT NULLPrimary key for this table
ste_state_code_KEYnvarchar (4)NOT NULLSymmetry state code
has_withholdingbit (1)NOT NULLFlag to indicate if the state has tax withholding
uses_seasonalbit (1)NOT NULLFlag to indicate if the associated state uses a seasonal flag
uses_nexusbit (1)NOT NULLFlag to indicate if the associated state uses a nexus flag
default_use_whole_dollar_roundingbit (1)NOT NULLDefault for the Tax_Jurisdiction_State_Setting use_whole_dollar_rounding field when a new row is created
is_whole_dollar_rounding_editablebit (1)NOT NULLFlag to indicate if the user can change the whole_dollar_rounding flag for the state
uses_workers_compensation_idbit (1)NOT NULLFlag to indicate if the associated state uses a workers_compensation_id
uses_business_numberbit (1)NOT NULLFlag to indicate if the associated state uses a business_number
uses_governmental_reimbursable_employerbit (1)NOT NULLFlag to indicate if the state needs the governmental reimbursable employer checkbox displayed.
Primary key
NameColumnsDescription
PK_State_Definitionstate_definition_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_State_Definition__Ste_State_Code__ste_state_code_KEYste_state_code_KEYSte_State_Code (ste_state_code_KEY)

Schema diagram