EMPLOYID

string

15

Y

Not applicable

Employee ID

EMPLCLAS

string

15

N

<blank>

Employee class

INACTIVE

i4

1

N

0

Inactive: 0=False; 1=True

LASTNAME

string

20

Y

Not applicable

Last name

FRSTNAME

string

15

Y

Not applicable

First name

MIDLNAME

string

15

N

<blank>

Middle name

EMPLSUFF

string

4

N

<blank>

Employee suffix

ADRSCODE

string

15

N

<blank>

Address code

ADDRESS1

string

30

N

<blank>

Address code 1

ADDRESS2

string

30

N

<blank>

Address code 2

ADDRESS3

string

30

N

<blank>

Address code 3

CITY

string

30

N

<blank>

City

STATE

string

29

N

<blank>

State

ZIPCODE

string

10

N

<blank>

ZIP Code

COUNTY

string

20

N

<blank>

County

COUNTRY

string

20

N

<blank>

Country

PHONE1

string

21

N

<blank>

Phone number 1

PHONE2

string

21

N

<blank>

Phone number 2

PHONE3

string

21

N

<blank>

Phone number 3

FAX

string

21

N

<blank>

Fax number

SOCSCNUM

string

15

Y

Not applicable

Social Security number

BRTHDATE

datetime

16

N

<blank>

Birth date

GENDER

i4

2

N

3

Gender:

1=Male;

2=Female;

3=Not applicable

ETHNORGN

i4

2

N

7

Ethnic origin:

1=White;

2=Native American or Alaskan Native;

3=Black or African American;

4=Asian;

5=Hispanic or Latino;

6=Two or more races;

7=Not applicable;

8=Native Hawaiian or Pacific Islander

Calc_Min_Wage_Bal

i4

1

N

Default from setup

Calculate minimum wage balance:

0=False;

1=True

DIVISIONCODE_I

string

6

N

<blank>

Division code; HR option only

DEPRTMNT

string

6

Y

Not applicable

Department

JOBTITLE

string

6

Y

Not applicable

Job title/position

SUPERVISORCODE_I

string

6

N

<blank>

Supervisor Code

LOCATNID

string

15

N

<blank>

Location ID

WCACFPAY

i4

2

N

0

Cash account from:

0=Checkbook;

1=Employee

AccountNumber

string

75

N

<blank>

Account number

WKHRPRYR

i4

2

N

0

Work hours per year

STRTDATE

datetime

16

N

<blank>

Start date

DEMPINAC

datetime

16

N

<blank>

Date employee inactivated; this field is active if INACTIVE=1

RSNEMPIN

string

30

N

<blank>

Reason employee inactivated; this field is active if INACTIVE=1

MINETPAY

number

21

N

Default from setup

Minimum net pay

SUTASTAT

string

2

N

<blank>

SUTA state

WRKRCOMP

string

6

N

<blank>

Workers' compensation code

ATACRVAC

i4

1

N

Default from setup

Auto accrue vacation: 0=False; 1=True

VACCRAMT

number

21

N

Default from setup

Vacation accrual amount

VACCRMTH

i4

2

N

Default from setup

Vacation accrual method: 0=Hours worked; 1=Set hours

VACAPRYR

number

21

N

Default from setup

Vacation hours per year

VACAVLBL

number

21

N

Default from setup

Vacation available

WRNVCNFLSBLWZR

i4

1

N

Default from setup

Warn if vacation falls below zero:

0=False;

1=True

ATACRSTM

i4

1

N

<blank>

Auto accrue sick time:

0=False

1=True

STMACMTH

i4

2

N

0

Sick Time Accrual Method:

0=Hours worked

1=Set hours

SKTMACAM

number

21

N

<blank>

Sick time accrual amount

SIKTIMAV

number

21

N

<blank>

Sick time available

SKTMHPYR

number

21

N

<blank>

Sick time hours per year

WRNSTFLSBLWZR

i4

1

N

<blank>

Warn sick time falls below zero

