TimePeriod

Entity Definition

Logical Name : TimePeriod
Physical Name : CO_PD_TM

A TimePeriod entity type designates and names a specific block of time for a specific day of the week. The block of times defined by a start time and a duration (along with athe unit of time used to specify the duration). For example, a TimePeriod entity type allows a retailer to define a "Happy Hour" period as Fridays from 5:00pm to 6:30pm

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
TimePeriodID (PK) A unique identifier for the time period. ID_PD_TM Identity integer
Name A human readable name for the time period NM_PD_TM Name varchar(40)
DayOfWeek A 2 character code denoting the day of the week that the time period falls on WD DateWeekdayISO8061 char(1)
StartTime The time of day that the time period commences TM_SRT Time Time
DurationUnitOfMeasureCode (FK) The code used to specify the units in which a value is being expressed, or manner in which a measurement has been taken. This code relates to the UCC data element 355. LU_UOM_DRN Code varchar(20) UnitOfMeasure(CO_UOM)
Duration The DurationUnitOfMeasureCode included in the time period from the StartTime. SI_DRN QuantityShortCountMinutes decimal(4,0)

Relationships

Parent Entity Verb Phrase Child Entity
UnitOfMeasure defines TimePeriod
TimePeriod is included in TimeGroupTimePeriod

Logical Views containing TimePeriod

Logical View
Logical 01400 - Item Rewards Derivation - Transaction Level
Logical 06100 - Calendar View
Logical 06500 - Time Groups View
Logical 11100 - Worker - Macro View
Logical 20000 - Forecourt Macro View
Logical 20020 - Forecourt Pricing View