Consultant Import Fields

The following fields are available for importing consultants.


NameFieldEquivalent InTIME Webservice FieldDescriptionTypeFormatConstraintsMandatory
ReferenceCON_ITRIS_IDConsultant.externalIdThe consultant's referenceString(30)
Must be uniqueYes
UsernameCON_USERNAMEConsultant.usernameIf you wish to specify a username user this field. Otherwise InTime will generate a usernameString(52)

No
Created DateCON_CREATEDConsultant.created (Read Only)The date at which the consultant was createdDateTime

No
Modified DateCON_MODIFIEDConsultant.modified (Read Only)The date/time at which the consultant was updatedDateTime

No
FirstnameCON_FIRSTNAMEConsultant.firstnameThe consultant's first nameString(50)

Yes
LastnameCON_LASTNAMEConsultant.lastnameThe consultant's last nameString(50)

Yes
Combined first and last nameCON_FIRSTLAST_NAMEN/AThe consultant's first and last names combined into one fieldString

Can be used instead of two fields above
Email AddressCON_EMAILConsultant.email
String(255)
A valid email addressYes
Mobile NumberCON_MOBILEConsultant.mobile
String(30)

No
Mobile PhoneCON_PHONEConsultant.phone
String(30)

No
Fax NumberCON_FAXConsultant.fax
String(30)

No
DepartmentCON_DEPARTMENTConsultant.department
String(255)

No
Address Line 1CON_STREET1Consultant.address.line1
String(80)

No
Address Line 2CON_STREET2Consultant.address.line2
String(80)

No
Town/CityCON_TOWNConsultant.address.town
String(80)

No
CountyCON_COUNTYConsultant.address.county
String(80)

No
PostcodeCON_POSTCODEConsultant.address.postcode
String(20)

No
CountryCON_COUNTRYConsultant.address.country
String(80)

No
Role TemplateCON_ROLE_TEMPLATEConsultant.roleLevelIf you are using role templates, the ID of that templateNumber

No
Custom Text 1CON_CUSTOM_TEXT1Consultant.customText1
String

No
Custom Text 2CON_CUSTOM_TEXT2Consultant.customText2
String

No
Custom Text 3CON_CUSTOM_TEXT3Consultant.customText3
String

No
Custom Text 4CON_CUSTOM_TEXT4Consultant.customText4
String

No
Custom Text 5CON_CUSTOM_TEXT5Consultant.customText5
String

No