Locate the Historical Ticketing Data information

Historical Ticketing Data is stored in the AVEVA Pipeline Operations for Liquids database of the Historical database:

• LMS.dbo.batchSchedule

• LMS.dbo.ticketHourlyIntegration

• LMS.dbo.ticketTotal

• LMS.dbo.accumulatorTicketDevice

• LMS.dbo.tankTicketDevice

• LMS.dbo.flowcomputerTicketDevice

The batchSchedule table stores all pending tickets, and all information related to them, including revisions made by a Controller and their current order.

The ticketHourlyIntegration table stores information related to the volume of product that flows through the batchXfer record each hour, which is related to the active ticket.

Note: If the Batch Transfer is not inhibited, the system will generate hourly integration records even if the Batch Transfer Sources are inhibited. This may result in zero volume records being generated until the Batch Transfer Sources become uninhibited and accumulation starts again.

The ticketTotal table and each of the Ticket Device Level tables associated with batchXferSources, accumulatorTicketDevice, tankTicketDevice, and flowcomputerTicketDevice are used to store all information related to completed tickets, as well as revision information related to modifications made to a completed ticket by a Controller.