Session Number SB5 Intellecheck PDF Pay Stub in

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? • Evisions Intellecheck (http: //www. evisions. com/Products/Intelle. Ch eck. Payment. Processing/Overview. aspx) • FTP Tool to transfer files between servers, MTSAC is using Go. Anywhere Director (http: //www. goanywheremft. com/products/d irector) • Optional – APPWORX (now UC 4) or any job scheduler California Community Colleges Banner Group • 2012

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

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

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

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

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

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

The Steps Involved 2) Read all the different PAY STUB files, and insert the file names to a PIVOT TABLE. C 0003. pdf C 0002. pdf C 0001. pdf File Name Media ID PIDM … C 0001 IC. pdf C 0002 IC. pdf C 0003 IC. 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

The Steps Involved 3) Store the actual PDF files in GORBLOB table. GORBLOB Table PIVOT Table File Name Media ID Check Num PIDM ……. Media ID C 0001 IC. pdf C 0002 IC. pdf C 0003 IC. pdf California Community Colleges Banner Group • 2012 Blot Code BLOB

The Steps Involved As PDFs are saved in GORBLOB, Media ID is being assigned and saved in both tables. PDF PIVOT Table File Name Media ID Check Num PIDM ……. GORBLOB Table Media ID C 0001 IC. pdf C 0002 IC. pdf C 0003 IC. pdf California Community Colleges Banner Group • 2012 Blot Code BLOB

The Steps Involved As PDFs are saved in GORBLOB, Media ID is being assigned and saved in both tables. PDF PIVOT Table File Name Media ID Check Num PIDM ……. GORBLOB Table Media ID C 0001 IC. pdf C 0002 IC. pdf C 0003 IC. pdf California Community Colleges Banner Group • 2012 Blot Code BLOB

The Steps Involved As PDFs are saved in GORBLOB, Media ID is being assigned and saved in both tables. PDF PIVOT Table File Name Media ID Check Num PIDM C 0001 IC. pdf 01 C 0001 ……. GORBLOB Table Media ID Blot Code BLOB 01 PDF <BLOB> C 0002 IC. pdf C 0003 IC. pdf • This has been accomplished by creating a PL/SQL job that calls the GORBLOB API. California Community Colleges Banner Group • 2012

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

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

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

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

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

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

Q&A California Community Colleges Banner Group • 2012