<?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">
  <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="192" 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/csv&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="192" 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:SCHEMA_TYPE" value="REPOSITORY"/>
    <elementParameter field="TECHNICAL" name="SCHEMA:REPOSITORY_SCHEMA_TYPE" value="_9Bvb8EY-EeOd6b-xkgEtPw - hfa_response_data_1"/>
    <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="" 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="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="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"/>
      <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="448" 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="_lsuAQFbnEeO_gpJnpHO4rA-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_publishing_license_responses" name="row2">
      <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>
    <nodeData xsi:type="MapperData">
      <uiProperties/>
      <varTables sizeState="INTERMEDIATE" name="Var" minimized="true"/>
      <outputTables sizeState="INTERMEDIATE" name="row2">
        <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_definied_2_track_id" expression="row1.user_defined_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"/>
        <mapperTableEntries name="id" type="id_Long"/>
        <mapperTableEntries name="created_date" type="id_Date"/>
        <mapperTableEntries name="response_filename" expression="(String) globalMap.get(&quot;tFileList_1_CURRENT_FILE&quot;)" type="id_String"/>
      </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="736" 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="_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&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="_JBGnYEYzEeOd6b-xkgEtPw - hfa_publishing_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="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_definied_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"/>
      <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="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="created_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="response_filename"/>
      <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_publishing_license_responses" name="tMysqlOutput_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>
    <metadata connector="REJECT" label="hfa_publishing_license_responses" name="REJECT">
      <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>
      <column defaultValue="" key="false" length="255" name="errorCode" nullable="true" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true"/>
      <column defaultValue="" 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="736" 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="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_definied_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"/>
      <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="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="created_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="response_filename"/>
      <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_publishing_license_responses" name="tMysqlOutput_3">
      <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>
      <column defaultValue="" key="false" length="255" name="errorCode" nullable="true" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true"/>
      <column defaultValue="" key="false" length="255" name="errorMessage" nullable="true" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true"/>
    </metadata>
    <metadata connector="REJECT" label="hfa_publishing_license_responses" name="REJECT">
      <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>
      <column defaultValue="" key="false" length="255" name="errorCode" nullable="true" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true"/>
      <column defaultValue="" key="false" length="255" name="errorMessage" nullable="true" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true"/>
    </metadata>
  </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_daate"/>
      <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="row2" lineStyle="0" metaname="row2" 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="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="row2"/>
  </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>
  <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>
</talendfile:ProcessType>
