AI‐READI Survey Data Element Mapping Table Guide

AI-READI value-set mapping table Explained

Survey Data Source Columns

Source	comments
FORM_NAME	survey instrument form name
FIELD_ID	RedCap form defines an id value for each data element field within a form
SOURCE_CODE	string id value used to identify the survey data element
SOURCE_CODE_ID	Key id value used to identify the survey data element
SOURCE_CODE_DESCRIPTION	source data element description

Survey Data Target Columns ( i.e. Maps to )

TARGET	comments
TARGET_CONCEPT_ID	concept id to target concept, key to the target concept to which the source code is being mapped
TARGET_CONCEPT_NAME	concept name to target concept
TARGET_DOMAIN_ID	OMOP domain id of the target concept
TARGET_VOCABULARY_ID	key value to the OMOP vocabulary table defining the vocabulary of the target concept
TARGET_CONCEPT_CLASS_ID	key value to the OMOP concept class of the target concept
TARGET_STANDARD_CONCEPT	standard concept
TARGET_CONCEPT_CODE	target conccept code
PREDICATE_ID	The predicate_id in an SSSOM mapping table is a unique identifier for the relationship (or predicate) that describes how the source concept (e.g., a REDCap survey question or variable) is related to the target concept (e.g., a standard terminology concept like SNOMED CT or OHDSI Athena concept_id) Predicate IDs are often drawn from ontologies like SKOS (Simple Knowledge Organization System), OWL (Web Ontology Language), or custom vocabularies. Examples include: skos:exactMatch: The source and target concepts are equivalent (e.g., a REDCap variable "Marital Status" maps exactly to SNOMED CT 125680007). skos:closeMatch: The concepts are very similar but not identical. skos:broadMatch or skos:narrowMatch: The source concept is broader or narrower than the target.
CONFIDENCE	The confidence level in an SSSOM mapping table is a numerical value, typically between 0.0 and 1.0, that represents the degree of certainty that the mapping between two concepts is correct or appropriate. It reflects the reliability of the relationship specified by the predicate_id (e.g., skos:exactMatch, skos:closeMatch) and is used to inform users or systems about the level of confidence of the mapping.
QUALIFIER_CONCEPT_ID	In AI-READI concept mappings, the concept_id may not fully capture post-coordination or laterality (e.g., left eye vs. right eye for visual acuity tests). The qualifier_concept_id column is used to specify these additional attributes, enhancing the precision of mappings to standard terminologies like SNOMED CT or LOINC.
QUALIFIER_SOURCE_VALUE	The actual string value of the qualifier_concept_id