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

.Rbuildignore

.gitattributes

.gitignore

DESCRIPTION

Desktop

NAMESPACE

R/claims_condition.R R/claims_elig.R R/elig_timevar_collapse.R R/helper_functions.R R/import_packages.R R/tabloop.R R/top_causes.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

apcd_export_import/APCD CSV Export SSIS/APCD CSV Export.database

apcd_export_import/APCD CSV Export SSIS/APCD CSV Export.dtproj

apcd_export_import/APCD CSV Export SSIS/APCD CSV Export.dtproj.user

apcd_export_import/APCD CSV Export SSIS/APCD CSV Export.sln

apcd_export_import/APCD CSV Export SSIS/Package.dtsx

apcd_export_import/APCD CSV Export SSIS/Project.params

apcd_export_import/APCD CSV Export SSIS/bin/Development/APCD CSV Export.ispac

apcd_export_import/APCD CSV Export SSIS/obj/Development/APCD CSV Export.dtproj

apcd_export_import/APCD CSV Export SSIS/obj/Development/BuildLog.xml

apcd_export_import/APCD CSV Export SSIS/obj/Development/Package.dtsx

apcd_export_import/APCD CSV Export SSIS/obj/Development/Project.params

apcd_export_import/APCD_Import_README.docx

apcd_export_import/APCD_Tables_20220609.xlsx

apcd_export_import/apcd_export_scripts.R apcd_export_import/apcd_import.R apcd_export_import/apcd_import_apde.R apcd_export_import/apcd_import_auto.R

apcd_export_import/apcd_import_config.yaml

apcd_export_import/apcd_import_functions.R claims_db/db_loader/apcd/01_apcd_aws_s3_sync_cifs.R claims_db/db_loader/apcd/02_apcd_create_yaml_files.R claims_db/db_loader/apcd/03_apcd_azure_blob_storage_upload.R claims_db/db_loader/apcd/04_apcd_copy_into_inthealth_edw.R claims_db/db_loader/apcd/05_apcd_load_reference_tables_hhsaw.R claims_db/db_loader/apcd/06_apcd_create_analytic_tables.R

claims_db/db_loader/apcd/20240318_ExternalTables_hhsaw_apcd_v3.sql

claims_db/db_loader/apcd/archived/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/phclaims/archive/sprocs/placeholder.txt

claims_db/phclaims/archive/tables/archive/create_archive.apcd_cmsdrg_output_multi_ver.yaml

claims_db/phclaims/archive/tables/archive/create_archive.apcd_dental_claim.yaml

claims_db/phclaims/archive/tables/archive/create_archive.apcd_eligibility.yaml

claims_db/phclaims/archive/tables/archive/create_archive.apcd_inpatient_stay_summary_ltd.yaml

claims_db/phclaims/archive/tables/archive/create_archive.apcd_medical_claim.yaml

claims_db/phclaims/archive/tables/archive/create_archive.apcd_medical_claim_header.yaml

claims_db/phclaims/archive/tables/archive/create_archive.apcd_medical_crosswalk.yaml

claims_db/phclaims/archive/tables/archive/create_archive.apcd_member_month_detail.yaml

claims_db/phclaims/archive/tables/archive/create_archive.apcd_pharmacy_claim.yaml

claims_db/phclaims/archive/tables/archive/create_archive.apcd_provider.yaml

claims_db/phclaims/archive/tables/archive/create_archive.apcd_provider_master.yaml

claims_db/phclaims/archive/tables/archive/create_archive.apcd_provider_practice_roster.yaml

claims_db/phclaims/archive/tables/archive/load_archive.apcd_cmsdrg_output_multi_ver.yaml

claims_db/phclaims/archive/tables/archive/load_archive.apcd_dental_claim.yaml

claims_db/phclaims/archive/tables/archive/load_archive.apcd_eligibility.yaml

claims_db/phclaims/archive/tables/archive/load_archive.apcd_inpatient_stay_summary_ltd.yaml

claims_db/phclaims/archive/tables/archive/load_archive.apcd_medical_claim.yaml

claims_db/phclaims/archive/tables/archive/load_archive.apcd_medical_claim_header.yaml

claims_db/phclaims/archive/tables/archive/load_archive.apcd_medical_crosswalk.yaml

claims_db/phclaims/archive/tables/archive/load_archive.apcd_member_month_detail.yaml

claims_db/phclaims/archive/tables/archive/load_archive.apcd_pharmacy_claim.yaml

claims_db/phclaims/archive/tables/archive/load_archive.apcd_provider.yaml

claims_db/phclaims/archive/tables/archive/load_archive.apcd_provider_master.yaml

claims_db/phclaims/archive/tables/archive/load_archive.apcd_provider_practice_roster.yaml

claims_db/phclaims/archive/tables/archive/master_archive.apcd_quarterly.R

claims_db/phclaims/archive/tables/archive/qa_archive.apcd_all_tables.sql

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.hedis_value_set.sql

claims_db/phclaims/archive/tables/load_archive.hedis_value_set.sql

claims_db/phclaims/final/sprocs/placeholder.txt

claims_db/phclaims/final/tables/archive/create_final.apcd_claim_ccw.sql

claims_db/phclaims/final/tables/archive/create_final.apcd_claim_header.sql

claims_db/phclaims/final/tables/archive/create_final.apcd_claim_icdcm_header.sql

claims_db/phclaims/final/tables/archive/create_final.apcd_claim_line.sql

claims_db/phclaims/final/tables/archive/create_final.apcd_claim_procedure.sql

claims_db/phclaims/final/tables/archive/create_final.apcd_claim_provider.sql

claims_db/phclaims/final/tables/archive/create_final.apcd_elig_demo.sql

claims_db/phclaims/final/tables/archive/create_final.apcd_elig_plr.sql

claims_db/phclaims/final/tables/archive/create_final.apcd_elig_timevar.sql

claims_db/phclaims/final/tables/archive/load_final.apcd_claim_ccw.sql

claims_db/phclaims/final/tables/archive/load_final.apcd_claim_header.sql

claims_db/phclaims/final/tables/archive/load_final.apcd_claim_icdcm_header.sql

claims_db/phclaims/final/tables/archive/load_final.apcd_claim_line.sql

claims_db/phclaims/final/tables/archive/load_final.apcd_claim_procedure.sql

claims_db/phclaims/final/tables/archive/load_final.apcd_claim_provider.sql

claims_db/phclaims/final/tables/archive/load_final.apcd_elig_demo.sql

