claims_db/phclaims/ref/tables/load_ref.taxonomy.R

In PHSKC-APDE/Medicaid: Query and analyze WA State Medicaid, Medicare, and APCD data

library("dplyr")
library("dbplyr")
library("DBI")
library("odbc")
library("tidyr")
library("glue")
library("devtools")
library("medicaid")
library("openxlsx")
library("lubridate")
library("janitor")

#dsn <- "Analytics"
dsn <- "PHClaims"
db.connection <- dbConnect(odbc(), dsn)

##### PROVIDER TAXONOMY CODES
# file.dir <- "L:/DCHSPHClaimsData/References/Medicare/"
# 
# input <- read.xlsx(paste0(file.dir, "CROSSWALK_MEDICARE_PROVIDER_SUPPLIER_to_HEALTHCARE_PROVIDER_TAXONOMY_CLEANED.xlsx"), sheet = 2)
# dbWriteTable(db.connection, "CROSSWALK_MEDICARE_PROVIDER_SUPPLIER_to_HEALTHCARE_PROVIDER_TAXONOMY_CLEANED.xlsx", input, overwrite=TRUE)

##### PROVIDER TAXONOMY CODES
file.dir <- "C:/Users/xxx/github/claims_data/claims_db/phclaims/ref/tables_data/"

input <- read.xlsx(paste0(file.dir, "ref.mcaid_prvdr_txnmy.xlsx"), sheet = 2)
tbl <- Id(schema="tmp", table="ref.mcaid_prvdr_txnmy.xlsx")
dbWriteTable(db.connection, name=tbl, value=input, overwrite=TRUE)