Sample XML and CSV files

This section contains sample XML mapping definition and sample CSV files for User Delegate.

<table-config>
    <table name="WB_USER_DELEGATE" transaction-type="INSERT_UPDATE" key-fields="WBU_ID,WBUDT_ID,WBUD_START_DATE,WBUD_END_DATE,WBUD_REF_WBU_ID" primary-key="WBUD_ID">
        <fields>
            <field index="1" db-field="WBU_ID">
                <reference table-name="WORKBRAIN_USER" supplied-value="WBU_NAME" resolve-to-field="WBU_ID"/>
            </field>
            <field index="2" db-field="WBUDT_ID">
                <reference table-name="WB_USER_DELEGATE_TYPE" supplied-value="WBUDT_NAME" resolve-to-field="WBUDT_ID"/>
            </field>
            <field index="3" db-field="WBUD_REF_WBU_ID">
                <reference table-name="WORKBRAIN_USER" supplied-value="WBU_NAME" resolve-to-field="WBU_ID"/>
            </field>
            <field index="4" db-field="WBUD_REF_WBROLE_ID">
                <reference table-name="WORKBRAIN_ROLE" supplied-value="WBROLE_NAME" resolve-to-field="WBROLE_ID"/>
            </field>
            <field index="5" db-field="WBUD_START_DATE" date-format="yyyyMMdd" default-value="!SYSTEM_DATE"/>
            <field index="6" db-field="WBUD_END_DATE" date-format="yyyyMMdd" default-value="30000101"/>
        </fields>
    </table>
</table-config>

LUCTALL,ALTERNATE,PAULAGRAY,SUPERVISOR,20221201,20231201