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
NameTypeConstraintsDescription
employee_reconciliation_tax_form_tax_jurisdiction_override_month_amount_KEYint (4)NOT NULLPrimary Key
employee_reconciliation_tax_form_tax_jurisdiction_override_KEYint (4)NOT NULLemployee/tax jurisdiction this override is related to
reconciliation_tax_form_override_type_KEYint (4)NOT NULLType of monthly amount this override is for
month_valueint (4)NOT NULLMonth (1-12) this override amount is for
amountdecimal (9, 2)NOT NULLoverride amount
Primary key
NameColumnsDescription
PK_Employee_Reconciliation_Tax_Form_Tax_Jurisdiction_Override_Month_Amountemployee_reconciliation_tax_form_tax_jurisdiction_override_month_amount_KEY
Unique constraints
NameColumnsDescription
UK_Employee_Reconciliation_Tax_Form_Tax_Jurisdiction_Override_Month_Amount$employee_reconciliation_tax_form_tax_jurisdiction_oveemployee_reconciliation_tax_form_tax_jurisdiction_override_KEY, reconciliation_tax_form_override_type_KEY, month_value
Foreign keys
NameColumnsReferenced tableDescription
FK_Employee_Reconciliation_Tax_Form_Tax_Jurisdiction_Override_Month_Amount__Employee_Reconciliation_Tax_Form_Tax_Jurisdiction_Ovemployee_reconciliation_tax_form_tax_jurisdiction_override_KEYEmployee_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__reconciliatioreconciliation_tax_form_override_type_KEYReconciliation_Tax_Form_Override_Type (reconciliation_tax_form_override_type_KEY)

Schema diagram