Entity Definition

Logical Name : CalendarLevel
Physical Name : CA_CLD_LV

A level of roll-up within a particular Calendar that designates a recurring time period that make up the calender and time periods within the calendar. Eg: MerchandisingCalendar may have Weeks, SubSeason, Seasons and Years, while Payroll Calendar may have Months and Years, SalesTax Calendar may have Quarters and Years.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
CalendarID (FK) A unique system assigned identifier for the Calendar. ID_CLD Identity integer CalendarLevel(CA_CLD_LV)
CalendarID (FK)(PK) A unique system assigned identifier for the Calendar. ID_CLD Identity integer Calendar(CA_CLD)
CalendarLevelID (PK) A unique system assigned identifier for the CalendarLevel. ID_CLD_LV Identity integer
ParentCalendarLevelID (FK) The calendar level of the PARENT of this level. Will be NULL for root. This is a self referencing FK. This allows: Years rollup from Months Quarters rollup from 3 months Months rollup from 30/31 days Weeks rollup from 7 days Days are the base period ID_CLD_LV_PRNT Identity integer CalendarLevel(CA_CLD_LV)
LevelName The name for this level with in the Calendar NM_CLD_LV Name varchar(40)
ChildPeriodCount The number of instances of the ChildPeriod that go to make up this CalendarPeriod Possible values include: NULL - period starts same time each Day/Week/Month rather than as a multiple of child periods 3 Shifts = Day 7 Days = Week 30/31 Days = Month 12 Months = Year QU_PRD_CHLD QuantityShortCount decimal(3,0)
PeriodStartDayCode A code denoting which day of week/month/year the period starts on. Suggested values include: NULL - Period is pure multiple of child Mon, Tue, Wed, Thu, Fri, Sat, Sun - Period starts on given week day FMon, FTue, FWed, FThu, FFri, FSat, FSun - Period starts on First given week day of month LMon, LTue, LWed, LThu, LFri, LSat, LSun - Period starts on Last given week day of month 125 - Julian day number 125 = 5-May WD_PRD_SRT Code4 char(4)
PeriodStartsTime The time of day that the period starts TM_PRD_SRT Time time


Parent Entity Verb Phrase Child Entity
Calendar defines CalendarLevel
CalendarLevel has child CalendarLevel
CalendarLevel defines CalendarPeriod
CalendarLevel has child CalendarLevel

Logical Views containing CalendarLevel

Logical View
Logical 02430 - Control Transaction - Period Open Close View
Logical 03000 - Reporting - Macro View
Logical 03000 - Reporting - Macro View
Logical 05400 - Taxation - Reporting View - Tax Rule Reference
Logical 06100 - Calendar View
Logical 11160 - Worker - Reporting View