Table: Filter_Type
Tags: read-only

Content of first 30 of 36 rows:
1Staff<Staff>
2Activity<Activity>
3Expense<Expense>
4Client<Client>
5Engagement<Engagement>
6Project<Project>
7Office<Office>
8Sheet_EntryTime & <Expense> Entry
12InvoiceInvoice
13Ledger_EntryReceipt & Adjustment Entry
14Engagement_List<Engagement>
15Statement_SelectionStatement Selection
19Ledger_EntryA/R Entry
20Billing_Decision
22Billing_Worksheet
23Task<ProjectTask>
24Project_Template<Project> Template
25Production_And_Billing_Posted
26Interaction<Interaction>
27Contact<Contact>
29Project_Template_Definition<Project> Template
30Interaction<Interaction>
31Payroll_CheckPayroll Check
32Employee<Employee>
33Billing_Decision_Taxing_Authority
34Integration_Sheet_EntryIntegrated Sheet Entry
35Schedule_Item<ScheduleItem>
37Staff_Benefit<Staff> <Benefit>
38Billing_Decision_CollectionBilling Decision Collection
39Staff_Education_Credit<CPECourse>
Columns
NameTypeConstraintsDescription
filter_type_KEYintNOT NULLPrimary key for this table.
list_namenvarchar (128)NOT NULLName of the list that this type of filter limits.
update__staff_KEYintNOT NULL
update_datedatetimeNOT NULL
descriptionnvarchar (30)NOT NULLUser friendly name for this type of filter.
Primary key
NameColumnsDescription
PK_Filter_Type$filter_type_KEYfilter_type_KEYCLUSTERED
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Filter__Filter_Type__filter_type_KEYfilter_type_KEYFilter
FK_Filter_Line_Type__Filter_Type__subfilter__filter_type_KEYsubfilter__filter_type_KEYFilter_Line_Type
FK_Filter_Base_Type__Filter_Type__filter_type_KEYfilter_type_KEYFilter_Base_Type

Schema diagram