| This table stores the notifications created when certain types of actions are completed by the client in ACS Client Access. |
| client_access_notification_KEY | int (4) | NOT NULL | Primary key for this table |
| client_KEY | int (4) | NOT NULL | The key of the client for which the action was performed. |
| client__staff_KEY | int (4) | NOT NULL | The key of the client staff that completed the action in Client Access. |
| assigned__staff_KEY | int (4) | | The key of the staff assigned as the accountant for related Client Access notification. Null if no accountant is assigned for related notification. |
| description | nvarchar (240) | NOT NULL | The further details of the action that was completed in Client Access. |
| event_date | datetime (8, 3) | NOT NULL | Date/time stamp the action was completed in Client Access. |
| client_access_notification_event_type_KEY | int (4) | NOT NULL | The action that was completed in Client Access. |
| client_access_notification_review_status_KEY | int (4) | NOT NULL | The review status of this Client Access notification. |
| notes | nvarchar (-1) | NOT NULL | Stores the notes entered via the Notification Details dialog. Allows any character type and is not null. |