Table: Filter_Type
Tags: read-only Content of first 30 of 36 rows:
1 | Staff | <Staff>
2 | Activity | <Activity>
3 | Expense | <Expense>
4 | Client | <Client>
5 | Engagement | <Engagement>
6 | Project | <Project>
7 | Office | <Office>
8 | Sheet_Entry | Time & <Expense> Entry
12 | Invoice | Invoice
13 | Ledger_Entry | Receipt & Adjustment Entry
14 | Engagement_List | <Engagement>
15 | Statement_Selection | Statement Selection
19 | Ledger_Entry | A/R Entry
20 | Billing_Decision |
22 | Billing_Worksheet |
23 | Task | <ProjectTask>
24 | Project_Template | <Project> Template
25 | Production_And_Billing_Posted |
26 | Interaction | <Interaction>
27 | Contact | <Contact>
29 | Project_Template_Definition | <Project> Template
30 | Interaction | <Interaction>
31 | Payroll_Check | Payroll Check
32 | Employee | <Employee>
33 | Billing_Decision_Taxing_Authority |
34 | Integration_Sheet_Entry | Integrated Sheet Entry
35 | Schedule_Item | <ScheduleItem>
37 | Staff_Benefit | <Staff> <Benefit>
38 | Billing_Decision_Collection | Billing Decision Collection
39 | Staff_Education_Credit | <CPECourse>
Columns
Name | Type | Constraints | Description
filter_type_KEY | int | NOT NULL | Primary key for this table.
list_name | nvarchar (128) | NOT NULL | Name of the list that this type of filter limits.
update__staff_KEY | int | NOT NULL |
update_date | datetime | NOT NULL |
description | nvarchar (30) | NOT NULL | User friendly name for this type of filter.

Primary key
Name | Columns | Description
PK_Filter_Type$filter_type_KEY | filter_type_KEY | CLUSTERED

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Filter__Filter_Type__filter_type_KEY | filter_type_KEY | Filter |
FK_Filter_Line_Type__Filter_Type__subfilter__filter_type_KEY | subfilter__filter_type_KEY | Filter_Line_Type |
FK_Filter_Base_Type__Filter_Type__filter_type_KEY | filter_type_KEY | Filter_Base_Type |