Package index • createslf

Connection to PHS database

phs_db_connection(): Open a connection to a PHS database

Check

Checks within vectors

is_missing(): Check for NA or blank values in a character vector
check_variables_exist(): Check variables exist in data
check_year_valid(): Check data exists for a year
check_it_reference(): Check that an IT reference looks valid

Years & Dates

Dates within Financial Year

Functions to compute the start, end and midpoint dates of a financial year, and convert date types

calculate_stay(): Calculate total length of stay
compute_mid_year_age(): Compute Age at Midpoint of Year
convert_date_to_numeric(): Convert a date type to the 'SLF numeric format'
convert_numeric_to_date(): Convert a date in 'SLF numeric format' to Date type
end_fy(): Return the end date of FY years
end_fy_quarter(): Return the end of a quarter
end_next_fy_quarter(): Return the end of the next quarter
fy_interval(): Financial Year interval
is_date_in_fyyear(): Check if a date, or interval is in the financial year
last_date_month(): Return the end date of the month of the given date
midpoint_fy(): Return the date of the midpoint of the FY year
next_fy(): Return the next financial year
start_fy(): Return the start date of FY year
start_fy_quarter(): Return the start of a quarter
start_next_fy_quarter(): Return the start of the next quarter
add_homelessness_date_flags(): Add homelessness date flags episode
end_date(): End date
fix_sc_end_dates(): Fix sc end dates
fix_sc_missing_end_dates(): Fix sc missing end dates
fix_sc_start_dates(): Fix sc start dates
fy(): Extract latest FY from end_date
qtr(): Extract latest quarter from end_date

Year Format

Functions to convert between financial year and calendar year, and check that the year variable is in the correct format

check_year_format(): Check that the year is in the correct format
convert_fyyear_to_year(): Convert year types - Financial year form to the alternate form
convert_year_to_fyyear(): Convert year types - Alternate year form to financial year form
combine_extracts_tests_year(): Combine year specific extract tests into one xlsx file by financial year
is_date_in_fyyear(): Check if a date, or interval is in the financial year
latest_cost_year(): The latest financial year for Cost uplift setting
process_tests_cross_year(): Process cross year tests

Ages

Functions to deal with ages of clients

add_age_group(): add_age_group
compute_mid_year_age(): Compute Age at Midpoint of Year

Clean-Up

Clean up the data

clean_up_ch(): Clean up CH
clean_up_free_text(): Clean up a free text string
clean_up_gender(): Clean up gender column
fill_ch_names(): Fix and fill care home name and postcodes
ch_name_extract_keyword(): extract keyword in a care home name
cascade_geographies(): Match dummy HSCP and LCA codes
correct_demographics(): Correct date of birth and ages of records

Create

ID

Functions to create ID variables

create_person_id(): Create the Person ID variable
replace_sc_id_with_latest(): Replace sc id with the latest sc id

Costs

Functions to create costs variables and fix costs

calculate_outpatient_costs(): Calculate cost for Outpatient records
create_day_episode_costs(): Assign costs for single day episodes
create_monthly_costs(): Create Monthly Costs
fix_c3_costs(): Fix C3 Costs - Acute Extract

Flags

Functions to create flag variables

create_demog_test_flags(): Create demographic test flags
create_hb_cost_test_flags(): Create Health Board cost test flags
create_hb_test_flags(): Create Health Board test flags
create_hscp_test_flags(): Create HSCP test flags
create_lca_client_test_flags(): Create LCA test flags
create_lca_test_flags(): Create LCA test flags
create_sending_location_test_flags(): Create sending location test flags
add_homelessness_date_flags(): Add homelessness date flags episode

Monthly

Functions to convert monthly variables, beddays

convert_monthly_rows_to_vars(): Convert Monthly Rows to Variables
create_monthly_beddays(): Create Monthly Beddays

Codes

Convert various codes to alternate forms

