{"id":1206,"date":"2014-09-16T08:29:58","date_gmt":"2014-09-16T08:29:58","guid":{"rendered":"http:\/\/www.w3computing.com\/systemsanalysis\/?p=1206"},"modified":"2017-08-22T17:24:09","modified_gmt":"2017-08-22T17:24:09","slug":"general-guidelines-coding","status":"publish","type":"post","link":"https:\/\/www.w3computing.com\/systemsanalysis\/general-guidelines-coding\/","title":{"rendered":"General Guidelines for Coding"},"content":{"rendered":"

In the previous sections, we examined the purposes for using different types of codes when humans and machines enter and store data. Next, we examine a few heuristics for establishing a coding system. These rules are highlighted in the list below.<\/p>\n

The Eight General Guidelines for Establishing a Coding System<\/h2>\n
    \n
  1. Keep codes concise<\/li>\n
  2. Keep codes stable<\/li>\n
  3. Make codes that are unique<\/li>\n
  4. Allow codes to be sortable<\/li>\n
  5. Avoid confusing codes<\/li>\n
  6. Keep codes uniform<\/li>\n
  7. Allow for modification of codes<\/li>\n
  8. Make codes meaningful<\/li>\n<\/ol>\n
    BE CONCISE<\/div>\n

    Codes should be concise. Overly long codes mean more keystrokes and consequently more errors. Long codes also mean that storing the information in a database will require more memory.<\/p>\n

    Short codes are easier for people to remember and easier to enter than long codes. If codes must be long, they should be broken up into subcodes. For example, 5678923453127 could be broken up with hyphens as follows: 5678-923-453-127. This approach is much more manageable and takes advantage of the way people are known to process information in short chunks. Sometimes codes are made longer than necessary for a reason. Credit card numbers are often long to prevent people from guessing a credit card number. Visa and MasterCard use 16-digit numbers, which would accommodate nine trillion customers. Because the numbers are not assigned sequentially, chances of guessing a credit card number are very slight.<\/p>\n

    KEEP THE CODES STABLE<\/div>\n

    Stability means that the identification code for a customer should not change each time new data are received. Earlier, we presented an alphabetic derivation code for a magazine subscription list. The expiration date was not part of the subscriber identification code because it was likely to change.<\/p>\n

    Don\u2019t change the code abbreviations in a mnemonic system. Once you have chosen the code abbreviations, do not try to revise them, because that makes it extremely difficult for data entry personnel to adapt.<\/p>\n

    ENSURE THAT CODES ARE UNIQUE<\/div>\n

    For codes to work, they must be unique. Make a note of all codes used in the system to ensure that you are not assigning the same code number or name to the same items. Code numbers and names are an essential part of the entries in data dictionaries, discussed in Chapter 8.<\/p>\n

    ALLOW CODES TO BE SORTABLE<\/div>\n

    If you are going to manipulate the data usefully, the codes must be sortable. For example, if you were to perform a text search on the months of the year in ascending order, the \u201cJ\u201d months would be out of order (January, July, and then June). Dictionaries are sorted in this way, one letter at a time from left to right. So, if you sorted MMMDDYYYY where the MMM stood for the abbreviation for the month, DD for the day, and YYYY for the year, the result would be in error.<\/p>\n

    Figure below shows what would happen if a text search were performed on different forms of the date. The third column shows a problem that was part of the year 2000 (Y2K) crisis that caused some alarm and even made the cover of Time magazine.<\/p>\n

    \"Plan<\/a>
    Plan ahead in order to be able to do something useful with data that have been entered. In this example, the person creating the codes did not realize the data would have to be sorted.<\/figcaption><\/figure>\n

    One of the lessons learned is to make sure that users can do what you intend them to do with the codes you create. Numeric codes are much easier to sort than alphanumerics; therefore, consider converting to numerics wherever practical.<\/p>\n

    AVOID CONFUSING CODES<\/div>\n

    Try to avoid using coding characters that look or sound alike. The characters O (the letter oh) and 0 (the number zero) are easily confused, as are the letter I and the number 1, and the letter Z and the number 2. Therefore, codes such as B1C and 280Z are unsatisfactory.<\/p>\n

    One example of a potentially confusing code is the Canadian Postal Code, as shown in the figure below. The code format is X9X 9X9, where X stands for a letter and 9 stands for a number. One advantage to using letters in the code is to allow more data in a six-digit code (there are 26 letters, but only 10 numbers). Because the code is used on a regular basis by Canadians, the code makes perfectly good sense to them. To foreigners sending mail to Canada, however, it may be difficult to tell if the second-to-last symbol is a Z or a 2.<\/p>\n

    \"Combining<\/a>
    Combining look-alike characters in codes can result in errors.<\/figcaption><\/figure>\n
    KEEP THE CODES UNIFORM<\/div>\n

    To be effective and efficient for humans, codes need to follow readily perceived forms most of the time. Codes used together, such as BUF-234 and KU-3456, are poor because the first contains three letters and three numbers, whereas the second has only two letters followed by four numbers.<\/p>\n

    When you are required to add dates, try to avoid using the codes MMDDYYYY in one application, YYYYDDMM in a second, and MMDDYY in a third. It is important to keep codes uniform among as well as within programs.<\/p>\n

    ALLOW FOR MODIFICATION OF CODES<\/div>\n

    Adaptability is a key feature of a good code. The analyst must keep in mind that the system will evolve over time, and the coding system should be able to encompass change. The number of customers should grow, customers will change names, and suppliers will modify the way they number their products. The analyst needs to be able to forecast the predictable changes that business users will desire and anticipate a wide range of future needs when designing codes.<\/p>\n

    MAKE CODES MEANINGFUL<\/div>\n

    Unless the analyst wants to hide information intentionally, codes should be meaningful. Effective codes not only contain information, but they also make sense to the people using them. Meaningful codes are easy to understand, work with, and recall. The job of data entry becomes more interesting when working with meaningful codes instead of just entering a series of meaningless numbers.<\/p>\n

    USING CODES<\/div>\n

    Codes are used in a number of ways. In validation programs, input data is checked against a list of codes to ensure that only valid codes have been entered. In report and inquiry programs, a code stored on a file is transformed into the meaning of the code. Reports and displays should not show or print the actual code. If they did, the user would have to memorize code meanings or look them up in a manual. Codes are used in GUI programs to create drop-down lists.<\/p>\n","protected":false},"excerpt":{"rendered":"

    In the previous sections, we examined the purposes for using different types of codes when humans and machines enter and store data. Next, we examine a few heuristics for establishing a coding system. These rules are highlighted in the list below. The Eight General Guidelines for Establishing a Coding System Keep codes concise Keep codes […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_genesis_hide_title":false,"_genesis_hide_breadcrumbs":false,"_genesis_hide_singular_image":false,"_genesis_hide_footer_widgets":false,"_genesis_custom_body_class":"","_genesis_custom_post_class":"","_genesis_layout":"","_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_post_was_ever_published":false},"categories":[18],"tags":[],"class_list":["post-1206","post","type-post","status-publish","format-standard","category-designing-accurate-data-entry-procedures","entry","has-post-thumbnail"],"yoast_head":"\nGeneral Guidelines for Coding<\/title>\n<meta name=\"description\" content=\"The Eight General Guidelines for Establishing a Coding System, Keep codes concise, Keep codes stable, Make codes that are unique, Allow codes to be sortable\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.w3computing.com\/systemsanalysis\/general-guidelines-coding\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"General Guidelines for Coding\" \/>\n<meta property=\"og:description\" content=\"The Eight General Guidelines for Establishing a Coding System, Keep codes concise, Keep codes stable, Make codes that are unique, Allow codes to be sortable\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.w3computing.com\/systemsanalysis\/general-guidelines-coding\/\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/w3computing\" \/>\n<meta property=\"article:published_time\" content=\"2014-09-16T08:29:58+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2017-08-22T17:24:09+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.w3computing.com\/systemsanalysis\/wp-content\/uploads\/2014\/09\/15.11-allow-codes-sortable-300x96.jpg\" \/>\n<meta name=\"author\" content=\"w3computing.com\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"w3computing.com\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"TechArticle\",\"@id\":\"https:\\\/\\\/www.w3computing.com\\\/systemsanalysis\\\/general-guidelines-coding\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.w3computing.com\\\/systemsanalysis\\\/general-guidelines-coding\\\/\"},\"author\":{\"name\":\"w3computing.com\",\"@id\":\"https:\\\/\\\/www.w3computing.com\\\/systemsanalysis\\\/#\\\/schema\\\/person\\\/8395166dc0b94b38a3aeb88dafbd63ce\"},\"headline\":\"General Guidelines for Coding\",\"datePublished\":\"2014-09-16T08:29:58+00:00\",\"dateModified\":\"2017-08-22T17:24:09+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.w3computing.com\\\/systemsanalysis\\\/general-guidelines-coding\\\/\"},\"wordCount\":1091,\"image\":{\"@id\":\"https:\\\/\\\/www.w3computing.com\\\/systemsanalysis\\\/general-guidelines-coding\\\/#primaryimage\"},\"thumbnailUrl\":\"http:\\\/\\\/www.w3computing.com\\\/systemsanalysis\\\/wp-content\\\/uploads\\\/2014\\\/09\\\/15.11-allow-codes-sortable-300x96.jpg\",\"articleSection\":[\"Designing Accurate Data Entry Procedures\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.w3computing.com\\\/systemsanalysis\\\/general-guidelines-coding\\\/\",\"url\":\"https:\\\/\\\/www.w3computing.com\\\/systemsanalysis\\\/general-guidelines-coding\\\/\",\"name\":\"General Guidelines for Coding\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.w3computing.com\\\/systemsanalysis\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.w3computing.com\\\/systemsanalysis\\\/general-guidelines-coding\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.w3computing.com\\\/systemsanalysis\\\/general-guidelines-coding\\\/#primaryimage\"},\"thumbnailUrl\":\"http:\\\/\\\/www.w3computing.com\\\/systemsanalysis\\\/wp-content\\\/uploads\\\/2014\\\/09\\\/15.11-allow-codes-sortable-300x96.jpg\",\"datePublished\":\"2014-09-16T08:29:58+00:00\",\"dateModified\":\"2017-08-22T17:24:09+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.w3computing.com\\\/systemsanalysis\\\/#\\\/schema\\\/person\\\/8395166dc0b94b38a3aeb88dafbd63ce\"},\"description\":\"The Eight General Guidelines for Establishing a Coding System, Keep codes concise, Keep codes stable, Make codes that are unique, Allow codes to be sortable\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.w3computing.com\\\/systemsanalysis\\\/general-guidelines-coding\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.w3computing.com\\\/systemsanalysis\\\/general-guidelines-coding\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.w3computing.com\\\/systemsanalysis\\\/general-guidelines-coding\\\/#primaryimage\",\"url\":\"http:\\\/\\\/www.w3computing.com\\\/systemsanalysis\\\/wp-content\\\/uploads\\\/2014\\\/09\\\/15.11-allow-codes-sortable-300x96.jpg\",\"contentUrl\":\"http:\\\/\\\/www.w3computing.com\\\/systemsanalysis\\\/wp-content\\\/uploads\\\/2014\\\/09\\\/15.11-allow-codes-sortable-300x96.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.w3computing.com\\\/systemsanalysis\\\/general-guidelines-coding\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Systems Analysis\",\"item\":\"https:\\\/\\\/www.w3computing.com\\\/systemsanalysis\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Designing Accurate Data Entry Procedures\",\"item\":\"https:\\\/\\\/www.w3computing.com\\\/systemsanalysis\\\/designing-accurate-data-entry-procedures\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"General Guidelines for Coding\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.w3computing.com\\\/systemsanalysis\\\/#website\",\"url\":\"https:\\\/\\\/www.w3computing.com\\\/systemsanalysis\\\/\",\"name\":\"\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.w3computing.com\\\/systemsanalysis\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.w3computing.com\\\/systemsanalysis\\\/#\\\/schema\\\/person\\\/8395166dc0b94b38a3aeb88dafbd63ce\",\"name\":\"w3computing.com\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"General Guidelines for Coding","description":"The Eight General Guidelines for Establishing a Coding System, Keep codes concise, Keep codes stable, Make codes that are unique, Allow codes to be sortable","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.w3computing.com\/systemsanalysis\/general-guidelines-coding\/","og_locale":"en_US","og_type":"article","og_title":"General Guidelines for Coding","og_description":"The Eight General Guidelines for Establishing a Coding System, Keep codes concise, Keep codes stable, Make codes that are unique, Allow codes to be sortable","og_url":"https:\/\/www.w3computing.com\/systemsanalysis\/general-guidelines-coding\/","article_publisher":"https:\/\/www.facebook.com\/w3computing","article_published_time":"2014-09-16T08:29:58+00:00","article_modified_time":"2017-08-22T17:24:09+00:00","og_image":[{"url":"http:\/\/www.w3computing.com\/systemsanalysis\/wp-content\/uploads\/2014\/09\/15.11-allow-codes-sortable-300x96.jpg","type":"","width":"","height":""}],"author":"w3computing.com","twitter_misc":{"Written by":"w3computing.com","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"TechArticle","@id":"https:\/\/www.w3computing.com\/systemsanalysis\/general-guidelines-coding\/#article","isPartOf":{"@id":"https:\/\/www.w3computing.com\/systemsanalysis\/general-guidelines-coding\/"},"author":{"name":"w3computing.com","@id":"https:\/\/www.w3computing.com\/systemsanalysis\/#\/schema\/person\/8395166dc0b94b38a3aeb88dafbd63ce"},"headline":"General Guidelines for Coding","datePublished":"2014-09-16T08:29:58+00:00","dateModified":"2017-08-22T17:24:09+00:00","mainEntityOfPage":{"@id":"https:\/\/www.w3computing.com\/systemsanalysis\/general-guidelines-coding\/"},"wordCount":1091,"image":{"@id":"https:\/\/www.w3computing.com\/systemsanalysis\/general-guidelines-coding\/#primaryimage"},"thumbnailUrl":"http:\/\/www.w3computing.com\/systemsanalysis\/wp-content\/uploads\/2014\/09\/15.11-allow-codes-sortable-300x96.jpg","articleSection":["Designing Accurate Data Entry Procedures"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.w3computing.com\/systemsanalysis\/general-guidelines-coding\/","url":"https:\/\/www.w3computing.com\/systemsanalysis\/general-guidelines-coding\/","name":"General Guidelines for Coding","isPartOf":{"@id":"https:\/\/www.w3computing.com\/systemsanalysis\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.w3computing.com\/systemsanalysis\/general-guidelines-coding\/#primaryimage"},"image":{"@id":"https:\/\/www.w3computing.com\/systemsanalysis\/general-guidelines-coding\/#primaryimage"},"thumbnailUrl":"http:\/\/www.w3computing.com\/systemsanalysis\/wp-content\/uploads\/2014\/09\/15.11-allow-codes-sortable-300x96.jpg","datePublished":"2014-09-16T08:29:58+00:00","dateModified":"2017-08-22T17:24:09+00:00","author":{"@id":"https:\/\/www.w3computing.com\/systemsanalysis\/#\/schema\/person\/8395166dc0b94b38a3aeb88dafbd63ce"},"description":"The Eight General Guidelines for Establishing a Coding System, Keep codes concise, Keep codes stable, Make codes that are unique, Allow codes to be sortable","breadcrumb":{"@id":"https:\/\/www.w3computing.com\/systemsanalysis\/general-guidelines-coding\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.w3computing.com\/systemsanalysis\/general-guidelines-coding\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.w3computing.com\/systemsanalysis\/general-guidelines-coding\/#primaryimage","url":"http:\/\/www.w3computing.com\/systemsanalysis\/wp-content\/uploads\/2014\/09\/15.11-allow-codes-sortable-300x96.jpg","contentUrl":"http:\/\/www.w3computing.com\/systemsanalysis\/wp-content\/uploads\/2014\/09\/15.11-allow-codes-sortable-300x96.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/www.w3computing.com\/systemsanalysis\/general-guidelines-coding\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Systems Analysis","item":"https:\/\/www.w3computing.com\/systemsanalysis\/"},{"@type":"ListItem","position":2,"name":"Designing Accurate Data Entry Procedures","item":"https:\/\/www.w3computing.com\/systemsanalysis\/designing-accurate-data-entry-procedures\/"},{"@type":"ListItem","position":3,"name":"General Guidelines for Coding"}]},{"@type":"WebSite","@id":"https:\/\/www.w3computing.com\/systemsanalysis\/#website","url":"https:\/\/www.w3computing.com\/systemsanalysis\/","name":"","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.w3computing.com\/systemsanalysis\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.w3computing.com\/systemsanalysis\/#\/schema\/person\/8395166dc0b94b38a3aeb88dafbd63ce","name":"w3computing.com"}]}},"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p4NNeA-js","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.w3computing.com\/systemsanalysis\/wp-json\/wp\/v2\/posts\/1206","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.w3computing.com\/systemsanalysis\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.w3computing.com\/systemsanalysis\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.w3computing.com\/systemsanalysis\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.w3computing.com\/systemsanalysis\/wp-json\/wp\/v2\/comments?post=1206"}],"version-history":[{"count":0,"href":"https:\/\/www.w3computing.com\/systemsanalysis\/wp-json\/wp\/v2\/posts\/1206\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.w3computing.com\/systemsanalysis\/wp-json\/wp\/v2\/media?parent=1206"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.w3computing.com\/systemsanalysis\/wp-json\/wp\/v2\/categories?post=1206"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.w3computing.com\/systemsanalysis\/wp-json\/wp\/v2\/tags?post=1206"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}