{"id":1392,"date":"2010-07-14T01:00:00","date_gmt":"2010-07-14T09:00:00","guid":{"rendered":"https:\/\/systematichr.com\/?p=1392"},"modified":"2010-06-14T18:39:54","modified_gmt":"2010-06-15T02:39:54","slug":"everything-in-its-place","status":"publish","type":"post","link":"https:\/\/systematichr.com\/?p=1392","title":{"rendered":"Everything in its Place"},"content":{"rendered":"

\"\"<\/a>I write this in the usual place \u2013 the airplane.\u00a0 I\u2019m in a window seat, so I\u2019m only surrounded on three sides.\u00a0 The guy in front of me has decided that all the stuff he does not want should not go in front of him, but that \u201cout of sight, out of mind\u201d is a good solution as he shoves the stuff under his seat at my legs.\u00a0 I was about to start throwing stuff back at him over his head, but thought better of it.\u00a0 The guy behind be decided the armrest was actually his footrest.\u00a0 When his shoe was on my arm, he didn\u2019t even have the sense to pull back a bit.\u00a0 I had to push his foot off the thing.\u00a0 The guy next to me is a good guy \u2013 he just has wide shoulders.\u00a0 I can\u2019t really blame anyone for that except his parents. \u00a0Worst thing yet, someone on this plane is flatulent.\u00a0 So not only is my space being intruded upon on all three sides, my very airspace is also becoming a bit offensive.\u00a0 (yes, I am the guy on the plane that will shout \u201cNo Farting!!\u201d to everyone)<\/p>\n

I was recently talking to someone about how Spain and Mexico uses 2 last names for employees.\u00a0\u00a0\u00a0 I don\u2019t know if you watch tennis, but the only example I can think of is Aranxa Sanchez-Vicario (I think that\u2019s how you spell it).Apparently PeopleSoft only has a 30 character last name field.\u00a0 I\u2019m not sure why they have not expanded this yet, but honestly, 30 should be enough, especially if you bought the right country packs.\u00a0 Anyway, I was recently talking to someone about Mexican last names and the thinking was that they would put the mother\u2019s last name in the middle name field, and the father\u2019s last name in the last name field.<\/p>\n

Fundamentally, I don\u2019t usually have a problem with workarounds.\u00a0 But as you know, I\u2019m a data governance guy and I have a huge problem dumping a last name somewhere other than the last name field and taking the middle name field and dropping in a name that is not the middle name.\u00a0 Not only are there just issues about using fields for the wrong purpose, but there are practical issues around interfaces and analytics.\u00a0 How do you search if you don\u2019t have a single last name field?\u00a0 If you have an interface, do you write it with specific instructions to look for Spaniards and Mexicans and re-arrange the names?<\/p>\n

There is a point to order and a point to \u201ceverything in its place.\u201d\u00a0 Especially in terms of systems and data governance order is of utmost importance.\u00a0 You start playing with order, and you wind up with what we call (in technical terms) \u201ccrappy data on a massive scale.\u201d\u00a0 You see, you mess with the wrong workarounds now, and there\u2019s a pretty high probability that you\u2019re going to pay for it later.\u00a0 Later might be a couple of years.\u00a0\u00a0\u00a0 Before you do the wrong workaround, do the right resource, figure out the implications, and then do it the right way anyway.<\/p>\n","protected":false},"excerpt":{"rendered":"

I write this in the usual place \u2013 the airplane.\u00a0 I\u2019m in a window seat, so I\u2019m only surrounded on three sides.\u00a0 The guy in front of me has decided that all the stuff he does not want should not…<\/p>\n","protected":false},"author":1,"featured_media":1748,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_coblocks_attr":"","_coblocks_dimensions":"","_coblocks_responsive_height":"","_coblocks_accordion_ie_support":"","footnotes":""},"categories":[27,8,2],"tags":[183,69,184],"class_list":["post-1392","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-data-metrics","category-strategies","category-hr-technology","tag-data-dictionary","tag-data-governance","tag-data-quality"],"_links":{"self":[{"href":"https:\/\/systematichr.com\/index.php?rest_route=\/wp\/v2\/posts\/1392","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/systematichr.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/systematichr.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/systematichr.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/systematichr.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1392"}],"version-history":[{"count":6,"href":"https:\/\/systematichr.com\/index.php?rest_route=\/wp\/v2\/posts\/1392\/revisions"}],"predecessor-version":[{"id":1488,"href":"https:\/\/systematichr.com\/index.php?rest_route=\/wp\/v2\/posts\/1392\/revisions\/1488"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/systematichr.com\/index.php?rest_route=\/wp\/v2\/media\/1748"}],"wp:attachment":[{"href":"https:\/\/systematichr.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1392"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/systematichr.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1392"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/systematichr.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1392"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}