convert_ca_to_lca(): Convert Council Areas into Local Council Authority Codes
convert_hb_to_hbnames(): Convert NHS Health Board Codes to Names
convert_hscp_to_hscpnames(): Convert HSCP Codes to Names
convert_sc_sending_location_to_lca(): Convert Social Care Sending Location Codes into LCA Codes
add_smrtype(): Add smrtype variable based on record ID
convert_eng_gpprac_to_dummy(): Convert GP Practice Codes to a Dummy Code
aggregate_by_chi(): Aggregate by CHI
assign_d_cohort_mh() assign_d_cohort_frailty() assign_d_cohort_maternity() assign_d_cohort_high_cc() assign_d_cohort_medium_cc() assign_d_cohort_low_cc() assign_d_cohort_comm_living() assign_d_cohort_adult_major() assign_d_cohort_child_major() assign_d_cohort_eol() assign_d_cohort_substance(): Assign Mental Health cohort
get_slf_chi_deaths_path(): SLF CHI Deaths File Path
is_chi_in_file(): Check if chi is in a file
process_it_chi_deaths(): Process the CHI deaths extract
process_tests_it_chi_deaths(): Process CHI Deaths tests
produce_it_chi_deaths_tests(): CHI death tests
read_it_chi_deaths(): Read the CHI deaths extract
remove_blank_chi(): Remove blank CHI
create_lca_client_test_flags(): Create LCA test flags
create_lca_test_flags(): Create LCA test flags

Writing data

Functions which mask the typical data write functions to add some nice defaults and importantly fix file permissions.

write_file(): Write a data to a file
clean_temp_data(): Clean temp data from disk
combine_multi_xlsx(): Combine xlsx files into one xlsx file
store_ep_file_vars(): Store the unneeded episode file variables
load_ep_file_vars(): Load the unneeded episode file variables
write_temp_data(): Write a temp data to disk in parquet format for debugging purpose

Initialisation

Get the date of update, period, and extract number

get_dd_period(): Delayed Discharge period
latest_cost_year(): The latest financial year for Cost uplift setting
latest_update(): Latest update
previous_update(): Previous update
years_to_run(): The year list for slf to update
gzip_files(): Compress CSV with gzip
make_lowercase_ext(): Make file path extensions lower-case

Files

Directories

File Directories for SLF’s

get_dev_dir(): SLF directory - sourcedev / Source_Linkage_File_Updates
get_lookups_dir(): Lookups Directory Path
get_slf_dir(): SLF directory - hscdiip
get_year_dir(): Year Directory

Paths

File Paths for SLF’s

