| EMPLOYID |
char(15)
''
|
Employee I...(more) Join Now
|
|
|
|
| EMPLCLAS |
char(15)
''
|
Employee C...(more) Join Now
|
|
|
join ... more text available
|
| INACTIVE |
tinyint
0
|
Set to 1 t...(more) Join Now
|
|
|
|
| LASTNAME |
char(21)
''
|
Last Name:...(more) Join Now
|
|
|
|
| FRSTNAME |
char(15)
''
|
First Name...(more) Join Now
|
|
|
|
| MIDLNAME |
char(15)
''
|
(Optional)...(more) Join Now
|
|
|
|
| ADRSCODE |
char(15)
''
|
Address Co...(more) Join Now
|
|
|
|
| SOCSCNUM |
char(15)
''
|
(Required ...(more) Join Now
|
|
|
|
| BRTHDATE |
datetime
'1/1/1900'
|
(Optional)...(more) Join Now
|
|
|
|
| GENDER |
smallint
0
|
Genderbr /...(more) Join Now
|
|
|
|
| ETHNORGN |
smallint
0
|
This field...(more) Join Now
|
|
|
|
| Calc_Min_Wage_Bal |
tinyint
0
|
Calc Min W...(more) Join Now
|
|
|
|
| DIVISIONCODE_I |
char(7)
''
|
*Division:...(more) Join Now
|
|
|
|
| DEPRTMNT |
char(7)
''
|
Department...(more) Join Now
|
|
|
join ... more text available
|
| JOBTITLE |
char(7)
''
|
|
|
|
|
| SUPERVISORCODE_I |
char(7)
''
|
Supervisor...(more) Join Now
|
|
|
|
| LOCATNID |
char(15)
''
|
|
|
|
join ... more text available
|
| WCACFPAY |
smallint
0
|
Which Cash...(more) Join Now
|
|
|
|
| ACTINDX |
int
0
|
Account In...(more) Join Now
|
|
|
join ... more text available
|
| WKHRPRYR |
smallint
0
|
Work Hours...(more) Join Now
|
|
|
|
| STRTDATE |
datetime
'1/1/1900'
|
Start Date...(more) Join Now
|
|
|
|
| DEMPINAC |
datetime
'1/1/1900'
|
Date Emplo...(more) Join Now
|
|
|
|
| RSNEMPIN |
char(31)
''
|
Reason Emp...(more) Join Now
|
|
|
|
| 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
|
|
|
|
| VACCRAMT |
int
0
|
Vacation A...(more) Join Now
|
|
|
|
| VACCRMTH |
smallint
0
|
Vacation A...(more) Join Now
|
|
|
|
| VACAPRYR |
int
0
|
Vacation H...(more) Join Now
|
|
|
|
| VACAVLBL |
int
0
|
Vacation A...(more) Join Now
|
|
|
|
| WRNVCNFLSBLWZR |
tinyint
0
|
Warn Vacat...(more) Join Now
|
|
|
|
| ATACRSTM |
tinyint
0
|
Auto Accru...(more) Join Now
|
|
|
|
| STMACMTH |
smallint
0
|
Sick Time ...(more) Join Now
|
|
|
|
| SKTMACAM |
int
0
|
Sick Time ...(more) Join Now
|
|
|
|
| SIKTIMAV |
int
0
|
Sick Time ...(more) Join Now
|
|
|
|
| SKTMHPYR |
int
0
|
Sick Time ...(more) Join Now
|
|
|
|
| WRNSTFLSBLWZR |
tinyint
0
|
Warn Sick ...(more) Join Now
|
|
|
|
| USERDEF1 |
char(21)
''
|
User Defin...(more) Join Now
|
|
|
|
| USERDEF2 |
char(21)
''
|
User Defin...(more) Join Now
|
|
|
|
| EMPLOYMENTTYPE |
smallint
0
|
Type of Em...(more) Join Now
|
|
|
|
| MARITALSTATUS |
smallint
0
|
1 = Marrie...(more) Join Now
|
|
|
|
| BENADJDATE |
datetime
'1/1/1900'
|
*Ben Adj D...(more) Join Now
|
|
|
|
| LASTDAYWORKED_I |
datetime
'1/1/1900'
|
Last Day W...(more) Join Now
|
|
|
|
| BIRTHDAY |
smallint
0
|
*Birth Day...(more) Join Now
|
|
|
|
| BIRTHMONTH |
smallint
0
|
*Birth Mon...(more) Join Now
|
|
|
|
| SPOUSE |
char(15)
''
|
|
|
|
|
| SPOUSESSN |
char(15)
''
|
Spouse SSN...(more) Join Now
|
|
|
|
| NICKNAME |
char(21)
''
|
|
|
|
|
| ALTERNATENAME |
char(21)
''
|
Alternate ...(more) Join Now
|
|
|
|
| HRSTATUS |
smallint
0
|
HR Status:...(more) Join Now
|
|
|
|
| DATEOFLASTREVIEW_I |
datetime
'1/1/1900'
|
*Date Of
...(more) Join Now
|
|
|
|
| DATEOFNEXTREVIEW_I |
datetime
'1/1/1900'
|
*Date Of
...(more) Join Now
|
|
|
|
| BENEFITEXPIRE_I |
datetime
'1/1/1900'
|
*Benefit E...(more) Join Now
|
|
|
|
| HANDICAPPED |
tinyint
0
|
*Handicapp...(more) Join Now
|
|
|
|
| VETERAN |
tinyint
0
|
*Veteran: ...(more) Join Now
|
|
|
|
| VIETNAMVETERAN |
tinyint
0
|
*Vietnam V...(more) Join Now
|
|
|
|
| DISABLEDVETERAN |
tinyint
0
|
*Disabled ...(more) Join Now
|
|
|
|
| UNIONEMPLOYEE |
tinyint
0
|
*Union Emp...(more) Join Now
|
|
|
|
| SMOKER_I |
tinyint
0
|
*Smoker: ...(more) Join Now
|
|
|
|
| CITIZEN |
tinyint
0
|
*Citizen: ...(more) Join Now
|
|
|
|
| VERIFIED |
tinyint
0
|
*Verified:...(more) Join Now
|
|
|
|
| I9RENEW |
datetime
'1/1/1900'
|
*I9renew: ...(more) Join Now
|
|
|
|
| Primary_Pay_Record |
char(7)
''
|
Primary Pa...(more) Join Now
|
|
|
join ... more text available
|
| CHANGEBY_I |
char(15)
''
|
*Change By...(more) Join Now
|
|
|
|
| CHANGEDATE_I |
datetime
'1/1/1900'
|
*Change Da...(more) Join Now
|
|
|
|
| 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
|
|
|
|
| RATECLSS |
char(15)
''
|
Rate Class...(more) Join Now
|
|
|
|
| FEDCLSSCD |
char(11)
''
|
Federal
...(more) Join Now
|
|
|
|
| OTHERVET |
tinyint
0
|
Other Vete...(more) Join Now
|
|
|
|
| Military_Discharge_Date |
datetime
'1/1/1900'
|
Military
...(more) Join Now
|
|
|
|
| EMPLSUFF |
char(5)
''
|
|
|
|
|
| STATUSCD |
char(15)
''
|
|
|
|
|
| Workflow_Approval_Status |
smallint
0
|
Workflow A...(more) Join Now
|
|
|
|
| Workflow_Priority |
smallint
0
|
Workflow P...(more) Join Now
|
|
|
|
| Workflow_Status |
smallint
0
|
|
|
|
|
| DEX_ROW_TS |
datetime
(getutcdate())
|
Time Stamp...(more) Join Now
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|
| AFSMVET |
tinyint
0
|
|
|
|
|
| RECSEPVET |
tinyint
0
|
|
|
|
|
| USERID |
char
''
|
The user t...(more) Join Now
|
|
|
join ... more text available
|