The LetterCustomData Table
On a Client server, the LetterCustomData table contains any information the the letter creator wishes to store, such as patient hospital numbers. appointment dates or reference numbers. This information is usually required so that it can be included in reports.
On a Master Server, this table is used to store information about the letter as it exists on the Client Server. This is required so that the Master server can update the Client Server with information about delivery or returns.
| LetterID | The UniqueID of the letter on this Master Server |
| CustomDataField1 | The ID of the Client Server where the letter was created |
| CustomDataField2 | The UniqueID of the letter on the Client Server |
| CustomDataField3 | The TemplateID that the letter was created with on the Client Server |
| CustomDataField4 | The OrganisationID that created the letter |
| CustomDataField5 | The UserID that created the letter |
| CustomDataField6 | The UserName that created the letter |
| CustomDataField7 | The GroupID of the user who created the letter |
| CustomDataField8 | The GroupName of the user |
| CustomDataField9 | The LetterName field |
| CustomDataField10 | The LetterStream field (or, if no LetterStream exists) the OrganisationName |