antonio bangloy [email protected] mount san antonio college (mtsac) session number: sb-5
TRANSCRIPT
•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
•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)
•Employees change their home address all the time•Some of the paystubs are being returned•Costs of stamps, forms, printer maintenance and ink (toner)
•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)
•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
Intellecheck generates the PDF Files
PDF Pay Stubs
PDF Pay Stubs
1) Move the PDF Files from Intellecheck Server to the BANNER Server
Intellecheck MAPS Server PDF
Pay Stubs
PDF Pay Stubs
BANNER Server
• This has been accomplished by using a Go Anywhere Director.
2) Read all the different PAY STUB files, and insert the file names to a PIVOT TABLE.
• This has been accomplished by creating a Perl Script to load the File Names of the PDF files
C0002.pdf
C0003.pdf
C0001.pdf
File Name Media ID PIDM …
C0001IC.pdf
C0002IC.pdf
C0003IC.pdf
3) Store the actual PDF files in GORBLOB table.
File Name Media ID
Check Num
PIDM …….
C0001IC.pdf
C0002IC.pdf
C0003IC.pdf
Media ID Blot Code BLOBPIVOT
TableGORBLOB Table
As PDFs are saved in GORBLOB, Media ID is being assigned and saved in both tables.
File Name Media ID
Check Num
PIDM …….
C0001IC.pdf
C0002IC.pdf
C0003IC.pdf
Media ID Blot Code BLOBPIVOT
TableGORBLOB TablePDFPDF
As PDFs are saved in GORBLOB, Media ID is being assigned and saved in both tables.
File Name Media ID
Check Num
PIDM …….
C0001IC.pdf
C0002IC.pdf
C0003IC.pdf
Media ID Blot Code BLOBPIVOT
TableGORBLOB TablePDFPDF
As PDFs are saved in GORBLOB, Media ID is being assigned and saved in both tables.
File Name Media ID
Check Num
PIDM …….
C0001IC.pdf 01 C0001 0001
C0002IC.pdf
C0003IC.pdf
Media ID Blot Code BLOB
01 PDF <BLOB>
PIVOT Table
GORBLOB TablePDFPDF
• This has been accomplished by creating a PL/SQL job that calls the GORBLOB API.
4) Simply use the baseline API to display the stored PDF file via Self-Serivice
gb_large_object
5) Modify the BWPKHPST package so that the PDF option will show up in the PAY STUB Package.
Clicking the PDF icon executes the procedure p_display_blob from gb_large_object package
