create_AC_Product_by_Link: Create an AC_PRODUCT table consisting of aries cases linked...

In Hilcorp-Reserves/Reserves.Util: Aries and Reserves Utilities

Description

The following functin will make a connection to the Enertia database located on the Enertia01B Server. It will then take the user defined 'enertia_codes' vector which contains one or more enertia_codes to query. The function will then return a dataframe object which contains aries cases linked to the specified enertia codes and the associated production data. the data frame is returned in the same format as the Aries AC_PRODUCT table. the export variable can be set equal to TRUE to export the output to the users desktop.

Usage

create_AC_Product_by_Link(
  enertia_codes,
  server = "extsql01",
  database = "Aries",
  user = Sys.getenv("USERNAME"),
  overwrite = "Y",
  export = FALSE
)

Arguments

enertia_codes	a character vector.
server	a character vector.
database	a character vector.
user	a character vector.
overwrite	a character vector.
export	a boolean value

Value

A dataframe containing production data formated for the AC_PRODUCT table in Aries

Examples

create_AC_Product_by_Link(enertia_codes = c("49.1018.0010.00", "49.1018.0210.00"), user = "user01", overwrite = "N", export = TRUE)

Hilcorp-Reserves/Reserves.Util documentation built on March 25, 2020, 5:43 p.m.