{ "_id": "6a23de5e530b9bc726be716f", "Package": "dmhct", "Title": "A Data Model Package for the MLinHCT Project", "Version": "1.0.0", "Authors@R": "person(\"Jesse\", \"Smith\", , \"jesse.smith@stjude.org\", role = c(\"aut\", \"cre\"))", "Description": "Extracts, Loads, and Transforms data from the SQL Server\ncontaining HCT data to a `dm` object with cleaned tables.", "License": "AGPL (>= 3)", "URL": "https://github.com/jesse-smith/dmhct,\nhttps://jesse-smith.github.io/dmhct/", "BugReports": "https://github.com/jesse-smith/dmhct/issues", "Encoding": "UTF-8", "Roxygen": "list(markdown = TRUE)", "RoxygenNote": "7.3.1", "Repository": "https://jesse-smith.r-universe.dev", "Date/Publication": "2024-05-31 20:47:09 UTC", "RemoteUrl": "https://github.com/jesse-smith/dmhct", "RemoteRef": "HEAD", "RemoteSha": "e024cd902179c4107db120020cd0d2ba1fb17220", "NeedsCompilation": "no", "Packaged": { "Date": "2026-06-06 08:41:56 UTC", "User": "root" }, "Author": "Jesse Smith [aut, cre]", "Maintainer": "Jesse Smith ", "MD5sum": "2db088e64c014c67109b58a836f3cbc2", "_user": "jesse-smith", "_type": "src", "_file": "dmhct_1.0.0.tar.gz", "_fileid": "344ed9cf0c68746a8df764cdd20eeca1a844bcb53c1901c6ca1f785ff181b972", "_filesize": 168153, "_sha256": "344ed9cf0c68746a8df764cdd20eeca1a844bcb53c1901c6ca1f785ff181b972", "_created": "2026-06-06T08:41:56.000Z", "_published": "2026-06-06T08:46:22.137Z", "_distro": "noble", "_jobs": [ { "job": 79865060574, "time": 161, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "NOTE", "artifact": "7452955650" }, { "job": 79865060577, "time": 168, "config": "linux-release-x86_64", "r": "4.6.0", "check": "NOTE", "artifact": "7452956225" }, { "job": 79865060569, "time": 191, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "NOTE", "artifact": "7452955144" }, { "job": 79865060576, "time": 199, "config": "macos-release-arm64", "r": "4.6.0", "check": "NOTE", "artifact": "7452956145" }, { "job": 79864846284, "time": 237, "config": "source", "r": "4.6.0", "check": "OK", "artifact": "7452937947" }, { "job": 79865060568, "time": 135, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "7452952671" }, { "job": 79865060581, "time": 130, "config": "windows-devel", "r": "4.7.0", "check": "NOTE", "artifact": "7452952405" }, { "job": 79865060575, "time": 105, "config": "windows-oldrel", "r": "4.5.3", "check": "NOTE", "artifact": "7452949689" }, { "job": 79865060573, "time": 105, "config": "windows-release", "r": "4.6.0", "check": "NOTE", "artifact": "7452949515" } ], "_buildurl": "https://github.com/r-universe/jesse-smith/actions/runs/27057648168", "_status": "success", "_host": "GitHub-Actions", "_upstream": "https://github.com/jesse-smith/dmhct", "_commit": { "id": "e024cd902179c4107db120020cd0d2ba1fb17220", "author": "Jesse Smith ", "committer": "GitHub ", "message": "Merge pull request #6 from jesse-smith/development\n\nAdd EDW source as SQL server option", "time": 1717188429 }, "_maintainer": { "name": "Jesse Smith", "email": "jesse.smith@stjude.org", "login": "jesse-smith", "linkedin": "in/jesse-smith-profile", "description": "Hi, I'm Jesse. I like building things sometimes.", "uuid": 26561253 }, "_registered": true, "_dependencies": [ { "package": "R", "version": ">= 4.0", "role": "Depends" }, { "package": "bit64", "role": "Imports" }, { "package": "checkmate", "role": "Imports" }, { "package": "data.table", "role": "Imports" }, { "package": "dbplyr", "role": "Imports" }, { "package": "dm", "version": ">= 1.0.0", "role": "Imports" }, { "package": "dplyr", "role": "Imports" }, { "package": "fs", "role": "Imports" }, { "package": "janitor", "role": "Imports" }, { "package": "lifecycle", "role": "Imports" }, { "package": "lubridate", "role": "Imports" }, { "package": "methods", "role": "Imports" }, { "package": "odbc", "role": "Imports" }, { "package": "purrr", "role": "Imports" }, { "package": "R6", "role": "Imports" }, { "package": "rlang", "role": "Imports" }, { "package": "stringi", "role": "Imports" }, { "package": "stringr", "role": "Imports" }, { "package": "vctrs", "role": "Imports" }, { "package": "cli", "role": "Suggests" }, { "package": "devtools", "role": "Suggests" }, { "package": "DiagrammeR", "role": "Suggests" }, { "package": "DiagrammeRsvg", "role": "Suggests" }, { "package": "forcats", "role": "Suggests" }, { "package": "lme4", "role": "Suggests" }, { "package": "qs", "role": "Suggests" }, { "package": "renv", "role": "Suggests" }, { "package": "stats", "role": "Suggests" }, { "package": "tidyr", "role": "Suggests" }, { "package": "usethis", "role": "Suggests" } ], "_owner": "jesse-smith", "_selfowned": true, "_usedby": 0, "_updates": [], "_tags": [], "_stars": 0, "_contributors": [ { "user": "jesse-smith", "count": 170, "uuid": 26561253 } ], "_userbio": { "uuid": 26561253, "type": "user", "name": "Jesse Smith", "description": "Hi, I'm Jesse. I like building things sometimes." }, "_downloads": { "count": 0, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/dmhct" }, "_devurl": "https://github.com/jesse-smith/dmhct", "_pkgdown": "https://jesse-smith.github.io/dmhct/", "_searchresults": 0, "_rbuild": "4.6.0", "_assets": [ "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/dmhct.html", "extra/readme.html", "extra/readme.md", "manual.pdf" ], "_cranurl": false, "_exports": [ "%>%", "con_irb_mlinhct", "con_sql_server", "con_stjude_edw", "dm_collect", "dm_combine", "dm_compute", "dm_disconnect", "dm_elt", "dm_extract", "dm_hct", "dm_is_remote", "dm_pivot", "dm_sql_server", "dm_standardize", "dm_transform", "intvl_to_matrix", "na_patterns", "non_numeric", "std_chr", "std_date", "std_intvl", "std_lgl", "std_num" ], "_help": [ { "page": "con_irb_mlinhct", "title": "Connect to SQL Server Where IRB_MLinHCT Data is Stored", "topics": [ "con_irb_mlinhct" ] }, { "page": "con_sql_server", "title": "Connect to SQL Server Where Data is Stored", "topics": [ "con_sql_server" ] }, { "page": "con_stjude_edw", "title": "Connect to SQL Server Where EDW Data is Stored", "topics": [ "con_stjude_edw" ] }, { "page": "dm_collect", "title": "Collect All Tables in a 'dm' Object", "topics": [ "dm_collect" ] }, { "page": "dm_combine", "title": "Combine Table with Like Information", "topics": [ "dm_combine" ] }, { "page": "dm_compute", "title": "Compute All Tables in a 'dm' Object", "topics": [ "dm_compute" ] }, { "page": "dm_disconnect", "title": "Disconnect a 'dm' Object from the Remote Server", "topics": [ "dm_disconnect" ] }, { "page": "dm_elt", "title": "Extract, Load, and Transform Remote Tables to Local Source", "topics": [ "dm_elt" ] }, { "page": "dm_extract", "title": "Extract Remote Tables from SQL Server for MLinHCT", "topics": [ "dm_extract" ] }, { "page": "dm_extract_legacy", "title": "Select and Convert Table + Columns From Remote Source", "topics": [ "dm_extract_legacy" ] }, { "page": "dm_hct", "title": "Extract, Standardize, and Combine Tables from the MLinHCT Database", "topics": [ "dm_hct" ] }, { "page": "dm_is_remote", "title": "Check Whether a 'dm' Object is Connected to a Remote Server", "topics": [ "dm_is_remote" ] }, { "page": "dm_pivot", "title": "Pivot Tables in Entity-Attribute-Value Format", "topics": [ "dm_pivot" ] }, { "page": "dm_sql_server", "title": "Create a 'dm' Object of HCT Data from Connection to SQL Server", "topics": [ "dm_sql_server" ] }, { "page": "dm_standardize", "title": "Standardize Column Values in a local 'dm' for MLinHCT", "topics": [ "dm_standardize" ] }, { "page": "dm_transform", "title": "Transform Tables to Analysis-Friendly Format", "topics": [ "dm_transform" ] }, { "page": "intvl_to_matrix", "title": "Convert Standardized Intervals to Matrix Format", "topics": [ "intvl_to_matrix" ] }, { "page": "na_patterns", "title": "Common Patterns Representing Missing Data", "topics": [ "na_patterns" ] }, { "page": "non_numeric", "title": "Extract Values That Cannot Be Converted to 'numeric'", "topics": [ "non_numeric" ] }, { "page": "std_chr", "title": "Standardize 'character' Vectors", "topics": [ "std_chr" ] }, { "page": "std_date", "title": "Parse Dates to Standard Format", "topics": [ "std_date" ] }, { "page": "std_intvl", "title": "Standardize Interval Representations", "topics": [ "std_intvl" ] }, { "page": "std_lgl", "title": "Standardize 'logical' Representations in Various Formats", "topics": [ "std_lgl" ] }, { "page": "std_num", "title": "Convert and Standardize Numeric Values in Various Forms", "topics": [ "std_num" ] } ], "_readme": "https://github.com/jesse-smith/dmhct/raw/HEAD/README.md", "_rundeps": [ "backports", "bit", "bit64", "blob", "cachem", "checkmate", "cli", "cpp11", "data.table", "DBI", "dbplyr", "dm", "dplyr", "fastmap", "fs", "generics", "glue", "hms", "janitor", "lifecycle", "lubridate", "magrittr", "memoise", "odbc", "pillar", "pkgconfig", "purrr", "R6", "Rcpp", "rlang", "snakecase", "stringi", "stringr", "tibble", "tidyr", "tidyselect", "timechange", "utf8", "vctrs", "withr" ], "_score": 1.6989700043360187, "_indexed": true, "_nocasepkg": "dmhct", "_universes": [ "jesse-smith" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "1.0.0", "date": "2026-06-06T08:45:01.000Z", "distro": "noble", "commit": "e024cd902179c4107db120020cd0d2ba1fb17220", "fileid": "945c8964aae03c82882a4b595db6942d53a2b301e6d8cf15dce057360919297e", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/jesse-smith/actions/runs/27057648168" }, { "r": "4.6.0", "os": "linux", "version": "1.0.0", "date": "2026-06-06T08:45:05.000Z", "distro": "noble", "commit": "e024cd902179c4107db120020cd0d2ba1fb17220", "fileid": "de2c3cb403a4bff31faf8bdd344e8be6856b202b0545895b0393c9b5b4ec0f38", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/jesse-smith/actions/runs/27057648168" }, { "r": "4.5.3", "os": "mac", "version": "1.0.0", "date": "2026-06-06T08:44:59.000Z", "commit": "e024cd902179c4107db120020cd0d2ba1fb17220", "fileid": "bb7d2d54349e936e4aa32191304808fefd0114c7266aa0194ea2ceb296ec50af", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/jesse-smith/actions/runs/27057648168" }, { "r": "4.6.0", "os": "mac", "version": "1.0.0", "date": "2026-06-06T08:45:08.000Z", "commit": "e024cd902179c4107db120020cd0d2ba1fb17220", "fileid": "fbaf991c23c1871ab1d0155bc0027b19ba7ca499782d5c7ffc8e1d8fbbf6b0d5", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/jesse-smith/actions/runs/27057648168" }, { "r": "4.6.0", "os": "wasm", "version": "1.0.0", "date": "2026-06-06T08:45:01.000Z", "commit": "e024cd902179c4107db120020cd0d2ba1fb17220", "fileid": "8179ef9632e642c653153a79914ce5b7adfa6644e4ade62d184dcc6d7599ffe0", "status": "success", "buildurl": "https://github.com/r-universe/jesse-smith/actions/runs/27057648168" }, { "r": "4.7.0", "os": "win", "version": "1.0.0", "date": "2026-06-06T08:44:28.000Z", "commit": "e024cd902179c4107db120020cd0d2ba1fb17220", "fileid": "21e4baf1f41e760b8a1c43267e71ae778b33ae8055eb30b1960c73080f2e8061", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/jesse-smith/actions/runs/27057648168" }, { "r": "4.5.3", "os": "win", "version": "1.0.0", "date": "2026-06-06T08:43:58.000Z", "commit": "e024cd902179c4107db120020cd0d2ba1fb17220", "fileid": "04c9b14236b27ce2a8d9c64e636d6fdb97569a3ef5a396217aca9c5f4aa3b84a", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/jesse-smith/actions/runs/27057648168" }, { "r": "4.6.0", "os": "win", "version": "1.0.0", "date": "2026-06-06T08:44:00.000Z", "commit": "e024cd902179c4107db120020cd0d2ba1fb17220", "fileid": "1fffc5b9f2917fee39d976c3e640e9b2cc1971328196a5f7b07a63c85bb06856", "status": "success", "check": "NOTE", "buildurl": "https://github.com/r-universe/jesse-smith/actions/runs/27057648168" } ] }