Data Collection Definitions

Belgian Early Warning System for Drugs (BEWSD)

  • Start date: 31/12/2015
Full viewCSV column namesValidation rulesReference listsComputed expressionsAdditional informationCSV extract

1 Generic information

choice

Nature of the sample

Technical specs

CSV column name:

nature_of_the_sample

Required:

true

Options
LabelValue
Biologicalbiological
Collectioncollection
Confiscationconfiscation
Otherother
Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.LaboratoryTestResult

Data element:

CollectionMethod

Nested option fields
  • When other Is selected:
    text

    Additional information on the nature of the sample

    Help

    Free text to provide more information in case the "Nature of sample" is equal to "Other"

    Technical specs

    CSV column name:

    nature_of_the_sample|additional_information_on_the_nature_of_the_sample

    Length:

    300

    Required:

    false

    Mapping of the clinical building blocks (indicative only)

    Concept:

    be.en.hd.LaboratoryTestResult

    Data element:

    Comment

text

Case ID

Help

Case ID: general case number. Allows to link e.g. multiple samples from the same judicial file.

Technical specs

CSV column name:

case_id

Length:

40

Required:

false

Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.LaboratoryTestResult

Data element:

SpecimenId

text

Secondary case ID

Help

Only for use by NICC-INCC

Technical specs

CSV column name:

secondary_case_id

Length:

40

Required:

false

Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.LaboratoryTestResult

Data element:

SpecimenId

text

Unique sample ID

Help

Unique sample ID : lab reference that uniquely identifies this sample/analysis

Technical specs

CSV column name:

unique_sample_id

Length:

40

Required:

true

Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.LaboratoryTestResult

Data element:

SpecimenId

date

Receival date

Help

Date the sample was received by the lab

Technical specs

Format:

DD/MM/YYYY

CSV column name:

receival_date

Required:

true

Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.LaboratoryTestResult

Data element:

CollectionDateTime

Validation
  • Date of receival cannot be after the current date (error)
  • Receival date cannot be after Analysis date (error)
choice

Requester of the analysis

Technical specs

CSV column name:

requester_of_the_analysis

Required:

true

Options
LabelValue
Treating physiciantreatingphysician
Policepolice
Customscustoms
Magistratemagistrate
Otherother
Nested option fields
  • When treatingphysician Is selected:
    text

    Additional information on the requestor analysis (treating physician)

    Technical specs

    CSV column name:

    requester_of_the_analysis|additional_information_on_the_requestor_analysis_treating_physician

    Length:

    300

    Required:

    true

    Mapping of the clinical building blocks (indicative only)

    Concept:

    be.en.hd.HealthProfessional

    Data element:

    HealthProfessionalIdentificationNumber

  • When police Is selected:
    text

    Additional information on the requestor analysis (police)

    Technical specs

    CSV column name:

    requester_of_the_analysis|additional_information_on_the_requestor_analysis_police

    Length:

    30

    Reference list:

    POLICE

    Required:

    false

  • When customs Is selected:
    text

    Additional information on the requestor analysis (customs)

    Technical specs

    CSV column name:

    requester_of_the_analysis|additional_information_on_the_requestor_analysis_customs

    Length:

    30

    Reference list:

    CUSTOMS

    Required:

    true

  • When magistrate Is selected:
    text

    Judicial district

    Technical specs

    CSV column name:

    requester_of_the_analysis|judicial_district

    Length:

    30

    Reference list:

    MAGISTRATE

    Required:

    true

  • When other Is selected:
    text

    Additional information on the requestor analysis (other)

    Technical specs

    CSV column name:

    requester_of_the_analysis|additional_information_on_the_requestor_analysis_other

    Length:

    300

    Required:

    true

fieldset

Contact information of the requester of the analysis

Fields
text

Name

Technical specs

CSV column name:

contact_information_of_the_requester_of_the_analysis|name

Length:

100

Required:

false

text

Phone Number

Technical specs

CSV column name:

contact_information_of_the_requester_of_the_analysis|phone_number

Length:

30

Required:

false

text

City of origin of the sample

Help

Place of death or place of seizure of the sample

Technical specs

CSV column name:

city_of_origin_of_the_sample

Length:

30

Reference list:

POSTAL_CODE

Required:

true

boolean

Victim deceased?

