1 / 24

SICAS Center Update

SICAS Center Update . Shirley Clark Interim Student/Financial Aid Product Manager Dan Maguffin Student Accounts/General Ledger Solution Specialist. AR/GL Projects. FDR #2009-001 Split Revenue (AC1370/FM909) FDR #2011-007 Auto-Refunding Changes

durin
Download Presentation

SICAS Center Update

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. SICAS Center Update Shirley Clark Interim Student/Financial Aid Product Manager Dan Maguffin Student Accounts/General Ledger Solution Specialist

  2. AR/GL Projects FDR #2009-001 Split Revenue (AC1370/FM909) FDR #2011-007 Auto-Refunding Changes FDR #2012-005 SLSC Agency Payment Invoices/Attorney General Invoices FDR #2012-009 Remittance Advice Re-Write into APIs We don't make Banner. We make Banner Better!

  3. FDR #2009-001 Split Revenue • What is Split Rev? • Baseline vs. SICAS • AC1370/FM909

  4. IFR – IFR Split

  5. IFR – Account B Split

  6. Term Based Detail Codes

  7. Testing • Created detail codes • Post charges • Post payments Day One Testing: • TGRCLOS – Cashier sessions closing • TGRAPPL – Application of Payments • TGRFEED – Accounting Feed process • TSPYAPS - SICAS Summing of Transactions Process Day 2 Testing: • TBRYIFR – SICAS FM 909 Report • TBRYARC – SICAS AC 1370 Rev Class Report • TBRYCSU - SICAS Distribution Charge Summary Report TBRYCHG - SICAS Summary Distribution Report by Charge • TBRYPAY - SICAS Distribution Report by Payment Bundle and package for BETA coming to a campus near you.

  8. FDR 2011-007 Auto-Refunding AutoRefunding is my life TSAYRFD TSRYHLD We didn’t make Banner but IRA FOX makes it Better!

  9. FDR #2011-007 Auto-Refunding • Originally released in 1998 • Title IV Calcs • SOAHOLD • TSAYRFD modifications . • TSRYRFD modifications. • TSRYRFD processing length of time.  Whoever did make Banner…..had a sense of humor!

  10. TSAYRFD We don't make Banner. We make Banner Better!

  11. TSRYRFD Prototype

  12. TSAYEXC/TSIYEXC

  13. Auto-Refunding Focus Group Oneonta; Buffalo State; Binghamton; Fredonia

  14. FDR 2012-005 SLSC Agency Payment AG(*) Invoices

  15. SLSC Process Diagram We don't make Banner. We make Banner Better!

  16. FDR #2012-005 SLSC Agency File Layout Samples We don't make Banner. We make Banner Better!

  17. FDR #2012-005 SLSC Agency Payment Invoices • What’s next? • File layout to import payments to TSAAREV • Focus Group • Bundle and package for BETA We don't make Banner. We make Banner Better!

  18. FDR #2012-009 Remittance Advice Re-Write into APIs • Why? • Last remaining SICAS Pro*COBOL process: RPBYRAP • What is an API? • Application Programming Interface • An API is essentially a database package that encapsulates the business logic surrounding an Banner business entity. • Focus Group: • SUNYIT; New Paltz; Oswego

  19. FDR #2012-009 Remittance Advice Re-Write into APIs • Issues to Resolve: • Disbursement Dates not updating from 31-DEC-2099 to today’s date on Awards/Scholarships • Issues with the Current HE8071 layout: • Layout only contains one Scholarship Literal • TAP Amount for term • Only one field for Total amount of scholarship(s) or other award(s) awarded to student for term (No way to distinguish how much for each if more than one??)

  20. FDR #2012-009 Remittance Advice Re-Write into APIs • 143 144 2 X SCHOLARSHIP PROGRAM Scholarship/fellowship code. • LITERAL Valid entries are: • BY = Byrd • CV = Child of Veteran • FM = Flight 587 Memorial • HC = Regents Health Care • ME = Scholarship for Academic • Excellence ($1500) • MR = Military Service • Recognition • MS= Memorial • MT = Scholarship for Academic • Excellence ($500) NF = McGee Nursing Faculty PO = Professional Opportunity TU = TAP Award VA = Vietnam Veteran/Persian Gulf Veteran VF = Volunteer Recruitment WT = World Trade Center Memorial TS = Math and Science Teaching Incentive Program

  21. FDR #2012-009 Remittance Advice Re-Write into APIs • HE8392 -Student Status Listing has three values: • TAP amount • CV/VA amount • One Scholarship amount • HE8592 – Comprehensive SSL has multiple values: • One Demographic Record • Multiple Financial Aid Program Records (Contains Scholarships from the Consolidated Rosters)

  22. FDR #2012-009 Remittance Advice Re-Write into APIs • How far can SICAS go with the current HE8071 layout? • Only update Disbursement Date? • Create a Comma Separated File as Output? • Questions?

  23. sicas.suny.edu

More Related