AnsweredAssumed Answered

Database columns deleted (officially) during past upgrades (e.g., PROJSITE in PPA_WIP)

Question asked by pjromano on Nov 3, 2015
Latest reply on Nov 4, 2015 by pjromano

The database column PROJSITE was deleted from PPA_WIP as per the 7.5.3 to 8.1 change impact and upgrade guide.  However, we have a 14.2 install (not fresh, it started as 7.5 once upon a time, and has gone through several upgrades), and the database column is still there, though it is NULL for all records.  Is this expected behavior?  If so, will repurposing this field to store custom transaction information be a risky proposition?

 

I would assume that fresh installs of 8.1 or later don't have this field, but that upgraded installs still retain it - as well as others that were documented as "deleted" in a prior upgrade.

Outcomes