claims_db/phclaims/final/tables/archive/load_final.apcd_elig_plr.sql

claims_db/phclaims/final/tables/archive/load_final.apcd_elig_timevar.sql

claims_db/phclaims/final/tables/archive/qa_final.apcd_claim_ccw.sql

claims_db/phclaims/final/tables/archive/qa_final.apcd_claim_header.sql

claims_db/phclaims/final/tables/archive/qa_final.apcd_claim_icdcm_header.sql

claims_db/phclaims/final/tables/archive/qa_final.apcd_claim_line.sql

claims_db/phclaims/final/tables/archive/qa_final.apcd_claim_procedure.sql

claims_db/phclaims/final/tables/archive/qa_final.apcd_claim_provider.sql

claims_db/phclaims/final/tables/archive/qa_final.apcd_elig_demo.sql

claims_db/phclaims/final/tables/archive/qa_final.apcd_elig_plr.sql

claims_db/phclaims/final/tables/archive/qa_final.apcd_elig_timevar.sql

claims_db/phclaims/final/tables/final_mcare_claim_header.sql

claims_db/phclaims/final/tables/final_mcare_claim_icdcm_header.sql

claims_db/phclaims/final/tables/load_final.mcaid_claim_bh.yaml

claims_db/phclaims/final/tables/load_final.mcaid_claim_ccw.yaml

claims_db/phclaims/final/tables/load_final.mcaid_claim_header.yaml

claims_db/phclaims/final/tables/load_final.mcaid_claim_icdcm_header.yaml

claims_db/phclaims/final/tables/load_final.mcaid_claim_line.yaml

claims_db/phclaims/final/tables/load_final.mcaid_claim_pharm.yaml

claims_db/phclaims/final/tables/load_final.mcaid_claim_procedure.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/load_raw/tables/_create_raw.mcare_hospice_occurance_codes_16.yaml

claims_db/phclaims/load_raw/tables/_create_raw.mcare_snf_condition_codes_15.yaml

claims_db/phclaims/load_raw/tables/_load_raw.mcare_hospice_condition_codes_15.R

claims_db/phclaims/load_raw/tables/_load_raw.mcare_hospice_condition_codes_16.yaml

claims_db/phclaims/load_raw/tables/_load_raw.mcare_hospice_occurance_codes_16.R

claims_db/phclaims/load_raw/tables/_load_raw.mcare_snf_condition_codes_15.yaml

claims_db/phclaims/load_raw/tables/archive/apcd_unzip_all_tables.R claims_db/phclaims/load_raw/tables/archive/apcd_unzip_individual_table.R claims_db/phclaims/load_raw/tables/archive/count_lines.apcd_all_tables.R

claims_db/phclaims/load_raw/tables/archive/load_load_raw.apcd_claim_icdcm_raw_full.yaml

claims_db/phclaims/load_raw/tables/archive/load_load_raw.apcd_claim_line_raw_full.yaml

claims_db/phclaims/load_raw/tables/archive/load_load_raw.apcd_claim_procedure_raw_full.yaml

claims_db/phclaims/load_raw/tables/archive/load_load_raw.apcd_claim_provider_raw_full.yaml

claims_db/phclaims/load_raw/tables/archive/load_load_raw.apcd_dental_claim_full.yaml

claims_db/phclaims/load_raw/tables/archive/load_load_raw.apcd_eligibility_full.yaml

claims_db/phclaims/load_raw/tables/archive/load_load_raw.apcd_medical_claim_header_full.yaml

claims_db/phclaims/load_raw/tables/archive/load_load_raw.apcd_member_month_detail_full.yaml

claims_db/phclaims/load_raw/tables/archive/load_load_raw.apcd_pharmacy_claim_full.yaml

claims_db/phclaims/load_raw/tables/archive/load_load_raw.apcd_provider_full.yaml

claims_db/phclaims/load_raw/tables/archive/load_load_raw.apcd_provider_master_full.yaml

claims_db/phclaims/load_raw/tables/create_load_raw.mcare_outpatient_revenue_k_16.yaml

claims_db/phclaims/load_raw/tables/create_load_raw_macare_hha_rev_codes_14.yaml

claims_db/phclaims/load_raw/tables/create_load_raw_macare_hha_rev_codes_15.yaml

claims_db/phclaims/load_raw/tables/create_load_raw_macare_hha_rev_codes_16.yaml

claims_db/phclaims/load_raw/tables/create_load_raw_macare_hha_rev_codes_17.yaml

claims_db/phclaims/load_raw/tables/create_load_raw_macare_hospice_rev_codes_17.yaml

claims_db/phclaims/load_raw/tables/create_load_raw_mcare_bcarrier_claims_17.yaml

claims_db/phclaims/load_raw/tables/create_load_raw_mcare_bcarrier_demo_17.yaml

claims_db/phclaims/load_raw/tables/create_load_raw_mcare_bcarrier_line_k_17.yaml

claims_db/phclaims/load_raw/tables/create_load_raw_mcare_dme_claims_k_17.yaml

claims_db/phclaims/load_raw/tables/create_load_raw_mcare_dme_line_k_17.yaml

claims_db/phclaims/load_raw/tables/create_load_raw_mcare_hha_base_claims_k_17.yaml

claims_db/phclaims/load_raw/tables/create_load_raw_mcare_hospice_base_claims_k_17.yaml

claims_db/phclaims/load_raw/tables/create_load_raw_mcare_inpatient_base_claims_k_17.yaml

claims_db/phclaims/load_raw/tables/create_load_raw_mcare_inpatient_revenue_center_k_17.yaml

claims_db/phclaims/load_raw/tables/create_load_raw_mcare_outpatient_base_claims_k_17.yaml

claims_db/phclaims/load_raw/tables/create_load_raw_mcare_outpatient_revenue_center_k_17.yaml

claims_db/phclaims/load_raw/tables/create_load_raw_mcare_snf_base_claims_k_17.yaml

claims_db/phclaims/load_raw/tables/create_load_raw_mcare_snf_revenue_center_k_17.yaml

claims_db/phclaims/load_raw/tables/create_raw.mcare_bcarrier_claims_k_14.yaml

claims_db/phclaims/load_raw/tables/create_raw.mcare_bcarrier_line_K_15.yaml

claims_db/phclaims/load_raw/tables/create_raw.mcare_bcarrier_line_K_16.yaml

claims_db/phclaims/load_raw/tables/create_raw.mcare_bcarrier_line_j_14.yaml

