Preface
Configuring PowerExchange for PeopleSoft
Understanding PowerExchange for PeopleSoft
Working with PeopleSoft Sources
Application Source Qualifier for PeopleSoft Sources
Accessing XLATTABLE Data
Creating PeopleSoft Sessions and Workflows
- Configuring a Session for PeopleSoft Sources
- Scheduling a Workflow
Appendix A: Datatype Reference
- PeopleSoft and Transformation Datatypes
Appendix B: PeopleSoft Language Codes
- PeopleSoft Language Codes
Appendix C: Glossary
- PeopleSoft Glossary of Terms

PowerExchange for PeopleSoft User Guide for PowerCenter

10.5.7
- 10.5.8
- 10.5.6
- 10.5.4
- 10.5
- 10.4.0

Back Next

Handling EFFSEQ when Extracting Current Rows

Some effective dated PeopleSoft records include effective sequence columns. The effective sequence column, EFFSEQ, is used when multiple rows become effective on the same date. When you extract current rows from the effective dated records, the PowerCenter Integration Service selects the row with the most recent date in the effective sequence.

Rename Saved Search

Table of Contents

PowerExchange for PeopleSoft User Guide for PowerCenter

PowerExchange for PeopleSoft User Guide for PowerCenter

Handling EFFSEQ when Extracting Current Rows

Handling EFFSEQ when Extracting Current Rows