Associated Job sample XML and CSV files

This section contains sample XML mapping definition and sample CSV files for Activity Type Map.

<table-config>
 <table name="ES_JOB_ASSOCIATION" transaction-type="INSERT_UPDATE" key-fields="JOB_ID,JOBASSOC_RANK" primary-key="JOBASSOC_ID">
    <fields>
        <field index="1" db-field="JOB_ID">
            <reference table-name="JOB" supplied-value="JOB_NAME" resolve-to-field="JOB_ID"/>
        </field>
        <field index="2" db-field="JOB_CHILD_ID">
            <reference table-name="JOB" supplied-value="JOB_NAME" resolve-to-field="JOB_ID"/>
        </field>
        <field index="3" db-field="JOBASSOC_FLAG1" />
        <field index="4" db-field="JOBASSOC_FLAG2" />
        <field index="5" db-field="JOBASSOC_FLAG3" />
        <field index="6" db-field="JOBASSOC_FLAG4" />
        <field index="7" db-field="JOBASSOC_FLAG5" />
        <field index="8" db-field="JOBASSOC_UDF1" />
        <field index="9" db-field="JOBASSOC_UDF2" />
        <field index="10" db-field="JOBASSOC_UDF3" />
        <field index="11" db-field="JOBASSOC_UDF4" />
        <field index="12" db-field="JOBASSOC_UDF5" />
        <field index="13" db-field="JOBASSOC_RANK" />
    </fields>
  </table>
</table-config>

INSPECTOR,PLASTIC MOLDING,y,y,N,y,n,UDF1,UDF2,UDF3,UDF4,UDF5,10