get_pm_fund_info: Get all pm_fund_info

In AZASRS/AZASRS: ASRS Database R API

Description

A view to get all private market fund info, can be filtered. By default, SQL –> SELECT * FROM all_pm_fund_info;

Usage

get_pm_fund_info(
  con = AZASRS_DATABASE_CONNECTION(),
  add_benchmark = FALSE,
  return_tibble = TRUE
)

Arguments

con	is a database connection object from AZASRS::AZASRS_DATABASE_CONNECTION()
return_tibble	is a boolean that determines whether or not a tibble is returned instead
add_benckmark	is a boolean that appends multiple benchmarks as their own columns. i.e. PVT_Benchmark, SAA_Benchmark, etc.

Value

Returns a tibble or SQL result with all pm_fund_info metadata.

Examples

get_pm_fund_info()
# A tibble: 282 x 26
# pm_fund_info_id pm_fund_id pm_fund_descrip… pm_fund_common_… vintage commit unfunded legacy specialist
# <int> <chr>      <chr>                   <chr>              <int>   <int>    <int>    <chr>  <chr>
# 1      Hgh19     AP Mezzanine Pa…      HPS Mezz 2019         2019    6.00e8  3.95e8     A    " "
# 2      HghBr     AP Mezzanine Pa…      HPS Mezz 2            2013    2.00e8  1.30e7     A    " "
# 3      HghBr3    AP Mezzanine Pa…      HPS Mezz 3            2016    5.00e8  9.85e7     A    " "
# … with 279 more rows, and 17 more variables: invest_end <date>, term_end <date>, extension <dbl>,
#   ext_time <dbl>, ext_used <dbl>, fee_cat <chr>, consultant <chr>, adv_board <lgl>, obsvr <lgl>,
#   fund_size_m <dbl>, closed <chr>, pm_fund_category <chr>, pm_fund_category_description <chr>,
#   pm_fund_portfolio <chr>, pm_fund_sponsor <chr>, pm_fund_city <chr>, pm_fund_sector <chr>

AZASRS/AZASRS documentation built on Sept. 30, 2020, 9:26 p.m.