claims_db/phclaims/load_raw/tables/create_raw.mcare_dme_claims_k_15.yaml

claims_db/phclaims/load_raw/tables/create_raw.mcare_dme_claims_k_16.yaml

claims_db/phclaims/load_raw/tables/create_raw.mcare_dme_demo_codes_15.yaml

claims_db/phclaims/load_raw/tables/create_raw.mcare_dme_demo_codes_16.yaml

claims_db/phclaims/load_raw/tables/create_raw.mcare_dme_line_k_15.yaml

claims_db/phclaims/load_raw/tables/create_raw.mcare_dme_line_k_16.yaml

claims_db/phclaims/load_raw/tables/create_raw.mcare_hha_base_claims_k_14.yaml

claims_db/phclaims/load_raw/tables/create_raw.mcare_hha_base_claims_k_15.yaml

claims_db/phclaims/load_raw/tables/create_raw.mcare_hha_base_claims_k_16.yaml

claims_db/phclaims/load_raw/tables/create_raw.mcare_hospice_base_claims_k_14.yaml

claims_db/phclaims/load_raw/tables/create_raw.mcare_hospice_base_claims_k_15.yaml

claims_db/phclaims/load_raw/tables/create_raw.mcare_hospice_base_claims_k_16.yaml

claims_db/phclaims/load_raw/tables/create_raw.mcare_hospice_condition_codes_14.yaml

claims_db/phclaims/load_raw/tables/create_raw.mcare_hospice_condition_codes_15.yaml

claims_db/phclaims/load_raw/tables/create_raw.mcare_hospice_condition_codes_16.yaml

claims_db/phclaims/load_raw/tables/create_raw.mcare_hospice_demo_codes_14.yaml

claims_db/phclaims/load_raw/tables/create_raw.mcare_hospice_demo_codes_15.yaml

claims_db/phclaims/load_raw/tables/create_raw.mcare_hospice_demo_codes_16.yaml

claims_db/phclaims/load_raw/tables/create_raw.mcare_hospice_occurance_codes_14.yaml

claims_db/phclaims/load_raw/tables/create_raw.mcare_hospice_occurance_codes_15.yaml

claims_db/phclaims/load_raw/tables/create_raw.mcare_hospice_revenue_center_k_14.yaml

claims_db/phclaims/load_raw/tables/create_raw.mcare_hospice_revenue_center_k_15.yaml

claims_db/phclaims/load_raw/tables/create_raw.mcare_hospice_revenue_center_k_16.yaml

claims_db/phclaims/load_raw/tables/create_raw.mcare_hospice_span_codes_14.yaml

claims_db/phclaims/load_raw/tables/create_raw.mcare_hospice_span_codes_15.yaml

claims_db/phclaims/load_raw/tables/create_raw.mcare_hospice_span_codes_16.yaml

claims_db/phclaims/load_raw/tables/create_raw.mcare_hospice_value_codes_14.yaml

claims_db/phclaims/load_raw/tables/create_raw.mcare_hospice_value_codes_15.yaml

claims_db/phclaims/load_raw/tables/create_raw.mcare_hospice_value_codes_16.yaml

claims_db/phclaims/load_raw/tables/create_raw.mcare_inpatient_base_claims_j_14.yaml

claims_db/phclaims/load_raw/tables/create_raw.mcare_outpatient_base_claims_j_14.yaml

claims_db/phclaims/load_raw/tables/create_raw.mcare_outpatient_revenue_center_k_14.yaml

claims_db/phclaims/load_raw/tables/create_raw.mcare_outpatient_revenue_center_k_15.yaml

claims_db/phclaims/load_raw/tables/create_raw.mcare_outpatient_revenue_center_k_16.yaml

claims_db/phclaims/load_raw/tables/create_raw.mcare_snf_base_claims_k_14.yaml

claims_db/phclaims/load_raw/tables/create_raw.mcare_snf_base_claims_k_15.yaml

claims_db/phclaims/load_raw/tables/create_raw.mcare_snf_base_claims_k_16.yaml

claims_db/phclaims/load_raw/tables/create_raw.mcare_snf_condition_codes_14.yaml

claims_db/phclaims/load_raw/tables/create_raw.mcare_snf_condition_codes_16.yaml

claims_db/phclaims/load_raw/tables/create_raw.mcare_snf_revenue_center_k_14.yaml

claims_db/phclaims/load_raw/tables/create_raw.mcare_snf_revenue_center_k_15.yaml

claims_db/phclaims/load_raw/tables/create_raw.mcare_snf_revenue_center_k_16.yaml

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.mcare_mbsf_ab.R claims_db/phclaims/load_raw/tables/load_load_raw.mcare_mbsf_abcd.R claims_db/phclaims/load_raw/tables/load_load_raw.ofm_xwalk_data.r claims_db/phclaims/load_raw/tables/load_raw.mcare_bcarrier_claims_k_14.R

claims_db/phclaims/load_raw/tables/load_raw.mcare_bcarrier_claims_k_14.yaml

claims_db/phclaims/load_raw/tables/load_raw.mcare_bcarrier_line_j_14.R

claims_db/phclaims/load_raw/tables/load_raw.mcare_bcarrier_line_j_14.yaml

claims_db/phclaims/load_raw/tables/load_raw.mcare_bcarrier_line_k_15.R

claims_db/phclaims/load_raw/tables/load_raw.mcare_bcarrier_line_k_15.yaml

claims_db/phclaims/load_raw/tables/load_raw.mcare_bcarrier_line_k_16.R

claims_db/phclaims/load_raw/tables/load_raw.mcare_bcarrier_line_k_16.yaml

claims_db/phclaims/load_raw/tables/load_raw.mcare_dme_claims_k_15.R

claims_db/phclaims/load_raw/tables/load_raw.mcare_dme_claims_k_15.yaml

claims_db/phclaims/load_raw/tables/load_raw.mcare_dme_claims_k_16.R

claims_db/phclaims/load_raw/tables/load_raw.mcare_dme_claims_k_16.yaml

claims_db/phclaims/load_raw/tables/load_raw.mcare_dme_demo_codes_15.R

claims_db/phclaims/load_raw/tables/load_raw.mcare_dme_demo_codes_15.yaml

claims_db/phclaims/load_raw/tables/load_raw.mcare_dme_demo_codes_16.R

claims_db/phclaims/load_raw/tables/load_raw.mcare_dme_demo_codes_16.yaml

claims_db/phclaims/load_raw/tables/load_raw.mcare_dme_line_k_15.R

