Load Summary Report
The Load Summary report is automatically generated each time EFI transactions are loaded (FFEL). The Load Summary report is an "exception report"; it prints information for the transactions that were not loaded or transactions that need attention. Transactions that were loaded without any problems are not printed on this report. A summary is included at the end of the Load Summary report. This report should be printed or saved and kept on file until all transactions have been processed and verified for accuracy.
At the bottom of the Load Summary report, the totals show how many transactions were processed and loaded, how many transactions were rejected, and how many of the loaded transactions have special messages that warrant attention. The Pump Summary is also included to provide a quick summary of the fuel cost and quantity dispensed from the pumps. Be sure to compare the computed totals against actual totals (from fuel logs, reports from fueling system, etc.) to validate the loaded data prior to processing the fuel transactions.
The report columns are as follows:
Column Descriptions
Date- Fueling date
Time- Fueling time
Site- Fuel site/fuel island number
Trn# Transaction number
Typ- Transaction type
Crd-1- Driver card number
Crd-2- Vehicle fuel card number
Vehicle # Vehicle number
Pump- Pump number
Prd- Product code
Quantity- Fuel quantity
Price- Fuel price
Odom- Vehicle meter reading
Department # Department number
RVTransaction status; Not applicable for this report
Message-Special messages regarding the transaction
Summary Info/Descriptions
Records: Processed- Total number of fuel transactions in the specified date and time range
Records: Rejected- Number of fuel transactions not loaded
Records: Spcl Msgs- Number of transactions with special messages
Totals: Trans-Added- Total number of fuel transactions loaded
Totals: Quantity- Total fuel quantity loaded
Totals: Total-Cost- Total fuel cost loaded
Pump Summary Info/Descriptions
*An "N" in this column indicates the pump is not on file
Pump- Pump facility and number
Product- Product code and fuel type
Site- Fuel site number where the pump is located
Accm-Trn- Total number of fuel transactions loaded for the pump
Accm-Qty- Total fuel quantity loaded for the pump
Accm-Cost- Total fuel cost loaded for the pump. "***" is printed next to the total fuel cost to flag a potential problem (e.g. fuel price not found)
Special Load Messages
Refer to the following table for the special messages that may be printed on the Load Summary report. It is very important to look over the messages that are printed on the Load Summary report, and take any necessary action in order to avoid potential problems.
Message | Meaning | Actions needed |
No F-xref crd | Vehicle EFI fuel cross-reference number not on file |
|
No U-xref crd | Vehicle unit cross-reference number not on file |
|
Tnk not found | Pump record found but the attached tank record is not on file |
|
Pmp not found | Pump record not on file |
|
Fty not found | Fuel type specified in product code not on file |
|
Stg not found | Product storage variable missing in fuel type record |
|
Pc not found | Product code not on file |
|
Fuel Transfer | Transaction processed as a tank transfer |
|
Reject Tran | Transaction dropped |
|
Trans on file | Transaction has already been loaded |
|