| This table stores the information about the association of notes with either the binder, the folder or the workpaper. |
| engagement_item_note_KEY | int (4) | NOT NULL | Primary key. This points to record in the Processing_Note table. |
| engagement_binder_KEY | int (4) | | Foreign key. This points to record in the Binder table. This note exists at the binder level |
| folder_KEY | int (4) | | Foreign key. This points to record in the folder table. This note is present in the folder. |
| workpaper_KEY | int (4) | | Foreign key. This points to record in the workpaper table. The note is present at the workpaper level. |
| engagement_item_note_status_KEY | int (4) | NOT NULL | This is the status of the note, which is either cleared, open or reviewed. |
| priority_KEY | int (4) | NOT NULL | This indicates if the note priority. |
| assigned_to__staff_KEY | int (4) | | This is the staff the note is assigned to. |
| note_subject | nvarchar (100) | NOT NULL | This has the subject of the note. |
| sequence_number | int (4) | NOT NULL | |
| created_date | datetime (8, 3) | NOT NULL | The date the note was created. |
| created_date__staff_KEY | int (4) | | The ID of the staff who created the note. |