INSERT INTO data_universe (SecCode, Type_, ID, ISIN, RkdISIN, RkdTicker, PermIDTicker, RkdSEDOL, RkdCUSIP, RkdRIC, RkdDisplayRIC, Name, ModelCntry, Country, InfoCode, DsSecCode, DsCmpyCode, IsMajorSec, DsCtryQtStatus, DsPrimQtSedol, DsTypeCode, DsExchMnem, DsExchCtryCode, DsQuoteCurr, RkdCode, RkdIssueID, RkdIssueCode, RkdIssueType, RkdIssueStatus, RkdIssueOrder, RkdListingType, RkdExchCode, RkdExchCtry, ShPerListing, PrimaryIssueType, PrimaryIssueCode, RelType, COATypeCode, QuotePermID, InstrPermID, OrgPermID, PriTrdQuotePermID, PriValQuotePermID, PriInstrPermID, IsPrimaryQuote, IsPrimaryInstr, PermQuoteStatus, PermInstrStatus, ExchCode, QuoteClass, InstrClass, OrgTypeCode, DomCntry, IncCntry, PriTRBCIndPermID, DsSecDelistDate, DsExchQtStartDate, SecMapStartDate, SecMapEndDate, PermQuoteRetireDate, PermOrgIPODate, PermSecMapStartDate, PermSecMapEndDate, startDate, endDate) VALUES (89928, 1, 'AIS', NULL, 'CA0014313039', 'AIS', 'AIS', 'BQ2MJH', '00143130', 'AIS.V', 'AIS.V', 'A I S RES LTD COM NEW', 'CA', 'CAN', 49334, 487, 44375, 'Y', 'A', 'BQ2MJH5', 'EQ', 'TSX', 'CA', 'CAD', 138714.0, 1.0, 176639.0, 'C', 1.0, 1.0, 'OSR', 'CVE', 'CAN', NULL, 'EQU', NULL, NULL, 'IND', 55838796196.0, 8589942406.0, 5074436803.0, NULL, 55838796196.0, 8589942406.0, 1.0, 1.0, 'AC', 'AC', 'CVE', 'ORD', 'ORD', 'COM', 'CAN', 'CAN', 4294951916.0, NULL, '1989-10-18', '1960-01-01', '2079-06-06', NULL, '2013-03-23', '1990-03-23', NULL, '1960-01-01', NULL);
INSERT INTO data_universe (SecCode, Type_, ID, ISIN, RkdISIN, RkdTicker, PermIDTicker, RkdSEDOL, RkdCUSIP, RkdRIC, RkdDisplayRIC, Name, ModelCntry, Country, InfoCode, DsSecCode, DsCmpyCode, IsMajorSec, DsCtryQtStatus, DsPrimQtSedol, DsTypeCode, DsExchMnem, DsExchCtryCode, DsQuoteCurr, RkdCode, RkdIssueID, RkdIssueCode, RkdIssueType, RkdIssueStatus, RkdIssueOrder, RkdListingType, RkdExchCode, RkdExchCtry, ShPerListing, PrimaryIssueType, PrimaryIssueCode, RelType, COATypeCode, QuotePermID, InstrPermID, OrgPermID, PriTrdQuotePermID, PriValQuotePermID, PriInstrPermID, IsPrimaryQuote, IsPrimaryInstr, PermQuoteStatus, PermInstrStatus, ExchCode, QuoteClass, InstrClass, OrgTypeCode, DomCntry, IncCntry, PriTRBCIndPermID, DsSecDelistDate, DsExchQtStartDate, SecMapStartDate, SecMapEndDate, PermQuoteRetireDate, PermOrgIPODate, PermSecMapStartDate, PermSecMapEndDate, startDate, endDate) VALUES (11181674, 1, 'AAJP.V', NULL, 'CA71716K1012', 'PCLO', 'PCLO', 'BH4KPJ', '71716K10', 'PCLO.V', 'PCLO.V', 'PHARMACIELO LTD NEW COM', 'CA', 'CAN', 304114, 223072, 175465, 'Y', 'A', 'BH4KPJ8', 'EQ', 'TSX', 'CA', 'CAD', 114524.0, 1.0, 144052.0, 'C', 1.0, 1.0, 'OSR', 'CVE', 'CAN', NULL, 'EQU', NULL, NULL, 'IND', 25727412715.0, 21625894872.0, 5059005031.0, NULL, 25727412715.0, 21625894872.0, 1.0, 1.0, 'AC', 'AC', 'CVE', 'ORD', 'ORD', 'COM', 'CAN', 'CAN', 4294951266.0, NULL, '2018-02-02', '2018-01-30', '2079-06-06', NULL, '2018-01-30', '2018-01-30', NULL, '2018-01-30', NULL);
