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.

Flags

Columns

code

Unique calendar type code.

Examples: 'public_holiday', 'central_bank_meeting', 'financial_centre', 'data_release', 'other'.

name

Human-readable name for the calendar type.

std::string(faker::word::adjective()) + " Calendar Type"

description

Detailed description of the calendar type.

std::string(faker::lorem::sentence())

display_order

Order for UI display purposes.

faker::number::integer(1, 100)

SQL

Flags

Extra drops

drop function if exists ores_refdata_validate_calendar_type_fn;

Validation function

Insert trigger

Validations

column validation_function
change_reason_code ores_dq_validate_change_reason_fn

C++

Flags

Repository

Domain includes

#include <chrono>
#include <string>

Entity includes

#include <string>
#include "sqlgen/Timestamp.hpp"

Conventions

Table display

column header
code Code
name Name
description Description
display_order Order
modified_by Modified By
version Version

Qt

Columns (Qt model)

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    

Custom repository methods

See also

Emacs 29.3 (Org mode 9.6.15)