Transaction Employee File
File: [EMPXTXN.ASC or NNNNRR00.EMT]
POS Filename: EMPLOYEE.EMP
Note
This file also updates the stores cashier table: CASHIER.CLG
Field Number and Name | Field Type or Mask | Possible Values |
|---|---|---|
1 Update Type * | Decimal 2.0 | 1 - Add 2 - Modify 3 - Delete 4 - Modify without overwriting 5 - Modify without overwriting 99 - Delete File |
2 Record Type | String 1 | Optional |
3 Employee Number * | String 15 | |
4 Last Name | String 15 | |
5 First Name | String 15 | |
6 Store Number | Decimal 6.0 | 1–999999 |
7 Address | String 25 | |
8 City | String 15 | |
9 State/Prov. | String 3 | |
10 Phone | String 16 | 99999999####### |
11 Social Security No. | Decimal 9.0 | |
12 Zip/Postal Code | String 6 | |
13 Discount * | Decimal 2.0 | |
14 Salesperson ID | Decimal 8.0 | |
15 Commission ID | Decimal 2.0 | |
16 Price Level | Decimal 2.0 | |
17 Employee Type | Decimal 2.0 | |
18 Employee Status | Decimal 1 | |
19 Cashier No. | Decimal 8.0 | |
20 Password | Decimal 6.0 | |
21 Auth. Level | Decimal 1 | 0 - 5 |
22 Force Preset Discount | String 1 | Y/N or 1/0 |
23 Region Number | Decimal 2.0 | |
24 Employee Short Name | String 12 | |
25 Scheduling Mode | Decimal 1.0 | 1/0 |
26 Salary | Decimal 6.2 | |
27 Hourly Pay Rate | Decimal 6.2 | |
28 Employee Profile ID | Decimal 2.0 | |
29 Upgrade Password | String 15 | |
30 Birthday | String 8 | yy/mm/dd or yyyy/mm/dd or yy-mm-dd or yyyy-mm-dd |
31 Hire Date | String 8 | yy/mm/dd or yyyy/mm/dd or yy-mm-dd or yyyy-mm-dd |
32 Perform Rating | String 5 | |
33 Increase Reason | String 5 | |
34 Status Reason | Decimal 5.0 | |
35 Last Day Worked | String 8 | yy/mm/dd or yyyy/mm/dd or yy-mm-dd or yyyy-mm-dd |
36 Eligible for Rehire | Decimal 1.0 | 1/0 |
37 Emergency Name | String 50 | |
38 Emergency Phone | String 10 | |
39 Account Number | String 30 | |
40 Bank | String 20 | |
41 Transit Number | String 5 | |
42 Gender | String 1 | M - Male F - Female |
43 Home Store Number | String 20 | |
44 Job Code | String 5 | |
45 Pay Rate Type | String 5 | |
46 Home/Borrowed | String 5 | 1 - Home 2 - Borrowed |
47 New Password Required | String 1 | Y/N |
48 Unused | ||
49 Unused | ||
50 Unused | ||
51 Language ID | Decimal 2.0 | |
52 Does employee have the option to display alternate languages | String 1 | Y/N |
53 Is employee password already hashed2 | String 1 | Y/N |
54 Allow Cash drawer assignments on multiple registers | String 1 | Y/N |