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
NameTypeConstraintsDescription
client_access_notification_KEYint (4)NOT NULLPrimary key for this table
client_KEYint (4)NOT NULLThe key of the client for which the action was performed.
client__staff_KEYint (4)NOT NULLThe key of the client staff that completed the action in Client Access.
assigned__staff_KEYint (4)The key of the staff assigned as the accountant for related Client Access notification. Null if no accountant is assigned for related notification.
descriptionnvarchar (240)NOT NULLThe further details of the action that was completed in Client Access.
event_datedatetime (8, 3)NOT NULLDate/time stamp the action was completed in Client Access.
client_access_notification_event_type_KEYint (4)NOT NULLThe action that was completed in Client Access.
client_access_notification_review_status_KEYint (4)NOT NULLThe review status of this Client Access notification.
notesnvarchar (-1)NOT NULLStores the notes entered via the Notification Details dialog. Allows any character type and is not null.
Primary key
NameColumnsDescription
PK_Client_Access_Notificationclient_access_notification_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Client_Access_Notification__Client__client_KEYclient_KEYClient (client_KEY)
FK_Client_Access_Notification__Client_Access_Notification_Event_Type__client_access_notification_event_type_KEYclient_access_notification_event_type_KEYClient_Access_Notification_Event_Type (client_access_notification_event_type_KEY)
FK_Client_Access_Notification__Client_Access_Notification_Review_Status__client_access_notification_review_status_KEYclient_access_notification_review_status_KEYClient_Access_Notification_Review_Status (client_access_notification_review_status_KEY)
FK_Client_Access_Notification__Staff__assigned__staff_KEYassigned__staff_KEYStaff (staff_KEY)
FK_Client_Access_Notification__Staff__client__staff_KEYclient__staff_KEYStaff (staff_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Recorded_Event_Object_N_Client_Access_Notification__Client_Access_Notification__client_access_notification_KEYclient_access_notification_KEYRecorded_Event_Object_N_Client_Access_Notification

Schema diagram