SWIFT Update November 23, 2016

SWIFT Data Warehouse Update: New Extract Views Available

New Extract views for the Accounts Receivable, Project and Grant areas are now available in Production.These new X2 views provide for faster running of reports, extracting of data and facilitate incremental loads.

PS_X2_W_RECV_LN to replace PS_X_S_W_RECV_LN
PS_X2_W_RECV_HDR to replace PS_X_S_W_RECV_HDR
PS_X2_W_PROJ_TRNS to replace PS_X_S_W_PROJ_TRNS
PS_X2_W_FEDAIDPRJ to replace PS_X_S_W_FEDAIDPRJ
PS_X2_W_FEDAID to replace PS_X_S_W_FEDAID

Three new fields were added to these views to allow for incremental updates:

CREATED_EW_DTTM
DATA_ORIGIN
LASTUPD_EW_DTTM

The current views will continue to be available to allow agencies time to redirect their extracts and reports to the new views. The current views also have been modified to address some data issues identified. For details about the revised, as well as the new X2 views, refer to the SWIFT Data Warehouse Bulletins page.

OBIEE Update: New Recruiting Solutions Subject Areas and Reports

The SWIFT Data Warehouse has released a suite of reports comprised of Recruiting Solutions data via OBIEE (Oracle Business Intelligence Enterprise Edition), the SWIFT Data Warehouse query and reporting tool. In addition, associated Recruiting Solutions subject areas are available for use with OBIEE analysis.
OBIEE Workforce Subject Area includes:

Recruiting Solutions - Applicant Analysis
Recruiting Solutions - Job Offer
Recruiting Solutions - Job Opening Detail
HCM - Recruiting Solutions - Job Summary

OBIEE FLSA Dashboard includes:

Affirmative Action
Application Detail by Job Openings
Job Offer Detail
Job Opening by Recruiter
Job Opening by Detail
Referral Source by Job Opening

More detail about these reporting resources can be found on the SWIFT Data Warehouse Bulletins page.

Sign Up for SWIFT Classroom Training

Classes are free of charge and open to everyone. You can enroll for this training by opening Employee Self-Service and selecting the Learning folder. Then, search the Catalog using the keyword “SWIFT” to find and enroll in classes currently scheduled. Seats are available in the following classes:

Class	Date	Time
AP Voucher Entry, Maintenance, Approval & Reporting Tools (AP2)	December 19, 2016	8:30 am to 4:00 pm
AP Voucher Entry, Maintenance, Approval & Reporting Tools (AP2)	February 22, 2017	8:30 am to 4:00 pm
AR Direct Journal Deposits (AR/BI3a)	January 25, 2017	8:30 am to 12:00 pm
AR Item Deposits and Applying Payments (AR/BI3b)	January 25, 2017	1:00 pm to 4:30 pm
AR Account Maintenance and Customer Interactions (AR/BI3c)	January 26, 2017	8:30 am to 12:00 pm
Billing Advanced (AR/BI2)	January 5, 2017	8:30 am to 4:00pm
Budget Journal Administration (BC2)	February 2, 2017	8:30 am to 4:00 pm
Create & Manage Purchase Orders for Buyer Roles (PO1)	January 24, 2017	8:30 am to 4:00 pm
Create and Manage Supplier Contracts (SC1)	November 30, 2016	8:30 am to 4:00 pm
Create & Manage Supplier Contracts (SC1)	January 31, 2017	8:30 am to 4:00 pm

SWIFT Help Desk

Contact the SWIFT Help Desk for any questions, concerns or issues you have with SWIFT:
651-201-8100, option 2 or by email SWIFTHelpDesk.MMB@state.mn.us

Hours: 7:30 a.m. to 4:00 p.m., Monday through Friday; closed holidays.

When emailing the SWIFT Help Desk, be sure to include all details regarding the issue. Information to include with your message:

Issue Description
Business Unit
Module (Accounts Payable, Purchase Orders, etc.)
Transaction ID (Voucher ID, PO ID, etc.)
Error Message Print Screen

Additional assistance can be found on the SWIFT Reference Guide page.

SWIFT Training

To find SWIFT training, open Employee Self-Service and select the Learning folder. Then, search the Catalog using the keyword “SWIFT” to find and enroll in classes currently scheduled. Classes are free of charge and open to everyone.

SWIFT Update Mailing List

The SWIFT Update is sent to the SWIFT Newsletter subscription list. Use the links at the bottom of the page to subscribe or unsubscribe to the SWIFT Newsletter subscription list.