0=False

1=True

USERDEF1

string

20

N

<blank>

User defined 1

USERDEF2

string

20

N

<blank>

User defined 2

EMPLOYMENTTYPE

i4

2

N

Default from setup

Type of employment:

1=Full-time regular;

2=Full-time temporary;

3=Part-time regular;

4=Part-time temporary;

5=Intern;

6=Other

MARITALSTATUS

i4

2

N

3

Marital status:

1=Married;

2=Single;

3=Not applicable

BENADJDATE

datetime

16

N

<blank>

Benefit adjustment date

LASTDAYWORKED_I

datetime

16

N

<blank>

Last day worked

BIRTHDAY

i4

2

N

0

Birthday

BIRTHMONTH

i4

2

N

0

Birth month:

1=January;

2=February;

3=March;

4=April;

5=May;

6=June;

7=July;

8=August;

9=September;

10=October;

11=November;

12=December

SPOUSE

string

15

N

<blank>

Spouse

SPOUSESSN

string

15

N

<blank>

Spouse Social Security number

NICKNAME

string

20

N

<blank>

Nickname

ALTERNATENAME

string

20

N

<blank>

Alternate name

STATUSCD

string

15

N

<blank>

Status code

HRSTATUS

i4

2

N

1

HR Status; HR option only:

1=Active;

2=Family leave;

3=Leave of absence;

4=Maternity;

5=Other;

6=Retired;

7=Separated;

8=Suspended;

9=Terminated

DATEOFLASTREVIEW_I

datetime

16

N

<blank>

Date of last review; HR option only

DATEOFNEXTREVIEW_I

datetime

16

N

<blank>

Date of next review; HR option only

BENEFITEXPIRE_I

datetime

16

N

<blank>

Benefit expire

HANDICAPPED

i4

1

N

0

Handicapped; HR option only:

0=False;

1=True

VETERAN

i4

1

N

0

Veteran; HR option only:

0=False;

1=True

VIETNAMVETERAN

i4

1

N

0

Vietnam veteran; HR option only:

0=False;

1=True

DISABLEDVETERAN

i4

1

N

0

Disabled veteran; HR option only:

0=False;

1=True

UNIONEMPLOYEE

i4

1

N

0

Union employee; HR option only:

0=False;

1=True

SMOKER_I

i4

1

N

0

Smoker; HR option only:

0=False;

1=True

CITIZEN

i4

1

N

0

Citizen; HR option only:

0=False;

1=True

VERIFIED

i4

1

N

0

Verified; HR option only:

0=False;

1=True

I9RENEW

datetime

16

N

<blank>

I9 renew; HR option only

Primary_Pay_Record

string

6

N

<blank>

Primary pay record; HR option only

CHANGEBY_I

string

15

N

<blank>

Change by; HR option only

CHANGEDATE_I

datetime

16

N

<blank>

Change date; HR option only

UNIONCD

string

6

N

<blank>

Union code; HR option only

RATECLSS

string

15

N

<blank>

Rate class; HR option only

FEDCLSSCD

string

10

N

<blank>

Federal class; HR option only

OTHERVET

i4

1

N

0

Other veterans; HR option only

Military_Discharge_Date

datetime

16

N

<blank>

Military discharge date; HR option only

DefaultFromClass

i4

1

N

1

Default information from class:

0=False;

1=True

UpdateIfExists

i4

1

N

1

Flag to allow customer data to be updated if it exists:

0=No;

1=Yes

RequesterTrx

i4

2

N

0

Requester transaction

0=False;

1=True (if True, it populates the requester shadow table)

USRDEFND1

string

50

N

<blank>

User-defined field—developer use only

USRDEFND2

string

50

N

<blank>

User-defined field—developer use only

USRDEFND3

string

50

N

<blank>

User-defined field—developer use only

USRDEFND4

string

8000

N

<blank>

User-defined field—developer use only

USRDEFND5

string

8000

N

<blank>

User-defined field—developer use only