get_dd_path(): Get the Delayed Discharges file path
get_demographic_cohorts_path(): Demographic cohorts lookup Path
get_file_path(): Get and check and full file path
get_homelessness_completeness_path(): Homelessness Completeness lookup path
get_ltcs_path(): Long Term Conditions File Path
get_nsu_path(): NSU File Path
get_practice_details_path(): Practice Details File Path
get_readcode_lookup_path(): Get the full path to the SLF read code lookup
get_service_use_cohorts_path(): Service-use cohorts lookup Path
get_sg_homelessness_pub_path(): Homelessness Completeness SG publication figures
get_gpprac_ref_path(): GP Practice Reference File Path (gpprac)
get_locality_path(): Locality File Path
get_lookups_dir(): Lookups Directory Path
get_pop_path(): Populations File Path for different types
get_simd_path(): SIMD File Path
get_spd_path(): Scottish Postcode Directory File Path
get_uk_postcode_path(): get uk postcode list file path
get_ch_costs_path(): Care Home Costs File Path
get_dn_costs_path(): District Nursing Costs File Path
get_dn_raw_costs_path(): Raw District Nursing Costs File Path
get_gp_ooh_costs_path(): GP Out of Hours Costs File Path
get_gp_ooh_raw_costs_path(): Raw GP OoH Costs File Path
get_hc_costs_path(): Full Home Care Costs File Path
get_hc_raw_costs_path(): Raw Home Care Costs File Path
get_boxi_extract_path(): Get BOXI extract
get_hhg_path(): HHG Extract File Path
get_it_deaths_path(): IT Deaths File Path
get_it_ltc_path(): IT Long Term Conditions File Path
get_it_prescribing_path(): IT Prescribing File Path
get_source_extract_path(): Source Extract File Path
get_sparra_path(): SPARRA Extract File Path
get_sc_client_lookup_path(): Social Care Client Lookup File Path
get_sc_demog_lookup_path(): Social Care Demographic Lookup File Path
get_sc_at_episodes_path(): Alarms and Telecare Episodes File Path
get_sc_ch_episodes_path(): Care Home Episodes File Path
get_sc_hc_episodes_path(): Home Care Episodes File Path
clean_individual_file(): Clean individual file
create_episode_file(): Produce the Source Episode file
create_individual_file(): Create the Source Individual file
find_latest_file(): Find the latest version of a file
is_chi_in_file(): Check if chi is in a file
process_tests_episode_file(): Process Episode file tests
process_tests_individual_file(): Process Individual file tests
read_dev_slf_file(): Read development SLF files (using SLFhelper)
read_file(): Read a file
write_file(): Write a data to a file
console_output_path(): console output path
get_combined_slf_deaths_lookup_path(): SLF death dates File Path
get_dummy_boxi_extract_path(): Get a path to a dummy file
get_sandpit_extract_path(): Sandpit Extract File Path
get_sc_sds_episodes_path(): SDS Episodes File Path
get_slf_ch_name_lookup_path(): SLF Care Home Lookup File Path
get_slf_chi_deaths_path(): SLF CHI Deaths File Path
get_slf_deaths_lookup_path(): SLF Deaths lookup path
get_slf_episode_path(): Get the slf episode file path
get_slf_gpprac_path(): SLF GP Lookup File Path
get_slf_individual_path(): Get the SLF individual file path
get_slf_postcode_path(): SLF Postcode Lookup File Path

Read extracts

Process SLF Extracts

read_dev_slf_file(): Read development SLF files (using SLFhelper)
read_extract_acute(): Read Acute extract
read_extract_ae(): Read A&E extract
read_extract_cmh(): Read CMH extract
read_extract_delayed_discharges(): Read Delayed Discharges extract
read_extract_district_nursing(): Read district nursing extract
read_extract_gp_ooh(): Process the GP OoH extract
read_extract_homelessness(): Read Homelessness extract
read_extract_maternity(): Read Maternity extract
read_extract_mental_health(): Read Mental Health extract
read_extract_nrs_deaths(): Read NRS Deaths extract
read_extract_ooh_consultations(): Read GP OOH Consultations extract
read_extract_ooh_diagnosis(): Read GP OOH Diagnosis extract
read_extract_ooh_outcomes(): Read GP OOH Outcomes extract
read_extract_outpatients(): Read Outpatients extract
read_extract_prescribing(): Read Prescribing extract
read_file(): Read a file
read_it_chi_deaths(): Read the CHI deaths extract
read_lookup_ltc(): Read LTC IT extract
read_lookup_sc_client(): Process the social care client lookup
read_lookup_sc_demographics(): Read SC demographics
read_sc_all_alarms_telecare(): Read Social Care Alarms Telecare data
read_sc_all_care_home(): Read Social Care - Care Home data
read_sc_all_home_care(): Read Social Care Home Care data
read_sc_all_sds(): Read Social Care SDS data
read_temp_data(): Read a temp data from disk for debugging purpose
get_gpprac_opendata(): GP Practice details from PHS open data

Process extracts

Process SLF Extracts

