# US 2014/0207771 A1 · Methods and Systems for Mapping Repair Orders within a Database

> Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt

- Number: US 2014/0207771 A1
- Document ID: US20140207771A1
- Status: Published application
- Kind: A1
- Application number: 13/746,165
- Filed: 2013-01-21
- Published: 2014-07-24
- Earliest claimed: 2013-01-21
- Assignees: Snap-on Incorporated
- Applicants: Snap-On Incorporated
- Inventors: Patrick S. Merg
- Web page: https://patentgrep.com/patent/US20140207771A1

## CPC

- G06Q 10/20: Administration of product repair or maintenance
- G06F 3/0482: Interaction with lists of selectable items, e.g. menus
- G06F 3/04842: Selection of displayed objects or displayed text elements (G06F3/0482 takes precedence)
- G06F 16/316: {Indexing structures}
- G06Q: INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)

## Abstract

Methods and systems for mapping repairs orders within a database are described. Mapping a repair order can include generating a searchable data record with multiple data record fields. Each data record field can include a term located on the repair order or a standard term associated with the term on the repair order. In order to retrieve repair orders from the database, the data records can be searched using search criteria that match standard terms storable in the data record fields. Although the repair orders can be searched to find repair orders with terms that match the search criteria, the search may be carried our more efficiently (e.g., quicker) by searching the data records instead of the repair orders. One or more repairs orders can be associated with real-fix tips. Phrases of the real-fix tips can be selected automatically based, for example, or RO terms recited on the repair orders.

## Claims

### Claim 1

A method comprising:
storing, within a repair order (RO) database at a computer-readable data storage device, a first RO comprising contents pertaining to servicing a device;
identifying, during a search of the contents of the first RO using a processor, first field data that matches data defined for recording in at least one data field of a data record to map repair orders;
generating, at the computer-readable data storage device, a first data record to map the first RO for subsequent searching of the RO database; and
storing, within the first data record at the computer-readable data storage device, the first field data identified during the search of the contents of the first RO.

### Claim 2 (depends on 1)

The method of claim 1, further comprising:
assigning, using the processor, a first RO identifier to the first RO; and
storing the first RO identifier within the first data record.

### Claim 3 (depends on 2)

The method of claim 2, further comprising:
assigning, using the processor, a first line number to the first RO, wherein the first line number is associated with service procedure information within a first distinct portion of the first RO; and
storing the first line number within the first data record.

### Claim 4 (depends on 3)

The method of claim 3, further comprising:
assigning, using the processor, a second line number to the first RO, wherein the second line number is associated with service procedure information within a second distinct portion of the first RO; and
generating, at the computer-readable data storage device, a second data record to map the first order for subsequent searching of the RO database,
wherein the first data record pertains to the service procedure information within the first distinct portion of the first RO, and
wherein the second data record pertains to the service procedure information within the second distinct portion of the first RO.

### Claim 5 (depends on 1)

The method of claim 1, further comprising:
storing, within the computer-readable data storage device, a set of standard and non-standard RO terms, wherein each standard RO term in the set is associated with at least one non-standard RO term;
identifying, during the search of the contents of the first RO using the processor, that the contents of the first RO comprise a non-standard term within the set;
storing, within the computer-readable data storage device, a mapped RO associated with the first RO,
wherein contents of the mapped RO match the contents of the first RO except that the mapped RO includes the standard term associated with the non-standard term in place of the non-standard term within the first RO.

### Claim 6 (depends on 1)

The method of claim 1, further comprising:
storing, within the computer-readable data storage device, a set of standard and non-standard RO terms, wherein each standard RO term in the set is associated with at least one non-standard RO term;
identifying, during the search of the contents of the first RO using the processor, that the contents of the first RO comprise a non-standard term within the set; and
modifying the contents of the first RO by replacing the identified non-standard term with the standard term associated with the non-standard term.

### Claim 7 (depends on 6)

The method of claim 6, wherein the standard term and the non-standard terms identify a diagnostic trouble code settable by the vehicle, a component name of a component attached to or within the vehicle, or a labor operation.

### Claim 8 (depends on 1)

The method of claim 1, further comprising:
storing, within the computer-readable data storage device, a set of context terms usable to determine a context of an RO;
identifying, during the search of the contents of the first RO using the processor, that the contents of the first RO comprise a context term within the set of context terms,
determining, from the set of context terms, a context of the first RO based on the context term the first RO comprises; and
storing, within the first data record at the computer-readable data storage device, data indicating the determined context of the first RO.

