Aircraft Parking Activity Records at SFO

A. SUMMARY
This dataset stores the parking reservation information recorded by the Aircraft Parking System at SFO.

The columns in this dataset include details such as the Source ID, Source Type, Start Datetime , End Datetime, Reserving Company, Operator Company, Model, Tail Number and Spot of the aircraft parking activity.

On the 28th day of each month, this dataset is exported from the Aircraft Parking System at SFO.

B. HOW THE DATASET IS CREATED

When airline requests for reservation of aircraft parking stand at SFO, a new aircraft parking reservation is entered to the
Aircraft Parking System.

On the 28th day of each month, this dataset is replaced with all the aircraft parking activity records retrieved from the aircraft parking reservation table with reservation Start Date between August 2008 and the previous month of the export run date.

C. UPDATE PROCESS
Airside Operations Supervisor updates the aircraft parking activity record as requested by the airline for making changes and cancellations.

When airline requests for changes or cancellation to the previous made aircraft parking reservation, the aircraft parking activity record is updated with the changes in the Aircraft Parking System.

On the 28th day of each month, this dataset is replaced with all the aircraft parking activity records retrieved from the aircraft parking reservation table with reservation Start Date between August 2008 and the previous month of the export run rate.

D. HOW TO USE THIS DATASET
Utilize this dataset to determine the parking duration of a reservation by calculating the difference between the reservation's end date and start date.

E. RELATED DATASETS

Aircraft Tail Numbers and Models at SFO

Utilize the Tail Number column of the "Aircraft Parking Activity Records at SFO" dataset to connect with the Tail Number column of the "Aircraft Tail Numbers and Models at SFO" dataset, for referencing the corresponding aircraft record.

Aircraft Parking Location Inventory at SFO

Utilize the Spot column from the "Aircraft Parking Activity Records at SFO" dataset to connect with the Spot Name column in the "Aircraft Parking Locations at SFO" dataset, for referencing the corresponding parking location record.