Touchworks 26.1
[dbo].[search]
Sentence form description of each nomenclature medical term. Descriptions are phrased using a positive/abnormal sense using professional terminology. It contains hierarchical information that enables searching. Information is also included that can be utilized for restricting searches to male only, female only, type of finding (test, disease, etc.), and type of therapy (narcotics, surgery, etc.).
| Key | Name | Data Type | Max Length (Bytes) | Nullability | Description |
|---|---|---|---|---|---|
| lang | nvarchar(1) | 2 | NOT NULL | Language indicator of term descriptions: E = English, P = Portuguese, F = French, G = German, S = Spanish, I = Italian, R = Russian | |
 | nodekey | nvarchar(20) | 40 | NOT NULL | Indicates hierarchical level of term. This is unique for each medical term but this field changes as MEDCIN evolves. More about this field is explained in the vocabulary and properties tables. |
 | medcinid | int | 4 | NOT NULL | Permanent id of MEDCIN term (finding id). |
| subs | nvarchar(1) | 2 | NULL allowed | + indicates that lower level nodes exist. When lower level nodes exist, an indicator for users should convey that expansion is possible for this term. | |
| termtype | tinyint | 1 | NOT NULL | Type of medical term: 1 = symptom, 2 = physical exam, 3 = test, 5 = history, 6 = diagnosis, 7 = therapy | |
| rxcode | nvarchar(1) | 2 | NULL allowed | Type of therapy: A = anesthesia, C = counseling and education, D = disposition, E = exposure, F = foods, G = eye glasses or contact lens, H = herbal medicines, I = infusion, M = non-narcotic medication, N = narcotic, O = operative note, P = non surgical procedure, R = consultation with a specialist, S = surgery, T = transfusion, U = uncoded, V = vaccinations, W = work restrictions, X = radiation, Y = allergenic extracts, 9 = exclude from care plan | |
| gender | nvarchar(1) | 2 | NULL allowed | Limits applicable gender of finding: M = male only, F = Female only, = Blank is okay for both genders | |
| description | nvarchar(120) | 240 | NOT NULL | Concise sentence form description of term that is displayed as a result of a search or other prompting. This description presents a positive or abnormal form of the term. Rxcode, gender, and termtype are also in the properties table. They are duplicated here to allow more specific searching without accessing another table. For example, if a search is for findings to enter into a male patients chart, the female only findings should be ignored. |