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
NameTypeConstraintsDescription
source_document_processing_sort_order_KEYtinyint (1)NOT NULLprimary key
file_typenvarchar (66)NOT NULLname of a type of file that comes back from SDP
folder_name_originalnvarchar (250)NOT NULLthe default name of the folder that this document type will go into.
folder_name_overridenvarchar (250)the override folder will be null until user starts to customize. When restore defaults, make this column null.
sort_rank_originaltinyint (1)NOT NULLdefault rank order where it should be placed in the engagement tree.
sort_rank_overridetinyint (1)the override sort rank will be null until user starts to customize. When restore defaults, make this column null.
folder_namenvarchar (250)NOT NULLfolder 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_ranktinyint (1)NOT NULLrank denoting where it should be placed in the engagement tree.
Primary key
NameColumnsDescription
PK_Source_Document_Processing_Sort_Ordersource_document_processing_sort_order_KEY
Unique constraints
NameColumnsDescription
UK_Source_Document_Processing_Sort_Order$sort_rank_originalsort_rank_original
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Folder_N_Source_Document_Processing_Sort_Order__Source_Document_Processing_Sort_Order__source_document_processing_sort_order_source_document_processing_sort_order_KEYFolder_N_Source_Document_Processing_Sort_Order

Schema diagram