Process the social care client lookup — read_lookup_sc_client • createslf

This will read and process the social care client lookup

Usage

read_lookup_sc_client(
  fyyear,
  sc_dvprod_connection = phs_db_connection(dsn = "DVPROD")
)

Arguments

fyyear: The year to process, in the standard format '1718'
sc_dvprod_connection: The connection to the SC platform.

Value

the final data as a tibble.

See also

Other process extracts: create_homelessness_lookup(), process_extract_acute(), process_extract_ae(), process_extract_alarms_telecare(), process_extract_care_home(), process_extract_cmh(), process_extract_delayed_discharges(), process_extract_district_nursing(), process_extract_gp_ooh(), process_extract_home_care(), process_extract_homelessness(), process_extract_maternity(), process_extract_mental_health(), process_extract_nrs_deaths(), process_extract_ooh_consultations(), process_extract_ooh_diagnosis(), process_extract_ooh_outcomes(), process_extract_outpatients(), process_extract_prescribing(), process_extract_sds(), process_it_chi_deaths(), process_lookup_gpprac(), process_lookup_postcode(), process_lookup_sc_client(), process_lookup_sc_demographics(), process_refined_death(), process_sc_all_alarms_telecare(), process_sc_all_care_home(), process_sc_all_home_care(), process_sc_all_sds(), read_extract_gp_ooh(), read_it_chi_deaths()