So the process has to be done automatically and the steps are:
1. Go to Maintenance | General | Data Object
2. Select PeopleSoft Object tab and create a new object. PS Test click Apply then Edit button.
3. Fill the identifier field with 'BUSINESS_UNIT'
4. In table Definition section click New and fill the columns:
Table Name = PS_BUS_UNIT_TBL_GL
SQL Where clause = BUSINESS_UNIT = %%A%% (automatically filled)
Table Key = BUSINESS_UNIT
5. Click Apply. Stat will create a table BO_XX_X in the Stat repository.
6. Click the Create table button. It will open the SQL window where you select the environment from where it takes the table definition
and adding two columns (ARCHIVE_ID, PRIMARY_KEY) that it will need for archive/compare/migration
7. Click Run SQL.
8. Using Toad you can see that the table is created and the data is stored good.
9. Now you can try to archive compare and migration. It works good as well.
