tuva/seeds/value_sets/chronic_conditions/cms_chronic_conditions_seeds.yml at 4720d784c95a42074d4b757bf6810dbd12e6a8ce · amartinson-zus/tuva · GitHub

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
version: 2

seeds:
  - name: chronic_conditions__cms_chronic_conditions_hierarchy
    description: CMS generated grouping of ICD 10 codes into chronic conditions groups
    config:
      schema: |
        {%- if var('tuva_schema_prefix',None) != None -%}{{var('tuva_schema_prefix')}}_value_sets{% else %}value_sets{%- endif -%}
      alias: _value_set_cms_chronic_conditions_hierarchy
      tags:
        - cms_chronic_conditions
        - chronic_conditions
        - hcc_recapture
      enabled: "{{ var('claims_enabled', False) }}"
      column_types:
        condition_id: |
          {%- if target.type in ("bigquery", "databricks") -%} string {%- else -%} varchar(256) {%- endif -%}
        condition: |
          {%- if target.type in ("bigquery", "databricks") -%} string {%- else -%} varchar(256) {%- endif -%}
        condition_column_name: |
          {%- if target.type in ("bigquery", "databricks") -%} string {%- else -%} varchar(256) {%- endif -%}
        chronic_condition_type: |
          {%- if target.type in ("bigquery", "databricks") -%} string {%- else -%} varchar(256) {%- endif -%}
        condition_category: |
          {%- if target.type in ("bigquery", "databricks") -%} string {%- else -%} varchar(256) {%- endif -%}
        additional_logic: |
          {%- if target.type in ("bigquery", "databricks") -%} string {%- else -%} varchar(256) {%- endif -%}
        claims_qualification: |
          {%- if target.type in ("bigquery", "databricks") -%} string {%- else -%} varchar(1024) {%- endif -%}
        inclusion_type: |
          {%- if target.type in ("bigquery", "databricks") -%} string {%- else -%} varchar(256) {%- endif -%}
        code_system: |
          {%- if target.type in ("bigquery", "databricks") -%} string {%- else -%} varchar(256) {%- endif -%}
        code: |
          {%- if target.type in ("bigquery", "databricks") -%} string {%- else -%} varchar(256) {%- endif -%}
    columns:
      - name: condition_id
        description: Identifier for the chronic condition
      - name: condition
        description: Name of the chronic condition
      - name: condition_column_name
        description: Column name for the chronic condition
      - name: chronic_condition_type
        description: Type of chronic condition
      - name: condition_category
        description: Category of the chronic condition
      - name: additional_logic
        description: Additional logic for the chronic condition
      - name: claims_qualification
        description: Claims qualification criteria for the chronic condition
      - name: inclusion_type
        description: Type of inclusion for the chronic condition
      - name: code_system
        description: Code system used for the chronic condition
      - name: code
        description: Code for the chronic condition