ContractNotificationResponsibility Table

ContractNotificationResponsibility keeps track of which responsibility groups need to be notified for contract expiry or renewals.

Note: To cater for multi-tenant mode, this table may contain data for multiple tenants. Access requires that the database TenantID has been set in the SQL Server connection context information. That setting filters an underlying table to produce this view of data for the single, selected tenant.
Table 1. Database columns for ContractNotificationResponsibility table

Database Column

Details

ContractNotification ResponsibilityID

Type: integer. Key. Generated ID

Unique identifier for contract notification responsibility groups.

ContractID

Type: integer. Key

The contract generating notifications. Foreign key to the Contract table.

ResponsibilityTypeID

Type: integer. Key

The responsibility type of the end-users receiving notifications about the contract. Foreign key to the ResponsibilityType table.

NotificationTypeID

Type: integer. Key

The type of notification (renewal or expiry) that these responsibility groups should receive notifications for. Foreign key to the NotificationType table.