search

MechanicalRabbit / OHDSICohortExpressions.jl

reimplementation of OHDSI's Circe JSON->SQL compiler
Other
7 stars 1 forks source link

Keyword `args` not Defined in `translate` #1

Closed TheCedarPrince closed 2 years ago

TheCedarPrince commented 2 years ago

Hey @clarkevans and @xitology ,

I know that this is an experimental package and I was trying it out today. I got this error today that seems to come from FunSQL:

ERROR: UndefKeywordError: keyword argument args not assigned
Stacktrace:
 [1] Append(; kws::Base.Pairs{Symbol, Vector{FunSQL.SQLNode}, Tuple{Symbol}, NamedTuple{(:list,), Tuple{Vector{FunS
QL.SQLNode}}}})
   @ FunSQL ~/.julia/packages/FunSQL/wBMQA/src/nodes/append.jl:60
 [2] translate(c::OHDSICohortExpressions.PrimaryCriteria, ctx::OHDSICohortExpressions.TranslateContext)
   @ OHDSICohortExpressions ~/.julia/packages/OHDSICohortExpressions/0wL4M/src/translate.jl:210
 [3] translate(c::OHDSICohortExpressions.CohortExpression, ctx::OHDSICohortExpressions.TranslateContext)
   @ OHDSICohortExpressions ~/.julia/packages/OHDSICohortExpressions/0wL4M/src/translate.jl:136
 [4] translate
   @ ~/.julia/packages/OHDSICohortExpressions/0wL4M/src/translate.jl:109 [inlined]
 [5] translate(cohort::Dict{String, Any}, dialect::Symbol, model::Model, cohort_definition_id::Int64)
   @ OHDSICohortExpressions ~/.julia/packages/OHDSICohortExpressions/0wL4M/src/translate.jl:53
 [6] translate(cohort::String, dialect::Symbol, model::Model, cohort_definition_id::Int64)
   @ OHDSICohortExpressions ~/.julia/packages/OHDSICohortExpressions/0wL4M/src/translate.jl:48
 [7] #translate#79
   @ ~/.julia/packages/OHDSICohortExpressions/0wL4M/src/translate.jl:45 [inlined]
 [8] top-level scope
   @ REPL[43]:1

Here is my code: 

julia> cohort = read("supreme-dm.json", String);

julia> using OHDSICohortExpressions: translate, Model;

julia> model = Model(cdm_version=v"5.3.1", cdm_schema="cdm",
                            vocabulary_schema="vcb", results_schema="res",
                                                 target_schema="res", target_table="cohort");

julia> tsql = translate(cohort, dialect=:sqlserver, model=model,
                                cohort_definition_id=0);

and here is my JSON:

