Holidays
Stores records representing holidays and non-working dates. This table supports scheduling logic, resource planning, and automatic date adjustments in calendaring workflows.
Columns
| Name | Type | ReadOnly | Description |
| Created_By | String | True |
The unique identifier (Id) of the user who created this holiday record. This value provides origin tracking for audit and administrative review. |
| Created_By_Name | String | True |
The display name of the user who created this holiday record. This value is shown in record details and history logs. |
| Date_Entered | Datetime | True |
The date and time when this holiday record was entered into the system. This timestamp supports chronological organization and audit tracking. |
| Date_Modified | Datetime | True |
The date and time when this holiday record was last modified. This timestamp supports version tracking and administrative oversight. |
| Deleted | Bool | False |
A Boolean field that returns a value of 'true' when this holiday record is marked as deleted. It returns a value of 'false' when the record remains active. |
| Description | String | False |
A descriptive note that explains the context, purpose, or meaning of the holiday. This field can be used to clarify usage or scheduling intent. |
| Holiday_Date | Date | False |
The date of the holiday. This date is used to determine non-working days, scheduling exceptions, and resource availability planning. |
| Id [KEY] | String | True |
The Id of this holiday record. The system uses this Id to reference and manage the record internally. |
| Modified_By_Name | String | True |
The display name of the user who last modified this holiday record. This value assists with change tracking visibility. |
| Modified_User_Id | String | True |
The Id of the user who most recently updated this holiday record. This value supports audit and responsibility tracking. |
| Name | String | False |
The name of the holiday. This value is shown in calendars, resource scheduling tools, and availability views. |
| Person_Id | String | False |
The Id of the specific person who is associated with this holiday, when the holiday applies to an individual rather than the entire organization. |
| Person_Type | String | False |
The type of person to whom the holiday applies (for example, 'Employee', 'Contractor', or 'Resource Group'). This value determines the holiday scope. |
| Related_Module | String | False |
The module that is associated with this holiday record (for example, 'Employees' or 'Resources'). This value defines the context in which the holiday applies. |
| Related_Module_Id | String | False |
The Id of the record in the related module that is associated with this holiday. This value links the holiday to a specific entity or resource. |
| Resource_Name | String | False |
The display name of the resource or individual to whom the holiday applies. This value is shown in scheduling, staffing, and availability views. |