Table: dbo.Client_Access_Notification
This table stores the notifications created when certain types of actions are completed by the client in ACS Client Access.
Columns
Name | Type | Constraints | Description
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.

Primary key
Name | Columns | Description
PK_Client_Access_Notification | client_access_notification_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Client_Access_Notification__Client__client_KEY | client_KEY | Client (client_KEY) |
FK_Client_Access_Notification__Client_Access_Notification_Event_Type__client_access_notification_event_type_KEY | client_access_notification_event_type_KEY | Client_Access_Notification_Event_Type (client_access_notification_event_type_KEY) |
FK_Client_Access_Notification__Client_Access_Notification_Review_Status__client_access_notification_review_status_KEY | client_access_notification_review_status_KEY | Client_Access_Notification_Review_Status (client_access_notification_review_status_KEY) |
FK_Client_Access_Notification__Staff__assigned__staff_KEY | assigned__staff_KEY | Staff (staff_KEY) |
FK_Client_Access_Notification__Staff__client__staff_KEY | client__staff_KEY | Staff (staff_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Recorded_Event_Object_N_Client_Access_Notification__Client_Access_Notification__client_access_notification_KEY | client_access_notification_KEY | Recorded_Event_Object_N_Client_Access_Notification |