Adding tasks for imported matters

For our Matter Import we need certain tasks added to certain matters from day 1. We can insert into the tasks table, but there is also the dbMSData.OMS2k table and dbManagementAppData tables that need to have data inserted/updated(?). Is there a stored procedure that the AddTask method in the File Management Designer uses that we could use, to ensure that when we need to add these tasks all the relevant tables are updated?If not can you tell me what tables do need to be updated for us to ensure that a task gets added correctly

In addition to the Tasks that need to get added, when a matter is imported it needs to have a milestone plan assigned to it. The additional tables that are used with taskflow are causing us problems (the dbMSData_Omsk2 for example). see attached image. [attachment]oms2k.JPG[/attachment] When we have a matter that is imported, what do we need to do to ensure that the milestone plan is assigned correctly to the matter? any stored proc we can run?

You need to know the MSCode of the Milestone Plan you are wishing to use for the imported matter and ensure this is included on the insert statement. There are no formal documents for this process and as such this is an area where you would need to implement testing as there are elements that you may invoke in your taskflow coding that would fail validation that is beyond our control so full testing is required.
The database error only covers the database level rules and as such you would need to ensure the referential integrity is maintained on data import. Then after this your taskflow may require addidional database entries that we would not be aware of to give advice on.