skip to content
Primary navigation

12 12 12 d

Batch Process Information

A new view is available for users who access the SWIFT Data Warehouse staging (OWS) data layer. The view contains information about the EPM Batch Process including the last update date and time for different segments of the EPM warehouse, both for the OWS and MDW layers.

VIEW

PS-X-W-EPM-BAT-INF - Records are added as part of the EPM batch to record completion date and time for segments of the EPM batch. 

Users can query this view to determine when the last update was made to an EPM Segment of the EPM Warehouse.

FIELDS 

W-EPM-JOB-GROUP - shows the name of the EPM batch segment (See group names listed below) 

LASTUPDDTTM - shows the completion date and time of load to the batch segment

SCHEDULE 

We currently insert the following W-EPM-JOB-GROUP values:

Daily 

OWS-FMS

OWS-HCM-HR 

MDW-FMS 

MDW-HCM-HR

Biweekly 

MDW-HCM-LBR

MDW-HCM-PRL

SECURITY

EPM users who have been granted access to the EPM security roles M-EPM-HCM-LOOKUP or M-EPM-FSCM-LOOKUP have access to the new PS-X-W-EPM-BAT-INF view. 

If you have any questions regarding the new SWIFT Data Warehouse Batch Information view, please contact the SWIFT Help Desk by phone at 651-201-8100, option 2.

back to top