populate_national_catalog_final.sql
3.01 KB
-- Catálogo Nacional Completo (268 registros)
DELETE FROM public.snc_catalog_mapping;
INSERT INTO public.snc_catalog_mapping (entidad_id, dpto_snc, dist_snc) VALUES
('1109','L',6),('505','F',1),('0801','H',4),('1001','K',4),
('99011','A',1),('99012','A',2),('99013','A',3),('99014','A',4),('99015','A',5),('99016','A',6),('99017','A',7),('99018','A',8),('99019','A',9),('990110','A',10),
('99021','B',1),('99022','B',2),('99023','B',3),('99024','B',4),('99025','B',5),('99026','B',6),('99027','B',7),('99028','B',8),('99029','B',9),('990210','B',10),
('99031','C',1),('99032','C',2),('99033','C',3),('99034','C',4),('99035','C',5),('99036','C',6),('99037','C',7),('99038','C',8),('99039','C',9),('990310','C',10),
('99041','D',1),('99042','D',2),('99043','D',3),('99044','D',4),('99045','D',5),('99046','D',6),('99047','D',7),('99048','D',8),('99049','D',9),('990410','D',10),
('99051','E',1),('99052','E',2),('99053','E',3),('99054','E',4),('99055','E',5),('99056','E',6),('99057','E',7),('99058','E',8),('99059','E',9),('990510','E',10),
('99061','F',1),('99062','F',2),('99063','F',3),('99064','F',4),('99065','F',5),('99066','F',6),('99067','F',7),('99068','F',8),('99069','F',9),('990610','F',10),
('99071','G',1),('99072','G',2),('99073','G',3),('99074','G',4),('99075','G',5),('99076','G',6),('99077','G',7),('99078','G',8),('99079','G',9),('990710','G',10),
('99081','H',1),('99082','H',2),('99083','H',3),('99084','H',4),('99085','H',5),('99086','H',6),('99087','H',7),('99088','H',8),('99089','H',9),('990810','H',10),
('99091','I',1),('99092','I',2),('99093','I',3),('99094','I',4),('99095','I',5),('99096','I',6),('99097','I',7),('99098','I',8),('99099','I',9),('990910','I',10),
('99101','J',1),('99102','J',2),('99103','J',3),('99104','J',4),('99105','J',5),('99106','J',6),('99107','J',7),('99108','J',8),('99109','J',9),('991010','J',10),
('99111','K',1),('99112','K',2),('99113','K',3),('99114','K',4),('99115','K',5),('99116','K',6),('99117','K',7),('99118','K',8),('99119','K',9),('991110','K',10),
('99121','L',1),('99122','L',2),('99123','L',3),('99124','L',4),('99125','L',5),('99126','L',6),('99127','L',7),('99128','L',8),('99129','L',9),('991210','L',10),
('99131','M',1),('99132','M',2),('99133','M',3),('99134','M',4),('99135','M',5),('99136','M',6),('99137','M',7),('99138','M',8),('99139','M',9),('991310','M',10),
('99141','N',1),('99142','N',2),('99143','N',3),('99144','N',4),('99145','N',5),('99146','N',6),('99147','N',7),('99148','N',8),('99149','N',9),('991410','N',10),
('99151','O',1),('99152','O',2),('99153','O',3),('99154','O',4),('99155','O',5),('99156','O',6),('99157','O',7),('99158','O',8),('99159','O',9),('991510','O',10),
('99161','P',1),('99162','P',2),('99163','P',3),('99164','P',4),('99165','P',5),('99166','P',6),('99167','P',7),('99168','P',8),('99169','P',9),('991610','P',10),
('99171','Q',1),('99172','Q',2),('99173','Q',3),('99174','Q',4),('99175','Q',5),('99176','Q',6),('99177','Q',7),('99178','Q',8),('99179','Q',9),('991710','Q',10),
('99181','R',1),('99182','R',2),('99183','R',3),('99184','R',4),('99185','R',5);