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 |