The GSR Status Information is taken from your GSR detailed service data file and includes detailed service recommendation information for all the workorders started in LubeSoft. To generate this file during End of Day, GSR Usage/Status Information must be set to Y in getdata (see Setting Up Data Sharing).
The following table explains the naming conventions of the GSR status data share file: #####v[md].shr
| Field | Definition | ||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ##### | Store Number | ||||||||||||||||||||||||||||||||
| v | This character denotes that the file contains GSR status information. | ||||||||||||||||||||||||||||||||
| m | This character denotes the month. The characters range from a to l and are as follows:
|
||||||||||||||||||||||||||||||||
| d | This character denotes the day. The characters range from a to z and 1 to 5 and are as follows:
|
The following is an example of an actual record in what is known as “comma-delimited” format. This means that the information you entered in each field in this POS system record is separated by a comma.
“1”,”65428752″,”06/15/2011″,”ABC1123″,…
We have numbered the fields in the following record in order to explain them more clearly to you. Each bolded number indicates one field.
| Note: | Some of the fields contained in this file are for internal system processing only and may not be useful to you. |
| 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 |
| “1” | “65428752” | “06/15/2011” | “ABC123” | “50125” | “59545675312546” | “32144” | “Full Service” |
| 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 |
| “FS1|FS2|FS3” | “Y” | “Y” | “Due Now” | “Severe” | “Due Now” | “OK” | “N/A” | “Y” | “” | “06/15/2011” | “” | “75695” |
The following chart lists and describes the contents of the (v) GSR status file.
| Num. | Description | Definition | ISI Field Name | Output Format* | Quoted? | Example Value | General Release Version When Added |
|---|---|---|---|---|---|---|---|
| 1 | Store Number | Store number where this GSR record was generated | inf0.store_nbr | #(5) | X | 1 | 11.1 |
| 2 | Record Number | Internal record number for this service review record | gsrd.recnum | #(8) | X | 65428752 | 11.1 |
| 3 | Invoice Date | Date the invoice was cashed out. Could be blank | gsrd.invoice_date | ##/##/#### | X | 06/15/2011 | 11.1 |
| 4 | Vehicle ID | Vehicle ID | gsrd.vehid | X(13) | X | ABC123 | 11.1 |
| 5 | Vehicle Mileage | Vehicle mileage at time of service review record | gsrd.mileage | #(8) | X | 50125 | 11.1 |
| 6 | Transaction Number | Transaction number of associated cashed out invoice. Could be blank. | gsrd.tran# | #(14) | X | 59545675312546 | 11.1 |
| 7 | GSRG Record Number | Record number for corresponding record in the GSR Usage (“u” share) file. | gsrd.gsrg_rec# | #(8) | X | 32144 | 11.1 |
| 8 | Service Description | Description of the Service Review service | gsrd.service_desc | X(255) | X | Full Service | 11.1 |
| 9 | Service Codes | Pipe delimited list of service codes attached to the service | gsrd.service_codes | X(255) | X | FS|FS1|FS2 | 11.1 |
| 10 | On Graph Flag | Y or N depending on if the service is set to be shown on the graph | gsrd.on_graph | X(1) | X | Y | 11.1 |
| 11 | On Form Flag | Y or N depending on if the service is set to be shown on the form | gsrd.on_form | X(1) | X | Y | 11.1 |
| 12 | Primary Status | Status of the primary recommendation. Can be OK, Due Now, Due Soon or N/A. | gsrd.primary_status | X(8) | X | Due Now | 11.1 |
| 13 | Primary Recommendation Type | Which type of recommendation is the primary recommendation. Can be Severe, Normal or Store. | gsrd.primary_type | X(6) | X | Severe | 11.1 |
| 14 | Severe Status | Status of the severe recommendation. Can be OK, Due Now, Due Soon or N/A. | gsrd.severe_status | X(8) | X | Due Now | 11.1 |
| 15 | Normal Status | Status of the normal recommendation. Can be OK, Due Now, Due Soon or N/A. | gsrd.normal_status | X(8) | X | OK | 11.1 |
| 16 | Store Status | Status of the store recommendation. Can be OK, Due Now, Due Soon or N/A. | gsrd.store_status | X(8) | X | N/A | 11.1 |
| 17 | On Invoice Flag | Y or N indicating if the service was sold on the corresponding invoice | gsrd.on_invoice | X(1) | X | Y | 11.1 |
| 18 | Invoice Processed Code | Code indicating the final result of the workorder:
A – aborted D – deleted Blank – cashed out |
gsrd.inv_processed | X(1) | X | 11.1 | |
| 19 | Invoice Start Date | Date the invoice was started | inf1.wo_start_date | ##/##/#### | X | 06/15/2011 | 11.1 |
| 20 | Basis for the primary status | Blank for services that are OK or do not have a recommendation. Otherwise, it will read “miles_km” if the service is due based on miles or kilometers, or “months” if the service is due based on the month interval. | gsrd.status_basis | X(8) | X | 11.7 | |
| 21 | Invoice Workorder Number | The number of the workorder as generated by the POS system. | inf1.wo# | #(8) | X | 75695 | 15.17 |
* The Output Format column uses X to represent string fields and # to represent numeric fields. E.g. X(5) represents a string up to five characters in length. #(14) represents a number up to 14 digits in length.
