<?xml version="1.0" encoding="UTF-8"?>
<talendfile:ProcessType xmi:version="2.0" xmlns:xmi="http://www.omg.org/XMI" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://www.talend.org/mapper" xmlns:talendfile="platform:/resource/org.talend.model/model/TalendFile.xsd" defaultContext="Default" screenshot="iVBORw0KGgoAAAANSUhEUgAABAQAAAFICAIAAABIp7sIAABMe0lEQVR4nO2dB3xT5f6Hi6hcL+q9iiAgsmQIuABBURQHovwVBQRkyy57tEBZbRkFpSDIBdkowwEyFFQUUJnKEJApe0NHOpKwoZT+f8lpDyFJmxbOSdKT5+H58HlzcvKeJGf9vsl70qCgoKA0PaF/+qd/+qd/+qd/+qd/+qd//+xf3yUBAAAAAIDfQhgAAAAAAAhQCAMAAAAAAAEKYQAAAAAAIEAhDAAAAAAABCiEAQAAAACAAIUwAAAAAAAQoBAGAAAAAAACFMIAAAAAAECAQhgAAAAAAAhQCAMAAAAAAAEKYQAAAAAAIEAhDAAAAAAABCiEAQAAAACAAIUwAAAAAAAQoBAGAAAAAAACFMIAAAAAAECAQhgAAAAAAAhQCAMAAAAAAAEKYQAAAAAAIEAhDAAAAAAABCiEAQAAAACAAIUwAAAAAAAQoBAGAAAAAAACFMIAAAAAAECAQhgAAAAAAAhQCAMAAAAAAAEKYQAAAAAAIEAhDAAAAAAABCiEAQAAAACAAIUwAAAAAAAQoAQJei8gNTXtVPzV/Scu7zxySXNDI6fp0S390z/90z/90z/9e7l/KRWkYLh+Pb1+0Ls+0bt/6h9jr1/D9K/7NwOyyvccu7zvxBVTYorFkmq1IiIiIjorRYKUClIy7jl2Rcro3A71j7HXr5HQPQxIBJQV7/NNEBEREXOFUkBL8aB3faI31D/GXr9GQvcwsP/kZVPSNZ9veYiIiJgrNCWm7D9xWe/6RG+of4y9fo2E7mFAYjHfjiEiImI2lbJBige96xO9of4x9vo1Et4IAz7f7BAREdFPbD44KAuVeQxQLAZs/RMg69dIEAYQERHRe0pFuC7NvUYqFgO2/gmQ9WskCAOIiIjoPQOkWAzY+idA1q+RIAwgIiKi9wyQYSQBW/8EyPo1EoQBRERE9C8NUCxS/xh7/RoJwgAiIiL6lwYoFql/jL1+jQRhABEREf1LAxSL1D/GXr9GgjCAiIiI/qUBikXqH2OvXyNBGEBERET/0gDFIvWPsdevkSAMICIion9pgGKR+sfY69dIEAYQERHRvzRAsUj9Y+z1ayQIA4iIiOhfGqBYpP4x9vo1EoQBRETEgNDx7OzzJ5O1BigWqX+MvX6NBGEAERHR+MoZOXbrkuMzXxelkebfecAAxSL1j7HXr5EgDCAiIhpfOSMfm/5aWvJa8diM19IIAzpD/WPs9WskCAOIiIgGN83+tcCRaa+lxf4iSsPPvxwwQLFI/WPs9WskCAOIiIgGV07Hh6fWSkteO7hBAVEah6a8kkYY0BPqH2OvXyNBGEBERDSyci4+8VXjnZ9UT9s7YmjjgsM/KCQNuSkT0/w1DxigWKT+Mfb6NRKEAURERCMr5+JtY6qlHQpJ2zt8dIvCY1sXTdszTG7+LRMJA7pB/WPs9WskCAOIiIiGNc3+tcC2MVXSjg5L29T8hkeH/RVd1W+/HDBAsUj9Y+z1ayQIA4iIiIZVTsSbP6qcdvKTtK3d0w5P+ahF4UkdHpVG2rZuaSfH/yV3EQb0gfrH2OvXSBAGEBERDWuaLQw8nXZ6ctqO0LSjs4Y1LiR5QBq2m6em2O4iDOgD9Y+x16+RIAwgIiIaVjkR/xn11Knve6edmZUW87mjMvHPkU+lEQb0gfrH2OvXSBAGEBERjayci/8Y8aRb0/wyCVgNUSxS/xh7/RoJwgAiIqLBzewc7fMnlpkGKBapf4y9fo0EYQARERH9SwMUi9Q/xl6/RoIwgIiIiP6lAYpF6h9jr18jESTouoDQyGm6bk9NmrSjf/qnf/qnf/qnfyP1L8Wi3vUJ9Q/rl/7T27ouKY1kjIiIiDnUAJ8ce6H+WRb9TPb1+To12Po1EoQBRMzKYcOG9XFBJmZ/hn6DPcyAiOikAYpF74SBK1eveXTPsi7+lgcMsH6NBGEgWztbLk3eiLevFO5pW4NuOK1q2vTqMlHDGRARnTRAsehXYcDf8oAB1q+RIAxoubP51Z6GqIk3Snkp4qdVXRdRQ3Rf69/qDIiIThqgWPRC/bPk48qXrqSIl69csyuNlJun2Dz42xApUfb6U5VigPVrJAgDns29yRvx9pWqPcUFx1I+62FCJ08me+wBEdFJAxSLfhUGxL3+lAcMsH6NBGFAy53N35I34u2bWSm/fPnqhAQPe/eqVRvq12/Qq1cvwgDibRoUFJy1Pn+G2mqAYtEL9c+3o6peuJwiZlafXLycIh7fNF7JA/ZPLTtLiSIPZP2CCmHAs7k3eSPevpmFga5de7Zr1/HMGWtmD9y0aVe9eu8uXbqSbwYQb1m11h80b3HWGiwSGKBY9GYYmPDVRnHYlF/FHlGLxdb954lqGHDIA51FwgA4QhjIwc52C8k77/2DFH3+KhBvTana97sgE5OTrw4ePLRp0+Z79hxzfdS+fSfr128wb97CLHrw+UtD9HOzkwFcI4HPn7YmGqBY9EL981XUs2cvpIjnLto8a1dpn7tg96J7vxr5LOsXVAgDns1+GHBN3hIDgrvP7dRjLnkAc6lZf64/btwkKfo3bdrl+JAjR+IaN27y6aeTs9MDIrr1FpKAkfKAAYpFwoCx16+RIAzou7NJBuja65suvb7u2utr8gDmRjMr5dUAMG/ewnr16i1fvlq5GRd3vnXrNlFR0Vn3MHToUJ+/NER/Vmr60M8X5DgJvNuWMOAneKH+mT28muVCiiUn9YnlvE15IOsXVAgDnr3NMNAjdFGPkMXdQ+T/ReQBzHW6LeV79+7dsmXr8PDhyclXZZ4VK9bVq/fuF198nZBwqXPn7iEh/R176Dd4mOsvDvFHxxCzVmr6vp8v6DH9q06fzWn96cxsxQBFwoB/4M0woFwzMHb2ejFq+mpxyP9+EUNHLxO7Dl8kth/0zZZWdfd+PMQpDMgUmR4a2nfSpOms38CEMJCDnc1tGFCvCsjMPmE/OEoewNxlZiP+z5yxtmvXMTi4q3IN8aZNuxo0aNi8eUsJAx5/ZQgRPSo1fd5BJRQ//HRmk+gp9aIm1A4f80LYyMq9Ix/vOqhEh74Pt+71n2Zd72nUKW/99oQBf8ML9c+MyOpJZ6+qJttNysQtTeucavie/C/V/4zI55QepL1Zmf5BHW/mAQOsXyNBGPBsFmFAKvt+Q1b1H7Ky3+CV0uhna6yyN2SiTdvNwek3M6avJA+gHxrTMU/8qJfMezc7Tc/izwhI0d+378DWrdscPCiBIDU8fHjdunVlivJ1ASKqZrZ/ZaESBpalzBCl8UH0lHclDESMfTFsVOXeQ+1hoJ+Egf8263ZPo+A7CQP+h4b1T54peV5Y9NLqo87bT/bDwOGvZ2+u//qFoREXhoVLY3vP1vJw+V/a5zMmEgYCFsKAZ5WdbVvQz6rqziZl/aBh6wcN22D/f/2goevTG443h9ruHZyhchd5AP3NmA5BNjveEduveNLKqVbzlWw+8OOPxzVo0DAiIqpx4w927z4aHNxV/bpAsd/grP4qGWIgeAv7lxoGltqV9rsj//dGxNiaYaOq9Blaoeugkh36FW7d2xYGGgff2YAw4HdoWP8ETQ4S75hyR7E5xSdsm5pkSd9+Jg953mS5Imbnm4G9Hw/Z9Gatc6H9zof2Pd62xeY3X5b/z4X0Pd+n7+Y3a8m9hIGAhTDg2azDQOSorel+5NBQ2xk3h9qnDB11o00eQL8yvVhJL1nyxHS9J+HzzpbYhOw8duDAiDp16ixYsNSa8XVBy5atla8LrPaBRmlbg244rWra9Or8mhAGlLewfylhYPHFqeIS8cJUuVlHwsCAUVX7DKvQbXDJjv0Kf9j7gebd/m0LAx0IA/6G5mFAMc/kPPdMv6f9r52PmRLUMJDNawb2dOy78aUXznXodq692PW8/f+NL9WQ6VwzEMgQBjyr7GyZhYGRY/cqRt38v1Nj5M035YGy40nnCd9G3HSSQPQru+Rz/VBfQd1Bli5dWa/eu7NmfVmvXr0vvvhamah8XbBlyx6rYxiQGDCt6rqIGqLSA9s/BrRd8qlXBWTmfPOkBXaVhkx5acBHVUOGVew2uFTH/kVsYaB7ZmFgwPoIxyISDWa+afk+HVQjJvmKGJsNlTk3Vq12pvrLZxu3sdmoTUz1l2WKl5MAYcDfIAzcbhiInnB0tN3oCUfsHlXMmKLem/6/TFSSgJd3PMSsVaqT2D6FTBMbxY2oHhtaNHFJlCU2wc3n+tOqqmFg9erNkgFWrdpgzbiGeNy4ScpdEgzee6/+ihXr3P4e0fjx433+khG9ptv9q8DAYnNjx98wJuN/1Vg3Sh54NmRYpe6DS0sYaNNHwkD+xp3v4psB/0PzbwYKfl6o/k+Nnv22epHZRSP+jDpmSriVMFDhmTPP1LC+1fSsXWnLFMJAgEMY8GzWO5vHXxMaPzlm3JSY8ZNjpTF+SgxJQBtjTZnelXAuq3tzruXECav1mu9fss5KpWKa2FhqlLhRNZPWLbBa0i8CzuJz/b//Pijl/uLFP6mdHDx4pmnT5n37DlR+UGjp0pXt23fq3bs3f3TMb7Ucd/MHpP2qQ2Podv+Ssn7G0egZR0anezTjf7VxJPrG9BvzRMsDK3UfUrpT/6Jt+jwoYaBJ57sa+j4MnEo0/336oNmakp2ZkyxXtp/efyg+JrMZ/LZYvJ52/Yj1iPmK2XHisK3DLFcsTnNqGwbq/9S48OyiNRbVnLN7QXLG8Tk67MXTiVfEbIaBPR37/lnyCWutho7+UbISw4QCHMKAZ5Uw4PjNgNMOFh4R6dZ+od2l9J84M9nmDNv/JIHbN+HL0NiB5eIin3E/gyXFNKOdJS4pcUmUnH2T/1qh3mWa2jq2678z6zZ+fL2k32e7vct8YGfigiE+f+F6G9M5n2l6W/O+7U7TM/ujY/v2naxfv8GMGXOd5j9zxhoc3LVTpy7qNcT8BWIvm8XG7KQlJs40s6PtIWPeiOnyL4vJknHXtbiwkvGf/J/bR5n/2RoXViqzPk1zepIHXHW7f0lNP3F31MQ9UZN2j5go7rH/L1PsE+XmpD3KvbYptrbDPPLYxzqF2cJAi/QwkOc9n4UBqelrf/9Wpa+ffOP7usXmPDp+6+QsZjaZL/Zc07fo7EfqfP9/Fb9+4v6Z97v+SI7Vn4rFVPmXwdwDc0vMK1H3p7pVFlZ5bdlrp86fUqbLqzh5/qTTAzWsf/JNy9dyRdsNx52Pz2oYyM41A7YkUORxJQDsr/j0H4XLy//SttRq8EeR8l7OA/6zfiGNMJAdlZ0tizAgLvr+J0cXfmczou8HUv1PmX1BkSSgiZbD+6TEzywMSNWetHKarbEkKrZbftO0D9PvSjgXG1I4izBgSThrTb6c2b1S3ySt/cbnr90nui3le/bs2bRpc3VEkJPJyVf79x8sM+zZc8ya+V8q8PlLM6pZb8yOxo9+1Xxwt9UeBmR/Sfrtc2W6+e81cjOzMGC1XHWIDS5LP3EibsRz6jdLmIVS0I/dHD5mS/gY2/8R0hi7OWLM5oixtilyM70xNr0dYZvNPoM8sO/gyMeCwx5pG1KgRY97m3S+u2HHPO+181UYeGnxK11+76W098WeLPT5wwv+WZrZzP3XD3l6fuWTCcnKzVOJ5piks66z+Umx+OHvH07ZO0Vpr4lZ88CsB46eParcHLJlSLVF1a6nXU/TPwxk5sh+NU+YLmfTPwqUTS/9C5RVSn/533EiYSBgIQx41vFruMzCgNOYPGX+MWEvSgCYPi9lxpcpJAFH48KfTPp1ZuyAMslbfpYy3TS9bVxYKTFx6Wi5N2HR0MSfbVWm5eTJuLCSlkN7pZ205qvEH8YqD0/e9mtmYSB2YDmlCpEwYJrcIrb7fdakC7aH/z7XNLWVGgZMU1vHDa8eN6SSWv2YZnZI3rBIaSStmGoa+6ZtUO+yMcq95gO74sfX8/n75hPdhoFevXpNnjwr6wdKVKhfv8GmTbv4ZuA2te0v6xbEDa0iu4N514aEeX1k4zR99oFyb9IPn8SNeD5ucAXT3PRqTN2Yk1bNSJgXkjCnuyRh0+RmTqPdLCeOx3/8itKWMGCa0jI+unZ6DzPay/6ihAEp7uPHvhU3tLKU+Ml7bJ/gSn6I/+hl9bkl/7FE7rXtzhlfxJkmvm/+Z6vP3zf/V2r6qDVhUWsG2P8Pi1pta4+Qm6ttU0aIqwdkzKAaJo/qHtK3fu+wMmoY+KCLD8PA6qObgyYH/XVqrzql9cr2Lyx6SRqTts/ovjok+LfuD39RuPHPzSzWa+K/p//7o82fuPYTtSm65NxSYotf2sQmnZPiYda+WaF/hgavDX5k7iNtf2+7I3HHs4ueLfNVmVWnVikFxlMLnpp3cF7F+RVl+o8nflQmjt0xtvSXpUV5yIWUCzJF6afH+h5F5hRp/mtzpXw/n3K+2apmFb6p0H51+9iLsW5nW3Z82YOfP1h8XvFXlr4iM7z909sfrPxALW9OnT8lL/z3M7+nZYSBlOspjVY0Wnpsqdfqn5yGgeNPPKskgb4hPZSCRMkDx56oShgIZAgDOdvZlDCQzR1PHqheOUAScFRqdCnHLfFmaUsqkDrbknDWcuqU5AHzkYPJm5bFj35N7kr8+bPY3gWTfrJdaRo/7m2lELFmHgYsp07HDXhMaUsYSFgYGT+8WtK6+VZ7rZO8daUaBswHdkphlLx7k1QwyhR1ZIU04gaUNu//23J4ny1LJNs34MTzsb0e8vn75hNv53P9r75a3KBBQ0kOhIHb0ba/TG4h+4hs0rE9H0jasFA2S8kDypgT2VBtW6lM6fmA5Gerw8Ys+dn2eb/sAonn7UHiD8duk1Z/KUW/0rbtIH9+F9P1HsvpM5KfYweVT1o9Jz0MxJvNx4/aevv+Y4kZ1puHCclzix9b1xITl/jLlPixdZSJCV/3T/xpgs/ft1yhx18TCl8eGr48RFWm9Ajt2zh00JM9w8sEDyjWNuShlj3ukzDwfsc7fBQGpu74oujsRxynzN41/8FZBaQxavPY/NPzy8245PMl5pb89cgfe2KOSQG99dQ/Tp3sPHP40TnF98WelBjwzg/1J26fLsXDuJ3jCnxe4NfTv0pNf++Me+v/XD/5cvJnez6ThlJgSAke8kfIuZRzUrU/9MVDqWmpR88eLTGvxOnzp+UhDX5pMHPfTJlN+pGHf3v424vXLpb6stTGuI0ycdreaVL3S2PU9lFR26Iym00Cg/rNgExUOlSRHDJp96S0jDDQaU0niRPerH+G9XnpWPxlMetq5FjcJXH+4h+VJBAeETkwpKnaiZIHuGYgkCEMePZ2woBUPLKDkQSclAJCKS/E+LFvSdmhtE0zO0oRbxvS0/0+KX2kyEhaMTV+3DsWkyV2YFn14ZmFgeTNy9UPLJUwkPTjuPhP35WYIalAosKNYUJyStm9KfG7UTGd86U/DYcwkLRqhjIxplNe9VpktdIKND3+tGjWnjlj5ZuB29S2O9hH4csmKqlYmSibtO2LNXvbcvifpF9nSV417/7TenMYME1pmT5/9OtJ67917Dbh67DEhRHp90oY+Ht1/KfvJf3wSdLabxLmhUhUUIcJyQ4oWdo0tZVp7JtWlzBgPnrINnHnurghlZSJiT9+qsYM9KhyjnA1OLiPlP79l/QIW9Kjv1252bNvv+b9w5/rF/VUz4iynQcUaxf6UMueEgby+TQMFJld1HHKrJ1fFZhl+/REwsAHP6dvga8seX3u7m93xxx1+hpBcdjGj1qtaKe0Z+788rXv3lDCQNvf2yq1ROkvS281bZXG8hPLayypoUx0HJzz8OyHN8dvHv336Par2ytTvj70dZ0f6qTZq/xWv7VSJtZeVnvRkUXSeOOHN979+d2eG3o2/KVhre9rZTabUxiY8c8Mxwqn/DflJZwoz6Truq7SoeMFBt4MA8o1A6M/XytGTFwp9vl4qdgpYr6ohIGj6V4W5YG+3ewJA34FYSAHO5t6zUAWydtpZ5MMoOjzV+FX2oqbE8eVdvyol2y/rWFvJ8zprlyqGx9dO2nt1/HDn7UmXYztXUjSgjoEwprFNwMnjquZQQkDljMxMV3+lfDNgKSfxqthQHJIbN9HEn+eJPWN+zCQcfFlTPCd6WFAnkbPBwLhN4X0kGsGblN1f7GHgXeUielhwJISN+J52TvMuzbYvlhzDQPT26bPL/vUzWFA5lGuHrZmhAHZE+OHVZUMYN7/txoGkjd+HzuwnCSExGXRbsOA8tzMO9erYSBh/kAJFT5/33KR6pnC0Ro1bNV/n2+6KEo7MjLyw0HDXh0S/Xy/qKftYeDRdqEFfR0G1hzdIvX9llN71ClS1ivDhCQMtFyRvgW++l1tCQNma8o90++J/HOkUydh68M7/tZVac/bs7DGoppKGGi3up1SS0gY2JawLS3LMHDAciBiS0S39d2UKYuPLn7p+5fS7FW+2o9kAKXKrzS/0oitIzbEbhCVmOF2Nscw8M7yd5qsbKKWN7Jox2FC/Tf2L/t1WdMlkzfrnyG9Xz4ce0n1iN3M2o5Twnu97NttnjDgVxAGPOsUBrL+Gs6vkrff6hgGEn+aYK9XrtlGMgyuIFWI1V7E2C4hWDDYavvqoI6tytmxVn14VtcMDCgj5ZE1IwxYlZ9J6ZzPEhOnhoGk375QhiEl795k++zffo1B1mHAcmhv/Ni6Pn/fcql8M3CbZhEGLMePxXS9xzZMKNYU27eYFPTWbIcB89HDyo5gzQgDtgFCPe6PG1rZah9EpIQB07Q2CYuGWe3DhJRrDDyGAdOkJrJz+fx9y+0qf4G4x9xOojR69+vfITzq7RGfvjYkuoaEgV4R5ToPtIWBVj3vb9r1X+93uqO+311A7BoGpNFnbdhj88rujzulTN98cvfh+NiNJ3aW/6pCfPIFi/WaPGT0lvHZDAM/n/zZVmkk7SzzVRlp7E7aXXF+xUvXLl1Puy6PnbBrQlomVX7on6Fv//T21dSrarnidjaJFpF/RSoT18aszfoCYokiVRdWPXv1rNfqH8IAaAJhwMg7m9/qGAYssQnxH70sMSC2z8MJn3dOn3hor+2HQe31ROKyaLlLKfFF0/8axg4sKwVQ3NAqylWSjtqHN8yzOoQB8+4/lauEbwwTkrJpYNm4IRVNk5tJ3ZMwz1aVZh0GbN8t/DrL5+9bLpUwcJtm9c2ANCbUjxtQOm7ki6bJTW1fplmuZjMMiHFRL5iPHLSqYUAWsW6+hG2rQxhI3v5bbEgRKfRlL4jpVUBmyDoMWM7ExA+rajVf8fn7lttVwoBin35hnYeOajx68jsjPn19yJga/Uc+0yuyfJeBxdv3LdSqly0MNOqUt357n/606JtPfPNU7e/fcvxpUbdhQCr+zr/1/O/M/7646GVJBc8tfEG5hKDDr10Kf1Gk3JePy/RjCaZshoHgtcFSuEuNvuDwAmVi13Vdi84pWuGbCrW+r5V4OTEtkypfSvaGvzR8ePbDry59VbkIwe1sG+M2lvqyVLNVzZTpcw7MKT6veN2f6lZeWNntT4vK86m9rPaV1CveqX8G9aw1qJfiy+LAnjYdp9w83a48xCZhAG5AGPAsYcALWmITlZ/9uV3NV2yXWmb+u4c3lmi/fNmafNn2O4xZz3l4X8Lc3j5/i3KvhAG9tcQlZzSScvbAkyfVkUJZmXxJ2T0tEo09Vfmys9iuafb1e2IMe/ToE9I/TOw+YnTrT2c2iZ5cb8SE18PHvCBhoPeNMPAfxzDguz8/fDIhOft/dCzRfHn76f0SDBwnxiWfP5GQvg1np1hUSvCL1y46fsAvyBSnPwqWGedSzqkf5GdGyvUUx95S01IPWQ+5/okxVwxQ/+gnYcCvIAx4Nvcm78BUCiPLmVgNO7RdH8mPpt+G/QYPE5yuP5YpPn9iaFV+jMi/OwxwpbgXgyfP+dAWBqbUi5pQW8JA2MjKvSMf7zqoRIe+D7fu9Z9mXZXZfJgENDf7YUDvMuaWMUD949v1C16DMICIiOjXqrV+Zvr8GWquAYpF6h9jr18jQRhARERE/9IAxSL1j7HXr5EgDCAiIqJ/aYBikfrH2OvXSAQJui4gNHKarttTkybt/Kf/reZfOsfcFWtJyKXPn/7pn/7pn/79tv9LAyJy9fPPkVIs6l2fUP+wfuk/va3rktICLBlHxj3dISZoSWKUz58JIiIaTDl7+/w5eE0DfHIcUPVPAK5fI5G7w8DAgZEnTyY7Tdy9+2hYWHhwcPdTp8ze3LJPWU5KEhBDY4uYrbr8xvaAARGurxcxl2oyXTxzxurzp4EB5erVm7/44ptFi35aunSlVYuTyIoV6+bNW+idJ58bw4C82/Kejx07cefOwzl6oAGKRT3qH7dbbE49cOD0iBGjtX1ix48nms3Z+lVZw6xfI5G7w8B99923d+9xp4m1a781fvzklSvXx8ae02/Rrk40NVLCQL+44uuS5uuxiHvvvdf19armaD9EzFqL5ZrSuOuuu5577gV1upzRg4KCbvNEsmbNlpdfflW252+++c7nrxQDyhkz5n34YYcBAyKGD//YqsVJZNSosS1btnVs6GdOhwn5g/Juy3tes2at33/P2R+lNkCxmNP6x/GoW6JEyTJlyokTJky1OmyobrdYxYiIKDmoli79WOHCRZ544qmPPx6ndujkunVbS5YslZ1nkh2nTZtdtWr1PHny5OgTWAOsXyNhwDCQL1++o0fj9VuoW5OtlzrH3KWEge4x/xkZ96IeS8kiDDRr1nrcuM+8/KrRqD76aPG//tqrtO++++78+fPv2nVEuTlo0FC5eZth4MiRuGPHTC+88BJhAL3s/Pnfd+3ae+TIMZ98MsmqxUlEzQAm08W4uPO6PvncGAa6desju/lbb72zZcueHD3QAMVijuofx6OuhIGtW/9xvPfkyWSlQM86DLz//gdKe8OG7VLu9+8/xO2cWYcBx2eSHXfvPiqxOSgoiDCQe8n1YWDu3G+ffrpy6dJlvv9+hUxp2LCJbJGSiceM+d8//5yoXfstuffZZ59bvXqz2x4+/LCDpGcJtWFh4XJz8OBhZcuWf+ONuur8cs6Qe2XikiU/y81Jk2bIoa1p01YPP1y4c+eex48nykTZDdp8XkVJAoo9Yx9oM6CBBPratd8sUqSodOK2N7dLdHL79v3yEMn6rVu3v+eee5SjwEcffVKt2vPly1fo0qWX1X56e+CBB4oVe7RmzVpy87vvfnnxxZcrVnxCXv7p057/Fi+iowMGRNx5552PP16xe/cQq70watKkeXj4COVe2a4aNGishAHXLc3tDpKZhAH0vlKvy2Ypm6syRO32TyJqGJCNv1evfspEOa0UL16iTJly777bUG7GxJxt1KhpuXKPt2rV7uDBM8rMsn8FB3eXPaVx42ZKnbdnzzFZ3JNPPl2nzv8p/Sxc+IPsidWr15g16yuru2FC0o9kG3nOr75a23V+Uc41sqNVqFBp4MBIubl5827ZZ+VMVLToI++8U19uKrNFRUVLdSi2aNFG+T7E7TN06s3tEp1Oc/Juy3t++HBsUlLORs8aoFjMfv3jdNR1DQOVKj154MBpq0MY2L79gLztsqHKulDeW8cwIMpRWmqG5OSrrpufYxhwWoNOz8R1KW6VzYMwkKvJ9WFAyugjR+I+/XTK66/XUSbKFqmUILJdSmCVxvDhH0vR77aHunXryVYuh2Bpb9u275lnqphMF1et2vDKK69b7aeN/PnzKx8RKYNw5Lgvh/iVK9fLImSe0aPHy8TPPpvZ7sDdjmGgb1yxZt8+WqpU6T/++Fu6leeZkHDJtTfXJboqR2HZpWVPk8JLDhDKUUAeKB2KkgH27TspU2RXV78ZkBPYiRO2v+gub86MGfP0e//RqMrpX/1kSMLAokU/SvKUtmyo9es3atOmoxIGXLc0tztIZhIG0Ofe/knEdZjQrl1H/vWvf/3220ZpK/WTdC5VtdVerg0ZMlyZWU4Hs2fPl/NCiRIlf/31D5nYv/8Q5fMd5QQhh325a//+U5JbHnmkmBzwXcOA9PPf//73xx9/czu/TKxRo+bXXy9R+5QqUApEOWfFx1/o3bu/5AGrfezfo48Wl1OJxACZMnHi9MyeoVNvrkt0Pc3dsgYoFnNU/zgedeVc361bn8jIkR999Im6oToNE5KTvuRYeZNr135zxYp1VpcwsH37ftmSZeW6bn5qGHC7zTg+E9eluJUwkNvJ9WFgx45DVvslXBUqVLLefBwXT5+2LF26smnTVrIdu+1BwsCUKZ8r7fDwEU8/XTk4uIfsNnIol2OlTHz11dpSr0txY735uC9K8V279ltW+wDTjqfucgwDYvsTd0yaNEOZM2/evMeOmVx7c7tER2UPfOCBB6XkUm46DhPauvWfyZNnFSjw0G+//Wm9OQyIkv7nzVv47LPPDR06Sr/3H42qUxiQgka2tPXrt7Vv33nBgqVqGLC6bGlud5DMJAygz739k4hrGJAaTgKG4zxy5JdzjRzq69Vr8OKLLyszf/BBS+Veic1Sb0lj2bJVUkkPGBChfDYvZ4qHHipoP0H0KFKkqFT8rsOEpJ/mzT9U2q7zW+1nmYIFC02fPkeZx/EjYdnH5Zwie/ewYR+1apX+I5IzZ3752mtvZPYMnXpzu0Sn09wta4Bi8XbCgBxRp079Qv2+xSkMmEwXZd3JAVne+apVqw2wbxhOYWDDhu2yJUswc9381M3A7RpUn4nbpbiVMJDbyfVhQNk9ZIN2PY7Pn/99mTLlvvjim6io6CzCwLRps5V2x45dZVeRU4KiEpGTk6+OHz9Z9g31wxK11vnkk0lSglvtNc2cOQuUiRIDlFF6jj3feeedShhw6s3tEh09diwhT5486k8HKGFAEkK1as936dJr1aoNsj+7hoFevfq9/nqdxYuXy3GBMIC3oFMYsNq3VYmsZcuWl9JBDQOuW5rbHSQzCQPoc2//JOIaBgYNGioHdsd5Hn+84uDBw5Tj/Jo1W6w37ylSqymlttX+KU/9+o1Kl35MTgcysUSJkuoJ4siROLdhQO3HdX5l+nff/SLVueQZ681hYMuWPYULF5FGWFi47ODKRMn2NWrUzOIZOvbmdolOp7lb1gDF4u2EAadhQk5hQCoK2Upl+1Te+e3bD1hdwoDclPre7eanbgZu16D6TNwuxa2EgdyOkcNAixZtZAew2r/hfemlV9z24FiyL1iwtGDBQsqwB0U5HCuf1kud3bhxM+X4+Morr585Y5VN/913G06fPlcmRkdPkIOmTImLOy9h4I8//ra6CwOuvbku0dXKlasqS5GyKW/evPJ69+w5ds8990hv0ucjjxRbvny11V6rqald9u1fflkrM7z99nvqyE7E7CsnD+UjImtGGJDkeccdd3Tu3FPaahhw3dLc7iCZSRhAn3v7JxHXMCA107///e+//z5ozRgm1L17SJ06/5eYeNn1UVaHUlutpQoVenj79v0HD57Jnz+/7Hrqo9wOE1L7cZ1f7VNqO6UulCqwQIGHlJGxo0ePb926vTQ2btxZvnwFOT3Jbiu9KaP7sniGam+uS3Q9zd2yBigWc1T/OB51PYYBaUgki4wc6TiPYxiQpCfl/tSpX7jd/NQw4HabcXwmrktxK2Egt2PkMCBbc+HCRWR6SMiABx8sMHu2m5/7dCzZrfZLZ+6//3456Feq9KR0smvXkWLFHpWbVatWVz/OefbZ5+rVayCHzpo1aykXTR47lvDiiy/LFDmCSxhw7VkJA669uS7R9RkuXPhD2bLlZb8NCwtXhwm98079UqVKP//8i40aNa1S5dnk5Ku//vqHVGbKB7FSqMmR+oknnurRI1TSQk5/wwFx7NiJsskpv72ohAGr/bpApb5Rw4DrluZ2B3F1yZKf5RwjJyHZjDP7wBXRC97+ScTtT4uGhg6UHefppyu//PKrVvtYI9kpChYsJId6Sc7WTEptCduy48jZpH37zspdkpblUdWqPS/7i+w1WYcB1/llStWq1WSXlP+VYatKGGjVqt1zz73w6KPFN23apTywQ4cu8krLlXtclq58j+32GTr15rpEt6e5W9MAxWKO6h/Ho252woBEMjn2SnlQvXoN5UoA5adFy5QpV7r0Y/L+f/nlIuWxrpuf4xdErtuM4zNxXYqrslx5rOw1Tz75dN++gwJn/RqJ3B0GPKp+SnHmjDWbP2Ug6dnpR+WUI6P15iOv61/9kJOHLEsNA5np2FtmS3RSMndMzFmnieoTUL9YkBeotuX1KhdvZf21A2JmyibkehGL29kct7QsdhDE3OgtnEQU5VFOe4H04PHn3eRRTn/cQI7/hw/HKj/mk52fFnWcX1H2zeTkq0pbrQJPnTI7/ZZ8XNz57JwvHHvLbImup7lb0ADFYk7rn2wedR1VBh1ks/PMNj/XNej0TLK/lIBav0bC4GHA0bVr/6pcuaqjMiWnnXj8szIew4DezxDRh7ruIBMmTHXaqn3+JBFvWaeNWfmDUF5zSuEit7l0j39tyn80QLHoP/WPVrZt28lxC5Sbgbx+jUQAhQHveDthABERMTNdhwkZWAMUi4FW/wTa+jUShAGNJQwgIqIeEgZyF4FW/wTa+jUShAGNJQwgIqIeZueaAcNogGIx0OqfQFu/RoIwoLGEAURE1EPCQO4i0OqfQFu/RoIwoLGEAURE1EOGCeUuAq3+CbT1ayQIAxpLGEBERD0kDOQuAq3+CbT1ayQIAxpLGEBERD1kmFDuItDqn0Bbv0aCMKCxhAFERNRDwkDuItDqn0Bbv0aCMKCxhAFERNRDhgnlLgKt/gm09WskCAMaSxhAREQ9JAzkLgKt/gm09WskCAMaSxhAREQ9ZJhQ7iLQ6p9AW79GgjCgsYQBRETUQ8JA7iLQ6p9AW79GgjCgsYQBRETUQ4YJ5S4Crf4JtPVrJAgDGksYQEREPSQM5C4Crf4JtPVrJAgDGksYQEREPWSYUO5CXoLF4vt30g+Vt8UA69dIEAY0ljCAiIh6SBjIXew/edmUdM3n76QfakpM2X/isq/XD9yAMKCxhAFERNRDhgnlLk7FX9134orP30k/VFauvDm+Xj9wA8KAxhIGEBFRDwkDuYvU1LQ9xy7LCzElXWO8kNU+OkjeCglI8rZcv+7r1QMOEAY0ljCAiIh6yDChXIeUvKfir+4/aYsEKMpbIW+IxCTwK4IEXRcQGjlN1+NFkybt/Kr/nIYBf3v+9E//9E//9O+f/ec0DPjb88+RUjjqXZ/QP/3Tf3pb1yWl8c0AIiKiFjJMCAD0gDCgsYQBRETUQ8IAAOgBYUBjCQOIiKiHXDMAAHpAGNBYwgAiIuohYQAA9IAwoLGEAURE1EOGCQGAHhAGNJYwgIiIekgYAAA9IAxoLGEAERH1kGFCAKAHhAGNJQwgIqIeEgYAQA8IAxpLGEBERD1kmBAA6AFhQGMJA4iIqIeEAQDQA8KAxhIGEBFRDxkmBAB6QBjQWMIAIiLqIWEAAPSAMKCxhAFERNRDhgkBgB4QBjSWMICIiHpIGAAAPSAMaCxhABER9ZBhQgCgB4QBjSUMICKiHhIGAEAPCAMaSxhAREQ9ZJgQAOgBYUBjCQOIiKiHhAEA0APCgMYSBhARUQ8ZJgQAekAY0FjCACIi6iFhAAD0gDCgsYQBRETUQ4YJAYAeEAY0ljCAiIh6SBgAAD0gDGgsYQAREfWQYUIAoAeEAY0lDCAioh4SBgBADwgDGksYQEREPWSYEADoAWFAYwkDiIioh4QBANADwoDGEgYQEVEPGSYEAHpAGNBYwgAiIuohYQAA9IAwoLGEAURE1EOGCQGAHhAGNJYwgIiIekgYAAA9IAxoLGEAERH1kGFCAKAHQYKuCwiNnKbr8aJJk3Z+1X9Ow4C/PX/6p3/6p3/698/+cxoG/O3550gJA3rXJ/RP//Sf3tZ1SWl8M4CIiKiFDBMCAD0gDGgsYQAREfWQMAAAekAY0FjCACIi6iHXDACAHhAGNJYwgIiIekgYAAA9IAxoLGEAERH1kGFCAKAHhAGNJQwgIqIeEgYAQA8IAxpLGEBERD1kmBAA6AFhQGMJA4iIqIeEAQDQA8KAxhIGEBFRDxkmBAB6QBjQWMIAIiLqIWEAAPSAMKCxhAFERNRDhgkBgB4QBjSWMICIiHpIGAAAPSAMaCxhABER9ZBhQgCgB4QBjSUMICKiHhIGAEAPCAMaSxhAREQ9ZJgQAOgBYUBjCQOIiKiHhAEA0APCgMYSBhARUQ8ZJgQAekAY0FjCACIietZ08dz2/dbkq5nOEHvu7DGT4xRvhIEzVuuxBN+/OYQBAC9CGPBgcMydRyz7M25e8zh/ZmHAYk3x+WtBRER/8PxPv18rX+Fq/UbXypa/OHaim3nMKVdatbOeSLoUEXX9vvtSixS9Vu7xq6/UzrTPhEu2qBB3PrvPwZzJKcl08UrTVtKbz98iwgCA1yAMeFANA/3iih+y7PU4v9swcMR8MCS2iM9fCyIi+oWW9I+Wzv/2Z2rxEq4zXO4/5OL/pklDwsDVJs2lcW7Nlut33HH2nxOZ9nkiKZtLP/v3wdTCmZ6SLny1+Er7zj5/iwgDAF6DMOBBJQwsTIyQxpC4ivMSQqy24v5AVFyNiLinFiZEmq1XZMpMU4cfk8YNj6suYeCE5cTY+LeGxlUeEffcnuTNcm90/OudYvIOjauyOulLubk5+QfpSnpYk/SVz18gIiLemtcqPXnxs5nXSpc5v+Rna+y5Ky3bppYsJV4aMVruvTRo6MVPJknj7L6TqSVKnvvL9nHShVlfXRo1Vu3h4sTpV99+z03PZcopI4jUMGA9lpAWFHR2+wFbO+bs1UZNr5V7/EqrdmcPnrFNSbwsi7DGX7AtYuEP1x6vmFK9hixL6e3szsMpr9dJfaSYdHt++eqUV16/njfvtWeqXJhpOyVdGjkmpWr1a2XL216FsvTSZdS44isJAwBegzDgQfWbgZDYwuo3A5NNTdcnfWuxpow1vbnTvE6mjI+vJ9nguOWYhIF4i/m4+ahM/D7xYwkJ0jhs2dc7tlBGn9fC4kqespwyWax9Y4slW3P3+4OIGLBev+++K81aW0+ZpS2p4GrdelKmn91/SvLA2b8PXvh2WUqt12x3jfss9aGCl0aPl/bVN98+t9r2IdHF8ZOvVa4qNbqkCKduzx44nVr6MaUtYSDltTcuTp+TUvtN9ZqBi59OuRLcXbn30pDhtonqMCHLNUkF8hysZ6xS/SsDfq40/9A2+CfmrG3OpCvntu1LLZhxSoo7fz1//rNH423tjLFDkg3Obdzp2/eWMADgNQgDHnQNA0nWi91i7/08ofNsU4/h8dUWJtp+603CwG9Jn1szhgmZLJatySunmlpJWrDeHAZ2mtf3ji0ojxVDY4tuT/7N568RERFvQQkDZ3cfVdpXa78lJbvSvtKmo5TpUuXLDLZP8d+oe3HC1KtvvWM9bbn2WFllHqm/Lyz68ep7719t0Nip2/OLl6e8+LLSln5SS5W++vZ7qYWLXOo7SJmY8mptCR6Xg3tcrdcgfc6MMHB+5XoJHnKXmFqk6Pkff7OaLl6///5zv29S+78pDNh7u/ZMFXmgOkW6vTB9rm/fW8IAgNcgDHjQNQzEWk1S8W9M/n6neZ14xGz70lbCwO9Js632MCB3DYwttzbpm2WJ0a5hYH3St2FxJZXHijGWOJ+/RkREvAVtYWDvcaWd8sJLF+YsUNpXgrtf7j/Eaq+zL3z+9bUqz0pFLvW3pIXLXXrd1MnxxOv58p3dcchxovSpZgZ1mJCEjZSq1ZSJ1x6veGnwsPMr1onn1myxTcwIAxfmfptaoqRyl3j2SJzy2f+5P3eo/TuFAWvy1YvjJ6c+XPjixOnpr6V6jXPrt/n2vSUMAHgNwoAH1TAwJK6i+in+0Lgq3yWOdJzNMQxMM7VZlDDMah8m9HH8K9I4Y4ntEvOvRKvtdx5OW850i82/y7zB5y8NERFvR8cwcDF6wpWWbW1D7ePOXytf4dwff8vES6PGppYsdbnfYGnbRu2XLHX+l7W2+TNG5J/buDP1wQLKWH9HbaP27YN21DBwdt9JKffPL/pJ2pe7h1yt83/WxMs3HpIRBs4ePCOl//lVN51irjRpcaVTN2uS7Qo3+f/s4djr//pX+k8PJVxSln5x3GdXGzdzWroPJQwAeA3CgAfVMLA8cWJYXCmp76V9yLI3Iu6pQbHlo+JqLE6wjdd0DAOSGUJiiwyJq/RNwoBeMQXWJc232i4zaCEP2Zz8o7T/TP6ud2yhEXHPS6jYkvyzz18jIiLego5hwHosIeXFlyUGpBZ6WP01nnN/7ZUaXRmicykqWu5SiuyL02Zfq1Dp6jv15X/lV4OclHL/wox5VscLiO1/Z0B6sH3Yf9pytV6D1IKFUl56Jf36Y4efFr3wzXe2u6o9bxv8Y78m+NyWPdfKlEst9ui1suXlXqs9Hlx74qkLi348u+uITJd+bNcJ2L9kOL94ue1CCF+/t4QBAK9BGMiBJos1yXrj85tYq8n18l/lmgGZrswpD1F+bsg2vyXRYlX/vsy1M5bY7PzhAkREzDUeT3T9mN+9J5LO/n0w03uTrki9LkW/48RLAyJumueMVZ3BdtVykaI37rJcO3s41ukXgWwpwvHzfnmqGX/y7MZfN0u4ZPt+wOWaZu9LGADwGoQBjeUvECMiogaeTLYV9A5TnMOA4omkq2+9k1LrtcsZlxfflqct6b9V6msJAwBegzCgsYQBRETUQ/WnRQNBwgCA1yAMaCxhABER9ZAwAAB6QBjQWMIAIiLqofthQgaVMADgNYIEXRcQGunmdxI0tEmTdn7Vf07DgL89f/qnf/qnf/r3z/5zGgb87fnnSAkDetcn9E//9J/e1nVJaXwzgIiIqIUMEwIAPSAMaCxhABER9ZAwAAB6QBjQWMIAIiLqIdcMAIAeEAY0ljCAiIh6SBgAAD0gDGgsYQAREfWQYUIAoAeEAY0lDCAioh4SBgBADwgDGksYQEREPWSYEADoAWFAYwkDiIioh4QBANADwoDGEgYQEVEPGSYEAHpAGNBYwgAiIuohYQAA9IAwoLGEAURE1EOGCQGAHhAGNJYwgIiIekgYAAA9IAxoLGEAERH1kGFCAKAHhAGNJQwgIqIeEgYAQA8IAxpLGEBERD1kmBAA6AFhQGMJA4iIqIeEAQDQA8KAxhIGEBFRDxkmBAB6QBjQWMIAIiLqIWEAAPSAMKCxhAFERNRDhgkBgB4QBjSWMICIiHpIGAAAPSAMaCxhABER9ZBhQgCgB4QBjSUMICKiHhIGAEAPCAMaSxhAREQ9ZJgQAOgBYUBjCQOIiKiHhAEA0APCgMYSBhARUQ8ZJgQAekAY0FjCACIi6iFhAAD0gDCgsYQBRETUQ4YJAYAeEAY0ljCAiIh6SBgAAD0gDGgsYQAREfWQYUIAoAeEAY0lDCAioh4SBgBADwgDGksYQEREPWSYEADoQZCg6wJCI6fperxo0qSdX/Wf0zDgb8+f/umf/umf/v2z/5yGAX97/jlSwoDe9Qn90z/9p7d1XVIa3wwgIiJqIcOEAEAPCAMaSxhAREQ9JAwAgB4QBjSWMICIiHrINQMAoAeEAY0lDCAioh4SBgBADwgDGksYQEREPWSYEADoAWFAYwkDiIioh4QBANADwoDGEgYQEVEPGSYEAHpAGNBYwgAiIuohYQAA9IAwoLGEAURE1EOGCQGAHhAGNJYwgIiIekgYAAA9IAxoLGEAERH1kGFCAKAHhAGNJQwgIqIeEgYAQA8IAxpLGEBERD1kmBAA6AFhQGMJA4iIqIeEAQDQA8KAxhIGEBFRDxkmBAB6QBjQWMIAIiLqIWEAAPSAMKCxhAFERNRDhgkBgB4QBjSWMICIiHpIGAAAPSAMaCxhABER9ZBhQgCgB4QBjSUMICKiHhIGAEAPCAMaSxhAREQ9ZJgQAOgBYUBjCQOIiKiHhAEA0APCgMYSBhARUQ8ZJgQAekAY0FjCACIi6iFhAAD0gDCgsYQBRETU0Ot58qQFBTl6PV8+nz8rvSUMAHgNwoDGEgYQEVFDU1582TEJXKnf+ErLtj5/VnpLGADwGoQBjSUMICKihp5bvfn6HXcoSSC1YKHUwkXPbdju82elt4QBAK9BGNBYwgAiImpr6qPFM74WaJRSo6bPn48XJAwAeA3CgMYSBhARUVsv/m+acuVAyrPVL8xZ4PPn4wUJAwBegzCgsYQBRETU2OSr1++5xzZMqEhRafv++egvYQDAaxAGNJYwgIiImnu5Q5fUgoUuRUT5/Jl4R8IAgNcIEnRdQGjkNF2PF02atNO1/+9jg3JkdEzO5tf7+dM//dM//dO/Efo/lnD9/vvl/9z6/HOohAG96xP6p3/6T2/ruqS03P/NgGPhPmL0g39913/Huugd6z7ZsW6M3ehtq0fuXDd6zTcNchobFH3+AhEREf1NvhkA8BqEAQ/eSAJf5DOfWm3OnAN/DiUMICIi3r6EAQCvQRjwoFKyf/z5f7+bWdte8+8zm3eYzZvM5hXmpB/Msd+Zj8wzH5obs3PaiS2fjBxclDCAiIh4mxIGALwGYcCDUq//El3FfHSW2fyd2bzabP7ebF5mNn9ljplpPv6pef/IpO0R4om1PQ+t6nR8bfeYLYNjtoSrJu6I2ragKWEAEREx+xIGALwGYcCD6WHA9oXACrN5eYYr7K4ym3/NcLXdtWbz7ze7yfTXSMIAIiJi9iUMAHgNwoAHM8LAFrN5odm8yO5i+/cD2XTV0RXdCAOIiHg7BgUFZ63Pn6G2EgYAvAZhwIMZYeAHs3mK2TzNbJ5uNk86sbbDwVVtDv3a/tCvHY783tHJQ793UD26+qabqoQBRET0qFrrD5q3OGsNFgkIAwBegzDgwYwwMFsygN1Zp1Y0PLJNbh4yJ60zm343n1pm8+g888HJ5oPTzPs/Me8cbN42yLxtsHlLH/MfLcxb2pp3djZv62De1tG8qcXpRVVmjHuaMICIiFmbnQzgGgl8/rQ1kTAA4DUIAx7MCAOzzEkfm5OizacG/DH3PbN5t/nUYPORnuZD3cx725r3trH/r9revE+1w00e6rTziyoME0JExKy9hSRgpDxAGADwGoQBD6aHAdMn5tMDzKbhMT/UPLThI/OJweZtDc07mpt3tDDvbJVd97Q1//7q5FElCQOIiJi1UtOHfr4gx0ng3baEAQDIEYQBD6aHgdNDzafDzYd6bZxSxXw02vzXe+ZtjXLsjkZbJlXhAmJERPSo1PR9P1/QY/pXnT6b0/rTmdmKAYqEAQDICYQBD2b8nYG+5lO9ji6ssmNBQ9tAoC3vmv9qkDO3NTD/UnVyVEnCACIielRq+ryDSih++OnMJtFT6kVNqB0+5oWwkZV7Rz7edVCJDn0fbt3rP8263tOoU9767QkDAHBrEAY8mB4GDnU072/wU1QV88b25k2vmTe+kUPrmDfW2jTB+WsBwgAiIrpVCQPLUmaI0vggesq7EgYixr4YNqpy76H2MNBPwsB/m3W7p1HwnYQBALhVCAMezAgDTWMWVVk1oZp5Z2PzhlfNf7yeHfPeP0i0hYENNWMXVpk8ojhhABERs6MaBpbalfa7I//3RsTYmmGjqvQZWqHroJId+hVu3dsWBhoH39mAMAAAtwhhwIPpYWBHrcUDqsT89IZ5bTXz6urZVJJApx5zbXlgeZXV0W6+FiAMICKiW5UwsPjiVHGJeGGq3KwjYWDAqKp9hlXoNrhkx36FP+z9QPNu/7aFgQ6EAQC4NQgDHlTCwMHZVeb1qmLe9Ia9yn/eUVutf/OUdNfa7urS6+uuvb6WxryRFQkDiIjoqHpVQGbON09aYFdpyJSXBnxUNWRYxW6DS3XsX8QWBroTBgDgdiAMeFAJA7M6VDm+sLp5XRXz7zcpVX6/IatsecBx+q92f7Hd2yNkcfeQRT1CFkmbMICIiKpS2c+NHX/DmIz/VWPdKI96NmRYpe6DS0sYaNNHwkD+xp3vIgwAwK1CGPCgEgYmNbJX+csd/MmmlPiDhq0fNGyDcnmAq33CflB1mwd8/gIREdEnSlk/42j0jCOj0z2a8b/aOBJ9Y/qNeaLlgZW6DyndqX/RNn0elDDQpPNdDQkDAHCLEAY8KPV6vw/KhTxfxa1S30eO2qrYb8jKfoNX9Rtis79d5Wb/IerEla55wOcvEBERfaLU9BN3R03cEzVp94iJ4h77/zLFPlFuTtqj3GubYms7zCOPfaxTmC0MtEgPA3neIwwAwK1AGPCg27E9qlLcjxy7V3HQ0PX2bwkyzLg5OEPlplMe8PkLREREnygF/djN4WO2hI+x/R8hjbGbI8ZsjhhrmyI30xtj09sRttnsM8gD+w6OfCw47JG2IQVa9Li3See7G3bM8147wgAA3AKEAQ96DAPRE46Otpv+FcFHdjO+LpD2UPvNoQ5txzzg8xeIiIg+UWr6qDVhUWsG2P8Pi1pta4+Qm6ttU0aIqwdkzKAaJo/qHtK3fu+wMmoY+KALYQAAbhnCgAezDgNKHhCj7F8OqP873hx580T7VcUtCQOIiOjx14TCl4eGLw9RlSk9Qvs2Dh30ZM/wMsEDirUNeahlj/skDLzf8Q7CAADcEoQBD3oMA1LZi0okiJ5wVHG07f8jGY30/2WKkgRCxxcjDCAiohga2tetwcF9pPTvv6RH2JIe/e3KzZ59+zXvH/5cv6inekaU7TygWLvQh1r2lDCQjzAAALcKYcCDHsOAKMW9YyRwdNyUmPGTY8dPjhk/JcY1CRAGEBFx0qTprtaoYav++3zTRVHakZGRHw4a9uqQ6Of7RT1tDwOPtgstSBgAgNuDMODB7IQBJQ+okUBVqv+JM5MnzkiW/90mAcIAIiK6VfkLxD3mdhKl0btf/w7hUW+P+PS1IdE1JAz0iijXeaAtDLTqeX/Trv96v9Md9QkDAHArEAY8mM0w4BgJVCUATJl9QcwsCRAGEBHRrUoYUOzTL6zz0FGNR09+Z8Snrw8ZU6P/yGd6RZbvMrB4+76FWvWyhYFGnfLWb08YAIBbgDDgwRyFAddri2d8mZJFEiAMICJiZvbo0Sekf5jYfcTo1p/ObBI9ud6ICa+Hj3lBwkDvG2HgP45hwBBJwEoYAPAihAEP3mYYyDoJEAYQETELpbgXgyfP+dAWBqbUi5pQW8JA2MjKvSMf7zqoRIe+D7fu9Z9mXZXZDJMErIQBAC9CGPDg7YQB5cqBrOfx+QtEREQ/V631M9Pnz1BzCQMAXoMw4MHbCQPKlQOEAURExBxJGADwGoQBD95OGMiOPn+BiIiI/iZhAMBrBAm6LiA0cpqux4smTdrRP/3TP/3TP/3Tv5H6lzCgd31C//RP/+ltXZeUlvu/GUBEREQvyzcDAF6DMJBdBw6MPHky2TvLOn480WxO8flLRkREb3rgwOkRI0Y7Tjl1yvz33wd9ckaQhe7YcSg29pxP3grCAIDXIAzYtFiuKY277rqrRImSZcqUEydMmCpT7rvvvr17jzs2XI2IiHr//Q8cp9StW2/atNkeF+eqPKpq1ep58uSRE4DP3xZERHTV8ZTx3HMvqNN37jwcFBTkVM3nyHXrtpYsWUppHzoUU7v2W5UqPfnGG3WLFXt0/PjJWT/21gJDZo9KTLxcvHiJevUaPPXUM02btvL+m0wYAPAahIHURx8t/tdfe5W2HNm3bv3H8d6TJ5OV436OwkBMzFk5knpcnKu7dx+NjT0npxPCACKiH+p4DL/77rvz58+/a9cR5eagQUPlplZh4KWXXunSpZfS3rfvZKFCDy9YsDSzBzZr1nrcuM9yurjsPMpkuvif//xHfY1ekzAA4DUCPQwMGBBx5513Pv54xe7dQ6zuwkClSk8eOHDa6hAGtm8/UL16jSeeeGrgwMikpCtWd2Hgww87fPnlImns2XOsdu23nnzy6Tp1/s91cW6V7EEYQET0Q52O4fny5WvSpHl4+Ajl3ooVn2jQoLGEgd9+21it2vPKB0nx8RcqV64aG3tuyZKfX3jhpQoVKsm5Q5lfGsWKPfr005VbtGjTq1c/q0MYWL16s5wIHD85at26vTxcGh999Im6xLp1661cuX7+/O8feOAB6apmzVoycdKkGd269WnatNXDDxfu3Lnn8eOJMrFhwyZLl66UhjyTEiVKms0pTo/KzG3b9hUsWCizj7f0kzAA4DUCPQyIcrh0/GZAjqGRkSPlaKtMcR0m1KhR07lzv5Ujae3ab65Ysc6a5TCh/v2HKB/tqF/FOi7OrYQBRES/1fEYLmFg0aIfy5evIO1VqzbUr9+oTZuOEgbkgC9F9k8//S7Tp0794oMPWkqjRo2aX3+9xJpxOti+fb/U/QcPnjl6NP69995v2bKt1SEMyKOKFn3EcbmzZ89/8MEC0ggLC5fzlDJRYoZS4suJSf2Mf9SoscWLl5CQIDHglVdeHz16vEyUICHVv9X+xbWcYpKTrzo9ytWff15Tq9Zrjz1WdseOQ95/nwkDAF6DMOAcBoYOHSVH4VmzvlKmOIUBk+nivffe27595+DgHlWrVhswIMKaZRhYtmxV/vz5ZTb1GizCACJi7tUpDCQlXSlQ4KH167fJeWHBgqVKGLDav0No3vxDaVSvXuOXX9ZKIzx8RMGChaZPn6M89uOPx7Vqlf7TnCNHjnENA0WKFHVcrpyVZEHW7IUBpTdRJtau/Zb1lsKAzCmJol+/wWXLlj92LMHL7zNhAMBrEAacw4DTMCGnMHDsmEkOo3JIXbFinbh9+wGrpwuIpcP69RuVLv1YQsIlK2EAETE36xQG5P+OHbsGB3eXilmCgRoGdu06cu+9965ataFcucfVx3733S/PPFNFuR63c+eeXbv2Vqa7hoE1a7bIiWDLlj3qYyU5KMOEchQGPvlkktxlvaUwoFq1arVJk2Z4+X0mDAB4DcJA6uOPV/zxx9+UtscwIA05lEdGjnScJ4swoNb0hQo9vH37fqfFuZUwgIjotzoew5UwIBX/HXfcIcW9tNUwINaq9VqxYo+qg06Vo7oECeUj/2+/Xfbkk09LaX76tEXmdAoD1swvIB49erxyxvnii2/y5s2rhAEJJMo31VZ7GHjlldfPnLHK2eTddxtOnz5XJr7zTn2p+83mFOlTDQOOj3JS/cWkxMTLkn9Wr97s5feZMADgNQgDqWPHTpSD7/DhH1uzFwbkUP7EE0+VLVu+evUaQ4YMt9rDwL333qv8IKm4du1fahiQ00P58hVefPHl9u07uy7OVelKwoYcqeUk0bfvIJ+/OYiI6KjjMVwJA1b7R/t//33QenMYmDnzy7vvvlsdYFO1arVnn31O/ZQ9Lu58ixZtpMSvVOnJ4ODurmHA/tOib8rppnbttxx/WvSff07IPKVKlZZHyflCCQO//vpHiRIllS8BJAzIgurVayBnn5o1a0nYkIkLF/4gyypduoxEAjUMOD7KyV27jjzySDHJEhUqVJLM4P33mTAA4DUIAzbPnLHGx1/I0UOOHTMpw348Kj07/dGWW1gcIiL6idk8hn/22cwmTZo7TjlxIkmpwlWVSl0dJuTqyZPJrn90zGK5Js/Bac6kpCvSv9VhmJDTH8qU5+z6o0Dqo1yV+bdt2+f93xFSJAwAeA3CgM9s27ZT5cpVVeWmz58SIiJqZcWKTyxfvjo7c2YRBm5Bx2sGsqkfno8IAwBegzCAiIiI/iVhAMBrEAYQERHRvyQMAHgNwgAiIiL6l4QBAK9BGEBERET/kjAA4DUIA4iIiOhfEgYAvAZhABEREf1LwgCA1yAMICIion9JGADwGoQBRERE9C8JAwBegzCAiIiI/iVhAMBrEAYQERHRvyQMAHgNwgAiIiL6l4QBAK9BGEBERET/kjAA4DUIA4iIiOhfEgYAvAZhABEREf1LwgCA1/BGGLBYfH9YQURExFyhlA2EAQCvoXsY2H/ysinpms+PLIiIiJgrNCWm7D9xWe/6BAAUdA8Dp+Kv7jtxxedHFkRERMwV7jxySYoHvesTAFDQPQykpqbtOXZZdmxT0jXGCyEiIqJbpUiQUmHfiStSNly/rnd5AgDp6B4GBNmlJeLvP2mLBIiIiIhulVJBCobUVC/UJgCQTpCg9wLon/7pn/7pn/7pn/7pn/7p3w/798Y3AwAAAAAA4IcQBgAAAAAAAhTCAAAAAABAgEIYAAAAAAAIUAgDAAAAAAABCmEAAAAAACBAIQwAAAAAAAQo/w9xFe+GTmpf6AAAAABJRU5ErkJggg==">
  <context confirmationNeeded="false" name="Default"/>
  <parameters>
    <elementParameter field="TEXT" name="JOB_RUN_VM_ARGUMENTS" value=" -Xms256M -Xmx1024M"/>
    <elementParameter field="CHECK" name="JOB_RUN_VM_ARGUMENTS_OPTION" value="false"/>
    <elementParameter field="TEXT" name="SCREEN_OFFSET_X" value="0"/>
    <elementParameter field="TEXT" name="SCREEN_OFFSET_Y" value="0"/>
    <elementParameter field="TEXT" name="SCHEMA_OPTIONS" value="none"/>
    <elementParameter field="TEXT" name="OEM_CUSTOM_ATTRIBUTE" value=""/>
    <elementParameter field="TEXT" name="HADOOP_APP_PATH" value=""/>
    <elementParameter field="TEXT" name="JOBID_FOR_OOZIE" value=""/>
    <elementParameter field="TEXT" name="REPOSITORY_CONNECTION_ID" value=""/>
    <elementParameter field="TABLE" name="HADOOP_ADVANCED_PROPERTIES"/>
    <elementParameter field="CHECK" name="IMPLICITCONTEXT_USE_PROJECT_SETTINGS" value="true"/>
    <elementParameter field="CHECK" name="STATANDLOG_USE_PROJECT_SETTINGS" value="true"/>
    <elementParameter field="CHECK" name="MULTI_THREAD_EXECATION" value="false"/>
    <elementParameter field="FILE" name="IMPLICIT_TCONTEXTLOAD_FILE" value="&quot;&quot;"/>
    <elementParameter field="TEXT" name="FIELDSEPARATOR" value="&quot;&quot;"/>
    <elementParameter field="CLOSED_LIST" name="DB_VERSION_IMPLICIT_CONTEXT" value=""/>
    <elementParameter field="CHECK" name="DISABLE_WARNINGS" value="false"/>
    <elementParameter field="CHECK" name="DISABLE_INFO" value="false"/>
    <elementParameter field="TECHNICAL" name="ENCODING:ENCODING_TYPE" value="ISO-8859-15"/>
    <elementParameter field="CLOSED_LIST" name="DB_VERSION" value="ORACLE_10"/>
    <routinesParameter id="_8bvCUEYyEeOd6b-xkgEtPw" name="DataOperation"/>
    <routinesParameter id="_8cEZgEYyEeOd6b-xkgEtPw" name="Mathematical"/>
    <routinesParameter id="_8cHc0EYyEeOd6b-xkgEtPw" name="Numeric"/>
    <routinesParameter id="_8cKgIEYyEeOd6b-xkgEtPw" name="Relational"/>
    <routinesParameter id="_8cOKgEYyEeOd6b-xkgEtPw" name="StringHandling"/>
    <routinesParameter id="_8cRN0EYyEeOd6b-xkgEtPw" name="TalendDataGenerator"/>
    <routinesParameter id="_8cURIEYyEeOd6b-xkgEtPw" name="TalendDate"/>
    <routinesParameter id="_8cXUcEYyEeOd6b-xkgEtPw" name="TalendString"/>
  </parameters>
  <node componentName="tFileList" componentVersion="0.102" offsetLabelX="0" offsetLabelY="0" posX="96" posY="256">
    <elementParameter field="TEXT" name="UNIQUE_NAME" value="tFileList_1"/>
    <elementParameter field="CHECK" name="START" value="true"/>
    <elementParameter field="DIRECTORY" name="DIRECTORY" value="&quot;/Users/achan/HFA/HFA Historic Data/tmp&quot;"/>
    <elementParameter field="CLOSED_LIST" name="LIST_MODE" value="FILES"/>
    <elementParameter field="CHECK" name="INCLUDSUBDIR" value="false"/>
    <elementParameter field="CLOSED_LIST" name="CASE_SENSITIVE" value="YES"/>
    <elementParameter field="CHECK" name="ERROR" value="true"/>
    <elementParameter field="CHECK" name="GLOBEXPRESSIONS" value="true"/>
    <elementParameter field="TABLE" name="FILES"/>
    <elementParameter field="RADIO" name="ORDER_BY_NOTHING" value="true"/>
    <elementParameter field="RADIO" name="ORDER_BY_FILENAME" value="false"/>
    <elementParameter field="RADIO" name="ORDER_BY_FILESIZE" value="false"/>
    <elementParameter field="RADIO" name="ORDER_BY_MODIFIEDDATE" value="false"/>
    <elementParameter field="RADIO" name="ORDER_ACTION_ASC" value="true"/>
    <elementParameter field="RADIO" name="ORDER_ACTION_DESC" value="false"/>
    <elementParameter field="CHECK" name="IFEXCLUDE" value="false"/>
    <elementParameter field="TEXT" name="EXCLUDEFILEMASK" value="&quot;*.txt&quot;"/>
    <elementParameter field="CHECK" name="FORMAT_FILEPATH_TO_SLASH" value="false"/>
    <elementParameter field="TEXT" name="CONNECTION_FORMAT" value="row"/>
    <elementParameter field="CHECK" name="INFORMATION" value="false"/>
    <elementParameter field="MEMO" name="COMMENT" value=""/>
    <elementParameter field="CHECK" name="VALIDATION_RULES" value="false"/>
  </node>
  <node componentName="tFileInputDelimited" componentVersion="0.102" offsetLabelX="0" offsetLabelY="0" posX="96" posY="64">
    <elementParameter field="TEXT" name="UNIQUE_NAME" value="tFileInputDelimited_2"/>
    <elementParameter field="CHECK" name="SUBTREE_START" value="false"/>
    <elementParameter field="CHECK" name="END_OF_FLOW" value="false"/>
    <elementParameter field="LABEL" name="FILENAMETEXT" value="&quot;When the input source is a stream or a zip file,footer and random shouldn't be bigger than 0.&quot;"/>
    <elementParameter field="FILE" name="FILENAME" value="(String) globalMap.get(&quot;tFileList_1_CURRENT_FILEPATH&quot;)"/>
    <elementParameter field="TEXT" name="ROWSEPARATOR" value="&quot;\n&quot;"/>
    <elementParameter field="OPENED_LIST" name="CSVROWSEPARATOR" value="&quot;\n&quot;"/>
    <elementParameter field="TEXT" name="FIELDSEPARATOR" value="&quot;\t&quot;"/>
    <elementParameter field="CHECK" name="CSV_OPTION" value="false"/>
    <elementParameter field="TEXT" name="ESCAPE_CHAR" value="&quot;&quot;&quot;"/>
    <elementParameter field="TEXT" name="TEXT_ENCLOSURE" value="&quot;&quot;&quot;"/>
    <elementParameter field="TEXT" name="HEADER" value="0"/>
    <elementParameter field="TEXT" name="FOOTER" value="0"/>
    <elementParameter field="TEXT" name="LIMIT" value=""/>
    <elementParameter field="CHECK" name="REMOVE_EMPTY_ROW" value="false"/>
    <elementParameter field="CHECK" name="UNCOMPRESS" value="false"/>
    <elementParameter field="CHECK" name="DIE_ON_ERROR" value="false"/>
    <elementParameter field="TECHNICAL" name="SCHEMA_REJECT:SCHEMA_TYPE" value="REPOSITORY"/>
    <elementParameter field="TECHNICAL" name="SCHEMA_REJECT:REPOSITORY_SCHEMA_TYPE" value="_9Bvb8EY-EeOd6b-xkgEtPw - hfa_response_data"/>
    <elementParameter field="DIRECTORY" name="TEMP_DIR" value="&quot;/Users/achan/Downloads/TOS_DI-r110020-V5.4.0/workspace&quot;"/>
    <elementParameter field="CHECK" name="ADVANCED_SEPARATOR" value="false"/>
    <elementParameter field="TEXT" name="THOUSANDS_SEPARATOR" value="&quot;,&quot;"/>
    <elementParameter field="TEXT" name="DECIMAL_SEPARATOR" value="&quot;.&quot;"/>
    <elementParameter field="CHECK" name="RANDOM" value="false"/>
    <elementParameter field="TEXT" name="NB_RANDOM" value="10"/>
    <elementParameter field="CHECK" name="TRIMALL" value="false"/>
    <elementParameter field="TABLE" name="TRIMSELECT">
      <elementValue elementRef="SCHEMA_COLUMN" value="hfa_agreement_code"/>
      <elementValue elementRef="TRIM" value="false"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="manufacturer_number"/>
      <elementValue elementRef="TRIM" value="false"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="transaction_date"/>
      <elementValue elementRef="TRIM" value="false"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="manufacturer_request_number"/>
      <elementValue elementRef="TRIM" value="false"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="label_name"/>
      <elementValue elementRef="TRIM" value="false"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="isrc_code"/>
      <elementValue elementRef="TRIM" value="false"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="playing_time_minutes"/>
      <elementValue elementRef="TRIM" value="false"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="playing_time_seconds"/>
      <elementValue elementRef="TRIM" value="false"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="artist"/>
      <elementValue elementRef="TRIM" value="false"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="song_title"/>
      <elementValue elementRef="TRIM" value="false"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="aka_song_title"/>
      <elementValue elementRef="TRIM" value="false"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="iswc_code"/>
      <elementValue elementRef="TRIM" value="false"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="hfa_song_code"/>
      <elementValue elementRef="TRIM" value="false"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="composers"/>
      <elementValue elementRef="TRIM" value="false"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="publisher_name"/>
      <elementValue elementRef="TRIM" value="false"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="hfa_publisher_number"/>
      <elementValue elementRef="TRIM" value="false"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="exact_per_publisher_share"/>
      <elementValue elementRef="TRIM" value="false"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="catalog_number"/>
      <elementValue elementRef="TRIM" value="false"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="album_title"/>
      <elementValue elementRef="TRIM" value="false"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="upc_code"/>
      <elementValue elementRef="TRIM" value="false"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="configuration_codes"/>
      <elementValue elementRef="TRIM" value="false"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="license_type"/>
      <elementValue elementRef="TRIM" value="false"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="server_fixation_date"/>
      <elementValue elementRef="TRIM" value="false"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="rate_code"/>
      <elementValue elementRef="TRIM" value="false"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="hfa_output_1"/>
      <elementValue elementRef="TRIM" value="false"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="hfa_output_2"/>
      <elementValue elementRef="TRIM" value="false"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="hfa_output_3"/>
      <elementValue elementRef="TRIM" value="false"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="hfa_license_number_direct_deal_reference_id"/>
      <elementValue elementRef="TRIM" value="false"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="hfa_request_process_code_1"/>
      <elementValue elementRef="TRIM" value="false"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="hfa_request_process_code_2"/>
      <elementValue elementRef="TRIM" value="false"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="hfa_request_process_code_3"/>
      <elementValue elementRef="TRIM" value="false"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="hfa_request_process_code_4"/>
      <elementValue elementRef="TRIM" value="false"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="licensed_status_code"/>
      <elementValue elementRef="TRIM" value="false"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="hfa_output_field"/>
      <elementValue elementRef="TRIM" value="false"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="publisher_status"/>
      <elementValue elementRef="TRIM" value="false"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="total_hfa_licensed_share"/>
      <elementValue elementRef="TRIM" value="false"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="user_defined_1"/>
      <elementValue elementRef="TRIM" value="false"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="user_defined_2_track_id"/>
      <elementValue elementRef="TRIM" value="false"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="user_defined_3"/>
      <elementValue elementRef="TRIM" value="false"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="user_defined_4_distribution_date"/>
      <elementValue elementRef="TRIM" value="false"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="user_defined_5"/>
      <elementValue elementRef="TRIM" value="false"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="user_defined_6"/>
      <elementValue elementRef="TRIM" value="false"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="user_defined_7_tr_code"/>
      <elementValue elementRef="TRIM" value="false"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="user_defined_8_priority_code"/>
      <elementValue elementRef="TRIM" value="false"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="user_defined_9_pid"/>
      <elementValue elementRef="TRIM" value="false"/>
    </elementParameter>
    <elementParameter field="CHECK" name="CHECK_FIELDS_NUM" value="false"/>
    <elementParameter field="CHECK" name="CHECK_DATE" value="false"/>
    <elementParameter field="ENCODING_TYPE" name="ENCODING" value="&quot;UTF-8&quot;"/>
    <elementParameter field="TECHNICAL" name="ENCODING:ENCODING_TYPE" value="UTF-8"/>
    <elementParameter field="CHECK" name="SPLITRECORD" value="false"/>
    <elementParameter field="TEXT" name="DESTINATION" value=""/>
    <elementParameter field="TEXT" name="SCHEMA_OPT_NUM" value="100"/>
    <elementParameter field="TEXT" name="LABEL" value="hfa_response_data"/>
    <elementParameter field="TEXT" name="CONNECTION_FORMAT" value="row"/>
    <elementParameter field="CHECK" name="INFORMATION" value="false"/>
    <elementParameter field="MEMO" name="COMMENT" value=""/>
    <elementParameter field="CHECK" name="VALIDATION_RULES" value="false"/>
    <metadata connector="FLOW" label="hfa_response_data_1" name="tFileInputDelimited_2">
      <column comment="" key="false" length="3" name="hfa_agreement_code" nullable="true" pattern="&quot;dd-MM-yyyy&quot;" precision="0" type="id_String" originalLength="3" usefulColumn="true"/>
      <column comment="" key="false" length="6" name="manufacturer_number" nullable="true" pattern="&quot;dd-MM-yyyy&quot;" precision="0" type="id_String" usefulColumn="true"/>
      <column comment="" key="false" length="8" name="transaction_date" nullable="true" pattern="&quot;dd-MM-yyyy&quot;" precision="0" type="id_Integer" usefulColumn="true"/>
      <column comment="" key="false" length="8" name="manufacturer_request_number" nullable="true" pattern="&quot;dd-MM-yyyy&quot;" precision="0" type="id_Integer" originalLength="8" usefulColumn="true"/>
      <column comment="" key="false" length="60" name="label_name" nullable="true" pattern="&quot;dd-MM-yyyy&quot;" precision="0" type="id_String" originalLength="60" usefulColumn="true"/>
      <column comment="" key="false" length="15" name="isrc_code" nullable="true" pattern="&quot;dd-MM-yyyy&quot;" precision="0" type="id_String" originalLength="15" usefulColumn="true"/>
      <column comment="" key="false" length="1" name="playing_time_minutes" nullable="true" pattern="&quot;dd-MM-yyyy&quot;" precision="0" type="id_Integer" usefulColumn="true"/>
      <column comment="" key="false" length="2" name="playing_time_seconds" nullable="true" pattern="&quot;dd-MM-yyyy&quot;" precision="0" type="id_Integer" usefulColumn="true"/>
      <column comment="" key="false" length="32" name="artist" nullable="true" pattern="&quot;dd-MM-yyyy&quot;" precision="0" type="id_String" usefulColumn="true"/>
      <column comment="" key="false" length="31" name="song_title" nullable="true" pattern="&quot;dd-MM-yyyy&quot;" precision="0" type="id_String" usefulColumn="true"/>
      <column comment="" key="false" length="0" name="aka_song_title" nullable="true" pattern="&quot;dd-MM-yyyy&quot;" precision="0" type="id_String" usefulColumn="true"/>
      <column comment="" key="false" length="0" name="iswc_code" nullable="true" pattern="&quot;dd-MM-yyyy&quot;" precision="0" type="id_String" usefulColumn="true"/>
      <column comment="" key="false" length="6" name="hfa_song_code" nullable="true" pattern="&quot;dd-MM-yyyy&quot;" precision="0" type="id_String" usefulColumn="true"/>
      <column comment="" key="false" length="56" name="composers" nullable="true" pattern="&quot;dd-MM-yyyy&quot;" precision="0" type="id_String" usefulColumn="true"/>
      <column comment="" key="false" length="0" name="publisher_name" nullable="true" pattern="&quot;dd-MM-yyyy&quot;" precision="0" type="id_String" usefulColumn="true"/>
      <column comment="" key="false" length="0" name="hfa_publisher_number" nullable="true" pattern="&quot;dd-MM-yyyy&quot;" precision="0" type="id_String" usefulColumn="true"/>
      <column comment="" key="false" length="7" name="exact_per_publisher_share" nullable="true" pattern="&quot;dd-MM-yyyy&quot;" precision="4" type="id_Float" originalLength="7" usefulColumn="true"/>
      <column comment="" key="false" length="15" name="catalog_number" nullable="true" pattern="&quot;dd-MM-yyyy&quot;" precision="0" type="id_String" originalLength="15" usefulColumn="true"/>
      <column comment="" key="false" length="200" name="album_title" nullable="true" pattern="&quot;dd-MM-yyyy&quot;" precision="0" type="id_String" originalLength="200" usefulColumn="true"/>
      <column comment="" key="false" length="16" name="upc_code" nullable="true" pattern="&quot;dd-MM-yyyy&quot;" precision="0" type="id_String" originalLength="16" usefulColumn="true"/>
      <column comment="" key="false" length="2" name="configuration_codes" nullable="true" pattern="&quot;dd-MM-yyyy&quot;" precision="0" type="id_String" usefulColumn="true"/>
      <column comment="" key="false" length="1" name="license_type" nullable="true" pattern="&quot;dd-MM-yyyy&quot;" precision="0" type="id_String" usefulColumn="true"/>
      <column comment="" key="false" length="8" name="server_fixation_date" nullable="true" pattern="&quot;dd-MM-yyyy&quot;" precision="0" type="id_Integer" usefulColumn="true"/>
      <column comment="" key="false" length="1" name="rate_code" nullable="true" pattern="&quot;dd-MM-yyyy&quot;" precision="0" type="id_String" usefulColumn="true"/>
      <column comment="" key="false" length="12" name="hfa_output_1" nullable="true" pattern="&quot;dd-MM-yyyy&quot;" precision="7" type="id_Float" originalLength="12" usefulColumn="true"/>
      <column comment="" key="false" length="5" name="hfa_output_2" nullable="true" pattern="&quot;dd-MM-yyyy&quot;" precision="2" type="id_Float" originalLength="5" usefulColumn="true"/>
      <column comment="" key="false" length="5" name="hfa_output_3" nullable="true" pattern="&quot;dd-MM-yyyy&quot;" precision="2" type="id_Float" originalLength="5" usefulColumn="true"/>
      <column comment="" key="false" length="10" name="hfa_license_number_direct_deal_reference_id" nullable="true" pattern="&quot;dd-MM-yyyy&quot;" precision="0" type="id_Integer" originalLength="10" usefulColumn="true"/>
      <column comment="" key="false" length="2" name="hfa_request_process_code_1" nullable="true" pattern="&quot;dd-MM-yyyy&quot;" precision="0" type="id_String" usefulColumn="true"/>
      <column comment="" key="false" length="2" name="hfa_request_process_code_2" nullable="true" pattern="&quot;dd-MM-yyyy&quot;" precision="0" type="id_String" originalLength="2" usefulColumn="true"/>
      <column comment="" key="false" length="2" name="hfa_request_process_code_3" nullable="true" pattern="&quot;dd-MM-yyyy&quot;" precision="0" type="id_String" originalLength="2" usefulColumn="true"/>
      <column comment="" key="false" length="2" name="hfa_request_process_code_4" nullable="true" pattern="&quot;dd-MM-yyyy&quot;" precision="0" type="id_String" originalLength="2" usefulColumn="true"/>
      <column comment="" key="false" length="2" name="licensed_status_code" nullable="true" pattern="&quot;dd-MM-yyyy&quot;" precision="0" type="id_String" originalLength="2" usefulColumn="true"/>
      <column comment="" key="false" length="1" name="hfa_output_field" nullable="true" pattern="&quot;dd-MM-yyyy&quot;" precision="0" type="id_String" usefulColumn="true"/>
      <column comment="" key="false" length="0" name="publisher_status" nullable="true" pattern="&quot;dd-MM-yyyy&quot;" precision="0" type="id_String" usefulColumn="true"/>
      <column comment="" key="false" length="7" name="total_hfa_licensed_share" nullable="true" pattern="&quot;dd-MM-yyyy&quot;" precision="4" type="id_Float" originalLength="7" usefulColumn="true"/>
      <column comment="" key="false" length="200" name="user_defined_1" nullable="true" pattern="&quot;dd-MM-yyyy&quot;" precision="0" type="id_String" originalLength="200" usefulColumn="true"/>
      <column comment="" key="false" length="0" name="user_defined_2_track_id" nullable="true" pattern="&quot;dd-MM-yyyy&quot;" precision="0" type="id_String" usefulColumn="true"/>
      <column comment="" key="false" length="0" name="user_defined_3" nullable="true" pattern="&quot;dd-MM-yyyy&quot;" precision="0" type="id_String" usefulColumn="true"/>
      <column comment="" key="false" length="0" name="user_defined_4_distribution_date" nullable="true" pattern="&quot;dd-MM-yyyy&quot;" precision="0" type="id_String" usefulColumn="true"/>
      <column comment="" key="false" length="0" name="user_defined_5" nullable="true" pattern="&quot;dd-MM-yyyy&quot;" precision="0" type="id_String" usefulColumn="true"/>
      <column comment="" key="false" length="0" name="user_defined_6" nullable="true" pattern="&quot;dd-MM-yyyy&quot;" precision="0" type="id_String" usefulColumn="true"/>
      <column comment="" key="false" length="0" name="user_defined_7_tr_code" nullable="true" pattern="&quot;dd-MM-yyyy&quot;" precision="0" type="id_String" usefulColumn="true"/>
      <column comment="" key="false" length="0" name="user_defined_8_priority_code" nullable="true" pattern="&quot;dd-MM-yyyy&quot;" precision="0" type="id_String" usefulColumn="true"/>
      <column comment="" key="false" length="0" name="user_defined_9_pid" nullable="true" pattern="&quot;dd-MM-yyyy&quot;" precision="0" type="id_String" usefulColumn="true"/>
    </metadata>
    <metadata connector="REJECT" label="hfa_response_data_1" name="REJECT">
      <column comment="" key="false" length="3" name="hfa_agreement_code" nullable="true" pattern="&quot;dd-MM-yyyy&quot;" precision="0" type="id_String" originalLength="3" usefulColumn="true"/>
      <column comment="" defaultValue="" key="false" length="6" name="manufacturer_number" nullable="true" pattern="&quot;dd-MM-yyyy&quot;" precision="0" type="id_String" usefulColumn="true"/>
      <column comment="" key="false" length="8" name="transaction_date" nullable="true" pattern="&quot;dd-MM-yyyy&quot;" precision="0" type="id_Integer" usefulColumn="true"/>
      <column comment="" key="false" length="8" name="manufacturer_request_number" nullable="true" pattern="&quot;dd-MM-yyyy&quot;" precision="0" type="id_Integer" originalLength="8" usefulColumn="true"/>
      <column comment="" key="false" length="60" name="label_name" nullable="true" pattern="&quot;dd-MM-yyyy&quot;" precision="0" type="id_String" originalLength="60" usefulColumn="true"/>
      <column comment="" key="false" length="15" name="isrc_code" nullable="true" pattern="&quot;dd-MM-yyyy&quot;" precision="0" type="id_String" originalLength="15" usefulColumn="true"/>
      <column comment="" key="false" length="1" name="playing_time_minutes" nullable="true" pattern="&quot;dd-MM-yyyy&quot;" precision="0" type="id_Integer" usefulColumn="true"/>
      <column comment="" key="false" length="2" name="playing_time_seconds" nullable="true" pattern="&quot;dd-MM-yyyy&quot;" precision="0" type="id_Integer" usefulColumn="true"/>
      <column comment="" key="false" length="32" name="artist" nullable="true" pattern="&quot;dd-MM-yyyy&quot;" precision="0" type="id_String" usefulColumn="true"/>
      <column comment="" key="false" length="31" name="song_title" nullable="true" pattern="&quot;dd-MM-yyyy&quot;" precision="0" type="id_String" usefulColumn="true"/>
      <column comment="" key="false" length="0" name="aka_song_title" nullable="true" pattern="&quot;dd-MM-yyyy&quot;" precision="0" type="id_String" usefulColumn="true"/>
      <column comment="" key="false" length="0" name="iswc_code" nullable="true" pattern="&quot;dd-MM-yyyy&quot;" precision="0" type="id_String" usefulColumn="true"/>
      <column comment="" key="false" length="6" name="hfa_song_code" nullable="true" pattern="&quot;dd-MM-yyyy&quot;" precision="0" type="id_String" usefulColumn="true"/>
      <column comment="" key="false" length="56" name="composers" nullable="true" pattern="&quot;dd-MM-yyyy&quot;" precision="0" type="id_String" usefulColumn="true"/>
      <column comment="" key="false" length="0" name="publisher_name" nullable="true" pattern="&quot;dd-MM-yyyy&quot;" precision="0" type="id_String" usefulColumn="true"/>
      <column comment="" key="false" length="0" name="hfa_publisher_number" nullable="true" pattern="&quot;dd-MM-yyyy&quot;" precision="0" type="id_String" usefulColumn="true"/>
      <column comment="" key="false" length="7" name="exact_per_publisher_share" nullable="true" pattern="&quot;dd-MM-yyyy&quot;" precision="0" type="id_Integer" originalLength="7" usefulColumn="true"/>
      <column comment="" key="false" length="15" name="catalog_number" nullable="true" pattern="&quot;dd-MM-yyyy&quot;" precision="0" type="id_String" originalLength="15" usefulColumn="true"/>
      <column comment="" key="false" length="200" name="album_title" nullable="true" pattern="&quot;dd-MM-yyyy&quot;" precision="0" type="id_String" originalLength="200" usefulColumn="true"/>
      <column comment="" key="false" length="16" name="upc_code" nullable="true" pattern="&quot;dd-MM-yyyy&quot;" precision="0" type="id_String" originalLength="16" usefulColumn="true"/>
      <column comment="" key="false" length="2" name="configuration_codes" nullable="true" pattern="&quot;dd-MM-yyyy&quot;" precision="0" type="id_String" usefulColumn="true"/>
      <column comment="" key="false" length="1" name="license_type" nullable="true" pattern="&quot;dd-MM-yyyy&quot;" precision="0" type="id_String" usefulColumn="true"/>
      <column comment="" key="false" length="8" name="server_fixation_date" nullable="true" pattern="&quot;dd-MM-yyyy&quot;" precision="0" type="id_Integer" usefulColumn="true"/>
      <column comment="" key="false" length="1" name="rate_code" nullable="true" pattern="&quot;dd-MM-yyyy&quot;" precision="0" type="id_String" usefulColumn="true"/>
      <column comment="" key="false" length="12" name="hfa_output_1" nullable="true" pattern="&quot;dd-MM-yyyy&quot;" precision="7" type="id_Float" originalLength="12" usefulColumn="true"/>
      <column comment="" key="false" length="5" name="hfa_output_2" nullable="true" pattern="&quot;dd-MM-yyyy&quot;" precision="2" type="id_Float" originalLength="5" usefulColumn="true"/>
      <column comment="" key="false" length="5" name="hfa_output_3" nullable="true" pattern="&quot;dd-MM-yyyy&quot;" precision="2" type="id_Float" originalLength="5" usefulColumn="true"/>
      <column comment="" key="false" length="10" name="hfa_license_number_direct_deal_reference_id" nullable="true" pattern="&quot;dd-MM-yyyy&quot;" precision="0" type="id_Integer" originalLength="10" usefulColumn="true"/>
      <column comment="" key="false" length="2" name="hfa_request_process_code_1" nullable="true" pattern="&quot;dd-MM-yyyy&quot;" precision="0" type="id_String" usefulColumn="true"/>
      <column comment="" key="false" length="2" name="hfa_request_process_code_2" nullable="true" pattern="&quot;dd-MM-yyyy&quot;" precision="0" type="id_String" originalLength="2" usefulColumn="true"/>
      <column comment="" key="false" length="2" name="hfa_request_process_code_3" nullable="true" pattern="&quot;dd-MM-yyyy&quot;" precision="0" type="id_String" originalLength="2" usefulColumn="true"/>
      <column comment="" key="false" length="2" name="hfa_request_process_code_4" nullable="true" pattern="&quot;dd-MM-yyyy&quot;" precision="0" type="id_String" originalLength="2" usefulColumn="true"/>
      <column comment="" key="false" length="2" name="licensed_status_code" nullable="true" pattern="&quot;dd-MM-yyyy&quot;" precision="0" type="id_String" originalLength="2" usefulColumn="true"/>
      <column comment="" key="false" length="1" name="hfa_output_field" nullable="true" pattern="&quot;dd-MM-yyyy&quot;" precision="0" type="id_String" usefulColumn="true"/>
      <column comment="" key="false" length="0" name="publisher_status" nullable="true" pattern="&quot;dd-MM-yyyy&quot;" precision="0" type="id_String" usefulColumn="true"/>
      <column comment="" key="false" length="7" name="total_hfa_licensed_share" nullable="true" pattern="&quot;dd-MM-yyyy&quot;" precision="4" type="id_Float" originalLength="7" usefulColumn="true"/>
      <column comment="" key="false" length="200" name="user_defined_1" nullable="true" pattern="&quot;dd-MM-yyyy&quot;" precision="0" type="id_String" originalLength="200" usefulColumn="true"/>
      <column comment="" key="false" length="0" name="user_defined_2_track_id" nullable="true" pattern="&quot;dd-MM-yyyy&quot;" precision="0" type="id_String" usefulColumn="true"/>
      <column comment="" key="false" length="0" name="user_defined_3" nullable="true" pattern="&quot;dd-MM-yyyy&quot;" precision="0" type="id_String" usefulColumn="true"/>
      <column comment="" key="false" length="0" name="user_defined_4_distribution_date" nullable="true" pattern="&quot;dd-MM-yyyy&quot;" precision="0" type="id_String" usefulColumn="true"/>
      <column comment="" key="false" length="0" name="user_defined_5" nullable="true" pattern="&quot;dd-MM-yyyy&quot;" precision="0" type="id_String" usefulColumn="true"/>
      <column comment="" key="false" length="0" name="user_defined_6" nullable="true" pattern="&quot;dd-MM-yyyy&quot;" precision="0" type="id_String" usefulColumn="true"/>
      <column comment="" key="false" length="0" name="user_defined_7_tr_code" nullable="true" pattern="&quot;dd-MM-yyyy&quot;" precision="0" type="id_String" usefulColumn="true"/>
      <column comment="" key="false" length="0" name="user_defined_8_priority_code" nullable="true" pattern="&quot;dd-MM-yyyy&quot;" precision="0" type="id_String" usefulColumn="true"/>
      <column comment="" key="false" length="0" name="user_defined_9_pid" nullable="true" pattern="&quot;dd-MM-yyyy&quot;" precision="0" type="id_String" usefulColumn="true"/>
      <column defaultValue="" key="false" length="255" name="errorCode" nullable="true" precision="0" sourceType="" type="id_String" usefulColumn="true"/>
      <column defaultValue="" key="false" length="255" name="errorMessage" nullable="true" precision="0" sourceType="" type="id_String" usefulColumn="true"/>
    </metadata>
  </node>
  <node componentName="tMap" componentVersion="2.1" offsetLabelX="0" offsetLabelY="0" posX="352" posY="64">
    <elementParameter field="TEXT" name="UNIQUE_NAME" value="tMap_1"/>
    <elementParameter field="EXTERNAL" name="MAP" value=""/>
    <elementParameter field="CLOSED_LIST" name="LINK_STYLE" value="AUTO"/>
    <elementParameter field="DIRECTORY" name="TEMPORARY_DATA_DIRECTORY" value=""/>
    <elementParameter field="IMAGE" name="PREVIEW" value="_HudTwEYzEeOd6b-xkgEtPw-tMap_1-PREVIEW.bmp"/>
    <elementParameter field="CHECK" name="DIE_ON_ERROR" value="true"/>
    <elementParameter field="CHECK" name="LKUP_PARALLELIZE" value="false"/>
    <elementParameter field="TEXT" name="ROWS_BUFFER_SIZE" value="2000000"/>
    <elementParameter field="CHECK" name="CHANGE_HASH_AND_EQUALS_FOR_BIGDECIMAL" value="false"/>
    <elementParameter field="TEXT" name="CONNECTION_FORMAT" value="row"/>
    <elementParameter field="CHECK" name="INFORMATION" value="false"/>
    <elementParameter field="MEMO" name="COMMENT" value=""/>
    <elementParameter field="CHECK" name="VALIDATION_RULES" value="false"/>
    <metadata connector="FLOW" label="hfa_license_responses" name="main">
      <column comment="" key="true" length="10" name="response_id" nullable="false" pattern="" precision="0" sourceType="INT" type="id_Integer" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" defaultValue="CURRENT_TIMESTAMP" key="false" length="19" name="response_created_at" nullable="false" pattern="&quot;dd-MM-yyyy&quot;" precision="0" sourceType="TIMESTAMP" type="id_Date" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="19" name="response_modified_at" nullable="true" pattern="&quot;dd-MM-yyyy&quot;" precision="0" sourceType="DATETIME" type="id_Date" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="200" name="response_file_name" nullable="false" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="3" name="hfa_agreement_code" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="6" name="manufacturer_number" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="10" name="transaction_date" nullable="true" pattern="" precision="0" sourceType="INT" type="id_Integer" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="10" name="manufacturer_request_number" nullable="false" pattern="" precision="0" sourceType="INT" type="id_Integer" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="60" name="label_name" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="15" name="isrc_code" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="10" name="playing_time_minutes" nullable="true" pattern="" precision="0" sourceType="INT" type="id_Integer" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="10" name="playing_time_seconds" nullable="true" pattern="" precision="0" sourceType="INT" type="id_Integer" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="200" name="artist" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="200" name="song_title" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="200" name="aka_song_title" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="11" name="iswc_code" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="6" name="hfa_song_code" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="200" name="composers" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="60" name="publisher_name" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="6" name="hfa_publisher_number" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="7" name="exact_per_publisher_share" nullable="true" pattern="" precision="4" sourceType="DECIMAL" type="id_Float" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="15" name="catalog_number" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="200" name="album_title" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="16" name="upc_code" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="2" name="configuration_codes" nullable="false" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="1" name="license_type" nullable="true" pattern="" precision="0" sourceType="CHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="10" name="server_fixation_date" nullable="true" pattern="" precision="0" sourceType="INT" type="id_Integer" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="1" name="rate_code" nullable="true" pattern="" precision="0" sourceType="CHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="12" name="hfa_output_1" nullable="true" pattern="" precision="7" sourceType="DECIMAL" type="id_Float" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="5" name="hfa_output_2" nullable="true" pattern="" precision="2" sourceType="DECIMAL" type="id_Float" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="5" name="hfa_output_3" nullable="true" pattern="" precision="2" sourceType="DECIMAL" type="id_Float" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="10" name="hfa_license_number_direct_deal_reference_id" nullable="true" pattern="" precision="0" sourceType="INT" type="id_Integer" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="{Input:Use only to designate amended record that is being resubmitted - use code R in field} {Output:  Code designating reason why request was not licensable as submitted. Numerous options available, with options being added/revised as necessary. See Digi" key="false" length="2" name="hfa_request_process_code_1" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value="{Input:Use only to designate amended record that is being resubmitted - use code R in field} {Output:  Code designating reason why request was not licensable as submitted. Numerous options available, with options being added/revised as necessary. See Digi"/>
      </column>
      <column comment="" key="false" length="2" name="hfa_request_process_code_2" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="2" name="hfa_request_process_code_3" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="2" name="hfa_request_process_code_4" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="2" name="licensed_status_code" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="1" name="hfa_output_field" nullable="true" pattern="" precision="0" sourceType="CHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="1" name="publisher_status" nullable="true" pattern="" precision="0" sourceType="CHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="7" name="total_hfa_licensed_share" nullable="true" pattern="" precision="4" sourceType="DECIMAL" type="id_Float" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="200" name="user_defined_1" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="200" name="user_defined_2_track_id" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="200" name="user_defined_3_track_publisher_id" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="200" name="user_defined_4_distribution_date" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="200" name="user_defined_5" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="200" name="user_defined_6" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="2" name="user_defined_7_tr_code" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="18" name="user_defined_8_priority_code" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="20" name="user_defined_9_pid" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
    </metadata>
    <nodeData xsi:type="MapperData">
      <uiProperties/>
      <varTables sizeState="INTERMEDIATE" name="Var" minimized="true"/>
      <outputTables sizeState="INTERMEDIATE" name="main">
        <mapperTableEntries name="response_id" type="id_Integer"/>
        <mapperTableEntries name="response_created_at" expression="" type="id_Date"/>
        <mapperTableEntries name="response_modified_at" type="id_Date" nullable="true"/>
        <mapperTableEntries name="response_file_name" expression="(String) globalMap.get(&quot;tFileList_1_CURRENT_FILE&quot;)" type="id_String"/>
        <mapperTableEntries name="hfa_agreement_code" expression="row1.hfa_agreement_code" type="id_String" nullable="true"/>
        <mapperTableEntries name="manufacturer_number" expression="row1.manufacturer_number" type="id_String" nullable="true"/>
        <mapperTableEntries name="transaction_date" expression="row1.transaction_date" type="id_Integer" nullable="true"/>
        <mapperTableEntries name="manufacturer_request_number" expression="row1.manufacturer_request_number" type="id_Integer"/>
        <mapperTableEntries name="label_name" expression="row1.label_name" type="id_String" nullable="true"/>
        <mapperTableEntries name="isrc_code" expression="row1.isrc_code" type="id_String" nullable="true"/>
        <mapperTableEntries name="playing_time_minutes" expression="row1.playing_time_minutes" type="id_Integer" nullable="true"/>
        <mapperTableEntries name="playing_time_seconds" expression="row1.playing_time_seconds" type="id_Integer" nullable="true"/>
        <mapperTableEntries name="artist" expression="row1.artist" type="id_String" nullable="true"/>
        <mapperTableEntries name="song_title" expression="row1.song_title" type="id_String" nullable="true"/>
        <mapperTableEntries name="aka_song_title" expression="row1.aka_song_title" type="id_String" nullable="true"/>
        <mapperTableEntries name="iswc_code" expression="row1.iswc_code" type="id_String" nullable="true"/>
        <mapperTableEntries name="hfa_song_code" expression="row1.hfa_song_code" type="id_String" nullable="true"/>
        <mapperTableEntries name="composers" expression="row1.composers" type="id_String" nullable="true"/>
        <mapperTableEntries name="publisher_name" expression="row1.publisher_name" type="id_String" nullable="true"/>
        <mapperTableEntries name="hfa_publisher_number" expression="row1.hfa_publisher_number" type="id_String" nullable="true"/>
        <mapperTableEntries name="exact_per_publisher_share" expression="row1.exact_per_publisher_share" type="id_Float" nullable="true"/>
        <mapperTableEntries name="catalog_number" expression="row1.catalog_number" type="id_String" nullable="true"/>
        <mapperTableEntries name="album_title" expression="row1.album_title" type="id_String" nullable="true"/>
        <mapperTableEntries name="upc_code" expression="row1.upc_code" type="id_String" nullable="true"/>
        <mapperTableEntries name="configuration_codes" expression="row1.configuration_codes" type="id_String"/>
        <mapperTableEntries name="license_type" expression="row1.license_type" type="id_String" nullable="true"/>
        <mapperTableEntries name="server_fixation_date" expression="row1.server_fixation_date" type="id_Integer" nullable="true"/>
        <mapperTableEntries name="rate_code" expression="row1.rate_code" type="id_String" nullable="true"/>
        <mapperTableEntries name="hfa_output_1" expression="row1.hfa_output_1" type="id_Float" nullable="true"/>
        <mapperTableEntries name="hfa_output_2" expression="row1.hfa_output_2" type="id_Float" nullable="true"/>
        <mapperTableEntries name="hfa_output_3" expression="row1.hfa_output_3" type="id_Float" nullable="true"/>
        <mapperTableEntries name="hfa_license_number_direct_deal_reference_id" expression="row1.hfa_license_number_direct_deal_reference_id" type="id_Integer" nullable="true"/>
        <mapperTableEntries name="hfa_request_process_code_1" expression="row1.hfa_request_process_code_1" type="id_String" nullable="true"/>
        <mapperTableEntries name="hfa_request_process_code_2" expression="row1.hfa_request_process_code_2" type="id_String" nullable="true"/>
        <mapperTableEntries name="hfa_request_process_code_3" expression="row1.hfa_request_process_code_3" type="id_String" nullable="true"/>
        <mapperTableEntries name="hfa_request_process_code_4" expression="row1.hfa_request_process_code_4" type="id_String" nullable="true"/>
        <mapperTableEntries name="licensed_status_code" expression="row1.licensed_status_code" type="id_String" nullable="true"/>
        <mapperTableEntries name="hfa_output_field" expression="row1.hfa_output_field" type="id_String" nullable="true"/>
        <mapperTableEntries name="publisher_status" expression="row1.publisher_status" type="id_String" nullable="true"/>
        <mapperTableEntries name="total_hfa_licensed_share" expression="row1.total_hfa_licensed_share" type="id_Float" nullable="true"/>
        <mapperTableEntries name="user_defined_1" expression="row1.user_defined_1" type="id_String" nullable="true"/>
        <mapperTableEntries name="user_defined_2_track_id" expression="row1.user_defined_2_track_id" type="id_String" nullable="true"/>
        <mapperTableEntries name="user_defined_3_track_publisher_id" expression="row1.user_defined_3 " type="id_String" nullable="true"/>
        <mapperTableEntries name="user_defined_4_distribution_date" expression="row1.user_defined_4_distribution_date" type="id_String" nullable="true"/>
        <mapperTableEntries name="user_defined_5" expression="row1.user_defined_5" type="id_String" nullable="true"/>
        <mapperTableEntries name="user_defined_6" expression="row1.user_defined_6" type="id_String" nullable="true"/>
        <mapperTableEntries name="user_defined_7_tr_code" expression="row1.user_defined_7_tr_code" type="id_String" nullable="true"/>
        <mapperTableEntries name="user_defined_8_priority_code" expression="row1.user_defined_8_priority_code" type="id_String" nullable="true"/>
        <mapperTableEntries name="user_defined_9_pid" expression="row1.user_defined_9_pid" type="id_String" nullable="true"/>
      </outputTables>
      <inputTables sizeState="INTERMEDIATE" name="row1" matchingMode="UNIQUE_MATCH" lookupMode="LOAD_ONCE">
        <mapperTableEntries name="hfa_agreement_code" type="id_String" nullable="true"/>
        <mapperTableEntries name="manufacturer_number" type="id_String" nullable="true"/>
        <mapperTableEntries name="transaction_date" type="id_Integer" nullable="true"/>
        <mapperTableEntries name="manufacturer_request_number" type="id_Integer" nullable="true"/>
        <mapperTableEntries name="label_name" type="id_String" nullable="true"/>
        <mapperTableEntries name="isrc_code" type="id_String" nullable="true"/>
        <mapperTableEntries name="playing_time_minutes" type="id_Integer" nullable="true"/>
        <mapperTableEntries name="playing_time_seconds" type="id_Integer" nullable="true"/>
        <mapperTableEntries name="artist" type="id_String" nullable="true"/>
        <mapperTableEntries name="song_title" type="id_String" nullable="true"/>
        <mapperTableEntries name="aka_song_title" type="id_String" nullable="true"/>
        <mapperTableEntries name="iswc_code" type="id_String" nullable="true"/>
        <mapperTableEntries name="hfa_song_code" type="id_String" nullable="true"/>
        <mapperTableEntries name="composers" type="id_String" nullable="true"/>
        <mapperTableEntries name="publisher_name" type="id_String" nullable="true"/>
        <mapperTableEntries name="hfa_publisher_number" type="id_String" nullable="true"/>
        <mapperTableEntries name="exact_per_publisher_share" type="id_Float" nullable="true"/>
        <mapperTableEntries name="catalog_number" type="id_String" nullable="true"/>
        <mapperTableEntries name="album_title" type="id_String" nullable="true"/>
        <mapperTableEntries name="upc_code" type="id_String" nullable="true"/>
        <mapperTableEntries name="configuration_codes" type="id_String" nullable="true"/>
        <mapperTableEntries name="license_type" type="id_String" nullable="true"/>
        <mapperTableEntries name="server_fixation_date" type="id_Integer" nullable="true"/>
        <mapperTableEntries name="rate_code" type="id_String" nullable="true"/>
        <mapperTableEntries name="hfa_output_1" type="id_Float" nullable="true"/>
        <mapperTableEntries name="hfa_output_2" type="id_Float" nullable="true"/>
        <mapperTableEntries name="hfa_output_3" type="id_Float" nullable="true"/>
        <mapperTableEntries name="hfa_license_number_direct_deal_reference_id" type="id_Integer" nullable="true"/>
        <mapperTableEntries name="hfa_request_process_code_1" type="id_String" nullable="true"/>
        <mapperTableEntries name="hfa_request_process_code_2" type="id_String" nullable="true"/>
        <mapperTableEntries name="hfa_request_process_code_3" type="id_String" nullable="true"/>
        <mapperTableEntries name="hfa_request_process_code_4" type="id_String" nullable="true"/>
        <mapperTableEntries name="licensed_status_code" type="id_String" nullable="true"/>
        <mapperTableEntries name="hfa_output_field" type="id_String" nullable="true"/>
        <mapperTableEntries name="publisher_status" type="id_String" nullable="true"/>
        <mapperTableEntries name="total_hfa_licensed_share" type="id_Float" nullable="true"/>
        <mapperTableEntries name="user_defined_1" type="id_String" nullable="true"/>
        <mapperTableEntries name="user_defined_2_track_id" type="id_String" nullable="true"/>
        <mapperTableEntries name="user_defined_3" type="id_String" nullable="true"/>
        <mapperTableEntries name="user_defined_4_distribution_date" type="id_String" nullable="true"/>
        <mapperTableEntries name="user_defined_5" type="id_String" nullable="true"/>
        <mapperTableEntries name="user_defined_6" type="id_String" nullable="true"/>
        <mapperTableEntries name="user_defined_7_tr_code" type="id_String" nullable="true"/>
        <mapperTableEntries name="user_defined_8_priority_code" type="id_String" nullable="true"/>
        <mapperTableEntries name="user_defined_9_pid" type="id_String" nullable="true"/>
      </inputTables>
    </nodeData>
  </node>
  <node componentName="tMysqlOutput" componentVersion="0.102" offsetLabelX="0" offsetLabelY="0" posX="640" posY="64">
    <elementParameter field="TEXT" name="UNIQUE_NAME" value="tMysqlOutput_1"/>
    <elementParameter field="TECHNICAL" name="PROPERTY:PROPERTY_TYPE" value="REPOSITORY"/>
    <elementParameter field="TECHNICAL" name="PROPERTY:REPOSITORY_PROPERTY_TYPE" value="_tjz5EEZkEeOd6b-xkgEtPw"/>
    <elementParameter field="CLOSED_LIST" name="DB_VERSION" value="MYSQL_5"/>
    <elementParameter field="CHECK" name="USE_EXISTING_CONNECTION" value="false"/>
    <elementParameter field="COMPONENT_LIST" name="CONNECTION" value=""/>
    <elementParameter field="TEXT" name="TYPE" value="MYSQL"/>
    <elementParameter field="TEXT" name="HOST" value="&quot;192.168.31.138&quot;"/>
    <elementParameter field="TEXT" name="PORT" value="&quot;3306&quot;"/>
    <elementParameter field="TEXT" name="DBNAME" value="&quot;publishing&quot;"/>
    <elementParameter field="TEXT" name="USER" value="&quot;myron&quot;"/>
    <elementParameter field="TEXT" name="PASS" value="&quot;orchard&quot;"/>
    <elementParameter field="DBTABLE" name="TABLE" value="&quot;hfa_license_responses&quot;"/>
    <elementParameter field="CLOSED_LIST" name="TABLE_ACTION" value="NONE"/>
    <elementParameter field="CLOSED_LIST" name="DATA_ACTION" value="INSERT"/>
    <elementParameter field="TECHNICAL" name="SCHEMA_FLOW:SCHEMA_TYPE" value="REPOSITORY"/>
    <elementParameter field="TECHNICAL" name="SCHEMA_FLOW:REPOSITORY_SCHEMA_TYPE" value="_tjz5EEZkEeOd6b-xkgEtPw - hfa_license_responses"/>
    <elementParameter field="LABEL" name="NOTE" value="This option only applies when deploying and running in the Talend Runtime"/>
    <elementParameter field="CHECK" name="SPECIFY_DATASOURCE_ALIAS" value="false"/>
    <elementParameter field="TEXT" name="DATASOURCE_ALIAS" value="&quot;&quot;"/>
    <elementParameter field="CHECK" name="DIE_ON_ERROR" value="false"/>
    <elementParameter field="MAPPING_TYPE" name="MAPPING" value="mysql_id"/>
    <elementParameter field="TEXT" name="PROPERTIES" value="&quot;noDatetimeStringSync=true&quot;"/>
    <elementParameter field="CHECK" name="EXTENDINSERT" value="false"/>
    <elementParameter field="LABEL" name="NOTE" value="(Not compatible with reject links)"/>
    <elementParameter field="TEXT" name="NB_ROWS_PER_INSERT" value="100"/>
    <elementParameter field="CHECK" name="USE_BATCH_SIZE" value="true"/>
    <elementParameter field="TEXT" name="BATCH_SIZE" value="10000"/>
    <elementParameter field="ENCODING_TYPE" name="ENCODING" value="&quot;ISO-8859-15&quot;"/>
    <elementParameter field="TECHNICAL" name="ENCODING:ENCODING_TYPE" value="ISO-8859-15"/>
    <elementParameter field="TEXT" name="COMMIT_EVERY" value="10000"/>
    <elementParameter field="TABLE" name="ADD_COLS"/>
    <elementParameter field="CHECK" name="USE_FIELD_OPTIONS" value="false"/>
    <elementParameter field="TABLE" name="FIELD_OPTIONS">
      <elementValue elementRef="SCHEMA_COLUMN" value="response_id"/>
      <elementValue elementRef="UPDATE_KEY" value="false"/>
      <elementValue elementRef="DELETE_KEY" value="false"/>
      <elementValue elementRef="UPDATABLE" value="true"/>
      <elementValue elementRef="INSERTABLE" value="true"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="response_created_at"/>
      <elementValue elementRef="UPDATE_KEY" value="false"/>
      <elementValue elementRef="DELETE_KEY" value="false"/>
      <elementValue elementRef="UPDATABLE" value="true"/>
      <elementValue elementRef="INSERTABLE" value="true"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="response_modified_at"/>
      <elementValue elementRef="UPDATE_KEY" value="false"/>
      <elementValue elementRef="DELETE_KEY" value="false"/>
      <elementValue elementRef="UPDATABLE" value="true"/>
      <elementValue elementRef="INSERTABLE" value="true"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="response_file_name"/>
      <elementValue elementRef="UPDATE_KEY" value="false"/>
      <elementValue elementRef="DELETE_KEY" value="false"/>
      <elementValue elementRef="UPDATABLE" value="true"/>
      <elementValue elementRef="INSERTABLE" value="true"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="hfa_agreement_code"/>
      <elementValue elementRef="UPDATE_KEY" value="false"/>
      <elementValue elementRef="DELETE_KEY" value="false"/>
      <elementValue elementRef="UPDATABLE" value="true"/>
      <elementValue elementRef="INSERTABLE" value="true"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="manufacturer_number"/>
      <elementValue elementRef="UPDATE_KEY" value="false"/>
      <elementValue elementRef="DELETE_KEY" value="false"/>
      <elementValue elementRef="UPDATABLE" value="true"/>
      <elementValue elementRef="INSERTABLE" value="true"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="transaction_date"/>
      <elementValue elementRef="UPDATE_KEY" value="false"/>
      <elementValue elementRef="DELETE_KEY" value="false"/>
      <elementValue elementRef="UPDATABLE" value="true"/>
      <elementValue elementRef="INSERTABLE" value="true"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="manufacturer_request_number"/>
      <elementValue elementRef="UPDATE_KEY" value="false"/>
      <elementValue elementRef="DELETE_KEY" value="false"/>
      <elementValue elementRef="UPDATABLE" value="true"/>
      <elementValue elementRef="INSERTABLE" value="true"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="label_name"/>
      <elementValue elementRef="UPDATE_KEY" value="false"/>
      <elementValue elementRef="DELETE_KEY" value="false"/>
      <elementValue elementRef="UPDATABLE" value="true"/>
      <elementValue elementRef="INSERTABLE" value="true"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="isrc_code"/>
      <elementValue elementRef="UPDATE_KEY" value="false"/>
      <elementValue elementRef="DELETE_KEY" value="false"/>
      <elementValue elementRef="UPDATABLE" value="true"/>
      <elementValue elementRef="INSERTABLE" value="true"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="playing_time_minutes"/>
      <elementValue elementRef="UPDATE_KEY" value="false"/>
      <elementValue elementRef="DELETE_KEY" value="false"/>
      <elementValue elementRef="UPDATABLE" value="true"/>
      <elementValue elementRef="INSERTABLE" value="true"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="playing_time_seconds"/>
      <elementValue elementRef="UPDATE_KEY" value="false"/>
      <elementValue elementRef="DELETE_KEY" value="false"/>
      <elementValue elementRef="UPDATABLE" value="true"/>
      <elementValue elementRef="INSERTABLE" value="true"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="artist"/>
      <elementValue elementRef="UPDATE_KEY" value="false"/>
      <elementValue elementRef="DELETE_KEY" value="false"/>
      <elementValue elementRef="UPDATABLE" value="true"/>
      <elementValue elementRef="INSERTABLE" value="true"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="song_title"/>
      <elementValue elementRef="UPDATE_KEY" value="false"/>
      <elementValue elementRef="DELETE_KEY" value="false"/>
      <elementValue elementRef="UPDATABLE" value="true"/>
      <elementValue elementRef="INSERTABLE" value="true"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="aka_song_title"/>
      <elementValue elementRef="UPDATE_KEY" value="false"/>
      <elementValue elementRef="DELETE_KEY" value="false"/>
      <elementValue elementRef="UPDATABLE" value="true"/>
      <elementValue elementRef="INSERTABLE" value="true"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="iswc_code"/>
      <elementValue elementRef="UPDATE_KEY" value="false"/>
      <elementValue elementRef="DELETE_KEY" value="false"/>
      <elementValue elementRef="UPDATABLE" value="true"/>
      <elementValue elementRef="INSERTABLE" value="true"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="hfa_song_code"/>
      <elementValue elementRef="UPDATE_KEY" value="false"/>
      <elementValue elementRef="DELETE_KEY" value="false"/>
      <elementValue elementRef="UPDATABLE" value="true"/>
      <elementValue elementRef="INSERTABLE" value="true"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="composers"/>
      <elementValue elementRef="UPDATE_KEY" value="false"/>
      <elementValue elementRef="DELETE_KEY" value="false"/>
      <elementValue elementRef="UPDATABLE" value="true"/>
      <elementValue elementRef="INSERTABLE" value="true"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="publisher_name"/>
      <elementValue elementRef="UPDATE_KEY" value="false"/>
      <elementValue elementRef="DELETE_KEY" value="false"/>
      <elementValue elementRef="UPDATABLE" value="true"/>
      <elementValue elementRef="INSERTABLE" value="true"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="hfa_publisher_number"/>
      <elementValue elementRef="UPDATE_KEY" value="false"/>
      <elementValue elementRef="DELETE_KEY" value="false"/>
      <elementValue elementRef="UPDATABLE" value="true"/>
      <elementValue elementRef="INSERTABLE" value="true"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="exact_per_publisher_share"/>
      <elementValue elementRef="UPDATE_KEY" value="false"/>
      <elementValue elementRef="DELETE_KEY" value="false"/>
      <elementValue elementRef="UPDATABLE" value="true"/>
      <elementValue elementRef="INSERTABLE" value="true"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="catalog_number"/>
      <elementValue elementRef="UPDATE_KEY" value="false"/>
      <elementValue elementRef="DELETE_KEY" value="false"/>
      <elementValue elementRef="UPDATABLE" value="true"/>
      <elementValue elementRef="INSERTABLE" value="true"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="album_title"/>
      <elementValue elementRef="UPDATE_KEY" value="false"/>
      <elementValue elementRef="DELETE_KEY" value="false"/>
      <elementValue elementRef="UPDATABLE" value="true"/>
      <elementValue elementRef="INSERTABLE" value="true"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="upc_code"/>
      <elementValue elementRef="UPDATE_KEY" value="false"/>
      <elementValue elementRef="DELETE_KEY" value="false"/>
      <elementValue elementRef="UPDATABLE" value="true"/>
      <elementValue elementRef="INSERTABLE" value="true"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="configuration_codes"/>
      <elementValue elementRef="UPDATE_KEY" value="false"/>
      <elementValue elementRef="DELETE_KEY" value="false"/>
      <elementValue elementRef="UPDATABLE" value="true"/>
      <elementValue elementRef="INSERTABLE" value="true"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="license_type"/>
      <elementValue elementRef="UPDATE_KEY" value="false"/>
      <elementValue elementRef="DELETE_KEY" value="false"/>
      <elementValue elementRef="UPDATABLE" value="true"/>
      <elementValue elementRef="INSERTABLE" value="true"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="server_fixation_date"/>
      <elementValue elementRef="UPDATE_KEY" value="false"/>
      <elementValue elementRef="DELETE_KEY" value="false"/>
      <elementValue elementRef="UPDATABLE" value="true"/>
      <elementValue elementRef="INSERTABLE" value="true"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="rate_code"/>
      <elementValue elementRef="UPDATE_KEY" value="false"/>
      <elementValue elementRef="DELETE_KEY" value="false"/>
      <elementValue elementRef="UPDATABLE" value="true"/>
      <elementValue elementRef="INSERTABLE" value="true"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="hfa_output_1"/>
      <elementValue elementRef="UPDATE_KEY" value="false"/>
      <elementValue elementRef="DELETE_KEY" value="false"/>
      <elementValue elementRef="UPDATABLE" value="true"/>
      <elementValue elementRef="INSERTABLE" value="true"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="hfa_output_2"/>
      <elementValue elementRef="UPDATE_KEY" value="false"/>
      <elementValue elementRef="DELETE_KEY" value="false"/>
      <elementValue elementRef="UPDATABLE" value="true"/>
      <elementValue elementRef="INSERTABLE" value="true"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="hfa_output_3"/>
      <elementValue elementRef="UPDATE_KEY" value="false"/>
      <elementValue elementRef="DELETE_KEY" value="false"/>
      <elementValue elementRef="UPDATABLE" value="true"/>
      <elementValue elementRef="INSERTABLE" value="true"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="hfa_license_number_direct_deal_reference_id"/>
      <elementValue elementRef="UPDATE_KEY" value="false"/>
      <elementValue elementRef="DELETE_KEY" value="false"/>
      <elementValue elementRef="UPDATABLE" value="true"/>
      <elementValue elementRef="INSERTABLE" value="true"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="hfa_request_process_code_1"/>
      <elementValue elementRef="UPDATE_KEY" value="false"/>
      <elementValue elementRef="DELETE_KEY" value="false"/>
      <elementValue elementRef="UPDATABLE" value="true"/>
      <elementValue elementRef="INSERTABLE" value="true"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="hfa_request_process_code_2"/>
      <elementValue elementRef="UPDATE_KEY" value="false"/>
      <elementValue elementRef="DELETE_KEY" value="false"/>
      <elementValue elementRef="UPDATABLE" value="true"/>
      <elementValue elementRef="INSERTABLE" value="true"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="hfa_request_process_code_3"/>
      <elementValue elementRef="UPDATE_KEY" value="false"/>
      <elementValue elementRef="DELETE_KEY" value="false"/>
      <elementValue elementRef="UPDATABLE" value="true"/>
      <elementValue elementRef="INSERTABLE" value="true"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="hfa_request_process_code_4"/>
      <elementValue elementRef="UPDATE_KEY" value="false"/>
      <elementValue elementRef="DELETE_KEY" value="false"/>
      <elementValue elementRef="UPDATABLE" value="true"/>
      <elementValue elementRef="INSERTABLE" value="true"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="licensed_status_code"/>
      <elementValue elementRef="UPDATE_KEY" value="false"/>
      <elementValue elementRef="DELETE_KEY" value="false"/>
      <elementValue elementRef="UPDATABLE" value="true"/>
      <elementValue elementRef="INSERTABLE" value="true"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="hfa_output_field"/>
      <elementValue elementRef="UPDATE_KEY" value="false"/>
      <elementValue elementRef="DELETE_KEY" value="false"/>
      <elementValue elementRef="UPDATABLE" value="true"/>
      <elementValue elementRef="INSERTABLE" value="true"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="publisher_status"/>
      <elementValue elementRef="UPDATE_KEY" value="false"/>
      <elementValue elementRef="DELETE_KEY" value="false"/>
      <elementValue elementRef="UPDATABLE" value="true"/>
      <elementValue elementRef="INSERTABLE" value="true"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="total_hfa_licensed_share"/>
      <elementValue elementRef="UPDATE_KEY" value="false"/>
      <elementValue elementRef="DELETE_KEY" value="false"/>
      <elementValue elementRef="UPDATABLE" value="true"/>
      <elementValue elementRef="INSERTABLE" value="true"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="user_defined_1"/>
      <elementValue elementRef="UPDATE_KEY" value="false"/>
      <elementValue elementRef="DELETE_KEY" value="false"/>
      <elementValue elementRef="UPDATABLE" value="true"/>
      <elementValue elementRef="INSERTABLE" value="true"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="user_defined_2_track_id"/>
      <elementValue elementRef="UPDATE_KEY" value="false"/>
      <elementValue elementRef="DELETE_KEY" value="false"/>
      <elementValue elementRef="UPDATABLE" value="true"/>
      <elementValue elementRef="INSERTABLE" value="true"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="user_defined_3_track_publisher_id"/>
      <elementValue elementRef="UPDATE_KEY" value="false"/>
      <elementValue elementRef="DELETE_KEY" value="false"/>
      <elementValue elementRef="UPDATABLE" value="true"/>
      <elementValue elementRef="INSERTABLE" value="true"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="user_defined_4_distribution_date"/>
      <elementValue elementRef="UPDATE_KEY" value="false"/>
      <elementValue elementRef="DELETE_KEY" value="false"/>
      <elementValue elementRef="UPDATABLE" value="true"/>
      <elementValue elementRef="INSERTABLE" value="true"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="user_defined_5"/>
      <elementValue elementRef="UPDATE_KEY" value="false"/>
      <elementValue elementRef="DELETE_KEY" value="false"/>
      <elementValue elementRef="UPDATABLE" value="true"/>
      <elementValue elementRef="INSERTABLE" value="true"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="user_defined_6"/>
      <elementValue elementRef="UPDATE_KEY" value="false"/>
      <elementValue elementRef="DELETE_KEY" value="false"/>
      <elementValue elementRef="UPDATABLE" value="true"/>
      <elementValue elementRef="INSERTABLE" value="true"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="user_defined_7_tr_code"/>
      <elementValue elementRef="UPDATE_KEY" value="false"/>
      <elementValue elementRef="DELETE_KEY" value="false"/>
      <elementValue elementRef="UPDATABLE" value="true"/>
      <elementValue elementRef="INSERTABLE" value="true"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="user_defined_8_priority_code"/>
      <elementValue elementRef="UPDATE_KEY" value="false"/>
      <elementValue elementRef="DELETE_KEY" value="false"/>
      <elementValue elementRef="UPDATABLE" value="true"/>
      <elementValue elementRef="INSERTABLE" value="true"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="user_defined_9_pid"/>
      <elementValue elementRef="UPDATE_KEY" value="false"/>
      <elementValue elementRef="DELETE_KEY" value="false"/>
      <elementValue elementRef="UPDATABLE" value="true"/>
      <elementValue elementRef="INSERTABLE" value="true"/>
    </elementParameter>
    <elementParameter field="CHECK" name="USE_HINT_OPTIONS" value="false"/>
    <elementParameter field="TABLE" name="HINT_OPTIONS"/>
    <elementParameter field="CHECK" name="ENABLE_DEBUG_MODE" value="false"/>
    <elementParameter field="CHECK" name="ON_DUPLICATE_KEY_UPDATE" value="false"/>
    <elementParameter field="TABLE" name="DUPLICATED_KEYS"/>
    <elementParameter field="CHECK" name="SUPPORT_NULL_WHERE" value="false"/>
    <elementParameter field="TEXT" name="LABEL" value="__TABLE__"/>
    <elementParameter field="TEXT" name="CONNECTION_FORMAT" value="row"/>
    <elementParameter field="CHECK" name="INFORMATION" value="false"/>
    <elementParameter field="MEMO" name="COMMENT" value=""/>
    <elementParameter field="CHECK" name="VALIDATION_RULES" value="false"/>
    <metadata connector="FLOW" label="hfa_license_responses" name="tMysqlOutput_1">
      <column comment="" key="true" length="10" name="response_id" nullable="false" pattern="" precision="0" sourceType="INT" type="id_Integer" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" defaultValue="CURRENT_TIMESTAMP" key="false" length="19" name="response_created_at" nullable="false" pattern="&quot;dd-MM-yyyy&quot;" precision="0" sourceType="TIMESTAMP" type="id_Date" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="19" name="response_modified_at" nullable="true" pattern="&quot;dd-MM-yyyy&quot;" precision="0" sourceType="DATETIME" type="id_Date" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="200" name="response_file_name" nullable="false" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="3" name="hfa_agreement_code" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="6" name="manufacturer_number" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="10" name="transaction_date" nullable="true" pattern="" precision="0" sourceType="INT" type="id_Integer" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="10" name="manufacturer_request_number" nullable="false" pattern="" precision="0" sourceType="INT" type="id_Integer" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="60" name="label_name" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="15" name="isrc_code" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="10" name="playing_time_minutes" nullable="true" pattern="" precision="0" sourceType="INT" type="id_Integer" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="10" name="playing_time_seconds" nullable="true" pattern="" precision="0" sourceType="INT" type="id_Integer" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="200" name="artist" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="200" name="song_title" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="200" name="aka_song_title" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="11" name="iswc_code" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="6" name="hfa_song_code" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="200" name="composers" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="60" name="publisher_name" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="6" name="hfa_publisher_number" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="7" name="exact_per_publisher_share" nullable="true" pattern="" precision="4" sourceType="DECIMAL" type="id_Float" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="15" name="catalog_number" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="200" name="album_title" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="16" name="upc_code" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="2" name="configuration_codes" nullable="false" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="1" name="license_type" nullable="true" pattern="" precision="0" sourceType="CHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="10" name="server_fixation_date" nullable="true" pattern="" precision="0" sourceType="INT" type="id_Integer" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="1" name="rate_code" nullable="true" pattern="" precision="0" sourceType="CHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="12" name="hfa_output_1" nullable="true" pattern="" precision="7" sourceType="DECIMAL" type="id_Float" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="5" name="hfa_output_2" nullable="true" pattern="" precision="2" sourceType="DECIMAL" type="id_Float" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="5" name="hfa_output_3" nullable="true" pattern="" precision="2" sourceType="DECIMAL" type="id_Float" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="10" name="hfa_license_number_direct_deal_reference_id" nullable="true" pattern="" precision="0" sourceType="INT" type="id_Integer" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="{Input:Use only to designate amended record that is being resubmitted - use code R in field} {Output:  Code designating reason why request was not licensable as submitted. Numerous options available, with options being added/revised as necessary. See Digi" key="false" length="2" name="hfa_request_process_code_1" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value="{Input:Use only to designate amended record that is being resubmitted - use code R in field} {Output:  Code designating reason why request was not licensable as submitted. Numerous options available, with options being added/revised as necessary. See Digi"/>
      </column>
      <column comment="" key="false" length="2" name="hfa_request_process_code_2" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="2" name="hfa_request_process_code_3" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="2" name="hfa_request_process_code_4" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="2" name="licensed_status_code" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="1" name="hfa_output_field" nullable="true" pattern="" precision="0" sourceType="CHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="1" name="publisher_status" nullable="true" pattern="" precision="0" sourceType="CHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="7" name="total_hfa_licensed_share" nullable="true" pattern="" precision="4" sourceType="DECIMAL" type="id_Float" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="200" name="user_defined_1" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="200" name="user_defined_2_track_id" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="200" name="user_defined_3_track_publisher_id" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="200" name="user_defined_4_distribution_date" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="200" name="user_defined_5" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="200" name="user_defined_6" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="2" name="user_defined_7_tr_code" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="18" name="user_defined_8_priority_code" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="20" name="user_defined_9_pid" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
    </metadata>
    <metadata connector="REJECT" label="hfa_license_responses" name="REJECT">
      <column comment="" key="true" length="10" name="response_id" nullable="false" pattern="" precision="0" sourceType="INT" type="id_Integer" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" defaultValue="CURRENT_TIMESTAMP" key="false" length="19" name="response_created_at" nullable="false" pattern="&quot;dd-MM-yyyy&quot;" precision="0" sourceType="TIMESTAMP" type="id_Date" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="19" name="response_modified_at" nullable="true" pattern="&quot;dd-MM-yyyy&quot;" precision="0" sourceType="DATETIME" type="id_Date" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="200" name="response_file_name" nullable="false" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="3" name="hfa_agreement_code" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="6" name="manufacturer_number" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="10" name="transaction_date" nullable="true" pattern="" precision="0" sourceType="INT" type="id_Integer" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="10" name="manufacturer_request_number" nullable="false" pattern="" precision="0" sourceType="INT" type="id_Integer" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="60" name="label_name" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="15" name="isrc_code" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="10" name="playing_time_minutes" nullable="true" pattern="" precision="0" sourceType="INT" type="id_Integer" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="10" name="playing_time_seconds" nullable="true" pattern="" precision="0" sourceType="INT" type="id_Integer" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="200" name="artist" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="200" name="song_title" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="200" name="aka_song_title" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="11" name="iswc_code" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="6" name="hfa_song_code" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="200" name="composers" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="60" name="publisher_name" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="6" name="hfa_publisher_number" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="7" name="exact_per_publisher_share" nullable="true" pattern="" precision="4" sourceType="DECIMAL" type="id_Float" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="15" name="catalog_number" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="200" name="album_title" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="16" name="upc_code" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="2" name="configuration_codes" nullable="false" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="1" name="license_type" nullable="true" pattern="" precision="0" sourceType="CHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="10" name="server_fixation_date" nullable="true" pattern="" precision="0" sourceType="INT" type="id_Integer" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="1" name="rate_code" nullable="true" pattern="" precision="0" sourceType="CHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="12" name="hfa_output_1" nullable="true" pattern="" precision="7" sourceType="DECIMAL" type="id_Float" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="5" name="hfa_output_2" nullable="true" pattern="" precision="2" sourceType="DECIMAL" type="id_Float" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="5" name="hfa_output_3" nullable="true" pattern="" precision="2" sourceType="DECIMAL" type="id_Float" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="10" name="hfa_license_number_direct_deal_reference_id" nullable="true" pattern="" precision="0" sourceType="INT" type="id_Integer" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="{Input:Use only to designate amended record that is being resubmitted - use code R in field} {Output:  Code designating reason why request was not licensable as submitted. Numerous options available, with options being added/revised as necessary. See Digi" key="false" length="2" name="hfa_request_process_code_1" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value="{Input:Use only to designate amended record that is being resubmitted - use code R in field} {Output:  Code designating reason why request was not licensable as submitted. Numerous options available, with options being added/revised as necessary. See Digi"/>
      </column>
      <column comment="" key="false" length="2" name="hfa_request_process_code_2" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="2" name="hfa_request_process_code_3" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="2" name="hfa_request_process_code_4" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="2" name="licensed_status_code" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="1" name="hfa_output_field" nullable="true" pattern="" precision="0" sourceType="CHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="1" name="publisher_status" nullable="true" pattern="" precision="0" sourceType="CHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="7" name="total_hfa_licensed_share" nullable="true" pattern="" precision="4" sourceType="DECIMAL" type="id_Float" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="200" name="user_defined_1" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="200" name="user_defined_2_track_id" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="200" name="user_defined_3_track_publisher_id" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="200" name="user_defined_4_distribution_date" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="200" name="user_defined_5" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="200" name="user_defined_6" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="2" name="user_defined_7_tr_code" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="18" name="user_defined_8_priority_code" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="20" name="user_defined_9_pid" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column key="false" length="255" name="errorCode" nullable="true" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true"/>
      <column key="false" length="255" name="errorMessage" nullable="true" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true"/>
    </metadata>
  </node>
  <node componentName="tMysqlOutput" componentVersion="0.102" offsetLabelX="0" offsetLabelY="0" posX="640" posY="256">
    <elementParameter field="TEXT" name="UNIQUE_NAME" value="tMysqlOutput_3"/>
    <elementParameter field="CHECK" name="END_OF_FLOW" value="true"/>
    <elementParameter field="TECHNICAL" name="PROPERTY:PROPERTY_TYPE" value="REPOSITORY"/>
    <elementParameter field="TECHNICAL" name="PROPERTY:REPOSITORY_PROPERTY_TYPE" value="_JBGnYEYzEeOd6b-xkgEtPw"/>
    <elementParameter field="CLOSED_LIST" name="DB_VERSION" value="MYSQL_5"/>
    <elementParameter field="CHECK" name="USE_EXISTING_CONNECTION" value="false"/>
    <elementParameter field="COMPONENT_LIST" name="CONNECTION" value=""/>
    <elementParameter field="TEXT" name="TYPE" value="MYSQL"/>
    <elementParameter field="TEXT" name="HOST" value="&quot;192.168.31.138&quot;"/>
    <elementParameter field="TEXT" name="PORT" value="&quot;3306&quot;"/>
    <elementParameter field="TEXT" name="DBNAME" value="&quot;art_relations&quot;"/>
    <elementParameter field="TEXT" name="USER" value="&quot;myron&quot;"/>
    <elementParameter field="TEXT" name="PASS" value="&quot;orchard&quot;"/>
    <elementParameter field="DBTABLE" name="TABLE" value="&quot;hfa_publishing_license_responses_errors&quot;"/>
    <elementParameter field="CLOSED_LIST" name="TABLE_ACTION" value="CREATE_IF_NOT_EXISTS"/>
    <elementParameter field="CLOSED_LIST" name="DATA_ACTION" value="INSERT"/>
    <elementParameter field="LABEL" name="NOTE" value="This option only applies when deploying and running in the Talend Runtime"/>
    <elementParameter field="CHECK" name="SPECIFY_DATASOURCE_ALIAS" value="false"/>
    <elementParameter field="TEXT" name="DATASOURCE_ALIAS" value="&quot;&quot;"/>
    <elementParameter field="CHECK" name="DIE_ON_ERROR" value="false"/>
    <elementParameter field="MAPPING_TYPE" name="MAPPING" value="mysql_id"/>
    <elementParameter field="TEXT" name="PROPERTIES" value="&quot;noDatetimeStringSync=true&quot;"/>
    <elementParameter field="CHECK" name="EXTENDINSERT" value="true"/>
    <elementParameter field="LABEL" name="NOTE" value="(Not compatible with reject links)"/>
    <elementParameter field="TEXT" name="NB_ROWS_PER_INSERT" value="100"/>
    <elementParameter field="CHECK" name="USE_BATCH_SIZE" value="true"/>
    <elementParameter field="TEXT" name="BATCH_SIZE" value="10000"/>
    <elementParameter field="ENCODING_TYPE" name="ENCODING" value="&quot;ISO-8859-15&quot;"/>
    <elementParameter field="TECHNICAL" name="ENCODING:ENCODING_TYPE" value="ISO-8859-15"/>
    <elementParameter field="TEXT" name="COMMIT_EVERY" value="10000"/>
    <elementParameter field="TABLE" name="ADD_COLS"/>
    <elementParameter field="CHECK" name="USE_FIELD_OPTIONS" value="false"/>
    <elementParameter field="TABLE" name="FIELD_OPTIONS">
      <elementValue elementRef="SCHEMA_COLUMN" value="response_id"/>
      <elementValue elementRef="UPDATE_KEY" value="false"/>
      <elementValue elementRef="DELETE_KEY" value="false"/>
      <elementValue elementRef="UPDATABLE" value="true"/>
      <elementValue elementRef="INSERTABLE" value="true"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="response_created_at"/>
      <elementValue elementRef="UPDATE_KEY" value="false"/>
      <elementValue elementRef="DELETE_KEY" value="false"/>
      <elementValue elementRef="UPDATABLE" value="true"/>
      <elementValue elementRef="INSERTABLE" value="true"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="response_modified_at"/>
      <elementValue elementRef="UPDATE_KEY" value="false"/>
      <elementValue elementRef="DELETE_KEY" value="false"/>
      <elementValue elementRef="UPDATABLE" value="true"/>
      <elementValue elementRef="INSERTABLE" value="true"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="response_file_name"/>
      <elementValue elementRef="UPDATE_KEY" value="false"/>
      <elementValue elementRef="DELETE_KEY" value="false"/>
      <elementValue elementRef="UPDATABLE" value="true"/>
      <elementValue elementRef="INSERTABLE" value="true"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="hfa_agreement_code"/>
      <elementValue elementRef="UPDATE_KEY" value="false"/>
      <elementValue elementRef="DELETE_KEY" value="false"/>
      <elementValue elementRef="UPDATABLE" value="true"/>
      <elementValue elementRef="INSERTABLE" value="true"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="manufacturer_number"/>
      <elementValue elementRef="UPDATE_KEY" value="false"/>
      <elementValue elementRef="DELETE_KEY" value="false"/>
      <elementValue elementRef="UPDATABLE" value="true"/>
      <elementValue elementRef="INSERTABLE" value="true"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="transaction_date"/>
      <elementValue elementRef="UPDATE_KEY" value="false"/>
      <elementValue elementRef="DELETE_KEY" value="false"/>
      <elementValue elementRef="UPDATABLE" value="true"/>
      <elementValue elementRef="INSERTABLE" value="true"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="manufacturer_request_number"/>
      <elementValue elementRef="UPDATE_KEY" value="false"/>
      <elementValue elementRef="DELETE_KEY" value="false"/>
      <elementValue elementRef="UPDATABLE" value="true"/>
      <elementValue elementRef="INSERTABLE" value="true"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="label_name"/>
      <elementValue elementRef="UPDATE_KEY" value="false"/>
      <elementValue elementRef="DELETE_KEY" value="false"/>
      <elementValue elementRef="UPDATABLE" value="true"/>
      <elementValue elementRef="INSERTABLE" value="true"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="isrc_code"/>
      <elementValue elementRef="UPDATE_KEY" value="false"/>
      <elementValue elementRef="DELETE_KEY" value="false"/>
      <elementValue elementRef="UPDATABLE" value="true"/>
      <elementValue elementRef="INSERTABLE" value="true"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="playing_time_minutes"/>
      <elementValue elementRef="UPDATE_KEY" value="false"/>
      <elementValue elementRef="DELETE_KEY" value="false"/>
      <elementValue elementRef="UPDATABLE" value="true"/>
      <elementValue elementRef="INSERTABLE" value="true"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="playing_time_seconds"/>
      <elementValue elementRef="UPDATE_KEY" value="false"/>
      <elementValue elementRef="DELETE_KEY" value="false"/>
      <elementValue elementRef="UPDATABLE" value="true"/>
      <elementValue elementRef="INSERTABLE" value="true"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="artist"/>
      <elementValue elementRef="UPDATE_KEY" value="false"/>
      <elementValue elementRef="DELETE_KEY" value="false"/>
      <elementValue elementRef="UPDATABLE" value="true"/>
      <elementValue elementRef="INSERTABLE" value="true"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="song_title"/>
      <elementValue elementRef="UPDATE_KEY" value="false"/>
      <elementValue elementRef="DELETE_KEY" value="false"/>
      <elementValue elementRef="UPDATABLE" value="true"/>
      <elementValue elementRef="INSERTABLE" value="true"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="aka_song_title"/>
      <elementValue elementRef="UPDATE_KEY" value="false"/>
      <elementValue elementRef="DELETE_KEY" value="false"/>
      <elementValue elementRef="UPDATABLE" value="true"/>
      <elementValue elementRef="INSERTABLE" value="true"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="iswc_code"/>
      <elementValue elementRef="UPDATE_KEY" value="false"/>
      <elementValue elementRef="DELETE_KEY" value="false"/>
      <elementValue elementRef="UPDATABLE" value="true"/>
      <elementValue elementRef="INSERTABLE" value="true"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="hfa_song_code"/>
      <elementValue elementRef="UPDATE_KEY" value="false"/>
      <elementValue elementRef="DELETE_KEY" value="false"/>
      <elementValue elementRef="UPDATABLE" value="true"/>
      <elementValue elementRef="INSERTABLE" value="true"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="composers"/>
      <elementValue elementRef="UPDATE_KEY" value="false"/>
      <elementValue elementRef="DELETE_KEY" value="false"/>
      <elementValue elementRef="UPDATABLE" value="true"/>
      <elementValue elementRef="INSERTABLE" value="true"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="publisher_name"/>
      <elementValue elementRef="UPDATE_KEY" value="false"/>
      <elementValue elementRef="DELETE_KEY" value="false"/>
      <elementValue elementRef="UPDATABLE" value="true"/>
      <elementValue elementRef="INSERTABLE" value="true"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="hfa_publisher_number"/>
      <elementValue elementRef="UPDATE_KEY" value="false"/>
      <elementValue elementRef="DELETE_KEY" value="false"/>
      <elementValue elementRef="UPDATABLE" value="true"/>
      <elementValue elementRef="INSERTABLE" value="true"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="exact_per_publisher_share"/>
      <elementValue elementRef="UPDATE_KEY" value="false"/>
      <elementValue elementRef="DELETE_KEY" value="false"/>
      <elementValue elementRef="UPDATABLE" value="true"/>
      <elementValue elementRef="INSERTABLE" value="true"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="catalog_number"/>
      <elementValue elementRef="UPDATE_KEY" value="false"/>
      <elementValue elementRef="DELETE_KEY" value="false"/>
      <elementValue elementRef="UPDATABLE" value="true"/>
      <elementValue elementRef="INSERTABLE" value="true"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="album_title"/>
      <elementValue elementRef="UPDATE_KEY" value="false"/>
      <elementValue elementRef="DELETE_KEY" value="false"/>
      <elementValue elementRef="UPDATABLE" value="true"/>
      <elementValue elementRef="INSERTABLE" value="true"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="upc_code"/>
      <elementValue elementRef="UPDATE_KEY" value="false"/>
      <elementValue elementRef="DELETE_KEY" value="false"/>
      <elementValue elementRef="UPDATABLE" value="true"/>
      <elementValue elementRef="INSERTABLE" value="true"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="configuration_codes"/>
      <elementValue elementRef="UPDATE_KEY" value="false"/>
      <elementValue elementRef="DELETE_KEY" value="false"/>
      <elementValue elementRef="UPDATABLE" value="true"/>
      <elementValue elementRef="INSERTABLE" value="true"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="license_type"/>
      <elementValue elementRef="UPDATE_KEY" value="false"/>
      <elementValue elementRef="DELETE_KEY" value="false"/>
      <elementValue elementRef="UPDATABLE" value="true"/>
      <elementValue elementRef="INSERTABLE" value="true"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="server_fixation_date"/>
      <elementValue elementRef="UPDATE_KEY" value="false"/>
      <elementValue elementRef="DELETE_KEY" value="false"/>
      <elementValue elementRef="UPDATABLE" value="true"/>
      <elementValue elementRef="INSERTABLE" value="true"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="rate_code"/>
      <elementValue elementRef="UPDATE_KEY" value="false"/>
      <elementValue elementRef="DELETE_KEY" value="false"/>
      <elementValue elementRef="UPDATABLE" value="true"/>
      <elementValue elementRef="INSERTABLE" value="true"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="hfa_output_1"/>
      <elementValue elementRef="UPDATE_KEY" value="false"/>
      <elementValue elementRef="DELETE_KEY" value="false"/>
      <elementValue elementRef="UPDATABLE" value="true"/>
      <elementValue elementRef="INSERTABLE" value="true"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="hfa_output_2"/>
      <elementValue elementRef="UPDATE_KEY" value="false"/>
      <elementValue elementRef="DELETE_KEY" value="false"/>
      <elementValue elementRef="UPDATABLE" value="true"/>
      <elementValue elementRef="INSERTABLE" value="true"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="hfa_output_3"/>
      <elementValue elementRef="UPDATE_KEY" value="false"/>
      <elementValue elementRef="DELETE_KEY" value="false"/>
      <elementValue elementRef="UPDATABLE" value="true"/>
      <elementValue elementRef="INSERTABLE" value="true"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="hfa_license_number_direct_deal_reference_id"/>
      <elementValue elementRef="UPDATE_KEY" value="false"/>
      <elementValue elementRef="DELETE_KEY" value="false"/>
      <elementValue elementRef="UPDATABLE" value="true"/>
      <elementValue elementRef="INSERTABLE" value="true"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="hfa_request_process_code_1"/>
      <elementValue elementRef="UPDATE_KEY" value="false"/>
      <elementValue elementRef="DELETE_KEY" value="false"/>
      <elementValue elementRef="UPDATABLE" value="true"/>
      <elementValue elementRef="INSERTABLE" value="true"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="hfa_request_process_code_2"/>
      <elementValue elementRef="UPDATE_KEY" value="false"/>
      <elementValue elementRef="DELETE_KEY" value="false"/>
      <elementValue elementRef="UPDATABLE" value="true"/>
      <elementValue elementRef="INSERTABLE" value="true"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="hfa_request_process_code_3"/>
      <elementValue elementRef="UPDATE_KEY" value="false"/>
      <elementValue elementRef="DELETE_KEY" value="false"/>
      <elementValue elementRef="UPDATABLE" value="true"/>
      <elementValue elementRef="INSERTABLE" value="true"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="hfa_request_process_code_4"/>
      <elementValue elementRef="UPDATE_KEY" value="false"/>
      <elementValue elementRef="DELETE_KEY" value="false"/>
      <elementValue elementRef="UPDATABLE" value="true"/>
      <elementValue elementRef="INSERTABLE" value="true"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="licensed_status_code"/>
      <elementValue elementRef="UPDATE_KEY" value="false"/>
      <elementValue elementRef="DELETE_KEY" value="false"/>
      <elementValue elementRef="UPDATABLE" value="true"/>
      <elementValue elementRef="INSERTABLE" value="true"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="hfa_output_field"/>
      <elementValue elementRef="UPDATE_KEY" value="false"/>
      <elementValue elementRef="DELETE_KEY" value="false"/>
      <elementValue elementRef="UPDATABLE" value="true"/>
      <elementValue elementRef="INSERTABLE" value="true"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="publisher_status"/>
      <elementValue elementRef="UPDATE_KEY" value="false"/>
      <elementValue elementRef="DELETE_KEY" value="false"/>
      <elementValue elementRef="UPDATABLE" value="true"/>
      <elementValue elementRef="INSERTABLE" value="true"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="total_hfa_licensed_share"/>
      <elementValue elementRef="UPDATE_KEY" value="false"/>
      <elementValue elementRef="DELETE_KEY" value="false"/>
      <elementValue elementRef="UPDATABLE" value="true"/>
      <elementValue elementRef="INSERTABLE" value="true"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="user_defined_1"/>
      <elementValue elementRef="UPDATE_KEY" value="false"/>
      <elementValue elementRef="DELETE_KEY" value="false"/>
      <elementValue elementRef="UPDATABLE" value="true"/>
      <elementValue elementRef="INSERTABLE" value="true"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="user_defined_2_track_id"/>
      <elementValue elementRef="UPDATE_KEY" value="false"/>
      <elementValue elementRef="DELETE_KEY" value="false"/>
      <elementValue elementRef="UPDATABLE" value="true"/>
      <elementValue elementRef="INSERTABLE" value="true"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="user_defined_3_track_publisher_id"/>
      <elementValue elementRef="UPDATE_KEY" value="false"/>
      <elementValue elementRef="DELETE_KEY" value="false"/>
      <elementValue elementRef="UPDATABLE" value="true"/>
      <elementValue elementRef="INSERTABLE" value="true"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="user_defined_4_distribution_date"/>
      <elementValue elementRef="UPDATE_KEY" value="false"/>
      <elementValue elementRef="DELETE_KEY" value="false"/>
      <elementValue elementRef="UPDATABLE" value="true"/>
      <elementValue elementRef="INSERTABLE" value="true"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="user_defined_5"/>
      <elementValue elementRef="UPDATE_KEY" value="false"/>
      <elementValue elementRef="DELETE_KEY" value="false"/>
      <elementValue elementRef="UPDATABLE" value="true"/>
      <elementValue elementRef="INSERTABLE" value="true"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="user_defined_6"/>
      <elementValue elementRef="UPDATE_KEY" value="false"/>
      <elementValue elementRef="DELETE_KEY" value="false"/>
      <elementValue elementRef="UPDATABLE" value="true"/>
      <elementValue elementRef="INSERTABLE" value="true"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="user_defined_7_tr_code"/>
      <elementValue elementRef="UPDATE_KEY" value="false"/>
      <elementValue elementRef="DELETE_KEY" value="false"/>
      <elementValue elementRef="UPDATABLE" value="true"/>
      <elementValue elementRef="INSERTABLE" value="true"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="user_defined_8_priority_code"/>
      <elementValue elementRef="UPDATE_KEY" value="false"/>
      <elementValue elementRef="DELETE_KEY" value="false"/>
      <elementValue elementRef="UPDATABLE" value="true"/>
      <elementValue elementRef="INSERTABLE" value="true"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="user_defined_9_pid"/>
      <elementValue elementRef="UPDATE_KEY" value="false"/>
      <elementValue elementRef="DELETE_KEY" value="false"/>
      <elementValue elementRef="UPDATABLE" value="true"/>
      <elementValue elementRef="INSERTABLE" value="true"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="errorCode"/>
      <elementValue elementRef="UPDATE_KEY" value="false"/>
      <elementValue elementRef="DELETE_KEY" value="false"/>
      <elementValue elementRef="UPDATABLE" value="true"/>
      <elementValue elementRef="INSERTABLE" value="true"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="errorMessage"/>
      <elementValue elementRef="UPDATE_KEY" value="false"/>
      <elementValue elementRef="DELETE_KEY" value="false"/>
      <elementValue elementRef="UPDATABLE" value="true"/>
      <elementValue elementRef="INSERTABLE" value="true"/>
    </elementParameter>
    <elementParameter field="CHECK" name="USE_HINT_OPTIONS" value="false"/>
    <elementParameter field="TABLE" name="HINT_OPTIONS"/>
    <elementParameter field="CHECK" name="ENABLE_DEBUG_MODE" value="false"/>
    <elementParameter field="CHECK" name="ON_DUPLICATE_KEY_UPDATE" value="false"/>
    <elementParameter field="TABLE" name="DUPLICATED_KEYS"/>
    <elementParameter field="CHECK" name="SUPPORT_NULL_WHERE" value="false"/>
    <elementParameter field="TEXT" name="CONNECTION_FORMAT" value="row"/>
    <elementParameter field="CHECK" name="INFORMATION" value="false"/>
    <elementParameter field="MEMO" name="COMMENT" value=""/>
    <elementParameter field="CHECK" name="VALIDATION_RULES" value="false"/>
    <metadata connector="FLOW" label="hfa_license_responses" name="tMysqlOutput_3">
      <column comment="" key="true" length="10" name="response_id" nullable="false" pattern="" precision="0" sourceType="INT" type="id_Integer" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" defaultValue="CURRENT_TIMESTAMP" key="false" length="19" name="response_created_at" nullable="false" pattern="&quot;dd-MM-yyyy&quot;" precision="0" sourceType="TIMESTAMP" type="id_Date" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="19" name="response_modified_at" nullable="true" pattern="&quot;dd-MM-yyyy&quot;" precision="0" sourceType="DATETIME" type="id_Date" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="200" name="response_file_name" nullable="false" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="3" name="hfa_agreement_code" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="6" name="manufacturer_number" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="10" name="transaction_date" nullable="true" pattern="" precision="0" sourceType="INT" type="id_Integer" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="10" name="manufacturer_request_number" nullable="false" pattern="" precision="0" sourceType="INT" type="id_Integer" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="60" name="label_name" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="15" name="isrc_code" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="10" name="playing_time_minutes" nullable="true" pattern="" precision="0" sourceType="INT" type="id_Integer" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="10" name="playing_time_seconds" nullable="true" pattern="" precision="0" sourceType="INT" type="id_Integer" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="200" name="artist" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="200" name="song_title" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="200" name="aka_song_title" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="11" name="iswc_code" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="6" name="hfa_song_code" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="200" name="composers" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="60" name="publisher_name" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="6" name="hfa_publisher_number" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="7" name="exact_per_publisher_share" nullable="true" pattern="" precision="4" sourceType="DECIMAL" type="id_Float" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="15" name="catalog_number" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="200" name="album_title" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="16" name="upc_code" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="2" name="configuration_codes" nullable="false" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="1" name="license_type" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="10" name="server_fixation_date" nullable="true" pattern="" precision="0" sourceType="INT" type="id_Integer" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="1" name="rate_code" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="12" name="hfa_output_1" nullable="true" pattern="" precision="7" sourceType="DECIMAL" type="id_Float" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="5" name="hfa_output_2" nullable="true" pattern="" precision="2" sourceType="DECIMAL" type="id_Float" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="5" name="hfa_output_3" nullable="true" pattern="" precision="2" sourceType="DECIMAL" type="id_Float" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="10" name="hfa_license_number_direct_deal_reference_id" nullable="true" pattern="" precision="0" sourceType="INT" type="id_Integer" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="{Input:Use only to designate amended record that is being resubmitted - use code R in field} {Output:  Code designating reason why request was not licensable as submitted. Numerous options available, with options being added/revised as necessary. See Digi" key="false" length="2" name="hfa_request_process_code_1" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value="{Input:Use only to designate amended record that is being resubmitted - use code R in field} {Output:  Code designating reason why request was not licensable as submitted. Numerous options available, with options being added/revised as necessary. See Digi"/>
      </column>
      <column comment="" key="false" length="2" name="hfa_request_process_code_2" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="2" name="hfa_request_process_code_3" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="2" name="hfa_request_process_code_4" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="2" name="licensed_status_code" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="1" name="hfa_output_field" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="1" name="publisher_status" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="7" name="total_hfa_licensed_share" nullable="true" pattern="" precision="4" sourceType="DECIMAL" type="id_Float" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="200" name="user_defined_1" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="200" name="user_defined_2_track_id" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="200" name="user_defined_3_track_publisher_id" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="200" name="user_defined_4_distribution_date" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="200" name="user_defined_5" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="200" name="user_defined_6" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="2" name="user_defined_7_tr_code" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="18" name="user_defined_8_priority_code" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="20" name="user_defined_9_pid" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column key="false" length="255" name="errorCode" nullable="true" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true"/>
      <column key="false" length="255" name="errorMessage" nullable="true" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true"/>
    </metadata>
    <metadata connector="REJECT" label="hfa_license_responses" name="REJECT">
      <column comment="" key="true" length="10" name="response_id" nullable="false" pattern="" precision="0" sourceType="INT" type="id_Integer" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" defaultValue="CURRENT_TIMESTAMP" key="false" length="19" name="response_created_at" nullable="false" pattern="&quot;dd-MM-yyyy&quot;" precision="0" sourceType="TIMESTAMP" type="id_Date" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="19" name="response_modified_at" nullable="true" pattern="&quot;dd-MM-yyyy&quot;" precision="0" sourceType="DATETIME" type="id_Date" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="200" name="response_file_name" nullable="false" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="3" name="hfa_agreement_code" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="6" name="manufacturer_number" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="10" name="transaction_date" nullable="true" pattern="" precision="0" sourceType="INT" type="id_Integer" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="10" name="manufacturer_request_number" nullable="false" pattern="" precision="0" sourceType="INT" type="id_Integer" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="60" name="label_name" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="15" name="isrc_code" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="10" name="playing_time_minutes" nullable="true" pattern="" precision="0" sourceType="INT" type="id_Integer" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="10" name="playing_time_seconds" nullable="true" pattern="" precision="0" sourceType="INT" type="id_Integer" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="200" name="artist" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="200" name="song_title" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="200" name="aka_song_title" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="11" name="iswc_code" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="6" name="hfa_song_code" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="200" name="composers" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="60" name="publisher_name" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="6" name="hfa_publisher_number" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="7" name="exact_per_publisher_share" nullable="true" pattern="" precision="4" sourceType="DECIMAL" type="id_Float" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="15" name="catalog_number" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="200" name="album_title" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="16" name="upc_code" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="2" name="configuration_codes" nullable="false" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="1" name="license_type" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="10" name="server_fixation_date" nullable="true" pattern="" precision="0" sourceType="INT" type="id_Integer" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="1" name="rate_code" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="12" name="hfa_output_1" nullable="true" pattern="" precision="7" sourceType="DECIMAL" type="id_Float" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="5" name="hfa_output_2" nullable="true" pattern="" precision="2" sourceType="DECIMAL" type="id_Float" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="5" name="hfa_output_3" nullable="true" pattern="" precision="2" sourceType="DECIMAL" type="id_Float" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="10" name="hfa_license_number_direct_deal_reference_id" nullable="true" pattern="" precision="0" sourceType="INT" type="id_Integer" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="{Input:Use only to designate amended record that is being resubmitted - use code R in field} {Output:  Code designating reason why request was not licensable as submitted. Numerous options available, with options being added/revised as necessary. See Digi" key="false" length="2" name="hfa_request_process_code_1" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value="{Input:Use only to designate amended record that is being resubmitted - use code R in field} {Output:  Code designating reason why request was not licensable as submitted. Numerous options available, with options being added/revised as necessary. See Digi"/>
      </column>
      <column comment="" key="false" length="2" name="hfa_request_process_code_2" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="2" name="hfa_request_process_code_3" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="2" name="hfa_request_process_code_4" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="2" name="licensed_status_code" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="1" name="hfa_output_field" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="1" name="publisher_status" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="7" name="total_hfa_licensed_share" nullable="true" pattern="" precision="4" sourceType="DECIMAL" type="id_Float" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="200" name="user_defined_1" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="200" name="user_defined_2_track_id" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="200" name="user_defined_3_track_publisher_id" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="200" name="user_defined_4_distribution_date" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="200" name="user_defined_5" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="200" name="user_defined_6" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="2" name="user_defined_7_tr_code" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="18" name="user_defined_8_priority_code" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" key="false" length="20" name="user_defined_9_pid" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column key="false" length="255" name="errorCode" nullable="true" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true"/>
      <column key="false" length="255" name="errorMessage" nullable="true" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true"/>
    </metadata>
  </node>
  <node componentName="tFileDelete" componentVersion="0.102" offsetLabelX="0" offsetLabelY="0" posX="832" posY="64">
    <elementParameter field="TEXT" name="UNIQUE_NAME" value="tFileDelete_1"/>
    <elementParameter field="FILE" name="FILENAME" value="((String)globalMap.get(&quot;tFileList_1_CURRENT_FILEPATH&quot;))"/>
    <elementParameter field="DIRECTORY" name="DIRECTORY" value="&quot;/Users/achan/Downloads/TOS_DI-r110020-V5.4.0/workspace/delete_folder&quot;"/>
    <elementParameter field="TEXT" name="PATH" value="&quot;/Users/achan/Downloads/TOS_DI-r110020-V5.4.0/workspace/delete_folder or delete_file&quot;"/>
    <elementParameter field="CHECK" name="FAILON" value="true"/>
    <elementParameter field="CHECK" name="FOLDER" value="false"/>
    <elementParameter field="CHECK" name="FOLDER_FILE" value="false"/>
    <elementParameter field="LABEL" name="NOTE" value="*Note &quot;CURRENT_STATUS&quot; including:&#xA;&quot;File (or path) deleted.&quot;&#xA;&quot;No file (or path) deleted.&quot;&#xA;&quot;File (or path) does not exists or is invalid.&quot;"/>
    <elementParameter field="TEXT" name="CONNECTION_FORMAT" value="row"/>
    <elementParameter field="CHECK" name="INFORMATION" value="false"/>
    <elementParameter field="MEMO" name="COMMENT" value=""/>
    <elementParameter field="CHECK" name="VALIDATION_RULES" value="false"/>
    <metadata connector="FLOW" name="tFileDelete_1"/>
  </node>
  <connection connectorName="ITERATE" label="Iterate" lineStyle="7" metaname="tFileList_1" offsetLabelX="0" offsetLabelY="0" source="tFileList_1" target="tFileInputDelimited_2">
    <elementParameter field="CHECK" name="ENABLE_PARALLEL" value="false"/>
    <elementParameter field="TEXT" name="NUMBER_PARALLEL" value="2"/>
    <elementParameter field="CHECK" name="ACTIVATE" value="true"/>
    <elementParameter field="TEXT" name="UNIQUE_NAME" value="iterate1"/>
  </connection>
  <connection connectorName="FLOW" label="row1" lineStyle="0" metaname="tFileInputDelimited_2" offsetLabelX="0" offsetLabelY="0" source="tFileInputDelimited_2" target="tMap_1">
    <elementParameter field="CHECK" name="TRACES_CONNECTION_ENABLE" value="true"/>
    <elementParameter field="TABLE" name="TRACES_CONNECTION_FILTER">
      <elementValue elementRef="TRACE_COLUMN" value="hfa_agreement_code"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="manufacturer_number"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="transaction_date"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="manufacturer_request_number"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="label_name"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="isrc_code"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="playing_time_minutes"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="playing_time_seconds"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="artist"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="song_title"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="aka_song_title"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="iswc_code"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="hfa_song_code"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="composers"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="publisher_name"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="hfa_publisher_number"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="exact_per_publisher_share"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="catalog_number"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="album_title"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="upc_code"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="configuration_codes"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="license_type"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="server_fixation_date"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="rate_code"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="hfa_output_1"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="hfa_output_2"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="hfa_output_3"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="hfa_license_number_direct_deal_reference_id"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="hfa_request_process_code_1"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="hfa_request_process_code_2"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="hfa_request_process_code_3"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="hfa_request_process_code_4"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="licensed_status_code"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="hfa_output_field"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="publisher_status"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="total_hfa_licensed_share"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="user_defined_1"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="user_defined_2_track_id"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="user_defined_3"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="user_defined_4_distribution_date"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="user_defined_5"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="user_defined_6"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="user_defined_7_tr_code"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="user_defined_8_priority_code"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="user_defined_9_pid"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
    </elementParameter>
    <elementParameter field="CHECK" name="MONITOR_CONNECTION" value="false"/>
    <elementParameter field="CHECK" name="USEROWLABEL" value="true"/>
    <elementParameter field="TEXT" name="METTERLABEL" value="&quot;MyLabel&quot;"/>
    <elementParameter field="CLOSED_LIST" name="ABSOLUTE" value="Absolute"/>
    <elementParameter field="CONNECTION_LIST" name="CONNECTIONS" value=""/>
    <elementParameter field="TABLE" name="THRESHLODS"/>
    <elementParameter field="CHECK" name="ACTIVATE" value="true"/>
    <elementParameter field="TEXT" name="UNIQUE_NAME" value="row1"/>
  </connection>
  <connection connectorName="FLOW" label="main" lineStyle="0" metaname="main" offsetLabelX="0" offsetLabelY="0" source="tMap_1" target="tMysqlOutput_1">
    <elementParameter field="CHECK" name="TRACES_CONNECTION_ENABLE" value="true"/>
    <elementParameter field="TABLE" name="TRACES_CONNECTION_FILTER">
      <elementValue elementRef="TRACE_COLUMN" value="response_id"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="response_created_at"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="response_modified_at"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="response_file_name"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="hfa_agreement_code"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="manufacturer_number"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="transaction_date"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="manufacturer_request_number"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="label_name"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="isrc_code"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="playing_time_minutes"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="playing_time_seconds"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="artist"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="song_title"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="aka_song_title"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="iswc_code"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="hfa_song_code"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="composers"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="publisher_name"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="hfa_publisher_number"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="exact_per_publisher_share"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="catalog_number"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="album_title"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="upc_code"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="configuration_codes"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="license_type"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="server_fixation_date"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="rate_code"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="hfa_output_1"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="hfa_output_2"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="hfa_output_3"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="hfa_license_number_direct_deal_reference_id"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="hfa_request_process_code_1"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="hfa_request_process_code_2"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="hfa_request_process_code_3"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="hfa_request_process_code_4"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="licensed_status_code"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="hfa_output_field"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="publisher_status"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="total_hfa_licensed_share"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="user_defined_1"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="user_defined_2_track_id"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="user_defined_3_track_publisher_id"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="user_defined_4_distribution_date"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="user_defined_5"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="user_defined_6"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="user_defined_7_tr_code"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="user_defined_8_priority_code"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="user_defined_9_pid"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
    </elementParameter>
    <elementParameter field="CHECK" name="MONITOR_CONNECTION" value="false"/>
    <elementParameter field="CHECK" name="USEROWLABEL" value="true"/>
    <elementParameter field="TEXT" name="METTERLABEL" value="&quot;MyLabel&quot;"/>
    <elementParameter field="CLOSED_LIST" name="ABSOLUTE" value="Absolute"/>
    <elementParameter field="CONNECTION_LIST" name="CONNECTIONS" value=""/>
    <elementParameter field="TABLE" name="THRESHLODS"/>
    <elementParameter field="CHECK" name="ACTIVATE" value="true"/>
    <elementParameter field="TEXT" name="UNIQUE_NAME" value="main"/>
  </connection>
  <connection connectorName="REJECT" label="row3" lineStyle="0" metaname="REJECT" offsetLabelX="0" offsetLabelY="0" source="tMysqlOutput_1" target="tMysqlOutput_3">
    <elementParameter field="CHECK" name="TRACES_CONNECTION_ENABLE" value="true"/>
    <elementParameter field="TABLE" name="TRACES_CONNECTION_FILTER">
      <elementValue elementRef="TRACE_COLUMN" value="hfa_agreement_code"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="manufacturer_number"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="transaction_date"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="manufacturer_request_number"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="label_name"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="isrc_code"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="playing_time_minutes"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="playing_time_seconds"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="artist"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="song_title"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="aka_song_title"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="iswc_code"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="hfa_song_code"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="composers"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="publisher_name"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="hfa_publisher_number"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="exact_per_publisher_share"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="catalog_number"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="album_title"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="upc_code"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="configuration_codes"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="license_type"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="server_fixation_date"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="rate_code"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="hfa_output_1"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="hfa_output_2"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="hfa_output_3"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="hfa_license_number_direct_deal_reference_id"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="hfa_request_process_code_1"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="hfa_request_process_code_2"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="hfa_request_process_code_3"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="hfa_request_process_code_4"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="licensed_status_code"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="hfa_output_field"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="publisher_status"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="total_hfa_licensed_share"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="user_defined_1"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="user_definied_2_track_id"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="user_defined_3"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="user_defined_4_distribution_date"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="user_defined_5"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="user_defined_6"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="user_defined_7_tr_code"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="user_defined_8_priority_code"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="user_defined_9_pid"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="id"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="created_date"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="response_filename"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="errorCode"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
      <elementValue elementRef="TRACE_COLUMN" value="errorMessage"/>
      <elementValue elementRef="TRACE_COLUMN_CHECKED" value="true"/>
      <elementValue elementRef="TRACE_COLUMN_CONDITION" value=""/>
    </elementParameter>
    <elementParameter field="CHECK" name="MONITOR_CONNECTION" value="false"/>
    <elementParameter field="CHECK" name="USEROWLABEL" value="true"/>
    <elementParameter field="TEXT" name="METTERLABEL" value="&quot;MyLabel&quot;"/>
    <elementParameter field="CLOSED_LIST" name="ABSOLUTE" value="Absolute"/>
    <elementParameter field="CONNECTION_LIST" name="CONNECTIONS" value=""/>
    <elementParameter field="TABLE" name="THRESHLODS"/>
    <elementParameter field="CHECK" name="ACTIVATE" value="true"/>
    <elementParameter field="TEXT" name="UNIQUE_NAME" value="row3"/>
  </connection>
  <connection connectorName="COMPONENT_OK" label="OnComponentOk" lineStyle="3" metaname="tMysqlOutput_1" offsetLabelX="0" offsetLabelY="0" source="tMysqlOutput_1" target="tFileDelete_1">
    <elementParameter field="CHECK" name="ACTIVATE" value="true"/>
    <elementParameter field="TEXT" name="UNIQUE_NAME" value="OnComponentOk1"/>
  </connection>
  <subjob>
    <elementParameter field="TEXT" name="UNIQUE_NAME" value="tFileList_1"/>
    <elementParameter field="COLOR" name="SUBJOB_TITLE_COLOR" value="160;190;240"/>
    <elementParameter field="COLOR" name="SUBJOB_COLOR" value="220;220;250"/>
  </subjob>
  <subjob>
    <elementParameter field="TEXT" name="UNIQUE_NAME" value="tFileDelete_1"/>
    <elementParameter field="COLOR" name="SUBJOB_TITLE_COLOR" value="160;190;240"/>
    <elementParameter field="COLOR" name="SUBJOB_COLOR" value="220;220;250"/>
  </subjob>
</talendfile:ProcessType>
