Table: dbo.Source_Document_Processing_Sort_Order
this table stores the sort order in the engagement tree for documents that have been through source document processing
Columns
Name | Type | Constraints | Description
source_document_processing_sort_order_KEY | tinyint (1) | NOT NULL | primary key
file_type | nvarchar (66) | NOT NULL | name of a type of file that comes back from SDP
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 | tinyint (1) | NOT NULL | default rank order where it should be placed in the engagement tree.
sort_rank_override | tinyint (1) |  | 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_Sort_Order table), create the folder and add an entry to Folder_N_Source_Document_Processing_Sort_Order table.
sort_rank | tinyint (1) | NOT NULL | rank denoting where it should be placed in the engagement tree.

Primary key
Name | Columns | Description
PK_Source_Document_Processing_Sort_Order | source_document_processing_sort_order_KEY |
Unique constraints
Name | Columns | Description
UK_Source_Document_Processing_Sort_Order$sort_rank_original | sort_rank_original |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Folder_N_Source_Document_Processing_Sort_Order__Source_Document_Processing_Sort_Order__source_document_processing_sort_order_ | source_document_processing_sort_order_KEY | Folder_N_Source_Document_Processing_Sort_Order |