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
NameTypeConstraintsDescription
source_document_processing_tax_organizer_sort_order_KEYsmallint (2)NOT NULLPrimary key.
file_typenvarchar (100)NOT NULLName of a type of file that comes back from Source Document Processing.
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_originalsmallint (2)NOT NULLDefault rank order where it should be placed in the engagement tree.
sort_rank_overridesmallint (2)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_Tax_Organizer_Sort_Order table), create the folder and add an entry to Folder_N_Source_Document_Processing_Tax_Organizer_Sort_Order table.
sort_ranksmallint (2)NOT NULLRank denoting where it should be placed in the engagement tree.
Primary key
NameColumnsDescription
PK_Source_Document_Processing_Tax_Organizer_Sort_Ordersource_document_processing_tax_organizer_sort_order_KEY
Unique constraints
NameColumnsDescription
UK_Source_Document_Processing_Tax_Organizer_Sort_Order$sort_rank_originalsort_rank_original
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Folder_N_Source_Document_Processing_Tax_Organizer_Sort_Order__Source_Document_Processing_Tax_Organizer_Sort_Order__source_docsource_document_processing_tax_organizer_sort_order_KEYFolder_N_Source_Document_Processing_Tax_Organizer_Sort_Order

Schema diagram