Table: Gofileroom_Workflow
Stores information about GoFileRoom Workflows. Field lengths match the field lengths defined in GoFileRoom Workflow.
Columns
Name | Type | Constraints | Description
gofileroom_workflow_KEY | int | NOT NULL | Assigned by COMMON_dp_Allocate_Unique_Identifiers. Primary key for this table.
folder_id | nvarchar (10) | NOT NULL | One of four required fields that uniquely identify a workflow, not intended to be viewed by users.
workflow_id | int | NOT NULL | One of four required fields that uniquely identify a workflow, not intended to be viewed by users.
workflow_template_id | int | NOT NULL | One of four required fields that uniquely identify a workflow, not intended to be viewed by users.
service_type_id | int | NOT NULL | One of four required fields that uniquely identify a workflow, not intended to be viewed by users.
client_name | nvarchar (255) | NOT NULL | GoFileRoom Client name of this workflow.
client_number | nvarchar (255) | NOT NULL | GoFileRoom Client number of this workflow.
engagement | nvarchar (255) | NOT NULL | GoFileRoom engagement of this workflow.
workflow_year | nvarchar (255) | NOT NULL | GoFileRoom year of this workflow.
period_end | nvarchar (255) | NOT NULL | GoFileRoom period end date part of this workflow.
workflow | nvarchar (255) | NOT NULL | GoFileRoom workflow template description of this workflow.
workflow_description | nvarchar (255) | NOT NULL | GoFileRoom workflow description of this workflow.
service_type | nvarchar (255) | NOT NULL | GoFileRoom folder name in which this workflow exists.
person_in_charge | nvarchar (100) | NOT NULL | GoFileRoom name of the person in charge of this workflow.

Primary key
Name | Columns | Description
PK_Gofileroom_Workflow$gofileroom_workflow_KEY | gofileroom_workflow_KEY | CLUSTERED
Unique constraints
Name | Columns | Description
UK_Gofileroom_Workflow$folder_id$workflow_id$workflow_template_id$service_type_id | folder_id, workflow_id, workflow_template_id, service_type_id | GoFileRoom Workflows are uniquely identified by the combination of these four fields.

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Project__Gofileroom_Workflow__gofileroom_workflow_KEY | gofileroom_workflow_KEY | Project |