INSITE Family Medicine Inc.

ENCODE-FM™ Spreadsheet Specifications

Name: INSITE Family Medicine Inc.
Address: 1943 Wembley Avenue, Ottawa, Ontario, K2A 1A8, Canada
Telephone: 6137227325

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

Created by

Legal notice