Feed Metadata Tables

Note: As of PeopleTools 8.52, feed metadata is stored in tables with names different from previous releases. The UPGPT852PTFP Application Engine program of the PeopleTools 8.52 upgrade process automatically converts pre-8.52 metadata to the 8.52 table structure. Because the old tables are used during the upgrade process and during ad hoc conversions, these tables remain in the PeopleTools 8.52 and later databases.

The following table lists the metadata table names prior to PeopleTools 8.52, new table names in 8.52, and any columns added in 8.52:

Pre-8.52 Table Name

8.52 Table Name

New Columns in 8.52

PS_PTFP_CATEGORY

PSFP_CATEGORY

VERSION

OBJECTOWNERID

PS_PTFP_CATG_LANG

PSFP_CATG_LANG,

PS_PTFP_FEED

PSFP_FEED

VERSION

PTFP_FEED_TEMPLATE

PS_PTFP_FEED_LANG

PSFP_FEED_LANG

PS_PTFP_SETTINGS

PSFP_SETTINGS

PS_PTFP_ADMN_PREF

PSFP_ADMN_PREF

PS_PTFP_USER_PREF

PSFP_USER_PREF

PS_PTFP_SECURITY

PSFP_SECURITY

PS_PTFP_PARMS

PSFP_PARMS

PS_PTFP_PARMS_LANG

PSFP_PARMS_LANG

PS_PTFP_PVALS

PSFP_PVALS

PS_PTFP_PVALS_LANG

PSFP_PVALS_LANG

PS_PTFP_ATTRS

PSFP_ATTRS

PS_PTFP_ATTRS_LANG

PSFP_ATTRS_LANG

PS_PTFP_DATATYPE

PSFP_DATATYPE

VERSION

OBJECTOWNERID

PS_PTFP_DTYPE_LANG

PSFP_DTYPE_LANG

PS_PTFP_DTYPE_ATTR

PSFP_DTYPE_ATTR

PS_PTFP_DATTR_LANG

PSFP_DATTR_LANG

Note: Any direct reference to the pre-8.52 tables in any existing custom implementations must be modified to use the newer tables.