Table: dbo.Source_Document_Processing_Tax_Organizer_Sort_Order
This table stores the sort order in the engagement tree for tax organizer documents that have been through source document processing.
Columns
Name | Type | Constraints | Description
source_document_processing_tax_organizer_sort_order_KEY | smallint (2) | NOT NULL | Primary key.
file_type | nvarchar (100) | NOT NULL | Name of a type of file that comes back from Source Document Processing.
folder_name_original | nvarchar (250) | NOT NULL | The default name of the folder that this document type will go into.
folder_name_override | nvarchar (250) |  | The override folder will be null until user starts to customize. When restore defaults, make this column null.
sort_rank_original | smallint (2) | NOT NULL | Default rank order where it should be placed in the engagement tree.
sort_rank_override | smallint (2) |  | The override sort rank will be null until user starts to customize. When restore defaults, make this column null.
folder_name | nvarchar (250) | NOT NULL | Folder that this document type will go into. If the folder is not found within the binder (no entry is found in the Folder_N_Source_Document_Processing_Tax_Organizer_Sort_Order table), create the folder and add an entry to Folder_N_Source_Document_Processing_Tax_Organizer_Sort_Order table.
sort_rank | smallint (2) | NOT NULL | Rank denoting where it should be placed in the engagement tree.

Primary key
Name | Columns | Description
PK_Source_Document_Processing_Tax_Organizer_Sort_Order | source_document_processing_tax_organizer_sort_order_KEY |
Unique constraints
Name | Columns | Description
UK_Source_Document_Processing_Tax_Organizer_Sort_Order$sort_rank_original | sort_rank_original |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Folder_N_Source_Document_Processing_Tax_Organizer_Sort_Order__Source_Document_Processing_Tax_Organizer_Sort_Order__source_doc | source_document_processing_tax_organizer_sort_order_KEY | Folder_N_Source_Document_Processing_Tax_Organizer_Sort_Order |