text: -- 410	Number of condition occurrence records outside valid observation period
  
  
  select 410 as analysis_id,
  	cast(null as varchar(255)) as stratum_1, cast(null as varchar(255)) as stratum_2, cast(null as varchar(255)) as stratum_3, cast(null as varchar(255)) as stratum_4, cast(null as varchar(255)) as stratum_5,
  	COUNT_BIG(co1.PERSON_ID) as count_value
  into @scratchDatabaseSchema@schemaDelim@tempAchillesPrefix_410
  from
  	@cdmDatabaseSchema.condition_occurrence co1
  	left join @cdmDatabaseSchema.observation_period op1
  	on op1.person_id = co1.person_id
  	and co1.condition_start_date >= op1.observation_period_start_date
  	and co1.condition_start_date <= op1.observation_period_end_date
  where op1.person_id is null
  ;
  