To ensure the PowerCenter Integration Service extracts accurate information from the XLATTABLE table, each time you use the XLATTABLE table, enter the following information:

When you use the XLATTABLE table as a PeopleSoft source, enter a join override and filter conditions to extract XLATTABLE data.

When you use the XLATTABLE table as a lookup table, enter lookup conditions and a lookup SQL override to extract XLATTABLE data.

Codes defined in the XLATTABLE table can contain more than one definition for a given code. For example, “A” might stand for “Active” in one PeopleSoft record, and it might stand for “Assets” in another. To differentiate between different codes, the XLATTABLE table contains two columns that are directly referenced by PeopleSoft records:

Additional columns define the codes, including the following columns:

For example, a PeopleSoft record contains a column named BD_WKBOOK_TYPE. The column contains codes representing different workbook types, such as A and E.

The following table shows the codes defined in the XLATTABLE table:

In the XLATTABLE table, “BD_WKBOOK_TYPE” identifies the codes in the FIELDVALUE column. Definitions of these codes appear in the XLATSHORTNAME and XLATLONGNAME columns. The short description of the “A” workbook type is “Assets.” The long description is “Assets Workbook.”