Table: dbo.Employee_Reconciliation_Tax_Form_Tax_Jurisdiction_Override_Month_Amount
Provide employee reconciliation form override monthly overrride amounts from the employee detail view grid
Columns
Name | Type | Constraints | Description
employee_reconciliation_tax_form_tax_jurisdiction_override_month_amount_KEY | int (4) | NOT NULL | Primary Key
employee_reconciliation_tax_form_tax_jurisdiction_override_KEY | int (4) | NOT NULL | employee/tax jurisdiction this override is related to
reconciliation_tax_form_override_type_KEY | int (4) | NOT NULL | Type of monthly amount this override is for
month_value | int (4) | NOT NULL | Month (1-12) this override amount is for
amount | decimal (9, 2) | NOT NULL | override amount

Primary key
Name | Columns | Description
PK_Employee_Reconciliation_Tax_Form_Tax_Jurisdiction_Override_Month_Amount | employee_reconciliation_tax_form_tax_jurisdiction_override_month_amount_KEY |
Unique constraints
Name | Columns | Description
UK_Employee_Reconciliation_Tax_Form_Tax_Jurisdiction_Override_Month_Amount$employee_reconciliation_tax_form_tax_jurisdiction_ove | employee_reconciliation_tax_form_tax_jurisdiction_override_KEY, reconciliation_tax_form_override_type_KEY, month_value |

Foreign keys
Name | Columns | Referenced table | Description
FK_Employee_Reconciliation_Tax_Form_Tax_Jurisdiction_Override_Month_Amount__Employee_Reconciliation_Tax_Form_Tax_Jurisdiction_Ov | employee_reconciliation_tax_form_tax_jurisdiction_override_KEY | Employee_Reconciliation_Tax_Form_Tax_Jurisdiction_Override (employee_reconciliation_tax_form_tax_jurisdiction_override_KEY) |
FK_Employee_Reconciliation_Tax_Form_Tax_Jurisdiction_Override_Month_Amount__Reconciliation_Tax_Form_Override_Type__reconciliatio | reconciliation_tax_form_override_type_KEY | Reconciliation_Tax_Form_Override_Type (reconciliation_tax_form_override_type_KEY) |