Table: Staff_Grouping_Type
Tags: read-only

Content:
9941000<Client>'s <Partner>Clientpartner__staff_KEY
9952000<Client>'s <Manager>Clientmanager__staff_KEY
9963000<Client>'s <Associate>Clientassociate__staff_KEY
9974000<Engagement>'s BillerEngagementbiller__staff_KEY
9985000<Engagement>'s ReviewerEngagementreviewer__staff_KEY
9996000<Engagement>'s <Manager>Engagementmanager__staff_KEY
10007000Specified <Staff>
Columns
NameTypeConstraintsDescription
staff_grouping_type_KEYintNOT NULLPrimary key for this table.
sortintNOT NULLUser defined sort for this table.
descriptionnvarchar (250)NOT NULLUser defined description (unique).
table_namenvarchar (128)NOT NULLName of the table used to find the value.
column_namenvarchar (128)NOT NULLName of the column used to find the value.
Primary key
NameColumnsDescription
PK_Staff_Grouping_Type$staff_grouping_type_KEYstaff_grouping_type_KEYCLUSTERED
Unique constraints
NameColumnsDescription
UK_Staff_Grouping_Type$descriptiondescriptionEach description must be unique.
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Engagement_Template__Staff_Grouping_Type__biller__staff_grouping_type_KEYbiller__staff_grouping_type_KEYEngagement_Template
FK_Engagement_Template__Staff_Grouping_Type__manager__staff_grouping_type_KEYmanager__staff_grouping_type_KEYEngagement_Template
FK_Engagement_Template__Staff_Grouping_Type__reviewer__staff_grouping_type_KEYreviewer__staff_grouping_type_KEYEngagement_Template
FK_Project_Template__Staff_Grouping_Type__assigned__staff_grouping_type_KEYassigned__staff_grouping_type_KEYProject_Template
FK_Project_Template__Staff_Grouping_Type__responsible__staff_grouping_type_KEYresponsible__staff_grouping_type_KEYProject_Template
FK_Task_Template__Staff_Grouping_Type__staff_grouping_type_KEYstaff_grouping_type_KEYTask_Template

Schema diagram