SQLite format 3@ :/:.f= r  /=FG[5indexsqlite_autoindex_cohort_relationships_1cohort_relationshipsD))Ctablecohort_overlapcohort_overlapCREATE TABLE cohort_overlap ( either_subjects BIGINT NOT NULL, both_subjects BIGINT NOT NULL, t_only_subjects BIGINT NOT NULL, c_only_subjects BIGINT NOT NULL, t_before_c_subjects BIGINT NOT NULL, c_before_t_subjects BIGINT NOT NULL, same_day_subjects BIGINT NOT NULL, t_in_c_subjects BIGINT NOT NULL, c_in_t_subjects BIGINT NOT NULL, target_cohort_id BIGINT NOT NULL, comparator_cohort_id BIGINT NOT NULL, database_id TEXT NOT NULL, PRIMARY KEY(target_cohort_id, comparator_cohort_id, database_id) );O)indexsqlite_autoindex_cohort_overlap_1cohort_overlap'55qtablecohort_summary_statscohort_summary_statsCREATE TABLE cohort_summary_stats ( database_id TEXT NOT NULL, cohort_id BIGINT NOT NULL, mode_id BIGINT NOT NULL, base_count BIGINT NOT NULL, final_count BIGINT NOT NULL, PRIMARY KEY(cohort_id, database_id, mode_id) )G[5indexsqlite_autoindex_cohort_summary_stats_1cohort_summary_statsn --tablecohort_inc_statscohort_inc_statsCREATE TABLE cohort_inc_stats ( cohort_id BIGINT NOT NULL, database_id TEXT NOT NULL, rule_sequence INT NOT NULL, mode_id BIGINT NOT NULL, person_count BIGINT NOT NULL, gain_count BIGINT NOT NULL, person_total BIGINT NOT NULL, PRIMARY KEY(cohort_id, database_id, rule_sequence, mode_id) )?S-indexsqlite_autoindex_cohort_inc_stats_1cohort_inc_stats= //)tablecohort_inc_resultcohort_inc_result CREATE TABLE cohort_inc_result ( cohort_id BIGINT NOT NULL, database_id TEXT NOT NULL, mode_id BIGINT NOT NULL, inclusion_rule_mask BIGINT NOT NULL, person_count BIGINT NOT NULL, PRIMARY KEY(cohort_id, database_id, mode_id, inclusion_rule_mask) )A U/indexsqlite_autoindex_cohort_inc_result_1cohort_inc_result  --Utablecohort_inclusioncohort_inclusion CREATE TABLE cohort_inclusion ( cohort_id BIGINT NOT NULL, database_id TEXT NOT NULL, rule_sequence INT NOT NULL, name TEXT NOT NULL, description TEXT, PRIMARY KEY(cohort_id, database_id, rule_sequence) )? S-indexsqlite_autoindex_cohort_inclusion_1cohort_inclusion l%%tablecohort_countcohort_countCREATE TABLE cohort_count ( cohort_id BIGINT NOT NULL, cohort_entries BIGINT NOT NULL, cohort_subjects BIGINT NOT NULL, database_id TEXT NOT NULL, PRIMARY KEY(cohort_id, database_id) )7K%indexsqlite_autoindex_cohort_count_1cohort_count 77Stableannotation_attributesannotation_attributesCREATE TABLE annotation_attributes ( annotation_id BIGINT NOT NULL DEFAULT 0, created_by TEXT NOT NULL, annotation_attributes TEXT NOT NULL, created_on BIGINT NOT NULL, PRIMARY KEY(annotation_id, created_by) )I]7indexsqlite_autoindex_annotation_attributes_1annotation_attributes++qtableannotation_linkannotation_linkCREATE TABLE annotation_link ( annotation_id BIGINT NOT NULL DEFAULT 0, diagnostics_id TEXT NOT NULL, cohort_id BIGINT NOT NULL, database_id TEXT NOT NULL, PRIMARY KEY(annotation_id, diagnostics_id, cohort_id, database_id) )=Q+indexsqlite_autoindex_annotation_link_1annotation_link !!_tableannotationannotationCREATE TABLE annotation ( annotation_id BIGINT NOT NULL, created_by TEXT NOT NULL, created_on BIGINT NOT NULL, modified_last_on BIGINT, deleted_on BIGINT, annotation TEXT NOT NULL, PRIMARY KEY(annotation_id) )3G!indexsqlite_autoindex_annotation_1anno(5!       #covid_ohdsi#covid_ohdsi #covid_ohdsi# covid_ohdsi              Ww r  /=F[5indexsqlite_autoindex_cohort_relationships_1cohort_relationships=O)indexsqlite_autoindex_cohort_overlap_1cohort_overlapD))Ctablecohort_overlapcohort_overlapCREATE TABLE cohort_overlap ( either_subjects BIGINT NOT NULL, both_subjects BIGINT NOT NULL, t_only_subjects BIGINT NOT NULL, c_only_subjects BIGINT NOT NULL, t_before_c_subjects BIGINT NOT NULL, c_before_t_subjects BIGINT NOT NULL, same_day_subjects BIGINT NOT NULL, t_in_c_subjects BIGINT NOT NULL, c_in_t_subjects BIGINT NOT NULL, target_cohort_id BIGINT NOT NULL, comparator_cohort_id BIGINT NOT NULL, database_id TEXT NOT NULL, PRIMARY KEY(target_cohort_id, comparator_cohort_id, database_id) )'55qtablecohort_summary_statscohort_summary_statsCREATE TABLE cohort_summary_stats ( database_id TEXT NOT NULL, cohort_id BIGINT NOT NULL, mode_id BIGINT NOT NULL, base_count BIGINT NOT NULL, final_count BIGINT NOT NULL, PRIMARY KEY(cohort_id, database_id, mode_id) )G[5indexsqlite_autoindex_cohort_summary_stats_1cohort_summary_statsn --tablecohort_inc_statscohort_inc_statsCREATE TABLE cohort_inc_stats ( cohort_id BIGINT NOT NULL, database_id TEXT NOT NULL, rule_sequence INT NOT NULL, mode_id BIGINT NOT NULL, person_count BIGINT NOT NULL, gain_count BIGINT NOT NULL, person_total BIGINT NOT NULL, PRIMARY KEY(cohort_id, database_id, rule_sequence, mode_id) )?S-indexsqlite_autoindex_cohort_inc_stats_1cohort_inc_stats= //)tablecohort_inc_resultcohort_inc_result CREATE TABLE cohort_inc_result ( cohort_id BIGINT NOT NULL, database_id TEXT NOT NULL, mode_id BIGINT NOT NULL, inclusion_rule_mask BIGINT NOT NULL, person_count BIGINT NOT NULL, PRIMARY KEY(cohort_id, database_id, mode_id, inclusion_rule_mask) )A U/indexsqlite_autoindex_cohort_inc_result_1cohort_inc_result  --Utablecohort_inclusioncohort_inclusion CREATE TABLE cohort_inclusion ( cohort_id BIGINT NOT NULL, database_id TEXT NOT NULL, rule_sequence INT NOT NULL, name TEXT NOT NULL, description TEXT, PRIMARY KEY(cohort_id, database_id, rule_sequence) )? S-indexsqlite_autoindex_cohort_inclusion_1cohort_inclusion l%%tablecohort_countcohort_countCREATE TABLE cohort_count ( cohort_id BIGINT NOT NULL, cohort_entries BIGINT NOT NULL, cohort_subjects BIGINT NOT NULL, database_id TEXT NOT NULL, PRIMARY KEY(cohort_id, database_id) )7K%indexsqlite_autoindex_cohort_count_1cohort_count 77Stableannotation_attributesannotation_attributesCREATE TABLE annotation_attributes ( annotation_id BIGINT NOT NULL DEFAULT 0, created_by TEXT NOT NULL, annotation_attributes TEXT NOT NULL, created_on BIGINT NOT NULL, PRIMARY KEY(annotation_id, created_by) )I]7indexsqlite_autoindex_annotation_attributes_1annotation_attributes++qtableannotation_linkannotation_linkCREATE TABLE annotation_link ( annotation_id BIGINT NOT NULL DEFAULT 0, diagnostics_id TEXT NOT NULL, cohort_id BIGINT NOT NULL, database_id TEXT NOT NULL, PRIMARY KEY(annotation_id, diagnostics_id, cohort_id, database_id) )=Q+indexsqlite_autoindex_annotation_link_1annotation_link !!_tableannotationannotationCREATE TABLE annotation ( annotation_id BIGINT NOT NULL, created_by TEXT NOT NULL, created_on BIGINT NOT NULL, modified_last_on BIGINT, deleted_on BIGINT, annotation TEXT NOT NULL, PRIMARY KEY(annotation_id) )3G!indexsqlite_autoindex_annotation_1annotation :!X)3e^  :I*!/tabledomaindomain$CREATE TABLE domain ( domain_id TEXT NOT NULL, domain_name TEXT NOT NULL, domain_concept_id BIGINT NOT NULL, PRIMARY KEY(domain_id) )/ Cindexsqlite_autoindex_database_1database#{Itabledatabasedatabase"CREATE TABLE database ( database_id TEXT NOT NULL, database_name TEXT, description TEXT, is_meta_analysis TEXT NOT NULL, vocabulary_version TEXT, vocabulary_version_cdm TEXT, PRIMARY KEY(database_id) )++5tableconcept_synonymconcept_synonym CREATE TABLE concept_synonym ( concept_id BIGINT NOT NULL, concept_synonym_name TEXT NOT NULL, language_concept_id BIGINT NOT NULL, PRIMARY KEY(concept_id, concept_synonym_name, language_concept_id) )%%stableconcept_setsconcept_setsCREATE TABLE concept_sets ( cohort_id BIGINT NOT NULL, concept_set_id INT NOT NULL, concept_set_sql TEXT NOT NULL, concept_set_name TEXT NOT NULL, concept_set_expression TEXT NOT NULL, PRIMARY KEY(cohort_id, concept_set_id) )/--tableconcept_ancestorconcept_ancestorCREATE TABLE concept_ancestor ( ancestor_concept_id BIGINT NOT NULL, descendant_concept_id BIGINT NOT NULL, min_levels_of_separation INT NOT NULL, max_levels_of_separation INT NOT NULL, PRIMARY KEY(ancestor_concept_id, descendant_concept_id) )?S-indexsqlite_autoindex_concept_ancestor_1concept_ancestorWtableconceptconceptCREATE TABLE concept ( concept_id BIGINT NOT NULL, concept_name TEXT NOT NULL, domain_id TEXT NOT NULL, vocabulary_id TEXT NOT NULL, concept_class_id TEXT NOT NULL, standard_concept TEXT, concept_code TEXT NOT NULL, valid_start_date DATE NOT NULL, valid_end_date DATE NOT NULL, invalid_reason TEXT, PRIMARY KEY(concept_id) )-Aindexsqlite_autoindex_concept_1conceptG[5indexsqlite_autoindex_cohort_relationships_1cohort_relationships~55tablecohort_relationshipscohort_relationshipsCREATE TABLE cohort_relationships ( database_id TEXT NOT NULL, cohort_id BIGINT NOT NULL, comparator_cohort_id BIGINT NOT NULL, start_day BIGINT NOT NULL, end_day BIGINT NOT NULL, subjects BIGINT NOT NULL, sub_cs_before_ts BIGINT NOT NULL, rec_cs_before_ts BIGINT NOT NULL, sub_cs_on_ts BIGINT NOT NULL, rec_cs_on_ts BIGINT NOT NULL, sub_cs_after_ts BIGINT NOT NULL, rec_cs_after_ts BIGINT NOT NULL, sub_cs_before_te BIGINT NOT NULL, rec_cs_before_te BIGINT NOT NULL, sub_cs_on_te BIGINT NOT NULL, rec_cs_on_te BIGINT NOT NULL, sub_cs_after_te BIGINT NOT NULL, rec_cs_after_te BIGINT NOT NULL, sub_cs_window_t BIGINT NOT NULL, rec_cs_window_t BIGINT NOT NULL, sub_ce_window_t BIGINT NOT NULL, rec_ce_window_t BIGINT NOT NULL, sub_cs_window_ts BIGINT NOT NULL, rec_cs_window_ts BIGINT NOT NULL, sub_cs_window_te BIGINT NOT NULL, rec_cs_window_te BIGINT NOT NULL, sub_ce_window_ts BIGINT NOT NULL, rec_ce_window_ts BIGINT NOT NULL, sub_ce_window_te BIGINT NOT NULL, rec_ce_window_te BIGINT NOT NULL, sub_c_within_t BIGINT NOT NULL, rec_c_within_t BIGINT NOT NULL, c_days_before_ts BIGINT NOT NULL, c_days_before_te BIGINT NOT NULL, c_days_within_t_days BIGINT NOT NULL, c_days_after_ts BIGINT NOT NULL, c_days_after_te BIGINT NOT NULL, t_days BIGINT NOT NULL, c_days BIGINT NOT NULL, PRIMARY KEY(database_id, cohort_id, comparator_cohort_id, start_day, end_day) )?=Q+indexsqlite_autoindex_concept_synonym_1concept_synonym!7K%indexsqlite_autoindex_concept_sets_1concept_sets;O)indexsqlite_autoindex_cohort_overlap_1cohort_overlapG[5indexsqlite_autoindex_concept_relationship_1concept_relationshipV55Otableconcept_relationshipconcept_relationshipCREATE TABLE concept_relationship ( concept_id_1 BIGINT NOT NULL, concept_id_2 BIGINT NOT NULL, relationship_id TEXT NOT NULL, valid_start_date DATE NOT NULL, valid_end_date DATE NOT NULL, invalid_reason TEXT, PRIMARY KEY(concept_id_1, concept_id_2, relationship_id) )      ai15SELECT 0 as codeset_id, c.concept_id FROM (select distinct I.concept_id FROM ( select concept_id from @vocabulary_database_schema.CONCEPT where concept_id in (35609191) UNION select c.concept_id from @vocabulary_database_schema.CONCEPT c join @vocabulary_database_schema.CONCEPT_ANCESTOR ca on c.concept_id = ca.descendant_concept_id and ca.ancestor_concept_id in (35609191) and c.invalid_reason is null ) I ) CHomeless Condition[ { "concept": { "CONCEPT_ID": 35609191, "CONCEPT_NAME": "Place of occurrence of injury is hostel for the homeless", "STANDARD_CONCEPT": "S", "STANDARD_CONCEPT_CAPTION": "Standard", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "CONCEPT_CODE": "1079661000000106", "DOMAIN_ID": "Condition", "VOCABULARY_ID": "SNOMED", "CONCEPT_CLASS_ID": "Clinical Finding" }, "isExcluded": false, "includeDescendants": true, "includeMapped": false } ]i15SELECT 0 as codeset_id, c.concept_id FROM (select distinct I.concept_id FROM ( select concept_id from @vocabulary_database_schema.CONCEPT where concept_id in (35609191) UNION select c.concept_id from @vocabulary_database_schema.CONCEPT c join @vocabulary_database_schema.CONCEPT_ANCESTOR ca on c.concept_id = ca.descendant_concept_id and ca.ancestor_concept_id in (35609191) and c.invalid_reason is null ) I ) CHomeless Condition[ { "concept": { "CONCEPT_ID": 35609191, "CONCEPT_NAME": "Place of occurrence of injury is hostel for the homeless", "STANDARD_CONCEPT": "S", "STANDARD_CONCEPT_CAPTION": "Standard", "INVALID_REASON": "V", "INVALID_REASON_CAPTION": "Valid", "CONCEPT_CODE": "1079661000000106", "DOMAIN_ID": "Condition", "VOCABULARY_ID": "SNOMED", "CONCEPT_CLASS_ID": "Clinical Finding" }, "isExcluded": false, "includeDescendants": true[ X WPON            )###covid_ohdsicovid_ohdsicovid_ohdsi0 # covid_ohdsi     n/ E p % < ~x`nBO6c=indexsqlite_autoindex_temporY5==Etabletemporal_covariate_valuetemporal_covariate_value9CREATE TABLE temporal_covariate_value ( cohort_id BIGINT NOT NULL, time_id INT NOT NULL, covariate_id BIGINT NOT NULL, sum_value REAL NOT NULL, mean REAL NOT NULL, sd REAL, database_id TEXT NOT NULL, PRIMARY KEY(cohort_id, time_id, covariate_id, database_id) )K4_9indexsqlite_autoindex_temporal_covariate_ref_1temporal_covariate_ref8{399tabletemporal_covariate_reftemporal_covariate_ref7CREATE TABLE temporal_covariate_ref ( covariate_id BIGINT NOT NULL, covariate_name TEXT NOT NULL, analysis_id INT NOT NULL, concept_id BIGINT NOT NULL, PRIMARY KEY(covariate_id) )I2]7indexsqlite_autoindex_temporal_analysis_ref_1temporal_analysis_ref6177Itabletemporal_analysis_reftemporal_analysis_ref5CREATE TABLE temporal_analysis_ref ( analysis_id INT NOT NULL, analysis_name TEXT NOT NULL, domain_id TEXT NOT NULL, is_binary TEXT NOT NULL, missing_means_zero TEXT, PRIMARY KEY(analysis_id, domain_id) )A0U/indexsqlite_autoindex_resolved_concepts_1resolved_concepts4///Mtableresolved_conceptsresolved_concepts3CREATE TABLE resolved_concepts ( cohort_id BIGINT NOT NULL, concept_set_id INT NOT NULL, concept_id BIGINT NOT NULL, database_id TEXT NOT NULL, PRIMARY KEY(cohort_id, concept_set_id, concept_id, database_id) )7.K%indexsqlite_autoindex_relationship_1relationship2u-%%-tablerelationshiprelationship1CREATE TABLE relationship ( relationship_id TEXT NOT NULL, relationship_name TEXT NOT NULL, is_hierarchical TEXT NOT NULL, defines_ancestry TEXT NOT NULL, reverse_relationship_id TEXT NOT NULL, relationship_concept_id BIGINT NOT NULL, PRIMARY KEY(relationship_id, reverse_relationship_id, relationship_concept_id) );,O)indexsqlite_autoindex_orphan_concept_1orphan_concept0M+))Utableorphan_conceptorphan_concept/CREATE TABLE orphan_concept ( cohort_id BIGINT NOT NULL, concept_set_id INT NOT NULL, database_id TEXT NOT NULL, concept_id BIGINT NOT NULL, concept_count BIGINT NOT NULL, concept_subjects BIGINT NOT NULL, PRIMARY KEY(cohort_id, concept_set_id, database_id, concept_id) )/*Cindexsqlite_autoindex_metadata_1metadata.f)tablemetadatametadata-CREATE TABLE metadata ( database_id TEXT NOT NULL, start_time TEXT DEFAULT '0:0:0', variable_field TEXT NOT NULL, value_field TEXT, PRIMARY KEY(database_id, start_time, variable_field) )I(]7indexsqlite_autoindex_index_event_breakdown_1index_event_breakdown, '771tableindex_event_breakdownindex_event_breakdown+CREATE TABLE index_event_breakdown ( concept_id BIGINT NOT NULL, concept_count BIGINT NOT NULL, subject_count BIGINT NOT NULL, cohort_id BIGINT NOT NULL, database_id TEXT NOT NULL, domain_field TEXT NOT NULL, domain_table TEXT NOT NULL, PRIMARY KEY(concept_id, cohort_id, database_id, domain_field, domain_table) )G&[5indexsqlite_autoindex_inclusion_rule_stats_1inclusion_rule_stats*%55Stableinclusion_rule_statsinclusion_rule_stats)CREATE TABLE inclusion_rule_stats ( rule_sequence_id INT NOT NULL, rule_name TEXT NOT NULL, meet_subjects BIGINT NOT NULL, gain_subjects BIGINT NOT NULL, total_subjects BIGINT NOT NULL, remain_subjects BIGINT NOT NULL, cohort_id BIGINT NOT NULL, database_id TEXT NOT NULL, PRIMARY KEY(rule_sequence_id, cohort_id, database_id) )M$a;indexsqlite_autoindex_included_source_concept_1included_source_concept'!#;;Ytableincluded_source_conceptincluded_source_concept&CREATE TABLE included_source_concept ( database_id TEXT NOT NULL, cohort_id BIGINT NOT NULL, concept_set_id INT NOT NULL, concept_id BIGINT NOT NULL, source_concept_id BIGINT NOT NULL, concept_subjects BIGINT NOT NULL, concept_count BIGINT NOT NULL, PRIMARY KEY(database_id, cohort_id, concept_set_id, concept_id, source_concept_id) )+"?indexsqlite_autoindex_domain_1domain%     "s4 9 t 4 ~ 6 S p"L#G9covid_ohdsiTM_2023-08-11 19:43:41.044424personDaysInDatasource439169084G#G3covid_ohdsiTM_2023-08-11 19:43:41.044424recordsInDatasource1964683G#G3covid_ohdsiTM_2023-08-11 19:43:41.044424personsInDatasource1964683O#G=!covid_ohdsiTM_2023-08-11 19:43:41.044424observationPeriodMaxDate2023-04-28O#G=!covid_ohdsiTM_2023-08-11 19:43:41.044424observationPeriodMinDate2020-01-01A#G5covid_ohdsiTM_2023-08-11 19:43:41.044424vocabularyVersionCdmM#G7#covid_ohdsiTM_2023-08-11 19:43:41.044424datasourceDescriptioncovid_ohdsiF#G)#covid_ohdsiTM_2023-08-11 19:43:41.044424datasourceNamecovid_ohdsi>#G/covid_ohdsiTM_2023-08-11 19:43:41.044424vocabularyVersion; #G)covid_ohdsiTM_2023-08-11 19:43:41.044424cdmReleaseDate7 #G!covid_ohdsiTM_2023-08-11 19:43:41.044424cdmVersion> #G/covid_ohdsiTM_2023-08-11 19:43:41.044424sourceReleaseDate: #G'covid_ohdsiTM_2023-08-11 19:43:41.044424cdmSourceName> #G/covid_ohdsiTM_2023-08-11 19:43:41.044424sourceDescriptionG#G7covid_ohdsiTM_2023-08-11 19:43:41.044424currentPackageVersion3.2.3L#G)/covid_ohdsiTM_2023-08-11 19:43:41.044424currentPackageCohortDiagnosticsV#GOcovid_ohdsiTM_2023-08-11 19:43:41.044424rversionR version 4.3.1 (2023-06-16 ucrt)#GUqcovid_ohdsiTM_2023-08-11 19:43:41.044424argumentsAtDiagnosticsInitiationJson{ "runInclusionStatistics" : true, "runIncludedSourceConcepts" : true, "runOrphanConcepts" : true, "runTimeSeries" : false, "runVisitContext" : true, "runBreakdownIndexEvents" : true, "runIncidenceRate" : true, "runTemporalCohortCharacterization" : true, "minCellCount" : 5, "minCharacterizationMean" : 0.010000000000000000208167, "incremental" : false, "temporalCovariateSettings" : [ "getDefaultCovariateSettings" ] }L#GGcovid_ohdsiTM_2023-08-11 19:43:41.044424packageDependencySnapShotJson{}=#G%covid_ohdsiTM_2023-08-11 19:43:41.044424runTimeUnitsminsD#G-covid_ohdsiTM_2023-08-11 19:43:41.044424runTime6.47331796487172E#G-covid_ohdsiTM_2023-08-11 19:43:41.044424timeZoneAmerica/New_York  up4z6 k  V n . uB#G5covid_ohdsiTM_2023-08-11 19:43:41.044424vocabularyVersionCdm?#G/covid_ohdsiTM_2023-08-11 19:43:41.044424vocabularyVersion5#G covid_ohdsiTM_2023-08-11 19:43:41.044424timeZone?#G/covid_ohdsiTM_2023-08-11 19:43:41.044424sourceReleaseDate ?#G/covid_ohdsiTM_2023-08-11 19:43:41.044424sourceDescription 6#Gcovid_ohdsiTM_2023-08-11 19:43:41.044424rversion:#G%covid_ohdsiTM_2023-08-11 19:43:41.044424runTimeUnits5#Gcovid_ohdsiTM_2023-08-11 19:43:41.044424runTimeA#G3covid_ohdsiTM_2023-08-11 19:43:41.044424recordsInDatasourceA#G3covid_ohdsiTM_2023-08-11 19:43:41.044424personsInDatasourceD#G9covid_ohdsiTM_2023-08-11 19:43:41.044424personDaysInDatasourceK#GGcovid_ohdsiTM_2023-08-11 19:43:41.044424packageDependencySnapShotJsonF#G=covid_ohdsiTM_2023-08-11 19:43:41.044424observationPeriodMinDateF#G=covid_ohdsiTM_2023-08-11 19:43:41.044424observationPeriodMaxDate<#G)covid_ohdsiTM_2023-08-11 19:43:41.044424datasourceNameC#G7covid_ohdsiTM_2023-08-11 19:43:41.044424datasourceDescriptionC#G7covid_ohdsiTM_2023-08-11 19:43:41.044424currentPackageVersion<#G)covid_ohdsiTM_2023-08-11 19:43:41.044424currentPackage8#G!covid_ohdsiTM_2023-08-11 19:43:41.044424cdmVersion ;#G'covid_ohdsiTM_2023-08-11 19:43:41.044424cdmSourceName <#G)covid_ohdsiTM_2023-08-11 19:43:41.044424cdmReleaseDate R#GUcovid_ohdsiTM_2023-08-11 19:43:41.044424argumentsAtDiagnosticsInitiationJson               Z;b{M;+   a>!! tablevocabularyvocabularyCCREATE TABLE vocabulary ( vocabulary_id TEXT NOT NULL, vocabulary_name TEXT NOT NULL, vocabulary_reference TEXT, vocabulary_version TEXT, vocabulary_concept_id BIGINT NOT NULL )+<''tablevisit_contextvisit_contextACREATE TABLE visit_context ( cohort_id BIGINT NOT NULL, visit_concept_id BIGINT NOT NULL, visit_context TEXT NOT NULL, subjects BIGINT NOT NULL, database_id TEXT NOT NULL, PRIMARY KEY(cohort_id, visit_concept_id, visit_context, database_id) )9=M'indexsqlite_autoindex_visit_context_1visit_contextB1;##)tabletime_seriestime_series@CREATE TABLE time_series ( cohort_id BIGINT NOT NULL, database_id TEXT NOT NULL, period_begin DATE NOT NULL, period_end DATE NOT NULL, calendar_interval TEXT NOT NULL, gender TEXT, age_group TEXT, series_type TEXT NOT NULL, records BIGINT NOT NULL, subjects BIGINT NOT NULL, person_days BIGINT NOT NULL, person_days_in BIGINT NOT NULL, records_start BIGINT, subjects_start BIGINT, subjects_start_in BIGINT, records_end BIGINT, subjects_end BIGINT, subjects_end_in BIGINT )<9//'tabletemporal_time_reftemporal_time_ref>CREATE TABLE temporal_time_ref ( time_id INT NOT NULL, start_day BIGINT NOT NULL, end_day BIGINT NOT NULL, PRIMARY KEY(time_id) )A:U/indexsqlite_autoindex_temporal_time_ref_1temporal_time_ref?>7GG{tabletemporal_covariate_value_disttemporal_covariate_value_dist;CREATE TABLE temporal_covariate_value_dist ( cohort_id BIGINT NOT NULL, time_id INT NOT NULL, covariate_id BIGINT NOT NULL, count_value REAL NOT NULL, min_value REAL NOT NULL, max_value REAL NOT NULL, mean REAL NOT NULL, sd REAL NOT NULL, median_value REAL NOT NULL, p_10_value REAL NOT NULL, p_25_value REAL NOT NULL, p_75_value REAL NOT NULL, p_90_value REAL NOT NULL, database_id TEXT NOT NULL, PRIMARY KEY(cohort_id, time_id, covariate_id, database_id) )Y8mGindexsqlite_autoindex_temporal_covariate_value_dist_1temporal_covariate_value_dist<O6c=indexsqlite_autoindex_temporal_covariate_value_1temporal_covariate_value:==Etabletemporal_covariate_valuetemporal_covariate_value9CREATE TABLE temporal_covariate_value ( cohort_id BIGINT NOT NULL, time_id INT NOT NULL, covariate_id BIGINT NOT NULL, sum_value REAL NOT NULL, mean REAL NOT NULL, sd REAL, database_id TEXT NOT NULL, PRIMARY KEY(cohort_id, time_id, covariate_id, database_id) )K4_9indexsqlite_autoindex_temporal_covariate_ref_1temporal_covariate_ref8{399tabletemporal_covariate_reftemporal_covariate_ref7CREATE TABLE temporal_covariate_ref ( covariate_id BG tablecohortcohortLCREATE TABLE cohort ( cohort_id BIGINT NOT NULL, cohort_name TEXT NOT NULL, metadata TEXT, sql TEXT NOT NULL, json TEXT NOT NULL, subset_definition_id BIGINT, subset_parent BIGINT, is_subset INT, PRIMARY KEY(cohort_id) )+H?indexsqlite_autoindex_cohort_1cohortM'E//}tablesubset_definitionsubset_definitionJCREATE TABLE subset_definition ( subset_definition_id BIGINT, json TEXT, PRIMARY KEY(subset_definition_id) )AFU/indexsqlite_autoindex_subset_definition_1subset_definitionK#D))tableincidence_rateincidence_rateICREATE TABLE incidence_rate ( cohort_count BIGINT NOT NULL, person_years NUMERIC, gender TEXT, age_group TEXT, calendar_year TEXT, incidence_rate NUMERIC NOT NULL, cohort_id BIGINT NOT NULL, database_id TEXT NOT NULL )oB++tablepackage_versionpackage_versionGCREATE TABLE package_version ( version_number TEXT PRIMARY KEY )=CQ+indexsqlite_autoindex_package_version_1package_versionH= OP.observation_period_start_date and E.start_date <= op.observation_period_end_date WHERE DATEADD(day,0,OP.OBSERVATION_PERIOD_START_DATE) <= E.START_DATE AND DATEADD(day,0,E.START_DATE) <= OP.OBSERVATION_PERIOD_END_DATE ) P WHERE P.ordinal = 1 -- End Primary Events ) pe JOIN ( -- Begin Criteria Group select 0 as index_id, person_id, event_id FROM ( select E.person_id, E.event_id FROM (-- Begin Primary Events select P.ordinal as event_id, P.person_id, P.start_date, P.end_date, op_start_date, op_end_date, cast(P.visit_occurrence_id as bigint) as visit_occurrence_id FROM ( select E.person_id, E.start_date, E.end_date, row_number() OVER (PARTITION BY E.person_id ORDER BY E.sort_date ASC, E.event_id) ordinal, OP.observation_period_start_date as op_start_date, OP.observation_period_end_date as op_end_date, cast(E.visit_occurrence_id as bigint) as visit_occurrence_id FROM ( -- Begin Visit Occurrence Criteria select C.person_id, C.visit_occurrence_id as event_id, C.visit_start_date as start_date, C.visit_end_date as end_date, C.visit_occurrence_id, C.visit_start_date as sort_date from ( select vo.* FROM @cdm_database_schema.VISIT_OCCURRENCE vo ) C -- End Visit Occurrence Criteria ) E JOIN @cdm_database_schema.observation_period OP on E.person_id = OP.person_id and E.start_date >= OP.observation_period_start_date and E.start_date <= op.observation_period_end_date WHERE DATEADD(day,0,OP.OBSERVATION_PERIOD_START_DATE) <= E.START_DATE AND DATEADD(day,0,E.START_DATE) <= OP.OBSERVATION_PERIOD_END_DATE ) P WHERE P.ordinal = 1 -- End Primary Events ) E INNER JOIN ( -- Begin Correlated Criteria select 0 as index_id, cc.person_id, cc.event_id from (SELECT p.person_id, p.event_id FROM (-- Begin Primary Events select P.ordinal as event_id, P.person_id, P.start_date, P.end_date, op_start_date, op_end_date, cast(P.visit_occurrence_id as bigint) as visit_occurrence_id FROM ( select E.person_id, E.start_date, E.end_date, row_number() OVER (PARTITION BY E.person_id ORDER BY E.sort_date ASC, E.event_id) ordinal, OP.observation_period_start_date as op_start_date, OP.observation_period_end_date as op_end_date, cast(E.visit_occurrence_id as bigint) as visit_occurrence_id FROM ( -- Begin Visit Occurrence Criteria select C.person_id, C.visit_occurrence_id as event_id, C.visit_start_date as start_date, C.visit_end_date as end_date, C.visit_occurrence_id, C.visit_start_date as sort_date from ( select vo.* FROM @cdm_database_schema.VISIT_OCCURRENCE vo ) C -- End Visit Occurrence Criteria ) E JOIN @cdm_database_schema.observation_period OP on E.person_id = OP.person_id and E.start_date >= OP.observation_period_start_date and E.start_date <= op.observation_period_end_date WHERE DATEADD(day,0,OP.OBSERVATION_PERIOD_START_DATE) <= E.START_DATE AND DATEADD(day,0,E.START_DATE) <= OP.OBSERVATION_PERIOD_END_DATE ) P WHERE P.ordinal = 1 -- End Primary Events ) P JOIN ( -- Begin Visit Occurrence Criteria select C.person_id, C.visit_occurrence_id as event_id, C.visit_start_date as start_date, C.visit_end_date as end_date, C.visit_occurrence_id, C.visit_start_date as sort_date from ( select vo.* FROM @cdm_database_schema.VISIT_OCCURRENCE vo ) C WHERE C.visit_start_date >= DATEFROMPARTS(2020, 1, 1) -- End Visit Occurrence Criteria ) A on A.person_id = P.person_id AND A.START_DATE >= P.OP_START_DATE AND A.START_DATE <= P.OP_END_DATE AND A.START_DATE >= P.OP_START_DATE AND A.START_DATE <= P.OP_END_DATE ) cc GROUP BY cc.person_id, cc.event_id HAVING COUNT(cc.event_id) >= 1 -- End Correlated Criteria ) CQ on E.person_id = CQ.person_id and E.event_id = CQ.event_id GROUP BY E.person_id, E.event_id HAVING COUNT(index_id) = 1 ) G -- End Criteria Group ) AC on AC.person_id = pe.person_id and AC.event_id = pe.event_id ) QEj WHERE QE.ordinal = 1 ; --- Inclusion Rule Inserts select 0 as inclusion_rule_id, person_id, event_id INTO #Inclusion_0 FROM ( select pe.person_id, pe.event_id FROM #qualified_events pe JOIN ( -- Begin Criteria Group select 0 as index_id, person_id, event_id FROM ( select E.person_id, E.event_id FROM #qualified_events E INNER JOIN ( -- Begin Correlated Criteria select 0 as index_id, cc.person_id, cc.event_id from (SELECT p.person_id, p.event_id FROM #qualified_events P JOIN ( -- Begin Visit Occurrence Criteria select C.person_id, C.visit_occurrence_id as event_id, C.visit_start_date as start_date, C.visit_end_date as end_date, C.visit_occurrence_id, C.visit_start_date as sort_date from ( select vo.* FROM @cdm_database_schema.VISIT_OCCURRENCE vo ) C -- End Visit Occurrence Criteria ) A on A.person_id = P.person_id AND A.START_DATE >= DATEADD(day,0,P.START_DATE) AND A.START_DATE <= DATEADD(day,180,P.START_DATE) ) cc GROUP BY cc.person_id, cc.event_id HAVING COUNT(cc.event_id) >= 1 -- End Correlated Criteria ) CQ on E.person_id = CQ.person_id and E.event_id = CQ.event_id GROUP BY E.person_id, E.event_id HAVING COUNT(index_id) = 1 ) G -- End Criteria Group ) AC on AC.person_id = pe.person_id AND AC.event_id = pe.event_id ) Results ; select 1 as inclusion_rule_id, person_id, event_id INTO #Inclusion_1 FROM ( select pe.person_id, pe.event_id FROM #qualified_events pe JOIN ( -- Begin Criteria Group select 0 as index_id, person_id, event_id FROM ( select E.person_id, E.event_id FROM #qualified_events E INNER JOIN ( -- Begin Correlated Criteria select 0 as index_id, cc.person_id, cc.event_id from (SELECT p.person_id, p.event_id FROM #qualified_events P JOIN ( -- Begin Condition Occurrence Criteria SELECT C.person_id, C.condition_occurrence_id as event_id, C.condition_start_date as start_date, COALESCE(C.condition_end_date, DATEADD(day,1,C.condition_start_date)) as end_date, C.visit_occurrence_id, C.condition_start_date as sort_date FROM ( SELECT co.* FROM @cdm_database_schema.CONDITION_OCCURRENCE co JOIN #Codesets cs on (co.condition_concept_id = cs.concept_id and cs.codeset_id = 5) ) C -- End Condition Occurrence Criteria ) A on A.person_id = P.person_id AND A.START_DATE >= DATEADD(day,0,P.START_DATE) AND A.START_DATE <= DATEADD(day,180,P.START_DATE) ) cc GROUP BY cc.person_id, cc.event_id HAVING COUNT(cc.event_id) >= 1 -- End Correlated Criteria UNION ALL -- Begin Correlated Criteria select 1 as index_id, cc.person_id, cc.event_id from (SELECT p.person_id, p.event_id FROM #qualified_events P JOIN ( -- Begin Measurement Criteria select C.person_id, C.measurement_id as event_id, C.measurement_date as start_date, DATEADD(d,1,C.measurement_date) as END_DATE, C.visit_occurrence_id, C.measurement_date as sort_date from ( select m.* FROM @cdm_database_schema.MEASUREMENT m JOIN #Codesets cs on (m.measurement_concept_id = cs.concept_id and cs.codeset_id = 5) ) C -- End Measurement Criteria ) A on A.person_id = P.person_id AND A.START_DATE >= DATEADD(day,0,P.START_DATE) AND A.START_DATE <= DATEADD(day,180,P.START_DATE) ) cc GROUP BY cc.person_id, cc.event_id HAVING COUNT(cc.event_id) >= 1 -- End Correlated Criteria UNION ALL -- Begin Correlated Criteria select 2 as index_id, cc.person_id, cc.event_id from (SELECT p.person_id, p.event_id FROM #qualified_events P JOIN ( -- Begin Observation Criteria select C.person_id, C.observation_id as event_id, C.observation_date as start_date, DATEADD(d,1,C.observation_date) as END_DATE, C.visit_occurrence_id, C.observation_date as sort_date from ( select o.* FROM @cdm_database_schema.OBSERVATION o JOIN #Codesets cs on (o.observation_concept_id = cs.concept_id and cs.codeset_id = 5) ) C -- End Observation Criteria ) A on A.person_id = P.person_id AND A.START_DATE >= DATEADD(day,0,P.START_DATE) AND A.START_DATE <= DATEADD(day,180,P.START_DATkE) ) cc GROUP BY cc.person_id, cc.event_id HAVING COUNT(cc.event_id) >= 1 -- End Correlated Criteria UNION ALL -- Begin Correlated Criteria select 3 as index_id, cc.person_id, cc.event_id from (SELECT p.person_id, p.event_id FROM #qualified_events P JOIN ( -- Begin Procedure Occurrence Criteria select C.person_id, C.procedure_occurrence_id as event_id, C.procedure_date as start_date, DATEADD(d,1,C.procedure_date) as END_DATE, C.visit_occurrence_id, C.procedure_date as sort_date from ( select po.* FROM @cdm_database_schema.PROCEDURE_OCCURRENCE po JOIN #Codesets cs on (po.procedure_concept_id = cs.concept_id and cs.codeset_id = 5) ) C -- End Procedure Occurrence Criteria ) A on A.person_id = P.person_id AND A.START_DATE >= DATEADD(day,0,P.START_DATE) AND A.START_DATE <= DATEADD(day,180,P.START_DATE) ) cc GROUP BY cc.person_id, cc.event_id HAVING COUNT(cc.event_id) >= 1 -- End Correlated Criteria UNION ALL -- Begin Correlated Criteria select 4 as index_id, cc.person_id, cc.event_id from (SELECT p.person_id, p.event_id FROM #qualified_events P JOIN ( -- Begin Visit Occurrence Criteria select C.person_id, C.visit_occurrence_id as event_id, C.visit_start_date as start_date, C.visit_end_date as end_date, C.visit_occurrence_id, C.visit_start_date as sort_date from ( select vo.* FROM @cdm_database_schema.VISIT_OCCURRENCE vo JOIN #Codesets cs on (vo.visit_concept_id = cs.concept_id and cs.codeset_id = 5) ) C -- End Visit Occurrence Criteria ) A on A.person_id = P.person_id AND A.START_DATE >= DATEADD(day,0,P.START_DATE) AND A.START_DATE <= DATEADD(day,180,P.START_DATE) ) cc GROUP BY cc.person_id, cc.event_id HAVING COUNT(cc.event_id) >= 1 -- End Correlated Criteria ) CQ on E.person_id = CQ.person_id and E.event_id = CQ.event_id GROUP BY E.person_id, E.event_id HAVING COUNT(index_id) > 0 ) G -- End Criteria Group ) AC on AC.person_id = pe.person_id AND AC.event_id = pe.event_id ) Results ; select 2 as inclusion_rule_id, person_id, event_id INTO #Inclusion_2 FROM ( select pe.person_id, pe.event_id FROM #qualified_events pe JOIN ( -- Begin Criteria Group select 0 as index_id, person_id, event_id FROM ( select E.person_id, E.event_id FROM #qualified_events E INNER JOIN ( -- Begin Correlated Criteria select 0 as index_id, p.person_id, p.event_id from #qualified_events p LEFT JOIN ( SELECT p.person_id, p.event_id FROM #qualified_events P JOIN ( -- Begin Condition Occurrence Criteria SELECT C.person_id, C.condition_occurrence_id as event_id, C.condition_start_date as start_date, COALESCE(C.condition_end_date, DATEADD(day,1,C.condition_start_date)) as end_date, C.visit_occurrence_id, C.condition_start_date as sort_date FROM ( SELECT co.* FROM @cdm_database_schema.CONDITION_OCCURRENCE co JOIN #Codesets cs on (co.condition_concept_id = cs.concept_id and cs.codeset_id = 6) ) C -- End Condition Occurrence Criteria ) A on A.person_id = P.person_id AND A.START_DATE >= DATEADD(day,0,P.START_DATE) AND A.START_DATE <= DATEADD(day,180,P.START_DATE) ) cc on p.person_id = cc.person_id and p.event_id = cc.event_id GROUP BY p.person_id, p.event_id HAVING COUNT(cc.event_id) = 0 -- End Correlated Criteria UNION ALL -- Begin Correlated Criteria select 1 as index_id, p.person_id, p.event_id from #qualified_events p LEFT JOIN ( SELECT p.person_id, p.event_id FROM #qualified_events P JOIN ( -- Begin Measurement Criteria select C.person_id, C.measurement_id as event_id, C.measurement_date as start_date, DATEADD(d,1,C.measurement_date) as END_DATE, C.visit_occurrence_id, C.measurement_date as sort_date from ( select m.* FROM @cdm_database_schema.MEASUREMENT m JOIN #Codesets cs on (m.measurement_concept_id = cs.concept_id and cs.codeset_id = 6) ) C -- End Measurement Criteria ) A on A.person_id = P.person_id AND A.START_DATE >= DATEADD(day,0,P.START_DATE) AND A.START_DATE <= DATEADD(day,180,P.START_DATE) ) cc on p.person_id = cc.persoln_id and p.event_id = cc.event_id GROUP BY p.person_id, p.event_id HAVING COUNT(cc.event_id) = 0 -- End Correlated Criteria UNION ALL -- Begin Correlated Criteria select 2 as index_id, p.person_id, p.event_id from #qualified_events p LEFT JOIN ( SELECT p.person_id, p.event_id FROM #qualified_events P JOIN ( -- Begin Observation Criteria select C.person_id, C.observation_id as event_id, C.observation_date as start_date, DATEADD(d,1,C.observation_date) as END_DATE, C.visit_occurrence_id, C.observation_date as sort_date from ( select o.* FROM @cdm_database_schema.OBSERVATION o JOIN #Codesets cs on (o.observation_concept_id = cs.concept_id and cs.codeset_id = 6) ) C -- End Observation Criteria ) A on A.person_id = P.person_id AND A.START_DATE >= DATEADD(day,0,P.START_DATE) AND A.START_DATE <= DATEADD(day,180,P.START_DATE) ) cc on p.person_id = cc.person_id and p.event_id = cc.event_id GROUP BY p.person_id, p.event_id HAVING COUNT(cc.event_id) = 0 -- End Correlated Criteria UNION ALL -- Begin Correlated Criteria select 3 as index_id, p.person_id, p.event_id from #qualified_events p LEFT JOIN ( SELECT p.person_id, p.event_id FROM #qualified_events P JOIN ( -- Begin Procedure Occurrence Criteria select C.person_id, C.procedure_occurrence_id as event_id, C.procedure_date as start_date, DATEADD(d,1,C.procedure_date) as END_DATE, C.visit_occurrence_id, C.procedure_date as sort_date from ( select po.* FROM @cdm_database_schema.PROCEDURE_OCCURRENCE po JOIN #Codesets cs on (po.procedure_concept_id = cs.concept_id and cs.codeset_id = 6) ) C -- End Procedure Occurrence Criteria ) A on A.person_id = P.person_id AND A.START_DATE >= DATEADD(day,0,P.START_DATE) AND A.START_DATE <= DATEADD(day,180,P.START_DATE) ) cc on p.person_id = cc.person_id and p.event_id = cc.event_id GROUP BY p.person_id, p.event_id HAVING COUNT(cc.event_id) = 0 -- End Correlated Criteria UNION ALL -- Begin Correlated Criteria select 4 as index_id, p.person_id, p.event_id from #qualified_events p LEFT JOIN ( SELECT p.person_id, p.event_id FROM #qualified_events P JOIN ( -- Begin Visit Occurrence Criteria select C.person_id, C.visit_occurrence_id as event_id, C.visit_start_date as start_date, C.visit_end_date as end_date, C.visit_occurrence_id, C.visit_start_date as sort_date from ( select vo.* FROM @cdm_database_schema.VISIT_OCCURRENCE vo JOIN #Codesets cs on (vo.visit_concept_id = cs.concept_id and cs.codeset_id = 6) ) C -- End Visit Occurrence Criteria ) A on A.person_id = P.person_id AND A.START_DATE >= DATEADD(day,0,P.START_DATE) AND A.START_DATE <= DATEADD(day,180,P.START_DATE) ) cc on p.person_id = cc.person_id and p.event_id = cc.event_id GROUP BY p.person_id, p.event_id HAVING COUNT(cc.event_id) = 0 -- End Correlated Criteria ) CQ on E.person_id = CQ.person_id and E.event_id = CQ.event_id GROUP BY E.person_id, E.event_id HAVING COUNT(index_id) = 5 ) G -- End Criteria Group ) AC on AC.person_id = pe.person_id AND AC.event_id = pe.event_id ) Results ; SELECT inclusion_rule_id, person_id, event_id INTO #inclusion_events FROM (select inclusion_rule_id, person_id, event_id from #Inclusion_0 UNION ALL select inclusion_rule_id, person_id, event_id from #Inclusion_1 UNION ALL select inclusion_rule_id, person_id, event_id from #Inclusion_2) I; TRUNCATE TABLE #Inclusion_0; DROP TABLE #Inclusion_0; TRUNCATE TABLE #Inclusion_1; DROP TABLE #Inclusion_1; TRUNCATE TABLE #Inclusion_2; DROP TABLE #Inclusion_2; select event_id, person_id, start_date, end_date, op_start_date, op_end_date into #included_events FROM ( SELECT event_id, person_id, start_date, end_date, op_start_date, op_end_date, row_number() over (partition by person_id order by start_date ASC) as ordinal from ( select Q.event_id, Q.person_id, Q.start_date, Q.end_date, Q.op_start_date, Q.op_end_date, SUM(coalesce(POWER(cast(2 as bigint), I.inclusion_rule_id), 0)) as inclusion_rule_mask from #qualified_events Q LEFT JOIN #inclmusion_events I on I.person_id = Q.person_id and I.event_id = Q.event_id GROUP BY Q.event_id, Q.person_id, Q.start_date, Q.end_date, Q.op_start_date, Q.op_end_date ) MG -- matching groups -- the matching group with all bits set ( POWER(2,# of inclusion rules) - 1 = inclusion_rule_mask WHERE (MG.inclusion_rule_mask = POWER(cast(2 as bigint),3)-1) ) Results WHERE Results.ordinal = 1 ; -- date offset strategy select event_id, person_id, case when DATEADD(day,180,start_date) > op_end_date then op_end_date else DATEADD(day,180,start_date) end as end_date INTO #strategy_ends from #included_events; -- generate cohort periods into #final_cohort select person_id, start_date, end_date INTO #cohort_rows from ( -- first_ends select F.person_id, F.start_date, F.end_date FROM ( select I.event_id, I.person_id, I.start_date, CE.end_date, row_number() over (partition by I.person_id, I.event_id order by CE.end_date) as ordinal from #included_events I join ( -- cohort_ends -- cohort exit dates -- End Date Strategy SELECT event_id, person_id, end_date from #strategy_ends ) CE on I.event_id = CE.event_id and I.person_id = CE.person_id and CE.end_date >= I.start_date ) F WHERE F.ordinal = 1 ) FE; select person_id, min(start_date) as start_date, end_date into #final_cohort from ( --cteEnds SELECT c.person_id , c.start_date , MIN(ed.end_date) AS end_date FROM #cohort_rows c JOIN ( -- cteEndDates SELECT person_id , DATEADD(day,-1 * 0, event_date) as end_date FROM ( SELECT person_id , event_date , event_type , SUM(event_type) OVER (PARTITION BY person_id ORDER BY event_date, event_type ROWS UNBOUNDED PRECEDING) AS interval_status FROM ( SELECT person_id , start_date AS event_date , -1 AS event_type FROM #cohort_rows UNION ALL SELECT person_id , DATEADD(day,0,end_date) as end_date , 1 AS event_type FROM #cohort_rows ) RAWDATA ) e WHERE interval_status = 0 ) ed ON c.person_id = ed.person_id AND ed.end_date >= c.start_date GROUP BY c.person_id, c.start_date ) e group by person_id, end_date ; DELETE FROM @target_database_schema.@target_cohort_table where cohort_definition_id = @target_cohort_id; INSERT INTO @target_database_schema.@target_cohort_table (cohort_definition_id, subject_id, cohort_start_date, cohort_end_date) select @target_cohort_id as cohort_definition_id, person_id, start_date, end_date FROM #final_cohort CO ; -- BEGIN: Censored Stats delete from @results_database_schema.cohort_censor_stats where cohort_definition_id = @target_cohort_id; -- END: Censored Stats -- Create a temp table of inclusion rule rows for joining in the inclusion rule impact analysis select cast(rule_sequence as int) as rule_sequence into #inclusion_rules from ( SELECT CAST(0 as int) as rule_sequence UNION ALL SELECT CAST(1 as int) as rule_sequence UNION ALL SELECT CAST(2 as int) as rule_sequence ) IR; -- Find the event that is the 'best match' per person. -- the 'best match' is defined as the event that satisfies the most inclusion rules. -- ties are solved by choosing the event that matches the earliest inclusion rule, and then earliest. select q.person_id, q.event_id into #best_events from #qualified_events Q join ( SELECT R.person_id, R.event_id, ROW_NUMBER() OVER (PARTITION BY R.person_id ORDER BY R.rule_count DESC,R.min_rule_id ASC, R.start_date ASC) AS rank_value FROM ( SELECT Q.person_id, Q.event_id, COALESCE(COUNT(DISTINCT I.inclusion_rule_id), 0) AS rule_count, COALESCE(MIN(I.inclusion_rule_id), 0) AS min_rule_id, Q.start_date FROM #qualified_events Q LEFT JOIN #inclusion_events I ON q.person_id = i.person_id AND q.event_id = i.event_id GROUP BY Q.person_id, Q.event_id, Q.start_date ) R ) ranked on Q.person_id = ranked.person_id and Q.event_id = ranked.event_id WHERE rannked.rank_value = 1 ; -- modes of generation: (the same tables store the results for the different modes, identified by the mode_id column) -- 0: all events -- 1: best event -- BEGIN: Inclusion Impact Analysis - event -- calculte matching group counts delete from @results_database_schema.cohort_inclusion_result where cohort_definition_id = @target_cohort_id and mode_id = 0; insert into @results_database_schema.cohort_inclusion_result (cohort_definition_id, inclusion_rule_mask, person_count, mode_id) select @target_cohort_id as cohort_definition_id, inclusion_rule_mask, count_big(*) as person_count, 0 as mode_id from ( select Q.person_id, Q.event_id, CAST(SUM(coalesce(POWER(cast(2 as bigint), I.inclusion_rule_id), 0)) AS bigint) as inclusion_rule_mask from #qualified_events Q LEFT JOIN #inclusion_events I on q.person_id = i.person_id and q.event_id = i.event_id GROUP BY Q.person_id, Q.event_id ) MG -- matching groups group by inclusion_rule_mask ; -- calculate gain counts delete from @results_database_schema.cohort_inclusion_stats where cohort_definition_id = @target_cohort_id and mode_id = 0; insert into @results_database_schema.cohort_inclusion_stats (cohort_definition_id, rule_sequence, person_count, gain_count, person_total, mode_id) select @target_cohort_id as cohort_definition_id, ir.rule_sequence, coalesce(T.person_count, 0) as person_count, coalesce(SR.person_count, 0) gain_count, EventTotal.total, 0 as mode_id from #inclusion_rules ir left join ( select i.inclusion_rule_id, count_big(i.event_id) as person_count from #qualified_events Q JOIN #inclusion_events i on Q.person_id = I.person_id and Q.event_id = i.event_id group by i.inclusion_rule_id ) T on ir.rule_sequence = T.inclusion_rule_id CROSS JOIN (select count(*) as total_rules from #inclusion_rules) RuleTotal CROSS JOIN (select count_big(event_id) as total from #qualified_events) EventTotal LEFT JOIN @results_database_schema.cohort_inclusion_result SR on SR.mode_id = 0 AND SR.cohort_definition_id = @target_cohort_id AND (POWER(cast(2 as bigint),RuleTotal.total_rules) - POWER(cast(2 as bigint),ir.rule_sequence) - 1) = SR.inclusion_rule_mask -- POWER(2,rule count) - POWER(2,rule sequence) - 1 is the mask for 'all except this rule' ; -- calculate totals delete from @results_database_schema.cohort_summary_stats where cohort_definition_id = @target_cohort_id and mode_id = 0; insert into @results_database_schema.cohort_summary_stats (cohort_definition_id, base_count, final_count, mode_id) select @target_cohort_id as cohort_definition_id, PC.total as person_count, coalesce(FC.total, 0) as final_count, 0 as mode_id FROM (select count_big(event_id) as total from #qualified_events) PC, (select sum(sr.person_count) as total from @results_database_schema.cohort_inclusion_result sr CROSS JOIN (select count(*) as total_rules from #inclusion_rules) RuleTotal where sr.mode_id = 0 and sr.cohort_definition_id = @target_cohort_id and sr.inclusion_rule_mask = POWER(cast(2 as bigint),RuleTotal.total_rules)-1 ) FC ; -- END: Inclusion Impact Analysis - event -- BEGIN: Inclusion Impact Analysis - person -- calculte matching group counts delete from @results_database_schema.cohort_inclusion_result where cohort_definition_id = @target_cohort_id and mode_id = 1; insert into @results_database_schema.cohort_inclusion_result (cohort_definition_id, inclusion_rule_mask, person_count, mode_id) select @target_cohort_id as cohort_definition_id, inclusion_rule_mask, count_big(*) as person_count, 1 as mode_id from ( select Q.person_id, Q.event_id, CAST(SUM(coalesce(POWER(cast(2 as bigint), I.inclusion_rule_id), 0)) AS bigint) as inclusion_rule_mask from #best_events Q LEFT JOIN #inclusion_events I on q.person_id = i.person_id and q.event_id = i.event_id GROUP BY Q.person_id, Q.event_id ) MG -- matching groups group by inclusion_rule_mask ; -- calculate gain counts delete from @results_database_schema.cohort_inclusion_stats where cohort_definition_id = @target_cohort_id and mode_id =o 1; insert into @results_database_schema.cohort_inclusion_stats (cohort_definition_id, rule_sequence, person_count, gain_count, person_total, mode_id) select @target_cohort_id as cohort_definition_id, ir.rule_sequence, coalesce(T.person_count, 0) as person_count, coalesce(SR.person_count, 0) gain_count, EventTotal.total, 1 as mode_id from #inclusion_rules ir left join ( select i.inclusion_rule_id, count_big(i.event_id) as person_count from #best_events Q JOIN #inclusion_events i on Q.person_id = I.person_id and Q.event_id = i.event_id group by i.inclusion_rule_id ) T on ir.rule_sequence = T.inclusion_rule_id CROSS JOIN (select count(*) as total_rules from #inclusion_rules) RuleTotal CROSS JOIN (select count_big(event_id) as total from #best_events) EventTotal LEFT JOIN @results_database_schema.cohort_inclusion_result SR on SR.mode_id = 1 AND SR.cohort_definition_id = @target_cohort_id AND (POWER(cast(2 as bigint),RuleTotal.total_rules) - POWER(cast(2 as bigint),ir.rule_sequence) - 1) = SR.inclusion_rule_mask -- POWER(2,rule count) - POWER(2,rule sequence) - 1 is the mask for 'all except this rule' ; -- calculate totals delete from @results_database_schema.cohort_summary_stats where cohort_definition_id = @target_cohort_id and mode_id = 1; insert into @results_database_schema.cohort_summary_stats (cohort_definition_id, base_count, final_count, mode_id) select @target_cohort_id as cohort_definition_id, PC.total as person_count, coalesce(FC.total, 0) as final_count, 1 as mode_id FROM (select count_big(event_id) as total from #best_events) PC, (select sum(sr.person_count) as total from @results_database_schema.cohort_inclusion_result sr CROSS JOIN (select count(*) as total_rules from #inclusion_rules) RuleTotal where sr.mode_id = 1 and sr.cohort_definition_id = @target_cohort_id and sr.inclusion_rule_mask = POWER(cast(2 as bigint),RuleTotal.total_rules)-1 ) FC ; -- END: Inclusion Impact Analysis - person TRUNCATE TABLE #best_events; DROP TABLE #best_events; TRUNCATE TABLE #inclusion_rules; DROP TABLE #inclusion_rules; TRUNCATE TABLE #strategy_ends; DROP TABLE #strategy_ends; TRUNCATE TABLE #cohort_rows; DROP TABLE #cohort_rows; TRUNCATE TABLE #final_cohort; DROP TABLE #final_cohort; TRUNCATE TABLE #inclusion_events; DROP TABLE #inclusion_events; TRUNCATE TABLE #qualified_events; DROP TABLE #qualified_events; TRUNCATE TABLE #included_events; DROP TABLE #included_events; TRUNCATE TABLE #Codesets; DROP TABLE #Codesets; { "cdmVersionRange" : ">=5.0.0", "PrimaryCriteria" : { "CriteriaList" : [ { "VisitOccurrence" : { "VisitTypeExclude" : false } } ], "ObservationWindow" : { "PriorDays" : 0, "PostDays" : 0 }, "PrimaryCriteriaLimit" : { "Type" : "First" } }, "AdditionalCriteria" : { "Type" : "ALL", "CriteriaList" : [ { "Criteria" : { "VisitOccurrence" : { "OccurrenceStartDate" : { "Value" : "2020-01-01", "Op" : "gte" }, "VisitTypeExclude" : false } }, "StartWindow" : { "Start" : { "Coeff" : -1 }, "End" : { "Coeff" : 1 }, "UseIndexEnd" : false, "UseEventEnd" : false }, "RestrictVisit" : false, "IgnoreObservationPeriod" : false, "Occurrence" : { "Type" : 2, "Count" : 1, "IsDistinct" : false } } ], "DemographicCriteriaList" : [], "Groups" : [] }, "ConceptSets" : [ { "id" : 0, "name" : "Homeless Condition", "expression" : { "items" : [ { "concept" : { "CONCEPT_ID" : 35609191, "CONCEPT_NAME" : "Place of occurrence of injury is hostel for the homeless", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "1079661000000106", "DOMAIN_ID" : "Condition", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Clinical Finding" }, "isExcluded" : false, "includeDescendantps" : true, "includeMapped" : false } ] } }, { "id" : 1, "name" : "Homeless Measurement", "expression" : { "items" : [ { "concept" : { "CONCEPT_ID" : 21498856, "CONCEPT_NAME" : "Homeless", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "LA20561-9", "DOMAIN_ID" : "Meas Value", "VOCABULARY_ID" : "LOINC", "CONCEPT_CLASS_ID" : "Answer" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 36309593, "CONCEPT_NAME" : "I'm homeless or threatened with eviction", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "LA29213-8", "DOMAIN_ID" : "Meas Value", "VOCABULARY_ID" : "LOINC", "CONCEPT_CLASS_ID" : "Answer" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 36310234, "CONCEPT_NAME" : "Patient is homeless", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "LA18835-1", "DOMAIN_ID" : "Meas Value", "VOCABULARY_ID" : "LOINC", "CONCEPT_CLASS_ID" : "Answer" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 37079289, "CONCEPT_NAME" : "I do not have housing (staying with others, in a hotel, in a shelter, living outside on the street, on a beach, in a car, or in a park)", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "LA30190-5", "DOMAIN_ID" : "Meas Value", "VOCABULARY_ID" : "LOINC", "CONCEPT_CLASS_ID" : "Answer" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 36310431, "CONCEPT_NAME" : "I'm in transitional, temporary or substandard housing; and/or current rent/mortgage is unaffordable (over 30% of income)", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "LA29212-0", "DOMAIN_ID" : "Meas Value", "VOCABULARY_ID" : "LOINC", "CONCEPT_CLASS_ID" : "Answer" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false } ] } }, { "id" : 2, "name" : "Homeless Observation", "expression" : { "items" : [ { "concept" : { "CONCEPT_ID" : 44810601, "CONCEPT_NAME" : "Discharge from homeless advocacy service", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "898811000000106", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Procedure" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 4271762, "CONCEPT_NAME" : "Feature of homelessness", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "364701009", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Observable Entity" }, "isExcluded" : false, "includeDescendants" : true, q "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 4139934, "CONCEPT_NAME" : "Homeless", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "32911000", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Clinical Finding" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 44788302, "CONCEPT_NAME" : "Homeless enhanced service completed", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "166461000000103", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Clinical Finding" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 44788283, "CONCEPT_NAME" : "Homeless enhanced services administration", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "166301000000107", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Clinical Finding" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 4019973, "CONCEPT_NAME" : "Homeless family", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "105526001", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Clinical Finding" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 4190815, "CONCEPT_NAME" : "Homeless mental health care", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "390818002", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Procedure" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 4307308, "CONCEPT_NAME" : "Homeless mental health care - 3-5 contacts/week", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "391195008", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Procedure" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 4192297, "CONCEPT_NAME" : "Homeless mental health care - Daily intensive", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "391194007", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Procedure" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 4307307, "CONCEPT_NAME" : "Homeless mental health care - Full day : day care", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCrEPT_CODE" : "391191004", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Procedure" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 4193277, "CONCEPT_NAME" : "Homeless mental health care - Part day : day care", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "391192006", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Procedure" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 4052051, "CONCEPT_NAME" : "Homeless single person", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "160700001", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Clinical Finding" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 4076506, "CONCEPT_NAME" : "Hostel for the homeless", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "224675009", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Clinical Finding" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 35610659, "CONCEPT_NAME" : "Provision of community outreach care for homeless", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "1095491000000105", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Procedure" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 35610286, "CONCEPT_NAME" : "Referral to homeless advocacy service", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "1091381000000101", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Procedure" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 42690497, "CONCEPT_NAME" : "Referred by homeless drop-in centre", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "1077211000000104", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Clinical Finding" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 45765559, "CONCEPT_NAME" : "Under care of homeless advocacy service", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "702526004", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Clinical Finding" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID"s : 4137393, "CONCEPT_NAME" : "Discharge to sheltered housing", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "306697004", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Procedure" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 4144274, "CONCEPT_NAME" : "Housing lack", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "266935003", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Clinical Finding" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 4053088, "CONCEPT_NAME" : "Lives in sheltered housing", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "160729004", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Clinical Finding" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 44790997, "CONCEPT_NAME" : "Living in temporary housing", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "247521000000104", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Clinical Finding" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 4091004, "CONCEPT_NAME" : "On housing list", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "185956004", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Clinical Finding" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 4090385, "CONCEPT_NAME" : "On urgent housing list", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "185955000", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Clinical Finding" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 44806052, "CONCEPT_NAME" : "Referral by housing service", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "790331000000107", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Procedure" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 44793821, "CONCEPT_NAME" : "Referral to housing department", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "38921000000104", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Procedure" }, t "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 46272532, "CONCEPT_NAME" : "Referral to housing service", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "710911006", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Procedure" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 3656380, "CONCEPT_NAME" : "Transitional housing", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "25911000087103", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Location" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 4022661, "CONCEPT_NAME" : "Housing problem", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "105531004", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Clinical Finding" }, "isExcluded" : false, "includeDescendants" : false, "includeMapped" : false } ] } }, { "id" : 3, "name" : "Homeless Procedure", "expression" : { "items" : [ { "concept" : { "CONCEPT_ID" : 37208401, "CONCEPT_NAME" : "Signposting to homeless support service", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "1104581000000103", "DOMAIN_ID" : "Procedure", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Procedure" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 35609555, "CONCEPT_NAME" : "Signposting to housing support service", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "1083301000000108", "DOMAIN_ID" : "Procedure", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Procedure" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false } ] } }, { "id" : 4, "name" : "Homeless Visit", "expression" : { "items" : [ { "concept" : { "CONCEPT_ID" : 8672, "CONCEPT_NAME" : "Homeless Shelter", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "04", "DOMAIN_ID" : "Visit", "VOCABULARY_ID" : "CMS Place of Service", "CONCEPT_CLASS_ID" : "Visit" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false } ] } }, { "id" : 5, "name" : "Not Homeless - 2023-07-12 (ALL CONCEPTS)", "expression" : { "items" : [ { "concept" : { "CONCEPT_ID" : 45877171, "CONCEPT_NAME" : "Detached single-family housing", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "LA15229-0", "DOMAIN_ID" : "Meas Value", "VOCABULARY_ID" : "LOINC", "CONCEPT_CLASS_ID" : "Answer" }, "isExcluded" : false, "includeDescendants" : true, "includeMuapped" : false }, { "concept" : { "CONCEPT_ID" : 4059641, "CONCEPT_NAME" : "House rented from housing association", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "160939001", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Clinical Finding" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 4052321, "CONCEPT_NAME" : "Housing adequate", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "161036002", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Clinical Finding" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 44804220, "CONCEPT_NAME" : "Housing standard", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "724751000000102", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Qualifier Value" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 37079501, "CONCEPT_NAME" : "I have housing", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "LA30189-7", "DOMAIN_ID" : "Meas Value", "VOCABULARY_ID" : "LOINC", "CONCEPT_CLASS_ID" : "Answer" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 36311105, "CONCEPT_NAME" : "I'm in stable housing that is safe but only marginally adequate", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "LA29211-2", "DOMAIN_ID" : "Meas Value", "VOCABULARY_ID" : "LOINC", "CONCEPT_CLASS_ID" : "Answer" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 4046991, "CONCEPT_NAME" : "Independent housing, lives alone", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "135852002", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Observable Entity" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 36308356, "CONCEPT_NAME" : "My household is in safe, adequate subsidized housing", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "LA29210-4", "DOMAIN_ID" : "Meas Value", "VOCABULARY_ID" : "LOINC", "CONCEPT_CLASS_ID" : "Answer" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 36308730, "CONCEPT_NAME" : "My household is safe, adequate, unsubsidized housing", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "LA29v209-6", "DOMAIN_ID" : "Meas Value", "VOCABULARY_ID" : "LOINC", "CONCEPT_CLASS_ID" : "Answer" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 40329714, "CONCEPT_NAME" : "(House in poor repair) or (slum housing)", "STANDARD_CONCEPT" : "N", "STANDARD_CONCEPT_CAPTION" : "Non-Standard", "INVALID_REASON" : "U", "INVALID_REASON_CAPTION" : "Invalid", "CONCEPT_CODE" : "160714001", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Location" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 40299805, "CONCEPT_NAME" : "House rented from housing association", "STANDARD_CONCEPT" : "N", "STANDARD_CONCEPT_CAPTION" : "Non-Standard", "INVALID_REASON" : "U", "INVALID_REASON_CAPTION" : "Invalid", "CONCEPT_CODE" : "138257000", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Clinical Finding" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 40300329, "CONCEPT_NAME" : "Housing adequate", "STANDARD_CONCEPT" : "N", "STANDARD_CONCEPT_CAPTION" : "Non-Standard", "INVALID_REASON" : "U", "INVALID_REASON_CAPTION" : "Invalid", "CONCEPT_CODE" : "138354009", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Qualifier Value" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 36309786, "CONCEPT_NAME" : "I'm Safe - I rarely have acute or chronic symptoms affecting housing, employment, social interactions, etc.", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "LA29242-7", "DOMAIN_ID" : "Meas Value", "VOCABULARY_ID" : "LOINC", "CONCEPT_CLASS_ID" : "Answer" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 40545298, "CONCEPT_NAME" : "Independent housing, lives alone", "STANDARD_CONCEPT" : "N", "STANDARD_CONCEPT_CAPTION" : "Non-Standard", "INVALID_REASON" : "U", "INVALID_REASON_CAPTION" : "Invalid", "CONCEPT_CODE" : "366833008", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Location" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 40299223, "CONCEPT_NAME" : "Independent housing, not alone", "STANDARD_CONCEPT" : "N", "STANDARD_CONCEPT_CAPTION" : "Non-Standard", "INVALID_REASON" : "U", "INVALID_REASON_CAPTION" : "Invalid", "CONCEPT_CODE" : "138109000", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Clinical Finding" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 4052157, "CONCEPT_NAME" : "Independent housing, not alone", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "160724009", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Clinical Finding" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { w "CONCEPT_ID" : 46285980, "CONCEPT_NAME" : "Lives in Extra Care housing", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "979501000000100", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Clinical Finding" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 3561367, "CONCEPT_NAME" : "Lives in extra care housing", "STANDARD_CONCEPT" : "N", "STANDARD_CONCEPT_CAPTION" : "Non-Standard", "INVALID_REASON" : "U", "INVALID_REASON_CAPTION" : "Invalid", "CONCEPT_CODE" : "979511000000103", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Clinical Finding" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 44802044, "CONCEPT_NAME" : "Lives in housing association rented accommodation", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "491761000000102", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Clinical Finding" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 4019978, "CONCEPT_NAME" : "Living in housing with technical defects", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "105537000", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Clinical Finding" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 4019977, "CONCEPT_NAME" : "Living in housing without electricity", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "105536009", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Clinical Finding" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 4207170, "CONCEPT_NAME" : "Slum housing", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "309683008", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Clinical Finding" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 2618142, "CONCEPT_NAME" : "Supported housing, per diem", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "H0043", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "HCPCS", "CONCEPT_CLASS_ID" : "HCPCS" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 2618143, "CONCEPT_NAME" : "Supported housing, per month", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "H0044", "DOMAIN_ID" : "Observation", "VOxCABULARY_ID" : "HCPCS", "CONCEPT_CLASS_ID" : "HCPCS" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false } ] } }, { "id" : 6, "name" : "Homeless - 2023-07-12 (ALL CONCEPTS)", "expression" : { "items" : [ { "concept" : { "CONCEPT_ID" : 4053088, "CONCEPT_NAME" : "Lives in sheltered housing", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "160729004", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Clinical Finding" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 4147554, "CONCEPT_NAME" : "Sheltered housing", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "310207003", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Clinical Finding" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 40519180, "CONCEPT_NAME" : "[V]Lack of housing", "STANDARD_CONCEPT" : "N", "STANDARD_CONCEPT_CAPTION" : "Non-Standard", "INVALID_REASON" : "D", "INVALID_REASON_CAPTION" : "Invalid", "CONCEPT_CODE" : "316362003", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Context-dependent" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 44794577, "CONCEPT_NAME" : "[V]Lack of housing", "STANDARD_CONCEPT" : "N", "STANDARD_CONCEPT_CAPTION" : "Non-Standard", "INVALID_REASON" : "U", "INVALID_REASON_CAPTION" : "Invalid", "CONCEPT_CODE" : "398341000000102", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Context-dependent" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 40519187, "CONCEPT_NAME" : "[V]Sheltered housing", "STANDARD_CONCEPT" : "N", "STANDARD_CONCEPT_CAPTION" : "Non-Standard", "INVALID_REASON" : "D", "INVALID_REASON_CAPTION" : "Invalid", "CONCEPT_CODE" : "316369007", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Context-dependent" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 44812921, "CONCEPT_NAME" : "[V]Sheltered housing", "STANDARD_CONCEPT" : "N", "STANDARD_CONCEPT_CAPTION" : "Non-Standard", "INVALID_REASON" : "U", "INVALID_REASON_CAPTION" : "Invalid", "CONCEPT_CODE" : "431521000000106", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Context-dependent" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 40329696, "CONCEPT_NAME" : "(Housing lack) or (homeless)", "STANDARD_CONCEPT" : "N", "STANDARD_CONCEPT_CAPTION" : "Non-Standard", "INVALID_REASON" : "U", "INVALID_REASON_CAPTION" : "Invalid", "CONCEPT_CODE" : "160699002", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Clinical Finding" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 21498856, y "CONCEPT_NAME" : "Homeless", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "LA20561-9", "DOMAIN_ID" : "Meas Value", "VOCABULARY_ID" : "LOINC", "CONCEPT_CLASS_ID" : "Answer" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 4139934, "CONCEPT_NAME" : "Homeless", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "32911000", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Clinical Finding" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 40299198, "CONCEPT_NAME" : "Homeless", "STANDARD_CONCEPT" : "N", "STANDARD_CONCEPT_CAPTION" : "Non-Standard", "INVALID_REASON" : "U", "INVALID_REASON_CAPTION" : "Invalid", "CONCEPT_CODE" : "138087002", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Clinical Finding" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 3552499, "CONCEPT_NAME" : "Homeless - enhanced service completed", "STANDARD_CONCEPT" : "N", "STANDARD_CONCEPT_CAPTION" : "Non-Standard", "INVALID_REASON" : "U", "INVALID_REASON_CAPTION" : "Invalid", "CONCEPT_CODE" : "165571000000100", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Clinical Finding" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 3552820, "CONCEPT_NAME" : "Homeless - enhanced service completed", "STANDARD_CONCEPT" : "N", "STANDARD_CONCEPT_CAPTION" : "Non-Standard", "INVALID_REASON" : "U", "INVALID_REASON_CAPTION" : "Invalid", "CONCEPT_CODE" : "171301000000107", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Clinical Finding" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 3552819, "CONCEPT_NAME" : "Homeless - enhanced services administration", "STANDARD_CONCEPT" : "N", "STANDARD_CONCEPT_CAPTION" : "Non-Standard", "INVALID_REASON" : "U", "INVALID_REASON_CAPTION" : "Invalid", "CONCEPT_CODE" : "171291000000108", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Clinical Finding" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 3553101, "CONCEPT_NAME" : "Homeless - enhanced services administration", "STANDARD_CONCEPT" : "N", "STANDARD_CONCEPT_CAPTION" : "Non-Standard", "INVALID_REASON" : "U", "INVALID_REASON_CAPTION" : "Invalid", "CONCEPT_CODE" : "175961000000109", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Clinical Finding" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 8672, "CONCEPT_NAME" : "Homeless Shelter", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "04", "DOMAIN_ID" : "Visit", "VOCABULARY_ID" : "CMS Place of Service", "CONCEPT_CLASS_zID" : "Visit" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 42628011, "CONCEPT_NAME" : "Homeless Shelter", "STANDARD_CONCEPT" : "N", "STANDARD_CONCEPT_CAPTION" : "Non-Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "1021866", "DOMAIN_ID" : "Visit", "VOCABULARY_ID" : "CPT4", "CONCEPT_CLASS_ID" : "Visit" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 44788302, "CONCEPT_NAME" : "Homeless enhanced service completed", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "166461000000103", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Clinical Finding" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 44788283, "CONCEPT_NAME" : "Homeless enhanced services administration", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "166301000000107", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Clinical Finding" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 4019973, "CONCEPT_NAME" : "Homeless family", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "105526001", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Clinical Finding" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 40299199, "CONCEPT_NAME" : "Homeless family", "STANDARD_CONCEPT" : "N", "STANDARD_CONCEPT_CAPTION" : "Non-Standard", "INVALID_REASON" : "U", "INVALID_REASON_CAPTION" : "Invalid", "CONCEPT_CODE" : "138088007", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Clinical Finding" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 4190815, "CONCEPT_NAME" : "Homeless mental health care", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "390818002", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Procedure" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 4307308, "CONCEPT_NAME" : "Homeless mental health care - 3-5 contacts/week", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "391195008", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Procedure" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 4192297, "CONCEPT_NAME" : "Homeless mental health care - Daily intensive", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "{V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "391194007", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Procedure" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 4307307, "CONCEPT_NAME" : "Homeless mental health care - Full day : day care", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "391191004", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Procedure" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 4193277, "CONCEPT_NAME" : "Homeless mental health care - Part day : day care", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "391192006", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Procedure" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 40299200, "CONCEPT_NAME" : "Homeless single person", "STANDARD_CONCEPT" : "N", "STANDARD_CONCEPT_CAPTION" : "Non-Standard", "INVALID_REASON" : "U", "INVALID_REASON_CAPTION" : "Invalid", "CONCEPT_CODE" : "138089004", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Clinical Finding" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 4052051, "CONCEPT_NAME" : "Homeless single person", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "160700001", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Clinical Finding" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 35225199, "CONCEPT_NAME" : "Homelessness", "STANDARD_CONCEPT" : "N", "STANDARD_CONCEPT_CAPTION" : "Non-Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "Z59.0", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "ICD10CM", "CONCEPT_CLASS_ID" : "4-char billing code" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 36309593, "CONCEPT_NAME" : "I'm homeless or threatened with eviction", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "LA29213-8", "DOMAIN_ID" : "Meas Value", "VOCABULARY_ID" : "LOINC", "CONCEPT_CLASS_ID" : "Answer" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 36310234, "CONCEPT_NAME" : "Patient is homeless", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "LA18835-1", "DOMAIN_ID" : "Meas Value", "VOCABULARY_ID" : "LOINC", "CONCEPT_CLASS_ID" : "Answer" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 3666234|9, "CONCEPT_NAME" : "Person does not have a permanent home or is homeless.", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "LA30928-8", "DOMAIN_ID" : "Meas Value", "VOCABULARY_ID" : "LOINC", "CONCEPT_CLASS_ID" : "Answer" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 35609191, "CONCEPT_NAME" : "Place of occurrence of injury is hostel for the homeless", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "1079661000000106", "DOMAIN_ID" : "Condition", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Clinical Finding" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 42690497, "CONCEPT_NAME" : "Referred by homeless drop-in centre", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "1077211000000104", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Clinical Finding" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 45765559, "CONCEPT_NAME" : "Under care of homeless advocacy service", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "702526004", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Clinical Finding" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 44810341, "CONCEPT_NAME" : "Under care of homeless advocacy service", "STANDARD_CONCEPT" : "N", "STANDARD_CONCEPT_CAPTION" : "Non-Standard", "INVALID_REASON" : "U", "INVALID_REASON_CAPTION" : "Invalid", "CONCEPT_CODE" : "887461000000108", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Clinical Finding" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 3560142, "CONCEPT_NAME" : "Under care of homeless advocacy service", "STANDARD_CONCEPT" : "N", "STANDARD_CONCEPT_CAPTION" : "Non-Standard", "INVALID_REASON" : "U", "INVALID_REASON_CAPTION" : "Invalid", "CONCEPT_CODE" : "887471000000101", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Clinical Finding" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 40329696, "CONCEPT_NAME" : "(Housing lack) or (homeless)", "STANDARD_CONCEPT" : "N", "STANDARD_CONCEPT_CAPTION" : "Non-Standard", "INVALID_REASON" : "U", "INVALID_REASON_CAPTION" : "Invalid", "CONCEPT_CODE" : "160699002", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Clinical Finding" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 3557438, "CONCEPT_NAME" : "Awaiting housing NOS", "STANDARD_CONCEPT" : "N", "STANDARD_CONCEPT_CAPTION" : "Non-Standard", "INVALID_REASON" : "D", "INVALID_REASON_CAPTION" : "Invalid", "CONCEP}T_CODE" : "553841000000107", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Clinical Finding" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 40318572, "CONCEPT_NAME" : "Awaiting housing NOS", "STANDARD_CONCEPT" : "N", "STANDARD_CONCEPT_CAPTION" : "Non-Standard", "INVALID_REASON" : "U", "INVALID_REASON_CAPTION" : "Invalid", "CONCEPT_CODE" : "154138002", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Clinical Finding" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 4091008, "CONCEPT_NAME" : "Awaiting housing NOS", "STANDARD_CONCEPT" : "N", "STANDARD_CONCEPT_CAPTION" : "Non-Standard", "INVALID_REASON" : "U", "INVALID_REASON_CAPTION" : "Invalid", "CONCEPT_CODE" : "185962009", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Clinical Finding" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 4137393, "CONCEPT_NAME" : "Discharge to sheltered housing", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "306697004", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Procedure" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 4144274, "CONCEPT_NAME" : "Housing lack", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "266935003", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Clinical Finding" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 3557354, "CONCEPT_NAME" : "Housing lack NOS", "STANDARD_CONCEPT" : "N", "STANDARD_CONCEPT_CAPTION" : "Non-Standard", "INVALID_REASON" : "D", "INVALID_REASON_CAPTION" : "Invalid", "CONCEPT_CODE" : "542821000000105", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Clinical Finding" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 40299203, "CONCEPT_NAME" : "Housing lack NOS", "STANDARD_CONCEPT" : "N", "STANDARD_CONCEPT_CAPTION" : "Non-Standard", "INVALID_REASON" : "U", "INVALID_REASON_CAPTION" : "Invalid", "CONCEPT_CODE" : "138091007", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Clinical Finding" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 4058157, "CONCEPT_NAME" : "Housing lack NOS", "STANDARD_CONCEPT" : "N", "STANDARD_CONCEPT_CAPTION" : "Non-Standard", "INVALID_REASON" : "U", "INVALID_REASON_CAPTION" : "Invalid", "CONCEPT_CODE" : "160704005", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Clinical Finding" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 37079289, "CONCEPT_NAME" : "I do not have housing (staying with others, in a~ hotel, in a shelter, living outside on the street, on a beach, in a car, or in a park)", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "LA30190-5", "DOMAIN_ID" : "Meas Value", "VOCABULARY_ID" : "LOINC", "CONCEPT_CLASS_ID" : "Answer" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 44831984, "CONCEPT_NAME" : "Lack of housing", "STANDARD_CONCEPT" : "N", "STANDARD_CONCEPT_CAPTION" : "Non-Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "V60.0", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "ICD9CM", "CONCEPT_CLASS_ID" : "4-dig billing V code" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false } ] } } ], "QualifiedLimit" : { "Type" : "First" }, "ExpressionLimit" : { "Type" : "First" }, "InclusionRules" : [ { "name" : "Visit 6 months after first visit", "description" : "Patient has at least one visit 6 months or more after their first visit after 2020-01-01", "expression" : { "Type" : "ALL", "CriteriaList" : [ { "Criteria" : { "VisitOccurrence" : { "VisitTypeExclude" : false } }, "StartWindow" : { "Start" : { "Days" : 0, "Coeff" : -1 }, "End" : { "Days" : 180, "Coeff" : 1 }, "UseIndexEnd" : false, "UseEventEnd" : false }, "RestrictVisit" : false, "IgnoreObservationPeriod" : true, "Occurrence" : { "Type" : 2, "Count" : 1, "IsDistinct" : false } } ], "DemographicCriteriaList" : [], "Groups" : [] } }, { "name" : "Not Homeless Indicators", "description" : "Patient has one of the indicators that identifys them as not homeless", "expression" : { "Type" : "ANY", "CriteriaList" : [ { "Criteria" : { "ConditionOccurrence" : { "CodesetId" : 5, "ConditionTypeExclude" : false } }, "StartWindow" : { "Start" : { "Days" : 0, "Coeff" : 1 }, "End" : { "Days" : 180, "Coeff" : 1 }, "UseIndexEnd" : false, "UseEventEnd" : false }, "RestrictVisit" : false, "IgnoreObservationPeriod" : true, "Occurrence" : { "Type" : 2, "Count" : 1, "IsDistinct" : false } }, { "Criteria" : { "Measurement" : { "CodesetId" : 5, "MeasurementTypeExclude" : false } }, "StartWindow" : { "Start" : { "Days" : 0, "Coeff" : 1 }, "End" : { "Days" : 180, "Coeff" : 1 }, "UseIndexEnd" : false, "UseEventEnd" : false }, "RestrictVisit" : false, "IgnoreObservationPeriod" : true, "Occurrence" : { "Type" : 2, "Count" : 1, "IsDistinct" : false } }, { "Criteria" : { "Observation" : { "CodesetId" : 5, "ObservationTypeExclude" : false } }, "StartWindow" : { "Start" : { "Days" : 0, "Coeff" : 1 }, "End" : { "Days" : 180, "Coeff" : 1 }, "UseIndexEnd" : false, "UseEventEnd" : false }, "RestrictVisit" : false, "IgnoreObservationPeriod" : true, "Occurrence" : { "Type" : 2, "Count" : 1, "IsDistinct" : false } }, { "Criteria" : { "ProcedureOccurrence" : { "CodesetId" : 5, "ProcedureTypeExclude" : false } }, "StartWindow" : { "Start" : { "Days" : 0, "Coeff" : 1 }, "End" : { "Days" : 180, "Coeff" : 1 }, "UseIndexEnd" : false, "UseEventEnd" : false }, "RestrictVisit" : false, "IgnoreObservationPeriod" : true, "Occurrence" : { "Type" : 2, "Count" : 1, "IsDistinct" : false } }, { "Criteria" : { "VisitOccurrence" : { "CodesetId" : 5, "VisitTypeExclude" : false } }, "StartWindow" : { "Start" : { "Days" : 0, "Coeff" : 1 }, "End" : { "Days" : 180, "Coeff" : 1 }, "UseIndexEnd" : false, "UseEventEnd" : false }, "RestrictVisit" : false, "IgnoreObservationPeriod" : true, "Occurrence" : { "Type" : 2, "Count" : 1, "IsDistinct" : false } } ], "DemographicCriteriaList" : [], "Groups" : [] } }, { "name" : "Exclude Homeless", "description" : "Patient has not had an indication of homelessness during the observation period.", "expression" : { "Type" : "ALL", "CriteriaList" : [ { "Criteria" : { "ConditionOccurrence" : { "CodesetId" : 6, "ConditionTypeExclude" : false } }, "StartWindow" : { "Start" : { "Days" : 0, "Coeff" : 1 }, "End" : { "Days" : 180, "Coeff" : 1 }, "UseIndexEnd" : false, "UseEventEnd" : false }, "RestrictVisit" : false, "IgnoreObservationPeriod" : true, "Occurrence" : { "Type" : 0, "Count" : 0, "IsDistinct" : false } }, { "Criteria" : { "Measurement" : { "CodesetId" : 6, "MeasurementTypeExclude" : false } }, "StartWindow" : { "Start" : { "Days" : 0, "Coeff" : 1 }, "End" : { "Days" : 180, "Coeff" : 1 }, "UseIndexEnd" : false, "UseEventEnd" : false }, "RestrictVisit" : false, "IgnoreObservationPeriod" : true, "Occurrence" : { "Type" : 0, "Count" : 0, "IsDistinct" : false } }, { "Criteria" : { "Observation" : { "CodesetId" : 6, "ObservationTypeExclude" : false } }, "StartWindow" : { "Start" : { "Days" : 0, "Coeff" : 1 }, "End" : { "Days" : 180, "Coeff" : 1 }, "UseIndexEnd" : false, "UseEventEnd" : false }, "RestrictVisit" : false, "IgnoreObservationPeriod" : true, "Occurrence" : { "Type" : 0, "Count" : 0, "IsDistinct" : false } }, { "Criteria" : { "ProcedureOccurrence" : { "CodesetId" : 6, "ProcedureTypeExclude" : false } }, "StartWindow" : { "Start" : { "Days" : 0, "Coeff" : 1 }, "End" : { "Days" : 180, "Coeff" : 1 }, "UseIndexEnd" : false, "UseEventEnd" : false }, "RestrictVisit" : false, "IgnoreObservationPeriod" : true, "Occurrence" : { "Type" : 0, "Count" : 0, "IsDistinct" : false } }, { "Criteria" : { "VisitOccurrence" : { "CodesetId" : 6, "VisitTypeExclude" : false } }, "StartWindow" : { "Start" : { "Days" : 0, "Coeff" : 1 }, "End" : { "Days" : 180, "Coeff" : 1 }, "UseIndexEnd" : false, "UseEventEnd" : false }, "RestrictVisit" : false, "IgnoreObservationPeriod" : true, "Occurrence" : { "Type" : 0, "Count" : 0, "IsDistinct" : false } } ], "DemographicCriteriaList" : [], "Groups" : [] } } ], "EndStrategy" : { "DateOffset" : { "DateField" : "StartDate", "Offset" : 180 } }, "CensoringCriteria" : [], "CollapseSettings" : { "CollapseType" : "ERA", "EraPad" : 0 }, "CensorWindow" : {} }= ca.descendant_concept_id and ca.ancestor_concept_id in (35609191) and c.invalid_reason is null ) I ) C UNION ALL SELECT 1 as codeset_id, c.concept_id FROM (select distinct I.concept_id FROM ( select concept_id from @vocabulary_database_schema.CONCEPT where concept_id in (21498856,36309593,36310234,37079289,36310431) UNION select c.concept_id from @vocabulary_database_schema.CONCEPT c join @vocabulary_database_schema.CONCEPT_ANCESTOR ca on c.concept_id = ca.descendant_concept_id and ca.ancestor_concept_id in (21498856,36309593,36310234,37079289,36310431) and c.invalid_reason is null ) I ) C UNION ALL SELECT 2 as codeset_id, c.concept_id FROM (select distinct I.concept_id FROM ( select concept_id from @vocabulary_database_schema.CONCEPT where concept_id in (44810601,4271762,4139934,44788302,44788283,4019973,4190815,4307308,4192297,4307307,4193277,4052051,4076506,35610659,35610286,42690497,45765559,4137393,4144274,4053088,44790997,4091004,4090385,44806052,44793821,46272532,3656380,4022661) UNION select c.concept_id from @vocabulary_database_schema.CONCEPT c join @vocabulary_database_schema.CONCEPT_ANCESTOR ca on c.concept_id = ca.descendant_concept_id and ca.ancestor_concept_id in (44810601,4271762,4139934,44788302,44788283,4019973,4190815,4307308,4192297,4307307,4193277,4052051,4076506,35610659,35610286,42690497,45765559,4137393,4144274,4053088,44790997,4091004,4090385,44806052,44793821,46272532,3656380) and c.invalid_reason is null ) I ) C UNION ALL SELECT 3 as codeset_id, c.concept_id FROM (select distinct I.concept_id FROM ( select concept_id from @vocabulary_database_schema.CONCEPT where concept_id in (37208401,35609555) UNION select c.concept_id from @vocabulary_database_schema.CONCEPT c join @vocabulary_database_schema.CONCEPT_ANCESTOR ca on c.concept_id = ca.descendant_concept_id and ca.ancestor_concept_id in (37208401,35609555) and c.invalid_reason is null ) I ) C UNION ALL SELECT 4 as codeset_id, c.concept_id FROM (select distinct I.concept_id FROM ( select concept_id from @vocabulary_database_schema.CONCEPT where concept_id in (8672) UNION select c.concept_id from @vocabulary_database_schema.CONCEPT c join @vocabulary_database_schema.CONCEPT_ANCESTOR ca on c.concept_id = ca.descendant_concept_id and ca.ancestor_concept_id in (8672) and c.invalid_reason is null ) I ) C UNION ALL SELECT 5 as codeset_id, c.concept_id FROM (select distinct I.concept_id FROM ( select concept_id from @vocabulary_database_schema.CONCEPT where concept_id in (4053088,4147554,40519180,44794577,40519187,44812921,40329696,21498856,4139934,40299198,3552499,3552820,3552819,3553101,8672,42628011,44788302,44788283,4019973,40299199,4190815,4307308,4192297,4307307,4193277,40299200,4052051,35225199,36309593,36310234,36662349,35609191,42690497,45765559,44810341,3560142,40329696,3557438,40318572,4091008,4137393,4144274,3557354,40299203,4058157,37079289,44831984) UNION select c.concept_id from @vocabulary_database_schema.CONCEPT c join @vocabulary_database_schema.CONCEPT_ANCESTOR ca on c.concept_id = ca.descendant_concept_id and ca.ancestor_concept_id in (4053088,4147554,40519180,44794577,40519187,44812921,40329696,21498856,4139934,40299198,3552499,3552820,3552819,3553101,8672,42628011,44788302,44788283,4019973,40299199,4190815,4307308,4192297,4307307,4193277,40299200,4052051,35225199,36309593,36310234,36662349,35609191,42690497,45765559,44810341,3560142,40329696,3557438,40318572,4091008,4137393,4144274,3557354,40299203,4058157,37079289,44831984) and c.invalid_reason is null ) I ) C ; SELECT event_id, person_id, start_date, end_date, op_start_date, op_end_date, visit_occurrence_id INTO #qualified_events FROM ( select pe.event_id, pe.person_id, pe.start_date, pe.end_date, pe.op_start_date, pe.op_end_date, row_number() over (partition by pe.person_id order by pe.start_date ASC) as ordinal, cast(pe.visit_occurrence_id as bigint) as visit_occurrence_id FROM (-- Begin Primary Events select P.ordinal as event_id, P.person_id, P.start_date, P.end_date, op_start_date, op_end_date, cast(P.visit_occurrence_id as bigint) as visit_occurrence_id FROM ( select E.person_id, E.start_date, E.end_date, row_number() OVER (PARTITION BY E.person_id ORDER BY E.sort_date ASC, E.event_id) ordinal, OP.observation_period_start_date as op_start_date, OP.observation_period_end_date as op_end_date, cast(E.visit_occurrence_id as bigint) as visit_occurrence_id FROM ( -- Begin Visit Occurrence Criteria select C.person_id, C.visit_occurrence_id as event_id, C.visit_start_date as start_date, C.visit_end_date as end_date, C.visit_occurrence_id, C.visit_start_date as sort_date from ( select vo.* FROM @cdm_database_schema.VISIT_OCCURRENCE vo ) C -- End Visit Occurrence Criteria ) E JOIN @cdm_database_schema.observation_period OP on E.person_id = OP.person_id and E.start_date >= OP.observation_period_start_date and E.start_date <= op.observation_period_end_date WHERE DATEADD(day,0,OP.OBSERVATION_PERIOD_START_DATE) <= E.START_DATE AND DATEADD(day,0,E.START_DATE) <= OP.OBSERVATION_PERIOD_END_DATE ) P WHERE P.ordinal = 1 -- End Primary Events ) pe JOIN ( -- Begin Criteria Group select 0 as index_id, person_id, event_id FROM ( select E.person_id, E.event_id FROM (-- Begin Primary Events select P.ordinal as event_id, P.person_id, P.start_date, P.end_date, op_start_date, op_end_date, cast(P.visit_occurrence_id as bigint) as visit_occurrence_id FROM ( select E.person_id, E.start_date, E.end_date, row_number() OVER (PARTITION BY E.person_id ORDER BY E.sort_date ASC, E.event_id) ordinal, OP.observation_period_start_date as op_start_date, OP.observation_period_end_date as op_end_date, cast(E.visit_occurrence_id as bigint) as visit_occurrence_id FROM ( -- Begin Visit Occurrence Criteria select C.person_id, C.visit_occurrence_id as event_id, C.visit_start_date as start_date, C.visit_end_date as end_date, C.visit_occurrence_id, C.visit_start_date as sort_date from ( select vo.* FROM @cdm_database_schema.VISIT_OCCURRENCE vo ) C -- End Visit Occurrence Criteria ) E JOIN @cdm_database_schema.observation_period OP on E.person_id = OP.person_id and E.start_date >= OP.observation_period_start_date and E.start_date <= op.observation_period_end_date WHERE DATEADD(day,0,OP.OBSERVATION_PERIOD_START_DATE) <= E.START_DATE AND DATEADD(day,0,E.START_DATE) <= OP.OBSERVATION_PERIOD_END_DATE ) P WHERE P.ordinal = 1 -- End Primary Events ) E INNER JOIN ( -- Begin Correlated Criteria select 0 as index_id, cc.person_id, cc.event_id from (SELECT p.person_id, p.event_id FROM (-- Begin Primary Events select P.ordinal as event_id, P.person_id, P.start_date, P.end_date, op_start_date, op_end_date, cast(P.visit_occurrence_id as bigint) as visit_occurrence_id FROM ( select E.person_id, E.start_date, E.end_date, row_number() OVER (PARTITION BY E.person_id ORDER BY E.sort_date ASC, E.event_id) ordinal, OP.observation_period_start_date as op_start_date, OP.observation_period_end_date as op_end_date, cast(E.visit_occurrence_id as bigint) as visit_occurrence_id FROM ( -- Begin Visit Occurrence Criteria select C.person_id, C.visit_occurrence_id as event_id, C.visit_start_date as start_date, C.visit_end_date as end_date, C.visit_occurrence_id, C.visit_start_date as sort_date from ( select vo.* FROM @cdm_database_schema.VISIT_OCCURRENCE vo ) C -- End Visit Occurrence Criteria ) E JOIN @cdm_database_schema.observation_period OP on E.person_id = OP.person_id and E.start_date >= OP.observation_period_start_date and E.start_date <= op.observation_period_end_date WHERE DATEADD(day,0,OP.OBSERVATION_PERIOD_START_DATE) <= E.START_DATE AND DATEADD(day,0,E.START_DATE) <= OP.OBSERVATION_PERIOD_END_DATE ) P WHERE P.ordinal = 1 -- End Primary Events ) P JOIN ( -- Begin Visit Occurrence Criteria select C.person_id, C.visit_occurrence_id as event_id, C.visit_start_date as start_date, C.visit_end_date as end_date, C.visit_occurrence_id, C.visit_start_date as sort_date from ( select vo.* FROM @cdm_database_schema.VISIT_OCCURRENCE vo ) C WHERE C.visit_start_date >= DATEFROMPARTS(2020, 1, 1) -- End Visit Occurrence Criteria ) A on A.person_id = P.person_id AND A.START_DATE >= P.OP_START_DATE AND A.START_DATE <= P.OP_END_DATE AND A.START_DATE >= P.OP_START_DATE AND A.START_DATE <= P.OP_END_DATE ) cc GROUP BY cc.person_id, cc.event_id HAVING COUNT(cc.event_id) >= 1 -- End Correlated Criteria ) CQ on E.person_id = CQ.person_id and E.event_id = CQ.event_id GROUP BY E.person_id, E.event_id HAVING COUNT(index_id) = 1 ) G -- End Criteria Group ) AC on AC.person_id = pe.person_id and AC.event_id = pe.event_id ) QE WHERE QE.ordinal = 1 ; --- Inclusion Rule Inserts select 0 as inclusion_rule_id, person_id, event_id INTO #Inclusion_0 FROM ( select pe.person_id, pe.event_id FROM #qualified_events pe JOIN ( -- Begin Criteria Group select 0 as index_id, person_id, event_id FROM ( select E.person_id, E.event_id FROM #qualified_events E INNER JOIN ( -- Begin Correlated Criteria select 0 as index_id, cc.person_id, cc.event_id from (SELECT p.person_id, p.event_id FROM #qualified_events P JOIN ( -- Begin Visit Occurrence Criteria select C.person_id, C.visit_occurrence_id as event_id, C.visit_start_date as start_date, C.visit_end_date as end_date, C.visit_occurrence_id, C.visit_start_date as sort_date from ( select vo.* FROM @cdm_database_schema.VISIT_OCCURRENCE vo ) C -- End Visit Occurrence Criteria ) A on A.person_id = P.person_id AND A.START_DATE >= DATEADD(day,0,P.START_DATE) AND A.START_DATE <= DATEADD(day,180,P.START_DATE) ) cc GROUP BY cc.person_id, cc.event_id HAVING COUNT(cc.event_id) >= 1 -- End Correlated Criteria ) CQ on E.person_id = CQ.person_id and E.event_id = CQ.event_id GROUP BY E.person_id, E.event_id HAVING COUNT(index_id) = 1 ) G -- End Criteria Group ) AC on AC.person_id = pe.person_id AND AC.event_id = pe.event_id ) Results ; select 1 as inclusion_rule_id, person_id, event_id INTO #Inclusion_1 FROM ( select pe.person_id, pe.event_id FROM #qualified_events pe JOIN ( -- Begin Criteria Group select 0 as index_id, person_id, event_id FROM ( select E.person_id, E.event_id FROM #qualified_events E INNER JOIN ( -- Begin Correlated Criteria select 0 as index_id, cc.person_id, cc.event_id from (SELECT p.person_id, p.event_id FROM #qualified_events P JOIN ( -- Begin Condition Occurrence Criteria SELECT C.person_id, C.condition_occurrence_id as event_id, C.condition_start_date as start_date, COALESCE(C.condition_end_date, DATEADD(day,1,C.condition_start_date)) as end_date, C.visit_occurrence_id, C.condition_start_date as sort_date FROM ( SELECT co.* FROM @cdm_database_schema.CONDITION_OCCURRENCE co JOIN #Codesets cs on (co.condition_concept_id = cs.concept_id and cs.codeset_id = 5) ) C -- End Condition Occurrence Criteria ) A on A.person_id = P.person_id AND A.START_DATE >= DATEADD(day,0,P.START_DATE) AND A.START_DATE <= DATEADD(day,180,P.START_DATE) ) cc GROUP BY cc.person_id, cc.event_id HAVING COUNT(cc.event_id) >= 1 -- End Correlated Criteria UNION ALL -- Begin Correlated Criteria select 1 as index_id, cc.person_id, cc.event_id from (SELECT p.person_id, p.event_id FROM #qualified_events P JOIN ( -- Begin Measurement Criteria select C.person_id, C.measurement_id as event_id, C.measurement_date as start_date, DATEADD(d,1,C.measurement_date) as END_DATE, C.visit_occurrence_id, C.measurement_date as sort_date from ( select m.* FROM @cdm_database_schema.MEASUREMENT m JOIN #Codesets cs on (m.measurement_concept_id = cs.concept_id and cs.codeset_id = 5) ) C -- End Measurement Criteria ) A on A.person_id = P.person_id AND A.START_DATE >= DATEADD(day,0,P.START_DATE) AND A.START_DATE <= DATEADD(day,180,P.START_DATE) ) cc GROUP BY cc.person_id, cc.event_id HAVING COUNT(cc.event_id) >= 1 -- End Correlated Criteria UNION ALL -- Begin Correlated Criteria select 2 as index_id, cc.person_id, cc.event_id from (SELECT p.person_id, p.event_id FROM #qualified_events P JOIN ( -- Begin Observation Criteria select C.person_id, C.observation_id as event_id, C.observation_date as start_date, DATEADD(d,1,C.observation_date) as END_DATE, C.visit_occurrence_id, C.observation_date as sort_date from ( select o.* FROM @cdm_database_schema.OBSERVATION o JOIN #Codesets cs on (o.observation_concept_id = cs.concept_id and cs.codeset_id = 5) ) C -- End Observation Criteria ) A on A.person_id = P.person_id AND A.START_DATE >= DATEADD(day,0,P.START_DATE) AND A.START_DATE <= DATEADD(day,180,P.START_DATE) ) cc GROUP BY cc.person_id, cc.event_id HAVING COUNT(cc.event_id) >= 1 -- End Correlated Criteria UNION ALL -- Begin Correlated Criteria select 3 as index_id, cc.person_id, cc.event_id from (SELECT p.person_id, p.event_id FROM #qualified_events P JOIN ( -- Begin Procedure Occurrence Criteria select C.person_id, C.procedure_occurrence_id as event_id, C.procedure_date as start_date, DATEADD(d,1,C.procedure_date) as END_DATE, C.visit_occurrence_id, C.procedure_date as sort_date from ( select po.* FROM @cdm_database_schema.PROCEDURE_OCCURRENCE po JOIN #Codesets cs on (po.procedure_concept_id = cs.concept_id and cs.codeset_id = 5) ) C -- End Procedure Occurrence Criteria ) A on A.person_id = P.person_id AND A.START_DATE >= DATEADD(day,0,P.START_DATE) AND A.START_DATE <= DATEADD(day,180,P.START_DATE) ) cc GROUP BY cc.person_id, cc.event_id HAVING COUNT(cc.event_id) >= 1 -- End Correlated Criteria UNION ALL -- Begin Correlated Criteria select 4 as index_id, cc.person_id, cc.event_id from (SELECT p.person_id, p.event_id FROM #qualified_events P JOIN ( -- Begin Visit Occurrence Criteria select C.person_id, C.visit_occurrence_id as event_id, C.visit_start_date as start_date, C.visit_end_date as end_date, C.visit_occurrence_id, C.visit_start_date as sort_date from ( select vo.* FROM @cdm_database_schema.VISIT_OCCURRENCE vo JOIN #Codesets cs on (vo.visit_concept_id = cs.concept_id and cs.codeset_id = 5) ) C -- End Visit Occurrence Criteria ) A on A.person_id = P.person_id AND A.START_DATE >= DATEADD(day,0,P.START_DATE) AND A.START_DATE <= DATEADD(day,180,P.START_DATE) ) cc GROUP BY cc.person_id, cc.event_id HAVING COUNT(cc.event_id) >= 1 -- End Correlated Criteria ) CQ on E.person_id = CQ.person_id and E.event_id = CQ.event_id GROUP BY E.person_id, E.event_id HAVING COUNT(index_id) > 0 ) G -- End Criteria Group ) AC on AC.person_id = pe.person_id AND AC.event_id = pe.event_id ) Results ; SELECT inclusion_rule_id, person_id, event_id INTO #inclusion_events FROM (select inclusion_rule_id, person_id, event_id from #Inclusion_0 UNION ALL select inclusion_rule_id, person_id, event_id from #Inclusion_1) I; TRUNCATE TABLE #Inclusion_0; DROP TABLE #Inclusion_0; TRUNCATE TABLE #Inclusion_1; DROP TABLE #Inclusion_1; select event_id, person_id, start_date, end_date, op_start_date, op_end_date into #included_events FROM ( SELECT event_id, person_id, start_date, end_date, op_start_date, op_end_date, row_number() over (partition by person_id order by start_date ASC) as ordinal from ( select Q.event_id, Q.person_id, Q.start_date, Q.end_date, Q.op_start_date, Q.op_end_date, SUM(coalesce(POWER(cast(2 as bigint), I.inclusion_rule_id), 0)) as inclusion_rule_mask from #qualified_events Q LEFT JOIN #inclusion_events I on I.person_id = Q.person_id and I.event_id = Q.event_id GROUP BY Q.event_id, Q.person_id, Q.start_date, Q.end_date, Q.op_start_date, Q.op_end_date ) MG -- matching groups -- the matching group with all bits set ( POWER(2,# of inclusion rules) - 1 = inclusion_rule_mask WHERE (MG.inclusion_rule_mask = POWER(cast(2 as bigint),2)-1) ) Results WHERE Results.ordinal = 1 ; -- date offset strategy select event_id, person_id, case when DATEADD(day,180,start_date) > op_end_date then op_end_date else DATEADD(day,180,start_date) end as end_date INTO #strategy_ends from #included_events; -- generate cohort periods into #final_cohort select person_id, start_date, end_date INTO #cohort_rows from ( -- first_ends select F.person_id, F.start_date, F.end_date FROM ( select I.event_id, I.person_id, I.start_date, CE.end_date, row_number() over (partition by I.person_id, I.event_id order by CE.end_date) as ordinal from #included_events I join ( -- cohort_ends -- cohort exit dates -- End Date Strategy SELECT event_id, person_id, end_date from #strategy_ends ) CE on I.event_id = CE.event_id and I.person_id = CE.person_id and CE.end_date >= I.start_date ) F WHERE F.ordinal = 1 ) FE; select person_id, min(start_date) as start_date, end_date into #final_cohort from ( --cteEnds SELECT c.person_id , c.start_date , MIN(ed.end_date) AS end_date FROM #cohort_rows c JOIN ( -- cteEndDates SELECT person_id , DATEADD(day,-1 * 0, event_date) as end_date FROM ( SELECT person_id , event_date , event_type , SUM(event_type) OVER (PARTITION BY person_id ORDER BY event_date, event_type ROWS UNBOUNDED PRECEDING) AS interval_status FROM ( SELECT person_id , start_date AS event_date , -1 AS event_type FROM #cohort_rows UNION ALL SELECT person_id , DATEADD(day,0,end_date) as end_date , 1 AS event_type FROM #cohort_rows ) RAWDATA ) e WHERE interval_status = 0 ) ed ON c.person_id = ed.person_id AND ed.end_date >= c.start_date GROUP BY c.person_id, c.start_date ) e group by person_id, end_date ; DELETE FROM @target_database_schema.@target_cohort_table where cohort_definition_id = @target_cohort_id; INSERT INTO @target_database_schema.@target_cohort_table (cohort_definition_id, subject_id, cohort_start_date, cohort_end_date) select @target_cohort_id as cohort_definition_id, person_id, start_date, end_date FROM #final_cohort CO ; -- BEGIN: Censored Stats delete from @results_database_schema.cohort_censor_stats where cohort_definition_id = @target_cohort_id; -- END: Censored Stats -- Create a temp table of inclusion rule rows for joining in the inclusion rule impact analysis select cast(rule_sequence as int) as rule_sequence into #inclusion_rules from ( SELECT CAST(0 as int) as rule_sequence UNION ALL SELECT CAST(1 as int) as rule_sequence ) IR; -- Find the event that is the 'best match' per person. -- the 'best match' is defined as the event that satisfies the most inclusion rules. -- ties are solved by choosing the event that matches the earliest inclusion rule, and then earliest. select q.person_id, q.event_id into #best_events from #qualified_events Q join ( SELECT R.person_id, R.event_id, ROW_NUMBER() OVER (PARTITION BY R.person_id ORDER BY R.rule_count DESC,R.min_rule_id ASC, R.start_date ASC) AS rank_value FROM ( SELECT Q.person_id, Q.event_id, COALESCE(COUNT(DISTINCT I.inclusion_rule_id), 0) AS rule_count, COALESCE(MIN(I.inclusion_rule_id), 0) AS min_rule_id, Q.start_date FROM #qualified_events Q LEFT JOIN #inclusion_events I ON q.person_id = i.person_id AND q.event_id = i.event_id GROUP BY Q.person_id, Q.event_id, Q.start_date ) R ) ranked on Q.person_id = ranked.person_id and Q.event_id = ranked.event_id WHERE ranked.rank_value = 1 ; -- modes of generation: (the same tables store the results for the different modes, identified by the mode_id column) -- 0: all events -- 1: best event -- BEGIN: Inclusion Impact Analysis - event -- calculte matching group counts delete from @results_database_schema.cohort_inclusion_result where cohort_definition_id = @target_cohort_id and mode_id = 0; insert into @results_database_schema.cohort_inclusion_result (cohort_definition_id, inclusion_rule_mask, person_count, mode_id) select @target_cohort_id as cohort_definition_id, inclusion_rule_mask, count_big(*) as person_count, 0 as mode_id from ( select Q.person_id, Q.event_id, CAST(SUM(coalesce(POWER(cast(2 as bigint), I.inclusion_rule_id), 0)) AS bigint) as inclusion_rule_mask from #qualified_events Q LEFT JOIN #inclusion_events I on q.person_id = i.person_id and q.event_id = i.event_id GROUP BY Q.person_id, Q.event_id ) MG -- matching groups group by inclusion_rule_mask ; -- calculate gain counts delete from @results_database_schema.cohort_inclusion_stats where cohort_definition_id = @target_cohort_id and mode_id = 0; insert into @results_database_schema.cohort_inclusion_stats (cohort_definition_id, rule_sequence, person_count, gain_count, person_total, mode_id) select @target_cohort_id as cohort_definition_id, ir.rule_sequence, coalesce(T.person_count, 0) as person_count, coalesce(SR.person_count, 0) gain_count, EventTotal.total, 0 as mode_id from #inclusion_rules ir left join ( select i.inclusion_rule_id, count_big(i.event_id) as person_count from #qualified_events Q JOIN #inclusion_events i on Q.person_id = I.person_id and Q.event_id = i.event_id group by i.inclusion_rule_id ) T on ir.rule_sequence = T.inclusion_rule_id CROSS JOIN (select count(*) as total_rules from #inclusion_rules) RuleTotal CROSS JOIN (select count_big(event_id) as total from #qualified_events) EventTotal LEFT JOIN @results_database_schema.cohort_inclusion_result SR on SR.mode_id = 0 AND SR.cohort_definition_id = @target_cohort_id AND (POWER(cast(2 as bigint),RuleTotal.total_rules) - POWER(cast(2 as bigint),ir.rule_sequence) - 1) = SR.inclusion_rule_mask -- POWER(2,rule count) - POWER(2,rule sequence) - 1 is the mask for 'all except this rule' ; -- calculate totals delete from @results_database_schema.cohort_summary_stats where cohort_definition_id = @target_cohort_id and mode_id = 0; insert into @results_database_schema.cohort_summary_stats (cohort_definition_id, base_count, final_count, mode_id) select @target_cohort_id as cohort_definition_id, PC.total as person_count, coalesce(FC.total, 0) as final_count, 0 as mode_id FROM (select count_big(event_id) as total from #qualified_events) PC, (select sum(sr.person_count) as total from @results_database_schema.cohort_inclusion_result sr CROSS JOIN (select count(*) as total_rules from #inclusion_rules) RuleTotal where sr.mode_id = 0 and sr.cohort_definition_id = @target_cohort_id and sr.inclusion_rule_mask = POWER(cast(2 as bigint),RuleTotal.total_rules)-1 ) FC ; -- END: Inclusion Impact Analysis - event -- BEGIN: Inclusion Impact Analysis - person -- calculte matching group counts delete from @results_database_schema.cohort_inclusion_result where cohort_definition_id = @target_cohort_id and mode_id = 1; insert into @results_database_schema.cohort_inclusion_result (cohort_definition_id, inclusion_rule_mask, person_count, mode_id) select @target_cohort_id as cohort_definition_id, inclusion_rule_mask, count_big(*) as person_count, 1 as mode_id from ( select Q.person_id, Q.event_id, CAST(SUM(coalesce(POWER(cast(2 as bigint), I.inclusion_rule_id), 0)) AS bigint) as inclusion_rule_mask from #best_events Q LEFT JOIN #inclusion_events I on q.person_id = i.person_id and q.event_id = i.event_id GROUP BY Q.person_id, Q.event_id ) MG -- matching groups group by inclusion_rule_mask ; -- calculate gain counts delete from @results_database_schema.cohort_inclusion_stats where cohort_definition_id = @target_cohort_id and mode_id = 1; insert into @results_database_schema.cohort_inclusion_stats (cohort_definition_id, rule_sequence, person_count, gain_count, person_total, mode_id) select @target_cohort_id as cohort_definition_id, ir.rule_sequence, coalesce(T.person_count, 0) as person_count, coalesce(SR.person_count, 0) gain_count, EventTotal.total, 1 as mode_id from #inclusion_rules ir left join ( select i.inclusion_rule_id, count_big(i.event_id) as person_count from #best_events Q JOIN #inclusion_events i on Q.person_id = I.person_id and Q.event_id = i.event_id group by i.inclusion_rule_id ) T on ir.rule_sequence = T.inclusion_rule_id CROSS JOIN (select count(*) as total_rules from #inclusion_rules) RuleTotal CROSS JOIN (select count_big(event_id) as total from #best_events) EventTotal LEFT JOIN @results_database_schema.cohort_inclusion_result SR on SR.mode_id = 1 AND SR.cohort_definition_id = @target_cohort_id AND (POWER(cast(2 as bigint),RuleTotal.total_rules) - POWER(cast(2 as bigint),ir.rule_sequence) - 1) = SR.inclusion_rule_mask -- POWER(2,rule count) - POWER(2,rule sequence) - 1 is the mask for 'all except this rule' ; -- calculate totals delete from @results_database_schema.cohort_summary_stats where cohort_definition_id = @target_cohort_id and mode_id = 1; insert into @results_database_schema.cohort_summary_stats (cohort_definition_id, base_count, final_count, mode_id) select @target_cohort_id as cohort_definition_id, PC.total as person_count, coalesce(FC.total, 0) as final_count, 1 as mode_id FROM (select count_big(event_id) as total from #best_events) PC, (select sum(sr.person_count) as total from @results_database_schema.cohort_inclusion_result sr CROSS JOIN (select count(*) as total_rules from #inclusion_rules) RuleTotal where sr.mode_id = 1 and sr.cohort_definition_id = @target_cohort_id and sr.inclusion_rule_mask = POWER(cast(2 as bigint),RuleTotal.total_rules)-1 ) FC ; -- END: Inclusion Impact Analysis - person TRUNCATE TABLE #best_events; DROP TABLE #best_events; TRUNCATE TABLE #inclusion_rules; DROP TABLE #inclusion_rules; TRUNCATE TABLE #strategy_ends; DROP TABLE #strategy_ends; TRUNCATE TABLE #cohort_rows; DROP TABLE #cohort_rows; TRUNCATE TABLE #final_cohort; DROP TABLE #final_cohort; TRUNCATE TABLE #inclusion_events; DROP TABLE #inclusion_events; TRUNCATE TABLE #qualified_events; DROP TABLE #qualified_events; TRUNCATE TABLE #included_events; DROP TABLE #included_events; TRUNCATE TABLE #Codesets; DROP TABLE #Codesets; { "cdmVersionRange" : ">=5.0.0", "PrimaryCriteria" : { "CriteriaList" : [ { "VisitOccurrence" : { "VisitTypeExclude" : false } } ], "ObservationWindow" : { "PriorDays" : 0, "PostDays" : 0 }, "PrimaryCriteriaLimit" : { "Type" : "First" } }, "AdditionalCriteria" : { "Type" : "ALL", "CriteriaList" : [ { "Criteria" : { "VisitOccurrence" : { "OccurrenceStartDate" : { "Value" : "2020-01-01", "Op" : "gte" }, "VisitTypeExclude" : false } }, "StartWindow" : { "Start" : { "Coeff" : -1 }, "End" : { "Coeff" : 1 }, "UseIndexEnd" : false, "UseEventEnd" : false }, "RestrictVisit" : false, "IgnoreObservationPeriod" : false, "Occurrence" : { "Type" : 2, "Count" : 1, "IsDistinct" : false } } ], "DemographicCriteriaList" : [], "Groups" : [] }, "ConceptSets" : [ { "id" : 0, "name" : "Homeless Condition", "expression" : { "items" : [ { "concept" : { "CONCEPT_ID" : 35609191, "CONCEPT_NAME" : "Place of occurrence of injury is hostel for the homeless", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "1079661000000106", "DOMAIN_ID" : "Condition", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Clinical Finding" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false } ] } }, { "id" : 1, "name" : "Homeless Measurement", "expression" : { "items" : [ { "concept" : { "CONCEPT_ID" : 21498856, "CONCEPT_NAME" : "Homeless", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "LA20561-9", "DOMAIN_ID" : "Meas Value", "VOCABULARY_ID" : "LOINC", "CONCEPT_CLASS_ID" : "Answer" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 36309593, "CONCEPT_NAME" : "I'm homeless or threatened with eviction", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "LA29213-8", "DOMAIN_ID" : "Meas Value", "VOCABULARY_ID" : "LOINC", "CONCEPT_CLASS_ID" : "Answer" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 36310234, "CONCEPT_NAME" : "Patient is homeless", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "LA18835-1", "DOMAIN_ID" : "Meas Value", "VOCABULARY_ID" : "LOINC", "CONCEPT_CLASS_ID" : "Answer" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 37079289, "CONCEPT_NAME" : "I do not have housing (staying with others, in a hotel, in a shelter, living outside on the street, on a beach, in a car, or in a park)", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "LA30190-5", "DOMAIN_ID" : "Meas Value", "VOCABULARY_ID" : "LOINC", "CONCEPT_CLASS_ID" : "Answer" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 36310431, "CONCEPT_NAME" : "I'm in transitional, temporary or substandard housing; and/or current rent/mortgage is unaffordable (over 30% of income)", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "LA29212-0", "DOMAIN_ID" : "Meas Value", "VOCABULARY_ID" : "LOINC", "CONCEPT_CLASS_ID" : "Answer" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false } ] } }, { "id" : 2, "name" : "Homeless Observation", "expression" : { "items" : [ { "concept" : { "CONCEPT_ID" : 44810601, "CONCEPT_NAME" : "Discharge from homeless advocacy service", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "898811000000106", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Procedure" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 4271762, "CONCEPT_NAME" : "Feature of homelessness", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "364701009", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Observable Entity" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 4139934, "CONCEPT_NAME" : "Homeless", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "32911000", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Clinical Finding" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 44788302, "CONCEPT_NAME" : "Homeless enhanced service completed", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "166461000000103", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Clinical Finding" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 44788283, "CONCEPT_NAME" : "Homeless enhanced services administration", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "166301000000107", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Clinical Finding" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 4019973, "CONCEPT_NAME" : "Homeless family", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "105526001", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Clinical Finding" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 4190815, "CONCEPT_NAME" : "Homeless mental health care", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "390818002", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Procedure" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 4307308, "CONCEPT_NAME" : "Homeless mental health care - 3-5 contacts/week", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "391195008", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Procedure" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 4192297, "CONCEPT_NAME" : "Homeless mental health care - Daily intensive", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "391194007", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Procedure" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 4307307, "CONCEPT_NAME" : "Homeless mental health care - Full day : day care", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "391191004", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Procedure" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 4193277, "CONCEPT_NAME" : "Homeless mental health care - Part day : day care", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "391192006", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Procedure" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 4052051, "CONCEPT_NAME" : "Homeless single person", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "160700001", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Clinical Finding" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 4076506, "CONCEPT_NAME" : "Hostel for the homeless", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "224675009", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Clinical Finding" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 35610659, "CONCEPT_NAME" : "Provision of community outreach care for homeless", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "1095491000000105", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Procedure" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 35610286, "CONCEPT_NAME" : "Referral to homeless advocacy service", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "1091381000000101", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Procedure" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 42690497, "CONCEPT_NAME" : "Referred by homeless drop-in centre", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "1077211000000104", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Clinical Finding" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 45765559, "CONCEPT_NAME" : "Under care of homeless advocacy service", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "702526004", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Clinical Finding" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 4137393, "CONCEPT_NAME" : "Discharge to sheltered housing", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "306697004", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Procedure" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 4144274, "CONCEPT_NAME" : "Housing lack", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "266935003", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Clinical Finding" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 4053088, "CONCEPT_NAME" : "Lives in sheltered housing", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "160729004", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Clinical Finding" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 44790997, "CONCEPT_NAME" : "Living in temporary housing", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "247521000000104", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Clinical Finding" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 4091004, "CONCEPT_NAME" : "On housing list", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "185956004", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Clinical Finding" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 4090385, "CONCEPT_NAME" : "On urgent housing list", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "185955000", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Clinical Finding" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 44806052, "CONCEPT_NAME" : "Referral by housing service", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "790331000000107", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Procedure" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 44793821, "CONCEPT_NAME" : "Referral to housing department", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "38921000000104", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Procedure" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 46272532, "CONCEPT_NAME" : "Referral to housing service", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "710911006", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Procedure" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 3656380, "CONCEPT_NAME" : "Transitional housing", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "25911000087103", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Location" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 4022661, "CONCEPT_NAME" : "Housing problem", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "105531004", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Clinical Finding" }, "isExcluded" : false, "includeDescendants" : false, "includeMapped" : false } ] } }, { "id" : 3, "name" : "Homeless Procedure", "expression" : { "items" : [ { "concept" : { "CONCEPT_ID" : 37208401, "CONCEPT_NAME" : "Signposting to homeless support service", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "1104581000000103", "DOMAIN_ID" : "Procedure", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Procedure" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 35609555, "CONCEPT_NAME" : "Signposting to housing support service", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "1083301000000108", "DOMAIN_ID" : "Procedure", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Procedure" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false } ] } }, { "id" : 4, "name" : "Homeless Visit", "expression" : { "items" : [ { "concept" : { "CONCEPT_ID" : 8672, "CONCEPT_NAME" : "Homeless Shelter", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "04", "DOMAIN_ID" : "Visit", "VOCABULARY_ID" : "CMS Place of Service", "CONCEPT_CLASS_ID" : "Visit" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false } ] } }, { "id" : 5, "name" : "Homeless - 2023-07-12 (ALL CONCEPTS)", "expression" : { "items" : [ { "concept" : { "CONCEPT_ID" : 4053088, "CONCEPT_NAME" : "Lives in sheltered housing", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "160729004", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Clinical Finding" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 4147554, "CONCEPT_NAME" : "Sheltered housing", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "310207003", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Clinical Finding" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 40519180, "CONCEPT_NAME" : "[V]Lack of housing", "STANDARD_CONCEPT" : "N", "STANDARD_CONCEPT_CAPTION" : "Non-Standard", "INVALID_REASON" : "D", "INVALID_REASON_CAPTION" : "Invalid", "CONCEPT_CODE" : "316362003", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Context-dependent" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 44794577, "CONCEPT_NAME" : "[V]Lack of housing", "STANDARD_CONCEPT" : "N", "STANDARD_CONCEPT_CAPTION" : "Non-Standard", "INVALID_REASON" : "U", "INVALID_REASON_CAPTION" : "Invalid", "CONCEPT_CODE" : "398341000000102", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Context-dependent" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 40519187, "CONCEPT_NAME" : "[V]Sheltered housing", "STANDARD_CONCEPT" : "N", "STANDARD_CONCEPT_CAPTION" : "Non-Standard", "INVALID_REASON" : "D", "INVALID_REASON_CAPTION" : "Invalid", "CONCEPT_CODE" : "316369007", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Context-dependent" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 44812921, "CONCEPT_NAME" : "[V]Sheltered housing", "STANDARD_CONCEPT" : "N", "STANDARD_CONCEPT_CAPTION" : "Non-Standard", "INVALID_REASON" : "U", "INVALID_REASON_CAPTION" : "Invalid", "CONCEPT_CODE" : "431521000000106", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Context-dependent" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 40329696, "CONCEPT_NAME" : "(Housing lack) or (homeless)", "STANDARD_CONCEPT" : "N", "STANDARD_CONCEPT_CAPTION" : "Non-Standard", "INVALID_REASON" : "U", "INVALID_REASON_CAPTION" : "Invalid", "CONCEPT_CODE" : "160699002", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Clinical Finding" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 21498856, "CONCEPT_NAME" : "Homeless", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "LA20561-9", "DOMAIN_ID" : "Meas Value", "VOCABULARY_ID" : "LOINC", "CONCEPT_CLASS_ID" : "Answer" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 4139934, "CONCEPT_NAME" : "Homeless", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "32911000", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Clinical Finding" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 40299198, "CONCEPT_NAME" : "Homeless", "STANDARD_CONCEPT" : "N", "STANDARD_CONCEPT_CAPTION" : "Non-Standard", "INVALID_REASON" : "U", "INVALID_REASON_CAPTION" : "Invalid", "CONCEPT_CODE" : "138087002", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Clinical Finding" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 3552499, "CONCEPT_NAME" : "Homeless - enhanced service completed", "STANDARD_CONCEPT" : "N", "STANDARD_CONCEPT_CAPTION" : "Non-Standard", "INVALID_REASON" : "U", "INVALID_REASON_CAPTION" : "Invalid", "CONCEPT_CODE" : "165571000000100", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Clinical Finding" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 3552820, "CONCEPT_NAME" : "Homeless - enhanced service completed", "STANDARD_CONCEPT" : "N", "STANDARD_CONCEPT_CAPTION" : "Non-Standard", "INVALID_REASON" : "U", "INVALID_REASON_CAPTION" : "Invalid", "CONCEPT_CODE" : "171301000000107", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Clinical Finding" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 3552819, "CONCEPT_NAME" : "Homeless - enhanced services administration", "STANDARD_CONCEPT" : "N", "STANDARD_CONCEPT_CAPTION" : "Non-Standard", "INVALID_REASON" : "U", "INVALID_REASON_CAPTION" : "Invalid", "CONCEPT_CODE" : "171291000000108", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Clinical Finding" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 3553101, "CONCEPT_NAME" : "Homeless - enhanced services administration", "STANDARD_CONCEPT" : "N", "STANDARD_CONCEPT_CAPTION" : "Non-Standard", "INVALID_REASON" : "U", "INVALID_REASON_CAPTION" : "Invalid", "CONCEPT_CODE" : "175961000000109", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Clinical Finding" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 8672, "CONCEPT_NAME" : "Homeless Shelter", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "04", "DOMAIN_ID" : "Visit", "VOCABULARY_ID" : "CMS Place of Service", "CONCEPT_CLASS_ID" : "Visit" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 42628011, "CONCEPT_NAME" : "Homeless Shelter", "STANDARD_CONCEPT" : "N", "STANDARD_CONCEPT_CAPTION" : "Non-Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "1021866", "DOMAIN_ID" : "Visit", "VOCABULARY_ID" : "CPT4", "CONCEPT_CLASS_ID" : "Visit" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 44788302, "CONCEPT_NAME" : "Homeless enhanced service completed", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "166461000000103", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Clinical Finding" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 44788283, "CONCEPT_NAME" : "Homeless enhanced services administration", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "166301000000107", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Clinical Finding" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 4019973, "CONCEPT_NAME" : "Homeless family", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "105526001", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Clinical Finding" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 40299199, "CONCEPT_NAME" : "Homeless family", "STANDARD_CONCEPT" : "N", "STANDARD_CONCEPT_CAPTION" : "Non-Standard", "INVALID_REASON" : "U", "INVALID_REASON_CAPTION" : "Invalid", "CONCEPT_CODE" : "138088007", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Clinical Finding" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 4190815, "CONCEPT_NAME" : "Homeless mental health care", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "390818002", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Procedure" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 4307308, "CONCEPT_NAME" : "Homeless mental health care - 3-5 contacts/week", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "391195008", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Procedure" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 4192297, "CONCEPT_NAME" : "Homeless mental health care - Daily intensive", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "391194007", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Procedure" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 4307307, "CONCEPT_NAME" : "Homeless mental health care - Full day : day care", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "391191004", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Procedure" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 4193277, "CONCEPT_NAME" : "Homeless mental health care - Part day : day care", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "391192006", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Procedure" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 40299200, "CONCEPT_NAME" : "Homeless single person", "STANDARD_CONCEPT" : "N", "STANDARD_CONCEPT_CAPTION" : "Non-Standard", "INVALID_REASON" : "U", "INVALID_REASON_CAPTION" : "Invalid", "CONCEPT_CODE" : "138089004", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Clinical Finding" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 4052051, "CONCEPT_NAME" : "Homeless single person", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "160700001", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Clinical Finding" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 35225199, "CONCEPT_NAME" : "Homelessness", "STANDARD_CONCEPT" : "N", "STANDARD_CONCEPT_CAPTION" : "Non-Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "Z59.0", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "ICD10CM", "CONCEPT_CLASS_ID" : "4-char billing code" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 36309593, "CONCEPT_NAME" : "I'm homeless or threatened with eviction", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "LA29213-8", "DOMAIN_ID" : "Meas Value", "VOCABULARY_ID" : "LOINC", "CONCEPT_CLASS_ID" : "Answer" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 36310234, "CONCEPT_NAME" : "Patient is homeless", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "LA18835-1", "DOMAIN_ID" : "Meas Value", "VOCABULARY_ID" : "LOINC", "CONCEPT_CLASS_ID" : "Answer" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 36662349, "CONCEPT_NAME" : "Person does not have a permanent home or is homeless.", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "LA30928-8", "DOMAIN_ID" : "Meas Value", "VOCABULARY_ID" : "LOINC", "CONCEPT_CLASS_ID" : "Answer" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 35609191, "CONCEPT_NAME" : "Place of occurrence of injury is hostel for the homeless", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "1079661000000106", "DOMAIN_ID" : "Condition", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Clinical Finding" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 42690497, "CONCEPT_NAME" : "Referred by homeless drop-in centre", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "1077211000000104", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Clinical Finding" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 45765559, "CONCEPT_NAME" : "Under care of homeless advocacy service", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "702526004", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Clinical Finding" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 44810341, "CONCEPT_NAME" : "Under care of homeless advocacy service", "STANDARD_CONCEPT" : "N", "STANDARD_CONCEPT_CAPTION" : "Non-Standard", "INVALID_REASON" : "U", "INVALID_REASON_CAPTION" : "Invalid", "CONCEPT_CODE" : "887461000000108", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Clinical Finding" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 3560142, "CONCEPT_NAME" : "Under care of homeless advocacy service", "STANDARD_CONCEPT" : "N", "STANDARD_CONCEPT_CAPTION" : "Non-Standard", "INVALID_REASON" : "U", "INVALID_REASON_CAPTION" : "Invalid", "CONCEPT_CODE" : "887471000000101", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Clinical Finding" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 40329696, "CONCEPT_NAME" : "(Housing lack) or (homeless)", "STANDARD_CONCEPT" : "N", "STANDARD_CONCEPT_CAPTION" : "Non-Standard", "INVALID_REASON" : "U", "INVALID_REASON_CAPTION" : "Invalid", "CONCEPT_CODE" : "160699002", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Clinical Finding" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 3557438, "CONCEPT_NAME" : "Awaiting housing NOS", "STANDARD_CONCEPT" : "N", "STANDARD_CONCEPT_CAPTION" : "Non-Standard", "INVALID_REASON" : "D", "INVALID_REASON_CAPTION" : "Invalid", "CONCEPT_CODE" : "553841000000107", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Clinical Finding" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 40318572, "CONCEPT_NAME" : "Awaiting housing NOS", "STANDARD_CONCEPT" : "N", "STANDARD_CONCEPT_CAPTION" : "Non-Standard", "INVALID_REASON" : "U", "INVALID_REASON_CAPTION" : "Invalid", "CONCEPT_CODE" : "154138002", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Clinical Finding" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 4091008, "CONCEPT_NAME" : "Awaiting housing NOS", "STANDARD_CONCEPT" : "N", "STANDARD_CONCEPT_CAPTION" : "Non-Standard", "INVALID_REASON" : "U", "INVALID_REASON_CAPTION" : "Invalid", "CONCEPT_CODE" : "185962009", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Clinical Finding" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 4137393, "CONCEPT_NAME" : "Discharge to sheltered housing", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "306697004", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Procedure" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 4144274, "CONCEPT_NAME" : "Housing lack", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "266935003", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Clinical Finding" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 3557354, "CONCEPT_NAME" : "Housing lack NOS", "STANDARD_CONCEPT" : "N", "STANDARD_CONCEPT_CAPTION" : "Non-Standard", "INVALID_REASON" : "D", "INVALID_REASON_CAPTION" : "Invalid", "CONCEPT_CODE" : "542821000000105", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Clinical Finding" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 40299203, "CONCEPT_NAME" : "Housing lack NOS", "STANDARD_CONCEPT" : "N", "STANDARD_CONCEPT_CAPTION" : "Non-Standard", "INVALID_REASON" : "U", "INVALID_REASON_CAPTION" : "Invalid", "CONCEPT_CODE" : "138091007", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Clinical Finding" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 4058157, "CONCEPT_NAME" : "Housing lack NOS", "STANDARD_CONCEPT" : "N", "STANDARD_CONCEPT_CAPTION" : "Non-Standard", "INVALID_REASON" : "U", "INVALID_REASON_CAPTION" : "Invalid", "CONCEPT_CODE" : "160704005", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "SNOMED", "CONCEPT_CLASS_ID" : "Clinical Finding" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 37079289, "CONCEPT_NAME" : "I do not have housing (staying with others, in a hotel, in a shelter, living outside on the street, on a beach, in a car, or in a park)", "STANDARD_CONCEPT" : "S", "STANDARD_CONCEPT_CAPTION" : "Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "LA30190-5", "DOMAIN_ID" : "Meas Value", "VOCABULARY_ID" : "LOINC", "CONCEPT_CLASS_ID" : "Answer" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false }, { "concept" : { "CONCEPT_ID" : 44831984, "CONCEPT_NAME" : "Lack of housing", "STANDARD_CONCEPT" : "N", "STANDARD_CONCEPT_CAPTION" : "Non-Standard", "INVALID_REASON" : "V", "INVALID_REASON_CAPTION" : "Valid", "CONCEPT_CODE" : "V60.0", "DOMAIN_ID" : "Observation", "VOCABULARY_ID" : "ICD9CM", "CONCEPT_CLASS_ID" : "4-dig billing V code" }, "isExcluded" : false, "includeDescendants" : true, "includeMapped" : false } ] } } ], "QualifiedLimit" : { "Type" : "First" }, "ExpressionLimit" : { "Type" : "First" }, "InclusionRules" : [ { "name" : "Visit 6 months after first visit", "description" : "Patient has at least one visit 6 months or more after their first visit after 2020-01-01", "expression" : { "Type" : "ALL", "CriteriaList" : [ { "Criteria" : { "VisitOccurrence" : { "VisitTypeExclude" : false } }, "StartWindow" : { "Start" : { "Days" : 0, "Coeff" : -1 }, "End" : { "Days" : 180, "Coeff" : 1 }, "UseIndexEnd" : false, "UseEventEnd" : false }, "RestrictVisit" : false, "IgnoreObservationPeriod" : true, "Occurrence" : { "Type" : 2, "Count" : 1, "IsDistinct" : false } } ], "DemographicCriteriaList" : [], "Groups" : [] } }, { "name" : "Homeless Indicators", "description" : "Patient has one of the indicators having experienced homelessness", "expression" : { "Type" : "ANY", "CriteriaList" : [ { "Criteria" : { "ConditionOccurrence" : { "CodesetId" : 5, "ConditionTypeExclude" : false } }, "StartWindow" : { "Start" : { "Days" : 0, "Coeff" : 1 }, "End" : { "Days" : 180, "Coeff" : 1 }, "UseIndexEnd" : false, "UseEventEnd" : false }, "RestrictVisit" : false, "IgnoreObservationPeriod" : true, "Occurrence" : { "Type" : 2, "Count" : 1, "IsDistinct" : false } }, { "Criteria" : { "Measurement" : { "CodesetId" : 5, "MeasurementTypeExclude" : false } }, "StartWindow" : { "Start" : { "Days" : 0, "Coeff" : 1 }, "End" : { "Days" : 180, "Coeff" : 1 }, "UseIndexEnd" : false, "UseEventEnd" : false }, "RestrictVisit" : false, "IgnoreObservationPeriod" : true, "Occurrence" : { "Type" : 2, "Count" : 1, "IsDistinct" : false } }, { "Criteria" : { "Observation" : { "CodesetId" : 5, "ObservationTypeExclude" : false } }, "StartWindow" : { "Start" : { "Days" : 0, "Coeff" : 1 }, "End" : { "Days" : 180, "Coeff" : 1 }, "UseIndexEnd" : false, "UseEventEnd" : false }, "RestrictVisit" : false, "IgnoreObservationPeriod" : true, "Occurrence" : { "Type" : 2, "Count" : 1, "IsDistinct" : false } }, { "Criteria" : { "ProcedureOccurrence" : { "CodesetId" : 5, "ProcedureTypeExclude" : false } }, "StartWindow" : { "Start" : { "Days" : 0, "Coeff" : 1 }, "End" : { "Days" : 180, "Coeff" : 1 }, "UseIndexEnd" : false, "UseEventEnd" : false }, "RestrictVisit" : false, "IgnoreObservationPeriod" : true, "Occurrence" : { "Type" : 2, "Count" : 1, "IsDistinct" : false } }, { "Criteria" : { "VisitOccurrence" : { "CodesetId" : 5, "VisitTypeExclude" : false } }, "StartWindow" : { "Start" : { "Days" : 0, "Coeff" : 1 }, "End" : { "Days" : 180, "Coeff" : 1 }, "UseIndexEnd" : false, "UseEventEnd" : false }, "RestrictVisit" : false, "IgnoreObservationPeriod" : true, "Occurrence" : { "Type" : 2, "Count" : 1, "IsDistinct" : false } } ], "DemographicCriteriaList" : [], "Groups" : [] } } ], "EndStrategy" : { "DateOffset" : { "DateField" : "StartDate", "Offset" : 180 } }, "CensoringCriteria" : [], "CollapseSettings" : { "CollapseType" : "ERA", "EraPad" : 0 }, "CensorWindow" : {} }