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.
The following table lists the input parameters and an example value for each parameter:
| Parameter | Example |
|---|---|
| Source Model Name | OMOP |
| Version | 5.3.1 |
| Table Name | Person |
| Attribute Name | gender_concept_id |
| Target Model Name | PCORnet |
| 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 parameters and an example value for each parameter:
| Parameter | Example |
|---|---|
| Target Model Name | PCORnet |
| Version | 4.0 |
| Mapped Element Table Name | Patient |
| Mapped Attribute Name | gender |
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-qa.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.
The following table lists the input parameters and an example value for each parameter:
| Parameter | Example |
|---|---|
| Source Model Name | OMOP |
| Version | 5.31 |
| Table Name | Person |
| Attribute Name | gender_concept_id |
| Value | F |
| Target Model Name | PCORnet |
| Version | 4.0 |
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 parameters and an example value for each parameter:
| Parameter | Example |
|---|---|
| Target Model Name | PCORnet |
| Version | 4.0 |
| Mapped Table Name | DEMOGRAPHIC |
| Mapped Attribute Name | SEX |
| Mapped Value | 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-qa.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.
The following table lists the input parameters and an example value for each parameter:
| Parameter | Example |
|---|---|
| Source Model Name | OMOP |
| Version | 5.3.1 |
| Table Name | Person |
| Target Model Name | PCORnet |
| Version | 4.0 |
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 parameters and an example value for each parameter:
| Parameter | Example | Example |
|---|---|---|
| Source Model Name | OMOP | OMOP |
| Version | 5.3.1 | 5.3.1 |
| Table Name | Person | Person |
| Target Model Name | gender_concept_ID | ethnicity |
| Version (TBD) | PCORnet (TBD) | PCORnet (TBD) |
| Target Table Name (TBD) | 4.0 (TBD) | 4.0 (TBD) |
| Attribute Name | Person | Person |
| caDSR Public ID and Version (TBD) | Gender (TBD) | ethnicity (TBD) |
The API returns all mapped attributes.
https://cadsrapi-qa.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
The example input 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-qa.cancer.gov/invoke/caDSRII.ModelApi/GetXML?query=ModelAttributes[@model=PCOR,@version=4.0] |