BPM Process Store creates the following two run-time tables for each process template installed:
An instance level dataslot table, which uses the process template name as the name of the table. It consists of all the instance level dataslot values. It also contains two key fields, PROCESS_TEMPLATE_ID and PROCESS_INSTANCE_ID, used to uniquely identify each row. Every process instance of the same process template has a corresponding row in this table.
A global dataslot table, which uses the PROCESSTEMPLATEID in the name of the table as BS_<ptid>. It consists of all global dataslots for the corresponding PROCESSTEMPLATE. It also contains PROCESS_TEMPLATE_ID as one of the column. Generally, there is only one row in this table when the process template has any global dataslots defined.