int_claim_level_diagnosis
:::caution Internal model This is an intermediate/staging model used to build the query surface. It is documented for lineage and debugging. Its shape may change between releases, so avoid building reports directly on it. :::
At a glance
| Schema | dax_intermediate |
| Table | int_claim_level_diagnosis |
| Layer | Claims Preprocessing |
| Object type | table |
| Columns | 29 |
| Grain | claim_id, data_source |
| Tags | service_category_grouper_base, claims_preprocessing |
Columns
| Column | Type | Key | Constraints | Description |
|---|---|---|---|---|
claim_id | — | not null | — | |
data_source | — | not null | — | |
diagnosis_code_type | — | — | — | |
diagnosis_code_1 | — | — | — | |
diagnosis_code_2 | — | — | — | |
diagnosis_code_3 | — | — | — | |
diagnosis_code_4 | — | — | — | |
diagnosis_code_5 | — | — | — | |
diagnosis_code_6 | — | — | — | |
diagnosis_code_7 | — | — | — | |
diagnosis_code_8 | — | — | — | |
diagnosis_code_9 | — | — | — | |
diagnosis_code_10 | — | — | — | |
diagnosis_code_11 | — | — | — | |
diagnosis_code_12 | — | — | — | |
diagnosis_code_13 | — | — | — | |
diagnosis_code_14 | — | — | — | |
diagnosis_code_15 | — | — | — | |
diagnosis_code_16 | — | — | — | |
diagnosis_code_17 | — | — | — | |
diagnosis_code_18 | — | — | — | |
diagnosis_code_19 | — | — | — | |
diagnosis_code_20 | — | — | — | |
diagnosis_code_21 | — | — | — | |
diagnosis_code_22 | — | — | — | |
diagnosis_code_23 | — | — | — | |
diagnosis_code_24 | — | — | — | |
diagnosis_code_25 | — | — | — | |
dax_last_run | — | — | — |
Querying
select *
from dax_intermediate.int_claim_level_diagnosis
limit 100;