claims_db/phclaims/load_raw/tables/load_raw.mcare_dme_line_k_15.yaml

claims_db/phclaims/load_raw/tables/load_raw.mcare_dme_line_k_16.R

claims_db/phclaims/load_raw/tables/load_raw.mcare_dme_line_k_16.yaml

claims_db/phclaims/load_raw/tables/load_raw.mcare_hha_base_claims_k_14.R

claims_db/phclaims/load_raw/tables/load_raw.mcare_hha_base_claims_k_14.yaml

claims_db/phclaims/load_raw/tables/load_raw.mcare_hha_base_claims_k_15.R

claims_db/phclaims/load_raw/tables/load_raw.mcare_hha_base_claims_k_15.yaml

claims_db/phclaims/load_raw/tables/load_raw.mcare_hha_base_claims_k_16.R

claims_db/phclaims/load_raw/tables/load_raw.mcare_hha_base_claims_k_16.yaml

claims_db/phclaims/load_raw/tables/load_raw.mcare_hospice_base_claims_k_14.R

claims_db/phclaims/load_raw/tables/load_raw.mcare_hospice_base_claims_k_14.yaml

claims_db/phclaims/load_raw/tables/load_raw.mcare_hospice_base_claims_k_15.R

claims_db/phclaims/load_raw/tables/load_raw.mcare_hospice_base_claims_k_15.yaml

claims_db/phclaims/load_raw/tables/load_raw.mcare_hospice_base_claims_k_16.R

claims_db/phclaims/load_raw/tables/load_raw.mcare_hospice_base_claims_k_16.yaml

claims_db/phclaims/load_raw/tables/load_raw.mcare_hospice_condition_codes_14.R

claims_db/phclaims/load_raw/tables/load_raw.mcare_hospice_condition_codes_14.yaml

claims_db/phclaims/load_raw/tables/load_raw.mcare_hospice_condition_codes_15.yaml

claims_db/phclaims/load_raw/tables/load_raw.mcare_hospice_condition_codes_16.R claims_db/phclaims/load_raw/tables/load_raw.mcare_hospice_demo_codes_14.R

claims_db/phclaims/load_raw/tables/load_raw.mcare_hospice_demo_codes_14.yaml

claims_db/phclaims/load_raw/tables/load_raw.mcare_hospice_demo_codes_15.R

claims_db/phclaims/load_raw/tables/load_raw.mcare_hospice_demo_codes_15.yaml

claims_db/phclaims/load_raw/tables/load_raw.mcare_hospice_demo_codes_16.R

claims_db/phclaims/load_raw/tables/load_raw.mcare_hospice_demo_codes_16.yaml

claims_db/phclaims/load_raw/tables/load_raw.mcare_hospice_occurance_codes_14.R

claims_db/phclaims/load_raw/tables/load_raw.mcare_hospice_occurance_codes_14.yaml

claims_db/phclaims/load_raw/tables/load_raw.mcare_hospice_occurance_codes_15.R

claims_db/phclaims/load_raw/tables/load_raw.mcare_hospice_occurance_codes_15.yaml

claims_db/phclaims/load_raw/tables/load_raw.mcare_hospice_occurance_codes_16.yaml

claims_db/phclaims/load_raw/tables/load_raw.mcare_hospice_revenue_center_k_14.R

claims_db/phclaims/load_raw/tables/load_raw.mcare_hospice_revenue_center_k_14.yaml

claims_db/phclaims/load_raw/tables/load_raw.mcare_hospice_revenue_center_k_15.R

claims_db/phclaims/load_raw/tables/load_raw.mcare_hospice_revenue_center_k_15.yaml

claims_db/phclaims/load_raw/tables/load_raw.mcare_hospice_revenue_center_k_16.R

claims_db/phclaims/load_raw/tables/load_raw.mcare_hospice_revenue_center_k_16.yaml

claims_db/phclaims/load_raw/tables/load_raw.mcare_hospice_span_codes_14.R

claims_db/phclaims/load_raw/tables/load_raw.mcare_hospice_span_codes_14.yaml

claims_db/phclaims/load_raw/tables/load_raw.mcare_hospice_span_codes_15.R

claims_db/phclaims/load_raw/tables/load_raw.mcare_hospice_span_codes_15.yaml

claims_db/phclaims/load_raw/tables/load_raw.mcare_hospice_span_codes_16.R

claims_db/phclaims/load_raw/tables/load_raw.mcare_hospice_span_codes_16.yaml

claims_db/phclaims/load_raw/tables/load_raw.mcare_hospice_value_codes_14.R

claims_db/phclaims/load_raw/tables/load_raw.mcare_hospice_value_codes_14.yaml

claims_db/phclaims/load_raw/tables/load_raw.mcare_hospice_value_codes_15.R

claims_db/phclaims/load_raw/tables/load_raw.mcare_hospice_value_codes_15.yaml

claims_db/phclaims/load_raw/tables/load_raw.mcare_hospice_value_codes_16.R

claims_db/phclaims/load_raw/tables/load_raw.mcare_hospice_value_codes_16.yaml

claims_db/phclaims/load_raw/tables/load_raw.mcare_inpatient_base_claims_j_14.R

claims_db/phclaims/load_raw/tables/load_raw.mcare_inpatient_base_claims_j_14.yaml

claims_db/phclaims/load_raw/tables/load_raw.mcare_outpatient_base_claims_j_14.R

claims_db/phclaims/load_raw/tables/load_raw.mcare_outpatient_base_claims_j_14.yaml

claims_db/phclaims/load_raw/tables/load_raw.mcare_outpatient_rev_center_k_16.yaml

claims_db/phclaims/load_raw/tables/load_raw.mcare_outpatient_revenue_center_k_14.R

claims_db/phclaims/load_raw/tables/load_raw.mcare_outpatient_revenue_center_k_14.yaml

claims_db/phclaims/load_raw/tables/load_raw.mcare_outpatient_revenue_center_k_15.R

claims_db/phclaims/load_raw/tables/load_raw.mcare_outpatient_revenue_center_k_15.yaml

claims_db/phclaims/load_raw/tables/load_raw.mcare_outpatient_revenue_center_k_16.R

claims_db/phclaims/load_raw/tables/load_raw.mcare_outpatient_revenue_center_k_16.yaml

claims_db/phclaims/load_raw/tables/load_raw.mcare_snf_base_claims_k_14.R

claims_db/phclaims/load_raw/tables/load_raw.mcare_snf_base_claims_k_14.yaml

