13/02/2021 04:13:25 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR ***** CLASE: covensol_soa_c_aero
METODO: ConsultaConceptoCtlAge
ERROR->
Invalid query: ERROR: missing FROM-clause entry for table "e"
LINE 4: ORDER BY e.codemisor
^
Whole query: SELECT * FROM aero_ctlage_concepto c LEFT JOIN aero_ctlage_tipconcepto tc ON tc.codtipconcepage=c.codtipconcepage
WHERE c.denconcepage ILIKE'%%'
ORDER BY e.codemisor
13/02/2021 04:13:35 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR ***** CLASE: covensol_soa_c_aero
METODO: ConsultaConceptoCtlAge
ERROR->
Invalid query: ERROR: missing FROM-clause entry for table "e"
LINE 4: ORDER BY e.codemisor
^
Whole query: SELECT * FROM aero_ctlage_concepto c LEFT JOIN aero_ctlage_tipconcepto tc ON tc.codtipconcepage=c.codtipconcepage
WHERE c.denconcepage ILIKE'%%'
ORDER BY e.codemisor
13/02/2021 04:14:38 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR ***** CLASE: covensol_soa_c_aero
METODO: ConsultaConceptoCtlAge
ERROR->
Invalid query: ERROR: missing FROM-clause entry for table "e"
LINE 4: ORDER BY e.codemisor
^
Whole query: SELECT * FROM aero_ctlage_concepto c LEFT JOIN aero_ctlage_tipconcepto tc ON tc.codtipconcepage=c.codtipconcepage
WHERE c.denconcepage ILIKE'%%'
ORDER BY e.codemisor
13/02/2021 04:16:03 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR ***** CLASE: covensol_soa_c_aero
METODO: ConsultaConceptoCtlAge
ERROR->
Invalid query: ERROR: missing FROM-clause entry for table "e"
LINE 4: ORDER BY e.codemisor
^
Whole query: SELECT * FROM aero_ctlage_concepto c LEFT JOIN aero_ctlage_tipconcepto tc ON tc.codtipconcepage=c.codtipconcepage
WHERE c.denconcepage ILIKE'%%'
ORDER BY e.codemisor
13/02/2021 04:16:09 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR ***** CLASE: covensol_soa_c_aero
METODO: ConsultaConceptoCtlAge
ERROR->
Invalid query: ERROR: missing FROM-clause entry for table "e"
LINE 4: ORDER BY e.codemisor
^
Whole query: SELECT * FROM aero_ctlage_concepto c LEFT JOIN aero_ctlage_tipconcepto tc ON tc.codtipconcepage=c.codtipconcepage
WHERE c.denconcepage ILIKE'%%'
ORDER BY e.codemisor
13/02/2021 04:16:47 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR ***** CLASE: covensol_soa_c_aero
METODO: ConsultaConceptoCtlAge
ERROR->
Invalid query: ERROR: missing FROM-clause entry for table "e"
LINE 4: ORDER BY e.codemisor
^
Whole query: SELECT * FROM aero_ctlage_concepto c LEFT JOIN aero_ctlage_tipconcepto tc ON tc.codtipconcepage=c.codtipconcepage
WHERE c.denconcepage ILIKE'%%'
ORDER BY e.codemisor
13/02/2021 04:17:19 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR ***** CLASE: covensol_soa_c_aero
METODO: ConsultaConceptoCtlAge
ERROR->
Invalid query: ERROR: missing FROM-clause entry for table "e"
LINE 4: ORDER BY e.codemisor
^
Whole query: SELECT * FROM aero_ctlage_concepto c LEFT JOIN aero_ctlage_tipconcepto tc ON tc.codtipconcepage=c.codtipconcepage
WHERE c.denconcepage ILIKE'%%'
ORDER BY e.codemisor
13/02/2021 04:17:24 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR ***** CLASE: covensol_soa_c_aero
METODO: ConsultaConceptoCtlAge
ERROR->
Invalid query: ERROR: missing FROM-clause entry for table "e"
LINE 4: ORDER BY e.codemisor
^
Whole query: SELECT * FROM aero_ctlage_concepto c LEFT JOIN aero_ctlage_tipconcepto tc ON tc.codtipconcepage=c.codtipconcepage
WHERE c.denconcepage ILIKE'%%'
ORDER BY e.codemisor
13/02/2021 04:19:05 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR ***** CLASE: covensol_soa_c_aero
METODO: ConsultaConceptoCtlAge
ERROR->
Invalid query: ERROR: missing FROM-clause entry for table "e"
LINE 4: ORDER BY e.codemisor
^
Whole query: SELECT * FROM aero_ctlage_concepto c LEFT JOIN aero_ctlage_tipconcepto tc ON tc.codtipconcepage=c.codtipconcepage
WHERE c.denconcepage ILIKE'%%'
ORDER BY e.codemisor
13/02/2021 04:19:45 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR ***** CLASE: covensol_soa_c_aero
METODO: ConsultaConceptoCtlAge
ERROR->
Invalid query: ERROR: missing FROM-clause entry for table "e"
LINE 4: ORDER BY e.codemisor
^
Whole query: SELECT * FROM aero_ctlage_concepto c LEFT JOIN aero_ctlage_tipconcepto tc ON tc.codtipconcepage=c.codtipconcepage
WHERE c.denconcepage ILIKE'%%'
ORDER BY e.codemisor
13/02/2021 06:15:52 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR ***** CLASE: covensol_soa_c_aero
METODO: ConsultaEmisor
ERROR->
Invalid query: ERROR: syntax error at or near "WHERE"
LINE 2: (CASE WHERE ref_kiu!='' THEN codemisor||...
^
Whole query: SELECT *,
(CASE WHERE ref_kiu!='' THEN codemisor||' - '||ref_kiu||' - '||denemisor
ELSE codemisor||' - '||denemisor
END) AS infoemisor
FROM aero_emisores e LEFT JOIN aero_tipo_emisor te ON te.id_tipemisor=e.id_tipemisor
LEFT JOIN aero_localidad l ON l.id_loc=e.id_loc
LEFT JOIN aero_periodicidad p ON p.id_periodicidad=e.id_periodicidad
WHERE e.codemisor ILIKE'%%'
AND e.denemisor ILIKE'%%'
AND e.ref_kiu ILIKE'%%'
ORDER BY e.codemisor
13/02/2021 16:11:18 ***** 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');