The Employee Timesheet information is taken from your employee file and records normal daily employee activities. 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 must clock in for the current day.
The following table explains the naming conventions of the employee timesheet information data share file: #####g[md].shr
| Field | Definition | ||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ##### | Store Number | ||||||||||||||||||||||||||||||||
| g | This character denotes that the file contains employee timesheet 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/23/1998″,”7″,”56″,”12″,”4″,”0″,”4.13″,”2″,”Break”,”P”,”57″….
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 | 12 | 13 |
| “1” | “JD” | “555555555” | “01/23/1998” | “7” | “56” | “12” | “4” | “0” | “4.13” | “2” | “Break” | “P” |
| 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 |
| “01/23/1998” | “8” | “57” | “9” | “59” | “JD” | “8.25” | “32000.00” | “12.38” | “80” | “Y” | “John Doe” | “TB3JRE” | “” | “” |
| Num. | Description | Definition | ISI Field Name | Output Format* | Quoted? | Example Values | General Release Version When Added |
|---|---|---|---|---|---|---|---|
| 1 | Store Number | Store number that generated the timesheet information. | inf0.store_nbr | #(5) | X | 1 | 6.835 |
| 2 | Employee ID | The ID of the employee on the timesheet. | hrf4.empl | X(10) | X | JD | 6.835 |
| 3 | Alternate ID | Employee’s Alternate ID number. | hrf1.soc_sec | X(20) | X | 555555555 | 6.835 |
| 4 | Date | The date the timesheet was created. | hrf4.date | ##/##/#### | 01/23/1998 | 6.835 | |
| 5 | In Hour | The hour the employee clocked in. | hrf4.inhh | #(2) | 7 | 6.835 | |
| 6 | In Minutes | The minute the employee clocked in. | hrf4.inmm | #(2) | 56 | 6.835 | |
| 7 | Out Hour | The hour the employee clocked out. | hrf4.outhh | #(2) | 12 | 6.835 | |
| 8 | Out Minutes | The minute the employee clocked out. | hrf4.outmm | #(2) | 4 | 6.835 | |
| 9 | Break | The total amount of break time. | hrf4.brk | #(2).#(2) | 0 | 6.835 | |
| 10 | Total Hours | The total hours worked by the employee. | hrf4.hrs | #(2).#(4) | 4.13 | 6.835 | |
| 11 | Type Code | The code for Type of shift. | hrf4.type_code | X(2) | X | 2 | 6.835 |
| 12 | Type | The detail description of the type of shift. | hrf4.type | X(40) | X | Paid Break | 6.835 |
| 13 | Paid-Unpaid | P-Paid, U-Unpaid | hrf4.paid_unpaid | X(1) | X | P | 6.835 |
| 14 | System Time Changed | The date the system time was changed. | hrf4.systime_changed | ##/##/#### | 01/23/1998 | 6.835 | |
| 15 | Changed at HH | The hour the system time was changed. | hrf4.changed_at_hh | #(2).#(0) | 8 | 6.835 | |
| 16 | Changed at MM | The minute the system time was changed. | hrf4.changed_at_mm | #(2).#(0) | 57 | 6.835 | |
| 17 | Changed to HH | The hour the system time was changed to. | hrf4.changed_to_hh | #(2).#(0) | 9 | 6.835 | |
| 18 | Changed to MM | The minute the system time was changed to. | hrf4.changed_to_mm | #(2).#(0) | 59 | 6.835 | |
| 19 | Override Employee ID | The ID of the employee who used the override functionality to clock-in an employee from a paid break/lunch. | hrf4.override_empl | X(10) | X | JD | 6.835 |
| 20 | Hourly rate | The hourly rate for hourly employees | hrf1.hourly | #(8).#(2) | X | 8.25 | 6.835 |
| 21 | Salary rate | The annual salary if the employee is considered a salaried employee. | hrf1.salary | #(8).#(2) | X | 32000.00 | 6.835 |
| 22 | Overtime rate | The overtime rate if the employee is considered an hourly employee. | hrf1.ot_rate | #(2).#(4) | X | 12.38 | 6.835 |
| 23 | 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 |
| 24 | 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 |
| 25 | Employee Name | Employee name saved in Set Up Employees | hrf1.name | X(30) | X | John Doe | 6.835 |
| 26 | Unique Employee ID | Unique Employee ID | hrfp.uid | X(20) | X | TB3JRE | 11.2 |
| 27 | Clock in type | Clock in type | hrf4.in_type | X(1) | X | 15.12 | |
| 28 | Clock out type | Clock out type | hrf4.out_type | X(1) | X | 15.12 |
* 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.
