Søgning » Årsager til kontaktallergi » union_Testforlob
Tabel

union_Testforlob


Beskrivelse ?

Table for tests, one to many to Plaster, many to one to Person. For reaserch datasets, job is coales

Størrelse (Antal rækker) ?

147772

Indhold (Kolonner/variable) ?

Navn Indhold
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