Email: insite@insite-fm.com
INSITE Family Medicine Inc.
Important: Please verify with INSITE-Family Medicine Inc. that no changes have been made to the information in this appendix before beginning any development.
Spreadsheet Column | Data Type | Data Length | Valid ENCODE-FM™ Entries | Notes |
---|---|---|---|---|
SeqNo (sequence number) | numeric | 5 | 1 - 99999 | This is number that indicates order relative to other terms. It may change with each version depending on additions to ENCODE-FM™. |
UniqueNo (unique code number) | numeric | 5 | 1 - 99999 | This is the permanent ENCODE-FM™ code number assigned to a term. It will never be deleted. |
Retired | numeric | 1 | 0 = in current use 1 = retired/header | This indicates if a term is no longer in current use or is a header term not intended for use in a clinical record. 1104 HEMATOLOGIC SYSTEM is an example of a Header. |
PKA | numeric | 5 | 1 - 99999 | Previously Known As. The unique number of a retired term that has been replaced with a new term. This will be associated with the new term. |
Rdate | character | 8 | ddmmyyyy | The date a term was retired. |
Modified | numeric | 1 | 0 = unchanged 1 = modified | A flag indicating if a term has been changed from the previous version. |
MDate | character | 8 | ddmmyyyy | The date a term was modified |
Parent | numeric | 5 | 1 - 99999 | This refers to the unique number of the term's Parent term |
Preferred | numeric | 5 | 1 - 99999 | This refers to the 'preferred' term for a synonym or an abbreviation |
Chapt | alpha | 1 | A - Z | This is the chapter or system that a term falls under |
l0 | numeric | 2 | 1-99 | "I0" - "I9" are the ASCII codes for the "Chapt" above and are alternatives to "Chapt". |
11 | numeric | 2 | 1-99 | See "I0" above. |
12 | numeric | 2 | 1-99 | See "I0" above. |
13 | numeric | 2 | 1-99 | See "I0" above. |
14 | numeric | 2 | 1-99 | See "I0" above. |
15 | numeric | 2 | 1-99 | See "I0" above. |
16 | numeric | 2 | 1-99 | See "I0" above. |
17 | numeric | 2 | 1-99 | See "I0" above. |
18 | numeric | 2 | 1-99 | See "I0" above. |
19 | numeric | 2 | 1-99 | See "I0" above. |
S | numeric | 2 | 0 or 1 - 99 | This designates a term as a synonym. Zero (0) implies not a synonym. |
Syn | character | 3 | 0 or s1 - s99 | This is the alpha or character equivalent to "S" above. It provides choice for programmers to designate synonyms as alpha or numeric codes. As with "Chapt" and I0, you only need one of "S" or "Syn". |
Ab | numeric | 2 | 0 or 1 - 99 | This designates a term as an abbreviation. Zero (0) implies not an abbreviation. |
ICPC | character | 3 | ANN A = A - Z N = 0 - 9 | These are the ICPC code numbers mapped to each ENCODE-FM™ unique number. |
ICD-10 | character | 5 | ANN.N A = A - Z N = 0 - 9 | These are the ICD-10 code numbers mapped to each ENCODE-FM™ unique number. |
ICD-9CM | character | 5 | ANNNN A = A - Z, 0 - 9 N = " ", 0 - 9 | These are the ICD-9CM code numbers mapped to each ENCODE-FM™ unique number. |
OHIP | numeric | 3 | NNN N = 0 - 9 | The OHIP Fee Schedule Diagnostic Codes mapped to each ENCODE-FM™ unique number. |
Level | numeric | 1 | 0 - 9 | This indicates the level of indentation for each term |
H0 | alpha | 125 | blank or text | The ENCODE-FM™ terms and synonyms are arranged hierarchically across columns H0 to H9 and Synonym. |
H1 | alpha | 125 | blank or text | See H0 above. |
H2 | alpha | 125 | blank or text | See H0 above. |
H3 | alpha | 125 | blank or text | See H0 above. |
H4 | alpha | 125 | blank or text | See H0 above. |
H5 | alpha | 125 | blank or text | See H0 above. |
H6 | alpha | 125 | blank or text | See H0 above. |
H7 | alpha | 125 | blank or text | See H0 above. |
H8 | alpha | 125 | blank or text | See H0 above. |
H9 | alpha | 125 | blank or text | See H0 above. |
Synonym | alpha | 125 | blank or text | See H0 above. |
French | alpha | 135 | text | |
Changes | alpha | 135 | text | Brief explanation of modifications |