delete from TCOMANDOSMANTENIMIENTO where csubsistema='21' and ctransaccion='5020';

INSERT INTO TCOMANDOSMANTENIMIENTO (CSUBSISTEMA, CTRANSACCION, VERSIONTRANSACCION, SCOMANDO, EVENTO, COMANDO, ORDEN, USACACHE, TIPOCOMANDO, ACTIVADO, CANALESEXCLUIDOS, PARAMETRO, VERSIONCONTROL, EJECUTADOPOR) VALUES ('21', '5020', '01', 1, 'I', 'com.fitbank.payroll.maintenance.GenerateRDEPFile', 2, '0', 'MAN', '1', null, null, 13, 'F');
INSERT INTO TCOMANDOSMANTENIMIENTO (CSUBSISTEMA, CTRANSACCION, VERSIONTRANSACCION, SCOMANDO, EVENTO, COMANDO, ORDEN, USACACHE, TIPOCOMANDO, ACTIVADO, CANALESEXCLUIDOS, PARAMETRO, VERSIONCONTROL, EJECUTADOPOR) VALUES ('21', '5020', '01', 2, 'I', 'com.fitbank.payroll.maintenance.FillFileRDEP', 1, '0', 'MAN', '1', null, null, 14, 'F');


-- parametrizacion de la plantilla

 delete from tplantillaindices where cplantillareporte=4;
 delete from tplantillaindicesid where ctipoplantillareporte='RDEP';
 
