Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Tab Position (.txt file)Excel Column (.csv file)Field NameStorage TypeKeyableStorage

1

A

*Employee ID

String

15

16

2

B

*Pay Record (Pay Code)

String

6

8

3

C

Employee Class

String

15

16

4

D

Inactive

Check Boxcheckbox

1

2

5

E

*Last Name

String

20

22

6

F

*First Name

String

15

16

7

G

Middle Name

String

15

16

8

H

Address 1

String

30

32

9

I

Address 2

String

30

32

10

J

City

String

30

32

11

K

State

String

4

30

12

L

Country

String

20

22

13

M

Zip Code

String

10

12

14

N

Phone Number

String

14

22

15

O

*Social Security Number

String

15

16

16

P

Birth Date

Date

6

4

17

Q

Gender

Drop-Down List
1 = Male
2 = Female

6

2

18

R

Ethnic Origin

Drop-Down List
1 = Caucasian
2 = Native American
3 = Black
4 = Asian
5 = Hispanic
6 = Other

15

2

19

S

Part Time

Check Boxcheckbox

1

2

20

T

*Department

String

6

8

21

U

*Job Title

String

6

8

22

V

Which Cash Account For Pay

Radio Group

0

2

23

W

Account Index

Long Integer

14

4

24

X

*Work Hours Per Year

Integer

4

2

25

Y

Start Date

Date

6

4

26

Z

Date Employee Inactivated

Date

8

4

27

AA

Reason Employee Inactivated

String

30

32

28

AB

Minimum Net Pay

Currency

14

10

29

AC

Suta State

String

2

4

30

AD

Workers Comp

String

6

8

31

AE

Auto Accrue Vacation

Check Boxcheckbox

16

2

32

AF

Vacation Accrual Amount

Long Integer

6

4

33

AG

Vacation Accrual Method

Radio Group

0

2

34

AH

Vacation Hours Per Year

Long Integer

6

4

35

AI

Vacation Available

Long Integer

6

4

36

AJ

Auto Accrue Sick Time

Check Boxcheckbox

1

2

37

AK

Sick Time Accrual Method

Radio Group

0

2

38

AL

Sick Time Accrual Amount

Long Integer

6

4

39

AM

Sick Time Available

Long Integer

6

4

40

AN

Sick Time Hours Per Year

Long Integer

6

4

41

AO

User Defined 1

String

20

22

42

AP

User Defined 2

String

20

22

43

AQ

Note Index

Currency

14

10

44

AR

*Pay Type

Drop-Down List
1 = Hourly
2 = Salary
3 = Piecework
4 = Commission
5 = Business Expense
6 = Overtime
7 = Double Time
8 = Vacation
9 = Sick
10 = Holiday
11 = Pension
12 = Other
13 = Earned Inc. Credit
14 = Charged Tips
15 = Reported Tips
16 = Min. Wage Bal.

20

2

45

AS

Base Pay Record

String

6

8

46

AT

*Pay Rate Amount

Currency

14

10

47

AU

Pay Unit

String

25

26

48

AV

Pay Unit Period

Drop-Down List
1 = Weekly
2 = Biweekly
3 = Semimonthly
4 = Monthly
5 = Quarterly
6 = Semiannually
7 = Annually
8 = Daily/Misc.

19

2

49

AW

Report As Wages

Check Boxcheckbox

1

2

50

AX

Taxable

Check Boxcheckbox

1

2

51

AY

Subject To Federal Tax

Check Boxcheckbox

1

2

52

AZ

Subject To Social Security

Check Boxcheckbox

1

2

53

BA

Subject To Medicare

Check Boxcheckbox

1

2

54

BB

Subject To State Tax

Check Boxcheckbox

1

2

55

BC

Subject To Local Tax

Check Boxcheckbox

1

2

56

BD

Subject To Futa

Check Boxcheckbox

1

2

57

BE

Subject To Suta

Check Boxcheckbox

1

2

58

BF

Flat Federal Tax Rate

Integer

4

2

59

BG

Flat State Tax Rate

Integer

4

2

60

BH

Pay Period

Drop-Down List
1 = Weekly
2 = Biweekly
3 = Semimonthly
4 = Monthly
5 = Quarterly
6 = Semiannually
7 = Annually
8 = Daily/Misc.

19

2

61

BI

Pay Per Period

Currency

14

10

62

BJ

Max Pay Per Period

Currency

14

10

63

BK

Pay Advance

Currency

14

10

64

BL

Accrue Vacation

Check Boxcheckbox

1

2

65

BM

Accrue Sick Time

Check Boxcheckbox

1

2

66

BN

W2 Box Number

Integer

2

2

67

BO

W2 Box Label

String

6

8

68

BP

Pay Advance Taken

Currency

14

10

69-80

BQ-CB

MTD Hours

Long Integer

6

4

81-92

CC-CN

MTD Wages

Currency

14

10

93

CO

Technician

String

10

12

94

CP

**Technician Team

String

15

16

95

CQ

Vendor Switch

Check Boxcheckbox

1

2

96

CR

Vendor ID

String

15

16

97

CS

**Branch Name

String

40

42