Back | Forward

• Location ID and Equipment ID Columns Expanded in the Database:  Effective with Release 6.0.x, location ID columns were expanded from 6 to 10 characters and equipment ID columns were expanded from 12 characters to 20 characters.

Although the location ID and equipment ID fields throughout the GUI were expanded, standard reports in the Query/Report Generator were not changed to accommodate the expansion. If you use more than 6 characters for a location ID or 12 characters for an equipment ID, you will need to modify your reports to ensure that they display the full number of characters.

• Note: Using a longer location ID may increase the size of part bar codes. If a part bar code is too long, it may run off the right side of the label and become unusable.

• Tip: Before you run the conversion against your production data, make sure that you run a test conversion from your current version to 6.0.x. The conversion could take a long time to complete as these expansions affect several large tables. You will need to plan how much time to set aside for your production conversion.

The application includes the following equipment unit reports, available from the Reports list box in the Standard toolbar. For a sample of these reports, see the Directory of Standard Reports.

• PR:EQ-LISTS OF EQ BY ID:  Lists equipment units by ID. Includes the fuel type of the equipment unit.

• PR:EQ-SERVICE REQUESTS:   Lists equipment IDs that have unresolved service requests.

• PR:EQ-DUE FOR PM BY DPT:  Lists IDs, sorted by department, of equipment units due or late for a PM service or inspection. Equipment units are listed on the report if the PM date due is either within the PM soon due range or is in the past. To run this report, you must use a run ID generated on the Data -> Equipment Management -> Equipment Due for PM/Inspection - by Equipment or the Equipment Due for PM/Inspection - by Location screen.

• PR:EQ-DUE FOR PM BY LOC(ation):   Lists all equipment unit IDs, by location, of equipment units that are due or late for a PM service or inspection. It includes equipment units on the report if the date they are due for PM falls within the PM soon due range, is in the past, or due by the specified date on the Data -> Equipment Management -> Equipment Due for PM/Inspection - by Equipment or the Equipment Due for PM/Inspection - by Location screen. To run this report, you must use a run ID generated on that screen.

The following reports exclude all equipment units that have a check (ü) in the Exclude from inventory lists field on the Authorization tab of the Data -> Equipment Units -> Fleet Equipment screen.

• PR:EQ-LISTS OF EQ BY CLASS:   Lists all equipment unit IDs assigned to a specified maintenance class.

• PR:EQ-LIST OF EQ BY DEPT:   Lists all equipment unit IDs assigned to a specified department ID.

• PR:EQ-LIST OF EQ BY ID:   Lists all equipment unit IDs.

• PR:EQ-SUB & PTS-EQ ID:   Lists all subsystems and parts for a specified range of equipment units.

• PR:EQ-SUB & PTS-EQ TYPE:   Lists all subsystems and parts for a specified range of equipment types.