Get Target CDM Mapped Data Element Name
The ModelMappedElements API retrieves all the Target data elements that have been mapped between a specific Source table/attribute and the Target model.
Input: Source Model Name/Version/Table Name/Attribute Name/Target Model Name/Version
Output: Target Model Name/Version/Mapped Element Table Name/Mapped Attribute Name
Input Example: OMOP/5.3.1/Person/gender_concept_id/PCORnet/4.0
This example requests the table/attribute in PCORnet 4.0 that has been mapped to OMOP 5.3.1 element Person/gender_concept_id.
Output Example: same style as ModelMappedValues
For this example, the output indicates that the element Patient/gender in PCORnet 4.0 has been mapped to Person/gender_concept_id in OMOP 5.3.1.
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 API retrieves the mapped permissible value for a particular Data Element between the Source and Target models.
Input: Source Model Name/Version/Table Name/Attribute Name/Value/Target Model Name/Version
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: 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"
Output: Target Model Name/Version/Mapped Table Name/Mapped Attribute Name/Mapped Value
Input Example: OMOP/5.31/Person/gender_concept_id/F/PCORnet/4.0
This example 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".
Output Example: PCORnet/4.0/DEMOGRAPHIC/SEX/F
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".
cadsrapi.cancer.gov/invoke/caDSRII.ModelApi/GetXML?query=ModelMappedValues[@model=OMOP,@version=5.31,@table=Person,@attributeName=race_concept_id,@attributeValue=2,@targetModelName=PCORnet,@targetModelVersion=4] |
Get All Target CDM Elements Mapped to Source CDM Table
The ModelMappedTableElements API retrieves all the table/attributes in the Source Model table that have been mapped to table/attributes Target Model.
For example: Get all data elements for Person table in OMOP 5.3.1 where mappings exist for PCORNET Version 4.
Input: Source Model Name/Version/Table Name/Target Model Name/Version
Output: Source Model Name/Version/Table Name/Target Model Name/Version/Target Table Name/Attribute name/caDSR Public ID and Version
Input example: OMOP/5.3.1/Person/PCORnet/4.0
This example requests all the mapped data elements from PCORnet version 4.0 that have been mapped to the Person table in OMOP 5.3.1
For this example, some of the output is as follows:
OMOP/5.3.1/Person/gender_concept_ID/PCORnet/4.0/Person/Gender
OMOP/5.3.1/Person/ethnicity/PCORnet/4.0/Person/ethnicity
All the mapped attributes are returned.
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 API retrieves all the data elements that have been recorded in caDSR for a given version of a model.
Input: Data Model Name/Version
Output: Each Data Element within its Data Model/Version/Table Name/{each data element name, public id, version}
Input Example: OMOP/5.3.1
This example retrieves all Data Elements classified by the OMOP 5.3.1 CS and organized by all of its CSIs.
For this example, some of the output OMOP/5.3.1 data elements are as follows:
OMOP/5.31/PERSON/gender_concept_id
OMOP/5.3.1?PERSON/ethnicity_concept_id
OMOP/5.3.1/PERSON/race_source_value
OMOP/5.3.1/DRUG_EXPOSURE/refills
OMOP/5.3.1/DRUG_EXPOSURE/days_supply
https://cadsrapi.cancer.gov/invoke/caDSRII.ModelApi/GetXML?query=ModelAttributes[@model=PCOR,@version=4.0] |