| TECHID |
char(11)
''
|
Field Type...(more) Join Now
|
|
|
|
| NAME |
char(31)
''
|
Field Type...(more) Join Now
|
|
|
|
| ADDRESS1 |
char(61)
''
|
Field Type...(more) Join Now
|
|
|
|
| ADDRESS2 |
char(61)
''
|
Field Type...(more) Join Now
|
|
|
|
| CITY |
char(35)
''
|
Field Type...(more) Join Now
|
|
|
|
| STATE |
char(29)
''
|
Field Type...(more) Join Now
|
|
|
|
| ZIPCODE |
char(11)
''
|
Field Type...(more) Join Now
|
|
|
|
| MANAGER |
char(11)
''
|
Field Type...(more) Join Now
|
|
|
|
| OFFID |
char(11)
''
|
Field Type...(more) Join Now
|
|
|
|
| PHONE1 |
char(21)
''
|
Field Type...(more) Join Now
|
|
|
|
| PHONE2 |
char(21)
''
|
Field Type...(more) Join Now
|
|
|
|
| PAGER1 |
char(99)
''
|
Field Type...(more) Join Now
|
|
|
|
| PIN1 |
char(11)
''
|
Field Type...(more) Join Now
|
|
|
|
| PAGER2 |
char(99)
''
|
Field Type...(more) Join Now
|
|
|
|
| PIN2 |
char(11)
''
|
Field Type...(more) Join Now
|
|
|
|
| TECHEMAIL |
char(99)
''
|
Field Type...(more) Join Now
|
|
|
|
| TECHEMAIL2 |
char(99)
''
|
Field Type...(more) Join Now
|
|
|
|
| WORKDYS_1 |
tinyint
0
|
Field Type...(more) Join Now
|
|
|
|
| WORKDYS_2 |
tinyint
0
|
Field Type...(more) Join Now
|
|
|
|
| WORKDYS_3 |
tinyint
0
|
Field Type...(more) Join Now
|
|
|
|
| WORKDYS_4 |
tinyint
0
|
Field Type...(more) Join Now
|
|
|
|
| WORKDYS_5 |
tinyint
0
|
Field Type...(more) Join Now
|
|
|
|
| WORKDYS_6 |
tinyint
0
|
Field Type...(more) Join Now
|
|
|
|
| WORKDYS_7 |
tinyint
0
|
Field Type...(more) Join Now
|
|
|
|
| WORKSTRT_1 |
datetime
'1/1/1900'
|
Field Type...(more) Join Now
|
|
|
|
| WORKSTRT_2 |
datetime
'1/1/1900'
|
Field Type...(more) Join Now
|
|
|
|
| WORKSTRT_3 |
datetime
'1/1/1900'
|
Field Type...(more) Join Now
|
|
|
|
| WORKSTRT_4 |
datetime
'1/1/1900'
|
Field Type...(more) Join Now
|
|
|
|
| WORKSTRT_5 |
datetime
'1/1/1900'
|
Field Type...(more) Join Now
|
|
|
|
| WORKSTRT_6 |
datetime
'1/1/1900'
|
Field Type...(more) Join Now
|
|
|
|
| WORKSTRT_7 |
datetime
'1/1/1900'
|
Field Type...(more) Join Now
|
|
|
|
| WORKEND_1 |
datetime
'1/1/1900'
|
Field Type...(more) Join Now
|
|
|
|
| WORKEND_2 |
datetime
'1/1/1900'
|
Field Type...(more) Join Now
|
|
|
|
| WORKEND_3 |
datetime
'1/1/1900'
|
Field Type...(more) Join Now
|
|
|
|
| WORKEND_4 |
datetime
'1/1/1900'
|
Field Type...(more) Join Now
|
|
|
|
| WORKEND_5 |
datetime
'1/1/1900'
|
Field Type...(more) Join Now
|
|
|
|
| WORKEND_6 |
datetime
'1/1/1900'
|
Field Type...(more) Join Now
|
|
|
|
| WORKEND_7 |
datetime
'1/1/1900'
|
Field Type...(more) Join Now
|
|
|
|
| DTEHIRE |
datetime
'1/1/1900'
|
Field Type...(more) Join Now
|
|
|
|
| DTETERM |
datetime
'1/1/1900'
|
Field Type...(more) Join Now
|
|
|
|
| TECHSTAT |
char(11)
''
|
Field Type...(more) Join Now
|
|
|
|
| LOCNCODE |
char(11)
''
|
Field Type...(more) Join Now
|
|
|
join ... more text available
|
| LOCCODEB |
char(11)
''
|
Field Type...(more) Join Now
|
|
|
|
| NOTEINDX |
numeric(19,5)
0.00
|
Note Index...(more) Join Now
|
|
|
join ... more text available
|
| PRCLEVEL |
char(11)
''
|
Field Type...(more) Join Now
|
|
|
|
| IVRPassword |
char(11)
''
|
Field Type...(more) Join Now
|
|
|
|
| IVROptions |
char(255)
''
|
Field Type...(more) Join Now
|
|
|
|
| IVRLoginDate |
datetime
'1/1/1900'
|
Field Type...(more) Join Now
|
|
|
|
| IVRPassDate |
datetime
'1/1/1900'
|
Field Type...(more) Join Now
|
|
|
|
| IVRAccess |
int
0
|
Field Type...(more) Join Now
|
|
|
|
| IVRGreet |
char(255)
''
|
Field Type...(more) Join Now
|
|
|
|
| ADDRESS3 |
char(61)
''
|
Field Type...(more) Join Now
|
|
|
|
| COUNTRY |
char(61)
''
|
Field Type...(more) Join Now
|
|
|
|
| SVC_ItemSiteDelta |
tinyint
0
|
Field Type...(more) Join Now
|
|
|
|
| SVC_LastCommDate |
datetime
'1/1/1900'
|
Field Type...(more) Join Now
|
|
|
|
| VENDORID |
char(15)
''
|
Field Type...(more) Join Now
|
|
|
join ... more text available
|
| EMPLOYID |
char(15)
''
|
Employee I...(more) Join Now
|
UPR00100.EMPLOYID
|
|
join ... more text available
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|