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