You need to change the status column in the table to a calculated field. This will need to be calculated like:
Case when publishingdatetime
This will result in 0 if pending or 1 if published.
If you prefer you can replace the 0 and 1 in the calculation to pending or published and then the status column will return the text instead