> ## Documentation Index
> Fetch the complete documentation index at: https://superofficeas-bugfix-ty-screen-designer-paradox.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# RecurrenceRule table

> The recurrency pattern for a recurring event. Each recurring event has an appointment.recurrenceRuleId pointing to its pattern.

## RecurrenceRule Table (207)

The recurrency pattern for a recurring event. Each recurring event has an appointment.recurrenceRuleId pointing to its pattern.

## Fields

| Name                      | Description                                                      | Type                                                          | Nullable |
| ------------------------- | ---------------------------------------------------------------- | ------------------------------------------------------------- | :------: |
| RecurrenceRule\_id        | Primary key                                                      | PK                                                            |    No    |
| pattern                   | Recurrence pattern (daily, weekly etc)                           | Enum [RecurrencePattern](./enums/recurrencepattern.mdx)       |    No    |
| subPattern                | Subpattern (workday, everyday, weekday etc)                      | Enum [RecurrenceSubPattern](./enums/recurrencesubpattern.mdx) |    No    |
| weekdays                  | Weekdays used, bitmask based on  ERecurrenceWeekDays enumeration | UShort                                                        |    No    |
| startDate                 | Start date for repetition pattern                                | DateTime                                                      |    No    |
| endDate                   | End date for repetition pattern                                  | DateTime                                                      |    No    |
| cyclicDay                 | Every nth day, in cyclic patterns                                | UShort                                                        |    No    |
| cyclicWeek                | Every nth week, in cyclic patterns                               | UShort                                                        |    No    |
| cyclicMonth               | Every nth month, in cyclic patterns                              | UShort                                                        |    No    |
| registered                | Registered when                                                  | UtcDateTime                                                   |    No    |
| registered\_associate\_id | Registered by whom                                               | FK [associate](./associate.mdx)                               |    No    |
| updated                   | Last updated when                                                | UtcDateTime                                                   |    No    |
| updated\_associate\_id    | Last updated by whom                                             | FK [associate](./associate.mdx)                               |    No    |
| updatedCount              | Number of updates made to this record                            | UShort                                                        |    No    |

<img src="https://mintcdn.com/superofficeas-bugfix-ty-screen-designer-paradox/cXByN-52D3CAMQji/media/loc/en/database/tables/RecurrenceRule.png?fit=max&auto=format&n=cXByN-52D3CAMQji&q=85&s=39a16f0287adab9ae327dd4e5b3f6475" alt="RecurrenceRule table relationship diagram" width="706" height="59" data-path="media/loc/en/database/tables/RecurrenceRule.png" />

## Indexes

| Fields | Types | Description |
| ------ | ----- | ----------- |

## Relationships

| Table                        | Description                                                                                                                                                                 |
| ---------------------------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| [appointment](./appointment) | Tasks, appointments, followups, phone calls; and documents (document\_id != 0). An appointment always has a corresponding record in VisibleFor specifying who may see this. |
| [associate](./associate)     | Employees, resources and other users - except for External persons                                                                                                          |

## Replication Flags

* Area Management controlled table. Contents replicated to satellites and traveller databases.
* Replicate changes UP from satellites and travellers back to central.
* Copy to satellite and travel prototypes.

## Security Flags

* No access control via user's Role.