Tables [dbo].[Note_Correspondence_Letter]
Maps the Original Document to the Referral Document and its respective NoteLetterID (1,2,3)
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDescription
Cluster Primary Key PK_Note_Correspondence_Letter: IDID[dbo].[dict_id]5NOT NULL1 - 1Key to the Note_Correspondence_Letter table
Indexes NIX_Note_Correspondence_Letter_OriginalDocumentID, TWstat_Note_Correspondence_Letter_OriginalDocumentID(2)Foreign Keys FK_Note_Correspondence_Letter_OriginalDocumentID_Document_DocumentID: [dbo].[Document].OriginalDocumentIDOriginalDocumentID[dbo].[uniqueid]9NOT NULLLink to Document.DocumentID
Indexes TWstat_Note_Correspondence_Letter_ReferralDocumentIDReferralDocumentID[dbo].[uniqueid]9NOT NULLLink to Document.DocumentID and CSS_CC_Distribution.WorkObjectID (the generated referral)
Check Constraints Ch_Note_Correspondence_Letter_NoteLetterID : ([NoteLetterID]>(0) AND [NoteLetterID]<=(3))NoteLetterIDint4NOT NULLOrdinal values (1, 2, or 3) within a set of OriginalDocumentID's  (see CSS_CC_Distribution.NoteLetterID)