Technical specs

CSV column name:

victim_deceased

Only when:

Required:

true

Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.Patient

Data element:

DeathIndicator

Options
LabelValue
YesTRUE
NoFALSE
choice

Sample forwarded by another laboratory for extended analysis?

Technical specs

CSV column name:

sample_forwarded_by_another_laboratory_for_extended_analysis

Required:

false

Options
LabelValue
Yesyes
Nono
Nested option fields
  • When yes Is selected:
    text

    Origin

    Help

    E.g. The name of the laboratory that forwarded the sample to your laboratory

    Technical specs

    CSV column name:

    sample_forwarded_by_another_laboratory_for_extended_analysis|origin

    Length:

    300

    Required:

    false

2 Sample

choice

Form

Technical specs

CSV column name:

form

Only when:

Required:

true

Options
LabelValue
Bloodblood
Urineurine
Hairhair
Salivasaliva
Body partsbodyparts
Otherother
Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.LaboratoryTestResult

Data element:

SpecimenMaterial

Nested option fields
  • When other Is selected:
    text

    Additional information on form

    Technical specs

    CSV column name:

    form|additional_information_on_form

    Length:

    300

    Required:

    false

choice

Sample nature

Technical specs

CSV column name:

sample_nature

Only when:

Required:

true

Options
LabelValue
Crystalcrystal
Powderpwd
Pastepaste
Tablettab
Capsulecap
Liquidliq
Plant Materialvegetable_material
Resinresin
Otherother
Nested option fields
  • When tab Is selected:
    number

    Tablet weight

    Technical specs

    CSV column name:

    sample_nature|tablet_weight

    Only when:

    Required:

    false

    number

    Diameter (mm)

    Help

    Provide the diameter of tablets with a circular shape

    Technical specs

    CSV column name:

    sample_nature|diameter_mm

    Length:

    10

    Only when:

    Required:

    false

    number

    Length (mm)

    Help

    Provide the length of tablets with a non-circular shape

    Technical specs

    CSV column name:

    sample_nature|length_mm

    Length:

    10

    Only when:

    Required:

    false

    number

    Width (mm)

    Help

    Provide the width of tablets with a non-circular shape

    Technical specs

    CSV column name:

    sample_nature|width_mm

    Length:

    10

    Only when:

    Required:

    false

    number

    Thickness (mm)

    Technical specs

    CSV column name:

    sample_nature|thickness_mm

    Length:

    10

    Required:

    false

    choice

    Shape

    Technical specs

    CSV column name:

    sample_nature|shape

    Required:

    false

    Options
    LabelValue
    Roundround
    Ovaloval
    Triangletriangle
    Squaresquare
    Pentagonpentagon
    Hexagonhexagon
    Octagonoctagon
    Otherother
    number

    Quantity

    Help

    The quantity of tablets that were confiscated

    Technical specs

    CSV column name:

    sample_nature|quantity

    Length:

    10

    Required:

    false

  • When other Is selected:
    text

    Additional information on the sample

    Technical specs

    CSV column name:

    sample_nature|additional_information_on_the_sample

    Length:

    300

    Required:

    false

text

Color

Technical specs

CSV column name:

color

Length:

50

Only when:

Required:

false

number

Total weight of seizure / shipment / tablets

Technical specs

CSV column name:

total_weight_of_seizure__shipment__tablets

Length:

10.5

Only when:

Required:

false

Validation
  • The minimum value is 0 (warning)
choice

Weight unit total

Technical specs

CSV column name:

weight_unit_total

Only when:

Required:

false

Options
LabelValue
mgmg
gg
kgkg
mLmL
LL
Pieces / itemspieces__items
date

Analysis date

Technical specs

Format:

DD/MM/YYYY

CSV column name:

analysis_date

Required:

true

Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.LaboratoryTestResult

Data element:

TestDateTime

Validation
  • Receival date cannot be after Analysis date (error)
  • Analysis date cannot be after the current date (error)
multichoice

Analysis method

Technical specs

CSV column name:

analysis_method

Required:

false

