Permalink
Find file
Fetching contributors…
Cannot retrieve contributors at this time
10889 lines (10885 sloc) 602 KB
SET search_path = acs2010_spt;
INSERT INTO seq0001
SELECT fileid, filetype, upper(stusab), chariter, seq, logrecno::int,
NULLIF(NULLIF(B01001001, ''), '.')::double precision,
NULLIF(NULLIF(B01001002, ''), '.')::double precision,
NULLIF(NULLIF(B01001003, ''), '.')::double precision,
NULLIF(NULLIF(B01001004, ''), '.')::double precision,
NULLIF(NULLIF(B01001005, ''), '.')::double precision,
NULLIF(NULLIF(B01001006, ''), '.')::double precision,
NULLIF(NULLIF(B01001007, ''), '.')::double precision,
NULLIF(NULLIF(B01001008, ''), '.')::double precision,
NULLIF(NULLIF(B01001009, ''), '.')::double precision,
NULLIF(NULLIF(B01001010, ''), '.')::double precision,
NULLIF(NULLIF(B01001011, ''), '.')::double precision,
NULLIF(NULLIF(B01001012, ''), '.')::double precision,
NULLIF(NULLIF(B01001013, ''), '.')::double precision,
NULLIF(NULLIF(B01001014, ''), '.')::double precision,
NULLIF(NULLIF(B01001015, ''), '.')::double precision,
NULLIF(NULLIF(B01001016, ''), '.')::double precision,
NULLIF(NULLIF(B01001017, ''), '.')::double precision,
NULLIF(NULLIF(B01001018, ''), '.')::double precision,
NULLIF(NULLIF(B01001019, ''), '.')::double precision,
NULLIF(NULLIF(B01001020, ''), '.')::double precision,
NULLIF(NULLIF(B01001021, ''), '.')::double precision,
NULLIF(NULLIF(B01001022, ''), '.')::double precision,
NULLIF(NULLIF(B01001023, ''), '.')::double precision,
NULLIF(NULLIF(B01001024, ''), '.')::double precision,
NULLIF(NULLIF(B01001025, ''), '.')::double precision,
NULLIF(NULLIF(B01001026, ''), '.')::double precision,
NULLIF(NULLIF(B01001027, ''), '.')::double precision,
NULLIF(NULLIF(B01001028, ''), '.')::double precision,
NULLIF(NULLIF(B01001029, ''), '.')::double precision,
NULLIF(NULLIF(B01001030, ''), '.')::double precision,
NULLIF(NULLIF(B01001031, ''), '.')::double precision,
NULLIF(NULLIF(B01001032, ''), '.')::double precision,
NULLIF(NULLIF(B01001033, ''), '.')::double precision,
NULLIF(NULLIF(B01001034, ''), '.')::double precision,
NULLIF(NULLIF(B01001035, ''), '.')::double precision,
NULLIF(NULLIF(B01001036, ''), '.')::double precision,
NULLIF(NULLIF(B01001037, ''), '.')::double precision,
NULLIF(NULLIF(B01001038, ''), '.')::double precision,
NULLIF(NULLIF(B01001039, ''), '.')::double precision,
NULLIF(NULLIF(B01001040, ''), '.')::double precision,
NULLIF(NULLIF(B01001041, ''), '.')::double precision,
NULLIF(NULLIF(B01001042, ''), '.')::double precision,
NULLIF(NULLIF(B01001043, ''), '.')::double precision,
NULLIF(NULLIF(B01001044, ''), '.')::double precision,
NULLIF(NULLIF(B01001045, ''), '.')::double precision,
NULLIF(NULLIF(B01001046, ''), '.')::double precision,
NULLIF(NULLIF(B01001047, ''), '.')::double precision,
NULLIF(NULLIF(B01001048, ''), '.')::double precision,
NULLIF(NULLIF(B01001049, ''), '.')::double precision,
NULLIF(NULLIF(B01002001, ''), '.')::double precision,
NULLIF(NULLIF(B01002002, ''), '.')::double precision,
NULLIF(NULLIF(B01002003, ''), '.')::double precision,
NULLIF(NULLIF(B01003001, ''), '.')::double precision
FROM tmp_seq0001;
INSERT INTO seq0002
SELECT fileid, filetype, upper(stusab), chariter, seq, logrecno::int,
NULLIF(NULLIF(B05001001, ''), '.')::double precision,
NULLIF(NULLIF(B05001002, ''), '.')::double precision,
NULLIF(NULLIF(B05001003, ''), '.')::double precision,
NULLIF(NULLIF(B05001004, ''), '.')::double precision,
NULLIF(NULLIF(B05001005, ''), '.')::double precision,
NULLIF(NULLIF(B05001006, ''), '.')::double precision,
NULLIF(NULLIF(B05002001, ''), '.')::double precision,
NULLIF(NULLIF(B05002002, ''), '.')::double precision,
NULLIF(NULLIF(B05002003, ''), '.')::double precision,
NULLIF(NULLIF(B05002004, ''), '.')::double precision,
NULLIF(NULLIF(B05002005, ''), '.')::double precision,
NULLIF(NULLIF(B05002006, ''), '.')::double precision,
NULLIF(NULLIF(B05002007, ''), '.')::double precision,
NULLIF(NULLIF(B05002008, ''), '.')::double precision,
NULLIF(NULLIF(B05002009, ''), '.')::double precision,
NULLIF(NULLIF(B05002010, ''), '.')::double precision,
NULLIF(NULLIF(B05002011, ''), '.')::double precision,
NULLIF(NULLIF(B05002012, ''), '.')::double precision,
NULLIF(NULLIF(B05002013, ''), '.')::double precision,
NULLIF(NULLIF(B05002014, ''), '.')::double precision,
NULLIF(NULLIF(B05002015, ''), '.')::double precision,
NULLIF(NULLIF(B05003001, ''), '.')::double precision,
NULLIF(NULLIF(B05003002, ''), '.')::double precision,
NULLIF(NULLIF(B05003003, ''), '.')::double precision,
NULLIF(NULLIF(B05003004, ''), '.')::double precision,
NULLIF(NULLIF(B05003005, ''), '.')::double precision,
NULLIF(NULLIF(B05003006, ''), '.')::double precision,
NULLIF(NULLIF(B05003007, ''), '.')::double precision,
NULLIF(NULLIF(B05003008, ''), '.')::double precision,
NULLIF(NULLIF(B05003009, ''), '.')::double precision,
NULLIF(NULLIF(B05003010, ''), '.')::double precision,
NULLIF(NULLIF(B05003011, ''), '.')::double precision,
NULLIF(NULLIF(B05003012, ''), '.')::double precision,
NULLIF(NULLIF(B05003013, ''), '.')::double precision,
NULLIF(NULLIF(B05003014, ''), '.')::double precision,
NULLIF(NULLIF(B05003015, ''), '.')::double precision,
NULLIF(NULLIF(B05003016, ''), '.')::double precision,
NULLIF(NULLIF(B05003017, ''), '.')::double precision,
NULLIF(NULLIF(B05003018, ''), '.')::double precision,
NULLIF(NULLIF(B05003019, ''), '.')::double precision,
NULLIF(NULLIF(B05003020, ''), '.')::double precision,
NULLIF(NULLIF(B05003021, ''), '.')::double precision,
NULLIF(NULLIF(B05003022, ''), '.')::double precision,
NULLIF(NULLIF(B05003023, ''), '.')::double precision,
NULLIF(NULLIF(B05005001, ''), '.')::double precision,
NULLIF(NULLIF(B05005002, ''), '.')::double precision,
NULLIF(NULLIF(B05005003, ''), '.')::double precision,
NULLIF(NULLIF(B05005004, ''), '.')::double precision,
NULLIF(NULLIF(B05005005, ''), '.')::double precision,
NULLIF(NULLIF(B05005006, ''), '.')::double precision,
NULLIF(NULLIF(B05005007, ''), '.')::double precision,
NULLIF(NULLIF(B05005008, ''), '.')::double precision,
NULLIF(NULLIF(B05005009, ''), '.')::double precision,
NULLIF(NULLIF(B05005010, ''), '.')::double precision,
NULLIF(NULLIF(B05005011, ''), '.')::double precision,
NULLIF(NULLIF(B05005012, ''), '.')::double precision,
NULLIF(NULLIF(B05005013, ''), '.')::double precision,
NULLIF(NULLIF(B05005014, ''), '.')::double precision,
NULLIF(NULLIF(B05005015, ''), '.')::double precision,
NULLIF(NULLIF(B05005016, ''), '.')::double precision,
NULLIF(NULLIF(B05005017, ''), '.')::double precision,
NULLIF(NULLIF(B05005018, ''), '.')::double precision,
NULLIF(NULLIF(B05005019, ''), '.')::double precision,
NULLIF(NULLIF(B05005020, ''), '.')::double precision,
NULLIF(NULLIF(B05005021, ''), '.')::double precision,
NULLIF(NULLIF(B05006001, ''), '.')::double precision,
NULLIF(NULLIF(B05006002, ''), '.')::double precision,
NULLIF(NULLIF(B05006003, ''), '.')::double precision,
NULLIF(NULLIF(B05006004, ''), '.')::double precision,
NULLIF(NULLIF(B05006005, ''), '.')::double precision,
NULLIF(NULLIF(B05006006, ''), '.')::double precision,
NULLIF(NULLIF(B05006007, ''), '.')::double precision,
NULLIF(NULLIF(B05006008, ''), '.')::double precision,
NULLIF(NULLIF(B05006009, ''), '.')::double precision,
NULLIF(NULLIF(B05006010, ''), '.')::double precision,
NULLIF(NULLIF(B05006011, ''), '.')::double precision,
NULLIF(NULLIF(B05006012, ''), '.')::double precision,
NULLIF(NULLIF(B05006013, ''), '.')::double precision,
NULLIF(NULLIF(B05006014, ''), '.')::double precision,
NULLIF(NULLIF(B05006015, ''), '.')::double precision,
NULLIF(NULLIF(B05006016, ''), '.')::double precision,
NULLIF(NULLIF(B05006017, ''), '.')::double precision,
NULLIF(NULLIF(B05006018, ''), '.')::double precision,
NULLIF(NULLIF(B05006019, ''), '.')::double precision,
NULLIF(NULLIF(B05006020, ''), '.')::double precision,
NULLIF(NULLIF(B05006021, ''), '.')::double precision,
NULLIF(NULLIF(B05006022, ''), '.')::double precision,
NULLIF(NULLIF(B05006023, ''), '.')::double precision,
NULLIF(NULLIF(B05006024, ''), '.')::double precision,
NULLIF(NULLIF(B05006025, ''), '.')::double precision,
NULLIF(NULLIF(B05006026, ''), '.')::double precision,
NULLIF(NULLIF(B05006027, ''), '.')::double precision,
NULLIF(NULLIF(B05006028, ''), '.')::double precision,
NULLIF(NULLIF(B05006029, ''), '.')::double precision,
NULLIF(NULLIF(B05006030, ''), '.')::double precision,
NULLIF(NULLIF(B05006031, ''), '.')::double precision,
NULLIF(NULLIF(B05006032, ''), '.')::double precision,
NULLIF(NULLIF(B05006033, ''), '.')::double precision,
NULLIF(NULLIF(B05006034, ''), '.')::double precision,
NULLIF(NULLIF(B05006035, ''), '.')::double precision,
NULLIF(NULLIF(B05006036, ''), '.')::double precision,
NULLIF(NULLIF(B05006037, ''), '.')::double precision,
NULLIF(NULLIF(B05006038, ''), '.')::double precision,
NULLIF(NULLIF(B05006039, ''), '.')::double precision,
NULLIF(NULLIF(B05006040, ''), '.')::double precision,
NULLIF(NULLIF(B05006041, ''), '.')::double precision,
NULLIF(NULLIF(B05006042, ''), '.')::double precision,
NULLIF(NULLIF(B05006043, ''), '.')::double precision,
NULLIF(NULLIF(B05006044, ''), '.')::double precision,
NULLIF(NULLIF(B05006045, ''), '.')::double precision,
NULLIF(NULLIF(B05006046, ''), '.')::double precision,
NULLIF(NULLIF(B05006047, ''), '.')::double precision,
NULLIF(NULLIF(B05006048, ''), '.')::double precision,
NULLIF(NULLIF(B05006049, ''), '.')::double precision,
NULLIF(NULLIF(B05006050, ''), '.')::double precision,
NULLIF(NULLIF(B05006051, ''), '.')::double precision,
NULLIF(NULLIF(B05006052, ''), '.')::double precision,
NULLIF(NULLIF(B05006053, ''), '.')::double precision,
NULLIF(NULLIF(B05006054, ''), '.')::double precision,
NULLIF(NULLIF(B05006055, ''), '.')::double precision,
NULLIF(NULLIF(B05006056, ''), '.')::double precision,
NULLIF(NULLIF(B05006057, ''), '.')::double precision,
NULLIF(NULLIF(B05006058, ''), '.')::double precision,
NULLIF(NULLIF(B05006059, ''), '.')::double precision,
NULLIF(NULLIF(B05006060, ''), '.')::double precision,
NULLIF(NULLIF(B05006061, ''), '.')::double precision,
NULLIF(NULLIF(B05006062, ''), '.')::double precision,
NULLIF(NULLIF(B05006063, ''), '.')::double precision,
NULLIF(NULLIF(B05006064, ''), '.')::double precision,
NULLIF(NULLIF(B05006065, ''), '.')::double precision,
NULLIF(NULLIF(B05006066, ''), '.')::double precision,
NULLIF(NULLIF(B05006067, ''), '.')::double precision,
NULLIF(NULLIF(B05006068, ''), '.')::double precision,
NULLIF(NULLIF(B05006069, ''), '.')::double precision,
NULLIF(NULLIF(B05006070, ''), '.')::double precision,
NULLIF(NULLIF(B05006071, ''), '.')::double precision,
NULLIF(NULLIF(B05006072, ''), '.')::double precision,
NULLIF(NULLIF(B05006073, ''), '.')::double precision,
NULLIF(NULLIF(B05006074, ''), '.')::double precision,
NULLIF(NULLIF(B05006075, ''), '.')::double precision,
NULLIF(NULLIF(B05006076, ''), '.')::double precision,
NULLIF(NULLIF(B05006077, ''), '.')::double precision,
NULLIF(NULLIF(B05006078, ''), '.')::double precision,
NULLIF(NULLIF(B05006079, ''), '.')::double precision,
NULLIF(NULLIF(B05006080, ''), '.')::double precision,
NULLIF(NULLIF(B05006081, ''), '.')::double precision,
NULLIF(NULLIF(B05006082, ''), '.')::double precision,
NULLIF(NULLIF(B05006083, ''), '.')::double precision,
NULLIF(NULLIF(B05006084, ''), '.')::double precision,
NULLIF(NULLIF(B05006085, ''), '.')::double precision,
NULLIF(NULLIF(B05006086, ''), '.')::double precision,
NULLIF(NULLIF(B05006087, ''), '.')::double precision,
NULLIF(NULLIF(B05006088, ''), '.')::double precision,
NULLIF(NULLIF(B05006089, ''), '.')::double precision,
NULLIF(NULLIF(B05006090, ''), '.')::double precision,
NULLIF(NULLIF(B05006091, ''), '.')::double precision,
NULLIF(NULLIF(B05006092, ''), '.')::double precision,
NULLIF(NULLIF(B05006093, ''), '.')::double precision,
NULLIF(NULLIF(B05006094, ''), '.')::double precision,
NULLIF(NULLIF(B05006095, ''), '.')::double precision,
NULLIF(NULLIF(B05006096, ''), '.')::double precision,
NULLIF(NULLIF(B05006097, ''), '.')::double precision,
NULLIF(NULLIF(B05006098, ''), '.')::double precision,
NULLIF(NULLIF(B05006099, ''), '.')::double precision,
NULLIF(NULLIF(B05006100, ''), '.')::double precision,
NULLIF(NULLIF(B05006101, ''), '.')::double precision,
NULLIF(NULLIF(B05006102, ''), '.')::double precision,
NULLIF(NULLIF(B05006103, ''), '.')::double precision,
NULLIF(NULLIF(B05006104, ''), '.')::double precision,
NULLIF(NULLIF(B05006105, ''), '.')::double precision,
NULLIF(NULLIF(B05006106, ''), '.')::double precision,
NULLIF(NULLIF(B05006107, ''), '.')::double precision,
NULLIF(NULLIF(B05006108, ''), '.')::double precision,
NULLIF(NULLIF(B05006109, ''), '.')::double precision,
NULLIF(NULLIF(B05006110, ''), '.')::double precision,
NULLIF(NULLIF(B05006111, ''), '.')::double precision,
NULLIF(NULLIF(B05006112, ''), '.')::double precision,
NULLIF(NULLIF(B05006113, ''), '.')::double precision,
NULLIF(NULLIF(B05006114, ''), '.')::double precision,
NULLIF(NULLIF(B05006115, ''), '.')::double precision,
NULLIF(NULLIF(B05006116, ''), '.')::double precision,
NULLIF(NULLIF(B05006117, ''), '.')::double precision,
NULLIF(NULLIF(B05006118, ''), '.')::double precision,
NULLIF(NULLIF(B05006119, ''), '.')::double precision,
NULLIF(NULLIF(B05006120, ''), '.')::double precision,
NULLIF(NULLIF(B05006121, ''), '.')::double precision,
NULLIF(NULLIF(B05006122, ''), '.')::double precision,
NULLIF(NULLIF(B05006123, ''), '.')::double precision,
NULLIF(NULLIF(B05006124, ''), '.')::double precision,
NULLIF(NULLIF(B05006125, ''), '.')::double precision,
NULLIF(NULLIF(B05006126, ''), '.')::double precision,
NULLIF(NULLIF(B05006127, ''), '.')::double precision,
NULLIF(NULLIF(B05006128, ''), '.')::double precision,
NULLIF(NULLIF(B05006129, ''), '.')::double precision,
NULLIF(NULLIF(B05006130, ''), '.')::double precision,
NULLIF(NULLIF(B05006131, ''), '.')::double precision,
NULLIF(NULLIF(B05006132, ''), '.')::double precision,
NULLIF(NULLIF(B05006133, ''), '.')::double precision,
NULLIF(NULLIF(B05006134, ''), '.')::double precision,
NULLIF(NULLIF(B05006135, ''), '.')::double precision,
NULLIF(NULLIF(B05006136, ''), '.')::double precision,
NULLIF(NULLIF(B05006137, ''), '.')::double precision,
NULLIF(NULLIF(B05006138, ''), '.')::double precision,
NULLIF(NULLIF(B05006139, ''), '.')::double precision,
NULLIF(NULLIF(B05006140, ''), '.')::double precision,
NULLIF(NULLIF(B05006141, ''), '.')::double precision,
NULLIF(NULLIF(B05006142, ''), '.')::double precision,
NULLIF(NULLIF(B05006143, ''), '.')::double precision,
NULLIF(NULLIF(B05006144, ''), '.')::double precision,
NULLIF(NULLIF(B05006145, ''), '.')::double precision,
NULLIF(NULLIF(B05006146, ''), '.')::double precision,
NULLIF(NULLIF(B05006147, ''), '.')::double precision,
NULLIF(NULLIF(B05006148, ''), '.')::double precision,
NULLIF(NULLIF(B05006149, ''), '.')::double precision,
NULLIF(NULLIF(B05006150, ''), '.')::double precision,
NULLIF(NULLIF(B05006151, ''), '.')::double precision,
NULLIF(NULLIF(B05006152, ''), '.')::double precision,
NULLIF(NULLIF(B05006153, ''), '.')::double precision,
NULLIF(NULLIF(B05006154, ''), '.')::double precision,
NULLIF(NULLIF(B05006155, ''), '.')::double precision,
NULLIF(NULLIF(B05006156, ''), '.')::double precision,
NULLIF(NULLIF(B05006157, ''), '.')::double precision,
NULLIF(NULLIF(B05006158, ''), '.')::double precision,
NULLIF(NULLIF(B05006159, ''), '.')::double precision,
NULLIF(NULLIF(B05006160, ''), '.')::double precision,
NULLIF(NULLIF(B05006161, ''), '.')::double precision
FROM tmp_seq0002;
INSERT INTO seq0003
SELECT fileid, filetype, upper(stusab), chariter, seq, logrecno::int,
NULLIF(NULLIF(B05007001, ''), '.')::double precision,
NULLIF(NULLIF(B05007002, ''), '.')::double precision,
NULLIF(NULLIF(B05007003, ''), '.')::double precision,
NULLIF(NULLIF(B05007004, ''), '.')::double precision,
NULLIF(NULLIF(B05007005, ''), '.')::double precision,
NULLIF(NULLIF(B05007006, ''), '.')::double precision,
NULLIF(NULLIF(B05007007, ''), '.')::double precision,
NULLIF(NULLIF(B05007008, ''), '.')::double precision,
NULLIF(NULLIF(B05007009, ''), '.')::double precision,
NULLIF(NULLIF(B05007010, ''), '.')::double precision,
NULLIF(NULLIF(B05007011, ''), '.')::double precision,
NULLIF(NULLIF(B05007012, ''), '.')::double precision,
NULLIF(NULLIF(B05007013, ''), '.')::double precision,
NULLIF(NULLIF(B05007014, ''), '.')::double precision,
NULLIF(NULLIF(B05007015, ''), '.')::double precision,
NULLIF(NULLIF(B05007016, ''), '.')::double precision,
NULLIF(NULLIF(B05007017, ''), '.')::double precision,
NULLIF(NULLIF(B05007018, ''), '.')::double precision,
NULLIF(NULLIF(B05007019, ''), '.')::double precision,
NULLIF(NULLIF(B05007020, ''), '.')::double precision,
NULLIF(NULLIF(B05007021, ''), '.')::double precision,
NULLIF(NULLIF(B05007022, ''), '.')::double precision,
NULLIF(NULLIF(B05007023, ''), '.')::double precision,
NULLIF(NULLIF(B05007024, ''), '.')::double precision,
NULLIF(NULLIF(B05007025, ''), '.')::double precision,
NULLIF(NULLIF(B05007026, ''), '.')::double precision,
NULLIF(NULLIF(B05007027, ''), '.')::double precision,
NULLIF(NULLIF(B05007028, ''), '.')::double precision,
NULLIF(NULLIF(B05007029, ''), '.')::double precision,
NULLIF(NULLIF(B05007030, ''), '.')::double precision,
NULLIF(NULLIF(B05007031, ''), '.')::double precision,
NULLIF(NULLIF(B05007032, ''), '.')::double precision,
NULLIF(NULLIF(B05007033, ''), '.')::double precision,
NULLIF(NULLIF(B05007034, ''), '.')::double precision,
NULLIF(NULLIF(B05007035, ''), '.')::double precision,
NULLIF(NULLIF(B05007036, ''), '.')::double precision,
NULLIF(NULLIF(B05007037, ''), '.')::double precision,
NULLIF(NULLIF(B05007038, ''), '.')::double precision,
NULLIF(NULLIF(B05007039, ''), '.')::double precision,
NULLIF(NULLIF(B05007040, ''), '.')::double precision,
NULLIF(NULLIF(B05007041, ''), '.')::double precision,
NULLIF(NULLIF(B05007042, ''), '.')::double precision,
NULLIF(NULLIF(B05007043, ''), '.')::double precision,
NULLIF(NULLIF(B05007044, ''), '.')::double precision,
NULLIF(NULLIF(B05007045, ''), '.')::double precision,
NULLIF(NULLIF(B05007046, ''), '.')::double precision,
NULLIF(NULLIF(B05007047, ''), '.')::double precision,
NULLIF(NULLIF(B05007048, ''), '.')::double precision,
NULLIF(NULLIF(B05007049, ''), '.')::double precision,
NULLIF(NULLIF(B05007050, ''), '.')::double precision,
NULLIF(NULLIF(B05007051, ''), '.')::double precision,
NULLIF(NULLIF(B05007052, ''), '.')::double precision,
NULLIF(NULLIF(B05007053, ''), '.')::double precision,
NULLIF(NULLIF(B05007054, ''), '.')::double precision,
NULLIF(NULLIF(B05007055, ''), '.')::double precision,
NULLIF(NULLIF(B05007056, ''), '.')::double precision,
NULLIF(NULLIF(B05007057, ''), '.')::double precision,
NULLIF(NULLIF(B05007058, ''), '.')::double precision,
NULLIF(NULLIF(B05007059, ''), '.')::double precision,
NULLIF(NULLIF(B05007060, ''), '.')::double precision,
NULLIF(NULLIF(B05007061, ''), '.')::double precision,
NULLIF(NULLIF(B05007062, ''), '.')::double precision,
NULLIF(NULLIF(B05007063, ''), '.')::double precision,
NULLIF(NULLIF(B05007064, ''), '.')::double precision,
NULLIF(NULLIF(B05007065, ''), '.')::double precision,
NULLIF(NULLIF(B05007066, ''), '.')::double precision,
NULLIF(NULLIF(B05007067, ''), '.')::double precision,
NULLIF(NULLIF(B05007068, ''), '.')::double precision,
NULLIF(NULLIF(B05007069, ''), '.')::double precision,
NULLIF(NULLIF(B05007070, ''), '.')::double precision,
NULLIF(NULLIF(B05007071, ''), '.')::double precision,
NULLIF(NULLIF(B05007072, ''), '.')::double precision,
NULLIF(NULLIF(B05007073, ''), '.')::double precision,
NULLIF(NULLIF(B05007074, ''), '.')::double precision,
NULLIF(NULLIF(B05007075, ''), '.')::double precision,
NULLIF(NULLIF(B05007076, ''), '.')::double precision,
NULLIF(NULLIF(B05007077, ''), '.')::double precision,
NULLIF(NULLIF(B05007078, ''), '.')::double precision,
NULLIF(NULLIF(B05007079, ''), '.')::double precision,
NULLIF(NULLIF(B05007080, ''), '.')::double precision,
NULLIF(NULLIF(B05007081, ''), '.')::double precision,
NULLIF(NULLIF(B05007082, ''), '.')::double precision,
NULLIF(NULLIF(B05007083, ''), '.')::double precision,
NULLIF(NULLIF(B05007084, ''), '.')::double precision,
NULLIF(NULLIF(B05007085, ''), '.')::double precision,
NULLIF(NULLIF(B05007086, ''), '.')::double precision,
NULLIF(NULLIF(B05007087, ''), '.')::double precision,
NULLIF(NULLIF(B05007088, ''), '.')::double precision,
NULLIF(NULLIF(B05007089, ''), '.')::double precision,
NULLIF(NULLIF(B05007090, ''), '.')::double precision,
NULLIF(NULLIF(B05007091, ''), '.')::double precision,
NULLIF(NULLIF(B05007092, ''), '.')::double precision,
NULLIF(NULLIF(B05007093, ''), '.')::double precision,
NULLIF(NULLIF(B05007094, ''), '.')::double precision
FROM tmp_seq0003;
INSERT INTO seq0004
SELECT fileid, filetype, upper(stusab), chariter, seq, logrecno::int,
NULLIF(NULLIF(B06003001, ''), '.')::double precision,
NULLIF(NULLIF(B06003002, ''), '.')::double precision,
NULLIF(NULLIF(B06003003, ''), '.')::double precision,
NULLIF(NULLIF(B06003004, ''), '.')::double precision,
NULLIF(NULLIF(B06003005, ''), '.')::double precision,
NULLIF(NULLIF(B06003006, ''), '.')::double precision,
NULLIF(NULLIF(B06003007, ''), '.')::double precision,
NULLIF(NULLIF(B06003008, ''), '.')::double precision,
NULLIF(NULLIF(B06003009, ''), '.')::double precision,
NULLIF(NULLIF(B06003010, ''), '.')::double precision,
NULLIF(NULLIF(B06003011, ''), '.')::double precision,
NULLIF(NULLIF(B06003012, ''), '.')::double precision,
NULLIF(NULLIF(B06003013, ''), '.')::double precision,
NULLIF(NULLIF(B06003014, ''), '.')::double precision,
NULLIF(NULLIF(B06003015, ''), '.')::double precision
FROM tmp_seq0004;
INSERT INTO seq0005
SELECT fileid, filetype, upper(stusab), chariter, seq, logrecno::int,
NULLIF(NULLIF(B07003001, ''), '.')::double precision,
NULLIF(NULLIF(B07003002, ''), '.')::double precision,
NULLIF(NULLIF(B07003003, ''), '.')::double precision,
NULLIF(NULLIF(B07003004, ''), '.')::double precision,
NULLIF(NULLIF(B07003005, ''), '.')::double precision,
NULLIF(NULLIF(B07003006, ''), '.')::double precision,
NULLIF(NULLIF(B07003007, ''), '.')::double precision,
NULLIF(NULLIF(B07003008, ''), '.')::double precision,
NULLIF(NULLIF(B07003009, ''), '.')::double precision,
NULLIF(NULLIF(B07003010, ''), '.')::double precision,
NULLIF(NULLIF(B07003011, ''), '.')::double precision,
NULLIF(NULLIF(B07003012, ''), '.')::double precision,
NULLIF(NULLIF(B07003013, ''), '.')::double precision,
NULLIF(NULLIF(B07003014, ''), '.')::double precision,
NULLIF(NULLIF(B07003015, ''), '.')::double precision,
NULLIF(NULLIF(B07003016, ''), '.')::double precision,
NULLIF(NULLIF(B07003017, ''), '.')::double precision,
NULLIF(NULLIF(B07003018, ''), '.')::double precision,
NULLIF(NULLIF(B07204001, ''), '.')::double precision,
NULLIF(NULLIF(B07204002, ''), '.')::double precision,
NULLIF(NULLIF(B07204003, ''), '.')::double precision,
NULLIF(NULLIF(B07204004, ''), '.')::double precision,
NULLIF(NULLIF(B07204005, ''), '.')::double precision,
NULLIF(NULLIF(B07204006, ''), '.')::double precision,
NULLIF(NULLIF(B07204007, ''), '.')::double precision,
NULLIF(NULLIF(B07204008, ''), '.')::double precision,
NULLIF(NULLIF(B07204009, ''), '.')::double precision,
NULLIF(NULLIF(B07204010, ''), '.')::double precision,
NULLIF(NULLIF(B07204011, ''), '.')::double precision,
NULLIF(NULLIF(B07204012, ''), '.')::double precision,
NULLIF(NULLIF(B07204013, ''), '.')::double precision,
NULLIF(NULLIF(B07204014, ''), '.')::double precision,
NULLIF(NULLIF(B07204015, ''), '.')::double precision,
NULLIF(NULLIF(B07204016, ''), '.')::double precision,
NULLIF(NULLIF(B07204017, ''), '.')::double precision,
NULLIF(NULLIF(B07204018, ''), '.')::double precision,
NULLIF(NULLIF(B07204019, ''), '.')::double precision,
NULLIF(NULLIF(C07201001, ''), '.')::double precision,
NULLIF(NULLIF(C07201002, ''), '.')::double precision,
NULLIF(NULLIF(C07201003, ''), '.')::double precision,
NULLIF(NULLIF(C07201004, ''), '.')::double precision,
NULLIF(NULLIF(C07201005, ''), '.')::double precision,
NULLIF(NULLIF(C07201006, ''), '.')::double precision,
NULLIF(NULLIF(C07201007, ''), '.')::double precision,
NULLIF(NULLIF(C07201008, ''), '.')::double precision,
NULLIF(NULLIF(C07201009, ''), '.')::double precision,
NULLIF(NULLIF(C07201010, ''), '.')::double precision,
NULLIF(NULLIF(C07201011, ''), '.')::double precision,
NULLIF(NULLIF(C07201012, ''), '.')::double precision
FROM tmp_seq0005;
INSERT INTO seq0006
SELECT fileid, filetype, upper(stusab), chariter, seq, logrecno::int,
NULLIF(NULLIF(B08007001, ''), '.')::double precision,
NULLIF(NULLIF(B08007002, ''), '.')::double precision,
NULLIF(NULLIF(B08007003, ''), '.')::double precision,
NULLIF(NULLIF(B08007004, ''), '.')::double precision,
NULLIF(NULLIF(B08007005, ''), '.')::double precision,
NULLIF(NULLIF(B08007006, ''), '.')::double precision,
NULLIF(NULLIF(B08007007, ''), '.')::double precision,
NULLIF(NULLIF(B08007008, ''), '.')::double precision,
NULLIF(NULLIF(B08007009, ''), '.')::double precision,
NULLIF(NULLIF(B08007010, ''), '.')::double precision,
NULLIF(NULLIF(B08007011, ''), '.')::double precision,
NULLIF(NULLIF(B08007012, ''), '.')::double precision,
NULLIF(NULLIF(B08007013, ''), '.')::double precision,
NULLIF(NULLIF(B08007014, ''), '.')::double precision,
NULLIF(NULLIF(B08007015, ''), '.')::double precision,
NULLIF(NULLIF(B08008001, ''), '.')::double precision,
NULLIF(NULLIF(B08008002, ''), '.')::double precision,
NULLIF(NULLIF(B08008003, ''), '.')::double precision,
NULLIF(NULLIF(B08008004, ''), '.')::double precision,
NULLIF(NULLIF(B08008005, ''), '.')::double precision,
NULLIF(NULLIF(B08008006, ''), '.')::double precision,
NULLIF(NULLIF(B08008007, ''), '.')::double precision,
NULLIF(NULLIF(B08008008, ''), '.')::double precision,
NULLIF(NULLIF(B08008009, ''), '.')::double precision,
NULLIF(NULLIF(B08008010, ''), '.')::double precision,
NULLIF(NULLIF(B08008011, ''), '.')::double precision,
NULLIF(NULLIF(B08008012, ''), '.')::double precision,
NULLIF(NULLIF(B08008013, ''), '.')::double precision,
NULLIF(NULLIF(B08008014, ''), '.')::double precision,
NULLIF(NULLIF(B08008015, ''), '.')::double precision,
NULLIF(NULLIF(B08009001, ''), '.')::double precision,
NULLIF(NULLIF(B08009002, ''), '.')::double precision,
NULLIF(NULLIF(B08009003, ''), '.')::double precision,
NULLIF(NULLIF(B08009004, ''), '.')::double precision,
NULLIF(NULLIF(B08009005, ''), '.')::double precision,
NULLIF(NULLIF(B08009006, ''), '.')::double precision,
NULLIF(NULLIF(B08009007, ''), '.')::double precision,
NULLIF(NULLIF(B08009008, ''), '.')::double precision,
NULLIF(NULLIF(B08009009, ''), '.')::double precision,
NULLIF(NULLIF(B08009010, ''), '.')::double precision,
NULLIF(NULLIF(B08009011, ''), '.')::double precision,
NULLIF(NULLIF(B08009012, ''), '.')::double precision,
NULLIF(NULLIF(B08009013, ''), '.')::double precision,
NULLIF(NULLIF(B08009014, ''), '.')::double precision,
NULLIF(NULLIF(B08009015, ''), '.')::double precision,
NULLIF(NULLIF(B08013001, ''), '.')::double precision,
NULLIF(NULLIF(B08013002, ''), '.')::double precision,
NULLIF(NULLIF(B08013003, ''), '.')::double precision,
NULLIF(NULLIF(B08016001, ''), '.')::double precision,
NULLIF(NULLIF(B08016002, ''), '.')::double precision,
NULLIF(NULLIF(B08016003, ''), '.')::double precision,
NULLIF(NULLIF(B08016004, ''), '.')::double precision,
NULLIF(NULLIF(B08016005, ''), '.')::double precision,
NULLIF(NULLIF(B08016006, ''), '.')::double precision,
NULLIF(NULLIF(B08016007, ''), '.')::double precision,
NULLIF(NULLIF(B08016008, ''), '.')::double precision,
NULLIF(NULLIF(B08016009, ''), '.')::double precision,
NULLIF(NULLIF(B08016010, ''), '.')::double precision,
NULLIF(NULLIF(B08016011, ''), '.')::double precision,
NULLIF(NULLIF(B08016012, ''), '.')::double precision,
NULLIF(NULLIF(B08016013, ''), '.')::double precision,
NULLIF(NULLIF(B08016014, ''), '.')::double precision,
NULLIF(NULLIF(B08016015, ''), '.')::double precision,
NULLIF(NULLIF(B08016016, ''), '.')::double precision,
NULLIF(NULLIF(B08016017, ''), '.')::double precision,
NULLIF(NULLIF(B08016018, ''), '.')::double precision,
NULLIF(NULLIF(B08016019, ''), '.')::double precision,
NULLIF(NULLIF(B08016020, ''), '.')::double precision,
NULLIF(NULLIF(B08016021, ''), '.')::double precision,
NULLIF(NULLIF(B08016022, ''), '.')::double precision,
NULLIF(NULLIF(B08016023, ''), '.')::double precision,
NULLIF(NULLIF(B08135001, ''), '.')::double precision,
NULLIF(NULLIF(B08135002, ''), '.')::double precision,
NULLIF(NULLIF(B08135003, ''), '.')::double precision,
NULLIF(NULLIF(B08135004, ''), '.')::double precision,
NULLIF(NULLIF(B08135005, ''), '.')::double precision,
NULLIF(NULLIF(B08135006, ''), '.')::double precision,
NULLIF(NULLIF(B08135007, ''), '.')::double precision,
NULLIF(NULLIF(B08135008, ''), '.')::double precision,
NULLIF(NULLIF(B08135009, ''), '.')::double precision,
NULLIF(NULLIF(B08135010, ''), '.')::double precision,
NULLIF(NULLIF(B08301001, ''), '.')::double precision,
NULLIF(NULLIF(B08301002, ''), '.')::double precision,
NULLIF(NULLIF(B08301003, ''), '.')::double precision,
NULLIF(NULLIF(B08301004, ''), '.')::double precision,
NULLIF(NULLIF(B08301005, ''), '.')::double precision,
NULLIF(NULLIF(B08301006, ''), '.')::double precision,
NULLIF(NULLIF(B08301007, ''), '.')::double precision,
NULLIF(NULLIF(B08301008, ''), '.')::double precision,
NULLIF(NULLIF(B08301009, ''), '.')::double precision,
NULLIF(NULLIF(B08301010, ''), '.')::double precision,
NULLIF(NULLIF(B08301011, ''), '.')::double precision,
NULLIF(NULLIF(B08301012, ''), '.')::double precision,
NULLIF(NULLIF(B08301013, ''), '.')::double precision,
NULLIF(NULLIF(B08301014, ''), '.')::double precision,
NULLIF(NULLIF(B08301015, ''), '.')::double precision,
NULLIF(NULLIF(B08301016, ''), '.')::double precision,
NULLIF(NULLIF(B08301017, ''), '.')::double precision,
NULLIF(NULLIF(B08301018, ''), '.')::double precision,
NULLIF(NULLIF(B08301019, ''), '.')::double precision,
NULLIF(NULLIF(B08301020, ''), '.')::double precision,
NULLIF(NULLIF(B08301021, ''), '.')::double precision,
NULLIF(NULLIF(B08302001, ''), '.')::double precision,
NULLIF(NULLIF(B08302002, ''), '.')::double precision,
NULLIF(NULLIF(B08302003, ''), '.')::double precision,
NULLIF(NULLIF(B08302004, ''), '.')::double precision,
NULLIF(NULLIF(B08302005, ''), '.')::double precision,
NULLIF(NULLIF(B08302006, ''), '.')::double precision,
NULLIF(NULLIF(B08302007, ''), '.')::double precision,
NULLIF(NULLIF(B08302008, ''), '.')::double precision,
NULLIF(NULLIF(B08302009, ''), '.')::double precision,
NULLIF(NULLIF(B08302010, ''), '.')::double precision,
NULLIF(NULLIF(B08302011, ''), '.')::double precision,
NULLIF(NULLIF(B08302012, ''), '.')::double precision,
NULLIF(NULLIF(B08302013, ''), '.')::double precision,
NULLIF(NULLIF(B08302014, ''), '.')::double precision,
NULLIF(NULLIF(B08302015, ''), '.')::double precision,
NULLIF(NULLIF(B08303001, ''), '.')::double precision,
NULLIF(NULLIF(B08303002, ''), '.')::double precision,
NULLIF(NULLIF(B08303003, ''), '.')::double precision,
NULLIF(NULLIF(B08303004, ''), '.')::double precision,
NULLIF(NULLIF(B08303005, ''), '.')::double precision,
NULLIF(NULLIF(B08303006, ''), '.')::double precision,
NULLIF(NULLIF(B08303007, ''), '.')::double precision,
NULLIF(NULLIF(B08303008, ''), '.')::double precision,
NULLIF(NULLIF(B08303009, ''), '.')::double precision,
NULLIF(NULLIF(B08303010, ''), '.')::double precision,
NULLIF(NULLIF(B08303011, ''), '.')::double precision,
NULLIF(NULLIF(B08303012, ''), '.')::double precision,
NULLIF(NULLIF(B08303013, ''), '.')::double precision,
NULLIF(NULLIF(C08134001, ''), '.')::double precision,
NULLIF(NULLIF(C08134002, ''), '.')::double precision,
NULLIF(NULLIF(C08134003, ''), '.')::double precision,
NULLIF(NULLIF(C08134004, ''), '.')::double precision,
NULLIF(NULLIF(C08134005, ''), '.')::double precision,
NULLIF(NULLIF(C08134006, ''), '.')::double precision,
NULLIF(NULLIF(C08134007, ''), '.')::double precision,
NULLIF(NULLIF(C08134008, ''), '.')::double precision,
NULLIF(NULLIF(C08134009, ''), '.')::double precision,
NULLIF(NULLIF(C08134010, ''), '.')::double precision,
NULLIF(NULLIF(C08134011, ''), '.')::double precision,
NULLIF(NULLIF(C08134012, ''), '.')::double precision,
NULLIF(NULLIF(C08134013, ''), '.')::double precision,
NULLIF(NULLIF(C08134014, ''), '.')::double precision,
NULLIF(NULLIF(C08134015, ''), '.')::double precision,
NULLIF(NULLIF(C08134016, ''), '.')::double precision,
NULLIF(NULLIF(C08134017, ''), '.')::double precision,
NULLIF(NULLIF(C08134018, ''), '.')::double precision,
NULLIF(NULLIF(C08134019, ''), '.')::double precision,
NULLIF(NULLIF(C08134020, ''), '.')::double precision,
NULLIF(NULLIF(C08134021, ''), '.')::double precision,
NULLIF(NULLIF(C08134022, ''), '.')::double precision,
NULLIF(NULLIF(C08134023, ''), '.')::double precision,
NULLIF(NULLIF(C08134024, ''), '.')::double precision,
NULLIF(NULLIF(C08134025, ''), '.')::double precision,
NULLIF(NULLIF(C08134026, ''), '.')::double precision,
NULLIF(NULLIF(C08134027, ''), '.')::double precision,
NULLIF(NULLIF(C08134028, ''), '.')::double precision,
NULLIF(NULLIF(C08134029, ''), '.')::double precision,
NULLIF(NULLIF(C08134030, ''), '.')::double precision,
NULLIF(NULLIF(C08134031, ''), '.')::double precision,
NULLIF(NULLIF(C08134032, ''), '.')::double precision,
NULLIF(NULLIF(C08134033, ''), '.')::double precision,
NULLIF(NULLIF(C08134034, ''), '.')::double precision,
NULLIF(NULLIF(C08134035, ''), '.')::double precision,
NULLIF(NULLIF(C08134036, ''), '.')::double precision,
NULLIF(NULLIF(C08134037, ''), '.')::double precision,
NULLIF(NULLIF(C08134038, ''), '.')::double precision,
NULLIF(NULLIF(C08134039, ''), '.')::double precision,
NULLIF(NULLIF(C08134040, ''), '.')::double precision,
NULLIF(NULLIF(C08134041, ''), '.')::double precision,
NULLIF(NULLIF(C08134042, ''), '.')::double precision,
NULLIF(NULLIF(C08134043, ''), '.')::double precision,
NULLIF(NULLIF(C08134044, ''), '.')::double precision,
NULLIF(NULLIF(C08134045, ''), '.')::double precision,
NULLIF(NULLIF(C08134046, ''), '.')::double precision,
NULLIF(NULLIF(C08134047, ''), '.')::double precision,
NULLIF(NULLIF(C08134048, ''), '.')::double precision,
NULLIF(NULLIF(C08134049, ''), '.')::double precision,
NULLIF(NULLIF(C08134050, ''), '.')::double precision,
NULLIF(NULLIF(C08136001, ''), '.')::double precision,
NULLIF(NULLIF(C08136002, ''), '.')::double precision,
NULLIF(NULLIF(C08136003, ''), '.')::double precision,
NULLIF(NULLIF(C08136004, ''), '.')::double precision,
NULLIF(NULLIF(C08136005, ''), '.')::double precision
FROM tmp_seq0006;
INSERT INTO seq0007
SELECT fileid, filetype, upper(stusab), chariter, seq, logrecno::int,
NULLIF(NULLIF(B09002001, ''), '.')::double precision,
NULLIF(NULLIF(B09002002, ''), '.')::double precision,
NULLIF(NULLIF(B09002003, ''), '.')::double precision,
NULLIF(NULLIF(B09002004, ''), '.')::double precision,
NULLIF(NULLIF(B09002005, ''), '.')::double precision,
NULLIF(NULLIF(B09002006, ''), '.')::double precision,
NULLIF(NULLIF(B09002007, ''), '.')::double precision,
NULLIF(NULLIF(B09002008, ''), '.')::double precision,
NULLIF(NULLIF(B09002009, ''), '.')::double precision,
NULLIF(NULLIF(B09002010, ''), '.')::double precision,
NULLIF(NULLIF(B09002011, ''), '.')::double precision,
NULLIF(NULLIF(B09002012, ''), '.')::double precision,
NULLIF(NULLIF(B09002013, ''), '.')::double precision,
NULLIF(NULLIF(B09002014, ''), '.')::double precision,
NULLIF(NULLIF(B09002015, ''), '.')::double precision,
NULLIF(NULLIF(B09002016, ''), '.')::double precision,
NULLIF(NULLIF(B09002017, ''), '.')::double precision,
NULLIF(NULLIF(B09002018, ''), '.')::double precision,
NULLIF(NULLIF(B09002019, ''), '.')::double precision,
NULLIF(NULLIF(B09002020, ''), '.')::double precision,
NULLIF(NULLIF(B09006001, ''), '.')::double precision,
NULLIF(NULLIF(B09006002, ''), '.')::double precision,
NULLIF(NULLIF(B09006003, ''), '.')::double precision,
NULLIF(NULLIF(B09006004, ''), '.')::double precision,
NULLIF(NULLIF(B09006005, ''), '.')::double precision,
NULLIF(NULLIF(B09016001, ''), '.')::double precision,
NULLIF(NULLIF(B09016002, ''), '.')::double precision,
NULLIF(NULLIF(B09016003, ''), '.')::double precision,
NULLIF(NULLIF(B09016004, ''), '.')::double precision,
NULLIF(NULLIF(B09016005, ''), '.')::double precision,
NULLIF(NULLIF(B09016006, ''), '.')::double precision,
NULLIF(NULLIF(B09016007, ''), '.')::double precision,
NULLIF(NULLIF(B09016008, ''), '.')::double precision,
NULLIF(NULLIF(B09016009, ''), '.')::double precision,
NULLIF(NULLIF(B09016010, ''), '.')::double precision,
NULLIF(NULLIF(B09016011, ''), '.')::double precision,
NULLIF(NULLIF(B09016012, ''), '.')::double precision,
NULLIF(NULLIF(B09016013, ''), '.')::double precision,
NULLIF(NULLIF(B09016014, ''), '.')::double precision,
NULLIF(NULLIF(B09016015, ''), '.')::double precision,
NULLIF(NULLIF(B09016016, ''), '.')::double precision,
NULLIF(NULLIF(B09016017, ''), '.')::double precision,
NULLIF(NULLIF(B09016018, ''), '.')::double precision,
NULLIF(NULLIF(B09016019, ''), '.')::double precision,
NULLIF(NULLIF(B09016020, ''), '.')::double precision,
NULLIF(NULLIF(B09016021, ''), '.')::double precision,
NULLIF(NULLIF(B09016022, ''), '.')::double precision,
NULLIF(NULLIF(B09016023, ''), '.')::double precision,
NULLIF(NULLIF(B09016024, ''), '.')::double precision,
NULLIF(NULLIF(B09016025, ''), '.')::double precision,
NULLIF(NULLIF(B09016026, ''), '.')::double precision,
NULLIF(NULLIF(B09016027, ''), '.')::double precision,
NULLIF(NULLIF(B09016028, ''), '.')::double precision,
NULLIF(NULLIF(B09016029, ''), '.')::double precision,
NULLIF(NULLIF(B09016030, ''), '.')::double precision,
NULLIF(NULLIF(B09016031, ''), '.')::double precision,
NULLIF(NULLIF(B09016032, ''), '.')::double precision,
NULLIF(NULLIF(B09016033, ''), '.')::double precision,
NULLIF(NULLIF(B09017001, ''), '.')::double precision,
NULLIF(NULLIF(B09017002, ''), '.')::double precision,
NULLIF(NULLIF(B09017003, ''), '.')::double precision,
NULLIF(NULLIF(B09017004, ''), '.')::double precision,
NULLIF(NULLIF(B09017005, ''), '.')::double precision,
NULLIF(NULLIF(B09017006, ''), '.')::double precision,
NULLIF(NULLIF(B09017007, ''), '.')::double precision,
NULLIF(NULLIF(B09017008, ''), '.')::double precision,
NULLIF(NULLIF(B09017009, ''), '.')::double precision,
NULLIF(NULLIF(B09017010, ''), '.')::double precision,
NULLIF(NULLIF(B09017011, ''), '.')::double precision,
NULLIF(NULLIF(B09017012, ''), '.')::double precision,
NULLIF(NULLIF(B09017013, ''), '.')::double precision,
NULLIF(NULLIF(B09017014, ''), '.')::double precision,
NULLIF(NULLIF(B09017015, ''), '.')::double precision,
NULLIF(NULLIF(B09017016, ''), '.')::double precision,
NULLIF(NULLIF(B09017017, ''), '.')::double precision,
NULLIF(NULLIF(B09017018, ''), '.')::double precision,
NULLIF(NULLIF(B09017019, ''), '.')::double precision,
NULLIF(NULLIF(B09017020, ''), '.')::double precision
FROM tmp_seq0007;
INSERT INTO seq0008
SELECT fileid, filetype, upper(stusab), chariter, seq, logrecno::int,
NULLIF(NULLIF(B10050001, ''), '.')::double precision,
NULLIF(NULLIF(B10050002, ''), '.')::double precision,
NULLIF(NULLIF(B10050003, ''), '.')::double precision,
NULLIF(NULLIF(B10050004, ''), '.')::double precision,
NULLIF(NULLIF(B10050005, ''), '.')::double precision,
NULLIF(NULLIF(B10050006, ''), '.')::double precision,
NULLIF(NULLIF(B10050007, ''), '.')::double precision,
NULLIF(NULLIF(B10050008, ''), '.')::double precision,
NULLIF(NULLIF(B10050009, ''), '.')::double precision,
NULLIF(NULLIF(B10050010, ''), '.')::double precision,
NULLIF(NULLIF(B10056001, ''), '.')::double precision,
NULLIF(NULLIF(B10056002, ''), '.')::double precision,
NULLIF(NULLIF(B10056003, ''), '.')::double precision,
NULLIF(NULLIF(B10056004, ''), '.')::double precision,
NULLIF(NULLIF(B10056005, ''), '.')::double precision,
NULLIF(NULLIF(B10056006, ''), '.')::double precision,
NULLIF(NULLIF(B10056007, ''), '.')::double precision,
NULLIF(NULLIF(B10056008, ''), '.')::double precision,
NULLIF(NULLIF(B10056009, ''), '.')::double precision,
NULLIF(NULLIF(B10056010, ''), '.')::double precision,
NULLIF(NULLIF(B10056011, ''), '.')::double precision,
NULLIF(NULLIF(B10057001, ''), '.')::double precision,
NULLIF(NULLIF(B10057002, ''), '.')::double precision,
NULLIF(NULLIF(B10057003, ''), '.')::double precision,
NULLIF(NULLIF(B10057004, ''), '.')::double precision,
NULLIF(NULLIF(B10057005, ''), '.')::double precision,
NULLIF(NULLIF(B10057006, ''), '.')::double precision,
NULLIF(NULLIF(B10057007, ''), '.')::double precision,
NULLIF(NULLIF(B10057008, ''), '.')::double precision,
NULLIF(NULLIF(B10057009, ''), '.')::double precision,
NULLIF(NULLIF(B10057010, ''), '.')::double precision,
NULLIF(NULLIF(B10057011, ''), '.')::double precision
FROM tmp_seq0008;
INSERT INTO seq0009
SELECT fileid, filetype, upper(stusab), chariter, seq, logrecno::int,
NULLIF(NULLIF(B11001001, ''), '.')::double precision,
NULLIF(NULLIF(B11001002, ''), '.')::double precision,
NULLIF(NULLIF(B11001003, ''), '.')::double precision,
NULLIF(NULLIF(B11001004, ''), '.')::double precision,
NULLIF(NULLIF(B11001005, ''), '.')::double precision,
NULLIF(NULLIF(B11001006, ''), '.')::double precision,
NULLIF(NULLIF(B11001007, ''), '.')::double precision,
NULLIF(NULLIF(B11001008, ''), '.')::double precision,
NULLIF(NULLIF(B11001009, ''), '.')::double precision,
NULLIF(NULLIF(B11002001, ''), '.')::double precision,
NULLIF(NULLIF(B11002002, ''), '.')::double precision,
NULLIF(NULLIF(B11002003, ''), '.')::double precision,
NULLIF(NULLIF(B11002004, ''), '.')::double precision,
NULLIF(NULLIF(B11002005, ''), '.')::double precision,
NULLIF(NULLIF(B11002006, ''), '.')::double precision,
NULLIF(NULLIF(B11002007, ''), '.')::double precision,
NULLIF(NULLIF(B11002008, ''), '.')::double precision,
NULLIF(NULLIF(B11002009, ''), '.')::double precision,
NULLIF(NULLIF(B11002010, ''), '.')::double precision,
NULLIF(NULLIF(B11002011, ''), '.')::double precision,
NULLIF(NULLIF(B11002012, ''), '.')::double precision,
NULLIF(NULLIF(B11003001, ''), '.')::double precision,
NULLIF(NULLIF(B11003002, ''), '.')::double precision,
NULLIF(NULLIF(B11003003, ''), '.')::double precision,
NULLIF(NULLIF(B11003004, ''), '.')::double precision,
NULLIF(NULLIF(B11003005, ''), '.')::double precision,
NULLIF(NULLIF(B11003006, ''), '.')::double precision,
NULLIF(NULLIF(B11003007, ''), '.')::double precision,
NULLIF(NULLIF(B11003008, ''), '.')::double precision,
NULLIF(NULLIF(B11003009, ''), '.')::double precision,
NULLIF(NULLIF(B11003010, ''), '.')::double precision,
NULLIF(NULLIF(B11003011, ''), '.')::double precision,
NULLIF(NULLIF(B11003012, ''), '.')::double precision,
NULLIF(NULLIF(B11003013, ''), '.')::double precision,
NULLIF(NULLIF(B11003014, ''), '.')::double precision,
NULLIF(NULLIF(B11003015, ''), '.')::double precision,
NULLIF(NULLIF(B11003016, ''), '.')::double precision,
NULLIF(NULLIF(B11003017, ''), '.')::double precision,
NULLIF(NULLIF(B11003018, ''), '.')::double precision,
NULLIF(NULLIF(B11003019, ''), '.')::double precision,
NULLIF(NULLIF(B11003020, ''), '.')::double precision,
NULLIF(NULLIF(B11004001, ''), '.')::double precision,
NULLIF(NULLIF(B11004002, ''), '.')::double precision,
NULLIF(NULLIF(B11004003, ''), '.')::double precision,
NULLIF(NULLIF(B11004004, ''), '.')::double precision,
NULLIF(NULLIF(B11004005, ''), '.')::double precision,
NULLIF(NULLIF(B11004006, ''), '.')::double precision,
NULLIF(NULLIF(B11004007, ''), '.')::double precision,
NULLIF(NULLIF(B11004008, ''), '.')::double precision,
NULLIF(NULLIF(B11004009, ''), '.')::double precision,
NULLIF(NULLIF(B11004010, ''), '.')::double precision,
NULLIF(NULLIF(B11004011, ''), '.')::double precision,
NULLIF(NULLIF(B11004012, ''), '.')::double precision,
NULLIF(NULLIF(B11004013, ''), '.')::double precision,
NULLIF(NULLIF(B11004014, ''), '.')::double precision,
NULLIF(NULLIF(B11004015, ''), '.')::double precision,
NULLIF(NULLIF(B11004016, ''), '.')::double precision,
NULLIF(NULLIF(B11004017, ''), '.')::double precision,
NULLIF(NULLIF(B11004018, ''), '.')::double precision,
NULLIF(NULLIF(B11004019, ''), '.')::double precision,
NULLIF(NULLIF(B11004020, ''), '.')::double precision,
NULLIF(NULLIF(B11005001, ''), '.')::double precision,
NULLIF(NULLIF(B11005002, ''), '.')::double precision,
NULLIF(NULLIF(B11005003, ''), '.')::double precision,
NULLIF(NULLIF(B11005004, ''), '.')::double precision,
NULLIF(NULLIF(B11005005, ''), '.')::double precision,
NULLIF(NULLIF(B11005006, ''), '.')::double precision,
NULLIF(NULLIF(B11005007, ''), '.')::double precision,
NULLIF(NULLIF(B11005008, ''), '.')::double precision,
NULLIF(NULLIF(B11005009, ''), '.')::double precision,
NULLIF(NULLIF(B11005010, ''), '.')::double precision,
NULLIF(NULLIF(B11005011, ''), '.')::double precision,
NULLIF(NULLIF(B11005012, ''), '.')::double precision,
NULLIF(NULLIF(B11005013, ''), '.')::double precision,
NULLIF(NULLIF(B11005014, ''), '.')::double precision,
NULLIF(NULLIF(B11005015, ''), '.')::double precision,
NULLIF(NULLIF(B11005016, ''), '.')::double precision,
NULLIF(NULLIF(B11005017, ''), '.')::double precision,
NULLIF(NULLIF(B11005018, ''), '.')::double precision,
NULLIF(NULLIF(B11005019, ''), '.')::double precision,
NULLIF(NULLIF(B11006001, ''), '.')::double precision,
NULLIF(NULLIF(B11006002, ''), '.')::double precision,
NULLIF(NULLIF(B11006003, ''), '.')::double precision,
NULLIF(NULLIF(B11006004, ''), '.')::double precision,
NULLIF(NULLIF(B11006005, ''), '.')::double precision,
NULLIF(NULLIF(B11006006, ''), '.')::double precision,
NULLIF(NULLIF(B11006007, ''), '.')::double precision,
NULLIF(NULLIF(B11006008, ''), '.')::double precision,
NULLIF(NULLIF(B11006009, ''), '.')::double precision,
NULLIF(NULLIF(B11006010, ''), '.')::double precision,
NULLIF(NULLIF(B11006011, ''), '.')::double precision,
NULLIF(NULLIF(B11006012, ''), '.')::double precision,
NULLIF(NULLIF(B11006013, ''), '.')::double precision,
NULLIF(NULLIF(B11006014, ''), '.')::double precision,
NULLIF(NULLIF(B11006015, ''), '.')::double precision,
NULLIF(NULLIF(B11007001, ''), '.')::double precision,
NULLIF(NULLIF(B11007002, ''), '.')::double precision,
NULLIF(NULLIF(B11007003, ''), '.')::double precision,
NULLIF(NULLIF(B11007004, ''), '.')::double precision,
NULLIF(NULLIF(B11007005, ''), '.')::double precision,
NULLIF(NULLIF(B11007006, ''), '.')::double precision,
NULLIF(NULLIF(B11007007, ''), '.')::double precision,
NULLIF(NULLIF(B11007008, ''), '.')::double precision,
NULLIF(NULLIF(B11007009, ''), '.')::double precision,
NULLIF(NULLIF(B11007010, ''), '.')::double precision,
NULLIF(NULLIF(B11007011, ''), '.')::double precision,
NULLIF(NULLIF(B11009001, ''), '.')::double precision,
NULLIF(NULLIF(B11009002, ''), '.')::double precision,
NULLIF(NULLIF(B11009003, ''), '.')::double precision,
NULLIF(NULLIF(B11009004, ''), '.')::double precision,
NULLIF(NULLIF(B11009005, ''), '.')::double precision,
NULLIF(NULLIF(B11009006, ''), '.')::double precision,
NULLIF(NULLIF(B11009007, ''), '.')::double precision,
NULLIF(NULLIF(B11010001, ''), '.')::double precision,
NULLIF(NULLIF(B11010002, ''), '.')::double precision,
NULLIF(NULLIF(B11010003, ''), '.')::double precision,
NULLIF(NULLIF(B11010004, ''), '.')::double precision,
NULLIF(NULLIF(B11010005, ''), '.')::double precision,
NULLIF(NULLIF(B11010006, ''), '.')::double precision,
NULLIF(NULLIF(B11010007, ''), '.')::double precision,
NULLIF(NULLIF(B11010008, ''), '.')::double precision,
NULLIF(NULLIF(B11010009, ''), '.')::double precision,
NULLIF(NULLIF(B11010010, ''), '.')::double precision,
NULLIF(NULLIF(B11010011, ''), '.')::double precision,
NULLIF(NULLIF(B11010012, ''), '.')::double precision,
NULLIF(NULLIF(B11010013, ''), '.')::double precision,
NULLIF(NULLIF(B11010014, ''), '.')::double precision,
NULLIF(NULLIF(B11010015, ''), '.')::double precision,
NULLIF(NULLIF(B11015001, ''), '.')::double precision,
NULLIF(NULLIF(B11015002, ''), '.')::double precision,
NULLIF(NULLIF(B11015003, ''), '.')::double precision,
NULLIF(NULLIF(B11016001, ''), '.')::double precision,
NULLIF(NULLIF(B11016002, ''), '.')::double precision,
NULLIF(NULLIF(B11016003, ''), '.')::double precision,
NULLIF(NULLIF(B11016004, ''), '.')::double precision,
NULLIF(NULLIF(B11016005, ''), '.')::double precision,
NULLIF(NULLIF(B11016006, ''), '.')::double precision,
NULLIF(NULLIF(B11016007, ''), '.')::double precision,
NULLIF(NULLIF(B11016008, ''), '.')::double precision,
NULLIF(NULLIF(B11016009, ''), '.')::double precision,
NULLIF(NULLIF(B11016010, ''), '.')::double precision,
NULLIF(NULLIF(B11016011, ''), '.')::double precision,
NULLIF(NULLIF(B11016012, ''), '.')::double precision,
NULLIF(NULLIF(B11016013, ''), '.')::double precision,
NULLIF(NULLIF(B11016014, ''), '.')::double precision,
NULLIF(NULLIF(B11016015, ''), '.')::double precision,
NULLIF(NULLIF(B11016016, ''), '.')::double precision
FROM tmp_seq0009;
INSERT INTO seq0010
SELECT fileid, filetype, upper(stusab), chariter, seq, logrecno::int,
NULLIF(NULLIF(B12001001, ''), '.')::double precision,
NULLIF(NULLIF(B12001002, ''), '.')::double precision,
NULLIF(NULLIF(B12001003, ''), '.')::double precision,
NULLIF(NULLIF(B12001004, ''), '.')::double precision,
NULLIF(NULLIF(B12001005, ''), '.')::double precision,
NULLIF(NULLIF(B12001006, ''), '.')::double precision,
NULLIF(NULLIF(B12001007, ''), '.')::double precision,
NULLIF(NULLIF(B12001008, ''), '.')::double precision,
NULLIF(NULLIF(B12001009, ''), '.')::double precision,
NULLIF(NULLIF(B12001010, ''), '.')::double precision,
NULLIF(NULLIF(B12001011, ''), '.')::double precision,
NULLIF(NULLIF(B12001012, ''), '.')::double precision,
NULLIF(NULLIF(B12001013, ''), '.')::double precision,
NULLIF(NULLIF(B12001014, ''), '.')::double precision,
NULLIF(NULLIF(B12001015, ''), '.')::double precision,
NULLIF(NULLIF(B12001016, ''), '.')::double precision,
NULLIF(NULLIF(B12001017, ''), '.')::double precision,
NULLIF(NULLIF(B12001018, ''), '.')::double precision,
NULLIF(NULLIF(B12001019, ''), '.')::double precision,
NULLIF(NULLIF(B12002001, ''), '.')::double precision,
NULLIF(NULLIF(B12002002, ''), '.')::double precision,
NULLIF(NULLIF(B12002003, ''), '.')::double precision,
NULLIF(NULLIF(B12002004, ''), '.')::double precision,
NULLIF(NULLIF(B12002005, ''), '.')::double precision,
NULLIF(NULLIF(B12002006, ''), '.')::double precision,
NULLIF(NULLIF(B12002007, ''), '.')::double precision,
NULLIF(NULLIF(B12002008, ''), '.')::double precision,
NULLIF(NULLIF(B12002009, ''), '.')::double precision,
NULLIF(NULLIF(B12002010, ''), '.')::double precision,
NULLIF(NULLIF(B12002011, ''), '.')::double precision,
NULLIF(NULLIF(B12002012, ''), '.')::double precision,
NULLIF(NULLIF(B12002013, ''), '.')::double precision,
NULLIF(NULLIF(B12002014, ''), '.')::double precision,
NULLIF(NULLIF(B12002015, ''), '.')::double precision,
NULLIF(NULLIF(B12002016, ''), '.')::double precision,
NULLIF(NULLIF(B12002017, ''), '.')::double precision,
NULLIF(NULLIF(B12002018, ''), '.')::double precision,
NULLIF(NULLIF(B12002019, ''), '.')::double precision,
NULLIF(NULLIF(B12002020, ''), '.')::double precision,
NULLIF(NULLIF(B12002021, ''), '.')::double precision,
NULLIF(NULLIF(B12002022, ''), '.')::double precision,
NULLIF(NULLIF(B12002023, ''), '.')::double precision,
NULLIF(NULLIF(B12002024, ''), '.')::double precision,
NULLIF(NULLIF(B12002025, ''), '.')::double precision,
NULLIF(NULLIF(B12002026, ''), '.')::double precision,
NULLIF(NULLIF(B12002027, ''), '.')::double precision,
NULLIF(NULLIF(B12002028, ''), '.')::double precision,
NULLIF(NULLIF(B12002029, ''), '.')::double precision,
NULLIF(NULLIF(B12002030, ''), '.')::double precision,
NULLIF(NULLIF(B12002031, ''), '.')::double precision,
NULLIF(NULLIF(B12002032, ''), '.')::double precision,
NULLIF(NULLIF(B12002033, ''), '.')::double precision,
NULLIF(NULLIF(B12002034, ''), '.')::double precision,
NULLIF(NULLIF(B12002035, ''), '.')::double precision,
NULLIF(NULLIF(B12002036, ''), '.')::double precision,
NULLIF(NULLIF(B12002037, ''), '.')::double precision,
NULLIF(NULLIF(B12002038, ''), '.')::double precision,
NULLIF(NULLIF(B12002039, ''), '.')::double precision,
NULLIF(NULLIF(B12002040, ''), '.')::double precision,
NULLIF(NULLIF(B12002041, ''), '.')::double precision,
NULLIF(NULLIF(B12002042, ''), '.')::double precision,
NULLIF(NULLIF(B12002043, ''), '.')::double precision,
NULLIF(NULLIF(B12002044, ''), '.')::double precision,
NULLIF(NULLIF(B12002045, ''), '.')::double precision,
NULLIF(NULLIF(B12002046, ''), '.')::double precision,
NULLIF(NULLIF(B12002047, ''), '.')::double precision,
NULLIF(NULLIF(B12002048, ''), '.')::double precision,
NULLIF(NULLIF(B12002049, ''), '.')::double precision,
NULLIF(NULLIF(B12002050, ''), '.')::double precision,
NULLIF(NULLIF(B12002051, ''), '.')::double precision,
NULLIF(NULLIF(B12002052, ''), '.')::double precision,
NULLIF(NULLIF(B12002053, ''), '.')::double precision,
NULLIF(NULLIF(B12002054, ''), '.')::double precision,
NULLIF(NULLIF(B12002055, ''), '.')::double precision,
NULLIF(NULLIF(B12002056, ''), '.')::double precision,
NULLIF(NULLIF(B12002057, ''), '.')::double precision,
NULLIF(NULLIF(B12002058, ''), '.')::double precision,
NULLIF(NULLIF(B12002059, ''), '.')::double precision,
NULLIF(NULLIF(B12002060, ''), '.')::double precision,
NULLIF(NULLIF(B12002061, ''), '.')::double precision,
NULLIF(NULLIF(B12002062, ''), '.')::double precision,
NULLIF(NULLIF(B12002063, ''), '.')::double precision,
NULLIF(NULLIF(B12002064, ''), '.')::double precision,
NULLIF(NULLIF(B12002065, ''), '.')::double precision,
NULLIF(NULLIF(B12002066, ''), '.')::double precision,
NULLIF(NULLIF(B12002067, ''), '.')::double precision,
NULLIF(NULLIF(B12002068, ''), '.')::double precision,
NULLIF(NULLIF(B12002069, ''), '.')::double precision,
NULLIF(NULLIF(B12002070, ''), '.')::double precision,
NULLIF(NULLIF(B12002071, ''), '.')::double precision,
NULLIF(NULLIF(B12002072, ''), '.')::double precision,
NULLIF(NULLIF(B12002073, ''), '.')::double precision,
NULLIF(NULLIF(B12002074, ''), '.')::double precision,
NULLIF(NULLIF(B12002075, ''), '.')::double precision,
NULLIF(NULLIF(B12002076, ''), '.')::double precision,
NULLIF(NULLIF(B12002077, ''), '.')::double precision,
NULLIF(NULLIF(B12002078, ''), '.')::double precision,
NULLIF(NULLIF(B12002079, ''), '.')::double precision,
NULLIF(NULLIF(B12002080, ''), '.')::double precision,
NULLIF(NULLIF(B12002081, ''), '.')::double precision,
NULLIF(NULLIF(B12002082, ''), '.')::double precision,
NULLIF(NULLIF(B12002083, ''), '.')::double precision,
NULLIF(NULLIF(B12002084, ''), '.')::double precision,
NULLIF(NULLIF(B12002085, ''), '.')::double precision,
NULLIF(NULLIF(B12002086, ''), '.')::double precision,
NULLIF(NULLIF(B12002087, ''), '.')::double precision,
NULLIF(NULLIF(B12002088, ''), '.')::double precision,
NULLIF(NULLIF(B12002089, ''), '.')::double precision,
NULLIF(NULLIF(B12002090, ''), '.')::double precision,
NULLIF(NULLIF(B12002091, ''), '.')::double precision,
NULLIF(NULLIF(B12002092, ''), '.')::double precision,
NULLIF(NULLIF(B12002093, ''), '.')::double precision,
NULLIF(NULLIF(B12002094, ''), '.')::double precision,
NULLIF(NULLIF(B12002095, ''), '.')::double precision,
NULLIF(NULLIF(B12002096, ''), '.')::double precision,
NULLIF(NULLIF(B12002097, ''), '.')::double precision,
NULLIF(NULLIF(B12002098, ''), '.')::double precision,
NULLIF(NULLIF(B12002099, ''), '.')::double precision,
NULLIF(NULLIF(B12002100, ''), '.')::double precision,
NULLIF(NULLIF(B12002101, ''), '.')::double precision,
NULLIF(NULLIF(B12002102, ''), '.')::double precision,
NULLIF(NULLIF(B12002103, ''), '.')::double precision,
NULLIF(NULLIF(B12002104, ''), '.')::double precision,
NULLIF(NULLIF(B12002105, ''), '.')::double precision,
NULLIF(NULLIF(B12002106, ''), '.')::double precision,
NULLIF(NULLIF(B12002107, ''), '.')::double precision,
NULLIF(NULLIF(B12002108, ''), '.')::double precision,
NULLIF(NULLIF(B12002109, ''), '.')::double precision,
NULLIF(NULLIF(B12002110, ''), '.')::double precision,
NULLIF(NULLIF(B12002111, ''), '.')::double precision,
NULLIF(NULLIF(B12002112, ''), '.')::double precision,
NULLIF(NULLIF(B12002113, ''), '.')::double precision,
NULLIF(NULLIF(B12002114, ''), '.')::double precision,
NULLIF(NULLIF(B12002115, ''), '.')::double precision,
NULLIF(NULLIF(B12002116, ''), '.')::double precision,
NULLIF(NULLIF(B12002117, ''), '.')::double precision,
NULLIF(NULLIF(B12002118, ''), '.')::double precision,
NULLIF(NULLIF(B12002119, ''), '.')::double precision,
NULLIF(NULLIF(B12002120, ''), '.')::double precision,
NULLIF(NULLIF(B12002121, ''), '.')::double precision,
NULLIF(NULLIF(B12002122, ''), '.')::double precision,
NULLIF(NULLIF(B12002123, ''), '.')::double precision,
NULLIF(NULLIF(B12002124, ''), '.')::double precision,
NULLIF(NULLIF(B12002125, ''), '.')::double precision,
NULLIF(NULLIF(B12002126, ''), '.')::double precision,
NULLIF(NULLIF(B12002127, ''), '.')::double precision,
NULLIF(NULLIF(B12002128, ''), '.')::double precision,
NULLIF(NULLIF(B12002129, ''), '.')::double precision,
NULLIF(NULLIF(B12002130, ''), '.')::double precision,
NULLIF(NULLIF(B12002131, ''), '.')::double precision,
NULLIF(NULLIF(B12002132, ''), '.')::double precision,
NULLIF(NULLIF(B12002133, ''), '.')::double precision,
NULLIF(NULLIF(B12002134, ''), '.')::double precision,
NULLIF(NULLIF(B12002135, ''), '.')::double precision,
NULLIF(NULLIF(B12002136, ''), '.')::double precision,
NULLIF(NULLIF(B12002137, ''), '.')::double precision,
NULLIF(NULLIF(B12002138, ''), '.')::double precision,
NULLIF(NULLIF(B12002139, ''), '.')::double precision,
NULLIF(NULLIF(B12002140, ''), '.')::double precision,
NULLIF(NULLIF(B12002141, ''), '.')::double precision,
NULLIF(NULLIF(B12002142, ''), '.')::double precision,
NULLIF(NULLIF(B12002143, ''), '.')::double precision,
NULLIF(NULLIF(B12002144, ''), '.')::double precision,
NULLIF(NULLIF(B12002145, ''), '.')::double precision,
NULLIF(NULLIF(B12002146, ''), '.')::double precision,
NULLIF(NULLIF(B12002147, ''), '.')::double precision,
NULLIF(NULLIF(B12002148, ''), '.')::double precision,
NULLIF(NULLIF(B12002149, ''), '.')::double precision,
NULLIF(NULLIF(B12002150, ''), '.')::double precision,
NULLIF(NULLIF(B12002151, ''), '.')::double precision,
NULLIF(NULLIF(B12002152, ''), '.')::double precision,
NULLIF(NULLIF(B12002153, ''), '.')::double precision,
NULLIF(NULLIF(B12002154, ''), '.')::double precision,
NULLIF(NULLIF(B12002155, ''), '.')::double precision,
NULLIF(NULLIF(B12002156, ''), '.')::double precision,
NULLIF(NULLIF(B12002157, ''), '.')::double precision,
NULLIF(NULLIF(B12002158, ''), '.')::double precision,
NULLIF(NULLIF(B12002159, ''), '.')::double precision,
NULLIF(NULLIF(B12002160, ''), '.')::double precision,
NULLIF(NULLIF(B12002161, ''), '.')::double precision,
NULLIF(NULLIF(B12002162, ''), '.')::double precision,
NULLIF(NULLIF(B12002163, ''), '.')::double precision,
NULLIF(NULLIF(B12002164, ''), '.')::double precision,
NULLIF(NULLIF(B12002165, ''), '.')::double precision,
NULLIF(NULLIF(B12002166, ''), '.')::double precision,
NULLIF(NULLIF(B12002167, ''), '.')::double precision,
NULLIF(NULLIF(B12002168, ''), '.')::double precision,
NULLIF(NULLIF(B12002169, ''), '.')::double precision,
NULLIF(NULLIF(B12002170, ''), '.')::double precision,
NULLIF(NULLIF(B12002171, ''), '.')::double precision,
NULLIF(NULLIF(B12002172, ''), '.')::double precision,
NULLIF(NULLIF(B12002173, ''), '.')::double precision,
NULLIF(NULLIF(B12002174, ''), '.')::double precision,
NULLIF(NULLIF(B12002175, ''), '.')::double precision,
NULLIF(NULLIF(B12002176, ''), '.')::double precision,
NULLIF(NULLIF(B12002177, ''), '.')::double precision,
NULLIF(NULLIF(B12002178, ''), '.')::double precision,
NULLIF(NULLIF(B12002179, ''), '.')::double precision,
NULLIF(NULLIF(B12002180, ''), '.')::double precision,
NULLIF(NULLIF(B12002181, ''), '.')::double precision,
NULLIF(NULLIF(B12002182, ''), '.')::double precision,
NULLIF(NULLIF(B12002183, ''), '.')::double precision,
NULLIF(NULLIF(B12002184, ''), '.')::double precision,
NULLIF(NULLIF(B12002185, ''), '.')::double precision,
NULLIF(NULLIF(B12002186, ''), '.')::double precision,
NULLIF(NULLIF(B12002187, ''), '.')::double precision
FROM tmp_seq0010;
INSERT INTO seq0011
SELECT fileid, filetype, upper(stusab), chariter, seq, logrecno::int,
NULLIF(NULLIF(B13001001, ''), '.')::double precision,
NULLIF(NULLIF(B13001002, ''), '.')::double precision,
NULLIF(NULLIF(B13001003, ''), '.')::double precision,
NULLIF(NULLIF(B13001004, ''), '.')::double precision,
NULLIF(NULLIF(B13001005, ''), '.')::double precision,
NULLIF(NULLIF(B13001006, ''), '.')::double precision,
NULLIF(NULLIF(B13001007, ''), '.')::double precision,
NULLIF(NULLIF(B13001008, ''), '.')::double precision,
NULLIF(NULLIF(B13001009, ''), '.')::double precision,
NULLIF(NULLIF(B13002001, ''), '.')::double precision,
NULLIF(NULLIF(B13002002, ''), '.')::double precision,
NULLIF(NULLIF(B13002003, ''), '.')::double precision,
NULLIF(NULLIF(B13002004, ''), '.')::double precision,
NULLIF(NULLIF(B13002005, ''), '.')::double precision,
NULLIF(NULLIF(B13002006, ''), '.')::double precision,
NULLIF(NULLIF(B13002007, ''), '.')::double precision,
NULLIF(NULLIF(B13002008, ''), '.')::double precision,
NULLIF(NULLIF(B13002009, ''), '.')::double precision,
NULLIF(NULLIF(B13002010, ''), '.')::double precision,
NULLIF(NULLIF(B13002011, ''), '.')::double precision,
NULLIF(NULLIF(B13002012, ''), '.')::double precision,
NULLIF(NULLIF(B13002013, ''), '.')::double precision,
NULLIF(NULLIF(B13002014, ''), '.')::double precision,
NULLIF(NULLIF(B13002015, ''), '.')::double precision,
NULLIF(NULLIF(B13002016, ''), '.')::double precision,
NULLIF(NULLIF(B13002017, ''), '.')::double precision,
NULLIF(NULLIF(B13002018, ''), '.')::double precision,
NULLIF(NULLIF(B13002019, ''), '.')::double precision
FROM tmp_seq0011;
INSERT INTO seq0012
SELECT fileid, filetype, upper(stusab), chariter, seq, logrecno::int,
NULLIF(NULLIF(B14001001, ''), '.')::double precision,
NULLIF(NULLIF(B14001002, ''), '.')::double precision,
NULLIF(NULLIF(B14001003, ''), '.')::double precision,
NULLIF(NULLIF(B14001004, ''), '.')::double precision,
NULLIF(NULLIF(B14001005, ''), '.')::double precision,
NULLIF(NULLIF(B14001006, ''), '.')::double precision,
NULLIF(NULLIF(B14001007, ''), '.')::double precision,
NULLIF(NULLIF(B14001008, ''), '.')::double precision,
NULLIF(NULLIF(B14001009, ''), '.')::double precision,
NULLIF(NULLIF(B14001010, ''), '.')::double precision,
NULLIF(NULLIF(B14002001, ''), '.')::double precision,
NULLIF(NULLIF(B14002002, ''), '.')::double precision,
NULLIF(NULLIF(B14002003, ''), '.')::double precision,
NULLIF(NULLIF(B14002004, ''), '.')::double precision,
NULLIF(NULLIF(B14002005, ''), '.')::double precision,
NULLIF(NULLIF(B14002006, ''), '.')::double precision,
NULLIF(NULLIF(B14002007, ''), '.')::double precision,
NULLIF(NULLIF(B14002008, ''), '.')::double precision,
NULLIF(NULLIF(B14002009, ''), '.')::double precision,
NULLIF(NULLIF(B14002010, ''), '.')::double precision,
NULLIF(NULLIF(B14002011, ''), '.')::double precision,
NULLIF(NULLIF(B14002012, ''), '.')::double precision,
NULLIF(NULLIF(B14002013, ''), '.')::double precision,
NULLIF(NULLIF(B14002014, ''), '.')::double precision,
NULLIF(NULLIF(B14002015, ''), '.')::double precision,
NULLIF(NULLIF(B14002016, ''), '.')::double precision,
NULLIF(NULLIF(B14002017, ''), '.')::double precision,
NULLIF(NULLIF(B14002018, ''), '.')::double precision,
NULLIF(NULLIF(B14002019, ''), '.')::double precision,
NULLIF(NULLIF(B14002020, ''), '.')::double precision,
NULLIF(NULLIF(B14002021, ''), '.')::double precision,
NULLIF(NULLIF(B14002022, ''), '.')::double precision,
NULLIF(NULLIF(B14002023, ''), '.')::double precision,
NULLIF(NULLIF(B14002024, ''), '.')::double precision,
NULLIF(NULLIF(B14002025, ''), '.')::double precision,
NULLIF(NULLIF(B14002026, ''), '.')::double precision,
NULLIF(NULLIF(B14002027, ''), '.')::double precision,
NULLIF(NULLIF(B14002028, ''), '.')::double precision,
NULLIF(NULLIF(B14002029, ''), '.')::double precision,
NULLIF(NULLIF(B14002030, ''), '.')::double precision,
NULLIF(NULLIF(B14002031, ''), '.')::double precision,
NULLIF(NULLIF(B14002032, ''), '.')::double precision,
NULLIF(NULLIF(B14002033, ''), '.')::double precision,
NULLIF(NULLIF(B14002034, ''), '.')::double precision,
NULLIF(NULLIF(B14002035, ''), '.')::double precision,
NULLIF(NULLIF(B14002036, ''), '.')::double precision,
NULLIF(NULLIF(B14002037, ''), '.')::double precision,
NULLIF(NULLIF(B14002038, ''), '.')::double precision,
NULLIF(NULLIF(B14002039, ''), '.')::double precision,
NULLIF(NULLIF(B14002040, ''), '.')::double precision,
NULLIF(NULLIF(B14002041, ''), '.')::double precision,
NULLIF(NULLIF(B14002042, ''), '.')::double precision,
NULLIF(NULLIF(B14002043, ''), '.')::double precision,
NULLIF(NULLIF(B14002044, ''), '.')::double precision,
NULLIF(NULLIF(B14002045, ''), '.')::double precision,
NULLIF(NULLIF(B14002046, ''), '.')::double precision,
NULLIF(NULLIF(B14002047, ''), '.')::double precision,
NULLIF(NULLIF(B14002048, ''), '.')::double precision,
NULLIF(NULLIF(B14002049, ''), '.')::double precision,
NULLIF(NULLIF(B14003001, ''), '.')::double precision,
NULLIF(NULLIF(B14003002, ''), '.')::double precision,
NULLIF(NULLIF(B14003003, ''), '.')::double precision,
NULLIF(NULLIF(B14003004, ''), '.')::double precision,
NULLIF(NULLIF(B14003005, ''), '.')::double precision,
NULLIF(NULLIF(B14003006, ''), '.')::double precision,
NULLIF(NULLIF(B14003007, ''), '.')::double precision,
NULLIF(NULLIF(B14003008, ''), '.')::double precision,
NULLIF(NULLIF(B14003009, ''), '.')::double precision,
NULLIF(NULLIF(B14003010, ''), '.')::double precision,
NULLIF(NULLIF(B14003011, ''), '.')::double precision,
NULLIF(NULLIF(B14003012, ''), '.')::double precision,
NULLIF(NULLIF(B14003013, ''), '.')::double precision,
NULLIF(NULLIF(B14003014, ''), '.')::double precision,
NULLIF(NULLIF(B14003015, ''), '.')::double precision,
NULLIF(NULLIF(B14003016, ''), '.')::double precision,
NULLIF(NULLIF(B14003017, ''), '.')::double precision,
NULLIF(NULLIF(B14003018, ''), '.')::double precision,
NULLIF(NULLIF(B14003019, ''), '.')::double precision,
NULLIF(NULLIF(B14003020, ''), '.')::double precision,
NULLIF(NULLIF(B14003021, ''), '.')::double precision,
NULLIF(NULLIF(B14003022, ''), '.')::double precision,
NULLIF(NULLIF(B14003023, ''), '.')::double precision,
NULLIF(NULLIF(B14003024, ''), '.')::double precision,
NULLIF(NULLIF(B14003025, ''), '.')::double precision,
NULLIF(NULLIF(B14003026, ''), '.')::double precision,
NULLIF(NULLIF(B14003027, ''), '.')::double precision,
NULLIF(NULLIF(B14003028, ''), '.')::double precision,
NULLIF(NULLIF(B14003029, ''), '.')::double precision,
NULLIF(NULLIF(B14003030, ''), '.')::double precision,
NULLIF(NULLIF(B14003031, ''), '.')::double precision,
NULLIF(NULLIF(B14003032, ''), '.')::double precision,
NULLIF(NULLIF(B14003033, ''), '.')::double precision,
NULLIF(NULLIF(B14003034, ''), '.')::double precision,
NULLIF(NULLIF(B14003035, ''), '.')::double precision,
NULLIF(NULLIF(B14003036, ''), '.')::double precision,
NULLIF(NULLIF(B14003037, ''), '.')::double precision,
NULLIF(NULLIF(B14003038, ''), '.')::double precision,
NULLIF(NULLIF(B14003039, ''), '.')::double precision,
NULLIF(NULLIF(B14003040, ''), '.')::double precision,
NULLIF(NULLIF(B14003041, ''), '.')::double precision,
NULLIF(NULLIF(B14003042, ''), '.')::double precision,
NULLIF(NULLIF(B14003043, ''), '.')::double precision,
NULLIF(NULLIF(B14003044, ''), '.')::double precision,
NULLIF(NULLIF(B14003045, ''), '.')::double precision,
NULLIF(NULLIF(B14003046, ''), '.')::double precision,
NULLIF(NULLIF(B14003047, ''), '.')::double precision,
NULLIF(NULLIF(B14003048, ''), '.')::double precision,
NULLIF(NULLIF(B14003049, ''), '.')::double precision,
NULLIF(NULLIF(B14003050, ''), '.')::double precision,
NULLIF(NULLIF(B14003051, ''), '.')::double precision,
NULLIF(NULLIF(B14003052, ''), '.')::double precision,
NULLIF(NULLIF(B14003053, ''), '.')::double precision,
NULLIF(NULLIF(B14003054, ''), '.')::double precision,
NULLIF(NULLIF(B14003055, ''), '.')::double precision,
NULLIF(NULLIF(B14003056, ''), '.')::double precision,
NULLIF(NULLIF(B14003057, ''), '.')::double precision,
NULLIF(NULLIF(B14004001, ''), '.')::double precision,
NULLIF(NULLIF(B14004002, ''), '.')::double precision,
NULLIF(NULLIF(B14004003, ''), '.')::double precision,
NULLIF(NULLIF(B14004004, ''), '.')::double precision,
NULLIF(NULLIF(B14004005, ''), '.')::double precision,
NULLIF(NULLIF(B14004006, ''), '.')::double precision,
NULLIF(NULLIF(B14004007, ''), '.')::double precision,
NULLIF(NULLIF(B14004008, ''), '.')::double precision,
NULLIF(NULLIF(B14004009, ''), '.')::double precision,
NULLIF(NULLIF(B14004010, ''), '.')::double precision,
NULLIF(NULLIF(B14004011, ''), '.')::double precision,
NULLIF(NULLIF(B14004012, ''), '.')::double precision,
NULLIF(NULLIF(B14004013, ''), '.')::double precision,
NULLIF(NULLIF(B14004014, ''), '.')::double precision,
NULLIF(NULLIF(B14004015, ''), '.')::double precision,
NULLIF(NULLIF(B14004016, ''), '.')::double precision,
NULLIF(NULLIF(B14004017, ''), '.')::double precision,
NULLIF(NULLIF(B14004018, ''), '.')::double precision,
NULLIF(NULLIF(B14004019, ''), '.')::double precision,
NULLIF(NULLIF(B14004020, ''), '.')::double precision,
NULLIF(NULLIF(B14004021, ''), '.')::double precision,
NULLIF(NULLIF(B14004022, ''), '.')::double precision,
NULLIF(NULLIF(B14004023, ''), '.')::double precision,
NULLIF(NULLIF(B14004024, ''), '.')::double precision,
NULLIF(NULLIF(B14004025, ''), '.')::double precision,
NULLIF(NULLIF(B14004026, ''), '.')::double precision,
NULLIF(NULLIF(B14004027, ''), '.')::double precision,
NULLIF(NULLIF(B14004028, ''), '.')::double precision,
NULLIF(NULLIF(B14004029, ''), '.')::double precision,
NULLIF(NULLIF(B14004030, ''), '.')::double precision,
NULLIF(NULLIF(B14004031, ''), '.')::double precision,
NULLIF(NULLIF(B14004032, ''), '.')::double precision,
NULLIF(NULLIF(B14004033, ''), '.')::double precision
FROM tmp_seq0012;
INSERT INTO seq0013
SELECT fileid, filetype, upper(stusab), chariter, seq, logrecno::int,
NULLIF(NULLIF(B15001001, ''), '.')::double precision,
NULLIF(NULLIF(B15001002, ''), '.')::double precision,
NULLIF(NULLIF(B15001003, ''), '.')::double precision,
NULLIF(NULLIF(B15001004, ''), '.')::double precision,
NULLIF(NULLIF(B15001005, ''), '.')::double precision,
NULLIF(NULLIF(B15001006, ''), '.')::double precision,
NULLIF(NULLIF(B15001007, ''), '.')::double precision,
NULLIF(NULLIF(B15001008, ''), '.')::double precision,
NULLIF(NULLIF(B15001009, ''), '.')::double precision,
NULLIF(NULLIF(B15001010, ''), '.')::double precision,
NULLIF(NULLIF(B15001011, ''), '.')::double precision,
NULLIF(NULLIF(B15001012, ''), '.')::double precision,
NULLIF(NULLIF(B15001013, ''), '.')::double precision,
NULLIF(NULLIF(B15001014, ''), '.')::double precision,
NULLIF(NULLIF(B15001015, ''), '.')::double precision,
NULLIF(NULLIF(B15001016, ''), '.')::double precision,
NULLIF(NULLIF(B15001017, ''), '.')::double precision,
NULLIF(NULLIF(B15001018, ''), '.')::double precision,
NULLIF(NULLIF(B15001019, ''), '.')::double precision,
NULLIF(NULLIF(B15001020, ''), '.')::double precision,
NULLIF(NULLIF(B15001021, ''), '.')::double precision,
NULLIF(NULLIF(B15001022, ''), '.')::double precision,
NULLIF(NULLIF(B15001023, ''), '.')::double precision,
NULLIF(NULLIF(B15001024, ''), '.')::double precision,
NULLIF(NULLIF(B15001025, ''), '.')::double precision,
NULLIF(NULLIF(B15001026, ''), '.')::double precision,
NULLIF(NULLIF(B15001027, ''), '.')::double precision,
NULLIF(NULLIF(B15001028, ''), '.')::double precision,
NULLIF(NULLIF(B15001029, ''), '.')::double precision,
NULLIF(NULLIF(B15001030, ''), '.')::double precision,
NULLIF(NULLIF(B15001031, ''), '.')::double precision,
NULLIF(NULLIF(B15001032, ''), '.')::double precision,
NULLIF(NULLIF(B15001033, ''), '.')::double precision,
NULLIF(NULLIF(B15001034, ''), '.')::double precision,
NULLIF(NULLIF(B15001035, ''), '.')::double precision,
NULLIF(NULLIF(B15001036, ''), '.')::double precision,
NULLIF(NULLIF(B15001037, ''), '.')::double precision,
NULLIF(NULLIF(B15001038, ''), '.')::double precision,
NULLIF(NULLIF(B15001039, ''), '.')::double precision,
NULLIF(NULLIF(B15001040, ''), '.')::double precision,
NULLIF(NULLIF(B15001041, ''), '.')::double precision,
NULLIF(NULLIF(B15001042, ''), '.')::double precision,
NULLIF(NULLIF(B15001043, ''), '.')::double precision,
NULLIF(NULLIF(B15001044, ''), '.')::double precision,
NULLIF(NULLIF(B15001045, ''), '.')::double precision,
NULLIF(NULLIF(B15001046, ''), '.')::double precision,
NULLIF(NULLIF(B15001047, ''), '.')::double precision,
NULLIF(NULLIF(B15001048, ''), '.')::double precision,
NULLIF(NULLIF(B15001049, ''), '.')::double precision,
NULLIF(NULLIF(B15001050, ''), '.')::double precision,
NULLIF(NULLIF(B15001051, ''), '.')::double precision,
NULLIF(NULLIF(B15001052, ''), '.')::double precision,
NULLIF(NULLIF(B15001053, ''), '.')::double precision,
NULLIF(NULLIF(B15001054, ''), '.')::double precision,
NULLIF(NULLIF(B15001055, ''), '.')::double precision,
NULLIF(NULLIF(B15001056, ''), '.')::double precision,
NULLIF(NULLIF(B15001057, ''), '.')::double precision,
NULLIF(NULLIF(B15001058, ''), '.')::double precision,
NULLIF(NULLIF(B15001059, ''), '.')::double precision,
NULLIF(NULLIF(B15001060, ''), '.')::double precision,
NULLIF(NULLIF(B15001061, ''), '.')::double precision,
NULLIF(NULLIF(B15001062, ''), '.')::double precision,
NULLIF(NULLIF(B15001063, ''), '.')::double precision,
NULLIF(NULLIF(B15001064, ''), '.')::double precision,
NULLIF(NULLIF(B15001065, ''), '.')::double precision,
NULLIF(NULLIF(B15001066, ''), '.')::double precision,
NULLIF(NULLIF(B15001067, ''), '.')::double precision,
NULLIF(NULLIF(B15001068, ''), '.')::double precision,
NULLIF(NULLIF(B15001069, ''), '.')::double precision,
NULLIF(NULLIF(B15001070, ''), '.')::double precision,
NULLIF(NULLIF(B15001071, ''), '.')::double precision,
NULLIF(NULLIF(B15001072, ''), '.')::double precision,
NULLIF(NULLIF(B15001073, ''), '.')::double precision,
NULLIF(NULLIF(B15001074, ''), '.')::double precision,
NULLIF(NULLIF(B15001075, ''), '.')::double precision,
NULLIF(NULLIF(B15001076, ''), '.')::double precision,
NULLIF(NULLIF(B15001077, ''), '.')::double precision,
NULLIF(NULLIF(B15001078, ''), '.')::double precision,
NULLIF(NULLIF(B15001079, ''), '.')::double precision,
NULLIF(NULLIF(B15001080, ''), '.')::double precision,
NULLIF(NULLIF(B15001081, ''), '.')::double precision,
NULLIF(NULLIF(B15001082, ''), '.')::double precision,
NULLIF(NULLIF(B15001083, ''), '.')::double precision,
NULLIF(NULLIF(B15002001, ''), '.')::double precision,
NULLIF(NULLIF(B15002002, ''), '.')::double precision,
NULLIF(NULLIF(B15002003, ''), '.')::double precision,
NULLIF(NULLIF(B15002004, ''), '.')::double precision,
NULLIF(NULLIF(B15002005, ''), '.')::double precision,
NULLIF(NULLIF(B15002006, ''), '.')::double precision,
NULLIF(NULLIF(B15002007, ''), '.')::double precision,
NULLIF(NULLIF(B15002008, ''), '.')::double precision,
NULLIF(NULLIF(B15002009, ''), '.')::double precision,
NULLIF(NULLIF(B15002010, ''), '.')::double precision,
NULLIF(NULLIF(B15002011, ''), '.')::double precision,
NULLIF(NULLIF(B15002012, ''), '.')::double precision,
NULLIF(NULLIF(B15002013, ''), '.')::double precision,
NULLIF(NULLIF(B15002014, ''), '.')::double precision,
NULLIF(NULLIF(B15002015, ''), '.')::double precision,
NULLIF(NULLIF(B15002016, ''), '.')::double precision,
NULLIF(NULLIF(B15002017, ''), '.')::double precision,
NULLIF(NULLIF(B15002018, ''), '.')::double precision,
NULLIF(NULLIF(B15002019, ''), '.')::double precision,
NULLIF(NULLIF(B15002020, ''), '.')::double precision,
NULLIF(NULLIF(B15002021, ''), '.')::double precision,
NULLIF(NULLIF(B15002022, ''), '.')::double precision,
NULLIF(NULLIF(B15002023, ''), '.')::double precision,
NULLIF(NULLIF(B15002024, ''), '.')::double precision,
NULLIF(NULLIF(B15002025, ''), '.')::double precision,
NULLIF(NULLIF(B15002026, ''), '.')::double precision,
NULLIF(NULLIF(B15002027, ''), '.')::double precision,
NULLIF(NULLIF(B15002028, ''), '.')::double precision,
NULLIF(NULLIF(B15002029, ''), '.')::double precision,
NULLIF(NULLIF(B15002030, ''), '.')::double precision,
NULLIF(NULLIF(B15002031, ''), '.')::double precision,
NULLIF(NULLIF(B15002032, ''), '.')::double precision,
NULLIF(NULLIF(B15002033, ''), '.')::double precision,
NULLIF(NULLIF(B15002034, ''), '.')::double precision,
NULLIF(NULLIF(B15002035, ''), '.')::double precision
FROM tmp_seq0013;
INSERT INTO seq0014
SELECT fileid, filetype, upper(stusab), chariter, seq, logrecno::int,
NULLIF(NULLIF(B16002001, ''), '.')::double precision,
NULLIF(NULLIF(B16002002, ''), '.')::double precision,
NULLIF(NULLIF(B16002003, ''), '.')::double precision,
NULLIF(NULLIF(B16002004, ''), '.')::double precision,
NULLIF(NULLIF(B16002005, ''), '.')::double precision,
NULLIF(NULLIF(B16002006, ''), '.')::double precision,
NULLIF(NULLIF(B16002007, ''), '.')::double precision,
NULLIF(NULLIF(B16002008, ''), '.')::double precision,
NULLIF(NULLIF(B16002009, ''), '.')::double precision,
NULLIF(NULLIF(B16002010, ''), '.')::double precision,
NULLIF(NULLIF(B16002011, ''), '.')::double precision,
NULLIF(NULLIF(B16002012, ''), '.')::double precision,
NULLIF(NULLIF(B16002013, ''), '.')::double precision,
NULLIF(NULLIF(B16002014, ''), '.')::double precision,
NULLIF(NULLIF(B16003001, ''), '.')::double precision,
NULLIF(NULLIF(B16003002, ''), '.')::double precision,
NULLIF(NULLIF(B16003003, ''), '.')::double precision,
NULLIF(NULLIF(B16003004, ''), '.')::double precision,
NULLIF(NULLIF(B16003005, ''), '.')::double precision,
NULLIF(NULLIF(B16003006, ''), '.')::double precision,
NULLIF(NULLIF(B16003007, ''), '.')::double precision,
NULLIF(NULLIF(B16003008, ''), '.')::double precision,
NULLIF(NULLIF(B16003009, ''), '.')::double precision,
NULLIF(NULLIF(B16003010, ''), '.')::double precision,
NULLIF(NULLIF(B16003011, ''), '.')::double precision,
NULLIF(NULLIF(B16003012, ''), '.')::double precision,
NULLIF(NULLIF(B16004001, ''), '.')::double precision,
NULLIF(NULLIF(B16004002, ''), '.')::double precision,
NULLIF(NULLIF(B16004003, ''), '.')::double precision,
NULLIF(NULLIF(B16004004, ''), '.')::double precision,
NULLIF(NULLIF(B16004005, ''), '.')::double precision,
NULLIF(NULLIF(B16004006, ''), '.')::double precision,
NULLIF(NULLIF(B16004007, ''), '.')::double precision,
NULLIF(NULLIF(B16004008, ''), '.')::double precision,
NULLIF(NULLIF(B16004009, ''), '.')::double precision,
NULLIF(NULLIF(B16004010, ''), '.')::double precision,
NULLIF(NULLIF(B16004011, ''), '.')::double precision,
NULLIF(NULLIF(B16004012, ''), '.')::double precision,
NULLIF(NULLIF(B16004013, ''), '.')::double precision,
NULLIF(NULLIF(B16004014, ''), '.')::double precision,
NULLIF(NULLIF(B16004015, ''), '.')::double precision,
NULLIF(NULLIF(B16004016, ''), '.')::double precision,
NULLIF(NULLIF(B16004017, ''), '.')::double precision,
NULLIF(NULLIF(B16004018, ''), '.')::double precision,
NULLIF(NULLIF(B16004019, ''), '.')::double precision,
NULLIF(NULLIF(B16004020, ''), '.')::double precision,
NULLIF(NULLIF(B16004021, ''), '.')::double precision,
NULLIF(NULLIF(B16004022, ''), '.')::double precision,
NULLIF(NULLIF(B16004023, ''), '.')::double precision,
NULLIF(NULLIF(B16004024, ''), '.')::double precision,
NULLIF(NULLIF(B16004025, ''), '.')::double precision,
NULLIF(NULLIF(B16004026, ''), '.')::double precision,
NULLIF(NULLIF(B16004027, ''), '.')::double precision,
NULLIF(NULLIF(B16004028, ''), '.')::double precision,
NULLIF(NULLIF(B16004029, ''), '.')::double precision,
NULLIF(NULLIF(B16004030, ''), '.')::double precision,
NULLIF(NULLIF(B16004031, ''), '.')::double precision,
NULLIF(NULLIF(B16004032, ''), '.')::double precision,
NULLIF(NULLIF(B16004033, ''), '.')::double precision,
NULLIF(NULLIF(B16004034, ''), '.')::double precision,
NULLIF(NULLIF(B16004035, ''), '.')::double precision,
NULLIF(NULLIF(B16004036, ''), '.')::double precision,
NULLIF(NULLIF(B16004037, ''), '.')::double precision,
NULLIF(NULLIF(B16004038, ''), '.')::double precision,
NULLIF(NULLIF(B16004039, ''), '.')::double precision,
NULLIF(NULLIF(B16004040, ''), '.')::double precision,
NULLIF(NULLIF(B16004041, ''), '.')::double precision,
NULLIF(NULLIF(B16004042, ''), '.')::double precision,
NULLIF(NULLIF(B16004043, ''), '.')::double precision,
NULLIF(NULLIF(B16004044, ''), '.')::double precision,
NULLIF(NULLIF(B16004045, ''), '.')::double precision,
NULLIF(NULLIF(B16004046, ''), '.')::double precision,
NULLIF(NULLIF(B16004047, ''), '.')::double precision,
NULLIF(NULLIF(B16004048, ''), '.')::double precision,
NULLIF(NULLIF(B16004049, ''), '.')::double precision,
NULLIF(NULLIF(B16004050, ''), '.')::double precision,
NULLIF(NULLIF(B16004051, ''), '.')::double precision,
NULLIF(NULLIF(B16004052, ''), '.')::double precision,
NULLIF(NULLIF(B16004053, ''), '.')::double precision,
NULLIF(NULLIF(B16004054, ''), '.')::double precision,
NULLIF(NULLIF(B16004055, ''), '.')::double precision,
NULLIF(NULLIF(B16004056, ''), '.')::double precision,
NULLIF(NULLIF(B16004057, ''), '.')::double precision,
NULLIF(NULLIF(B16004058, ''), '.')::double precision,
NULLIF(NULLIF(B16004059, ''), '.')::double precision,
NULLIF(NULLIF(B16004060, ''), '.')::double precision,
NULLIF(NULLIF(B16004061, ''), '.')::double precision,
NULLIF(NULLIF(B16004062, ''), '.')::double precision,
NULLIF(NULLIF(B16004063, ''), '.')::double precision,
NULLIF(NULLIF(B16004064, ''), '.')::double precision,
NULLIF(NULLIF(B16004065, ''), '.')::double precision,
NULLIF(NULLIF(B16004066, ''), '.')::double precision,
NULLIF(NULLIF(B16004067, ''), '.')::double precision,
NULLIF(NULLIF(B16005001, ''), '.')::double precision,
NULLIF(NULLIF(B16005002, ''), '.')::double precision,
NULLIF(NULLIF(B16005003, ''), '.')::double precision,
NULLIF(NULLIF(B16005004, ''), '.')::double precision,
NULLIF(NULLIF(B16005005, ''), '.')::double precision,
NULLIF(NULLIF(B16005006, ''), '.')::double precision,
NULLIF(NULLIF(B16005007, ''), '.')::double precision,
NULLIF(NULLIF(B16005008, ''), '.')::double precision,
NULLIF(NULLIF(B16005009, ''), '.')::double precision,
NULLIF(NULLIF(B16005010, ''), '.')::double precision,
NULLIF(NULLIF(B16005011, ''), '.')::double precision,
NULLIF(NULLIF(B16005012, ''), '.')::double precision,
NULLIF(NULLIF(B16005013, ''), '.')::double precision,
NULLIF(NULLIF(B16005014, ''), '.')::double precision,
NULLIF(NULLIF(B16005015, ''), '.')::double precision,
NULLIF(NULLIF(B16005016, ''), '.')::double precision,
NULLIF(NULLIF(B16005017, ''), '.')::double precision,
NULLIF(NULLIF(B16005018, ''), '.')::double precision,
NULLIF(NULLIF(B16005019, ''), '.')::double precision,
NULLIF(NULLIF(B16005020, ''), '.')::double precision,
NULLIF(NULLIF(B16005021, ''), '.')::double precision,
NULLIF(NULLIF(B16005022, ''), '.')::double precision,
NULLIF(NULLIF(B16005023, ''), '.')::double precision,
NULLIF(NULLIF(B16005024, ''), '.')::double precision,
NULLIF(NULLIF(B16005025, ''), '.')::double precision,
NULLIF(NULLIF(B16005026, ''), '.')::double precision,
NULLIF(NULLIF(B16005027, ''), '.')::double precision,
NULLIF(NULLIF(B16005028, ''), '.')::double precision,
NULLIF(NULLIF(B16005029, ''), '.')::double precision,
NULLIF(NULLIF(B16005030, ''), '.')::double precision,
NULLIF(NULLIF(B16005031, ''), '.')::double precision,
NULLIF(NULLIF(B16005032, ''), '.')::double precision,
NULLIF(NULLIF(B16005033, ''), '.')::double precision,
NULLIF(NULLIF(B16005034, ''), '.')::double precision,
NULLIF(NULLIF(B16005035, ''), '.')::double precision,
NULLIF(NULLIF(B16005036, ''), '.')::double precision,
NULLIF(NULLIF(B16005037, ''), '.')::double precision,
NULLIF(NULLIF(B16005038, ''), '.')::double precision,
NULLIF(NULLIF(B16005039, ''), '.')::double precision,
NULLIF(NULLIF(B16005040, ''), '.')::double precision,
NULLIF(NULLIF(B16005041, ''), '.')::double precision,
NULLIF(NULLIF(B16005042, ''), '.')::double precision,
NULLIF(NULLIF(B16005043, ''), '.')::double precision,
NULLIF(NULLIF(B16005044, ''), '.')::double precision,
NULLIF(NULLIF(B16005045, ''), '.')::double precision
FROM tmp_seq0014;
INSERT INTO seq0015
SELECT fileid, filetype, upper(stusab), chariter, seq, logrecno::int,
NULLIF(NULLIF(B17001001, ''), '.')::double precision,
NULLIF(NULLIF(B17001002, ''), '.')::double precision,
NULLIF(NULLIF(B17001003, ''), '.')::double precision,
NULLIF(NULLIF(B17001004, ''), '.')::double precision,
NULLIF(NULLIF(B17001005, ''), '.')::double precision,
NULLIF(NULLIF(B17001006, ''), '.')::double precision,
NULLIF(NULLIF(B17001007, ''), '.')::double precision,
NULLIF(NULLIF(B17001008, ''), '.')::double precision,
NULLIF(NULLIF(B17001009, ''), '.')::double precision,
NULLIF(NULLIF(B17001010, ''), '.')::double precision,
NULLIF(NULLIF(B17001011, ''), '.')::double precision,
NULLIF(NULLIF(B17001012, ''), '.')::double precision,
NULLIF(NULLIF(B17001013, ''), '.')::double precision,
NULLIF(NULLIF(B17001014, ''), '.')::double precision,
NULLIF(NULLIF(B17001015, ''), '.')::double precision,
NULLIF(NULLIF(B17001016, ''), '.')::double precision,
NULLIF(NULLIF(B17001017, ''), '.')::double precision,
NULLIF(NULLIF(B17001018, ''), '.')::double precision,
NULLIF(NULLIF(B17001019, ''), '.')::double precision,
NULLIF(NULLIF(B17001020, ''), '.')::double precision,
NULLIF(NULLIF(B17001021, ''), '.')::double precision,
NULLIF(NULLIF(B17001022, ''), '.')::double precision,
NULLIF(NULLIF(B17001023, ''), '.')::double precision,
NULLIF(NULLIF(B17001024, ''), '.')::double precision,
NULLIF(NULLIF(B17001025, ''), '.')::double precision,
NULLIF(NULLIF(B17001026, ''), '.')::double precision,
NULLIF(NULLIF(B17001027, ''), '.')::double precision,
NULLIF(NULLIF(B17001028, ''), '.')::double precision,
NULLIF(NULLIF(B17001029, ''), '.')::double precision,
NULLIF(NULLIF(B17001030, ''), '.')::double precision,
NULLIF(NULLIF(B17001031, ''), '.')::double precision,
NULLIF(NULLIF(B17001032, ''), '.')::double precision,
NULLIF(NULLIF(B17001033, ''), '.')::double precision,
NULLIF(NULLIF(B17001034, ''), '.')::double precision,
NULLIF(NULLIF(B17001035, ''), '.')::double precision,
NULLIF(NULLIF(B17001036, ''), '.')::double precision,
NULLIF(NULLIF(B17001037, ''), '.')::double precision,
NULLIF(NULLIF(B17001038, ''), '.')::double precision,
NULLIF(NULLIF(B17001039, ''), '.')::double precision,
NULLIF(NULLIF(B17001040, ''), '.')::double precision,
NULLIF(NULLIF(B17001041, ''), '.')::double precision,
NULLIF(NULLIF(B17001042, ''), '.')::double precision,
NULLIF(NULLIF(B17001043, ''), '.')::double precision,
NULLIF(NULLIF(B17001044, ''), '.')::double precision,
NULLIF(NULLIF(B17001045, ''), '.')::double precision,
NULLIF(NULLIF(B17001046, ''), '.')::double precision,
NULLIF(NULLIF(B17001047, ''), '.')::double precision,
NULLIF(NULLIF(B17001048, ''), '.')::double precision,
NULLIF(NULLIF(B17001049, ''), '.')::double precision,
NULLIF(NULLIF(B17001050, ''), '.')::double precision,
NULLIF(NULLIF(B17001051, ''), '.')::double precision,
NULLIF(NULLIF(B17001052, ''), '.')::double precision,
NULLIF(NULLIF(B17001053, ''), '.')::double precision,
NULLIF(NULLIF(B17001054, ''), '.')::double precision,
NULLIF(NULLIF(B17001055, ''), '.')::double precision,
NULLIF(NULLIF(B17001056, ''), '.')::double precision,
NULLIF(NULLIF(B17001057, ''), '.')::double precision,
NULLIF(NULLIF(B17001058, ''), '.')::double precision,
NULLIF(NULLIF(B17001059, ''), '.')::double precision,
NULLIF(NULLIF(B17006001, ''), '.')::double precision,
NULLIF(NULLIF(B17006002, ''), '.')::double precision,
NULLIF(NULLIF(B17006003, ''), '.')::double precision,
NULLIF(NULLIF(B17006004, ''), '.')::double precision,
NULLIF(NULLIF(B17006005, ''), '.')::double precision,
NULLIF(NULLIF(B17006006, ''), '.')::double precision,
NULLIF(NULLIF(B17006007, ''), '.')::double precision,
NULLIF(NULLIF(B17006008, ''), '.')::double precision,
NULLIF(NULLIF(B17006009, ''), '.')::double precision,
NULLIF(NULLIF(B17006010, ''), '.')::double precision,
NULLIF(NULLIF(B17006011, ''), '.')::double precision,
NULLIF(NULLIF(B17006012, ''), '.')::double precision,
NULLIF(NULLIF(B17006013, ''), '.')::double precision,
NULLIF(NULLIF(B17006014, ''), '.')::double precision,
NULLIF(NULLIF(B17006015, ''), '.')::double precision,
NULLIF(NULLIF(B17006016, ''), '.')::double precision,
NULLIF(NULLIF(B17006017, ''), '.')::double precision,
NULLIF(NULLIF(B17006018, ''), '.')::double precision,
NULLIF(NULLIF(B17006019, ''), '.')::double precision,
NULLIF(NULLIF(B17006020, ''), '.')::double precision,
NULLIF(NULLIF(B17006021, ''), '.')::double precision,
NULLIF(NULLIF(B17006022, ''), '.')::double precision,
NULLIF(NULLIF(B17006023, ''), '.')::double precision,
NULLIF(NULLIF(B17006024, ''), '.')::double precision,
NULLIF(NULLIF(B17006025, ''), '.')::double precision,
NULLIF(NULLIF(B17006026, ''), '.')::double precision,
NULLIF(NULLIF(B17006027, ''), '.')::double precision,
NULLIF(NULLIF(B17006028, ''), '.')::double precision,
NULLIF(NULLIF(B17006029, ''), '.')::double precision,
NULLIF(NULLIF(B17007001, ''), '.')::double precision,
NULLIF(NULLIF(B17007002, ''), '.')::double precision,
NULLIF(NULLIF(B17007003, ''), '.')::double precision,
NULLIF(NULLIF(B17007004, ''), '.')::double precision,
NULLIF(NULLIF(B17007005, ''), '.')::double precision,
NULLIF(NULLIF(B17007006, ''), '.')::double precision,
NULLIF(NULLIF(B17007007, ''), '.')::double precision,
NULLIF(NULLIF(B17007008, ''), '.')::double precision,
NULLIF(NULLIF(B17007009, ''), '.')::double precision,
NULLIF(NULLIF(B17007010, ''), '.')::double precision,
NULLIF(NULLIF(B17007011, ''), '.')::double precision,
NULLIF(NULLIF(B17007012, ''), '.')::double precision,
NULLIF(NULLIF(B17007013, ''), '.')::double precision,
NULLIF(NULLIF(B17007014, ''), '.')::double precision,
NULLIF(NULLIF(B17007015, ''), '.')::double precision,
NULLIF(NULLIF(B17007016, ''), '.')::double precision,
NULLIF(NULLIF(B17007017, ''), '.')::double precision,
NULLIF(NULLIF(B17007018, ''), '.')::double precision,
NULLIF(NULLIF(B17007019, ''), '.')::double precision,
NULLIF(NULLIF(B17007020, ''), '.')::double precision,
NULLIF(NULLIF(B17007021, ''), '.')::double precision,
NULLIF(NULLIF(B17007022, ''), '.')::double precision,
NULLIF(NULLIF(B17007023, ''), '.')::double precision,
NULLIF(NULLIF(B17007024, ''), '.')::double precision,
NULLIF(NULLIF(B17007025, ''), '.')::double precision,
NULLIF(NULLIF(B17007026, ''), '.')::double precision,
NULLIF(NULLIF(B17007027, ''), '.')::double precision,
NULLIF(NULLIF(B17007028, ''), '.')::double precision,
NULLIF(NULLIF(B17007029, ''), '.')::double precision,
NULLIF(NULLIF(B17007030, ''), '.')::double precision,
NULLIF(NULLIF(B17007031, ''), '.')::double precision,
NULLIF(NULLIF(B17007032, ''), '.')::double precision,
NULLIF(NULLIF(B17007033, ''), '.')::double precision,
NULLIF(NULLIF(B17007034, ''), '.')::double precision,
NULLIF(NULLIF(B17007035, ''), '.')::double precision,
NULLIF(NULLIF(B17007036, ''), '.')::double precision,
NULLIF(NULLIF(B17007037, ''), '.')::double precision,
NULLIF(NULLIF(B17007038, ''), '.')::double precision,
NULLIF(NULLIF(B17007039, ''), '.')::double precision,
NULLIF(NULLIF(B17007040, ''), '.')::double precision,
NULLIF(NULLIF(B17007041, ''), '.')::double precision,
NULLIF(NULLIF(B17007042, ''), '.')::double precision,
NULLIF(NULLIF(B17007043, ''), '.')::double precision,
NULLIF(NULLIF(B17008001, ''), '.')::double precision,
NULLIF(NULLIF(B17008002, ''), '.')::double precision,
NULLIF(NULLIF(B17008003, ''), '.')::double precision,
NULLIF(NULLIF(B17009001, ''), '.')::double precision,
NULLIF(NULLIF(B17009002, ''), '.')::double precision,
NULLIF(NULLIF(B17009003, ''), '.')::double precision,
NULLIF(NULLIF(B17009004, ''), '.')::double precision,
NULLIF(NULLIF(B17009005, ''), '.')::double precision,
NULLIF(NULLIF(B17009006, ''), '.')::double precision,
NULLIF(NULLIF(B17009007, ''), '.')::double precision,
NULLIF(NULLIF(B17009008, ''), '.')::double precision,
NULLIF(NULLIF(B17009009, ''), '.')::double precision,
NULLIF(NULLIF(B17009010, ''), '.')::double precision,
NULLIF(NULLIF(B17009011, ''), '.')::double precision,
NULLIF(NULLIF(B17009012, ''), '.')::double precision,
NULLIF(NULLIF(B17009013, ''), '.')::double precision,
NULLIF(NULLIF(B17009014, ''), '.')::double precision,
NULLIF(NULLIF(B17009015, ''), '.')::double precision,
NULLIF(NULLIF(B17009016, ''), '.')::double precision,
NULLIF(NULLIF(B17009017, ''), '.')::double precision,
NULLIF(NULLIF(B17009018, ''), '.')::double precision,
NULLIF(NULLIF(B17009019, ''), '.')::double precision,
NULLIF(NULLIF(B17009020, ''), '.')::double precision,
NULLIF(NULLIF(B17009021, ''), '.')::double precision,
NULLIF(NULLIF(B17010001, ''), '.')::double precision,
NULLIF(NULLIF(B17010002, ''), '.')::double precision,
NULLIF(NULLIF(B17010003, ''), '.')::double precision,
NULLIF(NULLIF(B17010004, ''), '.')::double precision,
NULLIF(NULLIF(B17010005, ''), '.')::double precision,
NULLIF(NULLIF(B17010006, ''), '.')::double precision,
NULLIF(NULLIF(B17010007, ''), '.')::double precision,
NULLIF(NULLIF(B17010008, ''), '.')::double precision,
NULLIF(NULLIF(B17010009, ''), '.')::double precision,
NULLIF(NULLIF(B17010010, ''), '.')::double precision,
NULLIF(NULLIF(B17010011, ''), '.')::double precision,
NULLIF(NULLIF(B17010012, ''), '.')::double precision,
NULLIF(NULLIF(B17010013, ''), '.')::double precision,
NULLIF(NULLIF(B17010014, ''), '.')::double precision,
NULLIF(NULLIF(B17010015, ''), '.')::double precision,
NULLIF(NULLIF(B17010016, ''), '.')::double precision,
NULLIF(NULLIF(B17010017, ''), '.')::double precision,
NULLIF(NULLIF(B17010018, ''), '.')::double precision,
NULLIF(NULLIF(B17010019, ''), '.')::double precision,
NULLIF(NULLIF(B17010020, ''), '.')::double precision,
NULLIF(NULLIF(B17010021, ''), '.')::double precision,
NULLIF(NULLIF(B17010022, ''), '.')::double precision,
NULLIF(NULLIF(B17010023, ''), '.')::double precision,
NULLIF(NULLIF(B17010024, ''), '.')::double precision,
NULLIF(NULLIF(B17010025, ''), '.')::double precision,
NULLIF(NULLIF(B17010026, ''), '.')::double precision,
NULLIF(NULLIF(B17010027, ''), '.')::double precision,
NULLIF(NULLIF(B17010028, ''), '.')::double precision,
NULLIF(NULLIF(B17010029, ''), '.')::double precision,
NULLIF(NULLIF(B17010030, ''), '.')::double precision,
NULLIF(NULLIF(B17010031, ''), '.')::double precision,
NULLIF(NULLIF(B17010032, ''), '.')::double precision,
NULLIF(NULLIF(B17010033, ''), '.')::double precision,
NULLIF(NULLIF(B17010034, ''), '.')::double precision,
NULLIF(NULLIF(B17010035, ''), '.')::double precision,
NULLIF(NULLIF(B17010036, ''), '.')::double precision,
NULLIF(NULLIF(B17010037, ''), '.')::double precision,
NULLIF(NULLIF(B17010038, ''), '.')::double precision,
NULLIF(NULLIF(B17010039, ''), '.')::double precision,
NULLIF(NULLIF(B17010040, ''), '.')::double precision,
NULLIF(NULLIF(B17010041, ''), '.')::double precision,
NULLIF(NULLIF(B17011001, ''), '.')::double precision,
NULLIF(NULLIF(B17011002, ''), '.')::double precision,
NULLIF(NULLIF(B17011003, ''), '.')::double precision,
NULLIF(NULLIF(B17011004, ''), '.')::double precision,
NULLIF(NULLIF(B17011005, ''), '.')::double precision,
NULLIF(NULLIF(C17002001, ''), '.')::double precision,
NULLIF(NULLIF(C17002002, ''), '.')::double precision,
NULLIF(NULLIF(C17002003, ''), '.')::double precision,
NULLIF(NULLIF(C17002004, ''), '.')::double precision,
NULLIF(NULLIF(C17002005, ''), '.')::double precision,
NULLIF(NULLIF(C17002006, ''), '.')::double precision,
NULLIF(NULLIF(C17002007, ''), '.')::double precision,
NULLIF(NULLIF(C17002008, ''), '.')::double precision
FROM tmp_seq0015;
INSERT INTO seq0016
SELECT fileid, filetype, upper(stusab), chariter, seq, logrecno::int,
NULLIF(NULLIF(B17015001, ''), '.')::double precision,
NULLIF(NULLIF(B17015002, ''), '.')::double precision,
NULLIF(NULLIF(B17015003, ''), '.')::double precision,
NULLIF(NULLIF(B17015004, ''), '.')::double precision,
NULLIF(NULLIF(B17015005, ''), '.')::double precision,
NULLIF(NULLIF(B17015006, ''), '.')::double precision,
NULLIF(NULLIF(B17015007, ''), '.')::double precision,
NULLIF(NULLIF(B17015008, ''), '.')::double precision,
NULLIF(NULLIF(B17015009, ''), '.')::double precision,
NULLIF(NULLIF(B17015010, ''), '.')::double precision,
NULLIF(NULLIF(B17015011, ''), '.')::double precision,
NULLIF(NULLIF(B17015012, ''), '.')::double precision,
NULLIF(NULLIF(B17015013, ''), '.')::double precision,
NULLIF(NULLIF(B17015014, ''), '.')::double precision,
NULLIF(NULLIF(B17015015, ''), '.')::double precision,
NULLIF(NULLIF(B17015016, ''), '.')::double precision,
NULLIF(NULLIF(B17015017, ''), '.')::double precision,
NULLIF(NULLIF(B17015018, ''), '.')::double precision,
NULLIF(NULLIF(B17015019, ''), '.')::double precision,
NULLIF(NULLIF(B17015020, ''), '.')::double precision,
NULLIF(NULLIF(B17015021, ''), '.')::double precision,
NULLIF(NULLIF(B17015022, ''), '.')::double precision,
NULLIF(NULLIF(B17015023, ''), '.')::double precision,
NULLIF(NULLIF(B17015024, ''), '.')::double precision,
NULLIF(NULLIF(B17015025, ''), '.')::double precision,
NULLIF(NULLIF(B17015026, ''), '.')::double precision,
NULLIF(NULLIF(B17015027, ''), '.')::double precision,
NULLIF(NULLIF(B17015028, ''), '.')::double precision,
NULLIF(NULLIF(B17015029, ''), '.')::double precision,
NULLIF(NULLIF(B17015030, ''), '.')::double precision,
NULLIF(NULLIF(B17015031, ''), '.')::double precision,
NULLIF(NULLIF(B17015032, ''), '.')::double precision,
NULLIF(NULLIF(B17015033, ''), '.')::double precision,
NULLIF(NULLIF(B17015034, ''), '.')::double precision,
NULLIF(NULLIF(B17015035, ''), '.')::double precision,
NULLIF(NULLIF(B17015036, ''), '.')::double precision,
NULLIF(NULLIF(B17015037, ''), '.')::double precision,
NULLIF(NULLIF(B17015038, ''), '.')::double precision,
NULLIF(NULLIF(B17015039, ''), '.')::double precision,
NULLIF(NULLIF(B17015040, ''), '.')::double precision,
NULLIF(NULLIF(B17015041, ''), '.')::double precision,
NULLIF(NULLIF(B17015042, ''), '.')::double precision,
NULLIF(NULLIF(B17015043, ''), '.')::double precision,
NULLIF(NULLIF(B17015044, ''), '.')::double precision,
NULLIF(NULLIF(B17015045, ''), '.')::double precision,
NULLIF(NULLIF(B17015046, ''), '.')::double precision,
NULLIF(NULLIF(B17015047, ''), '.')::double precision,
NULLIF(NULLIF(B17016001, ''), '.')::double precision,
NULLIF(NULLIF(B17016002, ''), '.')::double precision,
NULLIF(NULLIF(B17016003, ''), '.')::double precision,
NULLIF(NULLIF(B17016004, ''), '.')::double precision,
NULLIF(NULLIF(B17016005, ''), '.')::double precision,
NULLIF(NULLIF(B17016006, ''), '.')::double precision,
NULLIF(NULLIF(B17016007, ''), '.')::double precision,
NULLIF(NULLIF(B17016008, ''), '.')::double precision,
NULLIF(NULLIF(B17016009, ''), '.')::double precision,
NULLIF(NULLIF(B17016010, ''), '.')::double precision,
NULLIF(NULLIF(B17016011, ''), '.')::double precision,
NULLIF(NULLIF(B17016012, ''), '.')::double precision,
NULLIF(NULLIF(B17016013, ''), '.')::double precision,
NULLIF(NULLIF(B17016014, ''), '.')::double precision,
NULLIF(NULLIF(B17016015, ''), '.')::double precision,
NULLIF(NULLIF(B17016016, ''), '.')::double precision,
NULLIF(NULLIF(B17016017, ''), '.')::double precision,
NULLIF(NULLIF(B17016018, ''), '.')::double precision,
NULLIF(NULLIF(B17016019, ''), '.')::double precision,
NULLIF(NULLIF(B17016020, ''), '.')::double precision,
NULLIF(NULLIF(B17016021, ''), '.')::double precision,
NULLIF(NULLIF(B17016022, ''), '.')::double precision,
NULLIF(NULLIF(B17016023, ''), '.')::double precision,
NULLIF(NULLIF(B17016024, ''), '.')::double precision,
NULLIF(NULLIF(B17016025, ''), '.')::double precision,
NULLIF(NULLIF(B17016026, ''), '.')::double precision,
NULLIF(NULLIF(B17016027, ''), '.')::double precision,
NULLIF(NULLIF(B17016028, ''), '.')::double precision,
NULLIF(NULLIF(B17016029, ''), '.')::double precision,
NULLIF(NULLIF(B17016030, ''), '.')::double precision,
NULLIF(NULLIF(B17016031, ''), '.')::double precision,
NULLIF(NULLIF(B17016032, ''), '.')::double precision,
NULLIF(NULLIF(B17016033, ''), '.')::double precision,
NULLIF(NULLIF(B17016034, ''), '.')::double precision,
NULLIF(NULLIF(B17016035, ''), '.')::double precision,
NULLIF(NULLIF(B17016036, ''), '.')::double precision,
NULLIF(NULLIF(B17016037, ''), '.')::double precision,
NULLIF(NULLIF(B17016038, ''), '.')::double precision,
NULLIF(NULLIF(B17016039, ''), '.')::double precision,
NULLIF(NULLIF(B17016040, ''), '.')::double precision,
NULLIF(NULLIF(B17016041, ''), '.')::double precision,
NULLIF(NULLIF(B17016042, ''), '.')::double precision,
NULLIF(NULLIF(B17016043, ''), '.')::double precision,
NULLIF(NULLIF(B17016044, ''), '.')::double precision,
NULLIF(NULLIF(B17016045, ''), '.')::double precision,
NULLIF(NULLIF(B17016046, ''), '.')::double precision,
NULLIF(NULLIF(B17016047, ''), '.')::double precision,
NULLIF(NULLIF(B17017001, ''), '.')::double precision,
NULLIF(NULLIF(B17017002, ''), '.')::double precision,
NULLIF(NULLIF(B17017003, ''), '.')::double precision,
NULLIF(NULLIF(B17017004, ''), '.')::double precision,
NULLIF(NULLIF(B17017005, ''), '.')::double precision,
NULLIF(NULLIF(B17017006, ''), '.')::double precision,
NULLIF(NULLIF(B17017007, ''), '.')::double precision,
NULLIF(NULLIF(B17017008, ''), '.')::double precision,
NULLIF(NULLIF(B17017009, ''), '.')::double precision,
NULLIF(NULLIF(B17017010, ''), '.')::double precision,
NULLIF(NULLIF(B17017011, ''), '.')::double precision,
NULLIF(NULLIF(B17017012, ''), '.')::double precision,
NULLIF(NULLIF(B17017013, ''), '.')::double precision,
NULLIF(NULLIF(B17017014, ''), '.')::double precision,
NULLIF(NULLIF(B17017015, ''), '.')::double precision,
NULLIF(NULLIF(B17017016, ''), '.')::double precision,
NULLIF(NULLIF(B17017017, ''), '.')::double precision,
NULLIF(NULLIF(B17017018, ''), '.')::double precision,
NULLIF(NULLIF(B17017019, ''), '.')::double precision,
NULLIF(NULLIF(B17017020, ''), '.')::double precision,
NULLIF(NULLIF(B17017021, ''), '.')::double precision,
NULLIF(NULLIF(B17017022, ''), '.')::double precision,
NULLIF(NULLIF(B17017023, ''), '.')::double precision,
NULLIF(NULLIF(B17017024, ''), '.')::double precision,
NULLIF(NULLIF(B17017025, ''), '.')::double precision,
NULLIF(NULLIF(B17017026, ''), '.')::double precision,
NULLIF(NULLIF(B17017027, ''), '.')::double precision,
NULLIF(NULLIF(B17017028, ''), '.')::double precision,
NULLIF(NULLIF(B17017029, ''), '.')::double precision,
NULLIF(NULLIF(B17017030, ''), '.')::double precision,
NULLIF(NULLIF(B17017031, ''), '.')::double precision,
NULLIF(NULLIF(B17017032, ''), '.')::double precision,
NULLIF(NULLIF(B17017033, ''), '.')::double precision,
NULLIF(NULLIF(B17017034, ''), '.')::double precision,
NULLIF(NULLIF(B17017035, ''), '.')::double precision,
NULLIF(NULLIF(B17017036, ''), '.')::double precision,
NULLIF(NULLIF(B17017037, ''), '.')::double precision,
NULLIF(NULLIF(B17017038, ''), '.')::double precision,
NULLIF(NULLIF(B17017039, ''), '.')::double precision,
NULLIF(NULLIF(B17017040, ''), '.')::double precision,
NULLIF(NULLIF(B17017041, ''), '.')::double precision,
NULLIF(NULLIF(B17017042, ''), '.')::double precision,
NULLIF(NULLIF(B17017043, ''), '.')::double precision,
NULLIF(NULLIF(B17017044, ''), '.')::double precision,
NULLIF(NULLIF(B17017045, ''), '.')::double precision,
NULLIF(NULLIF(B17017046, ''), '.')::double precision,
NULLIF(NULLIF(B17017047, ''), '.')::double precision,
NULLIF(NULLIF(B17017048, ''), '.')::double precision,
NULLIF(NULLIF(B17017049, ''), '.')::double precision,
NULLIF(NULLIF(B17017050, ''), '.')::double precision,
NULLIF(NULLIF(B17017051, ''), '.')::double precision,
NULLIF(NULLIF(B17017052, ''), '.')::double precision,
NULLIF(NULLIF(B17017053, ''), '.')::double precision,
NULLIF(NULLIF(B17017054, ''), '.')::double precision,
NULLIF(NULLIF(B17017055, ''), '.')::double precision,
NULLIF(NULLIF(B17017056, ''), '.')::double precision,
NULLIF(NULLIF(B17017057, ''), '.')::double precision,
NULLIF(NULLIF(B17017058, ''), '.')::double precision,
NULLIF(NULLIF(B17017059, ''), '.')::double precision,
NULLIF(NULLIF(B17021001, ''), '.')::double precision,
NULLIF(NULLIF(B17021002, ''), '.')::double precision,
NULLIF(NULLIF(B17021003, ''), '.')::double precision,
NULLIF(NULLIF(B17021004, ''), '.')::double precision,
NULLIF(NULLIF(B17021005, ''), '.')::double precision,
NULLIF(NULLIF(B17021006, ''), '.')::double precision,
NULLIF(NULLIF(B17021007, ''), '.')::double precision,
NULLIF(NULLIF(B17021008, ''), '.')::double precision,
NULLIF(NULLIF(B17021009, ''), '.')::double precision,
NULLIF(NULLIF(B17021010, ''), '.')::double precision,
NULLIF(NULLIF(B17021011, ''), '.')::double precision,
NULLIF(NULLIF(B17021012, ''), '.')::double precision,
NULLIF(NULLIF(B17021013, ''), '.')::double precision,
NULLIF(NULLIF(B17021014, ''), '.')::double precision,
NULLIF(NULLIF(B17021015, ''), '.')::double precision,
NULLIF(NULLIF(B17021016, ''), '.')::double precision,
NULLIF(NULLIF(B17021017, ''), '.')::double precision,
NULLIF(NULLIF(B17021018, ''), '.')::double precision,
NULLIF(NULLIF(B17021019, ''), '.')::double precision,
NULLIF(NULLIF(B17021020, ''), '.')::double precision,
NULLIF(NULLIF(B17021021, ''), '.')::double precision,
NULLIF(NULLIF(B17021022, ''), '.')::double precision,
NULLIF(NULLIF(B17021023, ''), '.')::double precision,
NULLIF(NULLIF(B17021024, ''), '.')::double precision,
NULLIF(NULLIF(B17021025, ''), '.')::double precision,
NULLIF(NULLIF(B17021026, ''), '.')::double precision,
NULLIF(NULLIF(B17021027, ''), '.')::double precision,
NULLIF(NULLIF(B17021028, ''), '.')::double precision,
NULLIF(NULLIF(B17021029, ''), '.')::double precision,
NULLIF(NULLIF(B17021030, ''), '.')::double precision,
NULLIF(NULLIF(B17021031, ''), '.')::double precision,
NULLIF(NULLIF(B17021032, ''), '.')::double precision,
NULLIF(NULLIF(B17021033, ''), '.')::double precision,
NULLIF(NULLIF(B17021034, ''), '.')::double precision,
NULLIF(NULLIF(B17021035, ''), '.')::double precision
FROM tmp_seq0016;
INSERT INTO seq0017
SELECT fileid, filetype, upper(stusab), chariter, seq, logrecno::int,
NULLIF(NULLIF(B17022001, ''), '.')::double precision,
NULLIF(NULLIF(B17022002, ''), '.')::double precision,
NULLIF(NULLIF(B17022003, ''), '.')::double precision,
NULLIF(NULLIF(B17022004, ''), '.')::double precision,
NULLIF(NULLIF(B17022005, ''), '.')::double precision,
NULLIF(NULLIF(B17022006, ''), '.')::double precision,
NULLIF(NULLIF(B17022007, ''), '.')::double precision,
NULLIF(NULLIF(B17022008, ''), '.')::double precision,
NULLIF(NULLIF(B17022009, ''), '.')::double precision,
NULLIF(NULLIF(B17022010, ''), '.')::double precision,
NULLIF(NULLIF(B17022011, ''), '.')::double precision,
NULLIF(NULLIF(B17022012, ''), '.')::double precision,
NULLIF(NULLIF(B17022013, ''), '.')::double precision,
NULLIF(NULLIF(B17022014, ''), '.')::double precision,
NULLIF(NULLIF(B17022015, ''), '.')::double precision,
NULLIF(NULLIF(B17022016, ''), '.')::double precision,
NULLIF(NULLIF(B17022017, ''), '.')::double precision,
NULLIF(NULLIF(B17022018, ''), '.')::double precision,
NULLIF(NULLIF(B17022019, ''), '.')::double precision,
NULLIF(NULLIF(B17022020, ''), '.')::double precision,
NULLIF(NULLIF(B17022021, ''), '.')::double precision,
NULLIF(NULLIF(B17022022, ''), '.')::double precision,
NULLIF(NULLIF(B17022023, ''), '.')::double precision,
NULLIF(NULLIF(B17022024, ''), '.')::double precision,
NULLIF(NULLIF(B17022025, ''), '.')::double precision,
NULLIF(NULLIF(B17022026, ''), '.')::double precision,
NULLIF(NULLIF(B17022027, ''), '.')::double precision,
NULLIF(NULLIF(B17022028, ''), '.')::double precision,
NULLIF(NULLIF(B17022029, ''), '.')::double precision,
NULLIF(NULLIF(B17022030, ''), '.')::double precision,
NULLIF(NULLIF(B17022031, ''), '.')::double precision,
NULLIF(NULLIF(B17022032, ''), '.')::double precision,
NULLIF(NULLIF(B17022033, ''), '.')::double precision,
NULLIF(NULLIF(B17022034, ''), '.')::double precision,
NULLIF(NULLIF(B17022035, ''), '.')::double precision,
NULLIF(NULLIF(B17022036, ''), '.')::double precision,
NULLIF(NULLIF(B17022037, ''), '.')::double precision,
NULLIF(NULLIF(B17022038, ''), '.')::double precision,
NULLIF(NULLIF(B17022039, ''), '.')::double precision,
NULLIF(NULLIF(B17022040, ''), '.')::double precision,
NULLIF(NULLIF(B17022041, ''), '.')::double precision,
NULLIF(NULLIF(B17022042, ''), '.')::double precision,
NULLIF(NULLIF(B17022043, ''), '.')::double precision,
NULLIF(NULLIF(B17022044, ''), '.')::double precision,
NULLIF(NULLIF(B17022045, ''), '.')::double precision,
NULLIF(NULLIF(B17022046, ''), '.')::double precision,
NULLIF(NULLIF(B17022047, ''), '.')::double precision,
NULLIF(NULLIF(B17022048, ''), '.')::double precision,
NULLIF(NULLIF(B17022049, ''), '.')::double precision,
NULLIF(NULLIF(B17022050, ''), '.')::double precision,
NULLIF(NULLIF(B17022051, ''), '.')::double precision,
NULLIF(NULLIF(B17022052, ''), '.')::double precision,
NULLIF(NULLIF(B17022053, ''), '.')::double precision,
NULLIF(NULLIF(B17022054, ''), '.')::double precision,
NULLIF(NULLIF(B17022055, ''), '.')::double precision,
NULLIF(NULLIF(B17022056, ''), '.')::double precision,
NULLIF(NULLIF(B17022057, ''), '.')::double precision,
NULLIF(NULLIF(B17022058, ''), '.')::double precision,
NULLIF(NULLIF(B17022059, ''), '.')::double precision,
NULLIF(NULLIF(B17022060, ''), '.')::double precision,
NULLIF(NULLIF(B17022061, ''), '.')::double precision,
NULLIF(NULLIF(B17022062, ''), '.')::double precision,
NULLIF(NULLIF(B17022063, ''), '.')::double precision,
NULLIF(NULLIF(B17022064, ''), '.')::double precision,
NULLIF(NULLIF(B17022065, ''), '.')::double precision,
NULLIF(NULLIF(B17022066, ''), '.')::double precision,
NULLIF(NULLIF(B17022067, ''), '.')::double precision,
NULLIF(NULLIF(B17022068, ''), '.')::double precision,
NULLIF(NULLIF(B17022069, ''), '.')::double precision,
NULLIF(NULLIF(B17022070, ''), '.')::double precision,
NULLIF(NULLIF(B17022071, ''), '.')::double precision,
NULLIF(NULLIF(B17022072, ''), '.')::double precision,
NULLIF(NULLIF(B17022073, ''), '.')::double precision,
NULLIF(NULLIF(B17022074, ''), '.')::double precision,
NULLIF(NULLIF(B17022075, ''), '.')::double precision,
NULLIF(NULLIF(B17022076, ''), '.')::double precision,
NULLIF(NULLIF(B17022077, ''), '.')::double precision,
NULLIF(NULLIF(B17022078, ''), '.')::double precision,
NULLIF(NULLIF(B17022079, ''), '.')::double precision,
NULLIF(NULLIF(B17022080, ''), '.')::double precision,
NULLIF(NULLIF(B17022081, ''), '.')::double precision,
NULLIF(NULLIF(B17024001, ''), '.')::double precision,
NULLIF(NULLIF(B17024002, ''), '.')::double precision,
NULLIF(NULLIF(B17024003, ''), '.')::double precision,
NULLIF(NULLIF(B17024004, ''), '.')::double precision,
NULLIF(NULLIF(B17024005, ''), '.')::double precision,
NULLIF(NULLIF(B17024006, ''), '.')::double precision,
NULLIF(NULLIF(B17024007, ''), '.')::double precision,
NULLIF(NULLIF(B17024008, ''), '.')::double precision,
NULLIF(NULLIF(B17024009, ''), '.')::double precision,
NULLIF(NULLIF(B17024010, ''), '.')::double precision,
NULLIF(NULLIF(B17024011, ''), '.')::double precision,
NULLIF(NULLIF(B17024012, ''), '.')::double precision,
NULLIF(NULLIF(B17024013, ''), '.')::double precision,
NULLIF(NULLIF(B17024014, ''), '.')::double precision,
NULLIF(NULLIF(B17024015, ''), '.')::double precision,
NULLIF(NULLIF(B17024016, ''), '.')::double precision,
NULLIF(NULLIF(B17024017, ''), '.')::double precision,
NULLIF(NULLIF(B17024018, ''), '.')::double precision,
NULLIF(NULLIF(B17024019, ''), '.')::double precision,
NULLIF(NULLIF(B17024020, ''), '.')::double precision,
NULLIF(NULLIF(B17024021, ''), '.')::double precision,
NULLIF(NULLIF(B17024022, ''), '.')::double precision,
NULLIF(NULLIF(B17024023, ''), '.')::double precision,
NULLIF(NULLIF(B17024024, ''), '.')::double precision,
NULLIF(NULLIF(B17024025, ''), '.')::double precision,
NULLIF(NULLIF(B17024026, ''), '.')::double precision,
NULLIF(NULLIF(B17024027, ''), '.')::double precision,
NULLIF(NULLIF(B17024028, ''), '.')::double precision,
NULLIF(NULLIF(B17024029, ''), '.')::double precision,
NULLIF(NULLIF(B17024030, ''), '.')::double precision,
NULLIF(NULLIF(B17024031, ''), '.')::double precision,
NULLIF(NULLIF(B17024032, ''), '.')::double precision,
NULLIF(NULLIF(B17024033, ''), '.')::double precision,
NULLIF(NULLIF(B17024034, ''), '.')::double precision,
NULLIF(NULLIF(B17024035, ''), '.')::double precision,
NULLIF(NULLIF(B17024036, ''), '.')::double precision,
NULLIF(NULLIF(B17024037, ''), '.')::double precision,
NULLIF(NULLIF(B17024038, ''), '.')::double precision,
NULLIF(NULLIF(B17024039, ''), '.')::double precision,
NULLIF(NULLIF(B17024040, ''), '.')::double precision,
NULLIF(NULLIF(B17024041, ''), '.')::double precision,
NULLIF(NULLIF(B17024042, ''), '.')::double precision,
NULLIF(NULLIF(B17024043, ''), '.')::double precision,
NULLIF(NULLIF(B17024044, ''), '.')::double precision,
NULLIF(NULLIF(B17024045, ''), '.')::double precision,
NULLIF(NULLIF(B17024046, ''), '.')::double precision,
NULLIF(NULLIF(B17024047, ''), '.')::double precision,
NULLIF(NULLIF(B17024048, ''), '.')::double precision,
NULLIF(NULLIF(B17024049, ''), '.')::double precision,
NULLIF(NULLIF(B17024050, ''), '.')::double precision,
NULLIF(NULLIF(B17024051, ''), '.')::double precision,
NULLIF(NULLIF(B17024052, ''), '.')::double precision,
NULLIF(NULLIF(B17024053, ''), '.')::double precision,
NULLIF(NULLIF(B17024054, ''), '.')::double precision,
NULLIF(NULLIF(B17024055, ''), '.')::double precision,
NULLIF(NULLIF(B17024056, ''), '.')::double precision,
NULLIF(NULLIF(B17024057, ''), '.')::double precision,
NULLIF(NULLIF(B17024058, ''), '.')::double precision,
NULLIF(NULLIF(B17024059, ''), '.')::double precision,
NULLIF(NULLIF(B17024060, ''), '.')::double precision,
NULLIF(NULLIF(B17024061, ''), '.')::double precision,
NULLIF(NULLIF(B17024062, ''), '.')::double precision,
NULLIF(NULLIF(B17024063, ''), '.')::double precision,
NULLIF(NULLIF(B17024064, ''), '.')::double precision,
NULLIF(NULLIF(B17024065, ''), '.')::double precision,
NULLIF(NULLIF(B17024066, ''), '.')::double precision,
NULLIF(NULLIF(B17024067, ''), '.')::double precision,
NULLIF(NULLIF(B17024068, ''), '.')::double precision,
NULLIF(NULLIF(B17024069, ''), '.')::double precision,
NULLIF(NULLIF(B17024070, ''), '.')::double precision,
NULLIF(NULLIF(B17024071, ''), '.')::double precision,
NULLIF(NULLIF(B17024072, ''), '.')::double precision,
NULLIF(NULLIF(B17024073, ''), '.')::double precision,
NULLIF(NULLIF(B17024074, ''), '.')::double precision,
NULLIF(NULLIF(B17024075, ''), '.')::double precision,
NULLIF(NULLIF(B17024076, ''), '.')::double precision,
NULLIF(NULLIF(B17024077, ''), '.')::double precision,
NULLIF(NULLIF(B17024078, ''), '.')::double precision,
NULLIF(NULLIF(B17024079, ''), '.')::double precision,
NULLIF(NULLIF(B17024080, ''), '.')::double precision,
NULLIF(NULLIF(B17024081, ''), '.')::double precision,
NULLIF(NULLIF(B17024082, ''), '.')::double precision,
NULLIF(NULLIF(B17024083, ''), '.')::double precision,
NULLIF(NULLIF(B17024084, ''), '.')::double precision,
NULLIF(NULLIF(B17024085, ''), '.')::double precision,
NULLIF(NULLIF(B17024086, ''), '.')::double precision,
NULLIF(NULLIF(B17024087, ''), '.')::double precision,
NULLIF(NULLIF(B17024088, ''), '.')::double precision,
NULLIF(NULLIF(B17024089, ''), '.')::double precision,
NULLIF(NULLIF(B17024090, ''), '.')::double precision,
NULLIF(NULLIF(B17024091, ''), '.')::double precision,
NULLIF(NULLIF(B17024092, ''), '.')::double precision,
NULLIF(NULLIF(B17024093, ''), '.')::double precision,
NULLIF(NULLIF(B17024094, ''), '.')::double precision,
NULLIF(NULLIF(B17024095, ''), '.')::double precision,
NULLIF(NULLIF(B17024096, ''), '.')::double precision,
NULLIF(NULLIF(B17024097, ''), '.')::double precision,
NULLIF(NULLIF(B17024098, ''), '.')::double precision,
NULLIF(NULLIF(B17024099, ''), '.')::double precision,
NULLIF(NULLIF(B17024100, ''), '.')::double precision,
NULLIF(NULLIF(B17024101, ''), '.')::double precision,
NULLIF(NULLIF(B17024102, ''), '.')::double precision,
NULLIF(NULLIF(B17024103, ''), '.')::double precision,
NULLIF(NULLIF(B17024104, ''), '.')::double precision,
NULLIF(NULLIF(B17024105, ''), '.')::double precision,
NULLIF(NULLIF(B17024106, ''), '.')::double precision,
NULLIF(NULLIF(B17024107, ''), '.')::double precision,
NULLIF(NULLIF(B17024108, ''), '.')::double precision,
NULLIF(NULLIF(B17024109, ''), '.')::double precision,
NULLIF(NULLIF(B17024110, ''), '.')::double precision,
NULLIF(NULLIF(B17024111, ''), '.')::double precision,
NULLIF(NULLIF(B17024112, ''), '.')::double precision,
NULLIF(NULLIF(B17024113, ''), '.')::double precision,
NULLIF(NULLIF(B17024114, ''), '.')::double precision,
NULLIF(NULLIF(B17024115, ''), '.')::double precision,
NULLIF(NULLIF(B17024116, ''), '.')::double precision,
NULLIF(NULLIF(B17024117, ''), '.')::double precision,
NULLIF(NULLIF(B17024118, ''), '.')::double precision,
NULLIF(NULLIF(B17024119, ''), '.')::double precision,
NULLIF(NULLIF(B17024120, ''), '.')::double precision,
NULLIF(NULLIF(B17024121, ''), '.')::double precision,
NULLIF(NULLIF(B17024122, ''), '.')::double precision,
NULLIF(NULLIF(B17024123, ''), '.')::double precision,
NULLIF(NULLIF(B17024124, ''), '.')::double precision,
NULLIF(NULLIF(B17024125, ''), '.')::double precision,
NULLIF(NULLIF(B17024126, ''), '.')::double precision,
NULLIF(NULLIF(B17024127, ''), '.')::double precision,
NULLIF(NULLIF(B17024128, ''), '.')::double precision,
NULLIF(NULLIF(B17024129, ''), '.')::double precision,
NULLIF(NULLIF(B17024130, ''), '.')::double precision,
NULLIF(NULLIF(B17024131, ''), '.')::double precision,
NULLIF(NULLIF(B17025001, ''), '.')::double precision,
NULLIF(NULLIF(B17025002, ''), '.')::double precision,
NULLIF(NULLIF(B17025003, ''), '.')::double precision,
NULLIF(NULLIF(B17025004, ''), '.')::double precision,
NULLIF(NULLIF(B17025005, ''), '.')::double precision,
NULLIF(NULLIF(B17025006, ''), '.')::double precision,
NULLIF(NULLIF(B17025007, ''), '.')::double precision,
NULLIF(NULLIF(B17025008, ''), '.')::double precision,
NULLIF(NULLIF(B17025009, ''), '.')::double precision,
NULLIF(NULLIF(B17025010, ''), '.')::double precision,
NULLIF(NULLIF(B17025011, ''), '.')::double precision,
NULLIF(NULLIF(B17025012, ''), '.')::double precision,
NULLIF(NULLIF(B17025013, ''), '.')::double precision,
NULLIF(NULLIF(B17025014, ''), '.')::double precision,
NULLIF(NULLIF(B17025015, ''), '.')::double precision
FROM tmp_seq0017;
INSERT INTO seq0018
SELECT fileid, filetype, upper(stusab), chariter, seq, logrecno::int,
NULLIF(NULLIF(B19001001, ''), '.')::double precision,
NULLIF(NULLIF(B19001002, ''), '.')::double precision,
NULLIF(NULLIF(B19001003, ''), '.')::double precision,
NULLIF(NULLIF(B19001004, ''), '.')::double precision,
NULLIF(NULLIF(B19001005, ''), '.')::double precision,
NULLIF(NULLIF(B19001006, ''), '.')::double precision,
NULLIF(NULLIF(B19001007, ''), '.')::double precision,
NULLIF(NULLIF(B19001008, ''), '.')::double precision,
NULLIF(NULLIF(B19001009, ''), '.')::double precision,
NULLIF(NULLIF(B19001010, ''), '.')::double precision,
NULLIF(NULLIF(B19001011, ''), '.')::double precision,
NULLIF(NULLIF(B19001012, ''), '.')::double precision,
NULLIF(NULLIF(B19001013, ''), '.')::double precision,
NULLIF(NULLIF(B19001014, ''), '.')::double precision,
NULLIF(NULLIF(B19001015, ''), '.')::double precision,
NULLIF(NULLIF(B19001016, ''), '.')::double precision,
NULLIF(NULLIF(B19001017, ''), '.')::double precision,
NULLIF(NULLIF(B19013001, ''), '.')::double precision,
NULLIF(NULLIF(B19025001, ''), '.')::double precision,
NULLIF(NULLIF(B19037001, ''), '.')::double precision,
NULLIF(NULLIF(B19037002, ''), '.')::double precision,
NULLIF(NULLIF(B19037003, ''), '.')::double precision,
NULLIF(NULLIF(B19037004, ''), '.')::double precision,
NULLIF(NULLIF(B19037005, ''), '.')::double precision,
NULLIF(NULLIF(B19037006, ''), '.')::double precision,
NULLIF(NULLIF(B19037007, ''), '.')::double precision,
NULLIF(NULLIF(B19037008, ''), '.')::double precision,
NULLIF(NULLIF(B19037009, ''), '.')::double precision,
NULLIF(NULLIF(B19037010, ''), '.')::double precision,
NULLIF(NULLIF(B19037011, ''), '.')::double precision,
NULLIF(NULLIF(B19037012, ''), '.')::double precision,
NULLIF(NULLIF(B19037013, ''), '.')::double precision,
NULLIF(NULLIF(B19037014, ''), '.')::double precision,
NULLIF(NULLIF(B19037015, ''), '.')::double precision,
NULLIF(NULLIF(B19037016, ''), '.')::double precision,
NULLIF(NULLIF(B19037017, ''), '.')::double precision,
NULLIF(NULLIF(B19037018, ''), '.')::double precision,
NULLIF(NULLIF(B19037019, ''), '.')::double precision,
NULLIF(NULLIF(B19037020, ''), '.')::double precision,
NULLIF(NULLIF(B19037021, ''), '.')::double precision,
NULLIF(NULLIF(B19037022, ''), '.')::double precision,
NULLIF(NULLIF(B19037023, ''), '.')::double precision,
NULLIF(NULLIF(B19037024, ''), '.')::double precision,
NULLIF(NULLIF(B19037025, ''), '.')::double precision,
NULLIF(NULLIF(B19037026, ''), '.')::double precision,
NULLIF(NULLIF(B19037027, ''), '.')::double precision,
NULLIF(NULLIF(B19037028, ''), '.')::double precision,
NULLIF(NULLIF(B19037029, ''), '.')::double precision,
NULLIF(NULLIF(B19037030, ''), '.')::double precision,
NULLIF(NULLIF(B19037031, ''), '.')::double precision,
NULLIF(NULLIF(B19037032, ''), '.')::double precision,
NULLIF(NULLIF(B19037033, ''), '.')::double precision,
NULLIF(NULLIF(B19037034, ''), '.')::double precision,
NULLIF(NULLIF(B19037035, ''), '.')::double precision,
NULLIF(NULLIF(B19037036, ''), '.')::double precision,
NULLIF(NULLIF(B19037037, ''), '.')::double precision,
NULLIF(NULLIF(B19037038, ''), '.')::double precision,
NULLIF(NULLIF(B19037039, ''), '.')::double precision,
NULLIF(NULLIF(B19037040, ''), '.')::double precision,
NULLIF(NULLIF(B19037041, ''), '.')::double precision,
NULLIF(NULLIF(B19037042, ''), '.')::double precision,
NULLIF(NULLIF(B19037043, ''), '.')::double precision,
NULLIF(NULLIF(B19037044, ''), '.')::double precision,
NULLIF(NULLIF(B19037045, ''), '.')::double precision,
NULLIF(NULLIF(B19037046, ''), '.')::double precision,
NULLIF(NULLIF(B19037047, ''), '.')::double precision,
NULLIF(NULLIF(B19037048, ''), '.')::double precision,
NULLIF(NULLIF(B19037049, ''), '.')::double precision,
NULLIF(NULLIF(B19037050, ''), '.')::double precision,
NULLIF(NULLIF(B19037051, ''), '.')::double precision,
NULLIF(NULLIF(B19037052, ''), '.')::double precision,
NULLIF(NULLIF(B19037053, ''), '.')::double precision,
NULLIF(NULLIF(B19037054, ''), '.')::double precision,
NULLIF(NULLIF(B19037055, ''), '.')::double precision,
NULLIF(NULLIF(B19037056, ''), '.')::double precision,
NULLIF(NULLIF(B19037057, ''), '.')::double precision,
NULLIF(NULLIF(B19037058, ''), '.')::double precision,
NULLIF(NULLIF(B19037059, ''), '.')::double precision,
NULLIF(NULLIF(B19037060, ''), '.')::double precision,
NULLIF(NULLIF(B19037061, ''), '.')::double precision,
NULLIF(NULLIF(B19037062, ''), '.')::double precision,
NULLIF(NULLIF(B19037063, ''), '.')::double precision,
NULLIF(NULLIF(B19037064, ''), '.')::double precision,
NULLIF(NULLIF(B19037065, ''), '.')::double precision,
NULLIF(NULLIF(B19037066, ''), '.')::double precision,
NULLIF(NULLIF(B19037067, ''), '.')::double precision,
NULLIF(NULLIF(B19037068, ''), '.')::double precision,
NULLIF(NULLIF(B19037069, ''), '.')::double precision,
NULLIF(NULLIF(B19049001, ''), '.')::double precision,
NULLIF(NULLIF(B19049002, ''), '.')::double precision,
NULLIF(NULLIF(B19049003, ''), '.')::double precision,
NULLIF(NULLIF(B19049004, ''), '.')::double precision,
NULLIF(NULLIF(B19049005, ''), '.')::double precision,
NULLIF(NULLIF(B19050001, ''), '.')::double precision,
NULLIF(NULLIF(B19050002, ''), '.')::double precision,
NULLIF(NULLIF(B19050003, ''), '.')::double precision,
NULLIF(NULLIF(B19050004, ''), '.')::double precision,
NULLIF(NULLIF(B19050005, ''), '.')::double precision,
NULLIF(NULLIF(B19051001, ''), '.')::double precision,
NULLIF(NULLIF(B19051002, ''), '.')::double precision,
NULLIF(NULLIF(B19051003, ''), '.')::double precision,
NULLIF(NULLIF(B19052001, ''), '.')::double precision,
NULLIF(NULLIF(B19052002, ''), '.')::double precision,
NULLIF(NULLIF(B19052003, ''), '.')::double precision,
NULLIF(NULLIF(B19053001, ''), '.')::double precision,
NULLIF(NULLIF(B19053002, ''), '.')::double precision,
NULLIF(NULLIF(B19053003, ''), '.')::double precision,
NULLIF(NULLIF(B19054001, ''), '.')::double precision,
NULLIF(NULLIF(B19054002, ''), '.')::double precision,
NULLIF(NULLIF(B19054003, ''), '.')::double precision,
NULLIF(NULLIF(B19055001, ''), '.')::double precision,
NULLIF(NULLIF(B19055002, ''), '.')::double precision,
NULLIF(NULLIF(B19055003, ''), '.')::double precision,
NULLIF(NULLIF(B19056001, ''), '.')::double precision,
NULLIF(NULLIF(B19056002, ''), '.')::double precision,
NULLIF(NULLIF(B19056003, ''), '.')::double precision,
NULLIF(NULLIF(B19057001, ''), '.')::double precision,
NULLIF(NULLIF(B19057002, ''), '.')::double precision,
NULLIF(NULLIF(B19057003, ''), '.')::double precision,
NULLIF(NULLIF(B19059001, ''), '.')::double precision,
NULLIF(NULLIF(B19059002, ''), '.')::double precision,
NULLIF(NULLIF(B19059003, ''), '.')::double precision,
NULLIF(NULLIF(B19060001, ''), '.')::double precision,
NULLIF(NULLIF(B19060002, ''), '.')::double precision,
NULLIF(NULLIF(B19060003, ''), '.')::double precision,
NULLIF(NULLIF(B19061001, ''), '.')::double precision,
NULLIF(NULLIF(B19062001, ''), '.')::double precision,
NULLIF(NULLIF(B19063001, ''), '.')::double precision,
NULLIF(NULLIF(B19064001, ''), '.')::double precision,
NULLIF(NULLIF(B19065001, ''), '.')::double precision,
NULLIF(NULLIF(B19066001, ''), '.')::double precision,
NULLIF(NULLIF(B19067001, ''), '.')::double precision,
NULLIF(NULLIF(B19069001, ''), '.')::double precision,
NULLIF(NULLIF(B19070001, ''), '.')::double precision,
NULLIF(NULLIF(B19101001, ''), '.')::double precision,
NULLIF(NULLIF(B19101002, ''), '.')::double precision,
NULLIF(NULLIF(B19101003, ''), '.'