get_ssbt_composite_info: Query ssbt_composite_info table from database

In AZASRS/AZASRS: ASRS Database R API

Description

Gets all ssbt composite information.

Usage

get_ssbt_composite_info(
  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_ssbt_composite_info()
# A tibble: 36 x 5
# ssbt_composite_info… ssbt_composite_id ssbt_composite_description  ssbt_composite_short_des… benchmark_info_…
# <int>                <chr>               <chr>                <chr>            <int>
#  1                 ASRSA001           TOTAL PLAN            Total Fund          NA
#  2                 ASRSA007           TOTAL EQUITY          Equity              NA
#  3                 ASRSA007           TOTAL PUBLIC EQUITY   Public Equity       NA
# ... with 33 more rows

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