Table: Staff_Grouping_Type
Tags: read-only Content:
994 | 1000 | <Client>'s <Partner> | Client | partner__staff_KEY
995 | 2000 | <Client>'s <Manager> | Client | manager__staff_KEY
996 | 3000 | <Client>'s <Associate> | Client | associate__staff_KEY
997 | 4000 | <Engagement>'s Biller | Engagement | biller__staff_KEY
998 | 5000 | <Engagement>'s Reviewer | Engagement | reviewer__staff_KEY
999 | 6000 | <Engagement>'s <Manager> | Engagement | manager__staff_KEY
1000 | 7000 | Specified <Staff> |  |
Columns
Name | Type | Constraints | Description
staff_grouping_type_KEY | int | NOT NULL | Primary key for this table.
sort | int | NOT NULL | User defined sort for this table.
description | nvarchar (250) | NOT NULL | User defined description (unique).
table_name | nvarchar (128) | NOT NULL | Name of the table used to find the value.
column_name | nvarchar (128) | NOT NULL | Name of the column used to find the value.

Primary key
Name | Columns | Description
PK_Staff_Grouping_Type$staff_grouping_type_KEY | staff_grouping_type_KEY | CLUSTERED
Unique constraints
Name | Columns | Description
UK_Staff_Grouping_Type$description | description | Each description must be unique.

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Engagement_Template__Staff_Grouping_Type__biller__staff_grouping_type_KEY | biller__staff_grouping_type_KEY | Engagement_Template |
FK_Engagement_Template__Staff_Grouping_Type__manager__staff_grouping_type_KEY | manager__staff_grouping_type_KEY | Engagement_Template |
FK_Engagement_Template__Staff_Grouping_Type__reviewer__staff_grouping_type_KEY | reviewer__staff_grouping_type_KEY | Engagement_Template |
FK_Project_Template__Staff_Grouping_Type__assigned__staff_grouping_type_KEY | assigned__staff_grouping_type_KEY | Project_Template |
FK_Project_Template__Staff_Grouping_Type__responsible__staff_grouping_type_KEY | responsible__staff_grouping_type_KEY | Project_Template |
FK_Task_Template__Staff_Grouping_Type__staff_grouping_type_KEY | staff_grouping_type_KEY | Task_Template |