Table: dbo.Selection_Scope
Columns
NameTypeConstraintsDescription
selection_scope_KEYint (4)NOT NULLunique key
descriptionnvarchar (20)NOT NULLDescription
Primary key
NameColumnsDescription
PK_Selection_Scopeselection_scope_KEY
Unique constraints
NameColumnsDescription
UK_Selection_Scope$descriptiondescription
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Firm_Notification_Information__Selection_Scope__additional_contacts_notification__selection_scope_KEYadditional_contacts_notification__selection_scope_KEYFirm_Notification_Information
FK_Client_Benefit__Selection_Scope__selection_scope_KEYselection_scope_KEYClient_Benefit
FK_Client_Payroll_Information__Selection_Scope__shortfall_deduction__selection_scope_KEYshortfall_deduction__selection_scope_KEYClient_Payroll_Information
FK_Client_Payroll_Information__Selection_Scope__shortfall_tax__selection_scope_KEYshortfall_tax__selection_scope_KEYClient_Payroll_Information
FK_Client_Payroll_Item__Selection_Scope__accruable_benefits__selection_scope_KEYaccruable_benefits__selection_scope_KEYClient_Payroll_Item
FK_Client_Payroll_Item__Selection_Scope__selection_scope_KEYselection_scope_KEYClient_Payroll_Item
FK_Payroll_Check_Entry_Option__Selection_Scope__deduction_exclusion__selection_scope_KEYdeduction_exclusion__selection_scope_KEYPayroll_Check_Entry_Option
FK_Payroll_Check_Entry_Option__Selection_Scope__employer_contribution_exclusion__selection_scope_KEYemployer_contribution_exclusion__selection_scope_KEYPayroll_Check_Entry_Option
FK_Payroll_Check_Entry_Option__Selection_Scope__pay_exclusion__selection_scope_KEYpay_exclusion__selection_scope_KEYPayroll_Check_Entry_Option
FK_Payroll_Check_Entry_Option__Selection_Scope__shortfall_deduction__selection_scope_KEYshortfall_deduction__selection_scope_KEYPayroll_Check_Entry_Option
FK_Payroll_Check_Entry_Option__Selection_Scope__shortfall_tax__selection_scope_KEYshortfall_tax__selection_scope_KEYPayroll_Check_Entry_Option

Schema diagram