09/02/2021 01:09:27  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  <b>CLASE:</b> covensol_cxc_cuentasxcobrar <br><b>METODO:</b> ConsultaCmpVentaBoletos <br><b>ERROR-></b><br>Invalid query: ERROR:  syntax error at or near ","
LINE 108:                        /*scg_venta_boleto AS sc_cuenta*/, 
                                                                  ^
Whole query:    	
						
								SELECT infoscg.sc_cuenta,MAX(denominacion) AS denominacion,
								       SUM(infoscg.monto::numeric) AS monto,
									   SUM(infoscg.monto_ext::numeric) AS monto_ext,
									   'H' AS debhab
								 FROM ( 
									SELECT 
										 CASE WHEN id_tipodetalle='ARTIC' THEN spia.sc_cuenta
										  WHEN id_tipodetalle='SERVI' THEN spis.sc_cuenta
										  WHEN id_tipodetalle='CONCE' THEN scgc.scg_cuenta    
										  ELSE ''
										  END AS sc_cuenta,
										  sum(precioneto_detalle*cantidad_detalle)  as monto,
										  sum((precioneto_detalle/f.tascam)*cantidad_detalle)  as monto_ext	
									 FROM cxc_detalle d	
									 INNER JOIN cxc_factura f ON f.id_fact = d.id_fact
												             AND f.codproceso = d.codproceso 
									 LEFT JOIN siv_articulo a ON a.codart=d.coddetalle 
												             AND f.codemp = a.codemp 
												             AND d.id_tipodetalle = 'ARTIC' 
									 LEFT JOIN spi_cuentas spia ON spia.spi_cuenta = a.spi_cuenta										                          
									 LEFT JOIN spi_cuentas_estructuras cea ON spia.codemp = cea.codemp
														   AND spia.spi_cuenta = cea.spi_cuenta
													   AND d.estcla = cea.estcla																   
													   AND d.codestpro1 = cea.codestpro1
													   AND d.codestpro2 = cea.codestpro2
													   AND d.codestpro3 = cea.codestpro3
													   AND d.codestpro4 = cea.codestpro4
													   AND d.codestpro5 = cea.codestpro5
									 LEFT JOIN soc_servicios s ON s.codser=d.coddetalle 
												  AND d.id_tipodetalle = 'SERVI'
									 LEFT JOIN spi_cuentas spis ON spis.spi_cuenta = s.spg_cuenta										                         
									 LEFT JOIN spi_cuentas_estructuras ces ON spis.codemp = ces.codemp
														  AND spis.spi_cuenta = ces.spi_cuenta 
													  AND d.estcla = ces.estcla																  
													  AND d.codestpro1 = ces.codestpro1
													  AND d.codestpro2 = ces.codestpro2
													  AND d.codestpro3 = ces.codestpro3
													  AND d.codestpro4 = ces.codestpro4
													  AND d.codestpro5 = ces.codestpro5
									 LEFT JOIN soc_tiposervicio ts ON s.codtipser=ts.codtipser
									 LEFT JOIN cxc_conceptofac scgc ON scgc.codconfac=d.coddetalle 
													   AND d.id_tipodetalle = 'CONCE' 										
									 WHERE (nro_ticket!='' or nro_ticket is not null)
									 AND d.codproceso='FACTURA' 
									 AND EXTRACT(YEAR FROM f.fecfact) = '2020'
									 AND EXTRACT(MONTH FROM f.fecfact) = '01'
									 AND f.codemisor = 'VE178590'
									 AND (servboleto=0 OR id_tipodetalle='CONCE' OR id_tipodetalle='ARTIC')
									 AND (cmp_contab='' or cmp_contab is null)
									 AND contabilizado='0'
									  AND EXTRACT(DAY FROM f.fecfact) = '08'  AND f.codmon = 'USD' 
									 GROUP BY 1
									 UNION
									 SELECT sc_cuenta,
										   sum(monto) as monto,
										   sum(monto_ext) as monto_ext
									 FROM
									 (
												 SELECT 
													  CASE WHEN aero_tipo='INT' THEN '213010100000002'
														   ELSE '213010100000001'
													  END AS sc_cuenta,
													  /*scg_venta_boleto AS sc_cuenta,*/
													  sum(precioneto_detalle*cantidad_detalle)  as monto,
													  sum((precioneto_detalle/f.tascam)*cantidad_detalle)  as monto_ext 	
												 FROM cxc_detalle d	
												 INNER JOIN cxc_factura f ON f.id_fact = d.id_fact
																		 AND f.codproceso = d.codproceso
												 /*
												 LEFT JOIN cxc_ingresos i ON f.id_fact = i.id_fact_ticket
												 */						  
												 INNER JOIN soc_servicios s ON s.codser=d.coddetalle 
																		   AND d.id_tipodetalle = 'SERVI'
												 INNER JOIN soc_tiposervicio ts ON s.codtipser=ts.codtipser
												 LEFT JOIN spi_cuentas spis ON spis.spi_cuenta = s.spg_cuenta										                         
												 LEFT JOIN spi_cuentas_estructuras ces ON spis.codemp = ces.codemp
																  AND spis.spi_cuenta = ces.spi_cuenta 
																  AND d.estcla = ces.estcla																  
																  AND d.codestpro1 = ces.codestpro1
																  AND d.codestpro2 = ces.codestpro2
																  AND d.codestpro3 = ces.codestpro3
																  AND d.codestpro4 = ces.codestpro4
																  AND d.codestpro5 = ces.codestpro5
												 WHERE (nro_ticket!='' or nro_ticket is not null)
												 AND d.codproceso='FACTURA' 
												 AND d.id_tipodetalle = 'SERVI'
												 AND EXTRACT(YEAR FROM f.fecfact) = '2020'
												 AND EXTRACT(MONTH FROM f.fecfact) = '01'
												 AND f.codemisor = 'VE178590'
												 AND servboleto=1  
												 AND servboleto IS NOT NULL
												 AND (cmp_contab='' or cmp_contab is null)
												 AND contabilizado='0' 									 
												  AND EXTRACT(DAY FROM f.fecfact) = '08'  AND f.codmon = 'USD' 
												 GROUP BY 1
												 UNION
												 
												SELECT  sc_cuenta AS sc_cuenta, 
														sum( -i.moning ) as monto, 
														sum( -(i.moning/fac.tascam) ) as monto_ext    
												FROM
													(	 
															 SELECT CASE WHEN aero_tipo='INT' THEN '213010100000002'
																		 ELSE '213010100000001'
																	END AS sc_cuenta,
															        /*scg_venta_boleto AS sc_cuenta*/, 
																	f.id_fact AS id_fact,
																	MAX(f.codproceso) AS codproceso
															 FROM cxc_detalle d	
															 INNER JOIN cxc_factura f ON f.id_fact = d.id_fact
																					 AND f.codproceso = d.codproceso
															 LEFT JOIN cxc_ingresos i ON f.id_fact = i.id_fact_ticket						  
															 INNER JOIN soc_servicios s ON s.codser=d.coddetalle 
																					   AND d.id_tipodetalle = 'SERVI'
															 INNER JOIN soc_tiposervicio ts ON s.codtipser=ts.codtipser
															 LEFT JOIN spi_cuentas spis ON spis.spi_cuenta = s.spg_cuenta										                         
															 LEFT JOIN spi_cuentas_estructuras ces ON spis.codemp = ces.codemp
																				  AND spis.spi_cuenta = ces.spi_cuenta 
																			  AND d.estcla = ces.estcla																  
																			  AND d.codestpro1 = ces.codestpro1
																			  AND d.codestpro2 = ces.codestpro2
																			  AND d.codestpro3 = ces.codestpro3
																			  AND d.codestpro4 = ces.codestpro4
																			  AND d.codestpro5 = ces.codestpro5
															 WHERE (nro_ticket!='' or nro_ticket is not null)
															 AND d.codproceso='FACTURA' 
															 AND d.id_tipodetalle = 'SERVI'
															 AND EXTRACT(YEAR FROM f.fecfact) = '2020'
															 AND EXTRACT(MONTH FROM f.fecfact) = '01'
															 AND f.codemisor = 'VE178590'
															 AND servboleto=1  
															 AND servboleto IS NOT NULL
															 AND (cmp_contab='' or cmp_contab is null)
															 AND contabilizado='0' 
															 AND i.codforpag IN ('TS','MSMI')									 
															  AND EXTRACT(DAY FROM f.fecfact) = '08'  AND f.codmon = 'USD' 
															 GROUP BY 1,2
												 ) AS ven
												INNER JOIN cxc_factura fac ON fac.id_fact = ven.id_fact AND fac.codproceso = ven.codproceso 
												INNER JOIN cxc_ingresos i ON ven.id_fact = i.id_fact_ticket
												GROUP BY 1
												 
										 ) AS SCG
										GROUP BY 1
										 UNION
										 SELECT						 
										CASE WHEN id_tipodetalle='ARTIC' THEN ac.scg_cuenta
											 WHEN id_tipodetalle='SERVI' THEN sc.scg_cuenta     
											 ELSE ''
											 END AS sc_cuenta,					 
										 CASE WHEN id_tipodetalle='ARTIC' THEN  SUM(iva_detalle)
											  WHEN id_tipodetalle='SERVI' THEN  SUM(iva_detalle) 
										 ELSE 0
										 END AS monto,
										 CASE WHEN id_tipodetalle='ARTIC' THEN  SUM(iva_detalle/f.tascam)
											  WHEN id_tipodetalle='SERVI' THEN  SUM(iva_detalle/f.tascam) 
										 ELSE 0
										 END AS monto_ext
									 FROM cxc_detalle d 
									 INNER JOIN cxc_factura f ON f.id_fact = d.id_fact 
												AND f.codproceso = d.codproceso
									 LEFT JOIN siv_articulo a ON a.codart=d.coddetalle 
												 AND f.codemp = a.codemp 
												 AND d.id_tipodetalle = 'ARTIC'	
									 LEFT JOIN siv_cargosarticulo ca ON ca.codart = a.codart		
									 LEFT JOIN sigesp_cargos ac ON ac.codcar = ca.codcar AND ac.codemp = ca.codemp	
									 LEFT JOIN spi_cuentas spia ON spia.spi_cuenta = ac.spicta
									 LEFT JOIN soc_servicios s ON s.codser=d.coddetalle 
												  AND d.id_tipodetalle = 'SERVI'										
									 LEFT JOIN soc_serviciocargo cs ON cs.codser = s.codser		
									 LEFT JOIN sigesp_cargos sc ON sc.codcar = cs.codcar AND cs.codemp = sc.codemp	
									 LEFT JOIN spi_cuentas spis ON spis.spi_cuenta = sc.spicta					
									 LEFT JOIN soc_tiposervicio ts ON s.codtipser=ts.codtipser 										
									 WHERE (nro_ticket!='' or nro_ticket is not null)
									 AND d.codproceso='FACTURA' 
									 AND EXTRACT(YEAR FROM f.fecfact) = '2020'
									 AND EXTRACT(MONTH FROM f.fecfact) = '01'
									 AND f.codemisor = 'VE178590'
									 AND iva_detalle>0
									 AND (cmp_contab='' or cmp_contab is null)
									 AND contabilizado='0'									 
									  AND EXTRACT(DAY FROM f.fecfact) = '08'  AND f.codmon = 'USD' 
									 GROUP BY 1,id_tipodetalle
									 ORDER BY 1
								 ) infoscg
								INNER JOIN scg_cuentas scg ON INFOSCG.sc_cuenta = scg.sc_cuenta
								 GROUP BY 1 
								UNION
								SELECT infoscg.sc_cuenta, 
								       MAX(denominacion) AS denominacion, 
									   round(sum(total::numeric),2) AS monto,
									   round(sum(total_ext::numeric),2) AS monto_ext,
									   'D' AS debhab
								FROM
								(
									SELECT f.codemisor,
										   e.denemisor,	      
										   MAX(caj.scg_cuenta) as sc_cuenta,
										   /*sum(d.neto_detalle) AS total,
										   sum(d.neto_detalle/f.tascam) AS total_ext,*/
										   sum(i.moning) AS total,
										   sum(i.moning/i.tascam) AS total_ext,											   
										   count(*) AS numbol
									FROM cxc_factura f 
									INNER JOIN cxc_ingresos i ON f.id_fact = i.id_fact_ticket
									/*
									INNER JOIN cxc_detalle d ON f.id_fact = d.id_fact 
															AND f.codproceso = d.codproceso
									*/
									LEFT JOIN aero_emisores e ON e.codemisor = f.codemisor
									LEFT JOIN cxc_sucursales suc ON suc.codemp = f.codemp 
																AND suc.codsuc = f.codsuc
									LEFT JOIN cxc_cajas caj ON caj.codemp = f.codemp 
														   AND caj.codsuc = f.codsuc
														   AND caj.codcaj = f.codcaj
									WHERE (nro_ticket!='' or nro_ticket is not null)
									AND (cmp_contab='' or cmp_contab is null)
									AND contabilizado='0'
									AND (fecconta='1900-01-01' OR fecconta is null)
									AND EXTRACT(YEAR FROM f.fecfact) = '2020'
									AND EXTRACT(MONTH FROM f.fecfact) = '01'
									AND f.codemisor = 'VE178590'
									/*AND f.tipopecont = 'DC'*/
									AND i.codforpag NOT IN ('MSMI','TS')
									 AND EXTRACT(DAY FROM f.fecfact) = '08'  AND f.codmon = 'USD' 
									GROUP BY f.codemisor,e.denemisor 
									UNION
									SELECT f.codemisor,
										   e.denemisor,	      
										   '613070901000000' as sc_cuenta,
										   sum(i.moning) AS total,
										   sum(i.moning/f.tascam) AS total_ext,											   
										   count(*) AS numbol
									FROM cxc_factura f 
									INNER JOIN cxc_ingresos i ON f.id_fact = i.id_fact_ticket									
									LEFT JOIN aero_emisores e ON e.codemisor = f.codemisor
									LEFT JOIN cxc_sucursales suc ON suc.codemp = f.codemp 
																AND suc.codsuc = f.codsuc
									LEFT JOIN cxc_cajas caj ON caj.codemp = f.codemp 
														   AND caj.codsuc = f.codsuc
														   AND caj.codcaj = f.codcaj
									WHERE (nro_ticket!='' or nro_ticket is not null)
									AND (cmp_contab='' or cmp_contab is null)
									AND contabilizado='0'
									AND (fecconta='1900-01-01' OR fecconta is null)
									AND EXTRACT(YEAR FROM f.fecfact) = '2020'
									AND EXTRACT(MONTH FROM f.fecfact) = '01'
									AND f.codemisor = 'VE178590'
									AND f.tipopecont = 'DC'
									AND i.codforpag IN ('TS')
									 AND EXTRACT(DAY FROM f.fecfact) = '08'  AND f.codmon = 'USD' 
									GROUP BY f.codemisor,e.denemisor 
									   UNION	
									SELECT f.codemisor,
										   e.denemisor,	       
										   '112030101010001' as sc_cuenta,
										   (sum(f.total)-sum(i.moning)) AS total, 
										   (sum(f.total/f.tascam)-sum(i.moning/f.tascam)) AS total_ext, 
									count(*) AS numbol 
									FROM cxc_factura f 
									INNER JOIN cxc_ingresos i ON f.id_fact = i.id_fact_ticket 
									LEFT JOIN aero_emisores e ON e.codemisor = f.codemisor 
									LEFT JOIN cxc_sucursales suc ON suc.codemp = f.codemp AND suc.codsuc = f.codsuc 
									LEFT JOIN cxc_cajas caj ON caj.codemp = f.codemp AND caj.codsuc = f.codsuc AND caj.codcaj = f.codcaj 
									WHERE (nro_ticket!='' or nro_ticket is not null) 
									AND (cmp_contab='' or cmp_contab is null) 
									AND contabilizado='0' 
									AND (fecconta='1900-01-01' OR fecconta is null) 
									AND EXTRACT(YEAR FROM f.fecfact) = '2020'
									AND EXTRACT(MONTH FROM f.fecfact) = '01'
									AND f.codemisor = 'VE178590'
									AND f.tipopecont = 'DEV'
									 AND EXTRACT(DAY FROM f.fecfact) = '08'  AND f.codmon = 'USD' 
									GROUP BY f.codemisor,e.denemisor
								) AS infoscg
								INNER JOIN scg_cuentas scg ON infoscg.sc_cuenta = scg.sc_cuenta
								 GROUP BY 1 
								 ORDER BY 5 DESC,4,1	
				    