Cohort Definition ```json { "ConceptSets": [ { "id": 0, "name": "Diabetes Dx", "expression": { "items": [ { "concept": { "CONCEPT_CLASS_ID": "4-dig billing code", "CONCEPT_CODE": "357.2", "CONCEPT_ID": 44825349, "CONCEPT_NAME": "Polyneuropathy in diabetes", "DOMAIN_ID": "Condition", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "N", "STANDARD_CONCEPT_CAPTION": "Non-Standard", "VOCABULARY_ID": "ICD9CM" } }, { "concept": { "CONCEPT_CLASS_ID": "5-dig billing code", "CONCEPT_CODE": "366.41", "CONCEPT_ID": 44833484, "CONCEPT_NAME": "Diabetic cataract", "DOMAIN_ID": "Condition", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "N", "STANDARD_CONCEPT_CAPTION": "Non-Standard", "VOCABULARY_ID": "ICD9CM" } }, { "concept": { "CONCEPT_CLASS_ID": "Clinical Finding", "CONCEPT_CODE": "49455004", "CONCEPT_ID": 376112, "CONCEPT_NAME": "Polyneuropathy due to diabetes mellitus", "DOMAIN_ID": "Condition", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "S", "STANDARD_CONCEPT_CAPTION": "Standard", "VOCABULARY_ID": "SNOMED" } }, { "concept": { "CONCEPT_CLASS_ID": "Clinical Finding", "CONCEPT_CODE": "43959009", "CONCEPT_ID": 376979, "CONCEPT_NAME": "Cataract due to diabetes mellitus", "DOMAIN_ID": "Condition", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "S", "STANDARD_CONCEPT_CAPTION": "Standard", "VOCABULARY_ID": "SNOMED" } }, { "concept": { "CONCEPT_CLASS_ID": "5-dig billing code", "CONCEPT_CODE": "362.01", "CONCEPT_ID": 44831148, "CONCEPT_NAME": "Background diabetic retinopathy", "DOMAIN_ID": "Condition", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "N", "STANDARD_CONCEPT_CAPTION": "Non-Standard", "VOCABULARY_ID": "ICD9CM" } }, { "concept": { "CONCEPT_CLASS_ID": "5-dig billing code", "CONCEPT_CODE": "362.07", "CONCEPT_ID": 44821870, "CONCEPT_NAME": "Diabetic macular edema", "DOMAIN_ID": "Condition", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "N", "STANDARD_CONCEPT_CAPTION": "Non-Standard", "VOCABULARY_ID": "ICD9CM" } }, { "concept": { "CONCEPT_CLASS_ID": "4-dig nonbill code", "CONCEPT_CODE": "362.0", "CONCEPT_ID": 44826573, "CONCEPT_NAME": "Diabetic retinopathy", "DOMAIN_ID": "Condition", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "N", "STANDARD_CONCEPT_CAPTION": "Non-Standard", "VOCABULARY_ID": "ICD9CM" } }, { "concept": { "CONCEPT_CLASS_ID": "5-dig billing code", "CONCEPT_CODE": "362.04", "CONCEPT_ID": 44834647, "CONCEPT_NAME": "Mild nonproliferative diabetic retinopathy", "DOMAIN_ID": "Condition", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "N", "STANDARD_CONCEPT_CAPTION": "Non-Standard", "VOCABULARY_ID": "ICD9CM" } }, { "concept": { "CONCEPT_CLASS_ID": "5-dig billing code", "CONCEPT_CODE": "362.05", "CONCEPT_ID": 44832299, "CONCEPT_NAME": "Moderate nonproliferative diabetic retinopathy", "DOMAIN_ID": "Condition", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "N", "STANDARD_CONCEPT_CAPTION": "Non-Standard", "VOCABULARY_ID": "ICD9CM" } }, { "concept": { "CONCEPT_CLASS_ID": "5-dig billing code", "CONCEPT_CODE": "362.03", "CONCEPT_ID": 44823040, "CONCEPT_NAME": "Nonproliferative diabetic retinopathy NOS", "DOMAIN_ID": "Condition", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "N", "STANDARD_CONCEPT_CAPTION": "Non-Standard", "VOCABULARY_ID": "ICD9CM" } }, { "concept": { "CONCEPT_CLASS_ID": "5-dig billing code", "CONCEPT_CODE": "362.02", "CONCEPT_ID": 44833465, "CONCEPT_NAME": "Proliferative diabetic retinopathy", "DOMAIN_ID": "Condition", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "N", "STANDARD_CONCEPT_CAPTION": "Non-Standard", "VOCABULARY_ID": "ICD9CM" } }, { "concept": { "CONCEPT_CLASS_ID": "5-dig billing code", "CONCEPT_CODE": "362.06", "CONCEPT_ID": 44832300, "CONCEPT_NAME": "Severe nonproliferative diabetic retinopathy", "DOMAIN_ID": "Condition", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "N", "STANDARD_CONCEPT_CAPTION": "Non-Standard", "VOCABULARY_ID": "ICD9CM" } }, { "concept": { "CONCEPT_CLASS_ID": "Clinical Finding", "CONCEPT_CODE": "390834004", "CONCEPT_ID": 376683, "CONCEPT_NAME": "Nonproliferative retinopathy due to diabetes mellitus", "DOMAIN_ID": "Condition", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "S", "STANDARD_CONCEPT_CAPTION": "Standard", "VOCABULARY_ID": "SNOMED" } }, { "concept": { "CONCEPT_CLASS_ID": "Clinical Finding", "CONCEPT_CODE": "312912001", "CONCEPT_ID": 380097, "CONCEPT_NAME": "Macular edema due to diabetes mellitus", "DOMAIN_ID": "Condition", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "S", "STANDARD_CONCEPT_CAPTION": "Standard", "VOCABULARY_ID": "SNOMED" } }, { "concept": { "CONCEPT_CLASS_ID": "4-dig nonbill code", "CONCEPT_CODE": "250.2", "CONCEPT_ID": 44826459, "CONCEPT_NAME": "Diabetes mellitus with hyperosmolarity", "DOMAIN_ID": "Condition", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "N", "STANDARD_CONCEPT_CAPTION": "Non-Standard", "VOCABULARY_ID": "ICD9CM" } }, { "concept": { "CONCEPT_CLASS_ID": "4-dig nonbill code", "CONCEPT_CODE": "250.0", "CONCEPT_ID": 44834548, "CONCEPT_NAME": "Diabetes mellitus without mention of complication", "DOMAIN_ID": "Condition", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "N", "STANDARD_CONCEPT_CAPTION": "Non-Standard", "VOCABULARY_ID": "ICD9CM" } }, { "concept": { "CONCEPT_CLASS_ID": "5-dig billing code", "CONCEPT_CODE": "250.00", "CONCEPT_ID": 44836914, "CONCEPT_NAME": "Diabetes mellitus without mention of complication, type II or unspecified type, not stated as uncontrolled", "DOMAIN_ID": "Condition", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "N", "STANDARD_CONCEPT_CAPTION": "Non-Standard", "VOCABULARY_ID": "ICD9CM" } }, { "concept": { "CONCEPT_CLASS_ID": "5-dig billing code", "CONCEPT_CODE": "250.02", "CONCEPT_ID": 44836915, "CONCEPT_NAME": "Diabetes mellitus without mention of complication, type II or unspecified type, uncontrolled", "DOMAIN_ID": "Condition", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "N", "STANDARD_CONCEPT_CAPTION": "Non-Standard", "VOCABULARY_ID": "ICD9CM" } }, { "concept": { "CONCEPT_CLASS_ID": "5-dig billing code", "CONCEPT_CODE": "250.01", "CONCEPT_ID": 44820682, "CONCEPT_NAME": "Diabetes mellitus without mention of complication, type I [juvenile type], not stated as uncontrolled", "DOMAIN_ID": "Condition", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "N", "STANDARD_CONCEPT_CAPTION": "Non-Standard", "VOCABULARY_ID": "ICD9CM" } }, { "concept": { "CONCEPT_CLASS_ID": "5-dig billing code", "CONCEPT_CODE": "250.03", "CONCEPT_ID": 44821787, "CONCEPT_NAME": "Diabetes mellitus without mention of complication, type I [juvenile type], uncontrolled", "DOMAIN_ID": "Condition", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "N", "STANDARD_CONCEPT_CAPTION": "Non-Standard", "VOCABULARY_ID": "ICD9CM" } }, { "concept": { "CONCEPT_CLASS_ID": "5-dig billing code", "CONCEPT_CODE": "250.20", "CONCEPT_ID": 44836916, "CONCEPT_NAME": "Diabetes with hyperosmolarity, type II or unspecified type, not stated as uncontrolled", "DOMAIN_ID": "Condition", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "N", "STANDARD_CONCEPT_CAPTION": "Non-Standard", "VOCABULARY_ID": "ICD9CM" } }, { "concept": { "CONCEPT_CLASS_ID": "5-dig billing code", "CONCEPT_CODE": "250.22", "CONCEPT_ID": 44824073, "CONCEPT_NAME": "Diabetes with hyperosmolarity, type II or unspecified type, uncontrolled", "DOMAIN_ID": "Condition", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "N", "STANDARD_CONCEPT_CAPTION": "Non-Standard", "VOCABULARY_ID": "ICD9CM" } }, { "concept": { "CONCEPT_CLASS_ID": "5-dig billing code", "CONCEPT_CODE": "250.21", "CONCEPT_ID": 44832190, "CONCEPT_NAME": "Diabetes with hyperosmolarity, type I [juvenile type], not stated as uncontrolled", "DOMAIN_ID": "Condition", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "N", "STANDARD_CONCEPT_CAPTION": "Non-Standard", "VOCABULARY_ID": "ICD9CM" } }, { "concept": { "CONCEPT_CLASS_ID": "5-dig billing code", "CONCEPT_CODE": "250.23", "CONCEPT_ID": 44832191, "CONCEPT_NAME": "Diabetes with hyperosmolarity, type I [juvenile type], uncontrolled", "DOMAIN_ID": "Condition", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "N", "STANDARD_CONCEPT_CAPTION": "Non-Standard", "VOCABULARY_ID": "ICD9CM" } }, { "concept": { "CONCEPT_CLASS_ID": "4-dig nonbill code", "CONCEPT_CODE": "250.1", "CONCEPT_ID": 44828793, "CONCEPT_NAME": "Diabetes with ketoacidosis", "DOMAIN_ID": "Condition", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "N", "STANDARD_CONCEPT_CAPTION": "Non-Standard", "VOCABULARY_ID": "ICD9CM" } }, { "concept": { "CONCEPT_CLASS_ID": "5-dig billing code", "CONCEPT_CODE": "250.10", "CONCEPT_ID": 44829878, "CONCEPT_NAME": "Diabetes with ketoacidosis, type II or unspecified type, not stated as uncontrolled", "DOMAIN_ID": "Condition", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "N", "STANDARD_CONCEPT_CAPTION": "Non-Standard", "VOCABULARY_ID": "ICD9CM" } }, { "concept": { "CONCEPT_CLASS_ID": "5-dig billing code", "CONCEPT_CODE": "250.12", "CONCEPT_ID": 44824072, "CONCEPT_NAME": "Diabetes with ketoacidosis, type II or unspecified type, uncontrolled", "DOMAIN_ID": "Condition", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "N", "STANDARD_CONCEPT_CAPTION": "Non-Standard", "VOCABULARY_ID": "ICD9CM" } }, { "concept": { "CONCEPT_CLASS_ID": "5-dig billing code", "CONCEPT_CODE": "250.11", "CONCEPT_ID": 44824071, "CONCEPT_NAME": "Diabetes with ketoacidosis, type I [juvenile type], not stated as uncontrolled", "DOMAIN_ID": "Condition", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "N", "STANDARD_CONCEPT_CAPTION": "Non-Standard", "VOCABULARY_ID": "ICD9CM" } }, { "concept": { "CONCEPT_CLASS_ID": "5-dig billing code", "CONCEPT_CODE": "250.13", "CONCEPT_ID": 44822934, "CONCEPT_NAME": "Diabetes with ketoacidosis, type I [juvenile type], uncontrolled", "DOMAIN_ID": "Condition", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "N", "STANDARD_CONCEPT_CAPTION": "Non-Standard", "VOCABULARY_ID": "ICD9CM" } }, { "concept": { "CONCEPT_CLASS_ID": "4-dig nonbill code", "CONCEPT_CODE": "250.6", "CONCEPT_ID": 44827615, "CONCEPT_NAME": "Diabetes with neurological manifestations", "DOMAIN_ID": "Condition", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "N", "STANDARD_CONCEPT_CAPTION": "Non-Standard", "VOCABULARY_ID": "ICD9CM" } }, { "concept": { "CONCEPT_CLASS_ID": "5-dig billing code", "CONCEPT_CODE": "250.60", "CONCEPT_ID": 44828795, "CONCEPT_NAME": "Diabetes with neurological manifestations, type II or unspecified type, not stated as uncontrolled", "DOMAIN_ID": "Condition", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "N", "STANDARD_CONCEPT_CAPTION": "Non-Standard", "VOCABULARY_ID": "ICD9CM" } }, { "concept": { "CONCEPT_CLASS_ID": "5-dig billing code", "CONCEPT_CODE": "250.62", "CONCEPT_ID": 44833366, "CONCEPT_NAME": "Diabetes with neurological manifestations, type II or unspecified type, uncontrolled", "DOMAIN_ID": "Condition", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "N", "STANDARD_CONCEPT_CAPTION": "Non-Standard", "VOCABULARY_ID": "ICD9CM" } }, { "concept": { "CONCEPT_CLASS_ID": "5-dig billing code", "CONCEPT_CODE": "250.61", "CONCEPT_ID": 44831046, "CONCEPT_NAME": "Diabetes with neurological manifestations, type I [juvenile type], not stated as uncontrolled", "DOMAIN_ID": "Condition", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "N", "STANDARD_CONCEPT_CAPTION": "Non-Standard", "VOCABULARY_ID": "ICD9CM" } }, { "concept": { "CONCEPT_CLASS_ID": "5-dig billing code", "CONCEPT_CODE": "250.63", "CONCEPT_ID": 44819501, "CONCEPT_NAME": "Diabetes with neurological manifestations, type I [juvenile type], uncontrolled", "DOMAIN_ID": "Condition", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "N", "STANDARD_CONCEPT_CAPTION": "Non-Standard", "VOCABULARY_ID": "ICD9CM" } }, { "concept": { "CONCEPT_CLASS_ID": "4-dig nonbill code", "CONCEPT_CODE": "250.5", "CONCEPT_ID": 44828794, "CONCEPT_NAME": "Diabetes with ophthalmic manifestations", "DOMAIN_ID": "Condition", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "N", "STANDARD_CONCEPT_CAPTION": "Non-Standard", "VOCABULARY_ID": "ICD9CM" } }, { "concept": { "CONCEPT_CLASS_ID": "5-dig billing code", "CONCEPT_CODE": "250.50", "CONCEPT_ID": 44819500, "CONCEPT_NAME": "Diabetes with ophthalmic manifestations, type II or unspecified type, not stated as uncontrolled", "DOMAIN_ID": "Condition", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "N", "STANDARD_CONCEPT_CAPTION": "Non-Standard", "VOCABULARY_ID": "ICD9CM" } }, { "concept": { "CONCEPT_CLASS_ID": "5-dig billing code", "CONCEPT_CODE": "250.52", "CONCEPT_ID": 44829879, "CONCEPT_NAME": "Diabetes with ophthalmic manifestations, type II or unspecified type, uncontrolled", "DOMAIN_ID": "Condition", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "N", "STANDARD_CONCEPT_CAPTION": "Non-Standard", "VOCABULARY_ID": "ICD9CM" } }, { "concept": { "CONCEPT_CLASS_ID": "5-dig billing code", "CONCEPT_CODE": "250.51", "CONCEPT_ID": 44822936, "CONCEPT_NAME": "Diabetes with ophthalmic manifestations, type I [juvenile type], not stated as uncontrolled", "DOMAIN_ID": "Condition", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "N", "STANDARD_CONCEPT_CAPTION": "Non-Standard", "VOCABULARY_ID": "ICD9CM" } }, { "concept": { "CONCEPT_CLASS_ID": "5-dig billing code", "CONCEPT_CODE": "250.53", "CONCEPT_ID": 44820684, "CONCEPT_NAME": "Diabetes with ophthalmic manifestations, type I [juvenile type], uncontrolled", "DOMAIN_ID": "Condition", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "N", "STANDARD_CONCEPT_CAPTION": "Non-Standard", "VOCABULARY_ID": "ICD9CM" } }, { "concept": { "CONCEPT_CLASS_ID": "4-dig nonbill code", "CONCEPT_CODE": "250.3", "CONCEPT_ID": 44836917, "CONCEPT_NAME": "Diabetes with other coma", "DOMAIN_ID": "Condition", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "N", "STANDARD_CONCEPT_CAPTION": "Non-Standard", "VOCABULARY_ID": "ICD9CM" } }, { "concept": { "CONCEPT_CLASS_ID": "5-dig billing code", "CONCEPT_CODE": "250.30", "CONCEPT_ID": 44826460, "CONCEPT_NAME": "Diabetes with other coma, type II or unspecified type, not stated as uncontrolled", "DOMAIN_ID": "Condition", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "N", "STANDARD_CONCEPT_CAPTION": "Non-Standard", "VOCABULARY_ID": "ICD9CM" } }, { "concept": { "CONCEPT_CLASS_ID": "5-dig billing code", "CONCEPT_CODE": "250.32", "CONCEPT_ID": 44832193, "CONCEPT_NAME": "Diabetes with other coma, type II or unspecified type, uncontrolled", "DOMAIN_ID": "Condition", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "N", "STANDARD_CONCEPT_CAPTION": "Non-Standard", "VOCABULARY_ID": "ICD9CM" } }, { "concept": { "CONCEPT_CLASS_ID": "5-dig billing code", "CONCEPT_CODE": "250.31", "CONCEPT_ID": 44832192, "CONCEPT_NAME": "Diabetes with other coma, type I [juvenile type], not stated as uncontrolled", "DOMAIN_ID": "Condition", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "N", "STANDARD_CONCEPT_CAPTION": "Non-Standard", "VOCABULARY_ID": "ICD9CM" } }, { "concept": { "CONCEPT_CLASS_ID": "5-dig billing code", "CONCEPT_CODE": "250.33", "CONCEPT_ID": 44820683, "CONCEPT_NAME": "Diabetes with other coma, type I [juvenile type], uncontrolled", "DOMAIN_ID": "Condition", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "N", "STANDARD_CONCEPT_CAPTION": "Non-Standard", "VOCABULARY_ID": "ICD9CM" } }, { "concept": { "CONCEPT_CLASS_ID": "4-dig nonbill code", "CONCEPT_CODE": "250.8", "CONCEPT_ID": 44819503, "CONCEPT_NAME": "Diabetes with other specified manifestations", "DOMAIN_ID": "Condition", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "N", "STANDARD_CONCEPT_CAPTION": "Non-Standard", "VOCABULARY_ID": "ICD9CM" } }, { "concept": { "CONCEPT_CLASS_ID": "5-dig billing code", "CONCEPT_CODE": "250.80", "CONCEPT_ID": 44831047, "CONCEPT_NAME": "Diabetes with other specified manifestations, type II or unspecified type, not stated as uncontrolled", "DOMAIN_ID": "Condition", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "N", "STANDARD_CONCEPT_CAPTION": "Non-Standard", "VOCABULARY_ID": "ICD9CM" } }, { "concept": { "CONCEPT_CLASS_ID": "5-dig billing code", "CONCEPT_CODE": "250.82", "CONCEPT_ID": 44826461, "CONCEPT_NAME": "Diabetes with other specified manifestations, type II or unspecified type, uncontrolled", "DOMAIN_ID": "Condition", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "N", "STANDARD_CONCEPT_CAPTION": "Non-Standard", "VOCABULARY_ID": "ICD9CM" } }, { "concept": { "CONCEPT_CLASS_ID": "5-dig billing code", "CONCEPT_CODE": "250.81", "CONCEPT_ID": 44836918, "CONCEPT_NAME": "Diabetes with other specified manifestations, type I [juvenile type], not stated as uncontrolled", "DOMAIN_ID": "Condition", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "N", "STANDARD_CONCEPT_CAPTION": "Non-Standard", "VOCABULARY_ID": "ICD9CM" } }, { "concept": { "CONCEPT_CLASS_ID": "5-dig billing code", "CONCEPT_CODE": "250.83", "CONCEPT_ID": 44833368, "CONCEPT_NAME": "Diabetes with other specified manifestations, type I [juvenile type], uncontrolled", "DOMAIN_ID": "Condition", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "N", "STANDARD_CONCEPT_CAPTION": "Non-Standard", "VOCABULARY_ID": "ICD9CM" } }, { "concept": { "CONCEPT_CLASS_ID": "4-dig nonbill code", "CONCEPT_CODE": "250.7", "CONCEPT_ID": 44829880, "CONCEPT_NAME": "Diabetes with peripheral circulatory disorders", "DOMAIN_ID": "Condition", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "N", "STANDARD_CONCEPT_CAPTION": "Non-Standard", "VOCABULARY_ID": "ICD9CM" } }, { "concept": { "CONCEPT_CLASS_ID": "5-dig billing code", "CONCEPT_CODE": "250.70", "CONCEPT_ID": 44827616, "CONCEPT_NAME": "Diabetes with peripheral circulatory disorders, type II or unspecified type, not stated as uncontrolled", "DOMAIN_ID": "Condition", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "N", "STANDARD_CONCEPT_CAPTION": "Non-Standard", "VOCABULARY_ID": "ICD9CM" } }, { "concept": { "CONCEPT_CLASS_ID": "5-dig billing code", "CONCEPT_CODE": "250.72", "CONCEPT_ID": 44833367, "CONCEPT_NAME": "Diabetes with peripheral circulatory disorders, type II or unspecified type, uncontrolled", "DOMAIN_ID": "Condition", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "N", "STANDARD_CONCEPT_CAPTION": "Non-Standard", "VOCABULARY_ID": "ICD9CM" } }, { "concept": { "CONCEPT_CLASS_ID": "5-dig billing code", "CONCEPT_CODE": "250.71", "CONCEPT_ID": 44825264, "CONCEPT_NAME": "Diabetes with peripheral circulatory disorders, type I [juvenile type], not stated as uncontrolled", "DOMAIN_ID": "Condition", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "N", "STANDARD_CONCEPT_CAPTION": "Non-Standard", "VOCABULARY_ID": "ICD9CM" } }, { "concept": { "CONCEPT_CLASS_ID": "5-dig billing code", "CONCEPT_CODE": "250.73", "CONCEPT_ID": 44819502, "CONCEPT_NAME": "Diabetes with peripheral circulatory disorders, type I [juvenile type], uncontrolled", "DOMAIN_ID": "Condition", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "N", "STANDARD_CONCEPT_CAPTION": "Non-Standard", "VOCABULARY_ID": "ICD9CM" } }, { "concept": { "CONCEPT_CLASS_ID": "4-dig nonbill code", "CONCEPT_CODE": "250.4", "CONCEPT_ID": 44824074, "CONCEPT_NAME": "Diabetes with renal manifestations", "DOMAIN_ID": "Condition", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "N", "STANDARD_CONCEPT_CAPTION": "Non-Standard", "VOCABULARY_ID": "ICD9CM" } }, { "concept": { "CONCEPT_CLASS_ID": "5-dig billing code", "CONCEPT_CODE": "250.40", "CONCEPT_ID": 44831045, "CONCEPT_NAME": "Diabetes with renal manifestations, type II or unspecified type, not stated as uncontrolled", "DOMAIN_ID": "Condition", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "N", "STANDARD_CONCEPT_CAPTION": "Non-Standard", "VOCABULARY_ID": "ICD9CM" } }, { "concept": { "CONCEPT_CLASS_ID": "5-dig billing code", "CONCEPT_CODE": "250.42", "CONCEPT_ID": 44832194, "CONCEPT_NAME": "Diabetes with renal manifestations, type II or unspecified type, uncontrolled", "DOMAIN_ID": "Condition", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "N", "STANDARD_CONCEPT_CAPTION": "Non-Standard", "VOCABULARY_ID": "ICD9CM" } }, { "concept": { "CONCEPT_CLASS_ID": "5-dig billing code", "CONCEPT_CODE": "250.41", "CONCEPT_ID": 44822935, "CONCEPT_NAME": "Diabetes with renal manifestations, type I [juvenile type], not stated as uncontrolled", "DOMAIN_ID": "Condition", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "N", "STANDARD_CONCEPT_CAPTION": "Non-Standard", "VOCABULARY_ID": "ICD9CM" } }, { "concept": { "CONCEPT_CLASS_ID": "5-dig billing code", "CONCEPT_CODE": "250.43", "CONCEPT_ID": 44834549, "CONCEPT_NAME": "Diabetes with renal manifestations, type I [juvenile type], uncontrolled", "DOMAIN_ID": "Condition", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "N", "STANDARD_CONCEPT_CAPTION": "Non-Standard", "VOCABULARY_ID": "ICD9CM" } }, { "concept": { "CONCEPT_CLASS_ID": "4-dig nonbill code", "CONCEPT_CODE": "250.9", "CONCEPT_ID": 44820685, "CONCEPT_NAME": "Diabetes with unspecified complication", "DOMAIN_ID": "Condition", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "N", "STANDARD_CONCEPT_CAPTION": "Non-Standard", "VOCABULARY_ID": "ICD9CM" } }, { "concept": { "CONCEPT_CLASS_ID": "5-dig billing code", "CONCEPT_CODE": "250.90", "CONCEPT_ID": 44827617, "CONCEPT_NAME": "Diabetes with unspecified complication, type II or unspecified type, not stated as uncontrolled", "DOMAIN_ID": "Condition", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "N", "STANDARD_CONCEPT_CAPTION": "Non-Standard", "VOCABULARY_ID": "ICD9CM" } }, { "concept": { "CONCEPT_CLASS_ID": "5-dig billing code", "CONCEPT_CODE": "250.92", "CONCEPT_ID": 44829882, "CONCEPT_NAME": "Diabetes with unspecified complication, type II or unspecified type, uncontrolled", "DOMAIN_ID": "Condition", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "N", "STANDARD_CONCEPT_CAPTION": "Non-Standard", "VOCABULARY_ID": "ICD9CM" } }, { "concept": { "CONCEPT_CLASS_ID": "5-dig billing code", "CONCEPT_CODE": "250.91", "CONCEPT_ID": 44829881, "CONCEPT_NAME": "Diabetes with unspecified complication, type I [juvenile type], not stated as uncontrolled", "DOMAIN_ID": "Condition", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "N", "STANDARD_CONCEPT_CAPTION": "Non-Standard", "VOCABULARY_ID": "ICD9CM" } }, { "concept": { "CONCEPT_CLASS_ID": "5-dig billing code", "CONCEPT_CODE": "250.93", "CONCEPT_ID": 44819504, "CONCEPT_NAME": "Diabetes with unspecified complication, type I [juvenile type], uncontrolled", "DOMAIN_ID": "Condition", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "N", "STANDARD_CONCEPT_CAPTION": "Non-Standard", "VOCABULARY_ID": "ICD9CM" } }, { "concept": { "CONCEPT_CLASS_ID": "Clinical Finding", "CONCEPT_CODE": "73211009", "CONCEPT_ID": 201820, "CONCEPT_NAME": "Diabetes mellitus", "DOMAIN_ID": "Condition", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "S", "STANDARD_CONCEPT_CAPTION": "Standard", "VOCABULARY_ID": "SNOMED" }, "includeDescendants": true }, { "concept": { "CONCEPT_CLASS_ID": "Clinical Finding", "CONCEPT_CODE": "276560009", "CONCEPT_ID": 4079850, "CONCEPT_NAME": "Diabetes mellitus in neonate small for gestational age", "DOMAIN_ID": "Condition", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "S", "STANDARD_CONCEPT_CAPTION": "Standard", "VOCABULARY_ID": "SNOMED" }, "isExcluded": true }, { "concept": { "CONCEPT_CLASS_ID": "Clinical Finding", "CONCEPT_CODE": "5620001000004106", "CONCEPT_ID": 3183244, "CONCEPT_NAME": "Gestational diabetes during pregnancy", "DOMAIN_ID": "Condition", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "S", "STANDARD_CONCEPT_CAPTION": "Standard", "VOCABULARY_ID": "Nebraska Lexicon" }, "isExcluded": true }, { "concept": { "CONCEPT_CLASS_ID": "Clinical Finding", "CONCEPT_CODE": "11687002", "CONCEPT_ID": 4024659, "CONCEPT_NAME": "Gestational diabetes mellitus", "DOMAIN_ID": "Condition", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "S", "STANDARD_CONCEPT_CAPTION": "Standard", "VOCABULARY_ID": "SNOMED" }, "isExcluded": true }, { "concept": { "CONCEPT_CLASS_ID": "Clinical Finding", "CONCEPT_CODE": "75022004", "CONCEPT_ID": 4326434, "CONCEPT_NAME": "Gestational diabetes mellitus, class A>1<", "DOMAIN_ID": "Condition", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "S", "STANDARD_CONCEPT_CAPTION": "Standard", "VOCABULARY_ID": "SNOMED" }, "isExcluded": true }, { "concept": { "CONCEPT_CLASS_ID": "Clinical Finding", "CONCEPT_CODE": "46894009", "CONCEPT_ID": 4263902, "CONCEPT_NAME": "Gestational diabetes mellitus, class A>2<", "DOMAIN_ID": "Condition", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "S", "STANDARD_CONCEPT_CAPTION": "Standard", "VOCABULARY_ID": "SNOMED" }, "isExcluded": true }, { "concept": { "CONCEPT_CLASS_ID": "Clinical Finding", "CONCEPT_CODE": "40801000119106", "CONCEPT_ID": 37018765, "CONCEPT_NAME": "Gestational diabetes mellitus complicating pregnancy", "DOMAIN_ID": "Condition", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "S", "STANDARD_CONCEPT_CAPTION": "Standard", "VOCABULARY_ID": "SNOMED" }, "isExcluded": true }, { "concept": { "CONCEPT_CLASS_ID": "Clinical Finding", "CONCEPT_CODE": "10753491000119101", "CONCEPT_ID": 45757124, "CONCEPT_NAME": "Gestational diabetes mellitus in childbirth", "DOMAIN_ID": "Condition", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "S", "STANDARD_CONCEPT_CAPTION": "Standard", "VOCABULARY_ID": "SNOMED" }, "isExcluded": true }, { "concept": { "CONCEPT_CLASS_ID": "Clinical Finding", "CONCEPT_CODE": "40791000119105", "CONCEPT_ID": 45757789, "CONCEPT_NAME": "Postpartum gestational diabetes mellitus", "DOMAIN_ID": "Condition", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "S", "STANDARD_CONCEPT_CAPTION": "Standard", "VOCABULARY_ID": "SNOMED" }, "isExcluded": true } ] } }, { "id": 1, "name": "HbA1c", "expression": { "items": [ { "concept": { "CONCEPT_CLASS_ID": "Lab Test", "CONCEPT_CODE": "4548-4", "CONCEPT_ID": 3004410, "CONCEPT_NAME": "Hemoglobin A1c/Hemoglobin.total in Blood", "DOMAIN_ID": "Measurement", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "S", "STANDARD_CONCEPT_CAPTION": "Standard", "VOCABULARY_ID": "LOINC" } }, { "concept": { "CONCEPT_CLASS_ID": "Lab Test", "CONCEPT_CODE": "17855-8", "CONCEPT_ID": 3007263, "CONCEPT_NAME": "Hemoglobin A1c/Hemoglobin.total in Blood by calculation", "DOMAIN_ID": "Measurement", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "S", "STANDARD_CONCEPT_CAPTION": "Standard", "VOCABULARY_ID": "LOINC" } }, { "concept": { "CONCEPT_CLASS_ID": "Lab Test", "CONCEPT_CODE": "4549-2", "CONCEPT_ID": 3003309, "CONCEPT_NAME": "Hemoglobin A1c/Hemoglobin.total in Blood by Electrophoresis", "DOMAIN_ID": "Measurement", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "S", "STANDARD_CONCEPT_CAPTION": "Standard", "VOCABULARY_ID": "LOINC" } }, { "concept": { "CONCEPT_CLASS_ID": "Lab Test", "CONCEPT_CODE": "17856-6", "CONCEPT_ID": 3005673, "CONCEPT_NAME": "Hemoglobin A1c/Hemoglobin.total in Blood by HPLC", "DOMAIN_ID": "Measurement", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "S", "STANDARD_CONCEPT_CAPTION": "Standard", "VOCABULARY_ID": "LOINC" } }, { "concept": { "CONCEPT_CLASS_ID": "Lab Test", "CONCEPT_CODE": "59261-8", "CONCEPT_ID": 40762352, "CONCEPT_NAME": "Hemoglobin A1c/Hemoglobin.total in Blood by IFCC protocol", "DOMAIN_ID": "Measurement", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "S", "STANDARD_CONCEPT_CAPTION": "Standard", "VOCABULARY_ID": "LOINC" } }, { "concept": { "CONCEPT_CLASS_ID": "Lab Test", "CONCEPT_CODE": "62388-4", "CONCEPT_ID": 40765129, "CONCEPT_NAME": "Hemoglobin A1c/Hemoglobin.total in Blood by JDS/JSCC protocol", "DOMAIN_ID": "Measurement", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "S", "STANDARD_CONCEPT_CAPTION": "Standard", "VOCABULARY_ID": "LOINC" } }, { "concept": { "CONCEPT_CLASS_ID": "Lab Test", "CONCEPT_CODE": "71875-9", "CONCEPT_ID": 42869630, "CONCEPT_NAME": "Hemoglobin A1c/Hemoglobin.total [Pure mass fraction] in Blood", "DOMAIN_ID": "Measurement", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "S", "STANDARD_CONCEPT_CAPTION": "Standard", "VOCABULARY_ID": "LOINC" } }, { "concept": { "CONCEPT_CLASS_ID": "Lab Test", "CONCEPT_CODE": "41995-2", "CONCEPT_ID": 3034639, "CONCEPT_NAME": "Hemoglobin A1c [Mass/volume] in Blood", "DOMAIN_ID": "Measurement", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "S", "STANDARD_CONCEPT_CAPTION": "Standard", "VOCABULARY_ID": "LOINC" } } ] } }, { "id": 2, "name": "Fasting Glucose", "expression": { "items": [ { "concept": { "CONCEPT_CLASS_ID": "Lab Test", "CONCEPT_CODE": "35184-1", "CONCEPT_ID": 3031499, "CONCEPT_NAME": "Fasting glucose [Mass or Moles/volume] in Serum or Plasma", "DOMAIN_ID": "Measurement", "INVALID_REASON": "D", "INVALID_REASON_CAPTION": "Invalid", "STANDARD_CONCEPT": "N", "STANDARD_CONCEPT_CAPTION": "Non-Standard", "VOCABULARY_ID": "LOINC" } }, { "concept": { "CONCEPT_CLASS_ID": "Lab Test", "CONCEPT_CODE": "1556-0", "CONCEPT_ID": 3036671, "CONCEPT_NAME": "Fasting glucose [Mass/volume] in Capillary blood", "DOMAIN_ID": "Measurement", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "S", "STANDARD_CONCEPT_CAPTION": "Standard", "VOCABULARY_ID": "LOINC" } }, { "concept": { "CONCEPT_CLASS_ID": "Lab Test", "CONCEPT_CODE": "41604-0", "CONCEPT_ID": 3035250, "CONCEPT_NAME": "Fasting glucose [Mass/volume] in Capillary blood by Glucometer", "DOMAIN_ID": "Measurement", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "S", "STANDARD_CONCEPT_CAPTION": "Standard", "VOCABULARY_ID": "LOINC" } }, { "concept": { "CONCEPT_CLASS_ID": "Lab Test", "CONCEPT_CODE": "1558-6", "CONCEPT_ID": 3037110, "CONCEPT_NAME": "Fasting glucose [Mass/volume] in Serum or Plasma", "DOMAIN_ID": "Measurement", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "S", "STANDARD_CONCEPT_CAPTION": "Standard", "VOCABULARY_ID": "LOINC" } }, { "concept": { "CONCEPT_CLASS_ID": "Lab Test", "CONCEPT_CODE": "63382-6", "CONCEPT_ID": 40766113, "CONCEPT_NAME": "Fasting glucose [Mass/volume] in Urine", "DOMAIN_ID": "Measurement", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "S", "STANDARD_CONCEPT_CAPTION": "Standard", "VOCABULARY_ID": "LOINC" } }, { "concept": { "CONCEPT_CLASS_ID": "Lab Test", "CONCEPT_CODE": "1557-8", "CONCEPT_ID": 3037187, "CONCEPT_NAME": "Fasting glucose [Mass/volume] in Venous blood", "DOMAIN_ID": "Measurement", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "S", "STANDARD_CONCEPT_CAPTION": "Standard", "VOCABULARY_ID": "LOINC" } }, { "concept": { "CONCEPT_CLASS_ID": "Lab Test", "CONCEPT_CODE": "76629-5", "CONCEPT_ID": 46235168, "CONCEPT_NAME": "Fasting glucose [Moles/volume] in Blood", "DOMAIN_ID": "Measurement", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "S", "STANDARD_CONCEPT_CAPTION": "Standard", "VOCABULARY_ID": "LOINC" } }, { "concept": { "CONCEPT_CLASS_ID": "Lab Test", "CONCEPT_CODE": "14770-2", "CONCEPT_ID": 3017703, "CONCEPT_NAME": "Fasting glucose [Moles/volume] in Capillary blood by Glucometer", "DOMAIN_ID": "Measurement", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "S", "STANDARD_CONCEPT_CAPTION": "Standard", "VOCABULARY_ID": "LOINC" } }, { "concept": { "CONCEPT_CLASS_ID": "Lab Test", "CONCEPT_CODE": "14771-0", "CONCEPT_ID": 3018251, "CONCEPT_NAME": "Fasting glucose [Moles/volume] in Serum or Plasma", "DOMAIN_ID": "Measurement", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "S", "STANDARD_CONCEPT_CAPTION": "Standard", "VOCABULARY_ID": "LOINC" } }, { "concept": { "CONCEPT_CLASS_ID": "Lab Test", "CONCEPT_CODE": "77145-1", "CONCEPT_ID": 46236950, "CONCEPT_NAME": "Fasting glucose [Moles/volume] in Serum, Plasma or Blood", "DOMAIN_ID": "Measurement", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "S", "STANDARD_CONCEPT_CAPTION": "Standard", "VOCABULARY_ID": "LOINC" } }, { "concept": { "CONCEPT_CLASS_ID": "Lab Test", "CONCEPT_CODE": "53114-5", "CONCEPT_ID": 3041651, "CONCEPT_NAME": "Fasting glucose [Moles/volume] in Urine", "DOMAIN_ID": "Measurement", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "S", "STANDARD_CONCEPT_CAPTION": "Standard", "VOCABULARY_ID": "LOINC" } }, { "concept": { "CONCEPT_CLASS_ID": "Lab Test", "CONCEPT_CODE": "16913-6", "CONCEPT_ID": 3025791, "CONCEPT_NAME": "Fasting glucose [Presence] in Urine", "DOMAIN_ID": "Measurement", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "S", "STANDARD_CONCEPT_CAPTION": "Standard", "VOCABULARY_ID": "LOINC" } }, { "concept": { "CONCEPT_CLASS_ID": "Lab Test", "CONCEPT_CODE": "6764-5", "CONCEPT_ID": 3002574, "CONCEPT_NAME": "Fasting glucose [Presence] in Urine by Test strip", "DOMAIN_ID": "Measurement", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "S", "STANDARD_CONCEPT_CAPTION": "Standard", "VOCABULARY_ID": "LOINC" } }, { "concept": { "CONCEPT_CLASS_ID": "Lab Test", "CONCEPT_CODE": "10450-5", "CONCEPT_ID": 3025211, "CONCEPT_NAME": "Glucose [Mass/volume] in Serum or Plasma --10 hours fasting", "DOMAIN_ID": "Measurement", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "S", "STANDARD_CONCEPT_CAPTION": "Standard", "VOCABULARY_ID": "LOINC" } }, { "concept": { "CONCEPT_CLASS_ID": "Lab Test", "CONCEPT_CODE": "1554-5", "CONCEPT_ID": 3002009, "CONCEPT_NAME": "Glucose [Mass/volume] in Serum or Plasma --12 hours fasting", "DOMAIN_ID": "Measurement", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "S", "STANDARD_CONCEPT_CAPTION": "Standard", "VOCABULARY_ID": "LOINC" } }, { "concept": { "CONCEPT_CLASS_ID": "Lab Test", "CONCEPT_CODE": "1493-6", "CONCEPT_ID": 3021232, "CONCEPT_NAME": "Glucose [Mass/volume] in Serum or Plasma --1.5 hours post 0.05-0.15 U insulin/kg IV 12 hours fasting", "DOMAIN_ID": "Measurement", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "S", "STANDARD_CONCEPT_CAPTION": "Standard", "VOCABULARY_ID": "LOINC" } }, { "concept": { "CONCEPT_CLASS_ID": "Lab Test", "CONCEPT_CODE": "17865-7", "CONCEPT_ID": 3024762, "CONCEPT_NAME": "Glucose [Mass/volume] in Serum or Plasma --8 hours fasting", "DOMAIN_ID": "Measurement", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "S", "STANDARD_CONCEPT_CAPTION": "Standard", "VOCABULARY_ID": "LOINC" } }, { "concept": { "CONCEPT_CLASS_ID": "Lab Test", "CONCEPT_CODE": "1555-2", "CONCEPT_ID": 3020632, "CONCEPT_NAME": "Glucose [Mass/volume] in Urine --12 hours fasting", "DOMAIN_ID": "Measurement", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "S", "STANDARD_CONCEPT_CAPTION": "Standard", "VOCABULARY_ID": "LOINC" } }, { "concept": { "CONCEPT_CLASS_ID": "Lab Test", "CONCEPT_CODE": "95102-0", "CONCEPT_ID": 36660046, "CONCEPT_NAME": "Glucose post fasting and meal stimulation panel - Serum or Plasma", "DOMAIN_ID": "Measurement", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "S", "STANDARD_CONCEPT_CAPTION": "Standard", "VOCABULARY_ID": "LOINC" } } ] } }, { "id": 3, "name": "Random Glucose", "expression": { "items": [ { "concept": { "CONCEPT_CLASS_ID": "Lab Test", "CONCEPT_CODE": "2339-0", "CONCEPT_ID": 3000483, "CONCEPT_NAME": "Glucose [Mass/volume] in Blood", "DOMAIN_ID": "Measurement", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "S", "STANDARD_CONCEPT_CAPTION": "Standard", "VOCABULARY_ID": "LOINC" } }, { "concept": { "CONCEPT_CLASS_ID": "Lab Test", "CONCEPT_CODE": "32016-8", "CONCEPT_ID": 3004077, "CONCEPT_NAME": "Glucose [Mass/volume] in Capillary blood", "DOMAIN_ID": "Measurement", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "S", "STANDARD_CONCEPT_CAPTION": "Standard", "VOCABULARY_ID": "LOINC" } } ] } }, { "id": 4, "name": "Antihyperglycemic Medications", "expression": { "items": [ { "concept": { "CONCEPT_CLASS_ID": "Ingredient", "CONCEPT_CODE": "16681", "CONCEPT_ID": 1529331, "CONCEPT_NAME": "acarbose", "DOMAIN_ID": "Drug", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "S", "STANDARD_CONCEPT_CAPTION": "Standard", "VOCABULARY_ID": "RxNorm" }, "includeDescendants": true }, { "concept": { "CONCEPT_CLASS_ID": "Ingredient", "CONCEPT_CODE": "173", "CONCEPT_ID": 1530014, "CONCEPT_NAME": "acetohexamide", "DOMAIN_ID": "Drug", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "S", "STANDARD_CONCEPT_CAPTION": "Standard", "VOCABULARY_ID": "RxNorm" }, "includeDescendants": true }, { "concept": { "CONCEPT_CLASS_ID": "Ingredient", "CONCEPT_CODE": "2404", "CONCEPT_ID": 1594973, "CONCEPT_NAME": "chlorpropamide", "DOMAIN_ID": "Drug", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "S", "STANDARD_CONCEPT_CAPTION": "Standard", "VOCABULARY_ID": "RxNorm" }, "includeDescendants": true }, { "concept": { "CONCEPT_CLASS_ID": "Ingredient", "CONCEPT_CODE": "60548", "CONCEPT_ID": 1583722, "CONCEPT_NAME": "exenatide", "DOMAIN_ID": "Drug", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "S", "STANDARD_CONCEPT_CAPTION": "Standard", "VOCABULARY_ID": "RxNorm" }, "includeDescendants": true }, { "concept": { "CONCEPT_CLASS_ID": "Ingredient", "CONCEPT_CODE": "25789", "CONCEPT_ID": 1597756, "CONCEPT_NAME": "glimepiride", "DOMAIN_ID": "Drug", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "S", "STANDARD_CONCEPT_CAPTION": "Standard", "VOCABULARY_ID": "RxNorm" }, "includeDescendants": true }, { "concept": { "CONCEPT_CLASS_ID": "Ingredient", "CONCEPT_CODE": "4821", "CONCEPT_ID": 1560171, "CONCEPT_NAME": "glipizide", "DOMAIN_ID": "Drug", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "S", "STANDARD_CONCEPT_CAPTION": "Standard", "VOCABULARY_ID": "RxNorm" }, "includeDescendants": true }, { "concept": { "CONCEPT_CLASS_ID": "Ingredient", "CONCEPT_CODE": "4815", "CONCEPT_ID": 1559684, "CONCEPT_NAME": "glyburide", "DOMAIN_ID": "Drug", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "S", "STANDARD_CONCEPT_CAPTION": "Standard", "VOCABULARY_ID": "RxNorm" }, "includeDescendants": true }, { "concept": { "CONCEPT_CLASS_ID": "Ingredient", "CONCEPT_CODE": "30009", "CONCEPT_ID": 1510202, "CONCEPT_NAME": "miglitol", "DOMAIN_ID": "Drug", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "S", "STANDARD_CONCEPT_CAPTION": "Standard", "VOCABULARY_ID": "RxNorm" }, "includeDescendants": true }, { "concept": { "CONCEPT_CLASS_ID": "Ingredient", "CONCEPT_CODE": "274332", "CONCEPT_ID": 1502826, "CONCEPT_NAME": "nateglinide", "DOMAIN_ID": "Drug", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "S", "STANDARD_CONCEPT_CAPTION": "Standard", "VOCABULARY_ID": "RxNorm" }, "includeDescendants": true }, { "concept": { "CONCEPT_CLASS_ID": "Ingredient", "CONCEPT_CODE": "33738", "CONCEPT_ID": 1525215, "CONCEPT_NAME": "pioglitazone", "DOMAIN_ID": "Drug", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "S", "STANDARD_CONCEPT_CAPTION": "Standard", "VOCABULARY_ID": "RxNorm" }, "includeDescendants": true }, { "concept": { "CONCEPT_CLASS_ID": "Ingredient", "CONCEPT_CODE": "73044", "CONCEPT_ID": 1516766, "CONCEPT_NAME": "repaglinide", "DOMAIN_ID": "Drug", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "S", "STANDARD_CONCEPT_CAPTION": "Standard", "VOCABULARY_ID": "RxNorm" }, "includeDescendants": true }, { "concept": { "CONCEPT_CLASS_ID": "Ingredient", "CONCEPT_CODE": "84108", "CONCEPT_ID": 1547504, "CONCEPT_NAME": "rosiglitazone", "DOMAIN_ID": "Drug", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "S", "STANDARD_CONCEPT_CAPTION": "Standard", "VOCABULARY_ID": "RxNorm" }, "includeDescendants": true }, { "concept": { "CONCEPT_CLASS_ID": "Ingredient", "CONCEPT_CODE": "593411", "CONCEPT_ID": 1580747, "CONCEPT_NAME": "sitagliptin", "DOMAIN_ID": "Drug", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "S", "STANDARD_CONCEPT_CAPTION": "Standard", "VOCABULARY_ID": "RxNorm" }, "includeDescendants": true }, { "concept": { "CONCEPT_CLASS_ID": "Ingredient", "CONCEPT_CODE": "10633", "CONCEPT_ID": 1502809, "CONCEPT_NAME": "tolazamide", "DOMAIN_ID": "Drug", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "S", "STANDARD_CONCEPT_CAPTION": "Standard", "VOCABULARY_ID": "RxNorm" }, "includeDescendants": true }, { "concept": { "CONCEPT_CLASS_ID": "Ingredient", "CONCEPT_CODE": "72610", "CONCEPT_ID": 1515249, "CONCEPT_NAME": "troglitazone", "DOMAIN_ID": "Drug", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "S", "STANDARD_CONCEPT_CAPTION": "Standard", "VOCABULARY_ID": "RxNorm" }, "includeDescendants": true }, { "concept": { "CONCEPT_CLASS_ID": "Ingredient", "CONCEPT_CODE": "139953", "CONCEPT_ID": 1517998, "CONCEPT_NAME": "pramlintide", "DOMAIN_ID": "Drug", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "S", "STANDARD_CONCEPT_CAPTION": "Standard", "VOCABULARY_ID": "RxNorm" }, "includeDescendants": true }, { "concept": { "CONCEPT_CLASS_ID": "Ingredient", "CONCEPT_CODE": "1740938", "CONCEPT_ID": 35605670, "CONCEPT_NAME": "insulin argine", "DOMAIN_ID": "Drug", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "S", "STANDARD_CONCEPT_CAPTION": "Standard", "VOCABULARY_ID": "RxNorm" }, "includeDescendants": true }, { "concept": { "CONCEPT_CLASS_ID": "Ingredient", "CONCEPT_CODE": "1670007", "CONCEPT_ID": 35602717, "CONCEPT_NAME": "insulin degludec", "DOMAIN_ID": "Drug", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "S", "STANDARD_CONCEPT_CAPTION": "Standard", "VOCABULARY_ID": "RxNorm" }, "includeDescendants": true }, { "concept": { "CONCEPT_CLASS_ID": "Ingredient", "CONCEPT_CODE": "139825", "CONCEPT_ID": 1516976, "CONCEPT_NAME": "insulin detemir", "DOMAIN_ID": "Drug", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "S", "STANDARD_CONCEPT_CAPTION": "Standard", "VOCABULARY_ID": "RxNorm" }, "includeDescendants": true }, { "concept": { "CONCEPT_CLASS_ID": "Ingredient", "CONCEPT_CODE": "274783", "CONCEPT_ID": 1502905, "CONCEPT_NAME": "insulin glargine", "DOMAIN_ID": "Drug", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "S", "STANDARD_CONCEPT_CAPTION": "Standard", "VOCABULARY_ID": "RxNorm" }, "includeDescendants": true }, { "concept": { "CONCEPT_CLASS_ID": "Ingredient", "CONCEPT_CODE": "1605101", "CONCEPT_ID": 46221581, "CONCEPT_NAME": "insulin isophane", "DOMAIN_ID": "Drug", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "S", "STANDARD_CONCEPT_CAPTION": "Standard", "VOCABULARY_ID": "RxNorm" }, "includeDescendants": true }, { "concept": { "CONCEPT_CLASS_ID": "Ingredient", "CONCEPT_CODE": "86009", "CONCEPT_ID": 1550023, "CONCEPT_NAME": "insulin lispro", "DOMAIN_ID": "Drug", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "S", "STANDARD_CONCEPT_CAPTION": "Standard", "VOCABULARY_ID": "RxNorm" }, "includeDescendants": true }, { "concept": { "CONCEPT_CLASS_ID": "Ingredient", "CONCEPT_CODE": "OMOP4819461", "CONCEPT_ID": 35198096, "CONCEPT_NAME": "insulin aspart", "DOMAIN_ID": "Drug", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "S", "STANDARD_CONCEPT_CAPTION": "Standard", "VOCABULARY_ID": "RxNorm Extension" }, "includeDescendants": true }, { "concept": { "CONCEPT_CLASS_ID": "Ingredient", "CONCEPT_CODE": "1309342", "CONCEPT_ID": 42899447, "CONCEPT_NAME": "insulin, pork", "DOMAIN_ID": "Drug", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "S", "STANDARD_CONCEPT_CAPTION": "Standard", "VOCABULARY_ID": "RxNorm" }, "includeDescendants": true }, { "concept": { "CONCEPT_CLASS_ID": "Ingredient", "CONCEPT_CODE": "400008", "CONCEPT_ID": 1544838, "CONCEPT_NAME": "insulin glulisine, human", "DOMAIN_ID": "Drug", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "S", "STANDARD_CONCEPT_CAPTION": "Standard", "VOCABULARY_ID": "RxNorm" }, "includeDescendants": true }, { "concept": { "CONCEPT_CLASS_ID": "Ingredient", "CONCEPT_CODE": "51428", "CONCEPT_ID": 1567198, "CONCEPT_NAME": "insulin aspart, human", "DOMAIN_ID": "Drug", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "STANDARD_CONCEPT": "S", "STANDARD_CONCEPT_CAPTION": "Standard", "VOCABULARY_ID": "RxNorm" }, "includeDescendants": true } ] } } ], "PrimaryCriteria": { "CriteriaList": [ { "ConditionOccurrence": {} }, { "Measurement": {} }, { "DrugExposure": {} } ], "ObservationWindow": { "PriorDays": 0, "PostDays": 0 }, "PrimaryCriteriaLimit": { "Type": "First" } }, "AdditionalCriteria": { "Type": "ANY", "CriteriaList": [ { "Criteria": { "DrugEra": { "CodesetId": 4 } }, "StartWindow": { "Start": { "Coeff": -1 }, "End": { "Coeff": 1 }, "UseEventEnd": false }, "Occurrence": { "Type": 2, "Count": 1 } } ], "DemographicCriteriaList": [], "Groups": [ { "Type": "ANY", "CriteriaList": [ { "Criteria": { "ConditionOccurrence": { "CodesetId": 0, "VisitType": [ { "CONCEPT_CODE": "21", "CONCEPT_ID": 8717, "CONCEPT_NAME": "Inpatient Hospital", "DOMAIN_ID": "Visit", "INVALID_REASON_CAPTION": "Unknown", "STANDARD_CONCEPT_CAPTION": "Unknown", "VOCABULARY_ID": "CMS Place of Service" }, { "CONCEPT_CODE": "IP", "CONCEPT_ID": 9201, "CONCEPT_NAME": "Inpatient Visit", "DOMAIN_ID": "Visit", "INVALID_REASON_CAPTION": "Unknown", "STANDARD_CONCEPT_CAPTION": "Unknown", "VOCABULARY_ID": "Visit" } ] } }, "StartWindow": { "Start": { "Coeff": -1 }, "End": { "Coeff": 1 }, "UseEventEnd": false }, "Occurrence": { "Type": 2, "Count": 1 } }, { "Criteria": { "ConditionOccurrence": { "CodesetId": 0 } }, "StartWindow": { "Start": { "Coeff": -1 }, "End": { "Coeff": 1 }, "UseEventEnd": false }, "Occurrence": { "Type": 2, "Count": 2 } } ], "DemographicCriteriaList": [], "Groups": [] }, { "Type": "ANY", "CriteriaList": [ { "Criteria": { "Measurement": { "CodesetId": 2, "ValueAsNumber": { "Value": 126, "Op": "gt" } } }, "StartWindow": { "Start": { "Coeff": -1 }, "End": { "Coeff": 1 }, "UseEventEnd": false }, "Occurrence": { "Type": 2, "Count": 2 } }, { "Criteria": { "Measurement": { "CodesetId": 3, "ValueAsNumber": { "Value": 200, "Op": "gt" } } }, "StartWindow": { "Start": { "Coeff": -1 }, "End": { "Coeff": 1 }, "UseEventEnd": false }, "Occurrence": { "Type": 2, "Count": 2 } }, { "Criteria": { "Measurement": { "CodesetId": 1, "ValueAsNumber": { "Value": 6.5, "Op": "gt" } } }, "StartWindow": { "Start": { "Coeff": -1 }, "End": { "Coeff": 1 }, "UseEventEnd": false }, "Occurrence": { "Type": 2, "Count": 2 } } ], "DemographicCriteriaList": [], "Groups": [] } ] }, "QualifiedLimit": { "Type": "First" }, "ExpressionLimit": { "Type": "First" }, "InclusionRules": [], "CensoringCriteria": [], "CollapseSettings": { "CollapseType": "ERA", "EraPad": 0 }, "CensorWindow": {}, "cdmVersionRange": ">=5.0.0" } ```

and here is the direct link to the cohort definition on ATLAS demo: https://atlas-demo.ohdsi.org/#/cohortdefinition/1778180/

What am I doing wrong here? Thank you!

xitology commented 2 years ago

Thank you for the report! This error is caused by an incompatible change in FunSQL v0.9.0 and is already fixed in cfd03c062a4222a2f7c483b5475f6148891d4301, but I forgot to tag it. I tagged it just now.