2018-08 AD Adicionando Participantes faltantes no TOTVS mais 2.sql

select * from participantes where CHAPAAVALIADO = "060104";


insert into participantes (CODCOLIGADA, CODAVALIACAO, CODPARTICIPANTE, CODTIPOAVALIADOR, PESO, CONSENSUAL, 
CODCOLIGADAAVALIADO, CHAPAAVALIADO, CODCOLIGADAAVALIADOR, CHAPAAVALIADOR, FINALIZADA, CODPESSOA) values
(1, 40, 900000011, 1,1,0,1,"060185",1,"060109",1,1989),
(1, 41, 900000012, 1,1,0,1,"060185",1,"060109",1,1989),
(1, 42, 900000013, 1,1,0,1,"060185",1,"060109",1,1989),
(1, 43, 900000014, 1,1,0,1,"060185",1,"060109",1,1989),
(1, 44, 900000015, 1,1,0,1,"060185",1,"060109",1,1989);

insert into participantes (CODCOLIGADA, CODAVALIACAO, CODPARTICIPANTE, CODTIPOAVALIADOR, PESO, CONSENSUAL, 
CODCOLIGADAAVALIADO, CHAPAAVALIADO, CODCOLIGADAAVALIADOR, CHAPAAVALIADOR, FINALIZADA, CODPESSOA) values
(1, 40, 900000011, 1,1,0,1,"060202",1,"060109",1,2371),
(1, 41, 900000012, 1,1,0,1,"060202",1,"060109",1,2371),
(1, 42, 900000013, 1,1,0,1,"060202",1,"060109",1,2371),
(1, 43, 900000014, 1,1,0,1,"060202",1,"060109",1,2371),
(1, 44, 900000015, 1,1,0,1,"060202",1,"060109",1,2371);


select CODPESSOA from funcionarios where CHAPA = "060202"