You see the Operator-Class table has op#, class# and multiplier?
So when a class is encountereed in the ETMData table, its assoc. multiplier is looked up in the Op-Class table, via the the ETMData's Op# & Class #
Told you this was a brain ache! :-)
Thank you for your continuing interest, as usual
>Where "Multiplier" in your report comes from? I don't see it mentioned as a part of ETMDATA table.
>
>>>What about "Multiplier"? Does OPERATOR_CLASS table also has date field?
>>
>>OK, we're after the averag no. of journeys in the ETMDATA (Automated Ticket M/c DATA)say the pensioner bought a return ticket, (a particular class), that class's multiplier might be 2.0, meanimng that ticket is worth 2 trips. An all-day-rover (class) might be used, on average, 2.5 trips.
>>
>>This only applies to last year's data. Now as they're all zero-rated, all classes have a multiplier of 1.0.
>>
>>Very astute of you to divine that the Op. Class table has a date. Actually it has a start and end date, specifying when the conc. scheme began and ends. But that isn't important here as that's dealt with in the pre-processing of the raw ETM data that gets compiled into out ETMDATA table that sums up ticket sales for each ticket class within each route.
>>
>>Confused? I know I am! ;-S
>>
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.