Having a single Excel file with all relevant information on leak events may be of great use when you, for example, need to share the leak event report with your fellow workers or submit it to an internal compliance department. Or, you may want to make some additional calculations, filtering, or sorting in the Excel report. Whatever the purpose is, the leak event report is at your disposal.
Downloading the Leak Events Report
Follow the steps below to export the leak event report to your device.
⦿ How to Download the Leak Event Report
Open the hamburger menu in the upper-left corner, and select Assets (Equipment) > Refrigerant Leak Events. You land on the page listing all leak events.
(Optional) Apply the required filters to include only those leak events you’re interested in, and click Go.
Click the Download # Leak Records button on the right-hand side.
Opt for the unit of measure the refrigerant amount should be displayed in, and then hit Download Report.
To track the refrigerant usage in kilograms and grams, ask your ServiceChannel representative to enable the required feature for you.
An Excel file with the required leak events gets exported to your device.
Viewing the Leak Events Report
The report reflects key information on leak events that occurred including the area where the leak took place, assets that leaked the refrigerant, amount of the refrigerant used to fix the leak, and more.
Take a look at the details available in the report.
Part 1 (A–E)
Location. Identification number of the location where the leak happened
Tag ID. Tag ID of the asset that leaked the refrigerant
Leak Event Date. Date when the leak occurred or was found: MM/DD/YYYY
Tracking Number. Tracking number of the work order associated with the leak event
Work Order Status. Status of the associated work order
Part 2 (F–J)
Refrigerant Type. Specific type of the refrigerant that was used to fix the leak
Amount Added. Amount of the refrigerant added to the equipment to fix the leak. It can be in pounds and ounces, pounds and decimals of pounds, or kilograms and grams. What unit of measure to apply depends on the option you select when downloading the report.
Refrigerant Source Location. Location where the refrigerant part was taken from.
If the refrigerant was taken from an inventory location, you see the location name.
In case it was supplied by the vendor, you see Vendor Supplied.
Leak Record Number. Unique number of the leak event (record) in the system
Part 3 (K–O)
Current Leak Rate %. Percentage of the current leak rate
Repair Date. Date when the leak was fixed: MM/DD/YYYY
Leak Status. Status of the leak event: Completed or In Process
Leak Area. Area where the leak occurred: more general place, for example, receiver
Leak Location. Location where the leak occurred: more specific place within the particular area, for example, level indicator/alarm
Part 4 (P–U)
First Verification Date. Date when the first verification took place: MM/DD/YYYY
First Verification Method. Method that was used during the first verification to make sure the leak had been fixed
Second Verification Date.Date of the second verification: MM/DD/YYYY
Second Verification Method.Method of the second verification
Follow-Up Work Order Numbers. Tracking numbers of the follow-up work orders that were generated for providers to close the leak record. Based on your company settings, follow-ups may be created if the original work orders get completed with the associated leak events left open.
Notes. Notes that were manually added by users to a leak record
Two additional fields will be added as the far right columns on the export file title when download for multi-leak:
User Name - Displays the user name of the user who entered the leak detail
User ID - Displays the user Id of the user who entered the leak detail
For any reports and templates downloaded for viewing and/or adding information for uploading into Service Automation, items such as decimal separators, date & time formats, currency codes and address forms displays based on your computer settings if the format is Excel (.xls) and if it is a CSV file (.csv), then ServiceChannel settings takes precedence. If the Currency Code Support feature is enabled, a currency field is added to reports and templates. If the Localization Address Format feature is enabled, headers and values are updated with the specific country’s address format for Excel (.xls) and CSV(.csv) only headers are affected while headers and values are affected for a PDF (.pdf).