Page History
...
Step 3: ACT-OMOP v4
...
ontology data load and Views creation process
- Edit the edu.harvard.i2b2.data\Release_1-7\NewInstall\Metadata\db.properties file to update the project properties to 'ACT_OMOP' ; db.project=ACT_OMOP
- From the edu.harvard.i2b2.data\Release_1-7\NewInstall\Metadata folder, run the ant command: ant -f data_build.xml db_metadata_load_data.
- This will execute the SQL scripts from the edu.harvard.i2b2.data\Release_1-7\NewInstall\Metadata\act\scripts\<db type> folder and
- Create and
...
- load ACT-OMOP v4 Ontology metadata tables with indexes.
...
This creates these tables;
ACT_ICD10CM_DX_V4_OMOP ACT_ICD10PCS_PX_V4_OMOP ACT_ICD9CM_DX_V4_OMOP ACT_ICD9CM_PX_V4_OMOP ACT_CPT4_PX_V4_OMOP ACT_HCPCS_PX_V4_OMOP ACT_MED_ALPHA_V4_OMOP ACT_MED_VA_V4_OMOP ACT_MED_VA_V4_OMOP ACT_LOINC_LAB_PROV_V4_OMOP ACT_SDOH_V4_OMOP ACT_VITAL_SIGNS_V4_OMOP ACT_VISIT_DETAILS_V4_OMOP ACT_COVID_V4_OMOP ACT_DEM_V4_OMOP ACT_ICD10_ICD9_DX_V4_OMOP |
Step 4: Create OMOP views.
...
- Creates the ACT-OMOP views by executing BUILD_ACT_OMOP_VIEWS_ALL_MSSQL.sql
...
CONDITION_VIEW; DRUG_VIEW; MEASUREMENT_VIEW; OBSERVATION_VIEW; PROCEDURE_VIEW; COVID_LAB_VIEW; ALL_SOURCE_CONCEPTS; PATIENT_DIMENSION; VISIT_DIMENSION; DEVICE_VIEW; |
...