man OfflineExportData

Created by: Lester Caine, Last modification: 25 Jul 2008 (16:32 UTC)

The headings for the ticket file are:

  • A - Sequence number (Cross references to the Transactions file)
  • B - Ticket_ID
  • C - Date
  • D - Time
  • E - Ticket number
  • F - Caller_ID
  • G - Surname
  • H - Forename
  • I - HBIS
  • J - Tags ( Displayed as a list of REASON letters )
  • K - Clearance Code
  • L - Time left office
  • M - Initial reception staff ID
  • N - Last clearance staff ID

If the address option is enabled, then an additional 6 fields are added.
( This is controlled by the ExportAddress entry in the registry )

  • O - House number and/or name
  • P - Road *
  • Q - Area *
  • R - Town *
  • S - County *
  • T - Postcode
  •   * Taken from the postcode table - included to allow sorting if required.

The headings for the transaction file are:

  • A - Sequence number
  • B - Caller_ID
  • C - Surname
  • D - Forename
  • E - HBIS
  • F - Transaction time
  • G - Transaction duration
  • H - StaffID
  • I - Room number

This area has not been updated for some years, and a number of additional fields are now available. The Ticket_ID should now be used in place of the sequence number, and PROOM needs to be added to the transaction table to allow identification of the serving element of the time. However since the data can now be accessed from various alternative tools, and the offline package is planned to be removed once the web based reports are available, alternatives to the raw export will be provided as required.