get_pm_cash_flow_daily: Daily private market cash flows

In AZASRS/AZASRS: ASRS Database R API

Description

pm_cash_flow_daily table from database joined with metadata

Usage

get_pm_cash_flow_daily(
  con = AZASRS_DATABASE_CONNECTION(),
  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

Value

Returns a tibble or database object.

Examples

get_pm_cash_flow_daily()
# A tibble: 11,586 x 30
# pm_fund_info_id effective_date cash_flow contributions distributions pm_fund_id pm_fund_descrip..
#  <int>            <date>           <dbl>     <dbl>         <dbl>   <chr>      <chr>
#    1            2019-06-17       -8.80e6   -8800000          0     Hgh19       AP Mezzanine Pa…
#    1            2019-08-09       -1.70e6   -1700000          0     Hgh19       AP Mezzanine Pa…
#    1            2019-08-29       -2.00e7   -20035179.      F 0     Hgh19       AP Mezzanine Pa…
# ... with  11,583 more rows, and 23 more variables: pm_fund_common_name <chr>, vintage <int>, commit <int>,
#   unfunded <int>, legacy <chr>, specialist <chr>, 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.