Appendix: Feed Metadata Table Structures in PeopleTools 8.52

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 database.

See Also

Converting Feed Metadata Between PeopleTools Releases

Click to jump to parent topicFeed Metadata Tables

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.