create_homelessness_lookup(): Create a homelessness lookup
process_extract_acute(): Process the Acute extract
process_extract_ae(): Process the A&E extract
process_extract_alarms_telecare(): Process the (year specific) Alarms Telecare extract
process_extract_care_home(): Process the (year specific) Care Home extract
process_extract_cmh(): Process the Community Mental Health (CMH) extract
process_extract_delayed_discharges(): Process the delayed discharges extract
process_extract_district_nursing(): Process the District Nursing extract
process_extract_gp_ooh(): Process the GP OoH extract
process_extract_home_care(): Process the (year specific) Home Care extract
process_extract_homelessness(): Process the Homelessness Extract
process_extract_maternity(): Process the maternity extract
process_extract_mental_health(): Process the mental health extract
process_extract_nrs_deaths(): Process the Nation Records of Scotland (NRS) Deaths extract
process_extract_ooh_consultations(): Process the GP OOH Consultations extract
process_extract_ooh_diagnosis(): Process the GP OOH Diagnosis extract
process_extract_ooh_outcomes(): Process the GP OOH Outcomes extract
process_extract_outpatients(): Process the Outpatients extract
process_extract_prescribing(): Process the prescribing extract
process_extract_sds(): Process the (year specific) SDS extract
process_it_chi_deaths(): Process the CHI deaths extract
process_lookup_gpprac(): Process the SLF gpprac lookup
process_lookup_postcode(): Process the SLF postcode lookup
process_lookup_sc_client(): Process the social care client lookup
process_lookup_sc_demographics(): Process the social care demographic lookup
process_refined_death(): Process the refined death data
process_sc_all_alarms_telecare(): Process the all Alarms Telecare extract
process_sc_all_care_home(): Process the all Care Home extract
process_sc_all_home_care(): Process the all home care extract
process_sc_all_sds(): Process the all SDS extract
read_extract_gp_ooh(): Process the GP OoH extract
read_it_chi_deaths(): Read the CHI deaths extract
read_lookup_sc_client(): Process the social care client lookup
process_costs_ch_rmd(): Process care homes cost lookup Rmd file
process_costs_dn_rmd(): Process District Nursing cost lookup Rmd file
process_costs_gp_ooh_rmd(): Process GP ooh cost lookup Rmd file
process_costs_hc_rmd(): Process Home Care cost lookup Rmd file
process_costs_rmd(): Process the cost lookup files
process_lookup_ltc(): Process LTC IT extract
process_slf_deaths_lookup(): Create the SLF Deaths lookup
process_tests_acute(): Process Acute tests
process_tests_ae(): Process A&E tests
process_tests_alarms_telecare(): Process Alarms Telecare tests
process_tests_care_home(): Process Care Home tests
process_tests_cmh(): Process CMH tests
process_tests_cross_year(): Process cross year tests
process_tests_delayed_discharges(): Process Delayed Discharges tests
process_tests_district_nursing(): Process District Nursing tests
process_tests_episode_file(): Process Episode file tests
process_tests_gp_ooh(): Process GP OOH tests
process_tests_home_care(): Process Home Care tests
process_tests_homelessness(): Process Homelessness tests
process_tests_individual_file(): Process Individual file tests
process_tests_it_chi_deaths(): Process CHI Deaths tests
process_tests_lookup_gpprac(): Process GP (gpprac) Lookup tests
process_tests_lookup_pc(): Process PC (postcode) Lookup tests
process_tests_ltcs(): Process LTCs tests
process_tests_maternity(): Process Maternity tests
process_tests_mental_health(): Process Mental Health tests
process_tests_nrs_deaths(): Process National Records of Scotland (NRS) deaths tests
process_tests_outpatients(): Process Outpatients tests
process_tests_prescribing(): Process prescribing tests
process_tests_sc_all_at_episodes(): Process Social Care Alarms Telecare all episodes tests
process_tests_sc_all_ch_episodes(): Process Social Care, Care Home all episodes tests
process_tests_sc_all_hc_episodes(): Process Social Care Home Care all episodes tests
process_tests_sc_all_sds_episodes(): Process Social Care SDS all episodes tests
process_tests_sc_client_lookup(): Social care client lookup tests
process_tests_sc_demographics(): Process Social Care Demographics tests
process_tests_sc_sandpit(): Process tests for the social care sandpit extracts
process_tests_sds(): Process SDS tests

