{ "_id": "6a1d70fe1d7bb097a0a50685", "Package": "CommonDataModel", "Type": "Package", "Title": "OMOP CDM DDL and Documentation Generator", "Version": "1.0.1", "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", "RoxygenNote": "7.2.3", "Config/testthat/edition": "3", "Packaged": { "Date": "2026-06-01 11:43:04 UTC", "User": "root" }, "Author": "Clair Blacketer [aut, cre]", "Repository": "https://cran.r-universe.dev", "Date/Publication": "2024-10-02 02:59:03 UTC", "RemoteUrl": "https://github.com/cran/CommonDataModel", "RemoteRef": "HEAD", "RemoteSha": "5f15a9add81e19e9aa8e6e4f94348fa9c6f1f7ac", "MD5sum": "e6e6a5134c777821f4ce502eab37fe3a", "_user": "cran", "_type": "src", "_file": "CommonDataModel_1.0.1.tar.gz", "_fileid": "3ca055a118faf036228722930230c559ca998f3ce381a581e95c80e08db27c1a", "_filesize": 392600, "_sha256": "3ca055a118faf036228722930230c559ca998f3ce381a581e95c80e08db27c1a", "_created": "2026-06-01T11:43:04.000Z", "_published": "2026-06-01T11:46:06.204Z", "_distro": "noble", "_jobs": [ { "job": 78844808464, "time": 143, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "7330584440" }, { "job": 78844808432, "time": 137, "config": "linux-release-x86_64", "r": "4.6.0", "check": "OK", "artifact": "7330583053" }, { "job": 78844357580, "time": 169, "config": "source", "r": "4.6.0", "check": "OK", "artifact": "7330537085" }, { "job": 78844808446, "time": 144, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "7330584244" } ], "_buildurl": "https://github.com/r-universe/cran/actions/runs/26752502913", "_status": "success", "_host": "GitHub-Actions", "_upstream": "https://github.com/cran/CommonDataModel", "_commit": { "id": "5f15a9add81e19e9aa8e6e4f94348fa9c6f1f7ac", "author": "Clair Blacketer ", "committer": "cran-robot ", "message": "version 1.0.1\n", "time": 1727837943 }, "_maintainer": { "name": "Clair Blacketer", "email": "mblacke@its.jnj.com" }, "_registered": true, "_dependencies": [ { "package": "DatabaseConnector", "role": "Depends" }, { "package": "SqlRender", "role": "Depends" }, { "package": "rJava", "role": "Depends" }, { "package": "rmarkdown", "role": "Imports" }, { "package": "stringr", "role": "Imports" }, { "package": "DBI", "role": "Imports" }, { "package": "dplyr", "role": "Imports" }, { "package": "readr", "role": "Imports" }, { "package": "knitr", "role": "Suggests" }, { "package": "testthat", "version": ">= 3.0.0", "role": "Suggests" }, { "package": "RSQLite", "role": "Suggests" }, { "package": "withr", "role": "Suggests" } ], "_owner": "cran", "_selfowned": false, "_usedby": 1, "_updates": [], "_tags": [], "_stars": 0, "_userbio": { "uuid": 6899542, "type": "organization", "name": "cran", "description": "Unofficial read-only mirror of all CRAN R packages" }, "_downloads": { "count": 683, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/CommonDataModel" }, "_searchresults": 7, "_topics": [ "openjdk" ], "_rbuild": "4.6.0", "_assets": [ "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/CommonDataModel.html", "extra/contents.json", "extra/NEWS.html", "extra/NEWS.txt", "extra/readme.html", "extra/readme.md", "manual.pdf" ], "_realowner": "cran", "_cranurl": false, "_releases": [ { "version": "0.2.0", "date": "2024-02-07" }, { "version": "1.0.1", "date": "2024-10-01" } ], "_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", "base64enc", "bit", "bit64", "blob", "bslib", "cachem", "checkmate", "cli", "clipr", "cpp11", "crayon", "DatabaseConnector", "DBI", "dbplyr", "digest", "dplyr", "evaluate", "fastmap", "fontawesome", "fs", "generics", "glue", "highr", "hms", "htmltools", "jquerylib", "jsonlite", "knitr", "lifecycle", "magrittr", "memoise", "mime", "pillar", "pkgconfig", "prettyunits", "progress", "purrr", "R6", "rappdirs", "Rcpp", "readr", "rJava", "rlang", "rmarkdown", "sass", "SqlRender", "stringi", "stringr", "tibble", "tidyr", "tidyselect", "tinytex", "triebeard", "tzdb", "urltools", "utf8", "vctrs", "vroom", "withr", "xfun", "yaml" ], "_sysdeps": [ { "shlib": "libjvm", "package": "openjdk-21-jre-headless", "headers": "openjdk-21-jre-headless", "source": "openjdk", "version": "21.0.11+10-1~24.04.2", "name": "openjdk", "homepage": "https://openjdk.java.net/", "description": "OpenJDK Java runtime, using Hotspot JIT (headless)" } ], "_score": 2.1760912590556813, "_indexed": true, "_nocasepkg": "commondatamodel", "_universes": [ "cran" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "1.0.1", "date": "2026-06-01T11:45:19.000Z", "distro": "noble", "commit": "5f15a9add81e19e9aa8e6e4f94348fa9c6f1f7ac", "fileid": "5c65e623ccb122bdccec7619ef1e345cd6a1bc181560493e22d748c27d64a449", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cran/actions/runs/26752502913" }, { "r": "4.6.0", "os": "linux", "version": "1.0.1", "date": "2026-06-01T11:45:14.000Z", "distro": "noble", "commit": "5f15a9add81e19e9aa8e6e4f94348fa9c6f1f7ac", "fileid": "dbc2993862e2cb8f8cc75bc9fcdb2ae65f261942dffe6bd1a49af8ee34ebafb8", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/cran/actions/runs/26752502913" }, { "r": "4.6.0", "os": "wasm", "version": "1.0.1", "date": "2026-06-01T11:45:47.000Z", "commit": "5f15a9add81e19e9aa8e6e4f94348fa9c6f1f7ac", "fileid": "9c67f45480646fed0cec645c966a256d10935b7811a7d4e586cd400ef72f27d5", "status": "success", "buildurl": "https://github.com/r-universe/cran/actions/runs/26752502913" } ] }