Importing Employee Information
The following tables show examples of data fields used in the Employee Information section of the MasterPR.DEF file:
Header
| Table: tblPREE | ||||
|---|---|---|---|---|
| Context Section: CONTEXT,EMPLOYEE,HEADER,HEMPINF | ||||
| Field ID | Req'd | Field Length | Default Value | Notes |
|
EMP_EMPID |
Y |
User Defined |
Employee ID |
|
|
EMP_STATUS |
N |
1 |
A |
A (Active), I (Inactive), or D (Discontinued) |
|
EMP_LASTNAME |
Y |
User Defined |
Employee Last Name |
|
|
EMP_FIRSTNAME |
Y |
User Defined |
Employee First Name |
|
|
EMP_MI |
N |
1 |
Employee Middle Initial |
|
|
EMP_SSN |
Y |
11 |
Employee Social Security Number Format: |
|
|
EMP_I9 |
N |
2 |
No |
I-9 on File: 0 = No; 1 = Yes |
|
EMP_CITIZENSHIP |
N |
25 |
Employee Citizenship |
|
|
EMP_ |
N |
25 |
Employee Marital Status |
|
|
EMP_GENDER |
N |
2 |
Employee Gender: Female (F) or Male (M) |
|
|
EMP_ETHNICITY |
N |
25 |
Employee Ethnicity |
|
|
EMP_WORKPHONE |
N |
21 |
Employee Work Phone Format: |
|
| EMP_USERID_GUID | N | See Notes for format. | The system user ID that is associated with the employee ID. A blank GUID format: {00000000-0000-0000-0000-000000000000} | |
|
EMP_HIRED |
N |
Date |
Current Date |
Can be 6, 8, or 10 digit date. |
|
EMP_ACTION |
N |
Date |
Can be 6, 8, or 10 digit date. |
|
|
EMP_ |
N |
Date |
Can be 6, 8, or 10 digit date. |
|
|
EMP_TERMINATED |
N |
Date |
Can be 6, 8, or 10 digit date. |
|
|
EMP_BIRTHDATE |
N |
Date |
Can be 6, 8, or 10 digit date. |
|
|
EMP_ADDRESS |
N |
80 |
Employee Address. Use "^" to separate address lines. |
|
|
EMP_CITY |
N |
30 |
Employee City |
|
|
EMP_STATE |
N |
2 |
Employee State |
|
|
EMP_ZIP |
N |
10 |
Employee ZIP. 9 digit zip code must include dash after 5th number. |
|
| EMP_ZIP | N | 47 | Employee Country | |
|
EMP_VOICE |
N |
21 |
Employee Phone Format: |
|
|
EMP_FAX |
N |
21 |
Employee Fax Format: (xxx) xxx-xxxx. Dashes required. |
|
|
EMP_EREMAIL |
N |
60 |
Employee personal or home email address |
|
|
EMP_ECNAME |
N |
30 |
Emergency Contact Name |
|
|
EMP_ECPHONE |
N |
21 |
Emergency Contact Phone Format: (xxx) xxx-xxxx |
|
|
EMP_ECRELATION |
N |
20 |
Emergency Contact's Relationship to Employee |
|
|
EMP_ECEMAIL |
N |
60 |
The emergency contact's email address |
|
|
EMP_PROCGROUP |
Y |
User Defined |
Must be set up using Maintain>Payroll>Processing Groups. |
|
|
EMP_CLASS |
N |
User Defined |
Optional Class Designation |
|
|
EMP_POSITION |
N |
User Defined |
Optional Position Designation |
|
|
EMP_EMPTYPE |
N |
25 |
Employee Type |
|
|
EMP_ |
N |
25 |
Military Status |
|
| EMP_OCCUPATION | N | 10 | Occupational Code | |
|
EMP_LICENSENUM |
N |
15 |
Drivers License Number |
|
|
EMP_DLSTATE |
N |
2 |
Any existing state code |
|
|
EMP_DLEXPIRATION |
N |
Date |
Drivers License Expiration Date. Can be 6, 8, or 10 digit date. |
|
|
EMP_DLCLASS |
N |
25 |
Drivers License Class |
|
|
EMP_SALARIED_ |
Y |
1 |
S |
S (Salaried) or H (Hourly) |
|
EMP_SALARY |
Y |
Currency |
Salary per Pay Cycle. Required if salaried. |
|
|
EMP_HRLYRATE |
Y |
Single |
Hourly Rate. Required if hourly. |
|
|
EMP_EQ_HOURLY_ |
Y |
20 |
Equivalent Hourly Rate for Calculations. Required if Salary. |
|
|
EMP_ |
N |
2 |
Direct Deposit: 0 = No; 1 = Yes |
|
|
EMP_DISABLE_ |
N |
2 |
No |
Disable Pre-note: 0 = No; 1 = Yes |
|
EMP_FITMARSTS |
Y |
1 |
S |
Federal filing status. S (Single), M (Married), H (Head of Household) |
|
EMP_FITEXEMPT |
N |
2 |
0 |
Federal exemptions claimed |
|
EMP_FITADDLWH |
N |
Currency |
0.00 |
Additional Federal Withholding |
| EMP_FITNONRESALIEN | N | 1 | Nonresident Alien Status. 0 = No; 1 = Yes | |
| EMP_FIT24PRIOR2020 | N | 1 | W-4 completed prior to 2020. 0 = No; 1 = Yes | |
| EMP_FITEXEMPTSTATUS | N | 1 | Tax Exempt Status. 0 = No; 1 = Yes | |
| EMP_FITMULTIPLEJOBS | N | 1 | Multiple Jobs. 0 = No; 1 = Yes | |
| EMP_FITDEPENDENTAMT | N | Currency | 0.00 | Dependent Amount |
| EMP_FITOTHERINCOMEAMT | N | Currency | 0.00 | Other Income Amount |
| EMP_FITDEDUCTIONAMT | N | Currency | 0.00 | Deductions Amount |
| EMP_FITADDLWH2020 | N | Currency | 0.00 | Additional Federal Withholding |
| EMP_1095 | N | 2 | N | Issue Electronic Form 1095: 0 = No; 1 = Yes |
|
EMP_EIC |
N |
1 |
N |
EIC status. N (None), M (Married with Both Filing), or S (Single/Married with One Filing) |
|
EMP_SUTA |
N |
2 |
State unemployment state. Two digit state postal abbreviation. |
|
|
EMP_SWT |
N |
2 |
State withholding tax. Two digit state postal abbreviation. |
|
|
EMP_SWTADDLWH |
N |
Currency |
0.00 |
Additional state withholding |
|
EMP_ |
N |
2 |
State filing status. Required for some states. |
|
|
EMP_ |
N |
2 |
State exemptions claimed. Required for some states. |
|
|
EMP_ |
N |
2 |
State deductions claimed. Required for some states. |
|
|
EMP_SWTCREDITS |
N |
State Withholding Tax Credits |
||
|
EMP_ |
N |
Allowances for Deductions |
||
|
EMP_ |
N |
11 |
Spouse Social Security Number Format: xxx-xx-xxxx |
|
|
EMP_MQGE |
N |
2 |
No |
Medicare Qualified Government Employee. 0 = No; 1 = Yes |
|
EMP_STATUTORY |
N |
2 |
No |
W-2 Box check box—Statutory Employee. 0 = No; 1 = Yes |
|
EMP_ |
N |
2 |
No |
W-2 Box check box—Retirement Plan. 0 = No; 1 = Yes |
|
EMP_3RDPARTY_ |
N |
2 |
No |
W-2 Box check box—3rd Party Sick Pay. 0 = No; 1 = Yes |
|
EMP_EFILEW2 |
N |
2 |
No |
Issue employee W-2 electronically through Aatrix ® check box. 0 = No; 1 = Yes |
|
EMP_EFEMAIL |
N |
60 |
The Electronic W-2 email address |
|
| VOUCHER_PAPER | N | 1 | 1 | Print Paper Voucher: 0 = No; 1 = Yes |
| VOUCHER_EMAIL | N | 1 | 0 | Email Voucher: 0 = No; 1 = Yes |
| VOUCHER_EMAILADDR | Y* | 255 | 0 | Voucher Email Address. *Required if VOUCHER_EMAIL is Yes. Must be in email format. |
| VOUCHER_EMAILTEMPLATE | Y | 30 | <Default> | Voucher Process Template. Required if VOUCHER_EMAIL is Yes; otherwise <Default> displays. |
|
EMP_NOTES |
N |
Notes |
||
Direct Deposit Detail
| Table: tblPREEDirectDep | ||||
|---|---|---|---|---|
| Context Section: CONTEXT,EMPLOYEE,DETAIL,DEMPINF | ||||
| Field ID | Req'd | Field Length | Default Value | Notes |
|
MTNEMP_ROUTING |
Y |
9 |
9 digit Bank Routing Number |
|
|
MTNEMP_ACCNUM |
Y |
17 |
Employee's Checking or Savings account number |
|
|
MTNEMP_PERC |
Y |
Single |
000.0000 |
Percentage of net pay. All percentages must total 100%. Enter 5% as 05 or 5. |
|
MTNEMP_AMOUNT |
N |
Currency |
0.00 |
An exact dollar amount to be deposited into an account. |
|
MTNEMP_TYPE |
Y |
2 |
Direct Deposit Type: 22 for checking and 32 for savings. Required if direct deposit is selected and if Direct Deposit is installed. |
|
Employee Other Taxes Detail
| Table: tblPREEOtherTaxCode | ||||
|---|---|---|---|---|
| Context Section: CONTEXT,EMPLOYEE,DETAIL,DEMPOT | ||||
| Field ID | Req'd | Field Length | Default Value | Notes |
|
PRMTN_GRID |
N |
User Defined |
Other Taxes Employee Paid Tax code. Must be set up using Maintain>Payroll>Other Taxes. |
|
|
PRMTN_GRID |
N |
Currency |
0.00 |
Additional other taxes to withhold form each paycheck. |
Other Taxes Exemptions Detail
| Table: tblPREELocalTaxExempt | ||||
|---|---|---|---|---|
| Context Section: CONTEXT,EMPLOYEE,DETAIL,DEMPEMPT | ||||
| Field ID | Req'd | Field Length | Default Value | Notes |
|
PRMTN_GRID |
N |
User Defined |
Employee Other Taxes Exemptions/Deductions code. |
|
|
PRMTN_GRID |
N |
2 |
|
Employee Other Taxes Exemptions/Deductions claimed. Required if PRMTN_GRID_OCEXEMPT_CODE is selected. |