<Dataset>_WHO_DRUG_CODING

Column Name

Description

EDC_DATASET_NAME

Internal Export Label

EDC_ENVIRONMENT_ID

Environment ID

EDC_SITE_ID

Internal Site ID

EDC_SUBJECT_ID

Internal Subject ID

EDC_VARIABLE_ID

Internal Variable ID

EDC_LOCATION

Generic Path to ObjectID using Object IDs

EDC_OBJECT_ID

Internal Name of eCRF

EDC_ITERATION

Iteration of ObjectID

EDC_FIELD_ID

Internal Field ID

CODED_TERM_DATASET_FIELD_NAME

Export Field Name

CODED_TERM_DATASET_NORMALIZED_FIELD_NAME

Export Normalized Field Name

EDC_EXPORT_NORMALIZED_GROUP

Export Normalized Group

EDC_TREE_NODE_ID

Internal TreeNode ID

INDICATION

Deprecated

ROUTE

Field ID that explains the Means of administering the drug

VERBATIM

User Entered Term

EDITED_TERM

Field the coder used to edit the initial entry

DRUG_NAME

Refers to either a substance name (generic name) or trade name.

PREFERRED_DRUG_NAME

The preferred term for coded data

DRUG_RECORD_NUMBER

???

ATCCODE

The Anatomical Therapeutic Chemical code: a unique code assigned to a medicine according to the organ or system it works on and how it works. The classification system is maintained by the World Health Organization (WHO). Code that combines ATC Text 1 through 4

ATCTEXT1

One of the system’s fourteen main anatomical or pharmacological groups (1st level)

ATCTEXT2

Pharmacological or Therapeutic subgroup

ATCTEXT3

Chemical, Pharmacological or Therapeutic subgroup

ATCTEXT4

Chemical, Pharmacological or Therapeutic subgroup

SEQ1

 

SEQ2

 

EDC_CODING_EXCEPTION

If the Exception box is checked in the auto encoder for the coding record based on Status bit 1

EDC_CODING_VERIFIED

If the verified box is checked in the auto encoder for the coding record based on Status bit 2

EDC_CODING_SOURCE

Source of the coding record

EDC_CODING_ENTRY_USER

Entry User of the coding record

EDC_CODING_LAST_UPDATED_DATE

Entry Date of the coding record

EDC_CODING_AUDIT_COMMENT

Audit Comment of the coding record

 


 

Related Topics

Self Service Tables


Copyright (c) 2022 Clario. All Rights Reserved.