I have come across a table that in my Test upgrade has an extra column and in my Production Upgrade, that column is missing. When did the stat table of STAT_OBJECT_TYPES get the new column of PS_OBJECT TYPE?
This column was added in Stat 5.6.0. Here is the section of the script:
-- C-17) STAT_OBJECT_TYPES
-- (v560)
-- 1) CR0235829 (increase version field on STAT.STAT_OBJECT_TYPES to 98)
-- STAT_OBJECT_TYPES - Increase VERSIONS field from 50 to 98
-- The PT 8.51 release brings the largest value in that field is at 48, and not allowing an addition Psoft version to the table
-- The field needs to be 3(#of versions)-1 at minimum so upping it to 98 will give us the ability to add 12 more Psoft versions
-- DEFAULT ' '
-- 2) CR0235835 (Move PeopleSoft objects-related data from PB/Java code to DB tables.)
-- STAT_OBJECT_TYPES - Initialize new column PS_OBJECT_TYPE in the Data Section where WHERE OBJECT_CLASS = 'P' (NULL with no default)
-- 1)
ALTER TABLE STAT.STAT_OBJECT_TYPES MODIFY (VERSIONS VARCHAR2(98 CHAR));
-- 2)
DECLARE
AlterDone NUMBER;
BEGIN
SELECT COUNT(*) INTO AlterDone FROM USER_TAB_COLUMNS WHERE TABLE_NAME='STAT_OBJECT_TYPES' AND COLUMN_NAME='PS_OBJECT_TYPE';
IF AlterDone < 1 THEN
execute immediate ('ALTER TABLE STAT.STAT_OBJECT_TYPES ADD (PS_OBJECT_TYPE INTEGER)');
END IF;
END;
-------------------------------------------------------------------