claims_db/phclaims/load_raw/tables/load_raw.mcare_snf_base_claims_k_15.R

claims_db/phclaims/load_raw/tables/load_raw.mcare_snf_base_claims_k_15.yaml

claims_db/phclaims/load_raw/tables/load_raw.mcare_snf_base_claims_k_16.R

claims_db/phclaims/load_raw/tables/load_raw.mcare_snf_base_claims_k_16.yaml

claims_db/phclaims/load_raw/tables/load_raw.mcare_snf_condition_codes_14.R

claims_db/phclaims/load_raw/tables/load_raw.mcare_snf_condition_codes_14.yaml

claims_db/phclaims/load_raw/tables/load_raw.mcare_snf_condition_codes_15.R claims_db/phclaims/load_raw/tables/load_raw.mcare_snf_condition_codes_16.R

claims_db/phclaims/load_raw/tables/load_raw.mcare_snf_condition_codes_16.yaml

claims_db/phclaims/load_raw/tables/load_raw.mcare_snf_revenue_center_k_14.R

claims_db/phclaims/load_raw/tables/load_raw.mcare_snf_revenue_center_k_14.yaml

claims_db/phclaims/load_raw/tables/load_raw.mcare_snf_revenue_center_k_15.R

claims_db/phclaims/load_raw/tables/load_raw.mcare_snf_revenue_center_k_15.yaml

claims_db/phclaims/load_raw/tables/load_raw.mcare_snf_revenue_center_k_16.R

claims_db/phclaims/load_raw/tables/load_raw.mcare_snf_revenue_center_k_16.yaml

claims_db/phclaims/load_raw/tables/load_raw_inpatient_revenue_center_k_17.R claims_db/phclaims/load_raw/tables/load_raw_mcare_bcarrier_claims_17.R

claims_db/phclaims/load_raw/tables/load_raw_mcare_bcarrier_claims_17.yaml

claims_db/phclaims/load_raw/tables/load_raw_mcare_bcarrier_demo_2017.R

claims_db/phclaims/load_raw/tables/load_raw_mcare_bcarrier_demo_2017.yaml

claims_db/phclaims/load_raw/tables/load_raw_mcare_bcarrier_line_k_17.yaml

claims_db/phclaims/load_raw/tables/load_raw_mcare_dme_claims_17_AND_dme_line_17.R

claims_db/phclaims/load_raw/tables/load_raw_mcare_dme_claims_k_17.yaml

claims_db/phclaims/load_raw/tables/load_raw_mcare_dme_line_k_17.yaml

claims_db/phclaims/load_raw/tables/load_raw_mcare_hha_base_AND_revenue_17.R

claims_db/phclaims/load_raw/tables/load_raw_mcare_hha_base_claims_k_17.yaml

claims_db/phclaims/load_raw/tables/load_raw_mcare_hha_rev_codes_14.yaml

claims_db/phclaims/load_raw/tables/load_raw_mcare_hha_rev_codes_15.yaml

claims_db/phclaims/load_raw/tables/load_raw_mcare_hha_rev_codes_16.yaml

claims_db/phclaims/load_raw/tables/load_raw_mcare_hha_rev_codes_17.yaml

claims_db/phclaims/load_raw/tables/load_raw_mcare_hha_revenue_center_14_16.R

claims_db/phclaims/load_raw/tables/load_raw_mcare_hospice_base_claims_k_17.yaml

claims_db/phclaims/load_raw/tables/load_raw_mcare_hospice_rev_codes_17.yaml

claims_db/phclaims/load_raw/tables/load_raw_mcare_inpatient_base_claims_17.R

claims_db/phclaims/load_raw/tables/load_raw_mcare_inpatient_base_claims_17.yaml

claims_db/phclaims/load_raw/tables/load_raw_mcare_inpatient_revenue_center_k_17.yaml

claims_db/phclaims/load_raw/tables/load_raw_mcare_outpatient_claims_17.yaml

claims_db/phclaims/load_raw/tables/load_raw_mcare_outpatient_claims_17_AND_outpatient_revenue_17.R

claims_db/phclaims/load_raw/tables/load_raw_mcare_outpatient_revenue_center_k_17.yaml

claims_db/phclaims/load_raw/tables/load_raw_mcare_snf_base_claims_k_17.yaml

claims_db/phclaims/load_raw/tables/load_raw_mcare_snf_revenue_center_k_17.yaml

claims_db/phclaims/load_raw/tables/load_raw_snf_claims_AND_revenue_cneter_17.R

claims_db/phclaims/load_raw/tables/load_stg_claims.apcd_claim_icdcm_raw_full.yaml

claims_db/phclaims/load_raw/tables/load_stg_claims.apcd_claim_line_raw_full.yaml

claims_db/phclaims/load_raw/tables/load_stg_claims.apcd_claim_procedure_raw_full.yaml

claims_db/phclaims/load_raw/tables/load_stg_claims.apcd_claim_provider_raw_full.yaml

claims_db/phclaims/load_raw/tables/load_stg_claims.apcd_dental_claim_full.yaml

claims_db/phclaims/load_raw/tables/load_stg_claims.apcd_eligibility_full.yaml

claims_db/phclaims/load_raw/tables/load_stg_claims.apcd_medical_claim_header_full.yaml

claims_db/phclaims/load_raw/tables/load_stg_claims.apcd_member_month_detail_full.yaml

claims_db/phclaims/load_raw/tables/load_stg_claims.apcd_pharmacy_claim_full.yaml

claims_db/phclaims/load_raw/tables/load_stg_claims.apcd_provider_full.yaml

claims_db/phclaims/load_raw/tables/load_stg_claims.apcd_provider_master_full.yaml

claims_db/phclaims/metadata/sprocs/create_metadata.sp_comma_separated_list.sql

claims_db/phclaims/metadata/sprocs/create_metadata.sp_min_max_value.sql

claims_db/phclaims/metadata/sprocs/create_metadata.sp_profile_table.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.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/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/create_ref.claim_concept.sql

claims_db/phclaims/ref/tables/archive/create_ref.hedis_value_set.sql

claims_db/phclaims/ref/tables/archive/create_ref.perf_measure.sql

claims_db/phclaims/ref/tables/archive/create_ref.perf_measure_name_xwalk.sql

claims_db/phclaims/ref/tables/archive/create_ref.perf_year_month.sql

claims_db/phclaims/ref/tables/archive/load_ref.apcd_claim_no_elig.sql