Options
LabelValue
Enzymaticenzymatic
Immunoassayimmunoassay
GC/FIDgcfid
GC/NPDgcnpd
GC/MSgcms
GC/MS-MSgcmsms
GC/QTOFgcqtof
LC/MSlcms
LC/MS-MSlcmsms
LS/QTOFlsqtof
FTIRftir
HPLC-UVhplcuv
HPLC-UV-DADhplcuvdad
HPLChplc
HPLC-Fluohplcfluo
Otherother
Nested option fields
  • When other Is selected:
    text

    Please specify

    Technical specs

    CSV column name:

    analysis_method|please_specify

    Length:

    300

    Required:

    false

text

Additional information on the analysis method

Help

E.g. Different methods used for identification and quantification

Technical specs

CSV column name:

additional_information_on_the_analysis_method

Length:

300

Required:

false

choice

Derivatisation for analysis

Technical specs

CSV column name:

derivatisation_for_analysis

Required:

false

Options
LabelValue
Yesyes
Nono
Otherother
Nested option fields
  • When yes Is selected:
    text

    Specify method of derivatisation

    Technical specs

    CSV column name:

    derivatisation_for_analysis|specify_method_of_derivatisation

    Length:

    300

    Required:

    false

  • When other Is selected:
    text

    Please specify

    Technical specs

    CSV column name:

    derivatisation_for_analysis|please_specify

    Length:

    300

    Required:

    false

list

Sample substances

This is a container for multiple answers. See the reference documentation for more details. Below you can find the information about the fields of the container

Element conditions
MessageExpression
Concentration in % must be between 0 and 110$.concentration_unit.selectedOption === '%' && typeof $.concentration === 'number'?$.concentration >= 0 && $.concentration
ID of the active substance: Format of the LOINC code must be 'nnnnn-n'$.type_of_id_of_the_active_substance.selectedOption === 'L'?!isNaN($.id_of_the_active_substance.substr(0,5)) && $.id_of_the_active_substance.substr(5,1) === '-' && !isNaN($.id_of_the_active_substance.substr(6,1)) && $.id_of_the_active_substance.substr(6,1) !== '' && $.id_of_the_active_substance.length === 7:true
List items
choice

Substance

Technical specs

CSV column name:

sample_substances|0|substance

Default value:

drugs_new_psychoactive_substance

Required:

false

Options
LabelValue
Drugs and new psychoactive substancesdrugs_new_psychoactive_substance
Medication and health productmedication_and_health_product
Alcoholalcohol
Otherother
Nested option fields
  • When other Is selected:
    text

    Additional information on substance

    Technical specs

    CSV column name:

    sample_substances|0|substance|additional_information_on_substance

    Length:

    300

    Required:

    false

choice

Type of ID of the active substance

Technical specs

CSV column name:

sample_substances|0|type_of_id_of_the_active_substance

Default value:

C

Only when:

Required:

false

Options
LabelValue
LOINCL
IUPACI
Chemical NameC
CASCAS
OtherO
text

ID of the active substance

Technical specs

CSV column name:

sample_substances|0|id_of_the_active_substance

Length:

100

Only when:

Required:

true

Mapping of the clinical building blocks (indicative only)

Concept:

be.en.hd.DrugUse

Data element:

DrugOrMedicationType

number

Concentration

Technical specs

CSV column name:

sample_substances|0|concentration

Length:

10.5

Required:

false

Validation
  • The minimum value is 0 (warning)
choice

Concentration unit

Technical specs

CSV column name:

sample_substances|0|concentration_unit

Default value:

%

Required:

false

Options
LabelValue
mgmg
gg
mLmL
mg/Lmg/L
g/Lg/L
microgr/Lmicrogr/L
nanogr/Lnanogr/L
g/mLg/mL
mg/mLmg/mL
microgr/mLmicrogr/mL
nanogr/mLnanogr/mL
mg/gmg/g
microgr/gmicrogr/g
nanogr/gnanogr/g
microgr/mgmicrogr/mg
nanogr/mgnanogr/mg
nanog/mg (hair)nanog/mg (hair)
%%
%ww%ww
%v/v %v/v
text

Comments to the BEWSD regarding this sample

Technical specs

CSV column name:

comments_to_the_bewsd_regarding_this_sample

Length:

300

Required:

false

Validation
  • Length of comments to the BEWSD regarding this sample cannot be longer than 1000 characters (error)

3 Attachments

attachment

Attachments

Technical specs

CSV column name:

attachments

Required:

false