Sample XML and CSV file

Sample XML mapping definition

<table-config>
    <table name="ES_BUDG_HRS_PER_PATIENT_DAY" transaction-type="INSERT" primary-key="BHPPD_ID">
        <fields>
            <field index="1" db-field="WBT_ID">
                <reference table-name="WORKBRAIN_TEAM" supplied-value="WBT_ID" resolve-to-field="WBT_ID"/>
            </field>
            <field index="2" db-field="BHPPD_EFF_START_DATE" date-format="yyyy-MM-dd HH:mm:ss" default-value="!SYSTEM_DATE"/>
            <field index="3" db-field="BHPPD_EFF_END_DATE" date-format="yyyy-MM-dd HH:mm:ss" default-value="30000101"/>
            <field index="4" db-field="BHPPD_HOURS" />
            <field index="5" db-field="BHPPD_FLAG1" />
            <field index="6" db-field="BHPPD_FLAG2" />
            <field index="7" db-field="BHPPD_FLAG3" />
            <field index="8" db-field="BHPPD_FLAG4" />
            <field index="9" db-field="BHPPD_FLAG5" />
            <field index="10" db-field="BHPPD_UDF1" />
            <field index="11" db-field="BHPPD_UDF2" />
            <field index="12" db-field="BHPPD_UDF3" />
            <field index="13" db-field="BHPPD_UDF4" />
            <field index="14" db-field="BHPPD_UDF5" />
        </fields>
    </table>
</table-config>

Sample CSV files

1,2022-09-21 00:00:00,2022-09-30 00:00:00,100

1,2022-09-21 00:00:00,2022-09-24 00:00:00,100,Y,N,Y,N,Y,UDF1,UDF2,UDF3,UDF4,UDFTEST

1,2022-09-21 00:00:00,2022-09-24 00:00:00,100,,N,Y,N,,,UDF2,,UDF4,UDFTEST