Entity Definition

Logical Name : TimeGroupTimePeriod
Physical Name : CO_GP_PD_TM

The TimeGroupTimePeriod entity provides an associative relationship between TimePeriod entity type and TimeGroup entitty type that enables a flexible specification of one or more weekdays and time periods to be applied to a TimeGroup.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
TimePeriodID (FK)(PK) A unique identifier for the time period. ID_PD_TM Identity integer TimePeriod(CO_PD_TM)
TimeGroupID (FK)(PK) A unique identifier for a set of consecutive hours on a set of days of the week. e.g. 10am - 2pm Mon, Wed and Fri. ID_GP_TM Identity integer TimeGroup(CO_GP_TM)


Parent Entity Verb Phrase Child Entity
TimeGroup includes TimeGroupTimePeriod
TimePeriod is included in TimeGroupTimePeriod

Logical Views containing TimeGroupTimePeriod

Logical View
Logical 01110 - Item Selling Rules - Restrictions 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