Episode file

Building the episode file

add_activity_after_death_flag(): Match on BOXI NRS death dates to process activity after death flag
add_homelessness_flag(): Add 'homelessness in FY' flag
add_nsu_cohort(): Add NSU cohort to working file
add_ppa_flag(): Add Potentially Preventable Admission (PPA) Marker
apply_cost_uplift(): Uplift costs
correct_cij_vars(): Correct the CIJ variables
create_cohort_lookups(): Create the cohort lookups
create_cost_inc_dna(): Create cost total net inc DNA
fill_missing_cij_markers(): Fill any missing CIJ markers for records that should have them
link_delayed_discharge_eps(): Link Delayed Discharge to WIP episode file
lookup_uplift(): Set uplift scale
fill_geographies(): Fill postcode and GP practice geographies

Lookups

add_operation_flag(): Add operation flag
assign_cohort_names(): Assign service use cohort into string format
assign_death_flag(): Assign a flag for deaths
assign_d_cohort_mh() assign_d_cohort_frailty() assign_d_cohort_maternity() assign_d_cohort_high_cc() assign_d_cohort_medium_cc() assign_d_cohort_low_cc() assign_d_cohort_comm_living() assign_d_cohort_adult_major() assign_d_cohort_child_major() assign_d_cohort_eol() assign_d_cohort_substance(): Assign Mental Health cohort
assign_elective_daycase_instances(): Assign a flag for elective daycase instances
assign_elective_inpatient_flag(): Assign a flag for elective inpatients
assign_elective_inpatient_instances(): Assign a flag for elective inpatient instances
assign_elective_instances(): Assign a flag for elective instances
assign_emergency_instances(): Assign a flag for emergency instances
assign_s_cohort_ae2(): Assign A&E cohort flag
assign_s_cohort_community_care(): Assign Community Care cohort flag
assign_s_cohort_elective_inpatient(): Assign elective inpatient cohort flag
assign_s_cohort_geriatric(): Assign geriatric cohort flag
assign_s_cohort_limited_daycases(): Assign limited daycases cohort flag
assign_s_cohort_maternity(): Assign maternity cohort flag
assign_s_cohort_multiple_emergency(): Assign multiple emergency cohort flag
assign_s_cohort_outpatient(): Assign outpatient cohort flag
assign_s_cohort_prescribing(): Assign prescribing cohort flag
assign_s_cohort_psychiatry(): Assign psychiatry cohort flag
assign_s_cohort_residential_care(): Assign residential care cohort flag
assign_s_cohort_routine_daycase(): Assign routine daycase cohort flag
assign_s_cohort_single_emergency(): Assign single emergency cohort flag
calculate_acute_elective_cost(): Calculate cost for Acute Elective records
calculate_acute_emergency_cost(): Calculate cost for Acute Emergency records
calculate_ae2_cost(): Calculate cost for Accident & Emergency records
calculate_care_home_cost(): Calculate cost for Care Home records
calculate_community_care_cost(): Calculate community care cost
calculate_community_health_cost(): Calculate cost for Community Health records
calculate_elective_inpatient_cost(): Calculate cost for Elective Inpatient records
calculate_geriatric_cost(): Calculate cost for Geriatric Care records
calculate_home_care_cost(): Calculate cost for Home Care records
calculate_hospital_elective_cost(): Calculate cost for Hospital Elective records
calculate_hospital_emergency_cost(): Calculate cost for Hospital Emergency records
calculate_limited_daycases_cost(): Calculate limited daycases cost
calculate_maternity_cost(): Calculate cost for Maternity records
calculate_multiple_emergency_cost(): Calculate multiple emergency cost
calculate_outpatient_costs(): Calculate cost for Outpatient records
calculate_prescribing_cost(): Calculate cost for Prescribing records
calculate_psychiatry_cost(): Calculate cost for Psychiatry records
calculate_residential_care_cost(): Calculate residential care cost
calculate_routine_daycase_cost(): Calculate routine daycase cost
calculate_single_emergency_cost(): Calculate single emergency cost
create_demographic_cohorts(): Create the Demographic Cohort lookup
create_service_use_cohorts(): Create the Service Use Cohort lookup
recalculate_elective_inpatient_cost(): Recalculate elective inpatient costs
join_sparra_hhg(): Join SPARRA and HHG
join_deaths_data(): Join Deaths data
join_sc_client(): Join sc client variables onto episode file
match_on_ltcs(): Match on LTC DoB and dates of LTC incidence
order_ep_cols(): Order SLF Episode File Columns

