26/01/2021 04:22:59  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  CLASE->covensol_release MÉTODO->covensol_release_SAF_35_2015 ERROR->Invalid query: ERROR:  constraint "fk_saf_acti_saf_conse_saf_cons" of relation "saf_activo" does not exist
Whole query: 			   				
								CREATE TABLE saf_forma_adqact
								(
									codemp character varying(4) NOT NULL,
									claforadq character varying(2) NOT NULL,
									codforadq character varying(4) NOT NULL,
									denforadq character varying(50) NOT NULL,	
									CONSTRAINT pk_saf_forma_adqact PRIMARY KEY (codemp, codforadq)  
								)
								WITH (
								  OIDS=FALSE
								);
								ALTER TABLE saf_forma_adqact
								  OWNER TO postgres;
								INSERT INTO saf_forma_adqact (codemp, claforadq, codforadq, denforadq) VALUES('0001','B',lpad('1',4,'0'),'Compra Directa (por consulta de Precio)');
								INSERT INTO saf_forma_adqact (codemp, claforadq, codforadq, denforadq) VALUES('0001','G',lpad('2',4,'0'),'Permuta');
								INSERT INTO saf_forma_adqact (codemp, claforadq, codforadq, denforadq) VALUES('0001','D',lpad('3',4,'0'),'Dación en Pago');
								INSERT INTO saf_forma_adqact (codemp, claforadq, codforadq, denforadq) VALUES('0001','E',lpad('4',4,'0'),'Donación');
								INSERT INTO saf_forma_adqact (codemp, claforadq, codforadq, denforadq) VALUES('0001','H',lpad('5',4,'0'),'Transferencia');
								INSERT INTO saf_forma_adqact (codemp, claforadq, codforadq, denforadq) VALUES('0001','F',lpad('6',4,'0'),'Expropiación');
								INSERT INTO saf_forma_adqact (codemp, claforadq, codforadq, denforadq) VALUES('0001','C',lpad('7',4,'0'),'Confiscación');
								INSERT INTO saf_forma_adqact (codemp, claforadq, codforadq, denforadq) VALUES('0001','A',lpad('8',4,'0'),'Compra por Concurso Abierto');
								INSERT INTO saf_forma_adqact (codemp, claforadq, codforadq, denforadq) VALUES('0001','A',lpad('9',4,'0'),'Compra por Concurso Cerrado');
								INSERT INTO saf_forma_adqact (codemp, claforadq, codforadq, denforadq) VALUES('0001','I',lpad('10',4,'0'),'Adjudicación');
								
								
								
								CREATE TABLE saf_estatus_uso
								(
									codemp character varying(4) NOT NULL,
									codestuso character varying(4) NOT NULL,
									denestuso character varying(128) NOT NULL,	
									CONSTRAINT pk_saf_estatus_uso PRIMARY KEY (codemp, codestuso)  
								)
								WITH (
								  OIDS=FALSE
								);
								ALTER TABLE saf_estatus_uso
								  OWNER TO postgres;
								INSERT INTO saf_estatus_uso (codemp, codestuso, denestuso) VALUES('0001',lpad('1',4,'0'),'En uso');
								INSERT INTO saf_estatus_uso (codemp, codestuso, denestuso) VALUES('0001',lpad('2',4,'0'),'En comodato');
								INSERT INTO saf_estatus_uso (codemp, codestuso, denestuso) VALUES('0001',lpad('3',4,'0'),'En arrendamiento');
								INSERT INTO saf_estatus_uso (codemp, codestuso, denestuso) VALUES('0001',lpad('4',4,'0'),'En mantenimiento');
								INSERT INTO saf_estatus_uso (codemp, codestuso, denestuso) VALUES('0001',lpad('5',4,'0'),'En reparación');
								INSERT INTO saf_estatus_uso (codemp, codestuso, denestuso) VALUES('0001',lpad('6',4,'0'),'En proceso de disposición');
								INSERT INTO saf_estatus_uso (codemp, codestuso, denestuso) VALUES('0001',lpad('7',4,'0'),'En desuso por obsolescencia ');
								INSERT INTO saf_estatus_uso (codemp, codestuso, denestuso) VALUES('0001',lpad('8',4,'0'),'En desuso por  inservibilidad');
								INSERT INTO saf_estatus_uso (codemp, codestuso, denestuso) VALUES('0001',lpad('9',4,'0'),'En desuso por  obsolescencia e inservibilidad ');
								INSERT INTO saf_estatus_uso (codemp, codestuso, denestuso) VALUES('0001',lpad('10',4,'0'),'En Almacén o Depósito para su asignación');
								INSERT INTO saf_estatus_uso (codemp, codestuso, denestuso) VALUES('0001',lpad('11',4,'0'),'Otro uso');
								
								
								CREATE TABLE saf_colores
								(
									codemp character varying(4) NOT NULL,
									codcolor character varying(4) NOT NULL,
									dencolor character varying(128) NOT NULL,	
									CONSTRAINT pk_saf_colores PRIMARY KEY (codemp, codcolor)  
								)
								WITH (
								  OIDS=FALSE
								);
								ALTER TABLE saf_colores
								  OWNER TO postgres;
								INSERT INTO saf_colores (codemp, codcolor, dencolor) VALUES('0001',lpad('1',4,'0'),'NEGRO');
								INSERT INTO saf_colores (codemp, codcolor, dencolor) VALUES('0001',lpad('2',4,'0'),'AZUL');
								INSERT INTO saf_colores (codemp, codcolor, dencolor) VALUES('0001',lpad('3',4,'0'),'PALO ROSA');
								INSERT INTO saf_colores (codemp, codcolor, dencolor) VALUES('0001',lpad('4',4,'0'),'NARANJA');
								INSERT INTO saf_colores (codemp, codcolor, dencolor) VALUES('0001',lpad('5',4,'0'),'VERDE');
								INSERT INTO saf_colores (codemp, codcolor, dencolor) VALUES('0001',lpad('6',4,'0'),'BEIGE');
								INSERT INTO saf_colores (codemp, codcolor, dencolor) VALUES('0001',lpad('7',4,'0'),'CROMÁTICO');
								INSERT INTO saf_colores (codemp, codcolor, dencolor) VALUES('0001',lpad('8',4,'0'),'VINOTINTO');
								INSERT INTO saf_colores (codemp, codcolor, dencolor) VALUES('0001',lpad('9',4,'0'),'GRIS / NEGRO');
								INSERT INTO saf_colores (codemp, codcolor, dencolor) VALUES('0001',lpad('10',4,'0'),'PLATEADO');
								INSERT INTO saf_colores (codemp, codcolor, dencolor) VALUES('0001',lpad('11',4,'0'),'BEIGE AUSTRALIA');
								INSERT INTO saf_colores (codemp, codcolor, dencolor) VALUES('0001',lpad('12',4,'0'),'PLATEADO FERROSO');
								INSERT INTO saf_colores (codemp, codcolor, dencolor) VALUES('0001',lpad('13',4,'0'),'PERLA');
								INSERT INTO saf_colores (codemp, codcolor, dencolor) VALUES('0001',lpad('14',4,'0'),'BEIGE OLIMPICO');
								INSERT INTO saf_colores (codemp, codcolor, dencolor) VALUES('0001',lpad('15',4,'0'),'ARENA METALIZADO');
								INSERT INTO saf_colores (codemp, codcolor, dencolor) VALUES('0001',lpad('16',4,'0'),'PLATA');
								INSERT INTO saf_colores (codemp, codcolor, dencolor) VALUES('0001',lpad('17',4,'0'),'ROJO');
								INSERT INTO saf_colores (codemp, codcolor, dencolor) VALUES('0001',lpad('18',4,'0'),'AMARILLO');
								INSERT INTO saf_colores (codemp, codcolor, dencolor) VALUES('0001',lpad('19',4,'0'),'BEIGE DUNA');
								INSERT INTO saf_colores (codemp, codcolor, dencolor) VALUES('0001',lpad('20',4,'0'),'MARRÓN / NEGRO');
								INSERT INTO saf_colores (codemp, codcolor, dencolor) VALUES('0001',lpad('21',4,'0'),'AZUL / BEIGE');
								INSERT INTO saf_colores (codemp, codcolor, dencolor) VALUES('0001',lpad('22',4,'0'),'MARRÓN / BEIGE');
								INSERT INTO saf_colores (codemp, codcolor, dencolor) VALUES('0001',lpad('23',4,'0'),'VERDE ESMERALDA');
								INSERT INTO saf_colores (codemp, codcolor, dencolor) VALUES('0001',lpad('24',4,'0'),'PLATA CLARO');
								INSERT INTO saf_colores (codemp, codcolor, dencolor) VALUES('0001',lpad('25',4,'0'),'PLATEADO BRILLANTE');
								INSERT INTO saf_colores (codemp, codcolor, dencolor) VALUES('0001',lpad('26',4,'0'),'MARRÓN PARDILLO BICAPA');
								INSERT INTO saf_colores (codemp, codcolor, dencolor) VALUES('0001',lpad('27',4,'0'),'GRIS PALMERA');
								INSERT INTO saf_colores (codemp, codcolor, dencolor) VALUES('0001',lpad('28',4,'0'),'DORADO');
								INSERT INTO saf_colores (codemp, codcolor, dencolor) VALUES('0001',lpad('29',4,'0'),'MADERA NATURAL');
								INSERT INTO saf_colores (codemp, codcolor, dencolor) VALUES('0001',lpad('30',4,'0'),'NEGRO/AMARILLO MOSTAZA');
								INSERT INTO saf_colores (codemp, codcolor, dencolor) VALUES('0001',lpad('31',4,'0'),'MARRON');
								INSERT INTO saf_colores (codemp, codcolor, dencolor) VALUES('0001',lpad('32',4,'0'),'BLANCO');
								INSERT INTO saf_colores (codemp, codcolor, dencolor) VALUES('0001',lpad('33',4,'0'),'GRIS');
								INSERT INTO saf_colores (codemp, codcolor, dencolor) VALUES('0001',lpad('34',4,'0'),'AZUL / GRIS');
								INSERT INTO saf_colores (codemp, codcolor, dencolor) VALUES('0001',lpad('35',4,'0'),'AZUL / NEGRO');
								INSERT INTO saf_colores (codemp, codcolor, dencolor) VALUES('0001',lpad('36',4,'0'),'ACERO');
								INSERT INTO saf_colores (codemp, codcolor, dencolor) VALUES('0001',lpad('37',4,'0'),'OTRO COLOR');
								
								CREATE TABLE saf_tipos_vehiculo
								(
									codemp character varying(4) NOT NULL,
									codtipveh character varying(4) NOT NULL,
									dentipveh character varying(128) NOT NULL,	
									CONSTRAINT pk_saf_tipos_vehiculo PRIMARY KEY (codemp, codtipveh)  
								)
								WITH (
								  OIDS=FALSE
								);
								ALTER TABLE saf_tipos_vehiculo
								  OWNER TO postgres;
								  
								INSERT INTO saf_tipos_vehiculo (codemp, codtipveh, dentipveh) VALUES('0001',lpad('1',4,'0'),'Vehículos de transporte terrestre');
								INSERT INTO saf_tipos_vehiculo (codemp, codtipveh, dentipveh) VALUES('0001',lpad('2',4,'0'),'Vehículos de transporte marítimo');
								INSERT INTO saf_tipos_vehiculo (codemp, codtipveh, dentipveh) VALUES('0001',lpad('3',4,'0'),'Vehículos de transporte aéreo');
								INSERT INTO saf_tipos_vehiculo (codemp, codtipveh, dentipveh) VALUES('0001',lpad('4',4,'0'),'Otra clase');
								
								
								CREATE TABLE saf_tipos_animal
								(
									codemp character varying(4) NOT NULL,
									codtipani character varying(4) NOT NULL,
									dentipani character varying(128) NOT NULL,	
									CONSTRAINT pk_saf_tipos_animal PRIMARY KEY (codemp, codtipani)  
								)
								WITH (
								  OIDS=FALSE
								);
								ALTER TABLE saf_tipos_animal
								  OWNER TO postgres;
								INSERT INTO saf_tipos_animal (codemp, codtipani, dentipani) VALUES('0001',lpad('1',4,'0'),'Vacunos');
								INSERT INTO saf_tipos_animal (codemp, codtipani, dentipani) VALUES('0001',lpad('2',4,'0'),'Equinos');
								INSERT INTO saf_tipos_animal (codemp, codtipani, dentipani) VALUES('0001',lpad('3',4,'0'),'Caprinos');
								INSERT INTO saf_tipos_animal (codemp, codtipani, dentipani) VALUES('0001',lpad('4',4,'0'),'Porcinos');
								INSERT INTO saf_tipos_animal (codemp, codtipani, dentipani) VALUES('0001',lpad('5',4,'0'),'Aves');
								INSERT INTO saf_tipos_animal (codemp, codtipani, dentipani) VALUES('0001',lpad('6',4,'0'),'Búfalos');
								INSERT INTO saf_tipos_animal (codemp, codtipani, dentipani) VALUES('0001',lpad('7',4,'0'),'Peces');
								INSERT INTO saf_tipos_animal (codemp, codtipani, dentipani) VALUES('0001',lpad('8',4,'0'),'Otro tipo');
								
								CREATE TABLE saf_propositos_semovientes
								(
									codemp character varying(4) NOT NULL,
									codprosem character varying(4) NOT NULL,
									denprosem character varying(128) NOT NULL,	
									CONSTRAINT pk_saf_propositos_semovientes PRIMARY KEY (codemp, codprosem)  
								)
								WITH (
								  OIDS=FALSE
								);
								ALTER TABLE saf_propositos_semovientes
								  OWNER TO postgres;
								INSERT INTO saf_propositos_semovientes (codemp, codprosem, denprosem) VALUES('0001',lpad('1',4,'0'),'Engorde');
								INSERT INTO saf_propositos_semovientes (codemp, codprosem, denprosem) VALUES('0001',lpad('2',4,'0'),'Ordeño');
								INSERT INTO saf_propositos_semovientes (codemp, codprosem, denprosem) VALUES('0001',lpad('3',4,'0'),'Doble propósito');
								INSERT INTO saf_propositos_semovientes (codemp, codprosem, denprosem) VALUES('0001',lpad('4',4,'0'),'Cría');
								INSERT INTO saf_propositos_semovientes (codemp, codprosem, denprosem) VALUES('0001',lpad('5',4,'0'),'Científicos');
								INSERT INTO saf_propositos_semovientes (codemp, codprosem, denprosem) VALUES('0001',lpad('6',4,'0'),'Educativos');
								INSERT INTO saf_propositos_semovientes (codemp, codprosem, denprosem) VALUES('0001',lpad('7',4,'0'),'Otro propósito');
								
								CREATE TABLE saf_usos_edifterre
								(
									codemp character varying(4) NOT NULL,
									codusoedi character varying(4) NOT NULL,
									denusoedi character varying(128) NOT NULL,	
									CONSTRAINT pk_saf_usos_edifterre PRIMARY KEY (codemp, codusoedi)  
								)
								WITH (
								  OIDS=FALSE
								);
								ALTER TABLE saf_usos_edifterre
								  OWNER TO postgres;
								INSERT INTO saf_usos_edifterre (codemp, codusoedi, denusoedi) VALUES('0001',lpad('1',4,'0'),'Residencial');
								INSERT INTO saf_usos_edifterre (codemp, codusoedi, denusoedi) VALUES('0001',lpad('2',4,'0'),'Agrícola');
								INSERT INTO saf_usos_edifterre (codemp, codusoedi, denusoedi) VALUES('0001',lpad('3',4,'0'),'Turístico');
								INSERT INTO saf_usos_edifterre (codemp, codusoedi, denusoedi) VALUES('0001',lpad('4',4,'0'),'Comercial');
								INSERT INTO saf_usos_edifterre (codemp, codusoedi, denusoedi) VALUES('0001',lpad('5',4,'0'),'Educativo');
								INSERT INTO saf_usos_edifterre (codemp, codusoedi, denusoedi) VALUES('0001',lpad('6',4,'0'),'Asistencial');
								INSERT INTO saf_usos_edifterre (codemp, codusoedi, denusoedi) VALUES('0001',lpad('7',4,'0'),'De oficina');
								INSERT INTO saf_usos_edifterre (codemp, codusoedi, denusoedi) VALUES('0001',lpad('8',4,'0'),'Industrial');
								INSERT INTO saf_usos_edifterre (codemp, codusoedi, denusoedi) VALUES('0001',lpad('9',4,'0'),'Otro uso');
								
								
								ALTER TABLE saf_activo DROP CONSTRAINT fk_saf_acti_saf_conse_saf_cons;
								
								DELETE FROM saf_conservacionbien; 
								INSERT INTO saf_conservacionbien (codconbie, denconbie, desconbie) VALUES('01','Óptimo','');
								INSERT INTO saf_conservacionbien (codconbie, denconbie, desconbie) VALUES('02','Regular','');
								INSERT INTO saf_conservacionbien (codconbie, denconbie, desconbie) VALUES('03','Deteriorado','');
								INSERT INTO saf_conservacionbien (codconbie, denconbie, desconbie) VALUES('04','Averiado','');
								INSERT INTO saf_conservacionbien (codconbie, denconbie, desconbie) VALUES('05','Chatarra','');
								INSERT INTO saf_conservacionbien (codconbie, denconbie, desconbie) VALUES('06','No operativo','');
								INSERT INTO saf_conservacionbien (codconbie, denconbie, desconbie) VALUES('07','Otra condición física','');
								
								ALTER TABLE saf_activo
								  ADD CONSTRAINT fk_saf_acti_saf_conse_saf_cons FOREIGN KEY (codconbie)
									  REFERENCES saf_conservacionbien (codconbie) MATCH SIMPLE
									  ON UPDATE RESTRICT ON DELETE RESTRICT;
								
								
								CREATE TABLE saf_aseguradoras
								(
									codemp character varying(4) NOT NULL,
									codaseg character varying(4) NOT NULL,
									denaseg character varying(512) NOT NULL,	
									CONSTRAINT pk_saf_aseguradoras PRIMARY KEY (codemp, codaseg)  
								)
								WITH (
								  OIDS=FALSE
								);
								ALTER TABLE saf_aseguradoras
								  OWNER TO postgres;
								INSERT INTO saf_aseguradoras (codemp, codaseg, denaseg) VALUES('0001',lpad('1',4,'0'),'C.A. de Seguros Avila');
								INSERT INTO saf_aseguradoras (codemp, codaseg, denaseg) VALUES('0001',lpad('2',4,'0'),'C.N.A. de Seguros La Previsora');
								INSERT INTO saf_aseguradoras (codemp, codaseg, denaseg) VALUES('0001',lpad('3',4,'0'),'Mapfre La Seguridad C.A. de Seguros.');
								INSERT INTO saf_aseguradoras (codemp, codaseg, denaseg) VALUES('0001',lpad('4',4,'0'),'Seguros Caracas de Liberty Mutual, C.A.');
								INSERT INTO saf_aseguradoras (codemp, codaseg, denaseg) VALUES('0001',lpad('5',4,'0'),'Estar Seguros, S.A. (Antes Royal & Sun Alliance Seguros (Venezuela) S.A.)');
								INSERT INTO saf_aseguradoras (codemp, codaseg, denaseg) VALUES('0001',lpad('6',4,'0'),'Seguros Venezuela C.A.');
								INSERT INTO saf_aseguradoras (codemp, codaseg, denaseg) VALUES('0001',lpad('7',4,'0'),'Seguros Provincial C.A.');
								INSERT INTO saf_aseguradoras (codemp, codaseg, denaseg) VALUES('0001',lpad('8',4,'0'),'Adriática de Seguros, C.A');
								INSERT INTO saf_aseguradoras (codemp, codaseg, denaseg) VALUES('0001',lpad('9',4,'0'),'Seguros Carabobo, C.A.');
								INSERT INTO saf_aseguradoras (codemp, codaseg, denaseg) VALUES('0001',lpad('10',4,'0'),'La Venezolana de Seguros y de Vida, C.A.');
								INSERT INTO saf_aseguradoras (codemp, codaseg, denaseg) VALUES('0001',lpad('11',4,'0'),'Seguros Los Andes, C.A.');
								INSERT INTO saf_aseguradoras (codemp, codaseg, denaseg) VALUES('0001',lpad('12',4,'0'),'Seguros Nuevo Mundo S.A.');
								INSERT INTO saf_aseguradoras (codemp, codaseg, denaseg) VALUES('0001',lpad('13',4,'0'),'Seguros Horizonte, C.A.');
								INSERT INTO saf_aseguradoras (codemp, codaseg, denaseg) VALUES('0001',lpad('14',4,'0'),'C.A. de Seguros La Occidental');
								INSERT INTO saf_aseguradoras (codemp, codaseg, denaseg) VALUES('0001',lpad('15',4,'0'),'C.A. Seguros Catatumbo');
								INSERT INTO saf_aseguradoras (codemp, codaseg, denaseg) VALUES('0001',lpad('16',4,'0'),'Seguros La Fe C.A.');
								INSERT INTO saf_aseguradoras (codemp, codaseg, denaseg) VALUES('0001',lpad('17',4,'0'),'C.A. de Seguros American International');
								INSERT INTO saf_aseguradoras (codemp, codaseg, denaseg) VALUES('0001',lpad('18',4,'0'),'Seguros Virgen del Valle, C.A.');
								INSERT INTO saf_aseguradoras (codemp, codaseg, denaseg) VALUES('0001',lpad('19',4,'0'),'Seguros Federal, C.A. (Antes Seguros Federación C.A.)');
								INSERT INTO saf_aseguradoras (codemp, codaseg, denaseg) VALUES('0001',lpad('20',4,'0'),'La Mundial C.A. Venezolana de Seguros de Crédito');
								INSERT INTO saf_aseguradoras (codemp, codaseg, denaseg) VALUES('0001',lpad('21',4,'0'),'Mercantil Seguros , C.A.');
								INSERT INTO saf_aseguradoras (codemp, codaseg, denaseg) VALUES('0001',lpad('22',4,'0'),'C.A. Seguros Guayana');
								INSERT INTO saf_aseguradoras (codemp, codaseg, denaseg) VALUES('0001',lpad('23',4,'0'),'La Oriental de Seguros C.A.');
								INSERT INTO saf_aseguradoras (codemp, codaseg, denaseg) VALUES('0001',lpad('24',4,'0'),'Seguros Pirámide C.A.');
								INSERT INTO saf_aseguradoras (codemp, codaseg, denaseg) VALUES('0001',lpad('25',4,'0'),'Seguros Universitas, C.A. (Antes Universitas de Seguros C.A.)');
								INSERT INTO saf_aseguradoras (codemp, codaseg, denaseg) VALUES('0001',lpad('26',4,'0'),'Interbank Seguros S.A.');
								INSERT INTO saf_aseguradoras (codemp, codaseg, denaseg) VALUES('0001',lpad('27',4,'0'),'La Regional C.A. de Seguros');
								INSERT INTO saf_aseguradoras (codemp, codaseg, denaseg) VALUES('0001',lpad('28',4,'0'),'Multinacional de Seguros C.A.');
								INSERT INTO saf_aseguradoras (codemp, codaseg, denaseg) VALUES('0001',lpad('29',4,'0'),'Zuma Seguros, C.A. (Antes Seguros Bancentro S.A.)');
								INSERT INTO saf_aseguradoras (codemp, codaseg, denaseg) VALUES('0001',lpad('30',4,'0'),'Seguros Constitución C.A. (Antes Seguros Sofitasa)');
								INSERT INTO saf_aseguradoras (codemp, codaseg, denaseg) VALUES('0001',lpad('31',4,'0'),'Seguros Comerciales Bolívar S.A.');
								INSERT INTO saf_aseguradoras (codemp, codaseg, denaseg) VALUES('0001',lpad('32',4,'0'),'C.A. de Seguros La Internacional');
								INSERT INTO saf_aseguradoras (codemp, codaseg, denaseg) VALUES('0001',lpad('33',4,'0'),'Seguros Premier, C.A (antes Chubb de Venezuela). ');
								INSERT INTO saf_aseguradoras (codemp, codaseg, denaseg) VALUES('0001',lpad('34',4,'0'),'Seguros Comerciales Bolívar S.A.');
								INSERT INTO saf_aseguradoras (codemp, codaseg, denaseg) VALUES('0001',lpad('35',4,'0'),'C.A. de Seguros La Internacional');
								INSERT INTO saf_aseguradoras (codemp, codaseg, denaseg) VALUES('0001',lpad('36',4,'0'),'Seguros Premier, C.A (antes Chubb de Venezuela)');
								INSERT INTO saf_aseguradoras (codemp, codaseg, denaseg) VALUES('0001',lpad('37',4,'0'),'Seguros Corporativos C.A.');
								INSERT INTO saf_aseguradoras (codemp, codaseg, denaseg) VALUES('0001',lpad('38',4,'0'),'Seguros Banvalor C.A');
								INSERT INTO saf_aseguradoras (codemp, codaseg, denaseg) VALUES('0001',lpad('39',4,'0'),'Proseguros, S.A. (antes Rescarven)');
								INSERT INTO saf_aseguradoras (codemp, codaseg, denaseg) VALUES('0001',lpad('40',4,'0'),'Seguros Altamira C.A');
								INSERT INTO saf_aseguradoras (codemp, codaseg, denaseg) VALUES('0001',lpad('41',4,'0'),'Seguros Canarias de Venezuela C.A.');
								INSERT INTO saf_aseguradoras (codemp, codaseg, denaseg) VALUES('0001',lpad('42',4,'0'),'Banesco Seguros C.A.');
								INSERT INTO saf_aseguradoras (codemp, codaseg, denaseg) VALUES('0001',lpad('43',4,'0'),'Seguros Caroní C.A.');
								INSERT INTO saf_aseguradoras (codemp, codaseg, denaseg) VALUES('0001',lpad('44',4,'0'),'Universal de Seguros C.A.');
								INSERT INTO saf_aseguradoras (codemp, codaseg, denaseg) VALUES('0001',lpad('45',4,'0'),'Aseguradora Nacional Unida Uniseguros, S.A.');
								INSERT INTO saf_aseguradoras (codemp, codaseg, denaseg) VALUES('0001',lpad('46',4,'0'),'Hispana de Seguros C.A.');
								INSERT INTO saf_aseguradoras (codemp, codaseg, denaseg) VALUES('0001',lpad('47',4,'0'),'Primus Seguros, C.A.');
								INSERT INTO saf_aseguradoras (codemp, codaseg, denaseg) VALUES('0001',lpad('48',4,'0'),'Oceánica de Seguros, C.A (Antes Grupo Asegurador Previsional (Grasp), C.A.)');
								INSERT INTO saf_aseguradoras (codemp, codaseg, denaseg) VALUES('0001',lpad('49',4,'0'),'Seguros Qualitas C.A.');
								INSERT INTO saf_aseguradoras (codemp, codaseg, denaseg) VALUES('0001',lpad('50',4,'0'),'Seguros La Vitalicia, C.A.');
								INSERT INTO saf_aseguradoras (codemp, codaseg, denaseg) VALUES('0001',lpad('51',4,'0'),'Iberoamericana de Seguros, C.A.');
								INSERT INTO saf_aseguradoras (codemp, codaseg, denaseg) VALUES('0001',lpad('52',4,'0'),'ZURICH SEGUROS S.A.');
								INSERT INTO saf_aseguradoras (codemp, codaseg, denaseg) VALUES('0001',lpad('53',4,'0'),'Estar Seguros, S.A. (Antes Royal & Sun Alliance Seguros (Venezuela) S.A.)');
								INSERT INTO saf_aseguradoras (codemp, codaseg, denaseg) VALUES('0001',lpad('54',4,'0'),'Otra Compañía de Seguro');
								
								CREATE TABLE saf_tipocobertura
								(
									codemp character varying(4) NOT NULL,
									codtipcob character varying(4) NOT NULL,
									dentipcob character varying(512) NOT NULL,	
									CONSTRAINT pk_saf_tipocobertura PRIMARY KEY (codemp, codtipcob)  
								)
								WITH (
								  OIDS=FALSE
								);
								ALTER TABLE saf_tipocobertura
								  OWNER TO postgres;
								INSERT INTO saf_tipocobertura (codemp, codtipcob, dentipcob) VALUES('0001',lpad('1',4,'0'),'Total');
								INSERT INTO saf_tipocobertura (codemp, codtipcob, dentipcob) VALUES('0001',lpad('2',4,'0'),'Parcial');
								INSERT INTO saf_tipocobertura (codemp, codtipcob, dentipcob) VALUES('0001',lpad('3',4,'0'),'Otro tipo de cobertura');
								
								CREATE TABLE saf_tipolugares
								(
									codemp character varying(4) NOT NULL,
									codtiplug character varying(4) NOT NULL,
								
									dentiplug character varying(128) NOT NULL,	
									CONSTRAINT pk_saf_tipolugares PRIMARY KEY (codemp, codtiplug)  
								)
								WITH (
								  OIDS=FALSE
								);
								ALTER TABLE saf_tipolugares
								  OWNER TO postgres;
								INSERT INTO saf_tipolugares (codemp, codtiplug, dentiplug) VALUES('0001',lpad('1',2,'0'),'Sede Principal');
								INSERT INTO saf_tipolugares (codemp, codtiplug, dentiplug) VALUES('0001',lpad('2',2,'0'),'Puerto');
								INSERT INTO saf_tipolugares (codemp, codtiplug, dentiplug) VALUES('0001',lpad('3',2,'0'),'Aeropuerto');
								INSERT INTO saf_tipolugares (codemp, codtiplug, dentiplug) VALUES('0001',lpad('4',2,'0'),'Campamento');
								INSERT INTO saf_tipolugares (codemp, codtiplug, dentiplug) VALUES('0001',lpad('5',2,'0'),'Taller');
								INSERT INTO saf_tipolugares (codemp, codtiplug, dentiplug) VALUES('0001',lpad('6',2,'0'),'Almacén');
								INSERT INTO saf_tipolugares (codemp, codtiplug, dentiplug) VALUES('0001',lpad('7',2,'0'),'Galpón');
								INSERT INTO saf_tipolugares (codemp, codtiplug, dentiplug) VALUES('0001',lpad('8',2,'0'),'Otra Tipo de Sede o Lugar');
								
								CREATE TABLE saf_categorias_uniadm
								(
									codemp character varying(4) NOT NULL,
									codcatuni character varying(4) NOT NULL,
									dencatuni character varying(128) NOT NULL,	
									CONSTRAINT pk_saf_categorias_uniadm PRIMARY KEY (codemp, codcatuni)  
								)
								WITH (
								  OIDS=FALSE
								);
								ALTER TABLE saf_categorias_uniadm
								  OWNER TO postgres;
								INSERT INTO saf_categorias_uniadm (codemp, codcatuni, dencatuni) VALUES('0001',lpad('1',4,'0'),'Despacho del Presidente');
								INSERT INTO saf_categorias_uniadm (codemp, codcatuni, dencatuni) VALUES('0001',lpad('2',4,'0'),'Despacho del Vicepresidente');
								INSERT INTO saf_categorias_uniadm (codemp, codcatuni, dencatuni) VALUES('0001',lpad('3',4,'0'),'Despacho del Ministro');
								INSERT INTO saf_categorias_uniadm (codemp, codcatuni, dencatuni) VALUES('0001',lpad('4',4,'0'),'Despacho Viceministro');
								INSERT INTO saf_categorias_uniadm (codemp, codcatuni, dencatuni) VALUES('0001',lpad('5',4,'0'),'Dirección General');
								INSERT INTO saf_categorias_uniadm (codemp, codcatuni, dencatuni) VALUES('0001',lpad('6',4,'0'),'Dirección de Línea');
								INSERT INTO saf_categorias_uniadm (codemp, codcatuni, dencatuni) VALUES('0001',lpad('7',4,'0'),'Coordinación');
								INSERT INTO saf_categorias_uniadm (codemp, codcatuni, dencatuni) VALUES('0001',lpad('8',4,'0'),'División');
								INSERT INTO saf_categorias_uniadm (codemp, codcatuni, dencatuni) VALUES('0001',lpad('9',4,'0'),'Departamento');
								INSERT INTO saf_categorias_uniadm (codemp, codcatuni, dencatuni) VALUES('0001',lpad('10',4,'0'),'Presidencia');
								INSERT INTO saf_categorias_uniadm (codemp, codcatuni, dencatuni) VALUES('0001',lpad('11',4,'0'),'Gerencia General');
								INSERT INTO saf_categorias_uniadm (codemp, codcatuni, dencatuni) VALUES('0001',lpad('12',4,'0'),'Gerencia');
								INSERT INTO saf_categorias_uniadm (codemp, codcatuni, dencatuni) VALUES('0001',lpad('13',4,'0'),'Sub-Gerencia');
								INSERT INTO saf_categorias_uniadm (codemp, codcatuni, dencatuni) VALUES('0001',lpad('14',4,'0'),'Despacho del Superintendente');
								INSERT INTO saf_categorias_uniadm (codemp, codcatuni, dencatuni) VALUES('0001',lpad('15',4,'0'),'Dirección General Adjunta');
								INSERT INTO saf_categorias_uniadm (codemp, codcatuni, dencatuni) VALUES('0001',lpad('16',4,'0'),'Intendencia');
								INSERT INTO saf_categorias_uniadm (codemp, codcatuni, dencatuni) VALUES('0001',lpad('17',4,'0'),'Unidad Ad- Hoc');
								INSERT INTO saf_categorias_uniadm (codemp, codcatuni, dencatuni) VALUES('0001',lpad('18',4,'0'),'Área Organizacional');
								INSERT INTO saf_categorias_uniadm (codemp, codcatuni, dencatuni) VALUES('0001',lpad('19',4,'0'),'Área de Trabajo');
								INSERT INTO saf_categorias_uniadm (codemp, codcatuni, dencatuni) VALUES('0001',lpad('20',4,'0'),'Otra Categoría de Unidad');
								
								CREATE TABLE saf_raza
								(
									codemp character varying(4) NOT NULL,
									codraza character varying(4) NOT NULL,
									denraza character varying(128) NOT NULL,	
									CONSTRAINT pk_saf_raza PRIMARY KEY (codemp, codraza)  
								)
								WITH (
								  OIDS=FALSE
								);
								ALTER TABLE saf_raza
								  OWNER TO postgres;
								
								
								CREATE TABLE saf_genero
								(
									codemp character varying(4) NOT NULL,
									codgenero character varying(4) NOT NULL,
									dengenero character varying(128) NOT NULL,	
									CONSTRAINT pk_saf_genero PRIMARY KEY (codemp, codgenero)  
								)
								WITH (
								  OIDS=FALSE
								);
								ALTER TABLE saf_genero
								  OWNER TO postgres;
								INSERT INTO saf_genero (codemp, codgenero, dengenero) VALUES('0001','M','Masculino');
								INSERT INTO saf_genero (codemp, codgenero, dengenero) VALUES('0001','F','Femenino');
								
								
								CREATE TABLE saf_unimed
								(
									codemp character varying(4) NOT NULL,
									codunimed character varying(4) NOT NULL,
									denunimed character varying(128) NOT NULL,
									simbunimed character varying(10) NOT NULL,
									codtipunimed character varying(4) NOT NULL,	
									CONSTRAINT pk_saf_unimed PRIMARY KEY (codemp, codunimed)  
								)
								WITH (
								  OIDS=FALSE
								);
								ALTER TABLE saf_unimed
								  OWNER TO postgres;
								INSERT INTO saf_unimed (codemp, codunimed, denunimed, simbunimed, codtipunimed) VALUES('0001',lpad('1',4,'0'),'Hectárea','Ha','S');
								INSERT INTO saf_unimed (codemp, codunimed, denunimed, simbunimed, codtipunimed) VALUES('0001',lpad('2',4,'0'),'Kilómetro Cuadrado','km2','S');
								INSERT INTO saf_unimed (codemp, codunimed, denunimed, simbunimed, codtipunimed) VALUES('0001',lpad('3',4,'0'),'Metro Cuadrado','m2','S');
								INSERT INTO saf_unimed (codemp, codunimed, denunimed, simbunimed, codtipunimed) VALUES('0001',lpad('4',4,'0'),'Centímetro Cuadrado','cm2','S');
								INSERT INTO saf_unimed (codemp, codunimed, denunimed, simbunimed, codtipunimed) VALUES('0001',lpad('5',4,'0'),'Milímetro Cuadrado','mm2','S');
								INSERT INTO saf_unimed (codemp, codunimed, denunimed, simbunimed, codtipunimed) VALUES('0001',lpad('6',4,'0'),'Tonelada','ton','P');
								INSERT INTO saf_unimed (codemp, codunimed, denunimed, simbunimed, codtipunimed) VALUES('0001',lpad('7',4,'0'),'Kilogramo','kg','P');
								INSERT INTO saf_unimed (codemp, codunimed, denunimed, simbunimed, codtipunimed) VALUES('0001',lpad('8',4,'0'),'Gramo','gr','P');
								INSERT INTO saf_unimed (codemp, codunimed, denunimed, simbunimed, codtipunimed) VALUES('0001',lpad('9',4,'0'),'Libra','lb','P');
								INSERT INTO saf_unimed (codemp, codunimed, denunimed, simbunimed, codtipunimed) VALUES('0001',lpad('10',4,'0'),'Metro Cúbico','m3','V');
								INSERT INTO saf_unimed (codemp, codunimed, denunimed, simbunimed, codtipunimed) VALUES('0001',lpad('11',4,'0'),'Centímetro Cúbico','cm3','V');
								INSERT INTO saf_unimed (codemp, codunimed, denunimed, simbunimed, codtipunimed) VALUES('0001',lpad('12',4,'0'),'Litro','l','V');
								INSERT INTO saf_unimed (codemp, codunimed, denunimed, simbunimed, codtipunimed) VALUES('0001',lpad('13',4,'0'),'Mililitro','ml','V');
								INSERT INTO saf_unimed (codemp, codunimed, denunimed, simbunimed, codtipunimed) VALUES('0001',lpad('14',4,'0'),'Kilometro','km','D');
								INSERT INTO saf_unimed (codemp, codunimed, denunimed, simbunimed, codtipunimed) VALUES('0001',lpad('15',4,'0'),'Metro','m','D');
								INSERT INTO saf_unimed (codemp, codunimed, denunimed, simbunimed, codtipunimed) VALUES('0001',lpad('16',4,'0'),'Centímetro','cm','D');
								INSERT INTO saf_unimed (codemp, codunimed, denunimed, simbunimed, codtipunimed) VALUES('0001',lpad('17',4,'0'),'Milímetro','mm','D');
								INSERT INTO saf_unimed (codemp, codunimed, denunimed, simbunimed, codtipunimed) VALUES('0001',lpad('18',4,'0'),'Otra medida','otram','O');
								INSERT INTO saf_unimed (codemp, codunimed, denunimed, simbunimed, codtipunimed) VALUES('0001',lpad('1000',4,'0'),'Personas','Per','C');
								INSERT INTO saf_unimed (codemp, codunimed, denunimed, simbunimed, codtipunimed) VALUES('0001',lpad('1001',4,'0'),'Asientos','Asi','C');
								INSERT INTO saf_unimed (codemp, codunimed, denunimed, simbunimed, codtipunimed) VALUES('0001',lpad('1002',4,'0'),'Puestos','Pue','C');
								
								
								CREATE TABLE saf_unimed_garantia
								(
									codemp character varying(4) NOT NULL,
									codunimedgar character varying(4) NOT NULL,
									denunimedgar character varying(128) NOT NULL,
									simbunimedgar character varying(10) NOT NULL,	
									CONSTRAINT pk_saf_unimed_garantia PRIMARY KEY (codemp, codunimedgar)  
								)
								WITH (
								  OIDS=FALSE
								);
								ALTER TABLE saf_unimed_garantia
								  OWNER TO postgres;
								INSERT INTO saf_unimed_garantia (codemp, codunimedgar, denunimedgar, simbunimedgar) VALUES('0001',lpad('1',2,'0'),'Días','D');
								INSERT INTO saf_unimed_garantia (codemp, codunimedgar, denunimedgar, simbunimedgar) VALUES('0001',lpad('2',2,'0'),'Meses','M');
								INSERT INTO saf_unimed_garantia (codemp, codunimedgar, denunimedgar, simbunimedgar) VALUES('0001',lpad('3',2,'0'),'Años','A');