match_name_to_id: Match Name to ID

View source: R/match_name_to_id.R

match_name_to_idR Documentation

Match Name to ID

Description

Query BPFS database for latest Detailed Fund, Service, Activity, Fund, Agency, Object, and/or Subobject names. Useful for pulling the most recent names when working with historical data.

Usage

match_name_to_id(df, cols, incl.higher, fy = 22)

Arguments

df

dataframe to match

cols

a vector of strings of the column names to be matched

incl.higher

logical, should the returned dataframe include the level of detail above certain columns (ex: should Fund ID be included with a Detailed Fund match?)

fy

latest fiscal year, for database schema

Value

a dataframe with Name columns added

Author(s)

Lillian Nguyen


baltimorebudget/bbmR documentation built on Aug. 28, 2023, 6:32 p.m.