The Extended Fixed Asset Repair Statement (EFARS) details assets under repair that took more than 1 day to repair. This report is not limited to a certain number of years of data.
The EFARS report does not include assets where a system went under repair then returned to Normal Operation within 1 day. The FARS and EFARS report are successors to the Asset Repair Service Transaction Summary Report (arrestr).
Overview
The report builds a list of the below listed service event types, and considers the answers provided in the service event screen. Below are some examples of service event types and triggers that are considered in the EFARS report.
- Failed an Initial Verification Leak Inspection.
- Type of Service: Service or Leak Repair
- Was a leak found or was circuit opened? Yes or No
- Initial Verification Test Leak Test Results = Fail
- Failed a Follow up Verification Leak Inspection.
- Type of Service: Service or Leak Repair
- Was a leak found or was circuit opened? Yes or No
- Initial Verification Test Leak Test Results = Pass
- Follow Up Leak Verification Was a leak found or was circuit opened? Yes
- Found a leak but did not repair the leak
- Service Event Type: Service or Leak Repair
- Was a leak found or was circuit opened? Yes or No
- Initial Verification Test Leak Test Results = Pass
- Follow Up Leak Verification Leak Repair Status = No Leak Repair or Repair Attempted;
- Service was performed, but the asset is still under repair
- Follow Up Leak Verification Status after Service = Under Repair
- A failed leak inspection service event as long as there is a corresponding Service or Leak Repair
- Service Event Type: Leak Inspection; Was a leak found or was circuit opened? Yes AND Service Event Type: Service or Leak Repair; Was a leak found or was circuit opened? Yes;
- Impacted Appliance and Date of Service are the same between Leak Inspection and Service or Leak Repair
- Service Event Type: Leak Inspection; Was a leak found or was circuit opened? Yes AND Service Event Type: Service or Leak Repair; Was a leak found or was circuit opened? Yes;
- Service events that repaired a leak
- Follow Up Leak Verification Status after Service = Normal Operation
- Service events that resulted in the shutdown of an asset
- Service Event Type: Shutdown/Mothball
- Post Shutdown Status = Shutdown/Retired OR Mothballed - Pending...
The report then orders this list of events to determine the first event that sets an asset to Under Repair, and then finds the next event that would set the asset back to Normal Operation or Shutdown.
The report then filters this list of events to repairs that took more than 1 day to move from the first Under Repair status to the final Normal Operation or Shutdown status.
There are then four summarization queries performed for each repair range:
- Count the number of leak inspections that occurred
- Count the number of shutdowns that occurred
- Add all the gas added in the service events until the asset is repaired
- Count the number of repairs required until the asset is repaired
Calculation Methodology
Services Until Repaired: Summation of service events:
- Service Date Greater than or equal to when the asset went Under Repair
- Service Date Less than or equal to when the asset went to Normal Operation
- Service Event Type of Service/Leak Repair
Inspections Until Repaired: Summation of leak inspections:
- Service Date Greater than or equal to when the asset went Under Repair
- Service Date Less than or equal to when the asset went to Normal Operation
- Service Event Type of Leak Inspection
Shutdowns: Summation of leak inspections:
- Service Date Greater than or equal to when the asset went Under Repair
- Service Date Less than or equal to when the asset went to Normal Operation
- Service Event Type of Shutdown/Mothball
Repair Status: Current Operational Status
Under Repair Date: Date Service Event resulted Operational Status of Under Repair
Days Under Repair: Repair/Shutdown Date – Service Date of first Leak Detected Date
- If asset has not been repaired or shutdown yet, then date of report is used
Date Changed to Normal Operation: Repair or Shutdown date
Gas Added Under Repair (Lbs): Summation of Net Gas Added
- For each service event in the range, Gas Added – Gas Removed = Net Gas Added
- Sum all Net Gas Added for each service event
Gas Added Under Repair (Kgs): Gas Added Under Repair (Lbs) / 2.20462