Table: dbo.Withholding_Deposit_Schedule
Columns
NameTypeConstraintsDescription
withholding_deposit_schedule_KEYint (4)NOT NULLPrimary key for this table
ste_state_code_KEYnvarchar (4)NOT NULLSymmetry state code
is_default_itembit (1)NOT NULLItem is default
withholding_deposit_frequency_KEYnvarchar (50)NOT NULLFK into Withholding_Deposit_Frequency table; the frequency that tax withholdings are to be deposited
Primary key
NameColumnsDescription
PK_Withholding_Deposit_Schedulewithholding_deposit_schedule_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Withholding_Deposit_Schedule__Ste_State_Code__ste_state_code_KEYste_state_code_KEYSte_State_Code (ste_state_code_KEY)
FK_Withholding_Deposit_Schedule__Withholding_Deposit_Frequency__withholding_deposit_frequency_KEYwithholding_deposit_frequency_KEYWithholding_Deposit_Frequency (withholding_deposit_frequency_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Client_Payroll_Information__Withholding_Deposit_Schedule__withholding_deposit_schedule_KEYwithholding_deposit_schedule_KEYClient_Payroll_Information
FK_Tax_Jurisdiction_State_Setting__Withholding_Deposit_Schedule__withholding_deposit_schedule_KEYwithholding_deposit_schedule_KEYTax_Jurisdiction_State_Setting

Schema diagram