| tax_jurisdiction_KEY | int (4) | NOT NULL | Reference to parent tax jurisdiction |
| withholding_id | nvarchar (40) | NOT NULL | Withholding identification number used by state |
| suta_id | nvarchar (40) | NOT NULL | State unemployment tax identification number |
| withholding_deposit_schedule_KEY | int (4) | | DANGER!!! Not what it seems! In some cases foreign key to the Withholding_Deposit_Schedule table, but in others, the value is actually the primary surrogate key into the Vendor_Agent_Payment_Schedule table and is a vendor_agent_payment_schedule_KEY, which works only because the former table has nearly a superset of valid keys from the latter. Here be dragons, they are hungry, and you are coated in ketchup. |
| has_nexus | bit (1) | NOT NULL | Flag to indicate if the client has a business presence in the state - used by the Symetry Tax Engine |
| use_whole_dollar_rounding | bit (1) | NOT NULL | Flag to indicate if amounts are rounded to whole dollars |
| workers_compensation_id | nvarchar (40) | NOT NULL | State Workers Compensation ID |
| business_number | nvarchar (40) | NOT NULL | Formatted number assigned by the state to identify the business. Size and format are state dependant. Only applicable to certain states. |
| default__vendor_KEY | int (4) | | This is the default vendor key to use when adding a new tax item that applies to the state. This is nullable since a default vendor KEY does not need to be selected for a state. |
| employer_pays_full_wbf_assessment | bit (1) | NOT NULL | Flag to indicate if the employer pays the full Workers Benefit Fund assessment. |
| w2_psd_code | nvarchar (18) | NOT NULL | Political subdivison code used for Pennsylvania W-2s. |
| governmental_reimbursable_employer | bit (1) | NOT NULL | Flag to indicate if the employer is a governmental reimbursable employer. |
| employer_pays_full_employee_pfml_share | bit (1) | NOT NULL | Flag to indicate if the employer pays the full employee PFML share. |
| employer_pays_full_ccc_tax | bit (1) | NOT NULL | Flag to indicate if the employer pays the full CCC tax. 1 = employer pays. 0 = employee pays. |
| employer_subject_pfml_parental_leave_only | bit (1) | NOT NULL | Flag to indicate if the employer subject to PFML parental leave only tax. 1 = reduced coverage, reduced rate. 0 = full coverage, full rate (unless exempt). |