Module List >
Module UPR tables
UPR10101
You are currently viewing the COMPANY
database.
Change
|
COMPANY..UPR10101 Table Definition
(COMPANY..Payroll Year End Wage)
Field Definitions:
What is the 'source' column?
| RPTNGYR |
smallint
0
|
|
|
|
|
| MCRQGEMP |
tinyint
0
|
Medicare Q...(more) Join Now
|
|
|
|
| DEPRTMNT |
char(7)
''
|
Department...(more) Join Now
|
|
|
join ... more text available
|
| LASTNAME |
char(21)
''
|
Last Name:...(more) Join Now
|
|
|
|
| FRSTNAME |
char(15)
''
|
First Name...(more) Join Now
|
UPR00100.FRSTNAME
|
|
|
| MIDLNAME |
char(15)
''
|
|
|
|
|
| SEQNUMBR |
int
0
|
Sequence N...(more) Join Now
|
DTA10200.SEQNUMBR
|
|
|
| ADDRESS1 |
char(61)
''
|
|
|
|
|
| ADDRESS2 |
char(61)
''
|
|
|
|
|
| ADDRESS3 |
char(61)
''
|
|
|
|
|
| CITY |
char(35)
''
|
City: City...(more) Join Now
|
|
|
|
| STATE |
char(29)
''
|
|
|
|
|
| ZIPCODE |
char(11)
''
|
Zip Code: ...(more) Join Now
|
|
|
|
| Foreign_Address |
tinyint
0
|
Foreign Ad...(more) Join Now
|
|
|
|
| Foreign_StateProvince |
char(23)
''
|
Foreign
...(more) Join Now
|
|
|
|
| Foreign_Postal_Code |
char(15)
''
|
Foreign Po...(more) Join Now
|
|
|
|
| CCode |
char(7)
''
|
Country Co...(more) Join Now
|
|
|
|
| W2CTRNBR |
char(7)
''
|
|
|
|
|
| EMPLOYID |
char(15)
''
|
Employee I...(more) Join Now
|
|
|
join ... more text available
|
| SOCSCNUM |
char(15)
''
|
|
|
|
|
| W2BFSTEM |
tinyint
0
|
W2 Box for...(more) Join Now
|
|
|
|
| W2BFDCSD |
tinyint
0
|
W2 Box for...(more) Join Now
|
|
|
|
| W2BFPPLN |
tinyint
0
|
W2 Box for...(more) Join Now
|
|
|
|
| W2BFLREP |
tinyint
0
|
W2 Box for...(more) Join Now
|
|
|
|
| W2BF942E |
tinyint
0
|
W2 Box for...(more) Join Now
|
|
|
|
| W2BFSTTL |
char(1)
''
|
|
|
|
|
| W2BFDCMP |
tinyint
0
|
W2 Box for...(more) Join Now
|
|
|
|
| WGTPCOMP |
numeric(19,5)
0.00
|
|
|
|
|
| FEDITXWH |
numeric(19,5)
0.00
|
|
|
|
|
| SSECWAGS |
numeric(19,5)
0.00
|
|
|
|
|
| SSTXWHLD |
numeric(19,5)
0.00
|
|
|
|
|
| MCRWGTPS |
numeric(19,5)
0.00
|
|
|
|
|
| MDCRTXWH |
numeric(19,5)
0.00
|
|
|
|
|
| SSECTIPS |
numeric(19,5)
0.00
|
|
|
|
|
| ALOCTIPS |
numeric(19,5)
0.00
|
|
|
|
|
| ADEICPMT |
numeric(19,5)
0.00
|
|
|
|
|
| DEPCRBFT |
numeric(19,5)
0.00
|
|
|
|
|
| NQLFPLNS |
numeric(19,5)
0.00
|
|
|
|
|
| BNINCWGS |
numeric(19,5)
0.00
|
|
|
|
|
| W2FRMCTR |
int
0
|
|
|
|
|
| NOTEINDX |
numeric(19,5)
0.00
|
Note Index...(more) Join Now
|
|
|
join ... more text available
|
| STRINGARRAY_1 |
char(31)
''
|
|
|
|
|
| STRINGARRAY_2 |
char(31)
''
|
|
|
|
|
| STRINGARRAY_3 |
char(31)
''
|
|
|
|
|
| STRINGARRAY_4 |
char(31)
''
|
|
|
|
|
| STRINGARRAY_5 |
char(31)
''
|
|
|
|
|
| LONGINTARRAY_1 |
int
0
|
|
|
|
|
| LONGINTARRAY_2 |
int
0
|
|
|
|
|
| LONGINTARRAY_3 |
int
0
|
|
|
|
|
| LONGINTARRAY_4 |
int
0
|
|
|
|
|
| LONGINTARRAY_5 |
int
0
|
|
|
|
|
| EMPLSUFF |
char(5)
''
|
|
|
|
|
| ESSW2PRINTED |
tinyint
0
|
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|
|