claims_db/phclaims/ref/tables/archive/load_ref.apcd_denied_orphaned_header.R

claims_db/phclaims/ref/tables/archive/load_ref.apcd_denied_orphaned_header.sql

claims_db/phclaims/ref/tables/archive/load_ref.apcd_denied_orphaned_header.yaml

claims_db/phclaims/ref/tables/archive/load_ref.apcd_ethnicity_race_map.yaml

claims_db/phclaims/ref/tables/archive/load_ref.apcd_provider_npi.sql

claims_db/phclaims/ref/tables/archive/load_ref.claim_concept.R claims_db/phclaims/ref/tables/archive/load_ref.hedis_value_set.R

claims_db/phclaims/ref/tables/archive/load_ref.hedis_value_set.sql

claims_db/phclaims/ref/tables/archive/nppes_wa_load testing.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.hedis_value_set.sql

claims_db/phclaims/ref/tables/archive/qa_ref.king_provider_master.sql

claims_db/phclaims/ref/tables/combine_icdcm_codes.R

claims_db/phclaims/ref/tables/create_ref.age_grp.sql

claims_db/phclaims/ref/tables/create_ref.ahrq_value_set.sql

claims_db/phclaims/ref/tables/create_ref.chronic_meds_eli.R

claims_db/phclaims/ref/tables/create_ref.chronic_meds_eli.yaml

claims_db/phclaims/ref/tables/create_ref.comorb_ref_tables.sql

claims_db/phclaims/ref/tables/create_ref.date.sql

claims_db/phclaims/ref/tables/create_ref.fda_ndc_product.R

claims_db/phclaims/ref/tables/create_ref.fda_ndc_product.yaml

claims_db/phclaims/ref/tables/create_ref.geo_kc_zip.R

claims_db/phclaims/ref/tables/create_ref.geo_kc_zip.yaml

claims_db/phclaims/ref/tables/create_ref.informatica_address_input.yaml

claims_db/phclaims/ref/tables/create_ref.informatica_address_output.yaml

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.taxonomy.sql

claims_db/phclaims/ref/tables/load_claims.ref_hedis_value_sets_apde.R

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.ahrq_value_set.R

claims_db/phclaims/ref/tables/load_ref.ahrq_value_set.sas

claims_db/phclaims/ref/tables/load_ref.ahrq_value_set.sql

claims_db/phclaims/ref/tables/load_ref.apcd_ethnicity_race_map.R

claims_db/phclaims/ref/tables/load_ref.apcd_ethnicity_race_map_update_check.sql

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.ccw_lookup.R

claims_db/phclaims/ref/tables/load_ref.ccw_lookup.yaml

claims_db/phclaims/ref/tables/load_ref.geo_county_code_wa.R claims_db/phclaims/ref/tables/load_ref.icdcm_codes.R 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.mco.R claims_db/phclaims/ref/tables/load_ref.ndc_codes.R claims_db/phclaims/ref/tables/load_ref.provider_nppes_apde_load.R claims_db/phclaims/ref/tables/load_ref.provider_nppes_load.R

claims_db/phclaims/ref/tables/load_ref.provider_nppes_load.yaml

claims_db/phclaims/ref/tables/load_ref.rda_value_sets_apde.R 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.apcd_provider_npi.sql

claims_db/phclaims/ref/tables/qa_ref.date.sql

claims_db/phclaims/ref/tables/qa_ref.mcaid_rac_code.sql

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-with-Dx.xlsx

claims_db/phclaims/ref/tables_data/month_matrix_2012-2030.csv

claims_db/phclaims/ref/tables_data/ref.ahrq_value_set.xlsx

claims_db/phclaims/ref/tables_data/ref.city_lookup.csv

claims_db/phclaims/ref/tables_data/ref.claim_concept.xlsx

claims_db/phclaims/ref/tables_data/ref.mco.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/ref/tables_data/rolling_time_12mo_2012-2030.csv

claims_db/phclaims/ref/tables_data/rolling_time_24mo_2012-2030.csv

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/sprocs/create_stage.fn_mcaid_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_perf_distinct_member.sql

claims_db/phclaims/stage/sprocs/create_stage.sp_mcaid_perf_elig_member_month.sql

claims_db/phclaims/stage/sprocs/create_stage.sp_mcaid_perf_enroll_denom.sql

claims_db/phclaims/stage/sprocs/create_stage.sp_mcaid_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.sp_perf_staging_ALL_MEASURES.sql

claims_db/phclaims/stage/sprocs/create_stage.v_mcaid_mh_aod_ed.sql

claims_db/phclaims/stage/sprocs/create_stage.v_mcaid_perf_hospice_member_month.sql

claims_db/phclaims/stage/sprocs/create_stage.v_mcaid_pqi_ed.sql

claims_db/phclaims/stage/sprocs/create_stage.v_mcaid_pqi_inpatient.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_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_by_dx_denominator.sql

claims_db/phclaims/stage/sprocs/create_stage.v_perf_tpm_by_dx_numerator.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_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_header.R

claims_db/phclaims/stage/tables/archive/load_stage.apcd_claim_header.sql

claims_db/phclaims/stage/tables/archive/load_stage.apcd_claim_header_v2.sql

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.R

claims_db/phclaims/stage/tables/archive/load_stage.apcd_claim_line.sql

claims_db/phclaims/stage/tables/archive/load_stage.apcd_claim_procedure.R

claims_db/phclaims/stage/tables/archive/load_stage.apcd_claim_procedure.sql

claims_db/phclaims/stage/tables/archive/load_stage.apcd_claim_provider.R

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/load_stage.mcaid_mcare_claim_line.sql

claims_db/phclaims/stage/tables/archive/load_stage.mcaid_mcare_claim_procedure.sql

claims_db/phclaims/stage/tables/archive/load_stage.mcare_bcarrier_claims.sql

claims_db/phclaims/stage/tables/archive/load_stage.mcare_bcarrier_line.sql

claims_db/phclaims/stage/tables/archive/load_stage.mcare_claim_header.sql

claims_db/phclaims/stage/tables/archive/load_stage.mcare_claim_header_1persontest.sql

claims_db/phclaims/stage/tables/archive/load_stage.mcare_claim_icdcm_header.sql

claims_db/phclaims/stage/tables/archive/load_stage.mcare_claim_line.sql

claims_db/phclaims/stage/tables/archive/load_stage.mcare_claim_procedure.sql

claims_db/phclaims/stage/tables/archive/load_stage.mcare_claim_provider.sql

