UPDATE OR INSERT INTO VRH_BASE_TVERBAS_PADRAO (BDCODVERPD,BDAPEVERPD,BDDESCVERPD,BDDESCREDVERPD,BDCLAVERPD,BDREFVERPD,BDTIPOCODVERPD,BDINSSVERPD,BDFGTSVERPD,BDIRVERPD,BDTIPOREFVERPD,BDBASESFVERPD,BDPISVERPD,BDBASEHEVERPD,BDBASEMAIORVERPD,BDRAISVERPD,BDBASEGPSVERPD,BDMENORESVERPD,BDPROPVERPD,BDBASEVTVERPD,BDREEMBGPSVERPD,BDHEVERPD,BDGRAVAFICHAHNVERPD,BDCCPRINCIPALVERPD,BDFORMREFVERPD,BDFORMVALVERPD,BDBASEDSRHEVERPD,BDBASEDSRRVVERPD,BDFORMREFAUXVERPD,BDDEDFORMREFAUXVERPD,BDDEDFORMREFVERPD,BDDEDFORMVALVERPD,BDRENDISENTOIRVERPD,BDFORMINTVERPD,BDSITVERPD,BDPAGAESTOUROVERPD,BDSIMPLESNACIONALPD,BDBASE13HNPD,BDBASEFERHNPD,BDBASEAVHNPD,BDGARANTIAMINVERPD,BDSITMATVERPD,BDSITDOEVERPD,BDSITACITRABVERPD,BDSITMILITARVERPD,BDSITMATEMPVERPD,BDSITACITRAB15VERPD,BDSITDOETRABVERPD,BDSITLICVENCVERPD,BDSITDOE15VERPD,BDSITSINDICALVERPD,BDSITAPOINVVERPD,BDSITOUTRASPD,BDTIPOVERPD,BDINDRESCPD,BDULTALTPD,BDBASESALRAISPD,BDNAOCONVHORASVERPD) VALUES (243,'ADICNOTHORAS','Adicional noturno horas','Adic. noturno horas','0.002.0.2.002',190001,0,1,1,1,4,2,'TRUE','FALSE','FALSE','TRUE','TRUE','FALSE','FALSE','FALSE','FALSE','0','FALSE',null,null,'SALHORA * PERADICNOT * RF(243)',null,null,'PERADICTNOT * 100','FALSE','FALSE','FALSE','FALSE',null,0,'FALSE','FALSE','FALSE','FALSE','FALSE','FALSE','FALSE','FALSE','FALSE','FALSE','FALSE','FALSE','FALSE','FALSE','FALSE','FALSE','FALSE','FALSE',1,'FALSE','12/31/2015','FALSE','FALSE') MATCHING(BDCODVERPD, BDREFVERPD);
COMMIT WORK;
UPDATE VRH_BASE_TVERBAS_PADRAO SET BDULTALTPD = '12/31/2015';
COMMIT WORK;
