We have a table that shows in PCC with 0 records but when acessed via Brieve there are over 2500 rows in the table. How can we fix this?

Sounds like the DDF isn't pointing to the same data file. If you right click the table in the PCC and select Properties, it will show the Table Location. Make sure it's what you expect. To change it, you can issue an ALTER TABLE statement with USING and IN DICTIONARY clauses. The USING clause tells PSQL which data file to use and the IN DICTIONARY tells it to only affect the DDFs and not the data file too.