--parametrizacion de la plantilla  TPLANTILLAINDICESID para la rdep
INSERT INTO TPLANTILLAINDICESID (CPERSONA_COMPANIA, CPLANTILLAREPORTE, ORDEN, CTIPOPLANTILLAREPORTE) VALUES (2, 4, 4, 'RDEP');
INSERT INTO TPLANTILLAINDICESID (CPERSONA_COMPANIA, CPLANTILLAREPORTE, ORDEN, CTIPOPLANTILLAREPORTE) VALUES (2, 4, 5, 'RDEP');
INSERT INTO TPLANTILLAINDICESID (CPERSONA_COMPANIA, CPLANTILLAREPORTE, ORDEN, CTIPOPLANTILLAREPORTE) VALUES (2, 4, 6, 'RDEP');
INSERT INTO TPLANTILLAINDICESID (CPERSONA_COMPANIA, CPLANTILLAREPORTE, ORDEN, CTIPOPLANTILLAREPORTE) VALUES (2, 4, 7, 'RDEP');
INSERT INTO TPLANTILLAINDICESID (CPERSONA_COMPANIA, CPLANTILLAREPORTE, ORDEN, CTIPOPLANTILLAREPORTE) VALUES (2, 4, 8, 'RDEP');
INSERT INTO TPLANTILLAINDICESID (CPERSONA_COMPANIA, CPLANTILLAREPORTE, ORDEN, CTIPOPLANTILLAREPORTE) VALUES (2, 4, 9, 'RDEP');
INSERT INTO TPLANTILLAINDICESID (CPERSONA_COMPANIA, CPLANTILLAREPORTE, ORDEN, CTIPOPLANTILLAREPORTE) VALUES (2, 4, 10, 'RDEP');
INSERT INTO TPLANTILLAINDICESID (CPERSONA_COMPANIA, CPLANTILLAREPORTE, ORDEN, CTIPOPLANTILLAREPORTE) VALUES (2, 4, 11, 'RDEP');
INSERT INTO TPLANTILLAINDICESID (CPERSONA_COMPANIA, CPLANTILLAREPORTE, ORDEN, CTIPOPLANTILLAREPORTE) VALUES (2, 4, 12, 'RDEP');
INSERT INTO TPLANTILLAINDICESID (CPERSONA_COMPANIA, CPLANTILLAREPORTE, ORDEN, CTIPOPLANTILLAREPORTE) VALUES (2, 4, 13, 'RDEP');
INSERT INTO TPLANTILLAINDICESID (CPERSONA_COMPANIA, CPLANTILLAREPORTE, ORDEN, CTIPOPLANTILLAREPORTE) VALUES (2, 4, 14, 'RDEP');
INSERT INTO TPLANTILLAINDICESID (CPERSONA_COMPANIA, CPLANTILLAREPORTE, ORDEN, CTIPOPLANTILLAREPORTE) VALUES (2, 4, 15, 'RDEP');
INSERT INTO TPLANTILLAINDICESID (CPERSONA_COMPANIA, CPLANTILLAREPORTE, ORDEN, CTIPOPLANTILLAREPORTE) VALUES (2, 4, 16, 'RDEP');
INSERT INTO TPLANTILLAINDICESID (CPERSONA_COMPANIA, CPLANTILLAREPORTE, ORDEN, CTIPOPLANTILLAREPORTE) VALUES (2, 4, 17, 'RDEP');
INSERT INTO TPLANTILLAINDICESID (CPERSONA_COMPANIA, CPLANTILLAREPORTE, ORDEN, CTIPOPLANTILLAREPORTE) VALUES (2, 4, 18, 'RDEP');
INSERT INTO TPLANTILLAINDICESID (CPERSONA_COMPANIA, CPLANTILLAREPORTE, ORDEN, CTIPOPLANTILLAREPORTE) VALUES (2, 4, 19, 'RDEP');
INSERT INTO TPLANTILLAINDICESID (CPERSONA_COMPANIA, CPLANTILLAREPORTE, ORDEN, CTIPOPLANTILLAREPORTE) VALUES (2, 4, 20, 'RDEP');
INSERT INTO TPLANTILLAINDICESID (CPERSONA_COMPANIA, CPLANTILLAREPORTE, ORDEN, CTIPOPLANTILLAREPORTE) VALUES (2, 4, 21, 'RDEP');
INSERT INTO TPLANTILLAINDICESID (CPERSONA_COMPANIA, CPLANTILLAREPORTE, ORDEN, CTIPOPLANTILLAREPORTE) VALUES (2, 4, 22, 'RDEP');
INSERT INTO TPLANTILLAINDICESID (CPERSONA_COMPANIA, CPLANTILLAREPORTE, ORDEN, CTIPOPLANTILLAREPORTE) VALUES (2, 4, 23, 'RDEP');
INSERT INTO TPLANTILLAINDICESID (CPERSONA_COMPANIA, CPLANTILLAREPORTE, ORDEN, CTIPOPLANTILLAREPORTE) VALUES (2, 4, 24, 'RDEP');
INSERT INTO TPLANTILLAINDICESID (CPERSONA_COMPANIA, CPLANTILLAREPORTE, ORDEN, CTIPOPLANTILLAREPORTE) VALUES (2, 4, 25, 'RDEP');
INSERT INTO TPLANTILLAINDICESID (CPERSONA_COMPANIA, CPLANTILLAREPORTE, ORDEN, CTIPOPLANTILLAREPORTE) VALUES (2, 4, 26, 'RDEP');
INSERT INTO TPLANTILLAINDICESID (CPERSONA_COMPANIA, CPLANTILLAREPORTE, ORDEN, CTIPOPLANTILLAREPORTE) VALUES (2, 4, 27, 'RDEP');
INSERT INTO TPLANTILLAINDICESID (CPERSONA_COMPANIA, CPLANTILLAREPORTE, ORDEN, CTIPOPLANTILLAREPORTE) VALUES (2, 4, 28, 'RDEP');
INSERT INTO TPLANTILLAINDICESID (CPERSONA_COMPANIA, CPLANTILLAREPORTE, ORDEN, CTIPOPLANTILLAREPORTE) VALUES (2, 4, 29, 'RDEP');
INSERT INTO TPLANTILLAINDICESID (CPERSONA_COMPANIA, CPLANTILLAREPORTE, ORDEN, CTIPOPLANTILLAREPORTE) VALUES (2, 4, 30, 'RDEP');
INSERT INTO TPLANTILLAINDICESID (CPERSONA_COMPANIA, CPLANTILLAREPORTE, ORDEN, CTIPOPLANTILLAREPORTE) VALUES (2, 4, 1, 'RDEP');
INSERT INTO TPLANTILLAINDICESID (CPERSONA_COMPANIA, CPLANTILLAREPORTE, ORDEN, CTIPOPLANTILLAREPORTE) VALUES (2, 4, 2, 'RDEP');
INSERT INTO TPLANTILLAINDICESID (CPERSONA_COMPANIA, CPLANTILLAREPORTE, ORDEN, CTIPOPLANTILLAREPORTE) VALUES (2, 4, 3, 'RDEP');
INSERT INTO TPLANTILLAINDICESID (CPERSONA_COMPANIA, CPLANTILLAREPORTE, ORDEN, CTIPOPLANTILLAREPORTE) VALUES (2, 4, 31, 'RDEP');
INSERT INTO TPLANTILLAINDICESID (CPERSONA_COMPANIA, CPLANTILLAREPORTE, ORDEN, CTIPOPLANTILLAREPORTE) VALUES (2, 4, 32, 'RDEP');
INSERT INTO TPLANTILLAINDICESID (CPERSONA_COMPANIA, CPLANTILLAREPORTE, ORDEN, CTIPOPLANTILLAREPORTE) VALUES (2, 4, 33, 'RDEP');
INSERT INTO TPLANTILLAINDICESID (CPERSONA_COMPANIA, CPLANTILLAREPORTE, ORDEN, CTIPOPLANTILLAREPORTE) VALUES (2, 4, 34, 'RDEP');
INSERT INTO TPLANTILLAINDICESID (CPERSONA_COMPANIA, CPLANTILLAREPORTE, ORDEN, CTIPOPLANTILLAREPORTE) VALUES (2, 4, 35, 'RDEP');
INSERT INTO TPLANTILLAINDICESID (CPERSONA_COMPANIA, CPLANTILLAREPORTE, ORDEN, CTIPOPLANTILLAREPORTE) VALUES (2, 4, 36, 'RDEP');
INSERT INTO TPLANTILLAINDICESID (CPERSONA_COMPANIA, CPLANTILLAREPORTE, ORDEN, CTIPOPLANTILLAREPORTE) VALUES (2, 4, 37, 'RDEP');
INSERT INTO TPLANTILLAINDICESID (CPERSONA_COMPANIA, CPLANTILLAREPORTE, ORDEN, CTIPOPLANTILLAREPORTE) VALUES (2, 4, 38, 'RDEP');
INSERT INTO TPLANTILLAINDICESID (CPERSONA_COMPANIA, CPLANTILLAREPORTE, ORDEN, CTIPOPLANTILLAREPORTE) VALUES (2, 4, 39, 'RDEP');

