Charlson Comorbidity Index - metastasis category should use measurement table

--Metastatic solid tumor
INSERT INTO scratch_ddymshyt.charlson_scoring (
diag_category_id,
diag_category_name,
weight
)
VALUES (
16,
'Metastatic solid tumor',
6
);

INSERT INTO scratch_ddymshyt.charlson_concepts (
diag_category_id,
concept_id
)
SELECT 16,
descendant_concept_id
FROM cdm_optum_ehr_v3323.concept_ancestor
WHERE ancestor_concept_id IN (36769180); -- Metastasis - looks into measurement table then

this concept_id is the new one that we have to use now in the definition.
And use measurement table to get it

Start in inst/sql/sql_server/CharlsonIndex.sql at the Metastatic solid tumor definition around lines 333-352. Review how the current ancestor concept is queried, then trace the referenced measurement table and update the definition to use the new metastasis concept there. Done means the category retrieves metastasis records through the measurement table using the intended concept.