Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>I was looking for the same thing and found what I believe to be a more complete answer. Thought I'd help anyone else coming in the future.</p> <p><strong>ICD-9 Regex</strong></p> <p>The ICD 9 format has a bunch of ways it can be formatted. It can begin with V, E, or a number.</p> <ul> <li>If it begins with V, then it has 2 numbers, a decimal, then up to two numbers <ul> <li>Examples: <code>V10.12</code> and <code>V12</code></li> </ul></li> <li>If it begins when E, then it has 3 numbers, the decimal place, then up to two numbers <ul> <li>Examples: <code>E000.0</code> and <code>E002</code></li> </ul></li> <li>If it begins with a number, then it is up to 3 numbers, a decimal, then up to two numbers <ul> <li>Examples: <code>730.12</code> and <code>730</code></li> </ul></li> </ul> <p>A good regex that checks all these rules is (Credit goes to <a href="http://www.sascommunity.org/wiki/Validate_the_format_of_ICD-9_codes" rel="noreferrer">sascomunitt</a>)</p> <pre><code>^(V\d{2}(\.\d{1,2})?|\d{3}(\.\d{1,2})?|E\d{3}(\.\d)?)$ </code></pre> <p><strong>ICD-10 Regex</strong></p> <p>According to <a href="https://www.cms.gov/ICD10/Downloads/032310_ICD10_Slides.pdf" rel="noreferrer">www.cms.gov</a> ICD-10 has the following rules:</p> <ul> <li>3-7 Characters</li> <li>Character 1 is alpha (cannot be U)</li> <li>Character 2 is numeric</li> <li>Characters 3-7 are alphanumeric</li> <li>After 3 characters you use a decimal</li> <li>Use of dummy placeholder "x" (This is the only one I am not accounting for in my regex...)</li> <li>Alpha characters are not case sensitive</li> </ul> <p>Here is the regex I came up with:</p> <pre><code>^[A-TV-Z][0-9][A-Z0-9](\.[A-Z0-9]{1,4})?$ </code></pre> <p><strong>Note</strong> These regexes are for javascript and may need tweaked for C# (I'm too lazy to test it right now)</p>
    singulars
    1. This table or related slice is empty.
    1. POicd9 regex pattern
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USGordon Tucker
    1. USGordon Tucker
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POicd9 regex pattern
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COThanks! this is a better answer than the accepted one since it includes E Codes and V Codes. Only annoying thing is this us government form I'm writing a program for requires the '.' after the first three numbers, so lame!
      singulars
      1. PO
      1. USPeter Turner
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload