You can create a syntactic mapping that uses a subset of already-mapped data. This is helpful if you want to do a data science project on a subset of data where you do not need the full OMOP mapping.
To complete this, you will first need to create a data schema, then create a new syntactic mapping.
Prerequisites
Before you start, an existing data model should have already been created. You should know which fields you want to use in your data subset.
Create a New Data Schema
- Select the project that contains the syntactic mapping of the data.
- Select Data Schemas from the menu on the left.
- Select Create New Data Schema button in the upper right corner.
- Enter the name and description of the data schema.
- Select the Create Blank Data Schema or Upload From File button. If you want to create your own schema from scratch, select create blank data schema. If you have a CSV file, select Upload from File and select the file from your computer or device.
- Select the Create New Data Schema button. The schema appears. If you selected the Create Blank Data Schema button, a blank schema will appear like the following. If you chose Upload From File button, you’ll see the fields from your CSV file.
- Next, add the name of the Schema Field, Identifier, Description, Role, Type, Type Params, Units, May Contain PHI, Permissions.
- To add additional fields, select the Add Fields button.
- When complete, click Save.
- Create a new Syntactic Mapping by following instructions in Creating a Syntactic Mapping. Make sure that the target data model is Custom. Select the new schema that you created in the previous steps for the Target field.