Calendar Index
Snowflake table name : CYBERSYN.CALENDAR_INDEX
Last updated
Snowflake table name : CYBERSYN.CALENDAR_INDEX
Last updated
Copyright © 2024 Cybersyn
Name | Description | Type | Example |
---|---|---|---|
CALENDAR_ID
Unique ID denoting a type of calendar (e.g., Month, Quarter, Retail 4-5-4 Month).
VARCHAR
day
CALENDAR_NAME
Human-readable name for the type of calendar.
VARCHAR
Month
PERIOD_START_DATE
The first day of the period.
DATE
2027-06-24
PERIOD_END_DATE
The last day of the period.
DATE
2011-06-30
ANNUAL_PERIOD
The year number related to the annual calendar for the period. It reflects the calendar year for calendar periods and the 4-5-4 retail year for retail periods.
NUMBER
2011
ORDINAL_POSITION_IN_ANNUAL_PERIOD
The ordinal position of the period within the annual period.
NUMBER
6