Introduction
Purpose
Attributes & Descriptions
| Attribute | Data Type | Attribute Description |
|---|---|---|
| employeeid | varchar(250) | |
| firstname | varchar(255) | |
| middlename | varchar(255) | |
| lastname | varchar(255) | |
| department | varchar(255) | |
| division | varchar(255) | |
| location | varchar(255) | |
| manageremployeeid | varchar(250) | |
| workemail | varchar(255) | |
| workphone | varchar(255) | |
| title | varchar(255) | |
| employeetype | varchar(255) | |
| id | bigint(20) | |
| status | int(11) | |
| uniquecode | varchar(255) | |
| riskscore | double | |
| customfield1 | varchar(255) | |
| customfield2 | varchar(255) | |
| customfield3 | varchar(255) | |
| customfield4 | varchar(255) | |
| customfield5 | varchar(255) | |
| customfield6 | varchar(255) | |
| customfield7 | varchar(255) | |
| customfield8 | varchar(255) | |
| customfield9 | varchar(255) | |
| customfield10 | varchar(255) | |
| customfield11 | varchar(255) | |
| customfield12 | varchar(255) | |
| customfield13 | varchar(255) | |
| customfield14 | varchar(255) | |
| customfield15 | varchar(255) | |
| customfield16 | varchar(255) | |
| customfield17 | varchar(255) | |
| customfield18 | varchar(255) | |
| customfield19 | varchar(255) | |
| customfield20 | varchar(255) | |
| promoted | varchar(25) | |
| createdate | datetime | |
| usergroup | varchar(50) | |
| street | varchar(255) | |
| city | varchar(255) | |
| province | varchar(255) | |
| zipcode | varchar(25) | |
| userstate | varchar(255) | |
| region | varchar(255) | |
| country | varchar(255) | |
| approveremployeeid | varchar(250) | |
| delegateemployeeid | varchar(250) | |
| technicalapproverid | varchar(250) | |
| extension | varchar(255) | |
| fax | varchar(255) | |
| mobile | varchar(255) | |
| pager | varchar(255) | |
| jobcode | varchar(255) | |
| comments | varchar(255) | |
| createdby | varchar(250) | |
| costcentername | varchar(255) | |
| costcentercode | varchar(255) | |
| enabledate | datetime | |
| disabledate | datetime | |
| deletedate | datetime | |
| updatedate | datetime | |
| sunrisedate | datetime | |
| sunsetdate | datetime | |
| criticality | varchar(255) | |
| domintlin | varchar(50) | |
| nameprefix | varchar(255) | |
| namesuffix | varchar(255) | |
| preferredname | varchar(255) | |
| secondaryphone | varchar(255) | |
| statusdescription | varchar(400) | |
| vacationstart | datetime | |
| vacationend | datetime | |
| networkid | varchar(255) | |
| workpager | varchar(200) | |
| workextensionnumber | varchar(20) | |
| workfax | varchar(20) | |
| employeestatuscode | varchar(200) | |
| locationcode | varchar(200) | |
| locationname | varchar(255) | |
| mailcode | varchar(100) | |
| hiredate | datetime | |
| rehiredate | datetime | |
| recenthiredate | datetime | |
| terminationdate | datetime | |
| lastdayworked | datetime | |
| contractstartdate | datetime | |
| contractenddate | datetime | |
| employeetypedescription | varchar(255) | |
| regtempin | varchar(25) | |
| fulltimeparttimein | varchar(25) | |
| managerfirstname | varchar(255) | |
| managerlastname | varchar(255) | |
| managermiddlename | varchar(255) | |
| orgunitnumber | varchar(255) | |
| companycode | varchar(255) | |
| companynumber | varchar(255) | |
| hierarchy | varchar(255) | |
| lastperformancereviewdate | datetime | |
| lastperformancereviewresult | varchar(255) | |
| standardhours | varchar(15) | |
| shiftcode | varchar(50) | |
| shiftname | varchar(100) | |
| lanid | varchar(200) | |
| userid | varchar(250) | |
| transferreddate | datetime | |
| datasourceid | bigint(20) | |
| timezoneoffset | varchar(100) | |
| customfield21 | double | |
| customfield22 | double | |
| customfield23 | double | |
| customfield24 | varchar(255) | |
| customfield25 | text | |
| customfield26 | text | |
| customfield27 | text | |
| customfield28 | text | |
| customfield29 | text | |
| customfield30 | text | |
| encrypted | tinyint(1) | |
| encryptedfields | varchar(1024) | |
| lastsynctime | timestamp | |
| mergeuniquecode | varchar(255) | |
| masked | tinyint(1) | |
| maskedfields | text | |
| skipencryption | tinyint(1) |