Import PCG list

Imports and modifies PCG list provided by BAG to be used in RA calculation.

Usage

pcg_import(
  input,
  export_path = NULL,
  pcg_kurzname_col = 1,
  gtin_col = 4,
  pharmacode_col = 5,
  pharmacode_ddd_col = 7,
  schwellenwert_ddd_col = 8,
  schwellenwert_packungen_col = 9
)

Arguments

input

data.table or data.frame with the PCG-list or character vector with the path to an excel file.

export_path

Character vector with a path where a excel file as output should be generated.

pcg_kurzname_col, gtin_col, pharmacode_col, pharmacode_ddd_col, schwellenwert_ddd_col, schwellenwert_packungen_col

Integer vector with the column number of the PCG-Kurzname, GTIN, Pharmacode, Anzahl DDD pro Packung, DDD-Schwellenwert, Packungen-Schwellenwert.

Value

A data.frame with the modified PCG list to be used for upload in SORA PCG and PB calculation.

Author

Magnus Vieten, Yannick Schwarz

Examples

if (FALSE) { # \dontrun{
pcg_import(test_pcglist)
pcg_import("path/to/pcg_list.xlsx")
} # }