Sample XML and CSV files

This section contains sample XML mapping definition and sample CSV files for Job Team.

<table-config>
 <table name="JOB_TEAM" transaction-type="INSERT_UPDATE" key-fields="WBT_ID,JOB_ID" primary-key="JOBTEAM_ID">
    <fields>
        <field index="1" db-field="WBT_ID">
            <reference table-name="WORKBRAIN_TEAM" supplied-value="WBT_NAME" resolve-to-field="WBT_ID"/>
        </field>
        <field index="2" db-field="JOB_ID">
            <reference table-name="JOB" supplied-value="JOB_NAME" resolve-to-field="JOB_ID"/>
        </field>
        <field index="3" db-field="JOBTEAM_DOT_THRESH" />
        <field index="4" db-field="JOBTEAM_WOT_THRESH" />
        <field index="5" db-field="JOBTEAM_AV_HR_RATE" />
        <field index="6" db-field="JOBTEAM_OT_MULT" />
        <field index="7" db-field="JOBTEAM_OT_INC" />
    </fields>
  </table>
</table-config>

PRODUCTIONNORTH,INSPECTOR,10,44,10,1.3,4
PRODUCTIONSOUTH,OPERATOR,22,66,12,1.9,0