--parametrizacion de la tabla  TPLANTILLAINDICES  4

INSERT INTO TPLANTILLAINDICES (CPERSONA_COMPANIA, CPLANTILLAREPORTE, ORDEN, FHASTA, VERSIONCONTROL, FDESDE, LINEA, GRUPO, CONCEPTO, RESULTADO, FORMATO, OCULTAR, CONCEPTOCODIGO, PARTICIPACION) VALUES (2, 4, 1, TIMESTAMP '2999-12-31 00:00:00', 0, TIMESTAMP '2014-01-23 13:11:23', null, null, 'tipIdRet', '0', 'tipIdRet', '0', null, null);
INSERT INTO TPLANTILLAINDICES (CPERSONA_COMPANIA, CPLANTILLAREPORTE, ORDEN, FHASTA, VERSIONCONTROL, FDESDE, LINEA, GRUPO, CONCEPTO, RESULTADO, FORMATO, OCULTAR, CONCEPTOCODIGO, PARTICIPACION) VALUES (2, 4, 2, TIMESTAMP '2999-12-31 00:00:00', 0, TIMESTAMP '2014-01-23 13:11:23', null, null, 'idRet', '0', 'idRet', '0', null, null);
INSERT INTO TPLANTILLAINDICES (CPERSONA_COMPANIA, CPLANTILLAREPORTE, ORDEN, FHASTA, VERSIONCONTROL, FDESDE, LINEA, GRUPO, CONCEPTO, RESULTADO, FORMATO, OCULTAR, CONCEPTOCODIGO, PARTICIPACION) VALUES (2, 4, 3, TIMESTAMP '2999-12-31 00:00:00', 0, TIMESTAMP '2014-01-23 13:11:23', null, null, 'anioRet', '0', 'anioRet', '0', null, null);
INSERT INTO TPLANTILLAINDICES (CPERSONA_COMPANIA, CPLANTILLAREPORTE, ORDEN, FHASTA, VERSIONCONTROL, FDESDE, LINEA, GRUPO, CONCEPTO, RESULTADO, FORMATO, OCULTAR, CONCEPTOCODIGO, PARTICIPACION) VALUES (2, 4, 4, TIMESTAMP '2999-12-31 00:00:00', 0, TIMESTAMP '2014-01-23 13:11:23', null, null, 'nombretrab', '0', 'nombretrab', '0', null, null);
INSERT INTO TPLANTILLAINDICES (CPERSONA_COMPANIA, CPLANTILLAREPORTE, ORDEN, FHASTA, VERSIONCONTROL, FDESDE, LINEA, GRUPO, CONCEPTO, RESULTADO, FORMATO, OCULTAR, CONCEPTOCODIGO, PARTICIPACION) VALUES (2, 4, 5, TIMESTAMP '2999-12-31 00:00:00', 0, TIMESTAMP '2014-01-23 13:11:23', null, null, 'apellidotrab', '0', 'nombretrab', '0', null, null);
INSERT INTO TPLANTILLAINDICES (CPERSONA_COMPANIA, CPLANTILLAREPORTE, ORDEN, FHASTA, VERSIONCONTROL, FDESDE, LINEA, GRUPO, CONCEPTO, RESULTADO, FORMATO, OCULTAR, CONCEPTOCODIGO, PARTICIPACION) VALUES (2, 4, 6, TIMESTAMP '2999-12-31 00:00:00', 0, TIMESTAMP '2014-01-23 13:11:23', null, null, 'estab', '0', 'estab', '0', null, null);
INSERT INTO TPLANTILLAINDICES (CPERSONA_COMPANIA, CPLANTILLAREPORTE, ORDEN, FHASTA, VERSIONCONTROL, FDESDE, LINEA, GRUPO, CONCEPTO, RESULTADO, FORMATO, OCULTAR, CONCEPTOCODIGO, PARTICIPACION) VALUES (2, 4, 7, TIMESTAMP '2999-12-31 00:00:00', 0, TIMESTAMP '2014-01-23 13:11:23', null, null, 'residenciatrab', '0', 'suelSal', '0', null, null);
INSERT INTO TPLANTILLAINDICES (CPERSONA_COMPANIA, CPLANTILLAREPORTE, ORDEN, FHASTA, VERSIONCONTROL, FDESDE, LINEA, GRUPO, CONCEPTO, RESULTADO, FORMATO, OCULTAR, CONCEPTOCODIGO, PARTICIPACION) VALUES (2, 4, 8, TIMESTAMP '2999-12-31 00:00:00', 0, TIMESTAMP '2014-01-23 13:11:23', null, null, 'paisresidencia', '0', 'suelSal', '0', null, null);
INSERT INTO TPLANTILLAINDICES (CPERSONA_COMPANIA, CPLANTILLAREPORTE, ORDEN, FHASTA, VERSIONCONTROL, FDESDE, LINEA, GRUPO, CONCEPTO, RESULTADO, FORMATO, OCULTAR, CONCEPTOCODIGO, PARTICIPACION) VALUES (2, 4, 9, TIMESTAMP '2999-12-31 00:00:00', 0, TIMESTAMP '2014-01-23 13:11:23', null, null, 'aplicaconvenio', '0', 'suelSal', '0', null, null);
INSERT INTO TPLANTILLAINDICES (CPERSONA_COMPANIA, CPLANTILLAREPORTE, ORDEN, FHASTA, VERSIONCONTROL, FDESDE, LINEA, GRUPO, CONCEPTO, RESULTADO, FORMATO, OCULTAR, CONCEPTOCODIGO, PARTICIPACION) VALUES (2, 4, 10, TIMESTAMP '2999-12-31 00:00:00', 0, TIMESTAMP '2014-01-23 13:11:23', null, null, 'tipotrabajdiscap', '0', 'suelSal', '0', null, null);
INSERT INTO TPLANTILLAINDICES (CPERSONA_COMPANIA, CPLANTILLAREPORTE, ORDEN, FHASTA, VERSIONCONTROL, FDESDE, LINEA, GRUPO, CONCEPTO, RESULTADO, FORMATO, OCULTAR, CONCEPTOCODIGO, PARTICIPACION) VALUES (2, 4, 11, TIMESTAMP '2999-12-31 00:00:00', 0, TIMESTAMP '2014-01-23 13:11:23', null, null, 'porcentajediscap', '0', 'suelSal', '0', null, null);
INSERT INTO TPLANTILLAINDICES (CPERSONA_COMPANIA, CPLANTILLAREPORTE, ORDEN, FHASTA, VERSIONCONTROL, FDESDE, LINEA, GRUPO, CONCEPTO, RESULTADO, FORMATO, OCULTAR, CONCEPTOCODIGO, PARTICIPACION) VALUES (2, 4, 12, TIMESTAMP '2999-12-31 00:00:00', 0, TIMESTAMP '2014-01-23 13:11:23', null, null, 'tipIdDiscap', '0', 'suelSal', '0', null, null);
INSERT INTO TPLANTILLAINDICES (CPERSONA_COMPANIA, CPLANTILLAREPORTE, ORDEN, FHASTA, VERSIONCONTROL, FDESDE, LINEA, GRUPO, CONCEPTO, RESULTADO, FORMATO, OCULTAR, CONCEPTOCODIGO, PARTICIPACION) VALUES (2, 4, 13, TIMESTAMP '2999-12-31 00:00:00', 0, TIMESTAMP '2014-01-23 13:11:23', null, null, 'idDiscap', '0', 'suelSal', '0', null, null);
INSERT INTO TPLANTILLAINDICES (CPERSONA_COMPANIA, CPLANTILLAREPORTE, ORDEN, FHASTA, VERSIONCONTROL, FDESDE, LINEA, GRUPO, CONCEPTO, RESULTADO, FORMATO, OCULTAR, CONCEPTOCODIGO, PARTICIPACION) VALUES (2, 4, 14, TIMESTAMP '2999-12-31 00:00:00', 0, TIMESTAMP '2014-01-23 13:11:23', null, null, 'suelSal', '0', 'suelSal', '0', null, null);
INSERT INTO TPLANTILLAINDICES (CPERSONA_COMPANIA, CPLANTILLAREPORTE, ORDEN, FHASTA, VERSIONCONTROL, FDESDE, LINEA, GRUPO, CONCEPTO, RESULTADO, FORMATO, OCULTAR, CONCEPTOCODIGO, PARTICIPACION) VALUES (2, 4, 15, TIMESTAMP '2999-12-31 00:00:00', 0, TIMESTAMP '2014-01-23 13:11:23', null, null, 'sobSuelComRemu', '0', 'sobSuelComRemu', '0', null, null);
INSERT INTO TPLANTILLAINDICES (CPERSONA_COMPANIA, CPLANTILLAREPORTE, ORDEN, FHASTA, VERSIONCONTROL, FDESDE, LINEA, GRUPO, CONCEPTO, RESULTADO, FORMATO, OCULTAR, CONCEPTOCODIGO, PARTICIPACION) VALUES (2, 4, 16, TIMESTAMP '2999-12-31 00:00:00', 0, TIMESTAMP '2014-01-23 13:11:23', null, null, 'partUtil', '0', 'partUtil', '0', null, null);
INSERT INTO TPLANTILLAINDICES (CPERSONA_COMPANIA, CPLANTILLAREPORTE, ORDEN, FHASTA, VERSIONCONTROL, FDESDE, LINEA, GRUPO, CONCEPTO, RESULTADO, FORMATO, OCULTAR, CONCEPTOCODIGO, PARTICIPACION) VALUES (2, 4, 17, TIMESTAMP '2999-12-31 00:00:00', 0, TIMESTAMP '2014-01-23 13:11:23', null, null, 'intGrabGen', '0', 'intGrabGen', '0', null, null);
INSERT INTO TPLANTILLAINDICES (CPERSONA_COMPANIA, CPLANTILLAREPORTE, ORDEN, FHASTA, VERSIONCONTROL, FDESDE, LINEA, GRUPO, CONCEPTO, RESULTADO, FORMATO, OCULTAR, CONCEPTOCODIGO, PARTICIPACION) VALUES (2, 4, 18, TIMESTAMP '2999-12-31 00:00:00', 0, TIMESTAMP '2014-01-23 13:11:24', null, null, 'impRentEmpl', '0', 'impRentEmpl', '0', null, null);
INSERT INTO TPLANTILLAINDICES (CPERSONA_COMPANIA, CPLANTILLAREPORTE, ORDEN, FHASTA, VERSIONCONTROL, FDESDE, LINEA, GRUPO, CONCEPTO, RESULTADO, FORMATO, OCULTAR, CONCEPTOCODIGO, PARTICIPACION) VALUES (2, 4, 19, TIMESTAMP '2999-12-31 00:00:00', 0, TIMESTAMP '2014-01-23 13:11:24', null, null, 'decimTer', '0', 'decimTer', '0', null, null);
INSERT INTO TPLANTILLAINDICES (CPERSONA_COMPANIA, CPLANTILLAREPORTE, ORDEN, FHASTA, VERSIONCONTROL, FDESDE, LINEA, GRUPO, CONCEPTO, RESULTADO, FORMATO, OCULTAR, CONCEPTOCODIGO, PARTICIPACION) VALUES (2, 4, 20, TIMESTAMP '2999-12-31 00:00:00', 0, TIMESTAMP '2014-01-23 13:11:24', null, null, 'decimCuar', '0', 'decimCuar', '0', null, null);
INSERT INTO TPLANTILLAINDICES (CPERSONA_COMPANIA, CPLANTILLAREPORTE, ORDEN, FHASTA, VERSIONCONTROL, FDESDE, LINEA, GRUPO, CONCEPTO, RESULTADO, FORMATO, OCULTAR, CONCEPTOCODIGO, PARTICIPACION) VALUES (2, 4, 21, TIMESTAMP '2999-12-31 00:00:00', 0, TIMESTAMP '2014-01-23 13:11:24', null, null, 'fondoReserva', '0', 'fondoReserva', '0', null, null);
INSERT INTO TPLANTILLAINDICES (CPERSONA_COMPANIA, CPLANTILLAREPORTE, ORDEN, FHASTA, VERSIONCONTROL, FDESDE, LINEA, GRUPO, CONCEPTO, RESULTADO, FORMATO, OCULTAR, CONCEPTOCODIGO, PARTICIPACION) VALUES (2, 4, 22, TIMESTAMP '2999-12-31 00:00:00', 0, TIMESTAMP '2014-01-23 13:11:24', null, null, 'salarioDigno', '0', 'salarioDigno', '0', null, null);
INSERT INTO TPLANTILLAINDICES (CPERSONA_COMPANIA, CPLANTILLAREPORTE, ORDEN, FHASTA, VERSIONCONTROL, FDESDE, LINEA, GRUPO, CONCEPTO, RESULTADO, FORMATO, OCULTAR, CONCEPTOCODIGO, PARTICIPACION) VALUES (2, 4, 23, TIMESTAMP '2999-12-31 00:00:00', 0, TIMESTAMP '2014-01-23 13:11:24', null, null, 'otrosIngRenGrav', '0', 'otrosIngRenGrav', '0', null, null);
INSERT INTO TPLANTILLAINDICES (CPERSONA_COMPANIA, CPLANTILLAREPORTE, ORDEN, FHASTA, VERSIONCONTROL, FDESDE, LINEA, GRUPO, CONCEPTO, RESULTADO, FORMATO, OCULTAR, CONCEPTOCODIGO, PARTICIPACION) VALUES (2, 4, 24, TIMESTAMP '2999-12-31 00:00:00', 0, TIMESTAMP '2014-01-23 13:11:24', null, null, 'ingGravConEsteEmpl', '0', 'otrosIngRenGrav', '0', null, null);
INSERT INTO TPLANTILLAINDICES (CPERSONA_COMPANIA, CPLANTILLAREPORTE, ORDEN, FHASTA, VERSIONCONTROL, FDESDE, LINEA, GRUPO, CONCEPTO, RESULTADO, FORMATO, OCULTAR, CONCEPTOCODIGO, PARTICIPACION) VALUES (2, 4, 25, TIMESTAMP '2999-12-31 00:00:00', 0, TIMESTAMP '2014-01-23 13:11:24', null, null, 'sisSalNet', '0', 'sisSalNet', '0', null, null);
INSERT INTO TPLANTILLAINDICES (CPERSONA_COMPANIA, CPLANTILLAREPORTE, ORDEN, FHASTA, VERSIONCONTROL, FDESDE, LINEA, GRUPO, CONCEPTO, RESULTADO, FORMATO, OCULTAR, CONCEPTOCODIGO, PARTICIPACION) VALUES (2, 4, 26, TIMESTAMP '2999-12-31 00:00:00', 0, TIMESTAMP '2014-01-23 13:11:24', null, null, 'apoPerIess', '0', 'apoPerIess', '0', null, null);
INSERT INTO TPLANTILLAINDICES (CPERSONA_COMPANIA, CPLANTILLAREPORTE, ORDEN, FHASTA, VERSIONCONTROL, FDESDE, LINEA, GRUPO, CONCEPTO, RESULTADO, FORMATO, OCULTAR, CONCEPTOCODIGO, PARTICIPACION) VALUES (2, 4, 27, TIMESTAMP '2999-12-31 00:00:00', 0, TIMESTAMP '2014-01-23 13:11:24', null, null, 'aporPerIessConOtrosEmpls', '0', 'aporPerIessConOtrosEmpls', '0', null, null);
INSERT INTO TPLANTILLAINDICES (CPERSONA_COMPANIA, CPLANTILLAREPORTE, ORDEN, FHASTA, VERSIONCONTROL, FDESDE, LINEA, GRUPO, CONCEPTO, RESULTADO, FORMATO, OCULTAR, CONCEPTOCODIGO, PARTICIPACION) VALUES (2, 4, 28, TIMESTAMP '2999-12-31 00:00:00', 0, TIMESTAMP '2014-01-23 13:11:24', null, null, 'deducVivienda', '0', 'deducVivienda', '0', null, null);
INSERT INTO TPLANTILLAINDICES (CPERSONA_COMPANIA, CPLANTILLAREPORTE, ORDEN, FHASTA, VERSIONCONTROL, FDESDE, LINEA, GRUPO, CONCEPTO, RESULTADO, FORMATO, OCULTAR, CONCEPTOCODIGO, PARTICIPACION) VALUES (2, 4, 29, TIMESTAMP '2999-12-31 00:00:00', 0, TIMESTAMP '2014-01-23 13:11:24', null, null, 'deducSalud', '0', 'deducSalud', '0', null, null);
INSERT INTO TPLANTILLAINDICES (CPERSONA_COMPANIA, CPLANTILLAREPORTE, ORDEN, FHASTA, VERSIONCONTROL, FDESDE, LINEA, GRUPO, CONCEPTO, RESULTADO, FORMATO, OCULTAR, CONCEPTOCODIGO, PARTICIPACION) VALUES (2, 4, 30, TIMESTAMP '2999-12-31 00:00:00', 0, TIMESTAMP '2014-01-23 13:11:24', null, null, 'deducEduca', '0', 'deducEduca', '0', null, null);
INSERT INTO TPLANTILLAINDICES (CPERSONA_COMPANIA, CPLANTILLAREPORTE, ORDEN, FHASTA, VERSIONCONTROL, FDESDE, LINEA, GRUPO, CONCEPTO, RESULTADO, FORMATO, OCULTAR, CONCEPTOCODIGO, PARTICIPACION) VALUES (2, 4, 31, TIMESTAMP '2999-12-31 00:00:00', 0, TIMESTAMP '2014-01-23 13:11:24', null, null, 'deducAliement', '0', 'deducAliement', '0', null, null);
INSERT INTO TPLANTILLAINDICES (CPERSONA_COMPANIA, CPLANTILLAREPORTE, ORDEN, FHASTA, VERSIONCONTROL, FDESDE, LINEA, GRUPO, CONCEPTO, RESULTADO, FORMATO, OCULTAR, CONCEPTOCODIGO, PARTICIPACION) VALUES (2, 4, 32, TIMESTAMP '2999-12-31 00:00:00', 0, TIMESTAMP '2014-01-23 13:11:25', null, null, 'deducVestim', '0', 'deducVestim', '0', null, null);
INSERT INTO TPLANTILLAINDICES (CPERSONA_COMPANIA, CPLANTILLAREPORTE, ORDEN, FHASTA, VERSIONCONTROL, FDESDE, LINEA, GRUPO, CONCEPTO, RESULTADO, FORMATO, OCULTAR, CONCEPTOCODIGO, PARTICIPACION) VALUES (2, 4, 33, TIMESTAMP '2999-12-31 00:00:00', 0, TIMESTAMP '2014-01-23 13:11:25', null, null, 'exoDiscap', '0', 'exoDiscap', '0', null, null);
INSERT INTO TPLANTILLAINDICES (CPERSONA_COMPANIA, CPLANTILLAREPORTE, ORDEN, FHASTA, VERSIONCONTROL, FDESDE, LINEA, GRUPO, CONCEPTO, RESULTADO, FORMATO, OCULTAR, CONCEPTOCODIGO, PARTICIPACION) VALUES (2, 4, 34, TIMESTAMP '2999-12-31 00:00:00', 0, TIMESTAMP '2014-01-23 13:11:25', null, null, 'exoTerEd', '0', 'exoTerEd', '0', null, null);
INSERT INTO TPLANTILLAINDICES (CPERSONA_COMPANIA, CPLANTILLAREPORTE, ORDEN, FHASTA, VERSIONCONTROL, FDESDE, LINEA, GRUPO, CONCEPTO, RESULTADO, FORMATO, OCULTAR, CONCEPTOCODIGO, PARTICIPACION) VALUES (2, 4, 35, TIMESTAMP '2999-12-31 00:00:00', 0, TIMESTAMP '2014-01-23 13:11:25', null, null, 'basImp', '0', 'basImp', '0', null, null);
INSERT INTO TPLANTILLAINDICES (CPERSONA_COMPANIA, CPLANTILLAREPORTE, ORDEN, FHASTA, VERSIONCONTROL, FDESDE, LINEA, GRUPO, CONCEPTO, RESULTADO, FORMATO, OCULTAR, CONCEPTOCODIGO, PARTICIPACION) VALUES (2, 4, 36, TIMESTAMP '2999-12-31 00:00:00', 0, TIMESTAMP '2014-01-23 13:11:25', null, null, 'impRentCaus', '0', 'impRentCaus', '0', null, null);
INSERT INTO TPLANTILLAINDICES (CPERSONA_COMPANIA, CPLANTILLAREPORTE, ORDEN, FHASTA, VERSIONCONTROL, FDESDE, LINEA, GRUPO, CONCEPTO, RESULTADO, FORMATO, OCULTAR, CONCEPTOCODIGO, PARTICIPACION) VALUES (2, 4, 37, TIMESTAMP '2999-12-31 00:00:00', 0, TIMESTAMP '2014-01-23 13:11:25', null, null, 'valRetAsuOtrosEmpls', '0', 'valRetAsuOtrosEmpls', '0', null, null);
INSERT INTO TPLANTILLAINDICES (CPERSONA_COMPANIA, CPLANTILLAREPORTE, ORDEN, FHASTA, VERSIONCONTROL, FDESDE, LINEA, GRUPO, CONCEPTO, RESULTADO, FORMATO, OCULTAR, CONCEPTOCODIGO, PARTICIPACION) VALUES (2, 4, 38, TIMESTAMP '2999-12-31 00:00:00', 0, TIMESTAMP '2014-01-23 13:11:25', null, null, 'valImpAsuEsteEmpl', '0', 'valImpAsuEsteEmpl', '0', null, null);
INSERT INTO TPLANTILLAINDICES (CPERSONA_COMPANIA, CPLANTILLAREPORTE, ORDEN, FHASTA, VERSIONCONTROL, FDESDE, LINEA, GRUPO, CONCEPTO, RESULTADO, FORMATO, OCULTAR, CONCEPTOCODIGO, PARTICIPACION) VALUES (2, 4, 39, TIMESTAMP '2999-12-31 00:00:00', 0, TIMESTAMP '2014-01-23 13:11:25', null, null, 'valRet', '0', 'valRet', '0', null, null);