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.
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.
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
We currently insert the following W-EPM-JOB-GROUP values:
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.