ComplianceSchedule Table
ComplianceSchedule
defines schedules that take place repeatedly at a specified interval.
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.
Database Column |
Details |
---|---|
ComplianceScheduleID
|
Type: integer. Key. Generated ID A unique identifier for the schedule. |
TermAndConditionID
|
Type: integer. Key. Nullable The term/condition that the schedule is associated with. Foreign key to the |
StartDate
|
Type: datetime The date on which this schedule first applies. |
EndDate
|
Type: datetime The date on which this schedule ends. |
RepeatIntervalTypeID
|
Type: integer. Key. Nullable The type of repeat interval. Foreign key to the |
RepeatInterval
|
Type: integer. Nullable The interval between repeats of this schedule. |