Stores information about GoFileRoom Workflows. Field lengths match the field lengths defined in GoFileRoom Workflow. |
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. |