{"id":1910,"date":"2014-07-11T10:34:07","date_gmt":"2014-07-11T09:34:07","guid":{"rendered":"http:\/\/help.sdna.lu\/?p=1910&#038;lang=en"},"modified":"2020-07-30T13:53:19","modified_gmt":"2020-07-30T12:53:19","slug":"employee-2","status":"publish","type":"post","link":"https:\/\/sdna.lu\/?p=1910","title":{"rendered":"Employee"},"content":{"rendered":"<h3><span style=\"color: #ff0000;\"><b><span style=\"text-decoration: underline;\">Employee:<\/span><\/b><\/span><\/h3>\n<table>\n<tbody>\n<tr>\n<td valign=\"center\">RecordType;DBId;Title;FirstName;LastName;Phone;HouseNumber;Street;PostalCode;Locality;CountryCode;BDate;BPlace;<br \/>\nNumber;Extension;BillingRate;ACBillingRate;HourlyCost;ACHourlyCost;ShortName;Start;End<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<table>\n<tbody>\n<tr>\n<th width=\"10\">Nr<\/th>\n<th width=\"250\">Name<\/th>\n<th width=\"20\">Type<\/th>\n<th width=\"350\">Description<\/th>\n<\/tr>\n<tr>\n<td valign=\"top\">1<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">RecordType<\/span><\/td>\n<td valign=\"top\">Long<\/td>\n<td valign=\"top\">Type of object to import. 52 is for employee<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">2<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">DBId<\/span><\/td>\n<td valign=\"top\">Long<\/td>\n<td valign=\"top\">Database Id in DeMaSy. It is displayed in Utilities<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">3<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">Title<\/span><\/td>\n<td valign=\"top\">Char(25)<\/td>\n<td valign=\"top\">Title of the employee<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">4<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">FirstName<\/span><\/td>\n<td valign=\"top\">Char(30)<\/td>\n<td valign=\"top\">First name of the employee<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">5<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">LastName<\/span><\/td>\n<td valign=\"top\">Char(45)<\/td>\n<td valign=\"top\">Last name of the employee<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">6<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">Phone<\/span><\/td>\n<td valign=\"top\">Char(30)<\/td>\n<td valign=\"top\">Phone of the employee<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">7<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">HouseNumber<\/span><\/td>\n<td valign=\"top\">Char(10)<\/td>\n<td valign=\"top\">House number of the employee<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">8<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">Street<\/span><\/td>\n<td valign=\"top\">Char(30)<\/td>\n<td valign=\"top\">Street of the employee<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">9<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">PostalCode<\/span><\/td>\n<td valign=\"top\">Char(10)<\/td>\n<td valign=\"top\">Postal code of the employee<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">10<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">Locality<\/span><\/td>\n<td valign=\"top\">Char(30)<\/td>\n<td valign=\"top\">Locality of the employee<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">11<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">CountryCode<\/span><\/td>\n<td valign=\"top\">Char(10)<\/td>\n<td valign=\"top\">Code of the country of the employee<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">12<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">BDate<\/span><\/td>\n<td valign=\"top\">Date\/Time<\/td>\n<td valign=\"top\">Birth date<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">13<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">BPlace<\/span><\/td>\n<td valign=\"top\">Char(30)<\/td>\n<td valign=\"top\">Birth place<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">14<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">Number<\/span><\/td>\n<td valign=\"top\">Char(20)<\/td>\n<td valign=\"top\">\/<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">15<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">Extension<\/span><\/td>\n<td valign=\"top\">Char(10)<\/td>\n<td valign=\"top\">Extension of the employee<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">16<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">BillingRate<\/span><\/td>\n<td valign=\"top\">Double<\/td>\n<td valign=\"top\">Billing rate of the employee<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">17<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">ACBillingRate<\/span><\/td>\n<td valign=\"top\">Double<\/td>\n<td valign=\"top\">Billing rate of the employee<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">18<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">HourlyCost<\/span><\/td>\n<td valign=\"top\">Double<\/td>\n<td valign=\"top\">Hourly cost of the employee<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">19<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">ACHourlyCost<\/span><\/td>\n<td valign=\"top\">Double<\/td>\n<td valign=\"top\">Hourly cost of the employee<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">20<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">ShortName<\/span><\/td>\n<td valign=\"top\">Char(10)<\/td>\n<td valign=\"top\">Short name of the employee<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">21<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">Start<\/span><\/td>\n<td valign=\"top\">Date\/Time<\/td>\n<td valign=\"top\">First day of the employee<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">22<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">End<\/span><\/td>\n<td valign=\"top\">Date\/Time<\/td>\n<td valign=\"top\">Last date of the employee<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n","protected":false},"excerpt":{"rendered":"<p>Employee: RecordType;DBId;Title;FirstName;LastName;Phone;HouseNumber;Street;PostalCode;Locality;CountryCode;BDate;BPlace; Number;Extension;BillingRate;ACBillingRate;HourlyCost;ACHourlyCost;ShortName;Start;End Nr Name Type Description 1 RecordType Long Type of object to import. 52 is for employee 2 DBId Long Database Id in DeMaSy. It is displayed in Utilities 3 Title Char(25) Title of the employee 4 FirstName Char(30) First name of the employee 5 LastName Char(45) Last name of the employee 6 [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[237],"tags":[],"class_list":["post-1910","post","type-post","status-publish","format-standard","hentry","category-interface-utils"],"_links":{"self":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/1910","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1910"}],"version-history":[{"count":5,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/1910\/revisions"}],"predecessor-version":[{"id":9321,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/1910\/revisions\/9321"}],"wp:attachment":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1910"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1910"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1910"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}