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. |