Skip to Main Content
Return to Navigation

Loading Ledger Data into the Operational Warehouse Staging (OWS) Tables

This section discusses how to load subsidiary ledger data into the OWS tables.

Use ETL processing to load source ledgers into the OWS layer of PeopleSoft EPM. You may use the delivered ledger record objects, or you can create your own.

The ledger amounts that you load can use either the period activity balance format or the year-to-date (YTD) balance format, depending on your consolidation ledger format.

Note: When you define each ledger, you specify by account type which amounts are YTD.

See Understanding Ledgers.

For source ledgers that are in the PeopleSoft General Ledger format, you can use the ETL maps that are delivered with the product to load data.

For source ledgers in other formats, you must either create your own maps or modify the existing maps. In many cases you can use the delivered target maps and modify them to conform to your specific record structure. However, you need to establish specific source maps.

Source system ID is a key field in the OWS tables. This enables you to load data from multiple sources into the same OWS tables. It is not necessary to create a physical table in the OWS for each source.