480 likes | 639 Views
Session Number 2 Multiple Year Encumbering 8.0 SunGard Higher Education. Multiple Year Encumbering 8.0. Julie Monfette – Pnpl. Human Resources Consultant California Community College Specialist Jon Langlois - Senior Finance Consultant California Community College Specialist.
E N D
Session Number 2Multiple Year Encumbering 8.0SunGard Higher Education
Multiple Year Encumbering 8.0 • Julie Monfette – Pnpl. Human Resources Consultant California Community College Specialist • Jon Langlois - Senior Finance Consultant California Community College Specialist
Multiple Year Encumbering 8.0 • Allows multiple year encumbering for Grant-related jobs • Requires Banner Finance/Grant and HR/PosnCtl products • Uses Encumbrance Recast method • Restricted to ‘System Calculated’ jobs • Use for Bond Measure project tracking • Banner HR 8.0 release April 2008 Introduction
Multiple Year Encumbering 8.0 Provide a high level overview of : • Banner set up in Banner Finance/Grant and HR/PosnCtl • NBAJOBS use of Banner Finance information • Encumbrance calculations • Current versus future encumbrances Agenda
Multiple Year Encumbering 8.0 continued • Option to feed to Banner Finance • Viewing encumbrances in Banner Finance • Closing and rolling of Banner HR encumbrance within Banner Finance for fiscal year end • Query information Agenda
Multiple Year Encumbering 8.0Benefits • Use Banner Finance Grant information in Banner HR • Match grant budgets to expected expenditures • Project future salary and fringe budgets • Provide accurate year end reports for grants
Multiple Year Encumbering 8.0 Banner set-up
FTMFSYR Create fiscal years for future grant periods NBAFISC Create fiscal years for future grant periods PTRCALN Create payroll calendars for future grant periods System Calculated
FTMFSYR Create fiscal years for future grant periods FTMFUND (FTVFUND) Associate Grant to Fund FTMFTYP Set ‘Encumber Multi Year Labor’ indicator for Fund Type FRMFUND Value will default fromFTMFTYP User may override (Fund is tied to Grant) FRAGRNT (FRBGRNT) Create Grant record Banner Finance Flow
Multiple Year Encumbering 8.0 Identify Fund Types for multi-year encumbering
Multiple Year Encumbering 8.0 Create Grants on FRAGRNT
Multiple Year Encumbering 8.0 Create Funds and tie to Grants on FTMFUND
Multiple Year Encumbering 8.0 FTVFUND additions
Multiple Year Encumbering 8.0 New form FRIFUND
Multiple Year Encumbering 8.0 More of new form FRIFUND
Multiple Year Encumbering 8.0 NBAJOBS use of Banner Finance information
NBAJOBS Information Flow FTVFUND Get Fund code FRMFUND Get Budget Period Start / End dates for Fund code from appropriate effective date <=system Date upon creation NBAJOBS Enter LD FOAPALS associated with grants Display Grant related data If FRMFUND dates are FRAGRNT Project Begin / End Dates (not effective dated)
Multiple Year Encumbering 8.0 Review NBAJOBS
Multiple Year Encumbering 8.0 Grant related information
Multiple Year Encumbering 8.0 Access Finance grant information NBAJOBS
Multiple Year Encumbering 8.0 Encumbrance Calculations
Multiple Year Encumbering 8.0 Checks Banner Finance FRMFUND FTMFUND FRAGRNT
Multiple Year Encumbering 8.0 • The encumbrance calculation begin date for multi-year grants will be based on the greater of the following dates: • The first day of the fiscal year • Job Begin Date • Job Contract Begin Date, or • The Recast Date Encumbrance begin dates used
Multiple Year Encumbering 8.0 Encumbrance end dates used • Currently, the encumbrance calculation end date are based on the earliest of the following dates: • Currently • Job End Date • Job Contract End Date • Fiscal Year end date if the FRMFUND Budget Period End Date and Project End Date are NULL and the Job End Date, Contract End Date or Fund Termination Date do not exist or are beyond the end of the Active Fiscal Year
Multiple Year Encumbering 8.0 Encumbrance end dates used • The encumbrance calculation end date for multi-year grants will be based on the earliest of the following dates: • New to Banner 8.x • The Grant Budget Period End Date • The Fund Termination Date • The Grant Project End Date if Budget Dates are null • The Encumbrance Override End Date
Multiple Year Encumbering 8.0 NBPENCM Report
Multiple Year Encumbering 8.0 Current versus future encumbrances
Multiple Year Encumbering 8.0 Encumbrance Item Numbers • Current 7.X functionality • 0 = ‘Current’ Salary • 1 = ‘Current’ Fringe • 2 = ‘Current’ Fringe Residual • New 8.0 functionality adds • 3 = ‘Future’ Salary • 4 = ‘Future’ Fringe • 5 = ‘Future’ Fringe Residual • Note: Item numbers are assigned by NHPFIN1 process and seen on the FGIENCD form in finance
Multiple Year Encumbering 8.0 Labor Distribution History
Multiple Year Encumbering 8.0 Transaction Detail
Multiple Year Encumbering 8.0 Option to feed to Banner Finance
Multiple Year Encumbering 8.0 Set indicator on NTRINST
Multiple Year Encumbering 8.0 Future projections are still calculated
Multiple Year Encumbering 8.0 Only current fiscal year amounts are fed
NBPENCM • Applies Salary/Fringe Encumbrance to individual labor distributions, • Updates Base Job Encumbrance amounts, and • Creates ‘To Post’ amounts in history record NTRINST Check ‘Feed Future Encumbrance to Finance’ indicator Assign Item Numbers If not interfacing multi-year encumbrance amounts If interfacing multi-year encumbrance amounts ‘To Post’ = current FY encumbrance amount Items 0, 1 & 2 ‘To Post’ = current FY + future FY encumbrance amount Items 0, 1, 2, 3, 4 & 5 NBPENCM encumbrance calculation process
Multiple Year Encumbering 8.0 Review encumbrance detail on FGIENCD
Multiple Year Encumbering 8.0 Review encumbrance detail on FGIENCD
Multiple Year Encumbering 8.0 Closing and rolling Banner HR encumbrances in Banner Finance
Multiple Year Encumbering 8.0 Set up FGAYRLM
Multiple Year Encumbering 8.0 Run FGRLENC in ‘C’ mode & ‘R’ mode
Multiple Year Encumbering 8.0 FGRLENC report
Multiple Year Encumbering 8.0 Query information
Multiple Year Encumbering 8.0 Budget status at year end
Multiple Year Encumbering 8.0 Budget status in new FY
Multiple Year Encumbering 8.0 Grant inception to date
Multiple Year Encumbering 8.0 • Banner set up • NBAJOBS use of Banner Finance information • Encumbrance calculations • Current versus future encumbrances • Option to feed to Banner Finance • Viewing encumbrances in Banner Finance • Closing and rolling of Banner HR encumbrances • Query information Summary
Multiple Year Encumbering 8.0 Questions & Answers
Multiple Year Encumbering 8.0 • Julie Monfette - Julie.Monfette@sungardhe.com • Jon Langlois – Jon.langlois@sungardhe.com