| EMPLOYID |
char(15)
''
|
Employee I...(more) Join Now
|
|
|
join ... more text available
|
| EMPLCLAS |
char(15)
''
|
|
|
|
join ... more text available
|
| INACTIVE |
tinyint
0
|
|
|
|
|
| LASTNAME |
char(21)
''
|
Last Name:...(more) Join Now
|
|
|
|
| FRSTNAME |
char(15)
''
|
First Name...(more) Join Now
|
UPR00100.FRSTNAME
|
|
|
| MIDLNAME |
char(15)
''
|
|
|
|
|
| ADRSCODE |
char(15)
''
|
Address Co...(more) Join Now
|
|
|
|
| SOCSCNUM |
char(15)
''
|
|
|
|
|
| BRTHDATE |
datetime
'1/1/1900'
|
|
|
|
|
| GENDER |
smallint
0
|
|
|
|
|
| ETHNORGN |
smallint
0
|
|
|
|
|
| Calc_Min_Wage_Bal |
tinyint
0
|
Calc Min W...(more) Join Now
|
UPR00100.Calc_Min_Wage_Bal
|
|
|
| DIVISIONCODE_I |
char(7)
''
|
*Division:...(more) Join Now
|
UPR00100.DIVISIONCODE_I
|
|
|
| DEPRTMNT |
char(7)
''
|
Department...(more) Join Now
|
|
|
join ... more text available
|
| JOBTITLE |
char(7)
''
|
|
|
|
|
| SUPERVISORCODE_I |
char(7)
''
|
Supervisor...(more) Join Now
|
UPR00100.SUPERVISORCODE_I
|
|
|
| LOCATNID |
char(15)
''
|
Location I...(more) Join Now
|
|
|
join ... more text available
|
| WCACFPAY |
smallint
0
|
Which Cash...(more) Join Now
|
UPR00100.WCACFPAY
|
|
|
| ACTINDX |
int
0
|
Account In...(more) Join Now
|
|
|
join ... more text available
|
| WKHRPRYR |
smallint
0
|
Work Hours...(more) Join Now
|
UPR00100.WKHRPRYR
|
|
|
| STRTDATE |
datetime
'1/1/1900'
|
Start Date...(more) Join Now
|
UPR00100.STRTDATE
|
|
|
| DEMPINAC |
datetime
'1/1/1900'
|
Date Emplo...(more) Join Now
|
UPR00100.DEMPINAC
|
|
|
| RSNEMPIN |
char(31)
''
|
Reason Emp...(more) Join Now
|
UPR00100.RSNEMPIN
|
|
|
| MINETPAY |
numeric(19,5)
0.00
|
Minimum Ne...(more) Join Now
|
|
|
|
| SUTASTAT |
char(3)
''
|
Suta State...(more) Join Now
|
|
|
|
| WRKRCOMP |
char(7)
''
|
Workers Co...(more) Join Now
|
|
|
|
| ATACRVAC |
tinyint
0
|
Auto Accru...(more) Join Now
|
UPR00100.ATACRVAC
|
|
|
| VACCRAMT |
int
0
|
Vacation A...(more) Join Now
|
UPR00100.VACCRAMT
|
|
|
| VACCRMTH |
smallint
0
|
Vacation A...(more) Join Now
|
UPR00100.VACCRMTH
|
|
|
| VACAPRYR |
int
0
|
Vacation H...(more) Join Now
|
UPR00100.VACAPRYR
|
|
|
| VACAVLBL |
int
0
|
Vacation A...(more) Join Now
|
UPR00100.VACAVLBL
|
|
|
| WRNVCNFLSBLWZR |
tinyint
0
|
Warn Vacat...(more) Join Now
|
UPR00100.WRNVCNFLSBLWZR
|
|
|
| ATACRSTM |
tinyint
0
|
Auto Accru...(more) Join Now
|
UPR00100.ATACRSTM
|
|
|
| STMACMTH |
smallint
0
|
Sick Time ...(more) Join Now
|
UPR00100.STMACMTH
|
|
|
| SKTMACAM |
int
0
|
Sick Time ...(more) Join Now
|
UPR00100.SKTMACAM
|
|
|
| SIKTIMAV |
int
0
|
Sick Time ...(more) Join Now
|
UPR00100.SIKTIMAV
|
|
|
| SKTMHPYR |
int
0
|
Sick Time ...(more) Join Now
|
UPR00100.SKTMHPYR
|
|
|
| WRNSTFLSBLWZR |
tinyint
0
|
Warn Sick ...(more) Join Now
|
UPR00100.WRNSTFLSBLWZR
|
|
|
| USERDEF1 |
char(21)
''
|
UserDefine...(more) Join Now
|
CM20200.USERDEF1
|
|
|
| USERDEF2 |
char(21)
''
|
UserDefine...(more) Join Now
|
CM20200.USERDEF2
|
|
|
| EMPLOYMENTTYPE |
smallint
0
|
Type of Em...(more) Join Now
|
UPR00100.EMPLOYMENTTYPE
|
|
|
| MARITALSTATUS |
smallint
0
|
|
|
|
|
| BENADJDATE |
datetime
'1/1/1900'
|
*Ben Adj D...(more) Join Now
|
UPR00100.BENADJDATE
|
|
|
| LASTDAYWORKED_I |
datetime
'1/1/1900'
|
Last Day W...(more) Join Now
|
UPR00100.LASTDAYWORKED_I
|
|
|
| BIRTHDAY |
smallint
0
|
*Birth Day...(more) Join Now
|
UPR00100.BIRTHDAY
|
|
|
| BIRTHMONTH |
smallint
0
|
*Birth Mon...(more) Join Now
|
UPR00100.BIRTHMONTH
|
|
|
| SPOUSE |
char(15)
''
|
|
|
|
|
| SPOUSESSN |
char(15)
''
|
Spouse SSN...(more) Join Now
|
UPR00100.SPOUSESSN
|
|
|
| NICKNAME |
char(21)
''
|
|
|
|
|
| ALTERNATENAME |
char(21)
''
|
Alternate ...(more) Join Now
|
UPR00100.ALTERNATENAME
|
|
|
| HRSTATUS |
smallint
0
|
HR Status:...(more) Join Now
|
|
|
|
| DATEOFLASTREVIEW_I |
datetime
'1/1/1900'
|
*Date Of
...(more) Join Now
|
UPR00100.DATEOFLASTREVIEW_I
|
|
|
| DATEOFNEXTREVIEW_I |
datetime
'1/1/1900'
|
*Date Of
...(more) Join Now
|
UPR00100.DATEOFNEXTREVIEW_I
|
|
|
| BENEFITEXPIRE_I |
datetime
'1/1/1900'
|
*Benefit E...(more) Join Now
|
UPR00100.BENEFITEXPIRE_I
|
|
|
| HANDICAPPED |
tinyint
0
|
*Handicapp...(more) Join Now
|
UPR00100.HANDICAPPED
|
|
|
| VETERAN |
tinyint
0
|
*Veteran: ...(more) Join Now
|
UPR00100.VETERAN
|
|
|
| VIETNAMVETERAN |
tinyint
0
|
*Vietnam V...(more) Join Now
|
UPR00100.VIETNAMVETERAN
|
|
|
| DISABLEDVETERAN |
tinyint
0
|
*Disabled ...(more) Join Now
|
UPR00100.DISABLEDVETERAN
|
|
|
| UNIONEMPLOYEE |
tinyint
0
|
*Union Emp...(more) Join Now
|
UPR00100.UNIONEMPLOYEE
|
|
|
| SMOKER_I |
tinyint
0
|
*Smoker: ...(more) Join Now
|
UPR00100.SMOKER_I
|
|
|
| CITIZEN |
tinyint
0
|
*Citizen: ...(more) Join Now
|
UPR00100.CITIZEN
|
|
|
| VERIFIED |
tinyint
0
|
*Verified:...(more) Join Now
|
UPR00100.VERIFIED
|
|
|
| I9RENEW |
datetime
'1/1/1900'
|
*I9renew: ...(more) Join Now
|
UPR00100.I9RENEW
|
|
|
| Primary_Pay_Record |
char(7)
''
|
Primary Pa...(more) Join Now
|
UPR00100.Primary_Pay_Record
|
|
join ... more text available
|
| CHANGEBY_I |
char(15)
''
|
*Change By...(more) Join Now
|
|
|
|
| CHANGEDATE_I |
datetime
'1/1/1900'
|
*Change Da...(more) Join Now
|
UPR00100.CHANGEDATE_I
|
|
|
| NOTEINDX |
numeric(19,5)
0.00
|
Note Index...(more) Join Now
|
|
|
join ... more text available
|
| NOTEINDX2 |
numeric(19,5)
0.00
|
Note Index...(more) Join Now
|
|
|
|
| UNIONCD |
char(7)
''
|
Union Code...(more) Join Now
|
UPR00100.UNIONCD
|
|
|
| RATECLSS |
char(15)
''
|
Rate Class...(more) Join Now
|
UPR00100.RATECLSS
|
|
|
| FEDCLSSCD |
char(11)
''
|
Federal
...(more) Join Now
|
UPR00100.FEDCLSSCD
|
|
|
| OTHERVET |
tinyint
0
|
Other Vete...(more) Join Now
|
UPR00100.OTHERVET
|
|
|
| Military_Discharge_Date |
datetime
'1/1/1900'
|
Military
...(more) Join Now
|
UPR00100.Military_Discharge_Date
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|
| EMPLSUFF |
char(5)
''
|
|
|
|
|
| STATUSCD |
char(15)
''
|
|
|
|
|
| AFSMVET |
tinyint
0
|
|
|
|
|
| RECSEPVET |
tinyint
0
|
|
|
|
|