| Table: dbo.Processing_Note | |||
| Columns | |||
| Name | Type | Constraints | Description |
| processing_note_KEY | int (4) | NOT NULL | Primary key for the Processing_Note table |
| client_KEY | int (4) | NOT NULL | Key to associated client. |
| note | nvarchar (8000) | NOT NULL | XML text representing the processing note with formatting included. |
| created_date | datetime (8, 3) | NOT NULL | The date the note was originally created. |
| created_date__staff_KEY | int (4) | The staff ID of the user who created the note. | |
| edited_date | datetime (8, 3) | NOT NULL | The date the note was last edited. |
| edited_date__staff_KEY | int (4) | The staff ID of the user who last edited the note. | |
| processing_note_category_KEY | int (4) | NOT NULL | Key to type of note. |
| engagement_item_note_KEY | int (4) | The foreign key to the engagement_item_note table. | |
| processing_note_type_KEY | int (4) | NOT NULL | The type of note this record is for |
| sequence_number | int (4) | NOT NULL | The placement of this note relative to other notes of the same type |
| Primary key | |||
| Name | Columns | Description | |
| PK_Processing_Note | processing_note_KEY | ||