The Employee Setup Information is taken from your employee setup file and includes the setup information for all the employees set up in your system. To generate this file during End of Day, Employee Setup Information must be set to Y in getdata (see Setting Up Data Sharing) and at least one employee must be set up.
The following table explains the naming conventions of the employee setup data share file: #####s[md].shr
| Field | Definition | ||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ##### | Store Number | ||||||||||||||||||||||||||||||||
| s | This character denotes that the file contains employee setups. | ||||||||||||||||||||||||||||||||
| 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.
“06/20/2011″,”JD”,”123456″,”Active”,…
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 |
| “06/20/2011” | “JD” | “123456” | “Active” | “John Doe” | “” | “” | “” | “06/20/1978” | “123 Fir St.” | “” |
| 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 |
| “97223” | “Portland” | “OR” | “503” | “968-8100” | “” | “” | “” | “1” | “05/15/2011” | “ISI” | “Y” | “Y” |
| 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 |
| “” | “M” | “” | “” | “” | “” | “” | “H” | “15.00” | “10.00” | “” | “” | “” | “” | “” | “02/18/2008” |
| 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52 | 53 |
| “02/18/2008” | “M” | “” | “” | “” | “” | “” | “” | “” | “03/12/2011” | “N” | “4388FJ2” | “6” |
| 54 | 55 | 56 | 57 | 58 | 59 | 60 | 61 | 62 | 63 | 64 | 65 | 66 | 67 | 68 | 69 | 70 | 71 | 72 |
| “” | “” | “” | “N” | “” | “” | “” | “50” | “25” | “” | “” | “” | “” | “” | “” | “” | “” | “” | “” |
The following chart lists and describes the contents of the (s) employee setup file.
| Num. | Description | Definition | ISI Field Name | Output Format* | Quoted? | Example Value | General Release Version When Added |
|---|---|---|---|---|---|---|---|
| 1 | Date | File creation date | none | ##/##/#### | X | 06/20/2011 | 11.1 |
| 2 | ID | Employee ID | hrf1.empl | X(10) | X | JD | 11.1 |
| 3 | Password | Employee password | hrf1.passwd | X(6) | X | 123456 | 11.1 |
| 4 | Status | Active or Inactive | hrf1.emp_status | X(10) | X | Active | 11.1 |
| 5 | Name | Employee name | hrf1.name | X(30) | X | John Doe | 11.1 |
| 6 | Unused | hrf1.soc_sec1 | #4.0 | 11.1 | |||
| 7 | Unused | hrf1.soc_sec2 | #4.0 | 11.1 | |||
| 8 | Unused | hrf1.soc_sec3 | #4.0 | 11.1 | |||
| 9 | Date of Birth | Employee date of birth | hrf1.dob | ##/##/#### | X | 06/20/1978 | 11.1 |
| 10 | Address 1 | Employee address line 1 | hrf1.addr1 | X(30) | X | 123 Fir St. | 11.1 |
| 11 | Address 2 | Employee address line 2 | hrf1.addr2 | X(30) | X | 11.1 | |
| 12 | Zip Code | Employee zip | hrf1.zip | X(10) | X | 97223 | 11.1 |
| 13 | City | Employee city | hrf1.city | X(20) | X | Portland | 11.1 |
| 14 | State | Employee state | hrf1.state | X(2) | X | OR | 11.1 |
| 15 | Area Code | Employee area code | hrf1.areacode | #(4.0) | X | 503 | 11.1 |
| 16 | Phone Number | Employee phone number | hrf1.phone | X(10) | X | 968-8100 | 11.1 |
| 17 | Hire Code | Code indicating reason of hire:
ACT – Active, Company Transfer In AHA – Active, Hire by Acquisition AOH – Active, Original Hire ARH – Active, Rehire ARI – Active, Reinstatement Blank |
hrf1.hire_reason | X(3) | X | 11.1 | |
| 18 | Race Code | Code indicating race:
A – White (Non-Hispanic) B – Black (Non-Hispanic) C – Hispanic D –Asian or Pacific Islander E – American Indian or Alaskan Native Blank |
hrf1.race | X(3) | X | 11.1 | |
| 19 | State Tax Status | Code indicating state tax status:
B – Married both spouses filing H – Head of household M – Married O – Married, one spouse filing S – Single X – Married – filing single |
hrf1.sate_tax_stat | X(3) | X | 11.1 | |
| 20 | Store Number | Store number where employee was last edited | hrf1.store_number | #(6.0) | 1 | 11.1 | |
| 21 | Last Update Date | Date when employee record was last edited | hrf1.last_update | ##/##/#### | X | 05/15/2011 | 11.1 |
| 22 | Last Update Employee | Id of employee to last edit employee record | hrf1.last_update_id | X(10) | X | ISI | 11.1 |
| 23 | I-9 Flag | Y, N or blank to indicate if I-9 has been completed | hrf1.i_9done | X(1) | X | Y | 11.1 |
| 24 | Required Check-in | Y or N to indicate if employee is required to clock in and out of the system | hrf1.rcheckin | X(1) | X | Y | 11.1 |
| 25 | Unused | hrf1.vac_days_remain | #4.0 | 11.1 | |||
| 26 | Gender | M, F or blank to indicate gender | hrf1.sex | X(1) | X | M | 11.1 |
| 27 | Hire Source | Code to indicate hire source:
AD – Advertisement AQ – Acquired Company BR – Business Referral CS – Col/Univ Student PLC EA – Employment Agency / Exec Search Firms FE – Former Employee GA – Government Agency JP – Job Posting MA – Minority Agency OS – Other School Source RR – Emp. Referral UR – Unsolicited Resume WI – Walk-In Blank |
hrf1.hire_source | X(3) | X | 11.1 | |
| 28 | Citizenship Code | Code to indicate country of citizenship. See LubeSoft for complete list of country codes. | hrf1.citizenship | X(3) | X | 11.1 | |
| 29 | Handicap Code | Code to indicate handicap status:
01 – Not Handicapped 02 – Handicapped Blank |
hrf1.handi_cap_code | X(3) | X | 11.1 | |
| 30 | Veteran Code | Code to indicate veteran status:
01 – Not a Veteran 02 – Vietnam Era Veteran 03 – Disabled Veteran 04 – Other Veteran Blank |
hrf1.veteran_status | X(3) | X | 11.1 | |
| 31 | Job Title Code | Code to indicate job title:
001 – Technician/Lube 002 – Cashier 003 – Mgr/Assistant 004 – Mgr/Store 005 – Tech/Certified 006 – Technician/Senior 007 – Mgr/Area |
hrf1.job_code | X(20) | X | 11.1 | |
| 32 | Pay Basis | H for hourly or S for salary | hrf1.pay_basis | X(1) | X | H | 11.1 |
| 33 | Overtime Rate | Employee overtime pay rate or blank if salary | hrf1.ot_rate | #(2.4) | 15.00 | 11.1 | |
| 34 | Hourly Rate | Employee regular hourly rate or blank if salary | hrf1.hourly | #(8.2) | 10.00 | 11.1 | |
| 35 | Salary Rate | Employee annual salary rate or blank if hourly | hrf1.salary | #(8.2) | 11.1 | ||
| 36 | Federal Tax Status | Code indicating federal tax status:
B – Married both spouses filing H – Head of household M – Married O – Married, one spouse filing S – Single X – Married, filing single |
hrf1.fed_tax_status | X(3) | X | 11.1 | |
| 37 | Federal Tax Exemptions | Indicates the number of federal exemptions | hrf1.fed_exempts | #(2.0) | 11.1 | ||
| 38 | Hours Per Pay Period | Indicates the number of hours salaried employees are expected to work. Salaried employees only. | hrf1.hrs_per_period | #(4.0) | 11.1 | ||
| 39 | Include Hours | Y or N to indicate if the employee’s hours will be used in the store labor calculations. Salaried employees only. | hrf1.incl_hours | X(1) | X | 11.1 | |
| 40 | Original Hire Date | Employee start date | hrf1.orig_hire_date | ##/##/#### | X | 02/18/2008 | 11.1 |
| 41 | Last Hire Date | Same as original hire date | hrf1.last_hire_date | ##/##/#### | X | 02/18/2008 | 11.1 |
| 42 | Last Day Worked | Employee end date | hrf1.last_day_wrkd | ##/##/#### | X | 11.1 | |
| 43 | Unused | hrf1.effect_date | ##/##/#### | X | 11.1 | ||
| 44 | State Tax Exemptions | Indicates the number of state tax exemptions | hrf1.state_exempts | #(2.0) | 11.1 | ||
| 45 | Federal Additional Amount | Additional federal withholding per pay period | hrf1.fed_extra | #(6.2) | 11.1 | ||
| 46 | State Additional Amount | Additional state withholding per pay period | hrf1.state_extra | #(6.2) | 11.1 | ||
| 47 | Local Authority | Local source of tax information | hrf1.local_authority | X(40) | X | 11.1 | |
| 48 | Unused | hrf1.old_ssnumber | X(9) | X | 11.1 | ||
| 49 | Unused | hrf1.approved | X(1) | X | 11.1 | ||
| 50 | Previous Change Date | Date the employee password was last changed | hrf1.pswd_chg_date | ##/##/#### | X | 03/12/2011 | 11.1 |
| 51 | Central Send Flag | Y or N to indicate if set up should be sent from central to site | hrf1.send | X(1) | X | N | 11.1 |
| 52 | Alternate ID | Employee alternate ID | hrf1.soc_sec | X(20) | X | 4388FJ2 | 11.1 |
| 53 | Security Level | Number 0-9 to indicate the employees security level | hrf1.security | #(2.0) | 6 | 11.1 | |
| 54 | DMS Cashier Title | Only used for systems interfaced with a dealer management system. | hrf1.dms_cashier | X(15) | X | 11.1 | |
| 55 | DMS Technician Title | Only used for systems interfaced with a dealer management system. | hrf1.dms_tech | X(12) | X | 11.1 | |
| 56 | DMS Service Advisor Title | Only used for systems interfaced with a dealer management system. | hrf1.dms_svcadvisor | X(15) | X | 11.1 | |
| 57 | Timeclock Override Flag | Y or N to indicate if this employee has permission to override permissions to allow other employees to clock in early from paid breaks or lunches. | hrf1.allow_override | X(1) | X | N | 11.1 |
| 58 | Fingerprint enroller flag | Fingerprint enroller flag | hrf1.fp_enroller | X(1) | X | 11.2 | |
| 59 | Employee UID | Unique ID of the employee | hrfp.employee_uid | X(20) | X | 11.2 | |
| 60 | Location Store Number | Store number of the location that created the share file | inf0.store_nbr | X(5) | X | 1111 | 11.3 |
| 61 | Maximum price change increase % | Maximum price change increase % | hrf1.max_pc_inc | #(4.0) | 50 | 15.3 | |
| 62 | Maximum price change decrease % | Maximum price change decrease % | hrf1.max_pc_dec | #(4.0) | 25 | 15.3 | |
| 62 | LubeSoft API flag for controlling workorders | Y or N to indicate if employee is allowed to manually close out a workorder or delete one when the Wash API product is active. | hrf1.man_close_flg | X(1) | X | 15.11 | |
| 63 | Employee cell phone area code | Employee cell phone area code | hrf1.cell_areacode | #(4.0) | 15.11 | ||
| 64 | Employee cell phone number | Employee cell phone number | hrf1.cell_phone | X(10) | X | 15.11 | |
| 65 | Employee e-mail address | Employee e-mail address | hrf1.email | X(50) | X | 15.11 | |
| 66 | Primary store the employee works at | Free form field that can be used with ISI Central Setups | hrf1.primary_store | X(25) | X | 15.11 | |
| 67 | Free form note field line 1 | Free form note field line 1 | hrf1.note_line1 | X(75) | X | 15.11 | |
| 68 | Free form note field line 2 | Free form note field line 2 | hrf1.note_line2 | X(75) | X | 15.11 | |
| 69 | Free form note field line 3 | Free form note field line 3 | hrf1.note_line3 | X(75) | X | 15.11 | |
| 70 | Free form note field line 4 | Free form note field line 4 | hrf1.note_line4 | X(75) | X | 15.11 | |
| 71 | Free form note field line 5 | Free form note field line 5 | hrf1.note_line5 | X(75) | X | 15.11 | |
| 72 | Free form note field line 6 | Free form note field line 6 | hrf1.note_line6 | X(75) | X | 15.11 |
* 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.
