Ask Learn
Preview
Please sign in to use this experience.
Sign inThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Element name |
Data type |
Length |
Required |
Default |
Description |
---|---|---|---|---|---|
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 |
Please sign in to use this experience.
Sign in