BACHNUMB

string

15

Y

Not applicable

Batch number

EMPLOYID

string

15

Y

Not applicable

Employee ID

COMPTRTP

i4

2

N

1

Computer transaction type:

1=Pay code;

2=Deduction;

3=Benefit

SALCHG

i4

2

N

0

Salary change; required if passing a salary pay code:

1=Reallocate dollars;

2=Reallocate hours;

3=Reduce dollars;

4=Reduce hours;

5=Additional amount

UPRTRXCD

string

6

Y

Not applicable

UPR transaction code

TRXBEGDT

datetime

16

N

<blank>

Transaction begin date

TRXENDDT

datetime

16

N

<blank>

Transaction end date

TRXHRUNT

number

21

N

0

Transaction hours/units; required if the pay code passed is:

1=Salary with a salary change of reallocated hours;

2=Salary with a salary change of reduced hours;

3=Piecework;

4=Overtime;

5=Double time;

6=Vacation;

7=Sick;

8=Holiday;

9=Minimum wage balance

HRLYPYRT

number

21

N

0

Hourly pay rate

PAYRTAMT

number

21

N

0

Pay rate amount; required if passing the pay code:

1=Salary with a salary change of reallocated dollars;

2=Salary with a salary change of reduced dollars;

3=Salary with a salary change of additional amount;

4=Charged tips;

5=Reported tips

VARDBAMT

number

21

N

0

Variable deduction/benefit amount

VARDBPCT

number

21

N

0

Variable deduction/benefit percent

RECEIPTS

number

21

N

0

Receipts

DAYSWRDK

number

21

N

0

Days worked

WKSWRKD

number

21

N

0

Weeks worked

DEPRTMNT

string

6

N

<blank>

Department; if empty, pulls from UPR00100

JOBTITLE

string

6

N

<blank>

Job title/position code; if empty, pulls from UPR00100

STATECD

string

2

N

<blank>

State code

LOCALTAX

string

6

N

<blank>

Local tax

SUTASTAT

string

2

N

<blank>

SUTA state

WRKRCOMP

string

6

N

<blank>

Workers' compensation code

SHFTCODE

string

6

N

<blank>

Shift code

SHFTPREM

number

21

N

0

Shift premium

RequesterTrx

i4

2

N

0

Requester transaction

0=False;

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

USERID

string

15

N

<blank>

User ID

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>

Use-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