SC_Task vs TASK table

[brandimore]

Hello

I am reporting on the SCTASK level and I've seen two sceanrios; one were the sample reports pull from the SC_TASK table and other on the TASK table. I have developed reports on the SC_TASK table for the SCTASKxxxx level and the data appears correctly but I wanted to ask, what is the difference between the two? Also, do you have documentation that has descriptions of all the tables so we can understand it better.

[Brad Tilton · Accepted solution]

There are so many tables, and the tables in your instance vary based on your release and which plugins you have active so there isn't a definitive description. You can go to System Definition > Tables in your instance to see a list of all of the tables in your instance. Also, here are a couple more links that may be helpful:

Task table

Tables module

Schema map for tables