{ "_id": "6ac9176bde46216d5edd975a", "Package": "CommonDataModel", "Type": "Package", "Title": "OMOP CDM DDL and Documentation Generator", "Version": "1.1.0", "Authors@R": "person(given = \"Clair\",\nfamily = \"Blacketer\",\nrole = c(\"aut\", \"cre\"),\nemail = \"mblacke@its.jnj.com\")", "Maintainer": "Clair Blacketer ", "Description": "Generates the scripts required to create an Observational\nMedical Outcomes Partnership (OMOP) Common Data Model (CDM)\ndatabase and associated documentation for supported database\nplatforms. Leverages the 'SqlRender' package to convert the\nData Definition Language (DDL) script written in parameterized\nStructured Query Language (SQL) to the other supported\ndialects.", "License": "Apache License 2.0", "Encoding": "UTF-8", "NeedsCompilation": "no", "Config/testthat/edition": "3", "Config/roxygen2/version": "8.1.0", "Packaged": { "Date": "2026-10-09 16:29:22 UTC", "User": "root" }, "Author": "Clair Blacketer [aut, cre]", "Repository": "https://cran.r-universe.dev", "Date/Publication": "2026-10-09 08:20:02 UTC", "RemoteUrl": "https://github.com/cran/CommonDataModel", "RemoteRef": "HEAD", "RemoteSha": "62c9394a77a305a0b25e65968b933fbac4be5c24", "_user": "cran", "_type": "src", "_file": "CommonDataModel_1.1.0.tar.gz", "_fileid": "https://r2.ropensci.org/ff2dd7ca4127ad0a360642319a41982a75d9fc7de60e78a2cb604b1e4d6d76c5", "_filesize": 542507, "_sha256": "ff2dd7ca4127ad0a360642319a41982a75d9fc7de60e78a2cb604b1e4d6d76c5", "_expires": "2027-01-17T16:33:45.000Z", "_created": "2026-10-09T16:29:22.000Z", "_published": "2026-10-09T16:33:47.360Z", "_buildurl": "https://github.com/r-universe/cran/actions/runs/37959112431", "_status": "success", "_host": "GitHub-Actions", "_jobs": [ { "job": 113918489233, "time": 156, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "11630242927" }, { "job": 113918489438, "time": 133, "config": "linux-release-x86_64", "r": "4.6.1", "check": "OK", "artifact": "11631262669" }, { "job": 113917273002, "time": 178, "config": "source", "r": "4.6.1", "check": "OK", "artifact": "11630212202" }, { "job": 113918489262, "time": 122, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "11631197398" }, { "job": 113918489201, "time": 73, "config": "windows-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "11630422221" }, { "job": 113918489128, "time": 94, "config": "windows-release-x86_64", "r": "4.6.1", "check": "OK", "artifact": "11630142484" } ], "_upstream": "https://github.com/cran/CommonDataModel", "_commit": { "id": "62c9394a77a305a0b25e65968b933fbac4be5c24", "author": "Clair Blacketer ", "committer": "cran-robot ", "message": "version 1.1.0\n", "time": 1791534002 }, "_maintainer": { "name": "Clair Blacketer", "email": "mblacke@its.jnj.com" }, "_distro": "resolute", "_registered": true, "_dependencies": [ { "package": "R", "version": ">= 4.1.0", "role": "Depends" }, { "package": "DatabaseConnector", "role": "Imports" }, { "package": "SqlRender", "role": "Imports" }, { "package": "stringr", "role": "Imports" }, { "package": "readr", "role": "Imports" }, { "package": "DBI", "role": "Suggests" }, { "package": "dplyr", "role": "Suggests" }, { "package": "knitr", "role": "Suggests" }, { "package": "rmarkdown", "role": "Suggests" }, { "package": "RSQLite", "role": "Suggests" }, { "package": "testthat", "version": ">= 3.0.0", "role": "Suggests" }, { "package": "withr", "role": "Suggests" } ], "_owner": "cran", "_selfowned": false, "_usedby": 1, "_updates": [ { "week": "2026-41", "n": 1 } ], "_tags": [ { "name": "1.1.0", "date": "2026-10-09" } ], "_stars": 0, "_userbio": { "uuid": 6899542, "type": "organization", "name": "cran", "followers": 629, "description": "Unofficial read-only mirror of all CRAN R packages" }, "_downloads": { "count": 1121, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/CommonDataModel" }, "_searchresults": 12, "_topics": [ "openjdk" ], "_rbuild": "4.6.1", "_assets": [ "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/CommonDataModel.html", "extra/contents.json", "extra/manual.pdf", "extra/NEWS.html", "extra/NEWS.txt", "extra/readme.html", "extra/readme.md" ], "_realowner": "cran", "_cranurl": false, "_releases": [ { "version": "0.2.0", "date": "2024-02-07" }, { "version": "1.0.1", "date": "2024-10-01" }, { "version": "1.1.0", "date": "2026-10-09" } ], "_exports": [ "buildRelease", "buildReleaseZip", "createDdl", "createForeignKeys", "createPrimaryKeys", "downloadCurrentDdl", "executeDdl", "listSupportedDialects", "listSupportedVersions", "parseWiki", "writeDdl", "writeForeignKeys", "writeIndex", "writePrimaryKeys" ], "_help": [ { "page": "buildRelease", "title": "Create OMOP CDM SQL files", "topics": [ "buildRelease" ] }, { "page": "buildReleaseZip", "title": "Create OMOP CDM release zip", "topics": [ "buildReleaseZip" ] }, { "page": "createDdl", "title": "Create the OHDSI-SQL Common Data Model DDL code", "topics": [ "createDdl", "createForeignKeys", "createPrimaryKeys" ] }, { "page": "downloadCurrentDdl", "title": "Get current DDL sitting on the main branch", "topics": [ "downloadCurrentDdl" ] }, { "page": "executeDdl", "title": "Generate and execute the DDL on a database", "topics": [ "executeDdl" ] }, { "page": "listSupportedDialects", "title": "List RDBMS dialects supported by this package", "topics": [ "listSupportedDialects" ] }, { "page": "listSupportedVersions", "title": "List CDM versions supported by this package", "topics": [ "listSupportedVersions" ] }, { "page": "parseWiki", "title": "Parse Wiki files", "topics": [ "parseWiki" ] }, { "page": "writeDdl", "title": "Write DDL script", "topics": [ "writeDdl", "writeForeignKeys", "writeIndex", "writePrimaryKeys" ] } ], "_readme": "https://github.com/cran/CommonDataModel/raw/HEAD/README.md", "_rundeps": [ "backports", "bit", "bit64", "blob", "checkmate", "cli", "clipr", "cpp11", "crayon", "DatabaseConnector", "DBI", "dbplyr", "digest", "dplyr", "generics", "glue", "hms", "lifecycle", "magrittr", "pillar", "pkgconfig", "prettyunits", "progress", "purrr", "R6", "Rcpp", "readr", "rJava", "rlang", "SqlRender", "stringi", "stringr", "tibble", "tidyr", "tidyselect", "triebeard", "tzdb", "urltools", "utf8", "vctrs", "vroom", "withr" ], "_sysdeps": [ { "shlib": "libjvm", "package": "openjdk-25-jre-headless", "headers": "openjdk-25-jre-headless", "source": "openjdk", "version": "25.0.4.1+1-1~26.04.4", "name": "openjdk", "homepage": "https://openjdk.java.net/", "description": "OpenJDK Java runtime, using Hotspot JIT (headless)" } ], "_score": 2.304878117698279, "_indexed": true, "_nocasepkg": "commondatamodel", "_universes": [ "cran" ], "_previous": "1.0.1", "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "1.1.0", "date": "2026-10-09T16:32:12.000Z", "distro": "resolute", "commit": "62c9394a77a305a0b25e65968b933fbac4be5c24", "fileid": "https://r2.ropensci.org/b651da34c0cf61918740ae1081b5b7ca96986771468bacc0ec07bfd8b027638b", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cran/actions/runs/37959112431" }, { "r": "4.6.1", "os": "linux", "version": "1.1.0", "date": "2026-10-09T16:32:08.000Z", "distro": "resolute", "commit": "62c9394a77a305a0b25e65968b933fbac4be5c24", "fileid": "https://r2.ropensci.org/3633b1095d06a922e4dff31b656b935c7bade27bc4ea0219f488e18de3948812", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cran/actions/runs/37959112431" }, { "r": "4.6.0", "os": "wasm", "version": "1.1.0", "date": "2026-10-09T16:31:57.000Z", "commit": "62c9394a77a305a0b25e65968b933fbac4be5c24", "fileid": "https://r2.ropensci.org/662c25dbbd7147731b4051398d68765b7ac8a4a11b84efc935d504b8e927fed9", "status": "success", "buildurl": "https://github.com/r-universe/cran/actions/runs/37959112431" }, { "r": "4.7.0", "os": "win", "version": "1.1.0", "date": "2026-10-09T16:30:34.000Z", "commit": "62c9394a77a305a0b25e65968b933fbac4be5c24", "fileid": "https://r2.ropensci.org/848a538522815793995a8ced7d30be495bacccf12aeeb4415e67c2a822d89a8f", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cran/actions/runs/37959112431" }, { "r": "4.6.1", "os": "win", "version": "1.1.0", "date": "2026-10-09T16:30:45.000Z", "commit": "62c9394a77a305a0b25e65968b933fbac4be5c24", "fileid": "https://r2.ropensci.org/d270f5a539b538140927cdda28c08dc0eea268bb0cf1b348b73cac49be4a414d", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cran/actions/runs/37959112431" } ] }