The Graphical Service Review Information is taken from your General GSR information file and includes the general GSR information for each invoice throughout the day. To generate this file during End of Day, GSR Status/Usage Information must be set to Y in getdata (see Setting Up Data Sharing) and a service review must be printed or viewed.
The following table explains the naming conventions of the GSR usage data share file: #####u[md].shr
| Field | Definition | ||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ##### | Store Number | ||||||||||||||||||||||||||||||||
| u | This character denotes that the file contains GSR usage 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”,”32144″,”06/15/2011″,”ABC123″,…
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 | 9 |
| “1” | “32144” | “06/15/2011” | “ABC123” | “50125” | “59545675312546” | “06/15/2011” | “08” | “15” |
| 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 |
| “34” | “N” | “N” | “Y” | “Y” | “” | “06/15/2011” | “75695” |
The following chart lists and describes the contents of the (u) GSR usage 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 | gsrg.recnum | #(8) | X | 32144 | 11.1 |
| 3 | Invoice Date | Date the invoice was cashed out. Could be blank | gsrg.invoice_date | ##/##/#### | X | 06/15/2011 | 11.1 |
| 4 | Vehicle ID | Vehicle ID | gsrg.vehid | X(13) | X | ABC123 | 11.1 |
| 5 | Vehicle Mileage | Vehicle mileage at time of service review record | gsrg.mileage | #(8) | X | 50125 | 11.1 |
| 6 | Transaction Number | Transaction number of associated cashed out invoice. Could be blank. | gsrg.tran# | #(14) | X | 59545675312546 | 11.1 |
| 7 | Last Access Date | Date GSR was last accessed for record | gsrg.lst_access_date | ##/##/#### | X | 06/15/2011 | 11.1 |
| 8 | Last Access Hour | Hour GSR was last accessed | gsrg.lst_access_hh | #(2) | X | 08 | 11.1 |
| 9 | Last Access Minute | Minute GSR was last accessed | gsrg.lst_access_mm | #(2) | X | 15 | 11.1 |
| 10 | Last Access Second | Second GSR was last accessed | gsrg.lst_access_ss | #(2) | X | 34 | 11.1 |
| 11 | Graph Viewed Flag | Y or N depending on if the graph was viewed through LubeG | gsrg.graph_viewed | X(1) | X | N | 11.1 |
| 12 | Graph Printed Flag | Y or N depending on if the graph was printed | gsrg.graph_printed | X(1) | X | N | 11.1 |
| 13 | Form Viewed Flag | Y or N depending on if the form was viewed through LubeG | gsrg.form_viewed | X(1) | X | Y | 11.1 |
| 14 | Form Printed Flag | Y or N depending on if the form was printed | gsrg.form_printed | X(1) | X | Y | 11.1 |
| 15 | Invoice Processed Code | Code indicating the final result of the workorder:
A – aborted D – deleted Blank – cashed out |
gsrg.inv_processed | X(1) | X | 11.1 | |
| 16 | Invoice Start Date | Date the invoice was started | inf1.wo_start_date | ##/##/#### | X | 06/15/2011 | 11.1 |
| 17 | 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.
