AssociatedCalendarPeriod

Entity Definition

Logical Name : AssociatedCalendarPeriod
Physical Name : ST_ASCTN_CLD_PRD

An association denoting the fact that longer CalendarPeriods are composed of shorter CalendarPeriods. ie: That a particular set of Days are to be amalgamated into a particular Week.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
CalendarID (FK)(PK) A unique system assigned identifier for the Calendar. ID_CLD Identity integer CalendarPeriod(CA_CLD_PRD)
CalendarID (FK)(PK) A unique system assigned identifier for the Calendar. ID_CLD Identity integer CalendarPeriod(CA_CLD_PRD)
ParentLevelID (FK)(PK) A unique system assigned identifier for the CalendarLevel. ID_CLD_LV_PRNT Identity integer CalendarPeriod(CA_CLD_PRD)
ChildLevelID (FK)(PK) A unique system assigned identifier for the CalendarLevel. ID_CLD_LV_CHLD Identity integer CalendarPeriod(CA_CLD_PRD)
ParentPeriodID (FK)(PK) A unique system assigned identifier for this CalendarPeriod ID_CLD_PRD_PRNT Identity integer CalendarPeriod(CA_CLD_PRD)
ChildPeriodID (FK)(PK) A unique system assigned identifier for this CalendarPeriod ID_CLD_PRD_CHLD Identity integer CalendarPeriod(CA_CLD_PRD)

Relationships

Parent Entity Verb Phrase Child Entity
CalendarPeriod is parent AssociatedCalendarPeriod
CalendarPeriod is child AssociatedCalendarPeriod

Logical Views containing AssociatedCalendarPeriod

Logical View
Logical 03000 - Reporting - Macro View
Logical 03000 - Reporting - Macro View
Logical 06100 - Calendar View