Table of Contents

Search

  1. Preface
  2. Configuring PowerExchange for PeopleSoft
  3. Understanding PowerExchange for PeopleSoft
  4. Working with PeopleSoft Sources
  5. Application Source Qualifier for PeopleSoft Sources
  6. Accessing XLATTABLE Data
  7. Creating PeopleSoft Sessions and Workflows
  8. Appendix A: Datatype Reference
  9. Appendix B: PeopleSoft Language Codes
  10. Appendix C: Glossary

PowerExchange for PeopleSoft User Guide for PowerCenter

PowerExchange for PeopleSoft User Guide for PowerCenter

Entering the XLATTABLE Join Condition

Entering the XLATTABLE Join Condition

In the join override, set the XLATTABLE FIELDVALUE column equal to the column in the PeopleSoft record that contains the codes you want to describe:
XLATTABLE.FIELDVALUE=[RECORD_NAME].[RECORD_COLUMN_NAME]
For example, enter:
XLATTABLE.FIELDVALUE=PS_ALLOC_BASWK_TBL.DEPTID

0 COMMENTS

We’d like to hear from you!