Hi Jim, It's probably me not understanding the data structure or maybe the example XML is missing some elements, but I can't see where all the columns map to the XML nodes.
In your ID table, you have a column id. does that map to the XML node /ID/NO ? If so then I don't see the point of this table.
Also in your project table you have a column PROJECTID and a column ID, where do they map to? I can only see /ID/Program/Project/ID.
Is the example XML missing any nodes?