Page History

Versions Compared

Key

This line was added.
This line was removed.
Formatting was changed.

The following topics are included in this page.

Please note that the query parameter for the "model" attribute is a "Like" query with a wildcard to the right '<model>%%'. So "PCOR" finds "PCORNet CDM 4.0", "CRDC" finds "All CRDC Standard Data Elements". Models are currently represented in caDSR using a Classification Scheme, the Classification Scheme Name is the Model Name, the Classification Scheme Version is used to represent the specific version of the Model. The Table names in the Model are represented using a Classification Scheme Item Name and Version. CDEs are classified by one or more Classification Scheme/Classification Scheme Item, so the same CDE can be in one or more models.

The returned content is our first pass at what end user wanted to know. We can add additional information about the CDEs into the APIs based on customer requirements, as long as the information is registered in caDSR.

in these APIs, mappings between CDEs are based on common semantic annotations that are used when creating the CDEs. The annotation are made using NCI Thesaurus Concepts Codes instead of direct model-model, CDE-CDE mappings. The addition of more complex mappings that are not soley based on 1-1 semantics is being investigated for future expansion of these capabilities.

Numbered Headings

start-numbering-with	5
start-numbering-at	h2

Panel

title	Contents of This Page

Table of Contents

maxLevel	3

Get Target CDM Mapped Data Element Name

The ModelMappedElements parameter retrieves all the Target data elements that have been mapped between a specific Source table/attribute and the Target model.

The following table lists the input components and an example value for each component:

Input Component	Example
Source Model	OMOP
Source Model Version	5.3.1
Source Table	Person
Source Attribute	gender_concept_id
Target Model	PCORnet
Target Model Version	4

The example input requests the table/attribute in PCORnet 4.0 that has been mapped to OMOP 5.3.1 element Person/gender_concept_id.

The following table lists the output components and an example value for each component:

Output Component	Example
SourcePublicID	6144640
SourceVersion	1
TargetPublicID	6144639
TargetVersion	1
TargetTable	DEMOGRAPHIC
TargetAttribute	SEX

For this example, the output indicates that the element DEMOGRAPHIC/SEX in PCORnet 4.0 has been mapped to Person/gender_concept_id in OMOP 5.3.1.

Code Block

https://cadsrapi.cancer.gov/invoke/caDSRII.ModelApi/GetXML?query=ModelMappedElements[@model=OMOP,@version=5.31,@table=Person,@attributeName=gender_concept_id,@targetModelName=PCORnet,@targetModelVersion=4]

Get Target CDM Data Element and Permitted Value

The ModelMappedValues parameter retrieves the mapped permissible value for a particular Data Element between the Source and Target models.

The following table lists the input components and an example value for each component:

Input Component	Example
Source Model	OMOP
Source Model Version	5.31
Source Table	Person
Source Attribute	gender_concept_id
Source Value	F
Target Model	PCORnet
Target Model Version	4

The example input requests the equivalent permissible value for a CDE in PCORnet model, version 4 that has been mapped to OMOP Model version 5.31 Table = Person, OMOP Name =gender_concept_id, with permissible value "F".

Representation in caDSR of "model" elements:

The commonly-used short model name and version is stored in the CS Preferred Name/short name in the Context for the Project.
The table name is stored as the CSI Long Name, and also as an alternate Name for each data element with a name type of the model.

For example, in Data Element 6144640 version 1:

Owning Context = CDMH Phase I
DE is classified by CS/CSI "OMOP 5.31/Person"
DEC = 3175307
DE Short Name/Preferred Name = gender_concept_id, Alternate name type="OMOP Name"
DE Alternate name = PERSON, Alternate name type = "OMOP Table"

The following table lists the output components and an example value for each component:

Output Component	Example
PublicID	6144639
Version	1
TargetTable	DEMOGRAPHIC
TargetAttribute	SEX
TargetValue	F
TargetValueConcept	C16576

For this example, the output indicates that PCORnet 4.0 table Demographic attribute "sex" with value "F" has been mapped to OMOP 5.31 table Person attribute gender_concept_id value "F".

Code Block

https://cadsrapi.cancer.gov/invoke/caDSRII.ModelApi/GetXML?query=ModelMappedValues[@model=OMOP,@version=5.31,@table=Person,@attributeName=gender_concept_id,@attributeValue=F,@targetModelName=PCORnet,@targetModelVersion=4]

Get All Target CDM Elements Mapped to Source CDM Table

The ModelMappedTableElements parameter retrieves all the table/attributes in the Source Model table that have been mapped to table/attributes Target Model.

The following table lists the input components and an example value for each component:

Input Component	Example
Source Model	OMOP
Source Model Version	5.3.1
Source Table	Person
Target Model	PCORnet
Target Model Version	4

The example input requests all the mapped data elements from PCORnet version 4.0 that have been mapped to the Person table in OMOP 5.3.1

The following table lists the output components and an example value for each component:

Output Component	Example	Example
SourcePublicID	6144640	6093481
SourceVersion	1	1
SourceAttribute	gender_concept_id	race_concept_id
SourceTable	Person	Person
TargetPublicID	6144639	6093452
TargetVersion	1	1
TargetTable	Demographic	Demographic
TargetAttribute	SEX	RACE

The API returns all mapped attributes.

Code Block
https://cadsrapi.cancer.gov/invoke/caDSRII.ModelApi/GetXML?query=ModelMappedTableElements[@model=OMOP,@version=5.31,@table=Person,@targetModelName=PCORnet,@targetModelVersion=4]

Get All Attributes in a Model

The ModelAttributes parameter retrieves all the data elements that have been recorded in caDSR for a given version of a model.

The following table lists the input components and an example value for each component:

Input Component	Example
Source Model	PCOR
Source Model Version	4.0

The example input retrieves all Data Elements classified by the PCOR 4.0 CS and organized by all of its CSIs.

The following table lists the output components and an example value for each component:

Output Component	Example	Example
Table Name	Condition	Prescribing
Public ID	6365298	6421699
Version	1	1
Attribute	ONSET_DATE	RX_REFILLS

Code Block
https://cadsrapi.cancer.gov/invoke/caDSRII.ModelApi/GetXML?query=ModelAttributes[@model=PCOR,@version=4.0]

...

Content

Space Tools

Versions Compared

Old Version 24

New Version 25

Key

Get Target CDM Mapped Data Element Name

Get Target CDM Data Element and Permitted Value

Get All Target CDM Elements Mapped to Source CDM Table

Get All Attributes in a Model