Files in PHSKC-APDE/claims_data
Query and analyze WA State Medicaid, Medicare, and APCD data

.Rbuildignore
.gitattributes
.gitignore
DESCRIPTION
Desktop
Medicaid package orientation.R
NAMESPACE
R/claims_elig.R R/elig_timevar_collapse.R R/helper_functions.R R/import_packages.R R/mcaid_claim.R R/mcaid_condition.R R/mcaid_covgrp.R R/mcaid_top_n_conds.R R/tabloop.R README.md
analysis/Broad use functions/csvtotable_function.sql
analysis/Broad use functions/longest_common_substring.sql
analysis/Broad use functions/split function.sql
analysis/Broad use functions/sqlexport_speed.R
analysis/Broad use functions/sqlimport_speed.sql
analysis/Medicaid claims functions/README.md analysis/Medicaid claims functions/mcaid_elig_nonsp.R
analysis/Medicaid claims functions/sp_mcaid_claims_detail_r.sql
analysis/Medicaid claims functions/sp_mcaid_claims_simple_r.sql
analysis/Medicaid claims functions/sp_mcaidcohort_r_step1.sql
analysis/Medicaid claims functions/sp_mcaidcohort_r_step2.sql
analysis/Medicaid claims functions/sp_mcaidcohort_sql.sql
claims cleanup/clm_condition_type1_process.R claims cleanup/clm_condition_type2_process.R
claims cleanup/clm_diagnosis_process.sql
claims cleanup/clm_header_process.sql
claims cleanup/clm_line_process.sql
claims cleanup/clm_pharm_process.sql
claims cleanup/clm_procedure_process.sql
claims cleanup/clm_summary_process.sql
claims cleanup/month_matrix_2012-2020.xlsx
claims cleanup/ref_pharm_process.sql
claims cleanup/rolling_time_12mo_2012-2020.xlsx
claims cleanup/rolling_time_24mo_2012-2020.xlsx
claims_db/db_loader/apcd/master_apcd_analytic.R claims_db/db_loader/apcd/master_apcd_full.R
claims_db/db_loader/config/create_table_config_template.yaml
claims_db/db_loader/config/load_table_from_file_config_template.yaml
claims_db/db_loader/config/load_table_from_sql_config_template.yaml
claims_db/db_loader/mcaid/master_mcaid_analytic.R claims_db/db_loader/mcaid/master_mcaid_full.R claims_db/db_loader/mcaid/master_mcaid_partial.R claims_db/db_loader/scripts_general/add_index.R claims_db/db_loader/scripts_general/alter_schema.R claims_db/db_loader/scripts_general/claim_ccw.R claims_db/db_loader/scripts_general/create_table.R claims_db/db_loader/scripts_general/etl_log.R claims_db/db_loader/scripts_general/load_table.R claims_db/db_loader/scripts_general/qa_general.R claims_db/db_loader/scripts_general/qa_load_file.R claims_db/db_loader/scripts_general/qa_load_sql.R
claims_db/phclaims/archive/sprocs/placeholder.txt
claims_db/phclaims/archive/tables/create_archive.address_clean.yaml
claims_db/phclaims/archive/tables/create_archive.apcd_all_analytic_tables_one_time.sql
claims_db/phclaims/archive/tables/create_archive.apcd_cmsdrg_output_multi_ver.yaml
claims_db/phclaims/archive/tables/create_archive.apcd_dental_claim.yaml
claims_db/phclaims/archive/tables/create_archive.apcd_eligibility.yaml
claims_db/phclaims/archive/tables/create_archive.apcd_inpatient_stay_summary_ltd.yaml
claims_db/phclaims/archive/tables/create_archive.apcd_medical_claim.yaml
claims_db/phclaims/archive/tables/create_archive.apcd_medical_claim_header.yaml
claims_db/phclaims/archive/tables/create_archive.apcd_medical_crosswalk.yaml
claims_db/phclaims/archive/tables/create_archive.apcd_member_month_detail.yaml
claims_db/phclaims/archive/tables/create_archive.apcd_pharmacy_claim.yaml
claims_db/phclaims/archive/tables/create_archive.apcd_provider.yaml
claims_db/phclaims/archive/tables/create_archive.apcd_provider_master.yaml
claims_db/phclaims/archive/tables/create_archive.apcd_provider_practice_roster.yaml
claims_db/phclaims/archive/tables/create_archive.hedis_value_set.sql
claims_db/phclaims/archive/tables/create_archive.mcaid_elig.yaml
claims_db/phclaims/archive/tables/create_archive.perf_all_tables.sql
claims_db/phclaims/archive/tables/create_archive.rda_value_set.sql
claims_db/phclaims/archive/tables/load_archive.apcd_cmsdrg_output_multi_ver.yaml
claims_db/phclaims/archive/tables/load_archive.apcd_dental_claim.yaml
claims_db/phclaims/archive/tables/load_archive.apcd_eligibility.yaml
claims_db/phclaims/archive/tables/load_archive.apcd_inpatient_stay_summary_ltd.yaml
claims_db/phclaims/archive/tables/load_archive.apcd_medical_claim.yaml
claims_db/phclaims/archive/tables/load_archive.apcd_medical_claim_header.yaml
claims_db/phclaims/archive/tables/load_archive.apcd_medical_crosswalk.yaml
claims_db/phclaims/archive/tables/load_archive.apcd_member_month_detail.yaml
claims_db/phclaims/archive/tables/load_archive.apcd_pharmacy_claim.yaml
claims_db/phclaims/archive/tables/load_archive.apcd_provider.yaml
claims_db/phclaims/archive/tables/load_archive.apcd_provider_master.yaml
claims_db/phclaims/archive/tables/load_archive.apcd_provider_practice_roster.yaml
claims_db/phclaims/archive/tables/load_archive.hedis_value_set.sql
claims_db/phclaims/archive/tables/master_archive.apcd_quarterly.R
claims_db/phclaims/archive/tables/qa_archive.apcd_all_tables.sql
claims_db/phclaims/final/indexes/placeholder.txt
claims_db/phclaims/final/sprocs/placeholder.txt
claims_db/phclaims/final/tables/create_final.apcd_claim_ccw.sql
claims_db/phclaims/final/tables/create_final.apcd_claim_header.sql
claims_db/phclaims/final/tables/create_final.apcd_claim_icdcm_header.sql
claims_db/phclaims/final/tables/create_final.apcd_claim_line.sql
claims_db/phclaims/final/tables/create_final.apcd_claim_procedure.sql
claims_db/phclaims/final/tables/create_final.apcd_claim_provider.sql
claims_db/phclaims/final/tables/create_final.apcd_elig_demo.sql
claims_db/phclaims/final/tables/create_final.apcd_elig_plr.sql
claims_db/phclaims/final/tables/create_final.apcd_elig_timevar.sql
claims_db/phclaims/final/tables/create_final.mcaid_claim_all.sql
claims_db/phclaims/final/tables/create_final.mcaid_elig_demo.yaml
claims_db/phclaims/final/tables/create_final.mcaid_elig_timevar.yaml
claims_db/phclaims/final/tables/final_perf_measure.sql
claims_db/phclaims/final/tables/load_final.apcd_claim_ccw.sql
claims_db/phclaims/final/tables/load_final.apcd_claim_header.sql
claims_db/phclaims/final/tables/load_final.apcd_claim_icdcm_header.sql
claims_db/phclaims/final/tables/load_final.apcd_claim_line.sql
claims_db/phclaims/final/tables/load_final.apcd_claim_procedure.sql
claims_db/phclaims/final/tables/load_final.apcd_claim_provider.sql
claims_db/phclaims/final/tables/load_final.apcd_elig_demo.sql
claims_db/phclaims/final/tables/load_final.apcd_elig_plr.sql
claims_db/phclaims/final/tables/load_final.apcd_elig_timevar.sql
claims_db/phclaims/final/tables/load_final.mcaid_claim_all.sql
claims_db/phclaims/final/tables/load_final.mcaid_claim_ccw.yaml
claims_db/phclaims/final/tables/load_final.mcaid_elig_demo.yaml
claims_db/phclaims/final/tables/load_final.mcaid_elig_timevar.yaml
claims_db/phclaims/final/tables/load_final.mcaid_mcare_elig_demo.sql
claims_db/phclaims/final/tables/load_final.mcaid_mcare_elig_timevar.sql
claims_db/phclaims/final/tables/load_final.mcare_elig_demo.sql
claims_db/phclaims/final/tables/load_final.mcare_elig_timevar.sql
claims_db/phclaims/final/tables/load_final.xwalk_apde_mcaid_mcare_pha.sql
claims_db/phclaims/final/tables/qa_final.apcd_claim_ccw.sql
claims_db/phclaims/final/tables/qa_final.apcd_claim_header.sql
claims_db/phclaims/final/tables/qa_final.apcd_claim_icdcm_header.sql
claims_db/phclaims/final/tables/qa_final.apcd_claim_line.sql
claims_db/phclaims/final/tables/qa_final.apcd_claim_procedure.sql
claims_db/phclaims/final/tables/qa_final.apcd_claim_provider.sql
claims_db/phclaims/final/tables/qa_final.apcd_elig_demo.sql
claims_db/phclaims/final/tables/qa_final.apcd_elig_plr.sql
claims_db/phclaims/final/tables/qa_final.apcd_elig_timevar.sql
claims_db/phclaims/final/tables/qa_final.mcaid_claim_all.sql
claims_db/phclaims/load_raw/tables/archive/create_load_raw.apcd_dental_claim.R claims_db/phclaims/load_raw/tables/archive/create_load_raw.apcd_eligibility.R claims_db/phclaims/load_raw/tables/archive/create_load_raw.apcd_medical_claim.R claims_db/phclaims/load_raw/tables/archive/create_load_raw.apcd_medical_claim_column_add.R claims_db/phclaims/load_raw/tables/archive/create_load_raw.apcd_medical_claim_header.R claims_db/phclaims/load_raw/tables/archive/create_load_raw.apcd_medical_crosswalk.R claims_db/phclaims/load_raw/tables/archive/create_load_raw.apcd_member_month_detail.R claims_db/phclaims/load_raw/tables/archive/create_load_raw.apcd_pharmacy_claim.R claims_db/phclaims/load_raw/tables/archive/create_load_raw.apcd_provider.R claims_db/phclaims/load_raw/tables/archive/create_load_raw.apcd_small_lds_tables.R
claims_db/phclaims/load_raw/tables/archive/drop_load_raw.apcd_all_tables.sql
claims_db/phclaims/load_raw/tables/archive/drop_row_number_load_raw.apcd_all_tables.sql
claims_db/phclaims/load_raw/tables/archive/qa_load_raw.apcd_all_tables.sql
claims_db/phclaims/load_raw/tables/aws_s3_sync.apcd_all_tables.R claims_db/phclaims/load_raw/tables/count_lines.apcd_all_tables.R
claims_db/phclaims/load_raw/tables/create_load_raw.mcaid_claim.yaml
claims_db/phclaims/load_raw/tables/create_load_raw.mcaid_elig.yaml
claims_db/phclaims/load_raw/tables/create_yaml.apcd_all_tables_full.R claims_db/phclaims/load_raw/tables/load_load_raw.apcd_dental_claim_full.R
claims_db/phclaims/load_raw/tables/load_load_raw.apcd_dental_claim_full.yaml
claims_db/phclaims/load_raw/tables/load_load_raw.apcd_eligibility_full.R
claims_db/phclaims/load_raw/tables/load_load_raw.apcd_eligibility_full.yaml
claims_db/phclaims/load_raw/tables/load_load_raw.apcd_medical_claim_full.R
claims_db/phclaims/load_raw/tables/load_load_raw.apcd_medical_claim_full.yaml
claims_db/phclaims/load_raw/tables/load_load_raw.apcd_member_month_detail_full.R
claims_db/phclaims/load_raw/tables/load_load_raw.apcd_member_month_detail_full.yaml
claims_db/phclaims/load_raw/tables/load_load_raw.apcd_pharmacy_claim_full.R
claims_db/phclaims/load_raw/tables/load_load_raw.apcd_pharmacy_claim_full.yaml
claims_db/phclaims/load_raw/tables/load_load_raw.apcd_provider_full.R
claims_db/phclaims/load_raw/tables/load_load_raw.apcd_provider_full.yaml
claims_db/phclaims/load_raw/tables/load_load_raw.apcd_provider_master_full.R
claims_db/phclaims/load_raw/tables/load_load_raw.apcd_provider_master_full.yaml
claims_db/phclaims/load_raw/tables/load_load_raw.apcd_provider_practice_roster_full.R
claims_db/phclaims/load_raw/tables/load_load_raw.apcd_provider_practice_roster_full.yaml
claims_db/phclaims/load_raw/tables/load_load_raw.mcaid_claim_full.R
claims_db/phclaims/load_raw/tables/load_load_raw.mcaid_claim_full.yaml
claims_db/phclaims/load_raw/tables/load_load_raw.mcaid_claim_partial.R
claims_db/phclaims/load_raw/tables/load_load_raw.mcaid_claim_partial.yaml
claims_db/phclaims/load_raw/tables/load_load_raw.mcaid_elig_full.R
claims_db/phclaims/load_raw/tables/load_load_raw.mcaid_elig_full.yaml
claims_db/phclaims/load_raw/tables/load_load_raw.mcaid_elig_partial.R
claims_db/phclaims/load_raw/tables/load_load_raw.mcaid_elig_partial.yaml
claims_db/phclaims/load_raw/tables/load_load_raw.ofm_xwalk_data.r
claims_db/phclaims/metadata/sprocs/create_metadata.v_mcaid_claim_elig_summary.sql
claims_db/phclaims/metadata/sprocs/create_metadata.v_perf_measure_summary.sql
claims_db/phclaims/metadata/sprocs/create_metadata.v_rda_value_set_summary.sql
claims_db/phclaims/metadata/tables/create_metadata.etl_log.R
claims_db/phclaims/metadata/tables/create_metadata.etl_log.yaml
claims_db/phclaims/metadata/tables/create_metadata.mcaid_format_change.sql
claims_db/phclaims/metadata/tables/create_metadata.qa_mcaid.R
claims_db/phclaims/metadata/tables/create_metadata.qa_mcaid.yaml
claims_db/phclaims/metadata/tables/create_metadata.qa_mcaid_values.yaml
claims_db/phclaims/metadata/tables/create_metadata.qa_mcare.R
claims_db/phclaims/phclaims.sln
claims_db/phclaims/phclaims.sqlproj
claims_db/phclaims/ref/indexes/index_ref.tables.sql
claims_db/phclaims/ref/indexes/placeholder.txt
claims_db/phclaims/ref/tables/archive/create_ref.apcd_claim_no_elig.sql
claims_db/phclaims/ref/tables/archive/create_ref.apcd_provider_npi.sql
claims_db/phclaims/ref/tables/archive/load_ref.apcd_claim_no_elig.sql
claims_db/phclaims/ref/tables/archive/load_ref.apcd_provider_npi.sql
claims_db/phclaims/ref/tables/archive/qa_ref.apcd_claim_no_elig.sql
claims_db/phclaims/ref/tables/archive/qa_ref.apcd_provider_npi.sql
claims_db/phclaims/ref/tables/archive/qa_ref.king_provider_master.sql
claims_db/phclaims/ref/tables/create_ref.address_geocode.yaml
claims_db/phclaims/ref/tables/create_ref.age_grp.sql
claims_db/phclaims/ref/tables/create_ref.bree_value_set.sql
claims_db/phclaims/ref/tables/create_ref.date.sql
claims_db/phclaims/ref/tables/create_ref.hedis_value_set.sql
claims_db/phclaims/ref/tables/create_ref.kc_claim_type.yaml
claims_db/phclaims/ref/tables/create_ref.kc_claim_type_crosswalk.yaml
claims_db/phclaims/ref/tables/create_ref.mcaid_rac_code.sql
claims_db/phclaims/ref/tables/create_ref.num.sql
claims_db/phclaims/ref/tables/create_ref.perf_measure.sql
claims_db/phclaims/ref/tables/create_ref.perf_measure_name_xwalk.sql
claims_db/phclaims/ref/tables/create_ref.perf_year_month.sql
claims_db/phclaims/ref/tables/create_ref.rda_value_set.sql
claims_db/phclaims/ref/tables/create_ref.taxonomy.sql
claims_db/phclaims/ref/tables/load_ref.address_clean.yaml
claims_db/phclaims/ref/tables/load_ref.address_clean_full.R
claims_db/phclaims/ref/tables/load_ref.address_geocode.yaml
claims_db/phclaims/ref/tables/load_ref.apcd_ethnicity_race_map.R
claims_db/phclaims/ref/tables/load_ref.apcd_ethnicity_race_map.yaml
claims_db/phclaims/ref/tables/load_ref.apcd_mcare_carrier_billing_npi.sql
claims_db/phclaims/ref/tables/load_ref.apcd_provider_npi.R
claims_db/phclaims/ref/tables/load_ref.apcd_provider_npi.yaml
claims_db/phclaims/ref/tables/load_ref.apcd_reference_tables_full.R claims_db/phclaims/ref/tables/load_ref.bree_value_set.R
claims_db/phclaims/ref/tables/load_ref.bree_value_set.sql
claims_db/phclaims/ref/tables/load_ref.ccw_lookup.R
claims_db/phclaims/ref/tables/load_ref.ccw_lookup.yaml
claims_db/phclaims/ref/tables/load_ref.dx_lookup.R claims_db/phclaims/ref/tables/load_ref.geo_county_code_wa.R
claims_db/phclaims/ref/tables/load_ref.geo_county_code_wa.yaml
claims_db/phclaims/ref/tables/load_ref.hedis_value_set.R
claims_db/phclaims/ref/tables/load_ref.hedis_value_set.sql
claims_db/phclaims/ref/tables/load_ref.kc_claim_type.R
claims_db/phclaims/ref/tables/load_ref.kc_claim_type.yaml
claims_db/phclaims/ref/tables/load_ref.kc_claim_type_crosswalk.R
claims_db/phclaims/ref/tables/load_ref.kc_claim_type_crosswalk.yaml
claims_db/phclaims/ref/tables/load_ref.kc_provider_master.R
claims_db/phclaims/ref/tables/load_ref.kc_provider_master.sql
claims_db/phclaims/ref/tables/load_ref.kc_provider_master.yaml
claims_db/phclaims/ref/tables/load_ref.mcaid_rac_code.R
claims_db/phclaims/ref/tables/load_ref.mcaid_rac_code.sql
claims_db/phclaims/ref/tables/load_ref.rda_value_set.R
claims_db/phclaims/ref/tables/load_ref.rda_value_set.sql
claims_db/phclaims/ref/tables/load_ref.taxonomy.R
claims_db/phclaims/ref/tables/load_ref.taxonomy.sql
claims_db/phclaims/ref/tables/qa_ref.date.sql
claims_db/phclaims/ref/tables/qa_ref.hedis_value_set.sql
claims_db/phclaims/ref/tables/qa_ref.mcaid_rac_code.sql
claims_db/phclaims/ref/tables_data/Bree-Opioid-NDC-2017-exclude.xlsx
claims_db/phclaims/ref/tables_data/Bree-Opioid-NDC-2017-include.xlsx
claims_db/phclaims/ref/tables_data/Medicaid-RAC-Codes-for-Inclusion-Criteria-and-Grouping DSHS.xlsx
claims_db/phclaims/ref/tables_data/SUD-Tx-Pen-Value-Set-1.xlsx
claims_db/phclaims/ref/tables_data/ref.city_lookup.csv
claims_db/phclaims/ref/tables_data/ref.perf_measure.xlsx
claims_db/phclaims/ref/tables_data/ref.perf_measure_name_xwalk.xlsx
claims_db/phclaims/schemas/archive.sql
claims_db/phclaims/schemas/final.sql
claims_db/phclaims/schemas/load_raw.sql
claims_db/phclaims/schemas/metadata.sql
claims_db/phclaims/schemas/ref.sql
claims_db/phclaims/schemas/stage.sql
claims_db/phclaims/schemas/tmp.sql
claims_db/phclaims/stage/indexes/placeholder.txt
claims_db/phclaims/stage/sprocs/create_stage.fn_perf_enroll_member_month.sql
claims_db/phclaims/stage/sprocs/create_stage.fn_perf_fua_ed_index_visit.sql
claims_db/phclaims/stage/sprocs/create_stage.fn_perf_fua_ed_index_visit_exclusion.sql
claims_db/phclaims/stage/sprocs/create_stage.fn_perf_fua_follow_up_visit.sql
claims_db/phclaims/stage/sprocs/create_stage.fn_perf_fum_follow_up_visit.sql
claims_db/phclaims/stage/sprocs/create_stage.sp_mcaid_claim_header.sql
claims_db/phclaims/stage/sprocs/create_stage.sp_perf_distinct_member.sql
claims_db/phclaims/stage/sprocs/create_stage.sp_perf_elig_member_month.sql
claims_db/phclaims/stage/sprocs/create_stage.sp_perf_enroll_denom.sql
claims_db/phclaims/stage/sprocs/create_stage.sp_perf_enroll_provider.sql
claims_db/phclaims/stage/sprocs/create_stage.sp_perf_fua_join_step.sql
claims_db/phclaims/stage/sprocs/create_stage.sp_perf_fuh_join_step.sql
claims_db/phclaims/stage/sprocs/create_stage.sp_perf_fum_join_step.sql
claims_db/phclaims/stage/sprocs/create_stage.sp_perf_measures.sql
claims_db/phclaims/stage/sprocs/create_stage.sp_perf_pcr_join_step.sql
claims_db/phclaims/stage/sprocs/create_stage.sp_perf_staging.sql
claims_db/phclaims/stage/sprocs/create_stage.v_perf_ah_inpatient_direct_transfer.sql
claims_db/phclaims/stage/sprocs/create_stage.v_perf_ah_inpatient_exclusion.sql
claims_db/phclaims/stage/sprocs/create_stage.v_perf_ah_inpatient_numerator.sql
claims_db/phclaims/stage/sprocs/create_stage.v_perf_ah_medicine_surgery.sql
claims_db/phclaims/stage/sprocs/create_stage.v_perf_ah_observation_stay.sql
claims_db/phclaims/stage/sprocs/create_stage.v_perf_cap_ambulatory_visit.sql
claims_db/phclaims/stage/sprocs/create_stage.v_perf_ed_visit_num.sql
claims_db/phclaims/stage/sprocs/create_stage.v_perf_fuh_follow_up_visit.sql
claims_db/phclaims/stage/sprocs/create_stage.v_perf_fuh_inpatient_index_stay.sql
claims_db/phclaims/stage/sprocs/create_stage.v_perf_fuh_inpatient_index_stay_readmit.sql
claims_db/phclaims/stage/sprocs/create_stage.v_perf_hospice_member_month.sql
claims_db/phclaims/stage/sprocs/create_stage.v_perf_pcr_inpatient_direct_transfer.sql
claims_db/phclaims/stage/sprocs/create_stage.v_perf_pcr_planned_exclusion.sql
claims_db/phclaims/stage/sprocs/create_stage.v_perf_pcr_pregnancy_exclusion.sql
claims_db/phclaims/stage/sprocs/create_stage.v_perf_tpm_denominator.sql
claims_db/phclaims/stage/sprocs/create_stage.v_perf_tpm_numerator.sql
claims_db/phclaims/stage/sprocs/create_stage.v_perf_tpm_sub_denominator.sql
claims_db/phclaims/stage/sprocs/create_stage.v_perf_tpm_sub_numerator.sql
claims_db/phclaims/stage/sprocs/create_stage.v_perf_tpo_denominator.sql
claims_db/phclaims/stage/sprocs/create_stage.v_perf_tpo_numerator.sql
claims_db/phclaims/stage/sprocs/create_stage.v_perf_tps_denominator.sql
claims_db/phclaims/stage/sprocs/create_stage.v_perf_tps_numerator.sql
claims_db/phclaims/stage/tables/archive/create_stage.apcd_all_tables_initial_load.R
claims_db/phclaims/stage/tables/archive/load_stage.apcd_claim_icdcm_header.sql
claims_db/phclaims/stage/tables/archive/load_stage.apcd_claim_icdcm_line.sql
claims_db/phclaims/stage/tables/archive/load_stage.apcd_claim_line.sql
claims_db/phclaims/stage/tables/archive/load_stage.apcd_claim_procedure.sql
claims_db/phclaims/stage/tables/archive/load_stage.apcd_claim_provider.sql
claims_db/phclaims/stage/tables/archive/load_stage.apcd_elig_demo.sql
claims_db/phclaims/stage/tables/archive/load_stage.apcd_elig_plr.sql
claims_db/phclaims/stage/tables/archive/load_stage.apcd_elig_timevar.sql
claims_db/phclaims/stage/tables/archive/load_stage.apcd_elig_year_month_matrix.R
claims_db/phclaims/stage/tables/archive/load_stage.apcd_elig_year_month_matrix.yaml
claims_db/phclaims/stage/tables/archive/load_stage.mcaid_mcare_claim_header.sql
claims_db/phclaims/stage/tables/archive/load_stage.mcaid_mcare_claim_icdcm_header.sql
claims_db/phclaims/stage/tables/archive/qa_stage.apcd_claim_icdcm_header.sql
claims_db/phclaims/stage/tables/archive/qa_stage.apcd_claim_line.sql
claims_db/phclaims/stage/tables/archive/qa_stage.apcd_claim_procedure.sql
claims_db/phclaims/stage/tables/archive/qa_stage.apcd_claim_provider.sql
claims_db/phclaims/stage/tables/create_stage.address_geocode.yaml
claims_db/phclaims/stage/tables/create_stage.apcd_claim_header.sql
claims_db/phclaims/stage/tables/create_stage.mcaid_claim.yaml
claims_db/phclaims/stage/tables/create_stage.mcaid_claim_header.yaml
claims_db/phclaims/stage/tables/create_stage.mcaid_claim_icdcm_header.yaml
claims_db/phclaims/stage/tables/create_stage.mcaid_claim_pharm.yaml
claims_db/phclaims/stage/tables/create_stage.mcaid_claim_procedure.yaml
claims_db/phclaims/stage/tables/create_stage.mcaid_claim_value_set.sql
claims_db/phclaims/stage/tables/create_stage.mcaid_elig.yaml
claims_db/phclaims/stage/tables/create_stage.mcaid_elig_demo.yaml
claims_db/phclaims/stage/tables/create_stage.mcaid_elig_timevar.yaml
claims_db/phclaims/stage/tables/create_stage.perf_enroll_denom.sql
claims_db/phclaims/stage/tables/create_stage.perf_staging.sql
claims_db/phclaims/stage/tables/create_stage.perf_staging_event_date.sql
claims_db/phclaims/stage/tables/load_stage.address_clean.yaml
claims_db/phclaims/stage/tables/load_stage.address_clean_full.R claims_db/phclaims/stage/tables/load_stage.address_clean_partial_step1.R claims_db/phclaims/stage/tables/load_stage.address_clean_partial_step2.R claims_db/phclaims/stage/tables/load_stage.address_geocode.R claims_db/phclaims/stage/tables/load_stage.address_geocode_partial.R
claims_db/phclaims/stage/tables/load_stage.apcd_claim_ccw.yaml
claims_db/phclaims/stage/tables/load_stage.apcd_claim_header.sql
claims_db/phclaims/stage/tables/load_stage.apcd_claim_icdcm_header.R
claims_db/phclaims/stage/tables/load_stage.apcd_claim_icdcm_header.yaml
claims_db/phclaims/stage/tables/load_stage.apcd_claim_line.R
claims_db/phclaims/stage/tables/load_stage.apcd_claim_line.yaml
claims_db/phclaims/stage/tables/load_stage.apcd_claim_procedure.R
claims_db/phclaims/stage/tables/load_stage.apcd_claim_procedure.yaml
claims_db/phclaims/stage/tables/load_stage.apcd_claim_provider.R
claims_db/phclaims/stage/tables/load_stage.apcd_claim_provider.yaml
claims_db/phclaims/stage/tables/load_stage.apcd_elig_demo.R
claims_db/phclaims/stage/tables/load_stage.apcd_elig_demo.yaml
claims_db/phclaims/stage/tables/load_stage.apcd_elig_plr.R
claims_db/phclaims/stage/tables/load_stage.apcd_elig_plr_2014.yaml
claims_db/phclaims/stage/tables/load_stage.apcd_elig_plr_2015.yaml
claims_db/phclaims/stage/tables/load_stage.apcd_elig_plr_2016.yaml
claims_db/phclaims/stage/tables/load_stage.apcd_elig_plr_2017.yaml
claims_db/phclaims/stage/tables/load_stage.apcd_elig_plr_2018.yaml
claims_db/phclaims/stage/tables/load_stage.apcd_elig_timevar.R
claims_db/phclaims/stage/tables/load_stage.apcd_elig_timevar.yaml
claims_db/phclaims/stage/tables/load_stage.mcaid_claim_MASTER.R
claims_db/phclaims/stage/tables/load_stage.mcaid_claim_ccw.yaml
claims_db/phclaims/stage/tables/load_stage.mcaid_claim_full.R
claims_db/phclaims/stage/tables/load_stage.mcaid_claim_full.yaml
claims_db/phclaims/stage/tables/load_stage.mcaid_claim_header.R claims_db/phclaims/stage/tables/load_stage.mcaid_claim_icdcm_header.R claims_db/phclaims/stage/tables/load_stage.mcaid_claim_line.R claims_db/phclaims/stage/tables/load_stage.mcaid_claim_partial.R
claims_db/phclaims/stage/tables/load_stage.mcaid_claim_partial.yaml
claims_db/phclaims/stage/tables/load_stage.mcaid_claim_pharm.R claims_db/phclaims/stage/tables/load_stage.mcaid_claim_procedure.R
claims_db/phclaims/stage/tables/load_stage.mcaid_claim_value_set.sql
claims_db/phclaims/stage/tables/load_stage.mcaid_elig_demo.R claims_db/phclaims/stage/tables/load_stage.mcaid_elig_full.R
claims_db/phclaims/stage/tables/load_stage.mcaid_elig_full.yaml
claims_db/phclaims/stage/tables/load_stage.mcaid_elig_partial.R
claims_db/phclaims/stage/tables/load_stage.mcaid_elig_partial.yaml
claims_db/phclaims/stage/tables/load_stage.mcaid_elig_timevar.R claims_db/phclaims/stage/tables/load_stage.mcaid_mcare_claim_ccw.R
claims_db/phclaims/stage/tables/load_stage.mcaid_mcare_claim_ccw.yaml
claims_db/phclaims/stage/tables/load_stage.mcaid_mcare_claim_header.R
claims_db/phclaims/stage/tables/load_stage.mcaid_mcare_claim_header.yaml
claims_db/phclaims/stage/tables/load_stage.mcaid_mcare_claim_icdcm_header.R
claims_db/phclaims/stage/tables/load_stage.mcaid_mcare_claim_icdcm_header.yaml
claims_db/phclaims/stage/tables/load_stage.mcaid_mcare_elig_demo.R
claims_db/phclaims/stage/tables/load_stage.mcaid_mcare_elig_demo.yaml
claims_db/phclaims/stage/tables/load_stage.mcaid_mcare_elig_timevar.R
claims_db/phclaims/stage/tables/load_stage.mcaid_mcare_elig_timevar.yaml
claims_db/phclaims/stage/tables/load_stage.mcaid_perf_measures_amr.R
claims_db/phclaims/stage/tables/load_stage.mcare_claim_ccw.yaml
claims_db/phclaims/stage/tables/load_stage.mcare_elig_demo.R
claims_db/phclaims/stage/tables/load_stage.mcare_elig_demo.yaml
claims_db/phclaims/stage/tables/load_stage.mcare_elig_timevar.R
claims_db/phclaims/stage/tables/load_stage.mcare_elig_timevar.yaml
claims_db/phclaims/stage/tables/load_stage.mcare_mbsf.r
claims_db/phclaims/stage/tables/load_stage.mcare_mbsf.yaml
claims_db/phclaims/stage/tables/load_stage.xwalk_apde_mcaid_mcare_pha.r
claims_db/phclaims/stage/tables/qa_stage.apcd_all_tables_quarterly_refresh.sql
claims_db/phclaims/stage/tables/qa_stage.apcd_claim_ccw.sql
claims_db/phclaims/stage/tables/qa_stage.apcd_claim_header.sql
claims_db/phclaims/stage/tables/qa_stage.mcaid_claim_ccw.R
claims_db/phclaims/stage/tables/qa_stage.mcaid_claim_header.sql
claims_db/phclaims/stage/tables/qa_stage.mcaid_claim_icdcm_header.sql
claims_db/phclaims/stage/tables/qa_stage.mcaid_claim_line.sql
claims_db/phclaims/stage/tables/qa_stage.mcaid_claim_pharm.sql
claims_db/phclaims/stage/tables/qa_stage.mcaid_claim_procedure.sql
claims_db/phclaims/stage/tables/qa_stage.mcaid_elig_demo.R claims_db/phclaims/stage/tables/qa_stage.mcaid_elig_timevar.R
claims_db/phclaims/stage/tables/qa_stage.mcaid_mcare_claim_ccw.sql
claims_db/phclaims/stage/tables/qa_stage.mcare_elig_timevar.R
claims_db/phclaims/stage/tables/qa_tmp.mcare_claim_ccw.sql
eligibility cleanup/elig_address_clean_process.R eligibility cleanup/elig_address_geocoding.R
eligibility cleanup/elig_address_process.sql
eligibility cleanup/elig_covgrp_process.sql
eligibility cleanup/elig_overall_process.sql
eligibility cleanup/elig_timevar_process.sql
man/claims_elig.Rd man/helper.Rd man/mcaid_claim_f.Rd man/mcaid_condition_f.Rd man/mcaid_covgrp_f.Rd man/tabloop_f.Rd man/top_causes_f.Rd
reference documents/Medicaid Provider Report Vol. 2 - Technical Documentation (April 2018).xlsx
PHSKC-APDE/claims_data documentation built on Nov. 6, 2019, 11:45 a.m.