Entity Definition

Logical Name : BusinessUnitGroupSchedule
Physical Name : CO_BSN_GP_SCHDL

An identified, named association between a CalendarPeriod and a BusinessUnitGroup that designates a predetermined period of time. Typically this is used to designate store hours, receiving hours, and other time intervals that have business activity for a business unit group associated with them. The ASSUMPTION is that a named BusinessUnitGroupSchedule will reference a DAY CalendarPeriod as part of defining a schedule for the purposes of defining a schedule. Retailers should consider establishing OPERATING CALENDARs for schedule making purposes. Note that this can be used for individual store schedule because the business unit group at the leaf level has a one to one correspondence with an individual business unit (aka store).

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
BusinessUnitGroupScheduleID (PK) Token ID for a BusinessUnitGroupSchedule entity type instance. ID_BSN_UN_GP_SCHDL Identity integer
CalendarID (FK) A unique system assigned identifier for the Calendar. ID_CLD Identity integer CalendarPeriod(CA_CLD_PRD)
CalendarLevelID (FK) A unique system assigned identifier for the CalendarLevel. ID_CLD_LV Identity integer CalendarPeriod(CA_CLD_PRD)
CalendarPeriodID (FK) A unique system assigned identifier for this CalendarPeriod ID_CLD_PRD Identity integer CalendarPeriod(CA_CLD_PRD)
BusinessUnitScheduleTypeCode (FK) A shorthand name for a type of BusinessUnitScheduleTypeCode. The value list for this attribute will be defined by each retailer. Sample values include: SELLING_HRS RECVG_HRS INVTY_HRS CD_BSN_UN_SCHDL_TYP Code varchar(20) BusinessUnitGroupScheduleType(CO_BSN_GP_SCHDL_TYP)
BusinessUnitGroupID (FK) A unique system assigned identifier for a group of BusinessUnits. ID_BSNGP Identity integer BusinessUnitGroup(CO_BSNGP)


Parent Entity Verb Phrase Child Entity
CalendarPeriod designated period of BusinessUnitGroupSchedule
BusinessUnitGroupScheduleType classifies BusinessUnitGroupSchedule
BusinessUnitGroup is scheduled by BusinessUnitGroupSchedule

Logical Views containing BusinessUnitGroupSchedule

Logical View
Logical 06100 - Calendar View