The time transformation entites that are used to relate entities in the various time hierarchies to one another are: Year Transformation, Half Year Transformation, Half Year Todate Transformation, Quarter Transformation, Quarter Todate Trasnformation, Month Transformation, Month ToDate Transofrmation, Half Month Transformation, and Half Month Todate Transformation. For example, the Quarter Year Transformation and the Quarter Year Todate Transformation are used to relate Calendar Quarter, Fiscal Quarter, Advertising Quarter, and Planning Quarter. The time transformation entities that are used to relate entities in the advertising hierarchy to those in the planning hierarchy are Period Todate Transformation and Period Transformation. Week Transformation and Week Todate Transformation relate to several week entities: Calendar Week, Fiscal Week, Advertising Week, and Planning Week. Season is the parent of Time Standard By Day and Time Standard By Week which is a child of Calendar Week. Day Transformation relates to Day which is a parent of Dat Todate Transformation and Day Actual Condition.