claims_db/phclaims/stage/tables/archive/load_stage.mcare_dme_claims.sql

claims_db/phclaims/stage/tables/archive/load_stage.mcare_dme_line.sql

claims_db/phclaims/stage/tables/archive/load_stage.mcare_hha_base_claims.sql

claims_db/phclaims/stage/tables/archive/load_stage.mcare_hha_revenue_center.sql

claims_db/phclaims/stage/tables/archive/load_stage.mcare_hospice_base_claims.sql

claims_db/phclaims/stage/tables/archive/load_stage.mcare_hospice_revenue_center.sql

claims_db/phclaims/stage/tables/archive/load_stage.mcare_inpatient_base_claims.sql

claims_db/phclaims/stage/tables/archive/load_stage.mcare_inpatient_revenue_center.sql

claims_db/phclaims/stage/tables/archive/load_stage.mcare_outpatient_base_claims.sql

claims_db/phclaims/stage/tables/archive/load_stage.mcare_outpatient_revenue_center.sql

claims_db/phclaims/stage/tables/archive/load_stage.mcare_snf_base_claims.sql

claims_db/phclaims/stage/tables/archive/load_stage.mcare_snf_revenue_center.sql

claims_db/phclaims/stage/tables/archive/qa_stage.apcd_claim_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_elig_timevar.yaml

claims_db/phclaims/stage/tables/create_stage.mcaid_perf_enroll_denom.sql

claims_db/phclaims/stage/tables/create_stage.mcaid_perf_enroll_provider.sql

claims_db/phclaims/stage/tables/create_stage.mcaid_perf_staging.sql

claims_db/phclaims/stage/tables/create_stage.mcaid_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_geocode.R claims_db/phclaims/stage/tables/load_stage.address_clean_partial.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_bh.yaml

claims_db/phclaims/stage/tables/load_stage.apcd_claim_ccw.yaml

claims_db/phclaims/stage/tables/load_stage.apcd_claim_header.R

claims_db/phclaims/stage/tables/load_stage.apcd_claim_header.yaml

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_plr_2019.yaml

claims_db/phclaims/stage/tables/load_stage.apcd_elig_plr_20190630.yaml

claims_db/phclaims/stage/tables/load_stage.apcd_elig_plr_20190831.yaml

claims_db/phclaims/stage/tables/load_stage.apcd_elig_plr_2020.yaml

claims_db/phclaims/stage/tables/load_stage.apcd_elig_plr_2021.yaml

claims_db/phclaims/stage/tables/load_stage.apcd_elig_plr_2022.yaml

claims_db/phclaims/stage/tables/load_stage.apcd_elig_plr_20221231.yaml.yaml

claims_db/phclaims/stage/tables/load_stage.apcd_elig_plr_20230331.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.R

claims_db/phclaims/stage/tables/load_stage.mcaid_claim.yaml

claims_db/phclaims/stage/tables/load_stage.mcaid_claim_bh.yaml

claims_db/phclaims/stage/tables/load_stage.mcaid_claim_ccw.yaml

claims_db/phclaims/stage/tables/load_stage.mcaid_claim_header.R

claims_db/phclaims/stage/tables/load_stage.mcaid_claim_header.yaml

claims_db/phclaims/stage/tables/load_stage.mcaid_claim_icdcm_header.R

claims_db/phclaims/stage/tables/load_stage.mcaid_claim_icdcm_header.yaml

claims_db/phclaims/stage/tables/load_stage.mcaid_claim_line.R

claims_db/phclaims/stage/tables/load_stage.mcaid_claim_line.yaml

claims_db/phclaims/stage/tables/load_stage.mcaid_claim_pharm.R

claims_db/phclaims/stage/tables/load_stage.mcaid_claim_pharm.yaml

claims_db/phclaims/stage/tables/load_stage.mcaid_claim_procedure.R

claims_db/phclaims/stage/tables/load_stage.mcaid_claim_procedure.yaml

claims_db/phclaims/stage/tables/load_stage.mcaid_claim_value_set.R

claims_db/phclaims/stage/tables/load_stage.mcaid_claim_value_set.yaml

claims_db/phclaims/stage/tables/load_stage.mcaid_elig.R

claims_db/phclaims/stage/tables/load_stage.mcaid_elig.yaml

claims_db/phclaims/stage/tables/load_stage.mcaid_elig_demo.R

claims_db/phclaims/stage/tables/load_stage.mcaid_elig_demo.yaml

claims_db/phclaims/stage/tables/load_stage.mcaid_elig_timevar.R

claims_db/phclaims/stage/tables/load_stage.mcaid_elig_timevar.yaml

claims_db/phclaims/stage/tables/load_stage.mcaid_mcare_claim_bh.yaml

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_claim_line.R

claims_db/phclaims/stage/tables/load_stage.mcaid_mcare_claim_line.yaml

claims_db/phclaims/stage/tables/load_stage.mcaid_mcare_claim_procedure.R

claims_db/phclaims/stage/tables/load_stage.mcaid_mcare_claim_procedure.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_distinct_member.R claims_db/phclaims/stage/tables/load_stage.mcaid_perf_elig_member_month.R claims_db/phclaims/stage/tables/load_stage.mcaid_perf_enroll_denom.R

claims_db/phclaims/stage/tables/load_stage.mcaid_perf_enroll_denom.yaml

claims_db/phclaims/stage/tables/load_stage.mcaid_perf_measure.R

claims_db/phclaims/stage/tables/load_stage.mcaid_perf_measure.yaml

claims_db/phclaims/stage/tables/load_stage.mcaid_perf_measure_amr.R claims_db/phclaims/stage/tables/load_stage.mcare_bcarrier_claims.R

claims_db/phclaims/stage/tables/load_stage.mcare_bcarrier_claims.yaml

claims_db/phclaims/stage/tables/load_stage.mcare_bcarrier_line.R

claims_db/phclaims/stage/tables/load_stage.mcare_bcarrier_line.yaml

claims_db/phclaims/stage/tables/load_stage.mcare_claim_bh.yaml

claims_db/phclaims/stage/tables/load_stage.mcare_claim_ccw.yaml

claims_db/phclaims/stage/tables/load_stage.mcare_claim_header.R

claims_db/phclaims/stage/tables/load_stage.mcare_claim_header.yaml

claims_db/phclaims/stage/tables/load_stage.mcare_claim_icdcm_header.R

claims_db/phclaims/stage/tables/load_stage.mcare_claim_icdcm_header.yaml

