 -- -------------------------------------------------------------------
 
 -- Do not set locks, allow dirty reads.
-/*
 SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
 
 INSERT INTO cdm.src_clean

    unit_id                     varchar(50),
    filter                      smallint
);
*/
-- -------------------------------------------------------------------
-- Rules all together
-- Takes data from source tables and puts together participant_id

        cdm.src_clean.question_ppi_code = cdm.combined_question_filter.question_ppi_code
SET cdm.src_clean.filter = 1
WHERE TRUE;

-- -------------------------------------------------------------------
-- source_file: src/src_mapped.sql
-- -------------------------------------------------------------------