Individual file

Building the episode file

add_acute_columns(): Add Acute columns
add_ae_columns(): Add AE columns
add_all_columns(): Add all columns
add_at_columns(): Add AT columns
add_ch_columns(): Add CH columns
add_cij_columns(): Add CIJ-related columns
add_cmh_columns(): Add CMH columns
add_dd_columns(): Add DD columns
add_dn_columns(): Add DN columns
add_gls_columns(): Add GLS columns
add_hc_columns(): Add HC columns
add_hl1_columns(): Add HL1 columns
add_hri_variables(): Add HRI variables to an SLF Individual File
add_ipdc_cols(): Add columns based on IPDC
add_keep_population_flag(): Add keep_popluation flag
add_mat_columns(): Add Mat columns
add_mh_columns(): Add MH columns
add_nrs_columns(): Add NRS columns
add_nsu_columns(): Add NSU columns
add_ooh_columns(): Add OoH columns
add_op_columns(): Add OP columns
add_pis_columns(): Add PIS columns
add_sds_columns(): Add SDS columns
add_standard_cols(): Add standard columns
aggregate_ch_episodes(): Aggregate Care Home episodes to ch_cis
clean_up_ch(): Clean up CH
condition_cols(): Condition columns
create_individual_file(): Create the Source Individual file
flag_non_scottish_residents(): Flag non-Scottish residents
recode_gender(): Recode gender
remove_blank_chi(): Remove blank CHI

Lookups

