1 / 20

Intellecheck PDF Pay Stub in Self-Service Banner (Technical Session)

Session Number: SB-5. Intellecheck PDF Pay Stub in Self-Service Banner (Technical Session). Antonio Bangloy abangloy@mtsac.edu Mount San Antonio College (MTSAC). California Community Colleges Banner Group • 2012. What you need?.

caviles
Download Presentation

Intellecheck PDF Pay Stub in Self-Service Banner (Technical Session)

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Session Number: SB-5 Intellecheck PDF Pay Stub in Self-Service Banner(Technical Session) Antonio Bangloy abangloy@mtsac.edu Mount San Antonio College (MTSAC) California Community Colleges Banner Group • 2012

  2. What you need? Evisions Intellecheck (http://www.evisions.com/Products/IntelleCheckPaymentProcessing/Overview.aspx) FTP Tool to transfer files between servers, MTSAC is using GoAnywhere Director (http://www.goanywheremft.com/products/director) Optional – APPWORX (now UC4) or any job scheduler California Community Colleges Banner Group • 2012

  3. Overview MTSAC is using Evisions’ Intellecheck to generate paper checks and direct deposit remittance advices. Since Intellecheck is capable of saving them in PDF, posting them to SSB will be ideal to cut cost. Direct Deposit Remittance Advices (Pay Stubs) were being mailed to 4132 employees monthly ($1859.00/month on stamps alone) California Community Colleges Banner Group • 2012

  4. Issues on Mailing Pay Stubs Employees change their home address all the time Some of the paystubs are being returned Costs of stamps, forms, printer maintenance and ink (toner) California Community Colleges Banner Group • 2012

  5. Project To use the exact Pay Stub that employees are used to seeing and receiving every month and make it available through Self-Service Banner To automate the manual processes involved To cut the cost on generating/mailing Pay Stubs To take advantage of Intellecheck feature(s) California Community Colleges Banner Group • 2012

  6. Challenges We have employees with and with out Direct Deposit accounts (security issue – picture deposit) The PDF files (Pay Stubs) reside in Intellecheck Server The PDF files need to be uploaded to a BANNER table, capable enough to handle big files, to be accessed easily from Self Service California Community Colleges Banner Group • 2012

  7. The Plan Intellecheck generates the PDF Files PDF Pay Stubs California Community Colleges Banner Group • 2012

  8. The Steps Involved 1) Move the PDF Files from Intellecheck Server to the BANNER Server PDF Pay Stubs Intellecheck MAPS Server BANNER Server • This has been accomplished by using a Go Anywhere Director. California Community Colleges Banner Group • 2012

  9. The Steps Involved 2) Read all the different PAY STUB files, and insert the file names to a PIVOT TABLE. C0003.pdf C0002.pdf C0001.pdf • This has been accomplished by creating a Perl Script to load the File Names of the PDF files California Community Colleges Banner Group • 2012

  10. The Steps Involved 3) Store the actual PDF files in GORBLOB table. GORBLOB Table PIVOT Table California Community Colleges Banner Group • 2012

  11. The Steps Involved As PDFs are saved in GORBLOB, Media ID is being assigned and saved in both tables. PDF GORBLOB Table PIVOT Table California Community Colleges Banner Group • 2012

  12. The Steps Involved As PDFs are saved in GORBLOB, Media ID is being assigned and saved in both tables. PDF GORBLOB Table PIVOT Table California Community Colleges Banner Group • 2012

  13. The Steps Involved As PDFs are saved in GORBLOB, Media ID is being assigned and saved in both tables. PDF GORBLOB Table PIVOT Table • This has been accomplished by creating a PL/SQL job that calls the GORBLOB API. California Community Colleges Banner Group • 2012

  14. The Steps Involved 4) Simply use the baseline API to display the stored PDF file via Self-Serivice gb_large_object California Community Colleges Banner Group • 2012

  15. The Steps Involved 5) Modify the BWPKHPST package so that the PDF option will show up in the PAY STUB Package. California Community Colleges Banner Group • 2012

  16. How does it work functionally? California Community Colleges Banner Group • 2012

  17. How does it work functionally? California Community Colleges Banner Group • 2012

  18. How does it work functionally? Clicking the PDF icon executes the procedure p_display_blob from gb_large_object package California Community Colleges Banner Group • 2012

  19. How does it work functionally? California Community Colleges Banner Group • 2012

  20. Q & A California Community Colleges Banner Group • 2012

More Related