<?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="iVBORw0KGgoAAAANSUhEUgAABAQAAAFICAIAAABIp7sIAAAo4klEQVR4nO3dB5hU5aE/4E3MjfFvkptioiYajbHGFBFLMIlJrsRyDQrGFguxg0SKFOlNEBVQVBBpNrAhdqNGjbHeRI2xYkMBQWF7mSQqiMb/N3NgWLcx4O4e4Hvf5/fwnJ3yzczOYc7323NmpqioqOjjlmR84xvf+MY3vvGNb3zjG3/9HL9lbwkAAFhvKQMAABApZQAAACKlDAAAQKSUAQAAiJQyAAAAkVIGAAAgUsoAAABEShkAAIBIKQMAABApZQAAACKlDAAAQKSUAQAAiJQyAAAAkVIGAAAgUsoAAABEShkAAIBIKQMAABApZQAAACKlDAAAQKSUAQAAiJQyAAAAkVIGAAAgUsoAAABEShkAAIBIKQMAABApZQAAACKlDAAAQKSUAQAAiJQyAAAAkVIGAAAgUkVBS9+A8Y1vfOMb3/jGN77xjW/89XB8ewYAACBSygAAAERKGQAAgEgpAwAAECllAAAAIqUMAABApJQBAACIlDIAAACRUgYAACBSygAAAERKGQAAgEgpAwAAECllAAAAIqUMAABApJQBAACIlDIAAACRUgYAACBSygAAAERKGQAAgEgpAwAAECllAAAAIqUMAABApJQBAACIlDIAAACRUgYAACBSygAAAERKGQAAgEgpAwAAECllAAAAIqUMAABApJQBAACIVFHQ0jdg/KbH/+ijj98u/eC1RctemP9+s6fP8KktMazxjW984xt/PRw/bErCBuU//2ml7ZfxjW/8jWB8ewZSFl6y5y5c9uqi5WUVK2pqPspkRERE1iVhIxI2JaESzF24/KOP0t68ARsIZSBlb5d+EF64U9+EiIjIRpNXFy0PG5e0t2/AhkEZSNlri5eVVX6Y+pZDREQ2mpRVrHht0bK0t2/AhkEZSNkL8993dJCIiDRjwmYlbFzS3r4BGwZlIGWOERIRkbXKcYOLmkhyGWUAKJAykDJlQERE1iphxv/Yxw1HGQDWljKQMmVARETWKsoA0IyUgZQpAyIislZxmBDQjJSBlCkDIiLS7FEGgAIpAylTBkREpNmjDAAFUgZSpgyIiEizRxkACqQMpEwZEBGRZo8yABRIGUiZMiAiIs0eZQAokDKQMmVARESaPcoAUCBlIGXKgIiINHuUAaBAykDKlAEREWn2KANAgZSBlCkDIiLS7FEGgAIpAylTBkREpNmjDAAFUgZSpgyIiEizRxkACqQMpEwZEBGRZo8yABRIGUiZMiAiIs0eZQAokDKQMmVARESaPcoAUCBlIGXKgIiINHuUAaBAykDKlAEREWn2KANAgZSBlCkDIiLS7FEGgAIpAylTBkREpNmjDAAFUgZSpgyIiEizRxkACqQMpEwZEBGRZo8yABRIGUiZMiAiIs0eZQAokDKQMmVARESaPcoAUCBlIGXKgIiINHuUAaBARUFL34Dxm9Bn+NQW3R7cUVzUojn66FNa9P4b3/jGN77x1yGhDGzo20fjG9/4rTO+PQMpa+k9Ay1dBlr0zouIyLrFngGgQMpAypQBiTwjR448u55wYuEX6Dd4DRcQiTDKAFAgZSBlyoBEnjBx//iZotWZ2vbjafuEE5vxAhJt7hq7R+FJ/d42b5QBoEDKQMqUAYk8q6fyYRI/te1jw9qFNDzXX9cLSLQJU/zlH3y4xsy968yNrw8oA0CBlIGUtX4ZKCrq0nSUAWnNhFn7inpqT+WbPkxo8eKqNY4g0abwMrDx9QFlACiQMpCyVisD+bn+oFm3Np21qgSpb/BkQ09jU/l77324vHwN/zsefPCJjh079ezZUxmQBnPbBW3eX74iZNnyD3MJCys+eUo28x4aEsrAyxtXH1AGgAIpAylrnTJQSAeoXwmUAWmFNFYGunXrccoppy9Zkmnsik8++WKHDofdeecD9gxIYym8DIS8vHH1AWUAKJAykLJWKAPr0AQK7wOpb/BkQ0+Ytb9WTzixquqDwYNHHHvscXPnLqx/rVdfXdyxY6dZs+Y0MULqD01Sz81j2r67bEVIY2XgvWUrQt56ckLSB3LHC3UNZSBcMfU7/ymjDAAFUgZS1jploM9Vs9e6CRx2sjIgrZCm/65/8cWTwqT/ySdfrH2V+fNLjjrq6EsumVzICBJzwpx+k0HbJWm6DNTqA11DlAEgHspAylqnDPS9anb3adefcfm1nS+ZUVANSFLUZZMvD0qiDEgLpbGpfL4AzJo1p0OHDvfe+3DyY0nJvzt3Pmn06LFNjzBixIjUH5qknutH7xVqwF0rpoeEhX++tyLkX0nezeW9hnP9eXulfuc/ZZQBoEDKQMpaqQxcPbvHtOu7TL7295fMOHrsFR1GX9p+6Lj9+p/XptfwXbsN2u60vlt27vnfv+u22ZFnbNLx1DploMtZM8/oPrOxPpD6Bk829DQ4le/Vq9cJJ3QeOvTcqqoPwmXuv/+xDh0Ou/rqG8rL3+/a9azevc+pPUK/wSPrf+KQLx2TTK0ycGcuSR9QBgBqUwZS1nplYPoNSRk4ZuwVh4UyMGz8T/uPadNrRK4M9Atl4Cu/+8NmR3b5XL0y0K3njWf2vKFbzxsa7AOpb/BkQ09jR/wvWZI55ZTTu3TplryH+MknX+zU6YjjjjshlIE1fsqQSJJrzt07FIBb35sSclvIu1PCj02XgZp/ZxOumPqd/5RRBoACKQMpa50y0O/qm3tOv6Hr5JknXXrlMeOuOOy8y349bPzP+o/Z8+wRu3UbtP1p/bbq3CtbBo7q8rlOdctA9z63dO9961m9w7+31O8DqW/wZEPJ0tM/Uzrm59UvP1Xn9Ca+RiBM+vv2Hdi580nz5oVC8NHQoececsgh4ZRkd4FElcbWn5D8uwIay03Vk2bnkiys7AO1ysA/iu7LRxkAYqMMpKxVy8AV2TJw7Lgph5932YGhDAwY0/bskfl3BTSWs/vfXTt1+kDqGzzZULL0tKJsTv9scb/vVD4wJVO9vMArXnDBxZ06HTFs2OijjjrmpZcWdOnSLb+7IEm/wU19K5lsHGls/Qkz+5nFE1Zn6ap/8yluIOFalf/8IJ/aZSA5ZfrwfVN/yJ8yygBQIGUgZa1UBq65ueeMG868YubJoQyMD2Vg4oHDL/r5gPPDzL7fkAfPGfJAv8EPhIV+2YUHcwvhxGyyPw5e+eOq0x+o3QdS3+DJhpKVk7mVU7rPLO22WflVXWuKywu57sCBww488MDZs+/MrNpdcMIJnZPdBZncgUYfP1O0OlPbfjxtH58mtJGlsfUnTOunLxg7ff6FK7Ng1b/5hfljV5+++jJja/cBZQCImTKQstYpA+dcc3OvGTdmy8BlV/1u/JSOYyYeFMrAwGwZGDTy8UEjn8j9+/igEY+vXKj944jsuYNXJTkr3wfKbx72iY20yFrlzE3r/1E/kV+H77zzgQ4dDrvyyus6dOhw9dU3JCcmuwuefnpupnYZCDVgatvHhrULSUawfm7kOXPTMKef+NLoiXNHT3pp1MSQubl/wym5E8OPk+Ym52ZPyS7Xuky+D9QuA2U1y0MmD/lJ6rN5ZQBoHcpAylq3DMw65bKrjhs/tVMoAyMu2n/gBWFOP3zMMytzfq2F/PKqH0fkThkxZvVy0gdS3+DJhpJk9lZ89jfLJh5ZMmqf4j7fqrhtdE1xeQN/15/aNl8GHn74qdABHnzwicyq9xBffPGk5KxQDA4/vOP99z/W4OcRTZgwIfWHLM2YxtafMKEf/9TQcU8PHZf9d1hYGP/UsHFPDRufPSX8uHJh/MrlYdmL5S4Qrnj+BeNqHyyURBkAYqMMpKy1ysCcs2fc2G3KrFMmXnXcRVM7nT/p4BEX7z8oWwbOG/9yktGf/LfOwnmf/DH7xuLeJygDq1Nc1uhZ5f9q6ty1T82iRZnMh+k/5LVMmMmVTTwqzOFKxvys8rHZmZqVbwJu4u/6zz03L0z3b731nvwg8+YtOfbY4/r2HZh8oNCddz5w6qln9OrVq6W/dKx8zvCakqrUf4etnJq3Gvju57QGbGz9CXP60Y/0H/3IgNy//Uc/nF0eFX58OHvKqJCHB6y6QD79w7WGDhv+12deKa5aHlJ7z0ByyiWD2qX++/+UUQaAAikDKWulMnDtnLOvzJaBUydeffxFU484f9IhIy/+Ra4MjL10wYW5jL10fi4Lkqw6JX/uyn/DiUkT6DNhG2UgpPy6PsUDdy4ZvkfDF6hZUTb9lJqSyorbRofZTNXf78+fVTalc3G3/9fYsKUTOlT+5ZoGz6p+/YWK2UNSf+Brm6VdNy2bdnL1q8/WOb2xLx179dXFHTt2mj59Zp3LL1mS6dKl2xlnnJl/D3ErfANx8Vlfqln0Vu2FjSsNdMuapSVlM04PC6Xjfr30zC/UlNXkL1zSf/vSi/63waGqX3mmpP93G7uhsmt7rHMfaGz9yRTwaUJD7+0z9N7e+SRN4JY77knm/coAEDllIGWtUwb6Z8vATX+Ycl2uDEzLlYEJvxx04T59R63x04QmTF568RVLJ0wuDgsTrlhauwkoAyE1b74apviNlYEwa698YGp24bbRxX/YvGzq71eeVf6v4t5bNVEGasr/mala1ti5YVJV+eiNqT/2ZkmDU/kePXoce+xx+SOC6qSq6oNzzhkcLjB37sJM499U0Ix3Mt8BcvsHNrzdMk2kpN93at54uf7ppRf+qnreS5lcGQirbuVDVyWnVz/3SPixsTKQqfmgVm2om5pFi0pG7Zv/o34zpk+fvg2mb+/uYep/zm3d+9/W/Zxc6jeBOpXgnYrlIeP6/zT1p+ZTRhkACqQMpKzVykDvUAamXnfapKtPuHjaby+4/H9DGRh84b59R/2wx9BuZ/fp1qv3mb16d+15dpdsenXpkUuXs8PUf+KMqmymZ/+t0wQ2mjJQMvSHlX+eUTxgx6qn7wvT9LJpJ5f0/25IxZ0XhnPLbxlRcV92VlqzeHFJ/+2TmVPlI9dX3D0+uXrVP/7cWBkoHrhzMvUJZaBs8vFhTpmpfDd79b/MLJtyYr4MlE3pXHLuPiVDds9PucpmnFb1xC3JQuX9U8rGH5Q9SPquccm51a+/WDqhQ+q/t2ZJg2WgZ8+ekydf2fQVQ1Xo2LHTk0++2Jp7BsKqUvP2O9mnYMGbpeMPLO67TXiKq557OLeejCwetEvp+EOq5j6VX6+q/u+2khFtsqtWslOoZkV43ktHtg2nJMcdhdZXNvnYkkG7ZvcgvbOkwVuveurukiHfLxndLqx12VMq3wsz9con5mSvXlxROubnyXFo2dX44WtLBu8Wxq968q7kuhV3jU1W5rKpJ2WPWAvr3oPTy2f2Kpt0dOnY9hVzhi3t8rkwePms3rVvMTzY0gt+mSyHMlB2xQnhwsmPZdNPzT6EXBkIk/vS8QeHBxim+MmjDv2h9Pz9G3344eoTf1v9yjMtsSJNmjStfob1PSbM/s++8cwkYXn48OF3/fHe+k1AGQCipQykrDXLwFm1y8C5E34VykC/0T/qMWynrgMO6tb7gC69fnl6j5+fetZ+J3drd1Iu7bqH2f8V17ybpH4T2GjKQJjqhel4TWl1WA6tIMyzwxSt5u23wxSqev68MK8qvfB/wlkV911e3Osblfdk35laevGh+TlfY2UgzBpLBnwvWQ5loHzO8NJz96587KZMboJV9cwD+TJQ/foLmcyHVS89GaZNySn5w4TCQsmAHapfe67mzVezXaIqt8JU/Lu45xap/96aJZ/m7/rXX39rp05HhObQ+ocJlU39fZgTZ3fghAtULw/PTsmIPcM0vfrFJ0rHHpC/VugGNUtLKv50RWgO2VXlmQdLhv84d+6HyR6GcFb5tWetXENuPbehW88elhPWxpqyTOgeyQpQNffpsCpWL3ijbPLvkl1Pyc2Vzzo7XKzqb3cs7fn1UDxCY8n+4X/x4lADSi/tWPnAtOwN3T2+uMdXqp59aOW1em9Vf89A5cPXhUl/spxdV/96+9Jum2W7SuW7ofCEyrGyDJRWV7+1IDvmHReE1pr55GFC9R9+SPkN51Tcc2mrrV3n9ftZKADdZ54RkuwTmH3bPYvKljWYpAwky+GKrXYnWyjKAFAgZSBlrVMGBlx7S++rsmXg9EnXnDhh+pEXXn7ouZf8asjYn/Qb/eNcGdj2lD7fOKHHl445c9Pfnv7Zw0+p/Q3E02atmH7digabwMZUBpI5TUjp+IPDXCdZLptxepiiZQ/pCVPA8n+GmU3l/VNKL/5NTVlN8cCd8ldvrAxUPXVv/q+kSRmo/OPFpZccFiZ2oRWEqrD6MKGqZaEJVNw+ZmnXTVfejVploPLB6cmJS8/YJP9e5OIeX81O8tL+1X36rPGjRZvOkiWZFN4zUPlecfcvh6csf4GKW0eVjGhTdk33MLNfeuYXkv0/2fVqwRthofqFx0qG7J7JHYhf3HvrsklH5994UDq2fXiKwxXLLu2UX1tqp/qFx8O8P3uBa7oX9/lWfhJfce/E4r7fDutk/TuZXe71zaqX/lZxx/ll009JTgnz+zCtz+TKwOrD1RopA+U39K+YM2zlPQxl4LmHSy85vPLuiyofvbF8Vu/sUKsOEwr/F0KtDb2obPxBmXploM7Dz976Hy/J14xWSFIGVr5zoIAmoAwAEVIGUtZKZWDmLX2umt192vWnX54tA0ddOPnQUZf8z5Cx7UIZ6Dls564Ds2XgxB5fPrbbF357xmc7fqIMJGmwCWxMZWD15GzMz7OfVZJbDhO75K26YcZW+egNpefulZ0F9vpmaAtlM3vmr97onoFFb+U7Q1IGapYsDTPF8hsHVN4zIV8GQg8Js7qK+yaFSVXDZWDVO4mXdvncyjIQ7kaPr25kB6+vc1rzPQMrFyr+XfyHzatfez5/gfJruoXZfJj1Jkn+fp+/VpjQ52fDNcUVYaq9tMfXql97LvyYPUTnlpHJtarmPl3/pisfv7mk//b5kUOdSE6vuGtcGCT5e3ydO5nJlYGaN1+tuHlouGMrx3liTsmY7AQ3Wwamnbz6Wg3uGfjLNcm7hzOrykD4T1E6sm3oAOFu58tA1d/uKB64c2gIFXeNbbAM1H/45TcNDKWi1daNkWf/vP+AAaEGNN0EFpa8nzSBBSXvLyhZFhKu2Gp3soWiDAAFUgZS1spl4IzLr+mcKwO/GXXJAUPGtTvnvD16Dt/lzIHfObXvN0/smS0DR56xScdT82WgR68zQg1orAlslGWg4p5Lc1OlD8OEr2TwbsmMLcyfsm8hmD04k911cGD28KHnH81fvan3DAzYMVOzIrOqDGSSz2bpummY0uXLQOVDVyeHIVW99GT2b/+59xg0XQbC7K32n4QjTyqfJlQ2+fjya/6QqV6evUD18qq/3Zmdf5dUNnit/Gy4Jjx7uQpXNunoyvunhIXyWb2zE+vG3yxe886SbPF48YnaJ1bNfSr77oUlS7Nz8b/MzN9c5VPZj2ENK21yfFr16y+EdTi3m+LDsFYnR7jVKQOhjeT3NuSTfUdEbp3MrCoD2QOEun+5ZESbTLKTIVcGyqaeFJpMJneYUPIegzWWgfDAa+9RaemEOf1Nt94T0kQTSMrAwmwNeF8ZACKkDKSsFcpA0gf6riwD13a+ZMbRYyd3GHXpAUPH7RfKQK/VZeC/a5eBoi4Nzv43+jJQU1xeev7+YQpVfPaW5Vd1XXniGy9nPxg0N4mpuGtsOCuZ4oeUXXZE8cCdlnbbrGTEnslbfmsnd0zFrEytMlD90l+TdwmvPkyouCyMEOZkZZN/FyZb5bOys9imy0B238Kfr0z997aeJJUyUP3G3DARL+63bfGgXar+ensm923HYboc5sTZaXpxRaah2XDlozeWnLNdmGeHi+WKQfYwm7JLO4UiEU4pveTwBm89jB8uUDLqJ9l17On7wlXCaElNrX7t+eKeW4Q7k9xc+ZVnlI5tX9zjK/kPmyq/+szi3luXDNo1ewxSbuWpUwYq7p2YLbp3XFDnRktG71c9f14mXwbCnX/sptB7M7XKQGgR2cGH7B5WyKU9vx4u0HQZCO2ldGTblQ2qVTKk1/5vFr+fz/xcGluufcrQng0csrVhRRkACqQMpKx1ykDSB0K6TL7299kycEWH0Ze2D2Wg/3lteg3ftdug7U7ru2Xnnv/9u27JxQpsAhtNGaif7GQud9j3p0318rLJxzfxYYurbzH39uVM1bKV70lt4pJvvlo+s1fqv6L1J61QBhp9LpaW5GthNlXLMktL13CtmhV1diBkcnsM1rSSfFizpLjpA8PyhzDV3c9Q8e/6t1jn1uuv7TWLF+ePFGoqVe8n180OsqZZflhvw9rbCs9LPsoAwBopAylrtTJQuxI0kQI7wEZfBpoxNSVVuWlcsw2YfVNmC3xS+4abfoNHBnXefxxOSf2OrUOy71Af2bZ2Cr9us38hWrNP3Fu5CYQM6vGLQT2T7B8ysEc2tU/55Om5hKtkowwAsVAGUtbKZaDZk/oGT0RE6kcZAAqkDKRMGRARkWaPMgAUSBlImTIgIiLNHmUAKFBR0NI3YPwm9Bk+tUW3B0cffYrxjW984xs/tvFDGdjQt4/GN77xW2d8ewZS1tJ7BkREJMLYMwAUSBlIWbpl4PXX3xk16sJWvtGamg8XLixPfUspG33Kyt5bsiST+t2IOQMHDl+8uKqJC4RXg+eff2PRoqY++XQ9vNvNkgEDhjV9KwsXln2a8ZUBoEDKQMoKKQNhe5ks/Nd//de+++63+rX+hTeLioo+zWz+scee2X77ld8Q9LnPfe7ZZ1/79Fu46uoVjZ31zjs1hx56+JZbbtWtm4/Jjz0tt1aHPPLI0/vv/6svfvGLN954e+qPdGNN7Wdwu+2233HHnUMuvTT7tcpf+tKXXn75rdoLDWbq1Gu23fY77dsf/OMftwnP1yuvLGri5pp4YSnkWg8++MRnP/vZ731vp623/la4n6eddubSpY1+oUf+bh9ySIdwJ9d4K7VfSGv/ZppOWD8b++V0794n3Mkf/ajh7zUvMMoAUCBlIGVrLANhY/n3v7+cLH/+85/ffPPNX3xxfvLjoEEjwo/rVRl47rl5W221dWPnlpe///zzb/TvP1QZiDwtulaHzJ9fsnBh2X77/VwZaKHUfgZDGXjmmVdqn7t4cVUyIW6iDNxzz1++8pWvhO6X/Niv3+A999yrsWl00y8sjeXyy2ccccTRyXIoA9/85pbJ8oIFpQcccGC7dj9r7Ir5ux0KQ0XFsjXeUFXVB++8U1P/N9N0migD//jHq3fccb8yALQOZSBlTZeBAQOGhTn6rrt+/6yzeocfN91006OPPm7o0FHJud///g86dToqTJseeuhve+/9k2Q7Wlr6bps2bYuL/3XbbfeFydBuu+0+cODw5PJhYZtttv3xj9scf/xJPXv2yzRSBnbf/Yc33HBbuNgOO+wYNkjJueHEadOu3WWX3cLgN998V7JxPfjg3yTnDhs2+rzzxoWFX/7ygE022WSPPfacMeO6xh6UMhB5Clyrw/Ltt//ppz/dP5zSvv3ByWRr0qTpf/jD2ccee+KWW27VtWuPt96qaOKGlIHWeQbrl4HwcvH66+9kas2qn3329X32afeDH/wovApVVma/qPjAA/83P1MPeeWVRUVFRXff/efwOrbddtsnf7YPP4aVIfPJF5annnoprBXhBedb3/r2b37TMfyYaejl6LXX3g4vd6FvhGuFV7baZSDk4YefCjcXTgzLc+bcHR5LuHtXXnl9cm7+bv/+96ddd90tmdyKFx7sySefsfXW3wqvn0888Wx4Jdxhh+8lr5DJXar/m6k/crgnbdvuE67YufOpm222WRO7TcJjVwaA1qEMpGyNewbCpCf/d6Ywbbrllj+GGXmy8evY8ciTTjo9TJuqq1eEzd499/wlnD5lytXHHHNCWGjX7mdhTp9ZtaM8bITCvH/evCULFpQefvhvTzjh5EwjZSBsCH/960Pmzy+55JIrDjjgwPzWMUzClizJ3HTTHV/72tfDmGFbFQpDcm737n369Rucyf1B6xvf+GbTj0gZkELW6kxugpgcTR5WyOnTZ4WFMWPGf+c72z3wwOOhBoQJ4oUXTmjiVpSBlkvtZzCUgfDiMHz4eeeff1FySv3DhI488tiZM28Orxvt2x90//2PhVPCjH/ixGm1xwzrwLhxl4UyEKbpSfe7+ea7fvKTn2Y++cISXrXCNPryy2eUlr7bq9c5oQ9kclPn+i9H4RWswT0DmdyRPGFaHwZJukdoDuHF7dvf3qa8/P1MQ4cJhRXvq1/92p13PlBc/K/NN9/80EMPD2vg+PETw0Lmky+k+d9MgyMfddTvwrodzgpFN/zelAFgfaAMpGxty0Bl5fKvf32Lxx//x6mndp09+878tGnAgGHHHff7sLDPPu3+9KdHw8LQoaPC5nPatGuT615wwcUnnrjyY+zOO29c02Xg+effCAthm73bbrvX2bqHhGEfeuhvyoCscwpcq0NCfZ01a85ee+07YsSYTG5Olqy6IRdffHn79gc3cSvKQMulThkIz86UKVfX/8t6slBW9t4Xv/jF8OR26dK9bdu9w4tVJlcGLrvsEx+svOOOO4fpdSFlIP+qFe5DGDmsP2tbBkItCZP7a6+dHYrlFlt8I9yxkFAP/vjHhzKNlIHjjz8puW649UceeToshBK7994/yTRSBuqPnNxo/q0RTRwmlFEGgFakDKRsbctA+Pf007t16XLWTjvtEjaB+WnTiy/OD5uWsMHbeedd89e9/fY/7bHHnscee2JY7tq1R34KvsYykGyiwsassTIQts3KgKxzClyre/bsd8ABB956672//e0x9cvARRdNOvLIY5u4FWWg5VKnDNQ5TKhOGVi4sCzM72+66Y77738s5NlnXw9nHXTQockhQEnCxfKHCRVeBp5+em7yXoK1LQPhx3Ar4RVv5sybQy1J7ljI/PklmUbKQH7FC7f+6KN/z6ypDNQfeeHC8s985jP5TxBSBoD1hDKQsjWWgV13/X7yx6rMqmlT8rEYYXIflmv/DfUXv/ifbbbZNr+n/u23qzO5v5xtvfW3ks3qD3/446VL/xm2suGS61AGbrnlnrDwf//33A47fC9ZSDau4SbCdjrZ+r75ZvEXvvCFkpJ/N/GIlAEpcK0Oc6k//enR8vL3Dz308OStL2FO9stfHrBkSSZMGQ877Ihp02Y2cSvKQMul9jO4xjIQFvbYY8/hw8+rfZl77324sTcQh9PDq0p4pdp33/2SMlD7hSW8an3961vMnbswLF944YTOnU/NNPJydO21s5ND+TOfLANvvVXx618fkvylf968JZtvvnny5oH6938dykD+N9PgyG3atE1W2rBmbrLJJsoAsD5QBlK2xjIwfvzEsJk599wLMqumTZncn/afe25e5pNlYMaM6z7/+c/nP8K/bdu999pr3/DvpEnTw49hOxo2fmFzuPvuP+zS5ax1KAMnn3zGr37VPmynr776xuTE8OO3v71NqBZhe5xsfTPZ79Q8/gc/+FHYTNZ/LAsXloU5wZZbbrXFFt8IC8nmXCJMgWt1+DdU2bA6de/eJ6xpTz89N8zJwlrdoUOnXXbZ7Wc/+0X+I1zq5Lbb7gsrWJiKffe7O7Rvf1Dqj3fjS+1nsJAyEObo4Xncaadd9tmn3ZAh5yYXmzLl6m222bZ9+4PDrLf2R4sOGDAsvEqEp3jYsNFJGcjUemFJysCJJ54SqsK2237nySdfTC5Q/+UolMbwChb6QLgPSdvcccedd9hhx/AaOHToqOR9zJncvDz0hzCtD+tMWHMyn64M1P7N1B95zpy7wy8hXKB//6FN7BkIRfd739tps802C1dM3sG8DlEGgAIpAykr5HsGwiattPTdNV7s8stnHH30cbVPWbSosqrqg9qnJJOn/GFChSfZOoZGUeeD9pL9D3Xy1lsVdW5XpE4KXKvDxZJ3wCfvJM7PyVrhO6Gk6RT4DNbOwoVlyfto8wlP7rPPvl7/2Wyw5iUvLPmZd3jxqfNRpA2+HC1YULrGOxbGefPN4gK/H2CtfjP1Rw7LTXzFQTNGGQAKpAykrBm/gfj73//Bvfc+XMgl17kMFH75Rx/9e5s2bWsn+VuayKdJ7T/QJrn00il11rTU76S0aOp8w9eGnjprb/Ktbc0SZQAokDKQsmYsAyIiIkmUAaBAykDKlAEREWn2KANAgZSBlCkDIiLS7FEGgAIpAylTBkREpNmjDAAFUgZSpgyIiEizRxkACqQMpEwZEBGRZo8yABRIGUiZMiAiIs0eZQAokDKQMmVARESaPcoAUCBlIGXKgIiINHuUAaBAykDKlAEREWn2KANAgZSBlCkDIiLS7FEGgAIpAylTBkREpNmjDAAFUgZSpgyIiEizRxkACqQMpEwZEBGRZo8yABRIGUhZeL2uqUl/syEiIhtNwmZFGQAKpAyk7LXFy8oqP0x9yyEiIhtNyipWvLZoWdrbN2DDoAyk7O3SD15dtDz1LYeIiGw0eWH++2Hjkvb2DdgwKAMp++ijj+cuXBZeuMsqP3S8kIiIrHPCRiRsSl5dtDxsVv7zn7Q3b8AGQhlIX3jJfrv0g9cWZyuBiIjIOidsSsIG5aOP0t6wARuOoqClb8D4xje+8Y1vfOMb3/jGN/56OL49AwAAECllAAAAIqUMAABApJQBAACIlDIAAACRUgYAACBSygAAAERKGQAAgEgpAwAAECllAAAAIqUMAABApJQBAACIlDIAAACRUgYAACBSygAAAERKGQAAgEgpAwAAECllAAAAIqUMAABApJQBAACIlDIAAACRUgYAACBSygAAAERKGQAAgEgpAwAAECllAAAAIqUMAABApJQBAACIlDIAAACRUgYAACBSygAAAESqKGjpGzC+8Y1vfOMb3/jGN77xjb8ejm/PAAAAREoZAACASCkDAAAQKWUAAAAipQwAAECklAEAAIiUMgAAAJFSBgAAIFLKAAAAREoZAACASCkDAAAQKWUAAAAipQwAAECklAEAAIiUMgAAAJFSBgAAIFLKAAAAREoZAACASCkDAAAQKWUAAAAipQwAAECklAEAAIiUMgAAAJFSBgAAIFLKAAAAREoZAACASCkDAAAQKWUAAAAipQwAAECklAEAAIiUMgAAAJEqClr6BoxvfOMb3/jGN77xjW9846+H49szAAAAkVIGAAAgUsoAAABEShkAAIBIKQMAABApZQAAACKlDAAAQKSUAQAAiJQyAAAAkVIGAAAgUsoAAABEShkAAIBIKQMAABApZQAAACKlDAAAQKSUAQAAiJQyAAAAkVIGAAAgUsoAAABEShkAAIBIKQMAABApZQAAACKlDAAAQKSUAQAAiJQyAAAAkVIGAAAgUsoAAABEShkAAIBIKQMAABApZQAAACKlDAAAQKSKgpa+AeMb3/jGN77xjW984xvf+Ovh+PYMAABApJQBAACIlDIAAACRUgYAACBSygAAAERKGQAAgEgpAwAAECllAAAAIqUMAABApJQBAACIlDIAAACRUgYAACBSygAAAERKGQAAgEgpAwAAECllAAAAIqUMAABApJQBAACIlDIAAACRUgYAACBSygAAAERKGQAAgEgpAwAAECllAAAAIqUMAABApJQBAACIlDIAAACRUgYAACBSygAAAERKGQAAgEgpAwAAEKmioKVvwPjGN77xjW984xvf+MY3/no4vj0DAAAQKWUAAAAipQwAAECklAEAAIiUMgAAAJFSBgAAIFLKAAAAREoZAACASCkDAAAQKWUAAAAipQwAAECklAEAAIiUMgAAAJFSBgAAIFLKAAAAREoZAACASCkDAAAQKWUAAAAipQwAAECklAEAAIiUMgAAAJFSBgAAIFLKAAAAREoZAACASCkDAAAQKWUAAAAipQwAAECklAEAAIiUMgAAAJFSBgAAIFLKAAAARKooaOkbML7xjW984xvf+MY3vvGNvx6Ob88AAABEShkAAIBIKQMAABApZQAAACKlDAAAQKSUAQAAiJQyAAAAkfr/rw0qxFFXupsAAAAASUVORK5CYII=">
  <context confirmationNeeded="false" name="Default"/>
  <parameters>
    <elementParameter field="TEXT" name="JOB_RUN_VM_ARGUMENTS" value=" -Xms512M -Xmx2048M "/>
    <elementParameter field="CHECK" name="JOB_RUN_VM_ARGUMENTS_OPTION" value="true"/>
    <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="tMysqlInput" componentVersion="0.102" offsetLabelX="0" offsetLabelY="0" posX="160" posY="96">
    <elementParameter field="TEXT" name="UNIQUE_NAME" value="tMysqlInput_1"/>
    <elementParameter field="CHECK" name="START" value="true"/>
    <elementParameter field="CHECK" name="END_OF_FLOW" value="false"/>
    <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="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="TYPE" value="MYSQL"/>
    <elementParameter field="TEXT" name="USER" value="&quot;myron&quot;"/>
    <elementParameter field="TEXT" name="PASS" value="&quot;orchard&quot;"/>
    <elementParameter field="TECHNICAL" name="SCHEMA:SCHEMA_TYPE" value="REPOSITORY"/>
    <elementParameter field="TECHNICAL" name="SCHEMA:REPOSITORY_SCHEMA_TYPE" value="_JBGnYEYzEeOd6b-xkgEtPw - hfa_publishing_license_responses"/>
    <elementParameter field="DBTABLE" name="TABLE" value="&quot;hfa_publishing_license_responses&quot;"/>
    <elementParameter field="QUERYSTORE_TYPE" name="QUERYSTORE" value="&quot;&quot;"/>
    <elementParameter field="TECHNICAL" name="QUERYSTORE:REPOSITORY_QUERYSTORE_TYPE" value=""/>
    <elementParameter field="TECHNICAL" name="QUERYSTORE:QUERYSTORE_TYPE" value="BUILT_IN"/>
    <elementParameter field="GUESS_SCHEMA" name="GUESS_SCHEMA" value="&quot;&quot;"/>
    <elementParameter field="MEMO_SQL" name="QUERY" value="&quot;SELECT * FROM `hfa_publishing_license_responses` WHERE &#xA;`response_filename`&#xA; IN (&#xA;'/HFA/OrchardAdmin_Outgoing/Orchard_DGL_Requests_1',&#xA;'Orchard_DGL_Requests_5.csv',&#xA;'Orchard_DGL_Requests_2.csv',&#xA;'Orchard_DGL_Requests_6.csv',&#xA;'Orchard_DGL_Requests_3.csv',&#xA;'/HFA/OrchardAdmin_Outgoing//Orchard_DGL_Requests_7',&#xA;'Orchard_DGL_Requests_4.csv')&quot;"/>
    <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="MAPPING_TYPE" name="MAPPING" value="mysql_id"/>
    <elementParameter field="TEXT" name="PROPERTIES" value="&quot;noDatetimeStringSync=true&quot;"/>
    <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="CHECK" name="ENABLE_STREAM" value="true"/>
    <elementParameter field="CHECK" name="TRIM_ALL_COLUMN" value="false"/>
    <elementParameter field="TABLE" name="TRIM_COLUMN">
      <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_definied_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"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="id"/>
      <elementValue elementRef="TRIM" value="false"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="created_date"/>
      <elementValue elementRef="TRIM" value="false"/>
      <elementValue elementRef="SCHEMA_COLUMN" value="response_filename"/>
      <elementValue elementRef="TRIM" value="false"/>
    </elementParameter>
    <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_publishing_license_responses" name="tMysqlInput_1">
      <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="true" 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="60" 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="10" name="exact_per_publisher_share" nullable="true" pattern="" precision="0" sourceType="INT" type="id_Integer" 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="true" 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="" 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=""/>
      </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_definied_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" 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 comment="" key="true" length="19" name="id" nullable="false" pattern="" precision="0" sourceType="BIGINT" type="id_Long" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
      <column comment="" defaultValue="CURRENT_TIMESTAMP" key="false" length="19" name="created_date" 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="100" name="response_filename" nullable="false" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true">
        <additionalField key="Comment" value=""/>
      </column>
    </metadata>
  </node>
  <node componentName="tMap" componentVersion="2.1" offsetLabelX="0" offsetLabelY="0" posX="384" posY="96">
    <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="&quot;/Users/achan/HFA/HFA Historic Data/csv&quot;"/>
    <elementParameter field="IMAGE" name="PREVIEW" value="_Nk-aAEiKEeOMhaL78gMz8w-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="100000"/>
    <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 comment="" connector="FLOW" label="hfa_response_data_1" name="license_export">
      <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="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"/>
    </metadata>
    <nodeData xsi:type="MapperData">
      <uiProperties/>
      <varTables sizeState="INTERMEDIATE" name="Var" minimized="true"/>
      <outputTables sizeState="INTERMEDIATE" name="license_export" activateCondensedTool="true" id="_9Bvb8EY-EeOd6b-xkgEtPw - hfa_response_data_1">
        <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" nullable="true"/>
        <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_Integer" 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" nullable="true"/>
        <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_definied_2_track_id " type="id_String" nullable="true"/>
        <mapperTableEntries name="user_defined_3" 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_Integer" 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_definied_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"/>
        <mapperTableEntries name="id" type="id_Long"/>
        <mapperTableEntries name="created_date" type="id_Date"/>
        <mapperTableEntries name="response_filename" type="id_String"/>
      </inputTables>
    </nodeData>
  </node>
  <node componentName="tFileOutputDelimited" componentVersion="0.101" offsetLabelX="0" offsetLabelY="0" posX="576" posY="96">
    <elementParameter field="TEXT" name="UNIQUE_NAME" value="tFileOutputDelimited_1"/>
    <elementParameter field="CHECK" name="END_OF_FLOW" value="true"/>
    <elementParameter field="CHECK" name="USESTREAM" value="false"/>
    <elementParameter field="TEXT" name="STREAMNAME" value="outputStream"/>
    <elementParameter field="FILE" name="FILENAME" value="&quot;/Users/achan/HFA/HFA Historic Data/export/hfa_license_export_ab.csv&quot;"/>
    <elementParameter field="TEXT" name="ROWSEPARATOR" value="&quot;\n&quot;"/>
    <elementParameter field="CHECK" name="OS_LINE_SEPARATOR_AS_ROW_SEPARATOR" value="true"/>
    <elementParameter field="OPENED_LIST" name="CSVROWSEPARATOR" value="&quot;\n&quot;"/>
    <elementParameter field="TEXT" name="FIELDSEPARATOR" value="&quot;,&quot;"/>
    <elementParameter field="CHECK" name="APPEND" value="false"/>
    <elementParameter field="CHECK" name="INCLUDEHEADER" value="true"/>
    <elementParameter field="CHECK" name="COMPRESS" value="true"/>
    <elementParameter field="TECHNICAL" name="SCHEMA:SCHEMA_TYPE" value="REPOSITORY"/>
    <elementParameter field="TECHNICAL" name="SCHEMA:REPOSITORY_SCHEMA_TYPE" value="_9Bvb8EY-EeOd6b-xkgEtPw - hfa_response_data_1"/>
    <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="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="CHECK" name="CREATE" value="true"/>
    <elementParameter field="CHECK" name="SPLIT" value="true"/>
    <elementParameter field="TEXT" name="SPLIT_EVERY" value="500000"/>
    <elementParameter field="CHECK" name="FLUSHONROW" value="false"/>
    <elementParameter field="TEXT" name="FLUSHONROW_NUM" value="1"/>
    <elementParameter field="CHECK" name="ROW_MODE" value="false"/>
    <elementParameter field="ENCODING_TYPE" name="ENCODING" value="&quot;US-ASCII&quot;"/>
    <elementParameter field="TECHNICAL" name="ENCODING:ENCODING_TYPE" value="CUSTOM"/>
    <elementParameter field="CHECK" name="DELETE_EMPTYFILE" value="false"/>
    <elementParameter field="TEXT" name="SCHEMA_OPT_NUM" value="90"/>
    <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="tFileOutputDelimited_1">
      <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"/>
    </metadata>
  </node>
  <connection connectorName="FLOW" label="row1" lineStyle="0" metaname="tMysqlInput_1" offsetLabelX="0" offsetLabelY="0" source="tMysqlInput_1" 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_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=""/>
    </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="license_export" lineStyle="0" metaname="license_export" offsetLabelX="0" offsetLabelY="0" source="tMap_1" target="tFileOutputDelimited_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="license_export"/>
  </connection>
  <subjob>
    <elementParameter field="TEXT" name="UNIQUE_NAME" value="tMysqlInput_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>
