claim_diagnosis_wide_view

Provides up to 30 diagnosis codes, diagnosis code descriptions, HCUP group code, and HCUP group descriptions all in a single row

Materialized: false

Definition

 WITH diagnoses AS (
         SELECT ct.claim_id,
            ct.principal_diagnosis,
            ct.other_diagnosis1,
            ct.other_diagnosis2,
            ct.other_diagnosis3,
            ct.other_diagnosis4,
            ct.other_diagnosis5,
            ct.other_diagnosis6,
            ct.other_diagnosis7,
            ct.other_diagnosis8,
            ct.other_diagnosis9,
            ct.other_diagnosis10,
            ct.other_diagnosis11,
            ct.other_diagnosis12,
            ct.other_diagnosis13,
            ct.other_diagnosis14,
            ct.other_diagnosis15,
            ct.other_diagnosis16,
            ct.other_diagnosis17,
            ct.other_diagnosis18,
            ct.other_diagnosis19,
            ct.other_diagnosis20,
            ct.other_diagnosis21,
            ct.other_diagnosis22,
            ct.other_diagnosis23,
            ct.other_diagnosis24,
            ct.other_diagnosis25,
            ct.other_diagnosis26,
            ct.other_diagnosis27,
            ct.other_diagnosis28,
            ct.other_diagnosis29,
            ct.other_diagnosis30
           FROM public.crosstab('SELECT claim_id, claim_diagnosis_index, diagnosis_code
                            FROM claims.claim_diagnosis
                            WHERE diagnosis_type = ''Principal''
                            UNION
                            SELECT claim_id, claim_diagnosis_index, diagnosis_code
                            FROM claims.claim_diagnosis
                            WHERE diagnosis_type = ''Other''
                            ORDER BY claim_id, claim_diagnosis_index, diagnosis_code'::text) ct(claim_id bigint, principal_diagnosis text, other_diagnosis1 text, other_diagnosis2 text, other_diagnosis3 text, other_diagnosis4 text, other_diagnosis5 text, other_diagnosis6 text, other_diagnosis7 text, other_diagnosis8 text, other_diagnosis9 text, other_diagnosis10 text, other_diagnosis11 text, other_diagnosis12 text, other_diagnosis13 text, other_diagnosis14 text, other_diagnosis15 text, other_diagnosis16 text, other_diagnosis17 text, other_diagnosis18 text, other_diagnosis19 text, other_diagnosis20 text, other_diagnosis21 text, other_diagnosis22 text, other_diagnosis23 text, other_diagnosis24 text, other_diagnosis25 text, other_diagnosis26 text, other_diagnosis27 text, other_diagnosis28 text, other_diagnosis29 text, other_diagnosis30 text)
        ), descriptions AS (
         SELECT ct.claim_id,
            ct.principal_diagnosis_description,
            ct.other_diagnosis_description1,
            ct.other_diagnosis_description2,
            ct.other_diagnosis_description3,
            ct.other_diagnosis_description4,
            ct.other_diagnosis_description5,
            ct.other_diagnosis_description6,
            ct.other_diagnosis_description7,
            ct.other_diagnosis_description8,
            ct.other_diagnosis_description9,
            ct.other_diagnosis_description10,
            ct.other_diagnosis_description11,
            ct.other_diagnosis_description12,
            ct.other_diagnosis_description13,
            ct.other_diagnosis_description14,
            ct.other_diagnosis_description15,
            ct.other_diagnosis_description16,
            ct.other_diagnosis_description17,
            ct.other_diagnosis_description18,
            ct.other_diagnosis_description19,
            ct.other_diagnosis_description20,
            ct.other_diagnosis_description21,
            ct.other_diagnosis_description22,
            ct.other_diagnosis_description23,
            ct.other_diagnosis_description24,
            ct.other_diagnosis_description25,
            ct.other_diagnosis_description26,
            ct.other_diagnosis_description27,
            ct.other_diagnosis_description28,
            ct.other_diagnosis_description29,
            ct.other_diagnosis_description30
           FROM public.crosstab('SELECT claim_id, claim_diagnosis_index, description
                            FROM claims.claim_diagnosis d
                            LEFT OUTER JOIN claims.icd_diagnosis_lookup i ON i.icd_diagnosis_id = d.icd_diagnosis_id
                            WHERE diagnosis_type = ''Principal''
                            UNION
                            SELECT claim_id, claim_diagnosis_index, description
                            FROM claims.claim_diagnosis d
                            LEFT OUTER JOIN claims.icd_diagnosis_lookup i ON i.icd_diagnosis_id = d.icd_diagnosis_id
                            WHERE diagnosis_type = ''Other''
                            ORDER BY claim_id, claim_diagnosis_index, description'::text) ct(claim_id bigint, principal_diagnosis_description text, other_diagnosis_description1 text, other_diagnosis_description2 text, other_diagnosis_description3 text, other_diagnosis_description4 text, other_diagnosis_description5 text, other_diagnosis_description6 text, other_diagnosis_description7 text, other_diagnosis_description8 text, other_diagnosis_description9 text, other_diagnosis_description10 text, other_diagnosis_description11 text, other_diagnosis_description12 text, other_diagnosis_description13 text, other_diagnosis_description14 text, other_diagnosis_description15 text, other_diagnosis_description16 text, other_diagnosis_description17 text, other_diagnosis_description18 text, other_diagnosis_description19 text, other_diagnosis_description20 text, other_diagnosis_description21 text, other_diagnosis_description22 text, other_diagnosis_description23 text, other_diagnosis_description24 text, other_diagnosis_description25 text, other_diagnosis_description26 text, other_diagnosis_description27 text, other_diagnosis_description28 text, other_diagnosis_description29 text, other_diagnosis_description30 text)
        ), hcup_groups AS (
         SELECT ct.claim_id,
            ct.principal_diagnosis_hcup_group,
            ct.other_diagnosis_hcup_group1,
            ct.other_diagnosis_hcup_group2,
            ct.other_diagnosis_hcup_group3,
            ct.other_diagnosis_hcup_group4,
            ct.other_diagnosis_hcup_group5,
            ct.other_diagnosis_hcup_group6,
            ct.other_diagnosis_hcup_group7,
            ct.other_diagnosis_hcup_group8,
            ct.other_diagnosis_hcup_group9,
            ct.other_diagnosis_hcup_group10,
            ct.other_diagnosis_hcup_group11,
            ct.other_diagnosis_hcup_group12,
            ct.other_diagnosis_hcup_group13,
            ct.other_diagnosis_hcup_group14,
            ct.other_diagnosis_hcup_group15,
            ct.other_diagnosis_hcup_group16,
            ct.other_diagnosis_hcup_group17,
            ct.other_diagnosis_hcup_group18,
            ct.other_diagnosis_hcup_group19,
            ct.other_diagnosis_hcup_group20,
            ct.other_diagnosis_hcup_group21,
            ct.other_diagnosis_hcup_group22,
            ct.other_diagnosis_hcup_group23,
            ct.other_diagnosis_hcup_group24,
            ct.other_diagnosis_hcup_group25,
            ct.other_diagnosis_hcup_group26,
            ct.other_diagnosis_hcup_group27,
            ct.other_diagnosis_hcup_group28,
            ct.other_diagnosis_hcup_group29,
            ct.other_diagnosis_hcup_group30
           FROM public.crosstab('SELECT claim_id, claim_diagnosis_index, description
                            FROM claims.claim_diagnosis d
                            LEFT OUTER JOIN claims.icd_diagnosis_lookup i ON i.icd_diagnosis_id = d.icd_diagnosis_id
                            WHERE diagnosis_type = ''Principal''
                            UNION
                            SELECT claim_id, claim_diagnosis_index, description
                            FROM claims.claim_diagnosis d
                            LEFT OUTER JOIN claims.icd_diagnosis_lookup i ON i.icd_diagnosis_id = d.icd_diagnosis_id
                            WHERE diagnosis_type = ''Other''
                            ORDER BY claim_id, claim_diagnosis_index, description'::text) ct(claim_id bigint, principal_diagnosis_hcup_group text, other_diagnosis_hcup_group1 text, other_diagnosis_hcup_group2 text, other_diagnosis_hcup_group3 text, other_diagnosis_hcup_group4 text, other_diagnosis_hcup_group5 text, other_diagnosis_hcup_group6 text, other_diagnosis_hcup_group7 text, other_diagnosis_hcup_group8 text, other_diagnosis_hcup_group9 text, other_diagnosis_hcup_group10 text, other_diagnosis_hcup_group11 text, other_diagnosis_hcup_group12 text, other_diagnosis_hcup_group13 text, other_diagnosis_hcup_group14 text, other_diagnosis_hcup_group15 text, other_diagnosis_hcup_group16 text, other_diagnosis_hcup_group17 text, other_diagnosis_hcup_group18 text, other_diagnosis_hcup_group19 text, other_diagnosis_hcup_group20 text, other_diagnosis_hcup_group21 text, other_diagnosis_hcup_group22 text, other_diagnosis_hcup_group23 text, other_diagnosis_hcup_group24 text, other_diagnosis_hcup_group25 text, other_diagnosis_hcup_group26 text, other_diagnosis_hcup_group27 text, other_diagnosis_hcup_group28 text, other_diagnosis_hcup_group29 text, other_diagnosis_hcup_group30 text)
        ), hcup_descriptions AS (
         SELECT ct.claim_id,
            ct.principal_diagnosis_hcup_group_description,
            ct.other_diagnosis_hcup_group_description1,
            ct.other_diagnosis_hcup_group_description2,
            ct.other_diagnosis_hcup_group_description3,
            ct.other_diagnosis_hcup_group_description4,
            ct.other_diagnosis_hcup_group_description5,
            ct.other_diagnosis_hcup_group_description6,
            ct.other_diagnosis_hcup_group_description7,
            ct.other_diagnosis_hcup_group_description8,
            ct.other_diagnosis_hcup_group_description9,
            ct.other_diagnosis_hcup_group_description10,
            ct.other_diagnosis_hcup_group_description11,
            ct.other_diagnosis_hcup_group_description12,
            ct.other_diagnosis_hcup_group_description13,
            ct.other_diagnosis_hcup_group_description14,
            ct.other_diagnosis_hcup_group_description15,
            ct.other_diagnosis_hcup_group_description16,
            ct.other_diagnosis_hcup_group_description17,
            ct.other_diagnosis_hcup_group_description18,
            ct.other_diagnosis_hcup_group_description19,
            ct.other_diagnosis_hcup_group_description20,
            ct.other_diagnosis_hcup_group_description21,
            ct.other_diagnosis_hcup_group_description22,
            ct.other_diagnosis_hcup_group_description23,
            ct.other_diagnosis_hcup_group_description24,
            ct.other_diagnosis_hcup_group_description25,
            ct.other_diagnosis_hcup_group_description26,
            ct.other_diagnosis_hcup_group_description27,
            ct.other_diagnosis_hcup_group_description28,
            ct.other_diagnosis_hcup_group_description29,
            ct.other_diagnosis_hcup_group_description30
           FROM public.crosstab('SELECT claim_id, claim_diagnosis_index, description
                            FROM claims.claim_diagnosis d
                            LEFT OUTER JOIN claims.icd_diagnosis_lookup i ON i.icd_diagnosis_id = d.icd_diagnosis_id
                            WHERE diagnosis_type = ''Principal''
                            UNION
                            SELECT claim_id, claim_diagnosis_index, description
                            FROM claims.claim_diagnosis d
                            LEFT OUTER JOIN claims.icd_diagnosis_lookup i ON i.icd_diagnosis_id = d.icd_diagnosis_id
                            WHERE diagnosis_type = ''Other''
                            ORDER BY claim_id, claim_diagnosis_index, description'::text) ct(claim_id bigint, principal_diagnosis_hcup_group_description text, other_diagnosis_hcup_group_description1 text, other_diagnosis_hcup_group_description2 text, other_diagnosis_hcup_group_description3 text, other_diagnosis_hcup_group_description4 text, other_diagnosis_hcup_group_description5 text, other_diagnosis_hcup_group_description6 text, other_diagnosis_hcup_group_description7 text, other_diagnosis_hcup_group_description8 text, other_diagnosis_hcup_group_description9 text, other_diagnosis_hcup_group_description10 text, other_diagnosis_hcup_group_description11 text, other_diagnosis_hcup_group_description12 text, other_diagnosis_hcup_group_description13 text, other_diagnosis_hcup_group_description14 text, other_diagnosis_hcup_group_description15 text, other_diagnosis_hcup_group_description16 text, other_diagnosis_hcup_group_description17 text, other_diagnosis_hcup_group_description18 text, other_diagnosis_hcup_group_description19 text, other_diagnosis_hcup_group_description20 text, other_diagnosis_hcup_group_description21 text, other_diagnosis_hcup_group_description22 text, other_diagnosis_hcup_group_description23 text, other_diagnosis_hcup_group_description24 text, other_diagnosis_hcup_group_description25 text, other_diagnosis_hcup_group_description26 text, other_diagnosis_hcup_group_description27 text, other_diagnosis_hcup_group_description28 text, other_diagnosis_hcup_group_description29 text, other_diagnosis_hcup_group_description30 text)
        )
 SELECT diagnoses.claim_id,
    diagnoses.principal_diagnosis,
    descriptions.principal_diagnosis_description,
    hcup_groups.principal_diagnosis_hcup_group,
    hcup_descriptions.principal_diagnosis_hcup_group_description,
    diagnoses.other_diagnosis1,
    diagnoses.other_diagnosis2,
    diagnoses.other_diagnosis3,
    diagnoses.other_diagnosis4,
    diagnoses.other_diagnosis5,
    diagnoses.other_diagnosis6,
    diagnoses.other_diagnosis7,
    diagnoses.other_diagnosis8,
    diagnoses.other_diagnosis9,
    diagnoses.other_diagnosis10,
    diagnoses.other_diagnosis11,
    diagnoses.other_diagnosis12,
    diagnoses.other_diagnosis13,
    diagnoses.other_diagnosis14,
    diagnoses.other_diagnosis15,
    diagnoses.other_diagnosis16,
    diagnoses.other_diagnosis17,
    diagnoses.other_diagnosis18,
    diagnoses.other_diagnosis19,
    diagnoses.other_diagnosis20,
    diagnoses.other_diagnosis21,
    diagnoses.other_diagnosis22,
    diagnoses.other_diagnosis23,
    diagnoses.other_diagnosis24,
    diagnoses.other_diagnosis25,
    diagnoses.other_diagnosis26,
    diagnoses.other_diagnosis27,
    diagnoses.other_diagnosis28,
    diagnoses.other_diagnosis29,
    diagnoses.other_diagnosis30,
    descriptions.other_diagnosis_description1,
    descriptions.other_diagnosis_description2,
    descriptions.other_diagnosis_description3,
    descriptions.other_diagnosis_description4,
    descriptions.other_diagnosis_description5,
    descriptions.other_diagnosis_description6,
    descriptions.other_diagnosis_description7,
    descriptions.other_diagnosis_description8,
    descriptions.other_diagnosis_description9,
    descriptions.other_diagnosis_description10,
    descriptions.other_diagnosis_description11,
    descriptions.other_diagnosis_description12,
    descriptions.other_diagnosis_description13,
    descriptions.other_diagnosis_description14,
    descriptions.other_diagnosis_description15,
    descriptions.other_diagnosis_description16,
    descriptions.other_diagnosis_description17,
    descriptions.other_diagnosis_description18,
    descriptions.other_diagnosis_description19,
    descriptions.other_diagnosis_description20,
    descriptions.other_diagnosis_description21,
    descriptions.other_diagnosis_description22,
    descriptions.other_diagnosis_description23,
    descriptions.other_diagnosis_description24,
    descriptions.other_diagnosis_description25,
    descriptions.other_diagnosis_description26,
    descriptions.other_diagnosis_description27,
    descriptions.other_diagnosis_description28,
    descriptions.other_diagnosis_description29,
    descriptions.other_diagnosis_description30,
    hcup_groups.other_diagnosis_hcup_group1,
    hcup_groups.other_diagnosis_hcup_group2,
    hcup_groups.other_diagnosis_hcup_group3,
    hcup_groups.other_diagnosis_hcup_group4,
    hcup_groups.other_diagnosis_hcup_group5,
    hcup_groups.other_diagnosis_hcup_group6,
    hcup_groups.other_diagnosis_hcup_group7,
    hcup_groups.other_diagnosis_hcup_group8,
    hcup_groups.other_diagnosis_hcup_group9,
    hcup_groups.other_diagnosis_hcup_group10,
    hcup_groups.other_diagnosis_hcup_group11,
    hcup_groups.other_diagnosis_hcup_group12,
    hcup_groups.other_diagnosis_hcup_group13,
    hcup_groups.other_diagnosis_hcup_group14,
    hcup_groups.other_diagnosis_hcup_group15,
    hcup_groups.other_diagnosis_hcup_group16,
    hcup_groups.other_diagnosis_hcup_group17,
    hcup_groups.other_diagnosis_hcup_group18,
    hcup_groups.other_diagnosis_hcup_group19,
    hcup_groups.other_diagnosis_hcup_group20,
    hcup_groups.other_diagnosis_hcup_group21,
    hcup_groups.other_diagnosis_hcup_group22,
    hcup_groups.other_diagnosis_hcup_group23,
    hcup_groups.other_diagnosis_hcup_group24,
    hcup_groups.other_diagnosis_hcup_group25,
    hcup_groups.other_diagnosis_hcup_group26,
    hcup_groups.other_diagnosis_hcup_group27,
    hcup_groups.other_diagnosis_hcup_group28,
    hcup_groups.other_diagnosis_hcup_group29,
    hcup_groups.other_diagnosis_hcup_group30,
    hcup_descriptions.other_diagnosis_hcup_group_description1,
    hcup_descriptions.other_diagnosis_hcup_group_description2,
    hcup_descriptions.other_diagnosis_hcup_group_description3,
    hcup_descriptions.other_diagnosis_hcup_group_description4,
    hcup_descriptions.other_diagnosis_hcup_group_description5,
    hcup_descriptions.other_diagnosis_hcup_group_description6,
    hcup_descriptions.other_diagnosis_hcup_group_description7,
    hcup_descriptions.other_diagnosis_hcup_group_description8,
    hcup_descriptions.other_diagnosis_hcup_group_description9,
    hcup_descriptions.other_diagnosis_hcup_group_description10,
    hcup_descriptions.other_diagnosis_hcup_group_description11,
    hcup_descriptions.other_diagnosis_hcup_group_description12,
    hcup_descriptions.other_diagnosis_hcup_group_description13,
    hcup_descriptions.other_diagnosis_hcup_group_description14,
    hcup_descriptions.other_diagnosis_hcup_group_description15,
    hcup_descriptions.other_diagnosis_hcup_group_description16,
    hcup_descriptions.other_diagnosis_hcup_group_description17,
    hcup_descriptions.other_diagnosis_hcup_group_description18,
    hcup_descriptions.other_diagnosis_hcup_group_description19,
    hcup_descriptions.other_diagnosis_hcup_group_description20,
    hcup_descriptions.other_diagnosis_hcup_group_description21,
    hcup_descriptions.other_diagnosis_hcup_group_description22,
    hcup_descriptions.other_diagnosis_hcup_group_description23,
    hcup_descriptions.other_diagnosis_hcup_group_description24,
    hcup_descriptions.other_diagnosis_hcup_group_description25,
    hcup_descriptions.other_diagnosis_hcup_group_description26,
    hcup_descriptions.other_diagnosis_hcup_group_description27,
    hcup_descriptions.other_diagnosis_hcup_group_description28,
    hcup_descriptions.other_diagnosis_hcup_group_description29,
    hcup_descriptions.other_diagnosis_hcup_group_description30
   FROM diagnoses
     LEFT JOIN descriptions ON descriptions.claim_id = diagnoses.claim_id
     LEFT JOIN hcup_groups ON hcup_groups.claim_id = diagnoses.claim_id
     LEFT JOIN hcup_descriptions ON hcup_descriptions.claim_id = diagnoses.claim_id;

Column	Data Type	Indexed
claim_id	bigint	No
principal_diagnosis	text	No
principal_diagnosis_description	text	No
principal_diagnosis_hcup_group	text	No
principal_diagnosis_hcup_group_description	text	No
other_diagnosis1	text	No
other_diagnosis2	text	No
other_diagnosis3	text	No
other_diagnosis4	text	No
other_diagnosis5	text	No
other_diagnosis6	text	No
other_diagnosis7	text	No
other_diagnosis8	text	No
other_diagnosis9	text	No
other_diagnosis10	text	No
other_diagnosis11	text	No
other_diagnosis12	text	No
other_diagnosis13	text	No
other_diagnosis14	text	No
other_diagnosis15	text	No
other_diagnosis16	text	No
other_diagnosis17	text	No
other_diagnosis18	text	No
other_diagnosis19	text	No
other_diagnosis20	text	No
other_diagnosis21	text	No
other_diagnosis22	text	No
other_diagnosis23	text	No
other_diagnosis24	text	No
other_diagnosis25	text	No
other_diagnosis26	text	No
other_diagnosis27	text	No
other_diagnosis28	text	No
other_diagnosis29	text	No
other_diagnosis30	text	No
other_diagnosis_description1	text	No
other_diagnosis_description2	text	No
other_diagnosis_description3	text	No
other_diagnosis_description4	text	No
other_diagnosis_description5	text	No
other_diagnosis_description6	text	No
other_diagnosis_description7	text	No
other_diagnosis_description8	text	No
other_diagnosis_description9	text	No
other_diagnosis_description10	text	No
other_diagnosis_description11	text	No
other_diagnosis_description12	text	No
other_diagnosis_description13	text	No
other_diagnosis_description14	text	No
other_diagnosis_description15	text	No
other_diagnosis_description16	text	No
other_diagnosis_description17	text	No
other_diagnosis_description18	text	No
other_diagnosis_description19	text	No
other_diagnosis_description20	text	No
other_diagnosis_description21	text	No
other_diagnosis_description22	text	No
other_diagnosis_description23	text	No
other_diagnosis_description24	text	No
other_diagnosis_description25	text	No
other_diagnosis_description26	text	No
other_diagnosis_description27	text	No
other_diagnosis_description28	text	No
other_diagnosis_description29	text	No
other_diagnosis_description30	text	No
other_diagnosis_hcup_group1	text	No
other_diagnosis_hcup_group2	text	No
other_diagnosis_hcup_group3	text	No
other_diagnosis_hcup_group4	text	No
other_diagnosis_hcup_group5	text	No
other_diagnosis_hcup_group6	text	No
other_diagnosis_hcup_group7	text	No
other_diagnosis_hcup_group8	text	No
other_diagnosis_hcup_group9	text	No
other_diagnosis_hcup_group10	text	No
other_diagnosis_hcup_group11	text	No
other_diagnosis_hcup_group12	text	No
other_diagnosis_hcup_group13	text	No
other_diagnosis_hcup_group14	text	No
other_diagnosis_hcup_group15	text	No
other_diagnosis_hcup_group16	text	No
other_diagnosis_hcup_group17	text	No
other_diagnosis_hcup_group18	text	No
other_diagnosis_hcup_group19	text	No
other_diagnosis_hcup_group20	text	No
other_diagnosis_hcup_group21	text	No
other_diagnosis_hcup_group22	text	No
other_diagnosis_hcup_group23	text	No
other_diagnosis_hcup_group24	text	No
other_diagnosis_hcup_group25	text	No
other_diagnosis_hcup_group26	text	No
other_diagnosis_hcup_group27	text	No
other_diagnosis_hcup_group28	text	No
other_diagnosis_hcup_group29	text	No
other_diagnosis_hcup_group30	text	No
other_diagnosis_hcup_group_description1	text	No
other_diagnosis_hcup_group_description2	text	No
other_diagnosis_hcup_group_description3	text	No
other_diagnosis_hcup_group_description4	text	No
other_diagnosis_hcup_group_description5	text	No
other_diagnosis_hcup_group_description6	text	No
other_diagnosis_hcup_group_description7	text	No
other_diagnosis_hcup_group_description8	text	No
other_diagnosis_hcup_group_description9	text	No
other_diagnosis_hcup_group_description10	text	No
other_diagnosis_hcup_group_description11	text	No
other_diagnosis_hcup_group_description12	text	No
other_diagnosis_hcup_group_description13	text	No
other_diagnosis_hcup_group_description14	text	No
other_diagnosis_hcup_group_description15	text	No
other_diagnosis_hcup_group_description16	text	No
other_diagnosis_hcup_group_description17	text	No
other_diagnosis_hcup_group_description18	text	No
other_diagnosis_hcup_group_description19	text	No
other_diagnosis_hcup_group_description20	text	No
other_diagnosis_hcup_group_description21	text	No
other_diagnosis_hcup_group_description22	text	No
other_diagnosis_hcup_group_description23	text	No
other_diagnosis_hcup_group_description24	text	No
other_diagnosis_hcup_group_description25	text	No
other_diagnosis_hcup_group_description26	text	No
other_diagnosis_hcup_group_description27	text	No
other_diagnosis_hcup_group_description28	text	No
other_diagnosis_hcup_group_description29	text	No
other_diagnosis_hcup_group_description30	text	No