| aktiv |
Whether or not clinic was active member that test year, evaluated as IIF(v.teststed is null, 0, 1) with left join [dbo].[valSted] v on YEAR(t.UdfortDato) BETWEEN InkluderFraAar and InkluderTilAar and v.Teststed = t.teststed |
| ID0 |
PersonID (must be combined with Teststed to be unique) |
| ID1 |
TestID (must be combined with PersonID and Teststed to be unique) |
| Alder |
Age evaluated DateDiff(year, p.FodselsDato, t.UdfortDato) as Alder |
| Alder_Round |
Age evaluated round((CAST (t.UdfortDato AS INTEGER) - CAST(p.FodselsDato AS INTEGER)) / 365.25, 0) |
| Alder_Exact |
Age evaluated round((CAST (t.UdfortDato AS INTEGER) - CAST(p.FodselsDato AS INTEGER)) / 365.25, 1) |
| RekvirerDato |
Date test was booked |
| TestDato |
Date test was executed |
| TestAar |
Year test was executed |
| Halvaar |
Period test was executed |
| Teststed |
clinic id |
| Stednavn |
Clinic name |
| StillingId |
DISCO code for occupation at test, not for type 'a'databases, which use multiple possible occupations at test date |
| M |
Gender (1 = male, 0=female) |
| O |
occupational related (1=yes,0=no) |
| A |
atopic (1=yes,0=no) |
| H |
hand exzema (1=yes,0=no) |
| L |
leg exzema (1=yes,0=no) |
| F |
face exzema (1=yes,0=no) |
| AA |
Age over 40 years old (1=yes,0=no) |
| spFrisorserie |
patient tested for hairdressers allergens, erratic usage |
| frisorTestet |
calculated value patient tested for hairdressers allergens evaluated iif(t.spFrisorserie = 1 OR IIF(f.id0 is null, 0, 1) = 1, 1, 0) with left join on dbo.getFrisorSerier() |
| IkkeFremmodt |
Whether patient showed up |
| latexprik |
whether latex prick test should be executed (1=yes,0=no) |
| latexrasthr |
whether latex raster test should be executed (1=yes,0=no) |
| latexprik_udfoert |
whether latex prick test was be executed (1=yes,0=no) |
| latexrasthr_udfoert |
whether latex raster test wasbe executed (1=yes,0=no) |
| latexTest |
evaluation if latex tst was executed. Due to erratic field usage, evaluated as: case when (isnull(t.latexprik,0) + isnull(t.latexrasthr,0) + isnull(t.latexprik_udfoert,0) + isnull(t.latexrasthr_udfoert,0)) > 0 then 1 else 0 end |
| eksem_haar |
Exzema location hair (1=yes,0=no) |
| eksem_fod |
Exzema location foot (1=yes,0=no) |
| patientinformation |
complex value for if patient was given information. See 'view_patientinformation' for details. Allergen only |
| InfoAllergen |
Extraction from 'patientinformation' whether information on Allergen was given to patient for type 'a' databases else direct value |
| InfoHEksem |
Extraction from 'patientinformation' whether information on Hand exzema was given to patient for type 'a' databases else direct value |
| VarighedAktuel |
Duration of allergy current (see valVarighed) |
| VarighedDebut |
Begin of allergy (see valVarighed) |
| eksem_oeregang |
Exzema location earchannel (1=yes,0=no) |
| eksem_oejenlaag |
Exzema location eyelid (1=yes,0=no) |
| eksem_perioralt |
Exzema location around mouth (1=yes,0=no) |
| eksem_hals |
Exzema location neck (1=yes,0=no) |
| eksem_arm |
Exzema location arm (1=yes,0=no) |
| eksem_fleksurer |
Exzema location (1=yes,0=no) |
| eksem_overkrop |
Exzema location upper torso (1=yes,0=no) |
| eksem_underkrop |
Exzema location lower torso (1=yes,0=no) |
| eksem_laar |
Exzema location thigh (1=yes,0=no) |
| eksem_Axil |
Exzema location axilla (1=yes,0=no) |
| Standardserie |
Tested with >=15 allergens from standard serie as defined in valSted |
| Basisserie |
Tested with allergen(s) from standard serie as defined in valSted |
| D2ini |
read day 2 user initials, type 'a' database only |
| D3ini |
read day 3 user initials, type 'a' database only |
| D57ini |
read day 5 to 7 user initials, type 'a' database only |
| D2aflaest |
date read day 2 was read |
| D3aflaest |
date read day 3 was read |
| D57aflaest |
date read day 5 to 7 was read |
| job1 |
DISCO code for occupation 1 |
| txt1 |
DISCO description for occupation 1 |
| job2 |
DISCO code for occupation 2 |
| txt2 |
DISCO description for occupation 2 |
| job3 |
DISCO code for occupation 3 |
| txt3 |
DISCO description for occupation 3 |
| job4 |
DISCO code for occupation 4 |
| txt4 |
DISCO description for occupation 4 |