add_operation_flag(): Add operation flag
assign_cohort_names(): Assign service use cohort into string format
assign_death_flag(): Assign a flag for deaths
assign_d_cohort_mh() assign_d_cohort_frailty() assign_d_cohort_maternity() assign_d_cohort_high_cc() assign_d_cohort_medium_cc() assign_d_cohort_low_cc() assign_d_cohort_comm_living() assign_d_cohort_adult_major() assign_d_cohort_child_major() assign_d_cohort_eol() assign_d_cohort_substance(): Assign Mental Health cohort
assign_elective_daycase_instances(): Assign a flag for elective daycase instances
assign_elective_inpatient_flag(): Assign a flag for elective inpatients
assign_elective_inpatient_instances(): Assign a flag for elective inpatient instances
assign_elective_instances(): Assign a flag for elective instances
assign_emergency_instances(): Assign a flag for emergency instances
assign_s_cohort_ae2(): Assign A&E cohort flag
assign_s_cohort_community_care(): Assign Community Care cohort flag
assign_s_cohort_elective_inpatient(): Assign elective inpatient cohort flag
assign_s_cohort_geriatric(): Assign geriatric cohort flag
assign_s_cohort_limited_daycases(): Assign limited daycases cohort flag
assign_s_cohort_maternity(): Assign maternity cohort flag
assign_s_cohort_multiple_emergency(): Assign multiple emergency cohort flag
assign_s_cohort_outpatient(): Assign outpatient cohort flag
assign_s_cohort_prescribing(): Assign prescribing cohort flag
assign_s_cohort_psychiatry(): Assign psychiatry cohort flag
assign_s_cohort_residential_care(): Assign residential care cohort flag
assign_s_cohort_routine_daycase(): Assign routine daycase cohort flag
assign_s_cohort_single_emergency(): Assign single emergency cohort flag
calculate_acute_elective_cost(): Calculate cost for Acute Elective records
calculate_acute_emergency_cost(): Calculate cost for Acute Emergency records
calculate_ae2_cost(): Calculate cost for Accident & Emergency records
calculate_care_home_cost(): Calculate cost for Care Home records
calculate_community_care_cost(): Calculate community care cost
calculate_community_health_cost(): Calculate cost for Community Health records
calculate_elective_inpatient_cost(): Calculate cost for Elective Inpatient records
calculate_geriatric_cost(): Calculate cost for Geriatric Care records
calculate_home_care_cost(): Calculate cost for Home Care records
calculate_hospital_elective_cost(): Calculate cost for Hospital Elective records
calculate_hospital_emergency_cost(): Calculate cost for Hospital Emergency records
calculate_limited_daycases_cost(): Calculate limited daycases cost
calculate_maternity_cost(): Calculate cost for Maternity records
calculate_multiple_emergency_cost(): Calculate multiple emergency cost
calculate_outpatient_costs(): Calculate cost for Outpatient records
calculate_prescribing_cost(): Calculate cost for Prescribing records
calculate_psychiatry_cost(): Calculate cost for Psychiatry records
calculate_residential_care_cost(): Calculate residential care cost
calculate_routine_daycase_cost(): Calculate routine daycase cost
calculate_single_emergency_cost(): Calculate single emergency cost
create_demographic_cohorts(): Create the Demographic Cohort lookup
create_service_use_cohorts(): Create the Service Use Cohort lookup
recalculate_elective_inpatient_cost(): Recalculate elective inpatient costs
join_sparra_hhg(): Join SPARRA and HHG
join_cohort_lookups(): Join cohort lookups
join_deaths_data(): Join Deaths data
join_slf_lookup_vars(): Join slf lookup variables
match_on_ltcs(): Match on LTC DoB and dates of LTC incidence
order_indiv_cols(): Order SLF Individual File Columns

Demographics

Things related to demographic lookups

fill_geographies(): Fill postcode and GP practice geographies
get_gpprac_opendata(): GP Practice details from PHS open data
make_gpprac_lookup(): Make a GP practice lookup for filling to most recent postcodes based on CHI
make_postcode_lookup(): Make a postcode lookup for filling to most recent postcodes based on CHI
recode_health_boards(): Recode Health Board code to 2018 standard
recode_hscp(): Recode HSCP code to 2018 standard
get_la_code_opendata_lookup(): Download the LA code lookup
rename_hscp(): Rename hscp where applicable for testing

Miscellaneous functions

Miscellaneous functions.

Homelessness

fix_east_ayrshire_duplicates(): Fix the East Ayrshire duplicates - Homelessness
fix_west_dun_duplicates(): Fix the West Dunbartonshire duplicates - Homelessness
produce_homelessness_completeness(): Produce the Homelessness Completeness lookup
fix_scid_renfrewshire(): Fix social care id in renfrewshire

Helper functions

vars_end_with() vars_start_with() vars_contain(): Select columns according to a pattern
max_no_inf(): Custom maximum
min_no_inf(): Custom minimum
setup_keyring(): Interactively set up the keyring

Testing

Tests for the SLF Extracts

