Property Management, Billing, Revenue Management, and Billing System in an Integrated System at San Francisco International Airport

TADERA partnered with the San Francisco International Airport to implement a Property Management, Billing, Revenue Management and GIS System to manage all leases, properties, aeronautical activities, and accounts receivable functions at the airport. This project utilized the AirportIQ Business channel, which includes a series of integrated modules to manage all facets of the airport’s activity and revenue, as the foundation of the system, and included various integration points to other systems in use at the airport.

Integrating Critical Functions to Improve Efficiency

The AirportIQ Business Channel integrates a variety of critical functions under one platform, including:

• Agreement and Contract Management: this sub-module is used to manage all terms and information related to an airport lease, whether revenue-producing or non-revenue. This module also includes an integrated contact management module, which is used to manage companies and contacts throughout the enterprise.
• Activity Statistics: All airport operating statistics, such as aircraft landings, passenger movements, cargo movements, fuel flowage, per use activities, and concessions sales are managed through this sub-module. All of these activities are tied to the airport’s customer agreements, which allows for efficient analysis and reporting of all activities by customer.
• Tenant Billing: This sub-module is used to create all revenue invoices for the airport. Using the rates and billing rules established in each of the provisions in the agreement management sub-module, this integrated module produces all necessary invoices based on billing parameters established by the airport.
• Accounts Receivable—This sub-module is integrated with the Agreements, Activity Statistics, and Tenant Billing sub-module to provide an interface for the application of cash received from tenants. All other A/R functions, such as financial reporting, aged receivables, dunning, trial balance reports, etc. are provided in this sub-module.
• Space Management—This sub-module provides a comprehensive tool for managing the properties and facilities at the airport. It includes a flexible, user defined inventory hierarchy combined with integrated GIS mapping capabilities.

Integration with Outside Systems

The AirportIQ Business channel is also integrated with SFO’s Automated Vehicle Identification (AVI) system and other ground transportation systems. The system is integrated with other systems, such as the airport’s Automated Vehicle Identification (AVI) system and other ground transportation systems. ABRM imports airport-defined AVI data such as company vehicle identification, number of vehicle trips, and standby/wait times. ABRM calculates the imported data to produce detailed and itemized invoices to bill the ground transportation providers. All revenue transactions are then transferred from ABRM into the airport’s General Ledger through ABRM’s flexible G/L interface module.

Tailored Training for End-Users and Administrators

As part of this project, TADERA conducted a comprehensive training program that addressed most end-users across the organization. This training program included formal user and system training for various user groups. Trainings were tailored to different end-users and included the following topics:

• System and Database Administrators including Operatins and ITT Help Desk
  • Maintain Oracle database
  • Maintain application software
  • Maintain Web server
  • Apply upgrades and patches
  • Maintain system interfaces
• Functional Administrators
  • Implementation team
  • Edit, update, and delete system configuration
  • Run all standard system reports
  • Use of ad hoc reporting tool
• Functional Full Edit Users
  • Full edit, update, and delete within the user’s functional area
  • Run all standard system reports
  • Use of ad hoc reporting tool
  • Run space module graphic and non-graphic integration for pilot site
• Casual User
  • Read only
  • Full system navigation
  • Run all standard system reports
  • Use of ad hoc reporting tool
• System “Internals” Training
  • Training to include schema table and view definitions
  • Data extraction methods (SQL, APIs, etc.)

SFO also received complete user and system documentation for ongoing use and maintenance of the ABRM System as the Airport’s property management and billing system.