ores.refdata.calendar_type
Table of Contents
Reference data classifying what a calendar represents. Values
include: public_holiday, central_bank_meeting, financial_centre,
data_release, other. Lets a single calendar table hold
heterogeneous entries (a national holiday calendar, a central bank's
meeting schedule, a financial-centre business-day calendar) without
collapsing their distinct provenance.
1. Flags
2. Columns
2.1. code
Unique calendar type code.
Examples: 'public_holiday', 'central_bank_meeting', 'financial_centre', 'data_release', 'other'.
2.2. name
Human-readable name for the calendar type.
std::string(faker::word::adjective()) + " Calendar Type"
2.3. description
Detailed description of the calendar type.
std::string(faker::lorem::sentence())
2.4. display_order
Order for UI display purposes.
faker::number::integer(1, 100)
3. SQL
3.1. Flags
3.2. Extra drops
drop function if exists ores_refdata_validate_calendar_type_fn;
4. Validation function
5. Insert trigger
5.1. Validations
| column | validation_function |
|---|---|
| change_reason_code | ores_dq_validate_change_reason_fn |
6. C++
6.1. Flags
6.2. Repository
6.3. Domain includes
#include <chrono> #include <string>
6.4. Entity includes
#include <string> #include "sqlgen/Timestamp.hpp"
6.5. Conventions
6.6. Table display
| column | header |
|---|---|
| code | Code |
| name | Name |
| description | Description |
| display_order | Order |
| modified_by | Modified By |
| version | Version |
6.7. Presentation
6.7.1. Columns
| enum_name | field | header | type | width | is_badge | badge_key |
|---|---|---|---|---|---|---|
| Code | code | Code | string | 150 | true | calendar_type |
| Name | name | Name | string | 200 | ||
| Description | description | Description | string | 300 | ||
| DisplayOrder | display_order | Order | int | 80 | ||
| Version | version | Version | int | 80 | ||
| ModifiedBy | modified_by | Modified By | string | 120 | ||
| RecordedAt | recorded_at | Recorded At | timestamp | 150 |
6.8. Custom repository methods
7. See also
- ores.refdata — component group overview.
- Model calendars as proper ORE Studio reference data — parent story.