-
Notifications
You must be signed in to change notification settings - Fork 49
/
dbt_project.yml
252 lines (238 loc) · 19.1 KB
/
dbt_project.yml
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
name: 'the_tuva_project'
version: '0.12.4'
config-version: 2
require-dbt-version: ">=1.5.0"
profile: default
vars:
## CCSR data mart vars
# Set to "ip" for inpatient data or "op" for outpatient data (More info in the README)
record_type: "ip"
# CCSR Version numbers from HCUP
dxccsr_version: "'2023.1'"
prccsr_version: "'2023.1'"
## CMS HCC data mart vars
# The payment_year variable has a default of the current year, this can be
# changed by adding the numeric value of a year (ex: cms_hcc_payment_year: 2019)
cms_hcc_payment_year: '{{ run_started_at.strftime("%Y") }}'
## Quality Measures period var
# to run quality measueres for a period other than current year, add the below variable uncommented to your project
#quality_measures_period_end: "2020-12-31"
## Enable Normalize engine var
# set to false or leave undefined to affect no change
# set to unmapped to enable models in normalize schema that list any codes not mapped to normalized codes
# set to true produce the unmapped code models, and to integrate a seed called custom_mapped to map codes to normalized
# enable_normalize_engine: false
## Tuva Last Run
# The date and timestamp of the dbt run that will populate the tuva_last_run column in all models.
# Default timezone is UTC
tuva_last_run: '{{ run_started_at.astimezone(modules.pytz.timezone("UTC")) }}'
## Tuva seed S3 bucket override (for PG only) - also optional prefix in case the bucket has other content
#tuva_seeds_s3_bucket: "tuva-public-resources"
#tuva_seeds_s3_key_prefix: "tuva/seeds/example/prefix"
on-run-end:
- "{{ log_warning_for_seeds() }}"
model-paths: ["models"]
analysis-paths: ["analyses"]
test-paths: ["tests"]
seed-paths: ["seeds"]
macro-paths: ["macros"]
snapshot-paths: ["snapshots"]
docs-paths: ["dbt_doc_blocks"]
target-path: "target"
clean-targets:
- "target"
- "dbt_packages"
seeds:
the_tuva_project:
clinical_concept_library:
clinical_concept_library__clinical_concepts:
+post-hook: "{{ load_seed('tuva-public-resources/versioned_value_sets/0.12.4','tuva_clinical_concepts.csv',compression=true,null_marker=true) }}"
clinical_concept_library__coding_systems:
+post-hook: "{{ load_seed('tuva-public-resources/versioned_value_sets/0.12.4','tuva_coding_systems.csv',compression=true,null_marker=true) }}"
clinical_concept_library__value_set_members:
+post-hook: "{{ load_seed('tuva-public-resources/versioned_value_sets/0.12.4','tuva_value_set_members.csv',compression=true,null_marker=true) }}"
reference_data:
reference_data__code_type:
+post-hook: "{{ load_seed('tuva-public-resources/versioned_terminology/0.12.4','code_type.csv',compression=true,null_marker=true) }}"
reference_data__ansi_fips_state:
+post-hook: "{{ load_seed('tuva-public-resources/versioned_terminology/0.12.4','ansi_fips_state.csv',compression=true,null_marker=true) }}"
reference_data__calendar:
+post-hook: "{{ load_seed('tuva-public-resources/versioned_terminology/0.12.4','calendar.csv',compression=true,null_marker=true) }}"
reference_data__fips_county:
+post-hook: "{{ load_seed('tuva-public-resources/versioned_terminology/0.12.4','fips_county.csv',compression=true,null_marker=true) }}"
reference_data__ssa_fips_state:
+post-hook: "{{ load_seed('tuva-public-resources/versioned_terminology/0.12.4','ssa_fips_state.csv',compression=true,null_marker=true) }}"
terminology:
terminology__admit_source:
+post-hook: "{{ load_seed('tuva-public-resources/versioned_terminology/0.12.4','admit_source.csv',compression=true,null_marker=true) }}"
terminology__admit_type:
+post-hook: "{{ load_seed('tuva-public-resources/versioned_terminology/0.12.4','admit_type.csv',compression=true,null_marker=true) }}"
terminology__apr_drg:
+post-hook: "{{ load_seed('tuva-public-resources/versioned_terminology/0.12.4','apr_drg.csv',compression=true,null_marker=true) }}"
terminology__bill_type:
+post-hook: "{{ load_seed('tuva-public-resources/versioned_terminology/0.12.4','bill_type.csv',compression=true,null_marker=true) }}"
terminology__claim_type:
+post-hook: "{{ load_seed('tuva-public-resources/versioned_terminology/0.12.4','claim_type.csv',compression=true,null_marker=true) }}"
terminology__ccs_services_procedures:
+post-hook: "{{ load_seed('tuva-public-resources/versioned_terminology/0.12.4','ccs_services_procedures.csv',compression=true,null_marker=true) }}"
terminology__discharge_disposition:
+post-hook: "{{ load_seed('tuva-public-resources/versioned_terminology/0.12.4','discharge_disposition.csv',compression=true,null_marker=true) }}"
terminology__encounter_type:
+post-hook: "{{ load_seed('tuva-public-resources/versioned_terminology/0.12.4','encounter_type.csv',compression=true,null_marker=true) }}"
terminology__ethnicity:
+post-hook: "{{ load_seed('tuva-public-resources/versioned_terminology/0.12.4','ethnicity.csv',compression=true,null_marker=true) }}"
terminology__gender:
+post-hook: "{{ load_seed('tuva-public-resources/versioned_terminology/0.12.4','gender.csv',compression=true,null_marker=true) }}"
terminology__hcpcs_level_2:
+post-hook: "{{ load_seed('tuva-public-resources/versioned_terminology/0.12.4','hcpcs_level_2.csv',compression=true,null_marker=true) }}"
terminology__hcpcs_to_rbcs:
+post-hook: "{{ load_seed('tuva-public-resources/versioned_terminology/0.12.4','hcpcs_to_rbcs.csv',compression=true,null_marker=true) }}"
terminology__icd_10_cm:
+post-hook: "{{ load_seed('tuva-public-resources/versioned_terminology/0.12.4','icd_10_cm.csv',compression=true,null_marker=true) }}"
terminology__icd_10_pcs:
+post-hook: "{{ load_seed('tuva-public-resources/versioned_terminology/0.12.4','icd_10_pcs.csv',compression=true,null_marker=true) }}"
terminology__icd_9_cm:
+post-hook: "{{ load_seed('tuva-public-resources/versioned_terminology/0.12.4','icd_9_cm.csv',compression=true,null_marker=true) }}"
terminology__icd_9_pcs:
+post-hook: "{{ load_seed('tuva-public-resources/versioned_terminology/0.12.4','icd_9_pcs.csv',compression=true,null_marker=true) }}"
terminology__loinc:
+post-hook: "{{ load_seed('tuva-public-resources/versioned_terminology/0.12.4','loinc.csv',compression=true,null_marker=true) }}"
terminology__loinc_deprecated_mapping:
+post-hook: "{{ load_seed('tuva-public-resources/versioned_terminology/0.12.4','loinc_deprecated_mapping.csv',compression=true,null_marker=true) }}"
terminology__mdc:
+post-hook: "{{ load_seed('tuva-public-resources/versioned_terminology/0.12.4','mdc.csv',compression=true,null_marker=true) }}"
terminology__medicare_dual_eligibility:
+post-hook: "{{ load_seed('tuva-public-resources/versioned_terminology/0.12.4','medicare_dual_eligibility.csv',compression=true,null_marker=true) }}"
terminology__medicare_orec:
+post-hook: "{{ load_seed('tuva-public-resources/versioned_terminology/0.12.4','medicare_orec.csv',compression=true,null_marker=true) }}"
terminology__medicare_status:
+post-hook: "{{ load_seed('tuva-public-resources/versioned_terminology/0.12.4','medicare_status.csv',compression=true,null_marker=true) }}"
terminology__ms_drg_weights_los:
+post-hook: "{{ load_seed('tuva-public-resources/versioned_terminology/0.12.4','ms_drg_weights_los.csv',compression=true,null_marker=true) }}"
terminology__ms_drg:
+post-hook: "{{ load_seed('tuva-public-resources/versioned_terminology/0.12.4','ms_drg.csv',compression=true,null_marker=true) }}"
terminology__ndc:
+post-hook: "{{ load_seed('tuva-public-resources/versioned_terminology/0.12.4','ndc.csv',compression=true,null_marker=true) }}"
terminology__nitos:
+post-hook: "{{ load_seed('tuva-public-resources/versioned_terminology/0.12.4','nitos.csv',compression=true,null_marker=true) }}"
terminology__other_provider_taxonomy:
+post-hook: "{{ load_seed('tuva-public-resources/versioned_provider_data/0.12.4','other_provider_taxonomy.csv',compression=true,null_marker=true) }}"
terminology__payer_type:
+post-hook: "{{ load_seed('tuva-public-resources/versioned_terminology/0.12.4','payer_type.csv',compression=true,null_marker=true) }}"
terminology__place_of_service:
+post-hook: "{{ load_seed('tuva-public-resources/versioned_terminology/0.12.4','place_of_service.csv',compression=true,null_marker=true) }}"
terminology__present_on_admission:
+post-hook: "{{ load_seed('tuva-public-resources/versioned_terminology/0.12.4','present_on_admission.csv',compression=true,null_marker=true) }}"
terminology__provider:
+post-hook: "{{ load_seed('tuva-public-resources/versioned_provider_data/0.12.4','provider.csv',compression=true,null_marker=true) }}"
terminology__race:
+post-hook: "{{ load_seed('tuva-public-resources/versioned_terminology/0.12.4','race.csv',compression=true,null_marker=true) }}"
terminology__revenue_center:
+post-hook: "{{ load_seed('tuva-public-resources/versioned_terminology/0.12.4','revenue_center.csv',compression=true,null_marker=true) }}"
terminology__rxnorm_to_atc:
+post-hook: "{{ load_seed('tuva-public-resources/versioned_terminology/0.12.4','rxnorm_to_atc.csv',compression=true,null_marker=true) }}"
terminology__rxnorm_brand_generic:
+post-hook: "{{ load_seed('tuva-public-resources/versioned_terminology/0.12.4','rxnorm_brand_generic.csv',compression=true,null_marker=true) }}"
terminology__snomed_ct:
+post-hook: "{{ load_seed('tuva-public-resources/versioned_terminology/0.12.4','snomed_ct.csv',compression=true,null_marker=true) }}"
terminology__snomed_ct_transitive_closures:
+post-hook: "{{ load_seed('tuva-public-resources/versioned_terminology/0.12.4','snomed_ct_transitive_closures.csv',compression=true,null_marker=true) }}"
terminology__snomed_icd_10_map:
+post-hook: "{{ load_seed('tuva-public-resources/versioned_terminology/0.12.4','snomed_icd_10_map.csv',compression=true,null_marker=true) }}"
value_sets:
ccsr:
ccsr__dxccsr_v2023_1_body_systems:
+post-hook: "{{ load_seed('tuva-public-resources/versioned_value_sets/0.12.4','dxccsr_v2023_1_body_systems.csv',compression=true,null_marker=true) }}"
ccsr__dxccsr_v2023_1_cleaned_map:
+post-hook: "{{ load_seed('tuva-public-resources/versioned_value_sets/0.12.4','dxccsr_v2023_1_cleaned_map.csv',compression=true,null_marker=true) }}"
ccsr__prccsr_v2023_1_cleaned_map:
+post-hook: "{{ load_seed('tuva-public-resources/versioned_value_sets/0.12.4','prccsr_v2023_1_cleaned_map.csv',compression=true,null_marker=true) }}"
chronic_conditions:
chronic_conditions__cms_chronic_conditions_hierarchy:
+post-hook: "{{ load_seed('tuva-public-resources/versioned_value_sets/0.12.4','cms_chronic_conditions_hierarchy.csv',compression=true,null_marker=true) }}"
chronic_conditions__tuva_chronic_conditions_hierarchy:
+post-hook: "{{ load_seed('tuva-public-resources/versioned_value_sets/0.12.4','tuva_chronic_conditions_hierarchy.csv',compression=true,null_marker=true) }}"
cms_hcc:
cms_hcc__adjustment_rates:
+post-hook: "{{ load_seed('tuva-public-resources/versioned_value_sets/0.12.4','cms_hcc_adjustment_rates.csv',compression=true,null_marker=true) }}"
cms_hcc__cpt_hcpcs:
+post-hook: "{{ load_seed('tuva-public-resources/versioned_value_sets/0.12.4','cms_hcc_cpt_hcpcs.csv',compression=true,null_marker=true) }}"
cms_hcc__demographic_factors:
+post-hook: "{{ load_seed('tuva-public-resources/versioned_value_sets/0.12.4','cms_hcc_demographic_factors.csv',compression=true,null_marker=true) }}"
cms_hcc__disabled_interaction_factors:
+post-hook: "{{ load_seed('tuva-public-resources/versioned_value_sets/0.12.4','cms_hcc_disabled_interaction_factors.csv',compression=true,null_marker=true) }}"
cms_hcc__disease_factors:
+post-hook: "{{ load_seed('tuva-public-resources/versioned_value_sets/0.12.4','cms_hcc_disease_factors.csv',compression=true,null_marker=true) }}"
cms_hcc__disease_hierarchy:
+post-hook: "{{ load_seed('tuva-public-resources/versioned_value_sets/0.12.4','cms_hcc_disease_hierarchy.csv',compression=true,null_marker=true) }}"
cms_hcc__disease_interaction_factors:
+post-hook: "{{ load_seed('tuva-public-resources/versioned_value_sets/0.12.4','cms_hcc_disease_interaction_factors.csv',compression=true,null_marker=true) }}"
cms_hcc__enrollment_interaction_factors:
+post-hook: "{{ load_seed('tuva-public-resources/versioned_value_sets/0.12.4','cms_hcc_enrollment_interaction_factors.csv',compression=true,null_marker=true) }}"
cms_hcc__icd_10_cm_mappings:
+post-hook: "{{ load_seed('tuva-public-resources/versioned_value_sets/0.12.4','cms_hcc_icd_10_cm_mappings.csv',compression=true,null_marker=true) }}"
cms_hcc__payment_hcc_count_factors:
+post-hook: "{{ load_seed('tuva-public-resources/versioned_value_sets/0.12.4','cms_hcc_payment_hcc_count_factors.csv',compression=true,null_marker=true) }}"
data_quality:
data_quality__crosswalk_field_info:
+post-hook: "{{ load_seed('tuva-public-resources/versioned_value_sets/0.12.4','data_quality_crosswalk_field_info.csv',compression=true,null_marker=true) }}"
data_quality__crosswalk_field_to_mart:
+post-hook: "{{ load_seed('tuva-public-resources/versioned_value_sets/0.12.4','data_quality_crosswalk_field_to_mart.csv',compression=true,null_marker=true) }}"
data_quality__crosswalk_mart_to_outcome_measure:
+post-hook: "{{ load_seed('tuva-public-resources/versioned_value_sets/0.12.4','data_quality_crosswalk_mart_to_outcome_measure.csv',compression=true,null_marker=true) }}"
data_quality__crosswalk_measure_reasonable_ranges:
+post-hook: "{{ load_seed('tuva-public-resources/versioned_value_sets/0.12.4','data_quality_crosswalk_measure_reasonable_ranges.csv',compression=true,null_marker=true) }}"
data_quality__reference_mart_analytics:
+post-hook: "{{ load_seed('tuva-public-resources/versioned_value_sets/0.12.4','data_quality_reference_mart_analytics.csv',compression=true,null_marker=true) }}"
ed_classification:
ed_classification__categories:
+post-hook: "{{ load_seed('tuva-public-resources/versioned_value_sets/0.12.4','ed_classification_categories.csv',compression=true,null_marker=true) }}"
ed_classification__icd_10_cm_to_ccs:
+post-hook: "{{ load_seed('tuva-public-resources/versioned_value_sets/0.12.4','icd_10_cm_to_ccs.csv',compression=true,null_marker=true) }}"
ed_classification__johnston_icd10:
+post-hook: "{{ load_seed('tuva-public-resources/versioned_value_sets/0.12.4','johnston_icd10.csv',compression=true,null_marker=true) }}"
ed_classification__johnston_icd9:
+post-hook: "{{ load_seed('tuva-public-resources/versioned_value_sets/0.12.4','johnston_icd9.csv',compression=true,null_marker=true) }}"
hcc_suspecting:
hcc_suspecting__clinical_concepts:
+post-hook: "{{ load_seed('tuva-public-resources/versioned_value_sets/0.12.4','hcc_suspecting_clinical_concepts.csv',compression=true,null_marker=true) }}"
hcc_suspecting__hcc_descriptions:
+post-hook: "{{ load_seed('tuva-public-resources/versioned_value_sets/0.12.4','hcc_suspecting_descriptions.csv',compression=true,null_marker=true) }}"
hcc_suspecting__icd_10_cm_mappings:
+post-hook: "{{ load_seed('tuva-public-resources/versioned_value_sets/0.12.4','hcc_suspecting_icd_10_cm_mappings.csv',compression=true,null_marker=true) }}"
pharmacy:
pharmacy__rxnorm_generic_available:
+post-hook: "{{ load_seed('tuva-public-resources/versioned_value_sets/0.12.4','rxnorm_generic_available.csv',compression=true,null_marker=true) }}"
quality_measures:
quality_measures__concepts:
+post-hook: "{{ load_seed('tuva-public-resources/versioned_value_sets/0.12.4','quality_measures_concepts.csv',compression=true,null_marker=true) }}"
quality_measures__measures:
+post-hook: "{{ load_seed('tuva-public-resources/versioned_value_sets/0.12.4','quality_measures_measures.csv',compression=true,null_marker=true) }}"
quality_measures__value_sets:
+post-hook: "{{ load_seed('tuva-public-resources/versioned_value_sets/0.12.4','quality_measures_value_set_codes.csv',compression=true,null_marker=true) }}"
readmissions:
readmissions__acute_diagnosis_ccs:
+post-hook: "{{ load_seed('tuva-public-resources/versioned_value_sets/0.12.4','acute_diagnosis_ccs.csv',compression=true,null_marker=true) }}"
readmissions__acute_diagnosis_icd_10_cm:
+post-hook: "{{ load_seed('tuva-public-resources/versioned_value_sets/0.12.4','acute_diagnosis_icd_10_cm.csv',compression=true,null_marker=true) }}"
readmissions__always_planned_ccs_diagnosis_category:
+post-hook: "{{ load_seed('tuva-public-resources/versioned_value_sets/0.12.4','always_planned_ccs_diagnosis_category.csv',compression=true,null_marker=true) }}"
readmissions__always_planned_ccs_procedure_category:
+post-hook: "{{ load_seed('tuva-public-resources/versioned_value_sets/0.12.4','always_planned_ccs_procedure_category.csv',compression=true,null_marker=true) }}"
readmissions__exclusion_ccs_diagnosis_category:
+post-hook: "{{ load_seed('tuva-public-resources/versioned_value_sets/0.12.4','exclusion_ccs_diagnosis_category.csv',compression=true,null_marker=true) }}"
readmissions__icd_10_cm_to_ccs:
+post-hook: "{{ load_seed('tuva-public-resources/versioned_value_sets/0.12.4','icd_10_cm_to_ccs.csv',compression=true,null_marker=true) }}"
readmissions__icd_10_pcs_to_ccs:
+post-hook: "{{ load_seed('tuva-public-resources/versioned_value_sets/0.12.4','icd_10_pcs_to_ccs.csv',compression=true,null_marker=true) }}"
readmissions__potentially_planned_ccs_procedure_category:
+post-hook: "{{ load_seed('tuva-public-resources/versioned_value_sets/0.12.4','potentially_planned_ccs_procedure_category.csv',compression=true,null_marker=true) }}"
readmissions__potentially_planned_icd_10_pcs:
+post-hook: "{{ load_seed('tuva-public-resources/versioned_value_sets/0.12.4','potentially_planned_icd_10_pcs.csv',compression=true,null_marker=true) }}"
readmissions__specialty_cohort:
+post-hook: "{{ load_seed('tuva-public-resources/versioned_value_sets/0.12.4','specialty_cohort.csv',compression=true,null_marker=true) }}"
readmissions__surgery_gynecology_cohort:
+post-hook: "{{ load_seed('tuva-public-resources/versioned_value_sets/0.12.4','surgery_gynecology_cohort.csv',compression=true,null_marker=true) }}"
service_categories:
service_category__service_categories:
+post-hook: "{{ load_seed('tuva-public-resources/versioned_value_sets/0.12.4','service_category__service_categories.csv',compression=true,null_marker=true) }}"