Synced data from ADP

packages basic basic | | headcount planning headcount planning | compensation reviews compensation reviews | performance performance | engagement engagement the following table lists the default data set synced from adp to charthop charthop customers can work with charthop implementation services to customize what is synced you must include the country code as a part of any international number for it to be recognized as such within charthop when you are syncing phone numbers from an external system, such as a payroll system or ats, be sure the country code is included in the phone number that is listed in the external system this also applies when updating data through a spreadsheet charthop field label charthop field code adp field code base base workers workassignment baseremuneration payperiodrateamount amountvalue, workers workassignment baseremuneration payperiodrateamount currencycode, workers workassignment baseremuneration hourlyrateamount amountvalue, workers workassignment baseremuneration hourlyrateamount currencycode, workers workassignment paycyclecode codevalue birth date birthdate workers person birthdate city home address address city workers person legaladdress cityname company company workers workassignment country home address address country workers person legaladdress countrycode currency currency workers workassignment baseremuneration payperiodrateamount amountvalue, workers workassignment baseremuneration payperiodrateamount currencycode, workers workassignment baseremuneration hourlyrateamount amountvalue, workers workassignment baseremuneration hourlyrateamount currencycode, workers workassignment paycyclecode codevalue date date workers workassignment actualstartdate, workers workassignment terminationdate, workers workassignment baseremuneration effectivedate depart depart workers workassignment terminationdate, workers workassignment assignmentstatus reasoncode codevalue, workers workassignment voluntaryindicator department department workers workassignment employment employment workers workassignment workertypecode codevalue ethnicity ethnicity workers person racecode codevalue first name name first workers person legalname givenname gender gender workers person gendercode codevalue home email contact homeemail workers person communication emails\[0] emailuri home phone contact homephone workers person communication landlines\[0] formattednumber hourly hourly workers workassignment baseremuneration payperiodrateamount amountvalue, workers workassignment baseremuneration payperiodrateamount currencycode, workers workassignment baseremuneration hourlyrateamount amountvalue, workers workassignment baseremuneration hourlyrateamount currencycode, workers workassignment paycyclecode codevalue last name name last workers person legalname familyname1 location location workers workassignment homeworklocation namecode shortname manager manager workers workassignment reportsto\[0] workerid idvalue middle name name middle workers person legalname middlename mobile contact mobilephone workers businesscommunication mobiles\[0] formattednumber, workers person communication mobiles\[0] formattednumber preferred first name name pref workers person legalname nickname start date startdate workers workerdates rehiredate, workers workerdates originalhiredate state home address address state workers person legaladdress countrysubdivisionlevel1 codevalue street 1 home address address street1 workers person legaladdress lineone street 2 home address address street2 workers person legaladdress linetwo street 3 home address address street3 workers person legaladdress linethree title title workers workassignment jobcode longname, workers workassignment jobcode shortname work email contact workemail workers businesscommunication emails\[0] emailuri work fax contact workfax workers businesscommunication faxes\[0] formattednumber work phone contact workphone workers businesscommunication landlines\[0] formattednumber zip/postal home address address postal workers person legaladdress postalcode used to store profile photos imageurl workers photos\[0] links\[0] href hourly compensation rate calculations to calculate hourly compensation, the following fields are used from adp and are translated to charthop codenames charthop codename adp field code baseamount workers workassignment baseremuneration payperiodrateamount amountvalue basecurrency workers workassignment baseremuneration payperiodrateamount currencycode hourlyamount workers workassignment baseremuneration hourlyrateamount amountvalue hourlycurrency workers workassignment baseremuneration hourlyrateamount currencycode (as in adp) workers workassignment paycyclecode codevalue charthop uses a multiplier to correspond to the number of pay periods for a given employee below are the codes charthop receives from adp and the multipliers it maps to them m 12 (monthly) s 24 (semi monthly) b 26 (bi weekly) charthop first checks if baseamount is provided if so, it takes that value and times it by the given multiplier to determine a given employee’s salary if baseamount isn’t provided, charthop checks hourlyamount and sets it to its hourly field charthop also grabs either basecurrency or hourlycurrency depending on whether baseamount or hourlyamount is provided and uses that value to set its currency field