The Employee Timesheet Audit information is taken from your employee file and records any modifications made to any employee timesheet records. To generate this file during End of Day, Employee Timesheet Information must be set to Y in getdata (see Setting Up Data Sharing) and an employee timesheet must be edited for the current pay period.
The following table explains the naming conventions of the employee timesheet audit data share file: #####h[md].shr
| Field | Definition | ||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ##### | Store Number | ||||||||||||||||||||||||||||||||
| h | This character denotes that the file contains employee timesheet audit 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”,”JD”,”555555555″, 01/26/1998,”1″,”01/16/1998″,7,…
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 | 10 | 11 |
| “1” | “JD” | “555555555” | 01/26/1998 | “1” | “01/16/1998” | “7” | “20” | “18” | “30” | “0” |
| 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 |
| “7” | “20” | “17” | “45” | “0” | “2” | “LUNCH” | “3” | “PAID BREAK” | “-0.75” | “8.25” |
| 23 | 24 | 25 | 26 | 27 | 28 |
| “32000.00” | “12.38” | “80” | “Y” | “John Doe” | “TB3JRE” |
| Num. | Description | Definition | ISI Field Name | Output Format* | Quoted? | Example Value | General Release Version When Added |
|---|---|---|---|---|---|---|---|
| 1 | Store Number | Store number that generated the timesheet audit. | inf0.store_nbr | #(5) | X | 1 | 6.835 |
| 2 | Employee ID | The ID of the employee on the timesheet. | hrf3.empl | X(10) | X | JD | 6.835 |
| 3 | Alternate ID | Employee’s Alternate ID. | hrf1.soc_sec | #(20) | X | 555555555 | 6.835 |
| 4 | Last Update date | The date of the last change to an employee record. | hrf3.last_update | ##/##/#### | 01/26/1998 | 6.835 | |
| 5 | Last Update ID | ID of person who last updated record. | hrf3.last_update_id | X(10) | X | 1 | 6.835 |
| 6 | Date | The date that the timesheet was created. | hrf3.date | ##/##/#### | 01/16/1998 | 6.835 | |
| 7 | Old In Hours | The hour the employee clocked in before editing. | hrf3.old_inhh | #(2) | 7 | 6.835 | |
| 8 | Old In Minutes | The minute the employee clocked in before editing. | hrf3.old_inmm | #(2) | 20 | 6.835 | |
| 9 | Old Out Hours | The hour the employee clocked out before editing. | hrf3.old_outhh | #(2) | 18 | 6.835 | |
| 10 | Old Out Minutes | The minute the employee clocked out before editing. | hrf3.old_outmm | #(2) | 30 | 6.835 | |
| 11 | Old Break | The total amount of break time before editing. | hrf3.old_break | #(2).#(2) | 0 | 6.835 | |
| 12 | New In Hours | The hour the employee clocked in after editing. | hrf3.new_inhh | #(2) | 7 | 6.835 | |
| 13 | New In Minutes | The minute the employee clocked in after editing. | hrf3.new_inmm | #(2) | 20 | 6.835 | |
| 14 | New Out Hours | The hour the employee clocked out after editing. | hrf3.new_outhh | #(2) | 17 | 6.835 | |
| 15 | New Out Minutes | The minute the employee clocked out after editing. | hrf3.new_outmm | #(2) | 45 | 6.835 | |
| 16 | New Break | The total break time after editing. | hrf3.new_break | #(2).#(2) | 0 | 6.835 | |
| 17 | Old Type code | The type code of the shift before editing. | hrf3.old_type_code | X(2) | X | 2 | 6.835 |
| 18 | Old Type | The type description of the shift before editing. | hrf3.old_type | X(40) | X | LUNCH | 6.835 |
| 19 | New Type code | The type code of the shift after editing. | hrf3.new_type_code | X(2) | X | 3 | 6.835 |
| 20 | New Type | The type description of the shift after editing. | hrf3.new_type | X(40) | X | PAID BREAK | 6.835 |
| 21 | Total Hours Change | The difference in the total hours the employee worked after editing vs. the total hours worked before editing. | Calculated value.** | -0.75 | 6.835 | ||
| 22 | Hourly rate | The hourly rate for hourly employees | hrf1.hourly | #(8).#(2) | X | 8.25 | 6.835 |
| 23 | Salary rate | The annual salary if the employee is considered a salaried employee. | hrf1.salary | #(8).#(2) | X | 32000.00 | 6.835 |
| 24 | Overtime rate | The overtime rate if the employee is considered an hourly employee | hrf1.ot_rate | #(2).#(4) | X | 12.38 | 6.835 |
| 25 | Hours per pay period | The number of hours the employee is expected to work in a pay period. Required for salaried employees only. | hrf1.hrs_per_period | #(4).#(0) | X | 80 | 6.835 |
| 26 | Included hours | A “Y” or “N” response for whether you want to include the working hours of the employee in the calculation of the labor worked. Required for salaried employees only. | hrf1.incl_hours | X(1) | X | Y | 6.835 |
| 27 | Employee Name | Employee name saved in Set Up Employees | hrf1.name | X(30) | X | John Doe | 6.835 |
| 28 | Employee Unique ID | hrfp.uid | X(20) | X | 11.2 |
* 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.
** New hours calculation: ((((hrf3.new_outmm – hrf3.new_inmm) / 60) + (hrf3.new_outhh – hrf3.new_inhh) – hrf3.new_break) – (((hrf3.old_outmm – hrf3.old_inmm) / 60) + (hrf3.old_outhh – hrf3.old_inhh) – hrf3.old_break))