09/02/2021 04:15:40  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  <br><b>ERROR-></b><br><b>CLASE:</b> Clase menu ext <br><b>METODO:</b> busca menu auxInvalid query: ERROR:  current transaction is aborted, commands ignored until end of transaction block
Whole query: INSERT INTO sss_menus(codsis,nombre_menu,descripcion_menu) 
											  VALUES ('APR','',''); SELECT lastval() AS valor_id; 

09/02/2021 04:21:13  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  CLASE->covensol_release MÉTODO->covensol_release_SAF_35_2015 ERROR->Invalid query: ERROR:  update or delete on table "saf_conservacionbien" violates foreign key constraint "fk_saf_activo__saf_conservacionbien" on table "saf_activo"
DETAIL:  Key (codconbie)=(01) is still referenced from table "saf_activo".
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');
						

09/02/2021 04:22:39  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  CLASE->covensol_release MÉTODO->covensol_release_SAF_35_2015 ERROR->Invalid query: ERROR:  update or delete on table "saf_conservacionbien" violates foreign key constraint "fk_saf_activo__saf_conservacionbien" on table "saf_activo"
DETAIL:  Key (codconbie)=(01) is still referenced from table "saf_activo".
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');
						

09/02/2021 04:23:56  *****  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');
						

09/02/2021 04:25:16  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  CLASE->covensol_release MÉTODO->covensol_release_SAF_35_2015 ERROR->Invalid query: ERROR:  update or delete on table "saf_conservacionbien" violates foreign key constraint "fk_saf_activo__saf_conservacionbien" on table "saf_activo"
DETAIL:  Key (codconbie)=(01) is still referenced from table "saf_activo".
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');
						

09/02/2021 04:27:52  *****  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');
						

09/02/2021 04:30:26  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  CLASE->covensol_release MÉTODO->covensol_release_SAF_35_2015 ERROR->Invalid query: ERROR:  relation "saf_tipocobertura" already exists
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');