In-Service Management Tool

NAPRS Facility Database

Select Facility Inventory and Cost Analysis from the Main Menu.

Click the Go button.

The Facility Inventory and Cost Analysis reports use data from the NAPRS Database. Reports that can be generated are:

• Facility Inventory
• Cost Analysis

Set the report parameters. 

1. Begin by Selecting the facilities that are the subject of the reports you wish to generate.
   
   
1. Select the Facility Type (the default is All) from the drop down list.
   
   
2. Select the Facility Code (the default is All). To refine the report with specific Facility Code(s):
   
   
1. Click the 3-dots Button to open a pop up menu window.
   
   
2. Select the specific Facility Code(s) from the pop up menu window. Hold down the Ctrl Key for multiple selections.
   
   
3. You will only see the Facility Code(s) listed in the pop up menu window when you have already selected a Facility Type.  
   
   
2. You can further refine the report by Selecting a Site.
   
   
1. Selecting a Site



1. When you Select a Site you can further refine the report by Selecting one or more of the following parameters:
1. Region
2. Location ID
3. Restoration Code
4. Control ID (applies to Airport Facilities)
   
   
2. Select the Region first. The pop up window menu for the Location ID will then only list locations appropriate to the selected Region.
   
   
3. The default value for each is ALL. To Select the value for each parameter Click the 3-dots Button by the blank widow for each. The Control ID menu list will reflect the Airport Facilities that have been selected.
1. A pop up window menu will open.
2. Click on the desired value to Select it.
3. Click the OK button to Enter it. 
   
   
2. The Location Lookup link pops up a window from which you can search for the Location ID and its Region by typing in the name of the city or city and state if you don't know or remember the it.



1. The search will run if you only enter a City Name. The result will list all cities with the specified name in grouped by state.
   
   
2. The search will also run if you enter: City Name, State. Use the 2 letter abbreviation for the state and make sure to leave a space between the comma and the state. Example: Ontario, CA
   
   
3. The search response will produce a table showing
1. Region
2. Location ID
3. Name of City and State
   
   
4. Use this information to select the appropriate values from the corresponding pop up window menus.  
   
   
   
3. Selecting the Top Airports List is an alternative to selecting a Site.



1. Check the Box next to Top Airports to activate the customized list of airports.



1. Click the 3-dots Button to open a pop up window and view the current list.
   
   
2. Airports can be Deleted or Added to the list using the form in the pop up window.
   
   
2. Using the Top Airports List is an exclusive parameter. The other site values will not be functional.
   
   
   

4. Date Range Parameters have 4 options. Ranges must use dates prior to the current date. The ISMT application will run a validation on the dates that you type in and warn you if the dates do not meet accepted parameters.
   
   
   1. Leave the Date Range boxes blank. The report will include all pertinent dates in the database.
      
      
   2. Start Date: The Default Start Date reflects the most commonly used Date Range. To limit to a Start Date range, type in a date in the second Start Date box. The second date should be later than the first date.
      
      
   3. End Date: To limit to a End Date range, type in a date in the second End Date box. The second date should be later than the first date. 
      
      
5. Reports that can be generated are:
   1. Facility Inventory
      1. Summarize by: refinement options that can be selected from 2 drop down lists.
         
         
      2. The first drop down list allows you to Summarize by:
      1. None
      2. Facility
      3. Region
      4. Year
         
         
      3. The second drop down list defaults to None when None is selected in the first drop down list.
         
         
      1. If you have selected another option in the first drop down list you will be able to select additional options from the second drop down list.
         
         
      2. The options available will vary depending on the value you selected from the first drop down list
      1. None = None
      2. Facility = None, Region, Year, Quarter or Month
      3. Region = None, Facility, Year, Quarter or Month
      4. Year = None, Facility or Region
         
         
      4. If you use the default NONE values the generated report will display a 7 column list of facilities. The fields for the columns are:
         1. Facility Code
         2. Location
         3. Cost Center
         4. Status
         5. Start Date
         6. End Date
         7. Restoration Code. 
            
            
      5. When you use one of the other combinations of refinement parameters the report will be a table or columned list as is appropriate to the data requested.
         
         
   2. Cost Analysis - There are 3 refinement value options on the Summarize by: pop down list.
      
      
   1. The default is Summarize by: NONE. If you use the default NONE value the generated report will display a 9 column list showing costs in dollar amounts listed by Facility, Region and ID Code.
      
      
   1. The fields for the columns are:
   1. Facility Code
   2. Region
   3. Ident
   4. Labor
   5. Non-Labor
   6. Centralized
   7. Transfer
   8. Overhead
   9. Investment
      
      
   2. Click the GO link at the end of each item row to view a detailed cost breakdown for that list item.
      
      
   3. Use the browser Back button to return to the report list.
      
      
   2. The Summarize by: report is an 8 column list. The first column is the selected option title, the rest of the columns show dollar amounts. The fields for the columns are:
   1. The selected option: Facility, Region or Year
   2. Labor
   3. Non-Labor
   4. Centralized
   5. Transfer
   6. Overhead
   7. Investment
   8. Total
      
      
      
   3. Click the Show Report button to generate the report.
      
      
   4. Click the Export button to export the report data to Excel.
      
      
   5. User the browser Print button to Print a Report from a Report Screen.
      
      
   6. Remember to type a Title into the Title Box in the top area of the screen if you are going to Save the report for later retrieval.