table_name,column_name,data_type,is_required,primary_key,empty_is_na,min_cell_count,description
time_to_event,database_id,varchar(100),Yes,Yes,No,No,The database identifier
time_to_event,target_cohort_definition_id,bigint,Yes,Yes,No,No,The cohort definition id for the target cohort
time_to_event,outcome_cohort_definition_id,bigint,Yes,Yes,No,No,The cohort definition id for the outcome cohort
time_to_event,outcome_type,varchar(100),Yes,Yes,No,No,Is the outvome a first occurrence or repeat
time_to_event,target_outcome_type,varchar(40),Yes,Yes,No,No,When does the outcome occur relative to target
time_to_event,time_to_event,int,Yes,Yes,No,No,The time (in days) from target index to outcome start
time_to_event,num_events,int,Yes,No,No,No,Number of events that occur during the specified time to event
time_to_event,time_scale,varchar(20),Yes,Yes,No,No,time scale for the number of events
rechallenge_fail_case_series,database_id,varchar(100),Yes,Yes,No,No,The database identifier
rechallenge_fail_case_series,dechallenge_stop_interval,int,Yes,Yes,No,No,The time period that É
rechallenge_fail_case_series,dechallenge_evaluation_window,int,Yes,Yes,No,No,The time period that É
rechallenge_fail_case_series,target_cohort_definition_id,bigint,Yes,Yes,No,No,The cohort definition id for the target cohort
rechallenge_fail_case_series,outcome_cohort_definition_id,bigint,Yes,Yes,No,No,The cohort definition id for the outcome cohort
rechallenge_fail_case_series,person_key,int,Yes,Yes,No,No,The dense rank for the patient (an identifier that is not the same as the database)
rechallenge_fail_case_series,subject_id,bigint,No,No,No,No,The person identifier for the failed case series (optional)
rechallenge_fail_case_series,dechallenge_exposure_number,int,Yes,Yes,No,No,The number of times a dechallenge has occurred
rechallenge_fail_case_series,dechallenge_exposure_start_date_offset,int,Yes,No,No,No,The offset for the dechallenge start (number of days after index)
rechallenge_fail_case_series,dechallenge_exposure_end_date_offset,int,Yes,No,No,No,The offset for the dechallenge end (number of days after index)
rechallenge_fail_case_series,dechallenge_outcome_number,int,Yes,Yes,No,No,The number of times an outcome has occurred during the dechallenge
rechallenge_fail_case_series,dechallenge_outcome_start_date_offset,int,Yes,No,No,No,The offset for the outcome start (number of days after index)
rechallenge_fail_case_series,rechallenge_exposure_number,int,Yes,Yes,No,No,The number of times a rechallenge exposure has occurred
rechallenge_fail_case_series,rechallenge_exposure_start_date_offset,int,Yes,No,No,No,The offset for the rechallenge start (number of days after index)
rechallenge_fail_case_series,rechallenge_exposure_end_date_offset,int,Yes,No,No,No,The offset for the rechallenge end (number of days after index)
rechallenge_fail_case_series,rechallenge_outcome_number,int,Yes,Yes,No,No,The number of times the outcome has occurred during the rechallenge
rechallenge_fail_case_series,rechallenge_outcome_start_date_offset,int,Yes,No,No,No,The offset for the outcome start (number of days after index)
dechallenge_rechallenge,database_id,varchar(100),Yes,Yes,No,No,The database identifier
dechallenge_rechallenge,dechallenge_stop_interval,int,Yes,Yes,No,No,The dechallenge stop interval
dechallenge_rechallenge,dechallenge_evaluation_window,int,Yes,Yes,No,No,The dechallenge evaluation window
dechallenge_rechallenge,target_cohort_definition_id,bigint,Yes,Yes,No,No,The cohort definition id for the target cohort
dechallenge_rechallenge,outcome_cohort_definition_id,bigint,Yes,Yes,No,No,The cohort definition id for the outcome cohort
dechallenge_rechallenge,num_exposure_eras,int,Yes,No,No,No,The number of exposure eras
dechallenge_rechallenge,num_persons_exposed,int,Yes,No,No,No,The number of persons exposed
dechallenge_rechallenge,num_cases,int,Yes,No,No,No,The number of cases
dechallenge_rechallenge,dechallenge_attempt,int,Yes,No,No,No,The number of dechallenge attempts
dechallenge_rechallenge,dechallenge_fail,int,Yes,No,No,No,The dechallenge fail count
dechallenge_rechallenge,dechallenge_success,int,Yes,No,No,No,The dechallenge success count
dechallenge_rechallenge,rechallenge_attempt,int,Yes,No,No,No,The rechallenge attempt count
dechallenge_rechallenge,rechallenge_fail,int,Yes,No,No,No,The rechallenge fail count
dechallenge_rechallenge,rechallenge_success,int,Yes,No,No,No,The rechallenge success count
dechallenge_rechallenge,pct_dechallenge_attempt,float,Yes,No,No,No,The percentage of dechallenge attempts
dechallenge_rechallenge,pct_dechallenge_success,float,Yes,No,No,No,The percentage of dechallenge success
dechallenge_rechallenge,pct_dechallenge_fail,float,Yes,No,No,No,The percentage of dechallenge fails
dechallenge_rechallenge,pct_rechallenge_attempt,float,Yes,No,No,No,The percentage of rechallenge attempts
dechallenge_rechallenge,pct_rechallenge_success,float,Yes,No,No,No,The percentage of rechallenge success
dechallenge_rechallenge,pct_rechallenge_fail,float,Yes,No,No,No,The percentage of rechallenge fails
analysis_ref,database_id,varchar(100),Yes,Yes,No,No,The database identifier
analysis_ref,setting_id,varchar(30),Yes,Yes,No,No,The run identifier
analysis_ref,analysis_id,int,Yes,Yes,No,No,The analysis identifier
analysis_ref,analysis_name,varchar,Yes,No,No,No,The analysis name
analysis_ref,domain_id,varchar,Yes,No,No,No,The domain id
analysis_ref,start_day,int,Yes,No,No,No,The start day
analysis_ref,end_day,int,Yes,No,No,No,The end day
analysis_ref,is_binary,varchar(1),Yes,No,No,No,Is this a binary analysis
analysis_ref,missing_means_zero,varchar(1),Yes,No,No,No,Missing means zero
covariate_ref,database_id,varchar(100),Yes,Yes,No,No,The database identifier
covariate_ref,setting_id,varchar(30),Yes,Yes,No,No,The run identifier
covariate_ref,covariate_id,bigint,Yes,Yes,No,No,The covariate identifier
covariate_ref,covariate_name,varchar,Yes,No,No,No,The covariate name
covariate_ref,analysis_id,int,Yes,No,No,No,The analysis identifier
covariate_ref,concept_id,bigint,Yes,No,No,No,The concept identifier
covariate_ref,value_as_concept_id,int,N,N,N,N,The value as concept_id for features created from observation or measurement values
covariate_ref,collisions,int,N,N,N,N,The number of collisions found for the covariate_id
covariates,database_id,varchar(100),Yes,Yes,No,No,The database identifier
covariates,setting_id,varchar(30),Yes,Yes,No,No,The run identifier
covariates,cohort_type,varchar(12),Yes,Yes,No,No,The cohort type
covariates,target_cohort_id,int,Yes,Yes,No,No,The target cohort id
covariates,outcome_cohort_id,int,Yes,Yes,No,No,The outcome cohort id
covariates,min_characterization_mean,float,Yes,Yes,No,No,Minimum fraction for feature extraction
covariates,covariate_id,bigint,Yes,Yes,No,No,The covaraite id
covariates,sum_value,int,Yes,No,No,No,The sum value
covariates,average_value,float,No,No,No,No,The average value
covariates_continuous,database_id,varchar(100),Yes,Yes,No,No,The database identifier
covariates_continuous,setting_id,varchar(30),Yes,Yes,No,No,The run identifier
covariates_continuous,cohort_type,varchar(12),Yes,Yes,No,No,The cohort type
covariates_continuous,target_cohort_id,int,Yes,Yes,No,No,The target cohort id
covariates_continuous,outcome_cohort_id,int,Yes,Yes,No,No,The outcome cohort id
covariates_continuous,covariate_id,bigint,Yes,Yes,No,No,The covariate identifier
covariates_continuous,count_value,int,Yes,No,No,No,The count value
covariates_continuous,min_value,float,No,No,No,No,The min value
covariates_continuous,max_value,float,No,No,No,No,The max value
covariates_continuous,average_value,float,No,No,No,No,The average value
covariates_continuous,standard_deviation,float,No,No,No,No,The standard devidation
covariates_continuous,median_value,float,No,No,No,No,The median value
covariates_continuous,p_10_value,float,No,No,No,No,The 10th percentile
covariates_continuous,p_25_value,float,No,No,No,No,The 25th percentile
covariates_continuous,p_75_value,float,No,No,No,No,The 75th percentile
covariates_continuous,p_90_value,float,No,No,No,No,The 90th percentile
settings,setting_id,varchar(30),Yes,Yes,No,No,The run identifier
settings,database_id,varchar(100),Yes,Yes,No,No,The database identifier
settings,covariate_setting_json,varchar,Yes,No,No,No,The covariate settings JSON
settings,case_covariate_setting_json,varchar,Yes,No,No,No,The during covariate settings JSON
settings,min_prior_observation,int,No,No,No,No,Minimum time observed before index
settings,outcome_washout_days,int,No,No,No,No,Patients with outcome during washout are excluded
settings,risk_window_start,int,No,No,No,No,The risk window start
settings,risk_window_end,int,No,No,No,No,The risk window end
settings,start_anchor,varchar(15),No,No,No,No,The start anchor
settings,end_anchor,varchar(15),No,No,No,No,The end anchor
settings,case_pre_target_duration,int,No,No,No,No,How far to look back before index for case features
settings,case_post_outcome_duration,int,No,No,No,No,How far to look forward after outcome for case features
cohort_details,database_id,varchar(100),Yes,Yes,No,No,The database identifier
cohort_details,setting_id,varchar(30),Yes,Yes,No,No,The run identifier
cohort_details,cohort_type,varchar(12),Yes,Yes,No,No,The cohort type
cohort_details,target_cohort_id,int,Yes,Yes,No,No,The target cohort id
cohort_details,outcome_cohort_id,int,Yes,Yes,No,No,The outcome cohort id
cohort_counts,database_id,varchar(100),Yes,No,No,No,The database identifier
cohort_counts,cohort_type,varchar(12),Yes,No,No,No,The cohort type
cohort_counts,target_cohort_id,int,Yes,No,No,No,The target cohort id
cohort_counts,outcome_cohort_id,int,Yes,No,No,No,The outcome cohort id
cohort_counts,risk_window_start,int,No,No,No,No,The risk window start
cohort_counts,risk_window_end,int,No,No,No,No,The risk window end
cohort_counts,start_anchor,varchar(15),No,No,No,No,The start anchor
cohort_counts,end_anchor,varchar(15),No,No,No,No,The end anchor
cohort_counts,min_prior_observation,int,No,No,No,No,Minimum time observed before index
cohort_counts,outcome_washout_days,int,No,No,No,No,Patients with outcome during washout are excluded
cohort_counts,row_count,bigint,Yes,No,No,No,The number of rows in each cohort
cohort_counts,person_count,bigint,Yes,No,No,No,The number of distinct people in each cohort
cohort_counts,min_exposure_time,bigint,No,No,No,No,Minimum exposure time across cohort in days
cohort_counts,mean_exposure_time,float,No,No,No,No,Mean exposure time across cohort in days
cohort_counts,max_exposure_time,bigint,No,No,No,No,Max exposure time across cohort in days