format_test_excel(): Format Excel Worksheets of test results
get_existing_data_for_tests(): SLF Data for Testing
produce_test_comparison(): Test Comparison
write_tests_xlsx(): Write out Tests
calculate_measures(): Calculate Measures for Testing
produce_episode_file_ltc_tests(): Source Extract Tests
produce_episode_file_tests(): Source Extract Tests
produce_source_ch_tests(): Source Care Home Tests
produce_source_cmh_tests(): Source Extract Tests
produce_source_dd_tests(): Delayed Discharges extract tests
produce_source_dn_tests(): Source District Nursing Tests
produce_source_extract_tests(): Source Extract Tests
produce_source_hc_tests(): Source Care Home Tests
produce_source_nrs_tests(): Source Extract Tests
produce_source_pis_tests(): Source PIS Tests
produce_it_chi_deaths_tests(): CHI death tests
produce_slf_gpprac_tests(): SLF GP Practice Lookup Tests
produce_slf_homelessness_tests(): SLF Homelessness Extract Tests
produce_slf_postcode_tests(): SLF Postcode Lookup Tests
produce_sc_all_episodes_tests(): Social care All Episodes Tests
produce_sc_demog_lookup_tests(): Social Care Demographic Lookup Tests
produce_source_at_tests(): Alarm Telecare Episodes Tests
produce_source_ltc_tests(): LTC Episodes Tests
produce_source_sds_tests(): SDS Episodes Tests
produce_tests_sc_client_lookup(): Social care Client lookup Tests
combine_extracts_tests_year(): Combine year specific extract tests into one xlsx file by financial year
combine_lookup_tests(): Combine lookup tests to one xlsx file
combine_tests(): Combine split tests
process_tests_acute(): Process Acute tests
process_tests_ae(): Process A&E tests
process_tests_alarms_telecare(): Process Alarms Telecare tests
process_tests_care_home(): Process Care Home tests
process_tests_cmh(): Process CMH tests
process_tests_cross_year(): Process cross year tests
process_tests_delayed_discharges(): Process Delayed Discharges tests
process_tests_district_nursing(): Process District Nursing tests
process_tests_episode_file(): Process Episode file tests
process_tests_gp_ooh(): Process GP OOH tests
process_tests_home_care(): Process Home Care tests
process_tests_homelessness(): Process Homelessness tests
process_tests_individual_file(): Process Individual file tests
process_tests_it_chi_deaths(): Process CHI Deaths tests
process_tests_lookup_gpprac(): Process GP (gpprac) Lookup tests
process_tests_lookup_pc(): Process PC (postcode) Lookup tests
process_tests_ltcs(): Process LTCs tests
process_tests_maternity(): Process Maternity tests
process_tests_mental_health(): Process Mental Health tests
process_tests_nrs_deaths(): Process National Records of Scotland (NRS) deaths tests
process_tests_outpatients(): Process Outpatients tests
process_tests_prescribing(): Process prescribing tests
process_tests_sc_all_at_episodes(): Process Social Care Alarms Telecare all episodes tests
process_tests_sc_all_ch_episodes(): Process Social Care, Care Home all episodes tests
process_tests_sc_all_hc_episodes(): Process Social Care Home Care all episodes tests
process_tests_sc_all_sds_episodes(): Process Social Care SDS all episodes tests
process_tests_sc_client_lookup(): Social care client lookup tests
process_tests_sc_demographics(): Process Social Care Demographics tests
process_tests_sc_sandpit(): Process tests for the social care sandpit extracts
process_tests_sds(): Process SDS tests
produce_individual_file_tests(): Source Extract Tests
produce_sc_sandpit_tests(): Produce tests for social care sandpit extracts.
setup_tests_file_name(): set up file names for tests

Linkage utilities

Functions to extract and link data

extract_ep_ind_time(): Extract time stamp and time consumption of ep or ind files
extract_targets_time(): Extract time stamp and time consumption of targets console output
link_ch_with_adms(): Link AE episodes released from CH
update_uk_postcode_directory(): Update UK postcode directory from ONS API The ONS NHSPD directory is update quarterly.