Loading Metadata

In order to compare the source and target metadata, the selected record metadata attributes need to be extracted from the metadata tables. This creates a baseline of your metadata, against which you can compare changes. You load the metadata required for Alter Analyzer by running the PTALTDATLOAD Application Engine program. PTALTDATLOAD, runs against a subset of PeopleTools metadata tables, storing metadata related to record definitions into the metadata load PeopleTools tables.

Keep in mind that this process is designed for the "alter in place" upgrade process, where the source and target exist within the same physical database. PTALTDATLOAD runs against the current metadata tables, extracts the important record metadata attributes, and creates your metadata baseline. Then future alter processes can be compared against this baseline.

Metadata Load Table

Description

PS_PTRECDEFN

Stores selected values from source PSRECDEFN.

PS_PTRECFIELDDB

Stores selected values from source PSRECFIELDDB.

PS_PTDBFIELD

Stores selected values from source PSDBFIELD.

PS_PTOBJCHNG

Stores selected values from source PSOBJCHNG.

PS_PTOPTIONS

Stores selected values from source PTSOPTIONS.

PS_PTAEAPLTMPTBL

Stores selected values from source PSAEAPLTMPTBL.

PS_PTAEAPPLDEFN

Stores selected values from source PSAEAPPLDEFN.

PS_PTINDEXDEFN

Stores selected values from source PSINDEXDEFN.

PS_PTKEYDEFN

Stores selected values from source PSKEYDEFN.

Note: The metadata load tables exist in PeopleTools 8.50 and later version of PeopleTools.