> ## Documentation Index
> Fetch the complete documentation index at: https://docs.superoffice.com/llms.txt
> Use this file to discover all available pages before exploring further.

# redletterday table

> Red letter days for calendar (holidays, birthday of king etc)

## redletterday Table (17)

Red letter days for calendar (holidays, birthday of king etc)

## Fields

| Name             | Description                                                                                                                     | Type                        | Nullable |
| ---------------- | ------------------------------------------------------------------------------------------------------------------------------- | --------------------------- | :------: |
| redletterday\_id | Primary key                                                                                                                     | PK                          |    No    |
| reddate          | The date                                                                                                                        | DateTime                    |    No    |
| country\_id      | Which country does this red letter day belong to. It will show up in the diary for associates with this country as homecountry. | FK [country](./country.mdx) |    No    |
| reds             | The n´th bit corresponding to the date in dates month, is true if the color is active.                                          | UInt                        |    Yes   |
| colored          | The n´th bit corresponding to the date in dates month, is true if the color is active.                                          | UInt                        |    Yes   |
| color            | color can be one of the following: RLD\_COLOR\_BLACK, RLD\_COLOR\_RED, RLD\_COLOR\_SPES                                         | UShort                      |    Yes   |
| text             | Text to show on the date                                                                                                        | String(79)                  |    Yes   |
| updatedCount     | Number of updates made to this record                                                                                           | UShort                      |    No    |
| rgbColour        | Actual RGB colour index                                                                                                         | UInt                        |    Yes   |
| extraFlags       | Extra flags, spare field                                                                                                        | UInt                        |    Yes   |

<img src="https://mintcdn.com/superofficeas/6OcOTPa_ISkjXJg4/media/loc/en/database/tables/redletterday.png?fit=max&auto=format&n=6OcOTPa_ISkjXJg4&q=85&s=be3172db42cda5034f7b9c7b707ebb17" alt="redletterday table relationship diagram" width="380" height="59" data-path="media/loc/en/database/tables/redletterday.png" />

## Indexes

| Fields               | Types        | Description |
| -------------------- | ------------ | ----------- |
| country\_id, reddate | FK, DateTime | Clustered   |

## Relationships

| Table                | Description         |
| -------------------- | ------------------- |
| [country](./country) | Country information |

## Replication Flags

* Replicate changes DOWN from central to satellites and travellers.
* 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.


## Related topics

- [country table](/en/database/tables/country.md)
- [extra_tables table](/en/database/tables/extra-tables.md)
- [ext_table table](/en/database/tables/ext-table.md)
- [What's new in version 10.5.5.982](/release-notes/database/changes-10.5.5.md)
- [Database table listing](/en/database/tables/index.md)
- [What's new in version 11.1.447.0](/release-notes/database/changes-11.1.447.md)