CREATE MULTISET TABLE DWHFRT.STAMP_OPS_EVT_TMP ,NO FALLBACK ,
     NO BEFORE JOURNAL,
     NO AFTER JOURNAL,
     CHECKSUM = DEFAULT,
     DEFAULT MERGEBLOCKRATIO
     (
      NUM_RTE SMALLINT TITLE 'Route number of the receptacle' COMPRESS (1 ,2 ,3 ,4 ,5 ,6 ,7 ,8 ,9 ,10 ,11 ,12 ,13 ,14 ,15 ,16 ,17 ,18 ,19 ,20 ,21 ,22 ,23 ,25 ,27 ),
      NUM_STA SMALLINT TITLE 'Station number of the receptacle' COMPRESS (1 ,2 ,3 ,4 ,5 ,6 ,7 ,8 ,9 ,10 ,11 ,12 ),
      COD_EVT CHAR(3) CHARACTER SET LATIN NOT CASESPECIFIC TITLE 'Event Code UPU' NOT NULL COMPRESS ('21 ','23 ','40 ','42 ','43 ','57 ','6  ','74 ','82 ','iAW','iCA','iCL','iCO','iDA'),
      IDT_CNT_RCU CHAR(35) CHARACTER SET LATIN NOT CASESPECIFIC TITLE 'Rec. -ID or Container ID' NOT NULL,
      DAT_EVT_UTC TIMESTAMP(0) TITLE 'Event timestamp in UTC' NOT NULL,
      DAT_LOC_EVT TIMESTAMP(0) TITLE 'Event timestamp in Local' COMPRESS ,
      DAT_DEP TIMESTAMP(0) TITLE 'Departure Date/Time' COMPRESS ,
      LCT_SCA VARCHAR(17) CHARACTER SET LATIN NOT CASESPECIFIC TITLE 'Scan Location' COMPRESS ('CDG','AMS','CPH','JFK','HUB','ATH','SYD','FRA'),
      ESC_ORI CHAR(7) CHARACTER SET LATIN NOT CASESPECIFIC TITLE 'Ori. Station' COMPRESS ('AMS    ','ATH    ','ATL    ','BCN    ','BKO    ','BRU    ','BZV    ','CAN    ','CDG    ','CMN    ','CPH    ','DXB    ','EZE    ','FLR    ','FRA    ','HEL    ','HKG    ','ICN    ','JFK    ','JNB    ','KUL    ','LAX    ','LHR    ','LIM    ','LIS    ','LOS    ','LYS    ','MAD    ','MEX    ','MIA    ','NBO    ','NTE    ','OPO    ','ORD    ','ORK    ','PEK    ','PVG    ','RIX    ','SFO    ','SIN    ','SOF    ','SVO    ','SXM    ','TPE    ','VIE    ','WAW    ','YUL    ','ZRH    '),
      ESC_DST CHAR(7) CHARACTER SET LATIN NOT CASESPECIFIC TITLE 'Dest. Station' COMPRESS ('AMS    ','ATH    ','ATL    ','BCN    ','BKO    ','BRU    ','BZV    ','CAN    ','CDG    ','CMN    ','CPH    ','DXB    ','EZE    ','FLR    ','FRA    ','HEL    ','HKG    ','ICN    ','JFK    ','JNB    ','KUL    ','LAX    ','LHR    ','LIM    ','LIS    ','LOS    ','LYS    ','MAD    ','MEX    ','MIA    ','NBO    ','NTE    ','OPO    ','ORD    ','ORK    ','PEK    ','PVG    ','RIX    ','SFO    ','SIN    ','SOF    ','SVO    ','SXM    ','TPE    ','VIE    ','WAW    ','YUL    ','ZRH    '),
      NOM_PRN_ORI VARCHAR(17) CHARACTER SET LATIN NOT CASESPECIFIC TITLE 'Partner at Origin' COMPRESS ('MP','KL','NLAMSA','AF','DKCPHA','FRCDGA','CLEARINGOFFICE','CUSTOMS','GRATHA','USJFKA','AUSYDJ','AY','AZ','EI','DEFRAA','MH','DL'),
      NOM_PRN_DST VARCHAR(17) CHARACTER SET LATIN NOT CASESPECIFIC TITLE 'Partner at Dest.' COMPRESS ('FRCDGA','DKCPHA','NLAMSA','USJFKA','NLAMSB','AF','KL','AZ','GA','AC','EQ','MP'),
      NUM_VOL_DEP VARCHAR(17) CHARACTER SET LATIN NOT CASESPECIFIC TITLE 'Dep. Flight No.' COMPRESS ('AF008','AF006','AF1751','AF1351','KL1126','KL1124','KL643','AF1788','KL1130','AF5016','AF1160','KL5017','KL701','AF5018','KL1128','KL5022','AF1261','KL1134','KL855','KL1243','KL641','AF029','KL022','AF102','KL017','KL1705','KL1139','KL1132','AF012','KL887','AF5017','AF1140','KL1224','AF009T','KL644','KL5030','KL1127','KL1017','KL642','AF498','KL5251','KL427','AF5030','KL8477','KL1131','KL1733','AF1766','AF5012','AF138D','KL9356','KL1228','AF1340','AF1740','KL1763','AF1414Z','AF026','KL807','AF020','AF1350','KL1847','KL1244','AF1596','AF1300','AF5020','AF1260','KL1707','AF3852','AF100M','AF1693','KL9352','KL835','KL018','AF896','KL591','KL809','AF022','AF9865','AF1241','AF004T','AF1850','AF004S','AF002S','AF1151','MP4322','AF1240','AF1640','AF5022','KL671','KL565','AF007','AF024','KL016','AF438','KL1969Z','AF5120','KL1849','AF1141','KL1227','KL1693','AF003S','AF5014','AF5760','AF1361','KL1573','AF1750','AF3440','KL8643','AF1000','KL1229','AF101F','KL743','KL611','AF076','AF116','KL897','KL587','AF018','KL465','KL907','EI845','AF016','DL075'),
      NUM_VOL_ARV VARCHAR(17) CHARACTER SET LATIN NOT CASESPECIFIC TITLE 'Arrv. Flight No.' COMPRESS ('AF1751','AF001X','AF1351','AF1160','KL642','KL5017','CZ347','AF1140','AF995','KL1130','KL1128','KL1139','KL1132','AF083','KL1676','KL8078','EI602','KL896','KL8680','AF1340','KL644','KL1304','KL1032','AF1361','AF1740','AF1179','KL1243','AF7739','AF5030','AF1240','KL1574','AF1359','KL1598','AF5018','MP4322','AF1259','AF1241','KL1126','KL9106','AF5017','AF1260','AF1367','KL1022','AZ120','AF007','AZ108','KL017','AF017','AF1708','AF1161','AF7709','KL1732','AF004S','KL1227','KL1000','AF019','KL702','KL119','AF030','AF008'),
      IDT_VOL VARCHAR(32) CHARACTER SET LATIN NOT CASESPECIFIC TITLE 'Flight ID' COMPRESS ('GUYcrituIbDgUxASPAofjQ==','EpKHbKiqQD/gUxASPAptuw==','EpU1O0LJWIbgUxASPArDsQ==','EtPtIaE1cfzgUxASPApenQ==','EgtbwWdiEFrgUxASPAr/uw==','FxEInCN8EL7gUxASPAqtXw==','EpU1OkvhWIbgUxASPArDsQ==','FxEInCOAEL7gUxASPAqtXw==','EpU1OqrUWIbgUxASPArDsQ==','EpU1O0kBWIbgUxASPArDsQ==','E9aQHALVT+HgUxASPAqxWg==','EgtbwWtcEFrgUxASPAr/uw==','EgtbwXPyEFrgUxASPAr/uw==','EgtbwaNSEFrgUxASPAr/uw==','EpU1O0XzWIbgUxASPArDsQ==','EpU1O0X1WIbgUxASPArDsQ==','EpU1O0xoWIbgUxASPArDsQ==','E69kOtT9SSHgUxASPAqktQ==','E9aQHALhT+HgUxASPAqxWg==','FxEInCN6EL7gUxASPAqtXw==','EpU1OnGwWIbgUxASPArDsQ==','EtPtIaFTcfzgUxASPApenQ==','EgtbwaY9EFrgUxASPAr/uw==','EpU1Ok2+WIbgUxASPArDsQ==','EpKHbElkQD/gUxASPAptuw==','EpU1O1ApWIbgUxASPArDsQ==','EpKHbCSIQD/gUxASPAptuw==','EpKHbBaHQD/gUxASPAptuw==','EpKHbCRZQD/gUxASPAptuw==','FpRItURAXjngUxASPAq7tg==','EpKHa2OoQD/gUxASPAptuw==','E9aQHALMT+HgUxASPAqxWg==','EpU1O1R/WIbgUxASPArDsQ==','EpU1O0XmWIbgUxASPArDsQ==','EpU1O8U5WIbgUxASPArDsQ==','EgtbwaT2EFrgUxASPAr/uw==','EpU1Ok/nWIbgUxASPArDsQ==','EgtbwW5SEFrgUxASPAr/uw==','EgtbwXNiEFrgUxASPAr/uw==','EgtbwaUqEFrgUxASPAr/uw==','EtPtIaFUcfzgUxASPApenQ==','FpRItURNXjngUxASPAq7tg==','GUYcrn/SIbDgUxASPAofjQ==','EpU1PQRhWIbgUxASPArDsQ==','EtPtIaFDcfzgUxASPApenQ==','EpKHbD8EQD/gUxASPAptuw==','GM6rf2FtawXgUxASPApobg==','EpKHbCDTQD/gUxASPAptuw==','Egtbwad6EFrgUxASPAr/uw==','EpU1O0LRWIbgUxASPArDsQ==','EpU1OvF0WIbgUxASPArDsQ==','EpU1OseWWIbgUxASPArDsQ==','EpKHbCC5QD/gUxASPAptuw==','EpU1O8UyWIbgUxASPArDsQ==','GaWGqNrgWxHgUxASPApTCg==','EpU1Or8fWIbgUxASPArDsQ==','EpU1Ok3bWIbgUxASPArDsQ==','EgtbwXHfEFrgUxASPAr/uw==','EpU1O1MtWIbgUxASPArDsQ==','EpU1Ok3jWIbgUxASPArDsQ==','E9aQHALZT+HgUxASPAqxWg==','EpKHbDY4QD/gUxASPAptuw==','EpU1O8CIWIbgUxASPArDsQ==','EpKHbD39QD/gUxASPAptuw==','EgtbwXbbEFrgUxASPAr/uw==','EpU1O0X8WIbgUxASPArDsQ==','EpKHbJT7QD/gUxASPAptuw==','EpU1PUm3WIbgUxASPArDsQ==','GUYcritzIbDgUxASPAofjQ==','EpU1OknBWIbgUxASPArDsQ==','EpU1OphrWIbgUxASPArDsQ==','F/+i/3XrIkPgUxASPAoqMQ==','FWjEjtWleEngUxASPAoNGQ==','EpU1OnHAWIbgUxASPArDsQ==','EpKHbCRhQD/gUxASPAptuw==','F8iYavJgP8LgUxASPArNxQ==','EtPtIaFLcfzgUxASPApenQ==','FCgE4rwhTfPgUxASPAr+Ug==','EpU1O0kHWIbgUxASPArDsQ==','EgtbwXMpEFrgUxASPAr/uw==','EpKHbCRgQD/gUxASPAptuw==','E9aQHALiT+HgUxASPAqxWg==','EpKHbDg3QD/gUxASPAptuw==','EgtbwXJBEFrgUxASPAr/uw==','EpU1Ok3XWIbgUxASPArDsQ==','EgtbwXNhEFrgUxASPAr/uw==','EpU1PTJkWIbgUxASPArDsQ==','EgtbwXnzEFrgUxASPAr/uw==','EpU1O1SOWIbgUxASPArDsQ==','EpU1O0yBWIbgUxASPArDsQ==','EpKHbJ/7QD/gUxASPAptuw==','EpU1O0xiWIbgUxASPArDsQ==','EgtbwXLrEFrgUxASPAr/uw==','EgtbwamNEFrgUxASPAr/uw==','E9aQHALDT+HgUxASPAqxWg==','EpU1O1MjWIbgUxASPArDsQ==','E9aQHALLT+HgUxASPAqxWg==','EpU1O+38WIbgUxASPArDsQ==','EpU1O0eIWIbgUxASPArDsQ==','EpU1Okl0WIbgUxASPArDsQ==','EtPtIaFccfzgUxASPApenQ==','EgtbwXOqEFrgUxASPAr/uw==','EgtbwaXgEFrgUxASPAr/uw==','FptEQYOGXhjgUxASPAoeYg==','E9aQHALET+HgUxASPAqxWg==','EpU1OqRoWIbgUxASPArDsQ==','FxEInCN3EL7gUxASPAqtXw==','EpU1PSCRWIbgUxASPArDsQ==','EpKHbJN+QD/gUxASPAptuw==','EpMoUBNaWIvgUxASPAoSkg==','EpU1O8a5WIbgUxASPArDsQ==','EpU1OgnVWIbgUxASPArDsQ==','EpU1PZ3+WIbgUxASPArDsQ==','FxEInCONEL7gUxASPAqtXw==','EgtbwXGDEFrgUxASPAr/uw==','EpU1OkvcWIbgUxASPArDsQ==','EtPtIaEvcfzgUxASPApenQ==','GUYcrit1IbDgUxASPAofjQ==','FpRItUQ/XjngUxASPAq7tg==','EpKHbMwVQD/gUxASPAptuw==','GUYcr2OuIbDgUxASPAofjQ==','EpU1OjIJWIbgUxASPArDsQ==','EtPtIaE+cfzgUxASPApenQ==','EtPtIaFXcfzgUxASPApenQ==','E8VkiSymbMXgUxASPAqHTg==','EpKHbFSCQD/gUxASPAptuw==','EpU1Ok3cWIbgUxASPArDsQ==','EgtbwXMrEFrgUxASPAr/uw==','EpU1Or8IWIbgUxASPArDsQ==','EqXtN7ASXB3gUxASPAqpsw==','EpU1Owj7WIbgUxASPArDsQ==','EgtbwaeTEFrgUxASPAr/uw==','E9aQHALpT+HgUxASPAqxWg==','EpKHbIREQD/gUxASPAptuw==','EpKHa/6gQD/gUxASPAptuw==','EpKHbD7PQD/gUxASPAptuw==','GUYcrjNvIbDgUxASPAofjQ==','EgtbwXXPEFrgUxASPAr/uw==','EpKHbIhwQD/gUxASPAptuw==','EpKHbCRaQD/gUxASPAptuw==','EpU1O045WIbgUxASPArDsQ==','E9aQHAEZT+HgUxASPAqxWg==','EpU1O05GWIbgUxASPArDsQ==','EpU1PR18WIbgUxASPArDsQ==','EpKHbD7WQD/gUxASPAptuw==','EpU1Ok3YWIbgUxASPArDsQ==','FpRItURTXjngUxASPAq7tg==','EpKHbFHOQD/gUxASPAptuw==','EpU1O0X+WIbgUxASPArDsQ==','EpKHbD7VQD/gUxASPAptuw==','GUYcrxJ5IbDgUxASPAofjQ==','EpU1OkwBWIbgUxASPArDsQ==','EpU1O0xHWIbgUxASPArDsQ==','EpU1O0xfWIbgUxASPArDsQ==','EpU1O1NKWIbgUxASPArDsQ==','EpU1O1BDWIbgUxASPArDsQ==','EyQ1Jn6MJ0fgUxASPAp8SQ==','GUYcrmlSIbDgUxASPAofjQ==','EpU1Okl2WIbgUxASPArDsQ==','E9aQHALgT+HgUxASPAqxWg==','EpKHbz9mQD/gUxASPAptuw==','EpU1OluCWIbgUxASPArDsQ==','EpU1O0kAWIbgUxASPArDsQ==','EpU1O1A+WIbgUxASPArDsQ==','GUYcrit2IbDgUxASPAofjQ==','EpU1OvlwWIbgUxASPArDsQ==','EpU1O0LSWIbgUxASPArDsQ==','EpU1OknkWIbgUxASPArDsQ==','EpU1O8VbWIbgUxASPArDsQ==','EpU1PR10WIbgUxASPArDsQ==','EgtbwavtEFrgUxASPAr/uw==','EtPtIaFHcfzgUxASPApenQ==','EgtbwatZEFrgUxASPAr/uw==','EpU1PMFPWIbgUxASPArDsQ==','EpU1O0LmWIbgUxASPArDsQ==','EgtbwXN7EFrgUxASPAr/uw==','EgtbwXeAEFrgUxASPAr/uw==','FxEInCOIEL7gUxASPAqtXw==','EtPtIaIecfzgUxASPApenQ==','FoFsAhKwTu/gUxASPAqNdg==','EtPtIZ+1cfzgUxASPApenQ==','EpU1Okv2WIbgUxASPArDsQ==','EpU1O0xKWIbgUxASPArDsQ==','EpU1OiONWIbgUxASPArDsQ==','EgtbwXTsEFrgUxASPAr/uw==','EpKHbCxRQD/gUxASPAptuw==','EgtbwXmwEFrgUxASPAr/uw==','EpKHbFdaQD/gUxASPAptuw==','E8VkiTYHbMXgUxASPAqHTg==','EpU1O0eJWIbgUxASPArDsQ==','F/+i/3VmIkPgUxASPAoqMQ==','EpMoUBM1WIvgUxASPAoSkg==','EgtbwXFQEFrgUxASPAr/uw==','EtPtIaIjcfzgUxASPApenQ==','EpU1OgpHWIbgUxASPArDsQ==','EpU1PLCqWIbgUxASPArDsQ==','EpKHbDwcQD/gUxASPAptuw==','EpKHbJT+QD/gUxASPAptuw==','EpKHbCDOQD/gUxASPAptuw==','EpU1O76cWIbgUxASPArDsQ==','FMW9DQsiQ3ngUxASPAqswQ==','GUYcritvIbDgUxASPAofjQ==','FWjEjtkseEngUxASPAoNGQ==','EpU1O77NWIbgUxASPArDsQ==','EpU1OkCZWIbgUxASPArDsQ==','EpU1Ok/fWIbgUxASPArDsQ==','GbnH7W4tG8/gUxASPApiqQ==','FpRItURHXjngUxASPAq7tg==','EgtbwahpEFrgUxASPAr/uw==','EpU1O0xLWIbgUxASPArDsQ==','EpU1PaFBWIbgUxASPArDsQ==','EpU1OkuPWIbgUxASPArDsQ==','E8VkiTR3bMXgUxASPAqHTg==','EpU1Op2iWIbgUxASPArDsQ==','EpU1O1A2WIbgUxASPArDsQ==','EpKHbCDAQD/gUxASPAptuw==','E9aQHAIJT+HgUxASPAqxWg==','EgtbwXmvEFrgUxASPAr/uw==','FxEInCNsEL7gUxASPAqtXw==','EgtbwadfEFrgUxASPAr/uw==','EgtbwWuYEFrgUxASPAr/uw==','FYwceb6MNuvgUxASPAoiDg==','GUYcsW7NIbDgUxASPAofjQ==','Egtbwa2bEFrgUxASPAr/uw==','EpKHbJUEQD/gUxASPAptuw==','EgtbwaiCEFrgUxASPAr/uw==','EgtbwaTdEFrgUxASPAr/uw==','GUYcrit/IbDgUxASPAofjQ==','EqXtN65eXB3gUxASPAqpsw==','EpU1OkwEWIbgUxASPArDsQ==','FpRItUROXjngUxASPAq7tg==','EpU1O0XqWIbgUxASPArDsQ==','EgtbwaYXEFrgUxASPAr/uw==','E9aQHAIHT+HgUxASPAqxWg==','EgtbwXFAEFrgUxASPAr/uw==','EpKHbCKjQD/gUxASPAptuw==','E69kOtlSSSHgUxASPAqktQ==','FpRItURJXjngUxASPAq7tg==','FYwceLkrNuvgUxASPAoiDg==','EgtbwaQlEFrgUxASPAr/uw==','FpRItURPXjngUxASPAq7tg==','EpKHbCUzQD/gUxASPAptuw==','EgtbwaP2EFrgUxASPAr/uw==','FWcQRX74eE3gUxASPAouRg==','EpU1PTCTWIbgUxASPArDsQ==','EpU1OisjWIbgUxASPArDsQ==','EpU1OoAwWIbgUxASPArDsQ==','EpKHbCRiQD/gUxASPAptuw==','Egtbwa4bEFrgUxASPAr/uw==','EpKHbCDbQD/gUxASPAptuw==','EpU1O0jzWIbgUxASPArDsQ==','EpU1O1SeWIbgUxASPArDsQ==','EgtbwavMEFrgUxASPAr/uw==','EpKHbCw4QD/gUxASPAptuw==','EpU1O1NNWIbgUxASPArDsQ=='))
PRIMARY INDEX PI_STAMP_OPS_EVT_TMP ( IDT_CNT_RCU );



