Mapping of Columns in a Database table
Can anyone explain the mapping of the columns in a database table to their particular destination? We are using RTC v2.0.0.2, iFix6 on Windows.
We are using SQL Server 2005. Our RTC database is named "rtc". We can open up the database named rtc and export the tables from it. One table is named "MODEL.WORK_ITEM". This appears to be what RTC Work Items use for their basis. There are a bunch of "Columns" in this table.
Can someone tell me which "Columns" match to which "Fields" in the Work Item? Some are pretty easy to figure out. One is called CREATION_DATE. So, that must "map" to the "Created On:" field in a new Work Item. But there are others that I can't figure out.
Any help with this is appreciated.
Thanks,
-Walter
We are using SQL Server 2005. Our RTC database is named "rtc". We can open up the database named rtc and export the tables from it. One table is named "MODEL.WORK_ITEM". This appears to be what RTC Work Items use for their basis. There are a bunch of "Columns" in this table.
Can someone tell me which "Columns" match to which "Fields" in the Work Item? Some are pretty easy to figure out. One is called CREATION_DATE. So, that must "map" to the "Created On:" field in a new Work Item. But there are others that I can't figure out.
Any help with this is appreciated.
Thanks,
-Walter