In which table of Agile database history tab data for each Agile Object stored ?
To see history information for items/manufacturers/mfr parts/etc. (non-routeable objects) look at ITEM_HISTORY.
For changes/psr/qcr/etc. (routable objects, i.e. those with a workflow) look at CHANGE_HISTORY. Note that PPM routable objects can use CHANGE_HISTORY *and* PROGRAM_HISTORY.
You can find the values for ITEM_HISTORY.ACTION by using list ID 4456 (LIST_HISTORYACTION). For CHANGE_HISTORY.EVENT_TYPE, use list ID 4457 (LIST_WORKFLOWEVENT).
Most everything else is object ID values, which you can link to the correct table using ITEM_HISTORY.CLASS or CHANGE_HISTORY.CLASS_ID. NODETABLE comes into into play with CHANGE_HISTORY.PREV_STATUS and NEXT_STATUS. USER_ID links to AGILEUSER, although the full user name is always in USER_NAME, so you don’t need to go get it separately