Modify a value - To set a value, include the new value in corresponding column.
Skip a value - To not modify an existing value, leave the corresponding column blank.
Clear existing value - To clear a value, set the value to "!clear".
Delete an employee - To delete an employee from the system, set either firstname or lastname to !delete.
Name Columns marked "required" are only required in creating a new employee. If an existing
employee is found, then the field can be left blank (skip a value) as long as the employee already
has a value for the required column.
Columns can be in any order.
Columns are optional unless specified.
Column names are not case sensitive.
For text fields, any text is allowed unless specified.
Columns should be comma separated. Encapsulate in quotes if a comma is needed in the data field.
Elements shown in single quotes below are placeholders for your own value.
Your value does not need to be quoted.
For example:
TrackingLevel.'Name of Tracking Level'
might be
TrackingLevel.Department
Elements shown in Square Brackets are optional qualifiers and would only be needed if you have multiple options.
Currently they only apply to Communication Configurations. If you have Multiple Communication Configurations, then
you would use the Configuration Name as the qualifier when submitting information
Special Characters:
Data must use Quote Character (") to include Carriage Returns, Commas and/or Quotes.
Quote Character must be Doubled like ""this"" to include in a note
-------------------------------------------------------------
CompanyId (max 50 chars. Should be SSO CompanyID, required for multi-company support)
EmployeeId (max 50 chars. Must be unique within a company. Probably the same as the UserID from SSO, required)
IsActive (1 for active, 0 for inactive)
FirstName (max 35 chars, required)
LastName (max 35 chars, required)
OvertimeRuleName (max 50 chars)
HolidayRuleName (max 50 chars)
PayPeriodRuleName (max 50 chars)
AccrualPlanName (max 50 chars)
WebConnectName
TrackingLevel1
TrackingLevel2
TrackingLevel3
TrackingLevel4
TrackingLevel5
TrackingLevel6
TrackingLevel7
TrackingLevel8
TrackingLevel.'Name of Tracking Level' (name max 50 chars)
PayRate (numeric max 4 decimal places)
HireDate (min year 1900)
ReleaseDate (min year 1900)
Street (max 128 chars)
City (max 35 chars)
State (max 20 chars)
PostalCode (max 15 chars)
Country (max 20 chars)
HomePhone (max 50 chars)
MobilePhone (max 50 chars)
EmergencyContactName (max 50 chars)
EmergencyContactPhone (max 50 chars)
EMail (max 255 chars. must pass RFC5322 formatting)
WebConnectUsername (max 255 chars)
WebConnectPassword (max 255 chars)
WebConnectPasswordChangeRequired
DeskPunchPasswordChangeRequired
SalaryRate (numeric max 4 decimal places)
SalaryHours (numeric hours. fractional allowed)
SalaryStart (previous,current,next)
SalaryRuleName (max 50 chars)
PrimarySupervisorUserName (supervisor's username)
SecondarySupervisorUserName (supervisor's username)
ScheduleName
ScheduleEffectiveDate
AccrualBalance.'Name of PTO' (numeric up to 4 decimal places)
AccrualBalanceDate.'Name of PTO'
AccruedAmount.'Name of PTO' (numeric up to 4 decimal places)
IdentityPin[.ConfigName]
IdentityPrivilege[.ConfigName] (0=Employee,2=Enroller,14=Administrator; accepts either number or word)
IdentityPassword[.ConfigName]
IdentityCardNumber[.ConfigName]
IdentityFingerprint0[.ConfigName]
IdentityFingerprint1[.ConfigName]
IdentityFingerprint2[.ConfigName]
IdentityFingerprint3[.ConfigName]
IdentityFingerprint4[.ConfigName]
IdentityFingerprint5[.ConfigName]
IdentityFingerprint6[.ConfigName]
IdentityFingerprint7[.ConfigName]
IdentityFingerprint8[.ConfigName]
IdentityFingerprint9[.ConfigName]
Property.'Name'
