Figure 15: Example of a Time Period Selection Tool The values that demonstrate the example above would look like the example in Table 23. 23: Example of Implementing a Hierarchical Recurring Time Interval Time Period Time Period Data Values - 1 timePeriodID 1001 timePeriodName Example timePeriodDescription Demonstrate hierarchical levels of time intervals authority MTA Long Island Bus effectiveDateBegin 20100101 effectiveDateEnd 20101231 Time Dimension Data Data Data Data Values - Values - Values - Values – 1 2 3 4 timeDimID 1 2 3 4 timePeriodID 1001 1001 1001 1001 timeDimName Daily Monthly Quarterly period interval interval and day interval for for type for for example example example example timePeriodType recurring recurring recurring recurring customTimeInterval biw mnth qtr dayType weekday periodID 1 Period Data Values - 1 periodID 1 periodName AM Peak periodDescription Morning Peak periods for inbound trips inclusive true timeBegin 18000 timeEnd 36000 dayType weekday
Figure 15: Example of a Time Period Selection Tool The values that demonstrate the example above would look like the example in Table 23. 23: Example of Implementing a Hierarchical Recurring Time Interval Time Period Time Period Data Values - 1 timePeriodID 1001 timePeriodName Example timePeriodDescription Demonstrate hierarchical levels of time intervals authority MTA Long Island Bus effectiveDateBegin 20100101 effectiveDateEnd 20101231 Time Dimension Data Values - 1 Data Values - 2 Data Values - 3 Data Values – 4 timeDimID 1 2 3 4 timePeriodID 1001 1001 1001 1001 timeDimName Daily period and day type for example interval for example Monthly interval for example Quarterly interval for example timePeriodType recurring recurring recurring recurring customTimeInterval biw mnth qtr dayType weekday periodID 1 Period Data Values - 1 periodID 1 periodName AM Peak periodDescription Morning Peak periods for inbound trips inclusive true timeBegin 18000 timeEnd 36000 dayType weekday
TSIP_Planning_Data_Profile_Reqt_v03_.docx