claims_db/phclaims/stage/tables/load_stage.mcare_claim_line.R

claims_db/phclaims/stage/tables/load_stage.mcare_claim_line.yaml

claims_db/phclaims/stage/tables/load_stage.mcare_claim_procedure.R

claims_db/phclaims/stage/tables/load_stage.mcare_claim_procedure.yaml

claims_db/phclaims/stage/tables/load_stage.mcare_claim_provider.R

claims_db/phclaims/stage/tables/load_stage.mcare_claim_provider.yaml

claims_db/phclaims/stage/tables/load_stage.mcare_dme_claims.R

claims_db/phclaims/stage/tables/load_stage.mcare_dme_claims.yaml

claims_db/phclaims/stage/tables/load_stage.mcare_dme_line.R

claims_db/phclaims/stage/tables/load_stage.mcare_dme_line.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_hha_base_claims.R

claims_db/phclaims/stage/tables/load_stage.mcare_hha_base_claims.yaml

claims_db/phclaims/stage/tables/load_stage.mcare_hha_revenue_center.R

claims_db/phclaims/stage/tables/load_stage.mcare_hha_revenue_center.yaml

claims_db/phclaims/stage/tables/load_stage.mcare_hospice_base_claims.R

claims_db/phclaims/stage/tables/load_stage.mcare_hospice_base_claims.yaml

claims_db/phclaims/stage/tables/load_stage.mcare_hospice_revenue_center.R

claims_db/phclaims/stage/tables/load_stage.mcare_hospice_revenue_center.yaml

claims_db/phclaims/stage/tables/load_stage.mcare_inpatient_base_claims.R

claims_db/phclaims/stage/tables/load_stage.mcare_inpatient_base_claims.yaml

claims_db/phclaims/stage/tables/load_stage.mcare_inpatient_revenue_center.R

claims_db/phclaims/stage/tables/load_stage.mcare_inpatient_revenue_center.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.mcare_outpatient_base_claims.R

claims_db/phclaims/stage/tables/load_stage.mcare_outpatient_base_claims.yaml

claims_db/phclaims/stage/tables/load_stage.mcare_outpatient_revenue_center.R

claims_db/phclaims/stage/tables/load_stage.mcare_outpatient_revenue_center.yaml

claims_db/phclaims/stage/tables/load_stage.mcare_snf_base_claims.R

claims_db/phclaims/stage/tables/load_stage.mcare_snf_base_claims.yaml

claims_db/phclaims/stage/tables/load_stage.mcare_snf_revenue_center.R

claims_db/phclaims/stage/tables/load_stage.mcare_snf_revenue_center.yaml

claims_db/phclaims/stage/tables/load_stage.mcare_xwalk_bene_ssn.R

claims_db/phclaims/stage/tables/load_stage.mcare_xwalk_bene_ssn.yaml

claims_db/phclaims/stage/tables/load_stage.mcare_xwalk_edb_user_view.R

claims_db/phclaims/stage/tables/load_stage.mcare_xwalk_edb_user_view.yaml

claims_db/phclaims/stage/tables/load_stage.xwalk_apde_mcaid_mcare_pha.R claims_db/phclaims/stage/tables/load_stage_address_clean_partial.R claims_db/phclaims/stage/tables/qa_stage.address_clean_partial.R

claims_db/phclaims/stage/tables/qa_stage.apcd_all_tables_quarterly_refresh.sql

claims_db/phclaims/stage/tables/qa_stage.apcd_claim_ccw_10009.sql

claims_db/phclaims/stage/tables/qa_stage.apcd_claim_header_10001.sql

claims_db/phclaims/stage/tables/qa_stage.apcd_claim_provider.sql

claims_db/phclaims/stage/tables/qa_stage.apcd_elig_demo.sql

claims_db/phclaims/stage/tables/qa_stage.apcd_elig_plr.sql

claims_db/phclaims/stage/tables/qa_stage.apcd_elig_timevar.sql

claims_db/phclaims/stage/tables/qa_stage.mcaid_claim_bh.R claims_db/phclaims/stage/tables/qa_stage.mcaid_claim_ccw.R

claims_db/phclaims/stage/tables/qa_stage.mcaid_claim_ccw_new_criteria.sql

claims_db/phclaims/stage/tables/qa_stage.mcaid_claim_header.R claims_db/phclaims/stage/tables/qa_stage.mcaid_claim_icdcm_header.R claims_db/phclaims/stage/tables/qa_stage.mcaid_claim_line.R claims_db/phclaims/stage/tables/qa_stage.mcaid_claim_pharm.R claims_db/phclaims/stage/tables/qa_stage.mcaid_claim_procedure.R 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.mcaid_mcare_claim_header.sql

claims_db/phclaims/stage/tables/qa_stage.mcaid_mcare_elig_demo.R claims_db/phclaims/stage/tables/qa_stage.mcaid_mcare_elig_timevar.R claims_db/phclaims/stage/tables/qa_stage.mcare_elig_timevar.R claims_db/phclaims/stage/tables/qa_stage.xwalk_apde_mcaid_mcare_pha.R

claims_db/phclaims/stage/tables/qa_tmp.mcare_claim_ccw.sql

claims_db/phclaims/table_dependencies.Rmd

claims_db/phclaims/table_dependencies.csv

claims_db/phclaims/table_dependencies.html

docs/claims_condition.Rmd docs/claims_elig.Rmd docs/elig_timevar_collapse.Rmd docs/tabloop.Rmd docs/top_causes.Rmd dugan_p1_export/denom_exploration_eli.R

dugan_p1_export/mcaid_data_prep.sql

dugan_p1_export/metadata_prep.R dugan_p1_export/move_files.R dugan_p1_export/sqlcmd_export.R

dugan_p1_export/wahbe_data_prep.sql

dugan_p1_export/zip_all_tables.R man/claims_condition.Rd man/claims_elig.Rd man/elig_timevar_collapse.Rd man/helper.Rd man/mcaid_claim_f.Rd man/mcaid_covgrp_f.Rd man/tabloop_f.Rd man/top_causes.Rd

renv.lock

PHSKC-APDE/claims_data documentation built on April 22, 2024, 6:29 p.m.

rdrr.io home R language documentation Run R code online

CRAN packages Bioconductor packages R-Forge packages GitHub packages

Note that we can't provide technical support on individual packages. You should contact the package authors for that.

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

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

R Package Documentation

Browse R Packages

We want your feedback!

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

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

R Package Documentation

Browse R Packages

We want your feedback!

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

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