### Claim 9 (depends on 8)

The method of claim 8, wherein the context of the first RO is an electrical context, a mechanical context, or a hydraulic context.

### Claim 10 (depends on 1)

The method of claim 1,
wherein the device is a vehicle drivable on land or maneuverable on a body of water, and
wherein the first field data comprises at least one of the following field data: data that indicates a model year of the vehicle, data that indicates a make of the vehicle, data that indicates a model name of the vehicle, data that indicates an engine used within the vehicle, and data that indicates a system used within the vehicle.

### Claim 11 (depends on 1)

The method of claim 1, further comprising
storing, within the computer-readable data storage device, a plurality of other data records,
wherein each data record of the plurality of other data records is associated with a respective RO line,
wherein each respective RO line is associated with service procedure information within a respective distinct portion of an RO stored within the RO database, and
wherein the plurality of other data records includes at least six of the following data records: (i) a data record including an RO identifier field, (ii) a data record including an RO line number field, (iii) a data record including a model year field, (iv) a data record including a vehicle make field, (v) a data record including a vehicle model field, (vi) a data record including an engine field, (vii) a data record including a system field, (viii) a data record including an RO context field, (ix) a data record including a real-fix-tip identifier field, (x) a data record including a diagnostic trouble code field, (xi) a data record including a vehicle component field, (xii) a data record including a service date field, (xiii) a data record including a service location field, (xiv) a data record including a labor operation code field, (xv) a data record including a repair technician field, (xvi) a data record including a duplicate RO field, (xvii) a data record including an RO group field, (xviii) a data record including a quantity of characters field, (xix) a data record including an RO validation field, and (xx) a data record including a RO publication field.

### Claim 12 (depends on 1)

The method of claim 1, further comprising:
storing, within the RO database at the computer-readable data storage device, a plurality of other repair orders, wherein each RO of the plurality of repair orders comprises contents pertaining to servicing a respective device;
storing, within the RO database at the computer-readable data storage device, a plurality of data records comprising the first data record and at least one data record for each RO of the plurality of repair orders;
receiving, at the processor, search criteria and a request to locate a group of repair orders comprising data that matches the search criteria; and
locating the group of repair orders within the RO database by searching the plurality of data records based on the received search criteria.

### Claim 13

A system comprising:
a computer-readable data storage device storing a repair order (RO) database and within the RO database a first RO comprising contents pertaining to servicing a device; and
a data processing machine including a processor configured to execute computer-readable program instructions,
wherein the computer-readable program instructions include program instructions executable by the processor to (i) identify, during a search of the contents of the first RO using the processor, first field data that matches data defined for recording in at least one data field of a data record to map repair orders, (ii) generate, at the data storage device, a first data record to map the first RO for subsequent searching of the RO database, and (iii) store, within the first data record, the first field data identified during the search of the contents of the first RO.

### Claim 14 (depends on 13)

The system of claim 13,
wherein the computer-readable data storage device is storing a set of standard and non-standard RO terms, wherein each standard RO term in the set is associated with at least one non-standard RO term,
wherein the computer-readable program instructions include program instructions executable by the processor to (i) identify, during the search of the contents of the first RO using the processor, that the contents of the first RO comprise a non-standard term within the set, and (ii) store, within the computer-readable data storage device, a mapped RO associated with the first RO, and
wherein contents of the mapped RO match the contents of the first RO except that the mapped RO includes the standard term associated with the non-standard term in place of the non-standard term within the first RO.

### Claim 15 (depends on 13)

The system of claim 13,
wherein the computer-readable data storage device is storing a set of standard and non-standard RO terms, wherein each standard RO term in the set is associated with at least one non-standard RO term, and
wherein the computer-readable program instructions include program instructions executable by the processor to (i) identify, during the search of the contents of the first RO using the processor, that the contents of the first RO comprise a non-standard term within the set, (ii) store, within the computer-readable data storage device, a mapped RO associated with the first RO, and (iii) modify the contents of the first RO by replacing the identified non-standard term with the standard term associated with the non-standard term.

### Claim 16 (depends on 13)

The system of claim 13,
wherein the computer-readable data storage device is storing a set of context terms usable to determine a context of an RO, and
wherein the computer-readable program instructions include program instructions executable by the processor to (i) identify, during the search of the contents of the first RO using the processor, that the contents of the first RO comprise a context term within the set of context terms, (ii) determine, from the set of context terms, a context of the first RO based on the context term the first RO comprises, and (iii) store, within the first data record at the computer-readable data storage device, data indicating the determined context of the first RO.

### Claim 18 (depends on 13)

The system of claim 13,
wherein the computer-readable data storage device is storing a plurality of other data records,
wherein each data record of the plurality of other data records is associated with a respective RO line,
wherein each respective RO line is associated with service procedure information within a respective distinct portion of an RO stored within the RO database, and
wherein the plurality of other data records includes at least six of the following data records: (i) a data record including an RO identifier field, (ii) a data record including an RO line number field, (iii) a data record including a model year field, (iv) a data record including a vehicle make field, (v) a data record including a vehicle model field, (vi) a data record including an engine field, (vii) a data record including a system field, (viii) a data record including an RO context field, (ix) a data record including a real-fix-tip identifier field, (x) a data record including a diagnostic trouble code field, (xi) a data record including a vehicle component field, (xii) a data record including a service date field, (xiii) a data record including a service location field, (xiv) a data record including a labor operation code field, (xv) a data record including a repair technician field, (xvi) a data record including a duplicate RO field, (xvii) a data record including an RO group field, (xviii) a data record including a quantity of characters field, (xix) a data record including an RO validation field, and (xx) a data record including a RO publication field.

### Claim 19

A method comprising:
receiving, at a processor, a first repair order (RO) term pertaining to a service procedure described on a computer-readable RO;
selecting, using the processor based on the first RO term, a first phrase for including within a real-fix tip pertaining to the service procedure described on the computer-readable RO;
generating, using the processor, the real-fix tip pertaining to the service procedure described on the computer-readable RO, wherein the real-fix tip includes the first phrase selected based on the first RO term; and
transmitting the real-fix tip including the first phrase selected based on the first RO term.

### Claim 20 (depends on 19)

The method of claim 19, further comprising:
storing, within a computer-readable data storage device, a plurality of RO terms and a plurality of phrases,
wherein each phrase of the plurality of phrases is associated with at least one RO term of the plurality of RO terms,
wherein the first phrase is associated with the first RO term received at the processor, and
wherein selecting the first phrase includes the processor searching the computer-readable data storage device to locate the first RO term received at the processor and the processor determining that the first phrase is associated with the first RO term received at the processor.

### Claim 21 (depends on 19)

The method of claim 19,
wherein the at least the first RO term comprises a standard RO term;
the method further comprising:
receiving, at the processor, a second RO term pertaining to the service procedure described on the computer-readable RO;
wherein receiving the first RO term occurs after the processor selects, from a set of standard terms, the first RO term based on the first RO term being associated with the second RO term.

### Claim 22 (depends on 19)

The method of claim 19,
wherein the real-fix tip includes a title, a customer complaint, a cause, and a correction, and
wherein the processor selects the first phrase for including within the title, the customer complaint, the cause, or the correction.

### Claim 23 (depends on 19)

The method of claim 19, wherein the first RO term comprises at least one of a diagnostic trouble code (DTC) and a vehicle component name.

### Claim 24 (depends on 23)

The method of claim 23,
wherein the first phrase selected using the processor comprises a complete phrase including the at least one of the DTC and the vehicle component name, and
wherein the transmitted real-fix tip comprises the complete phrase.

### Claim 25 (depends on 23)

The method of claim 23,
wherein the first phrase selected using the processor comprises an incomplete phrase,
wherein generating the real-fix tip includes generating a complete phrase by completing the incomplete phrase to include the at least one of the DTC and the vehicle component name, and
wherein the transmitted real-fix tip comprises the complete phrase.

### Claim 26 (depends on 19)

The method of claim 19, further comprising:
storing, within a computer-readable data storage device, computer-readable program instructions executable to select the first phrase and to generate the real-fix tip,
wherein selecting the first phrase and generating the real-fix tip includes the processor executing the computer-readable program instructions to select the first phrase and to generate the real-fix tip, and
wherein selecting the first phrase and generating the real-fix tip occurs before the computer-readable RO is first selected for displaying at a data processing machine.

### Claim 27 (depends on 19)

The method of claim 19, further comprising:
storing, within a computer-readable data storage device, computer-readable program instructions executable to select the first phrase and to generate the real-fix tip,
wherein selecting the first phrase and generating the real-fix tip includes the processor executing the computer-readable program instructions to select the first phrase and to generate the real-fix tip, and
wherein selecting the first phrase and generating the real-fix tip occurs after the computer-readable RO being selected for displaying at a data processing machine.
