YEAR END CLOSEPurpose:The Year End Close (YEC) process is performed to finalize the financial results of the fiscal year ending and to calculate the financial balances to be carried over to the next fiscal year.Procedure:FTAs Fiscal Year ends on September 3011 and the Team Web YEC process is performed in October. In order for the YEC process to run smoothly any data discrepancies in database arc researched, identified and corrected. To achieve the goal, several SQL queries are run by either DBA or Help Desk lead to update the production database. The YEC process can be divided into four categories: Disconnect Financial Dialogs, Reconciliation, Rollover activities. Start Up Activities.Disconnect Financial Dialogs:Certain financial screens will be disabled in the Team Web interface and to do this, cripts are run to hide the appropriate menu links on the main page.This category includes the actions required to close all the financial activities for the previous Fiscal Year. This category includes the following steps:1. Reset Reservation: A SQL script is run to zero out all the reservations in Operating_Budget table for the previous Fiscal Year.2. Clear Obligation: All the records in Obligation table are deleted for the previous Fiscal Year. Prior to doing that, a copy of Obligation table is saved as prior_yearvvyy_ Obligation, where yyyy is the year of the closing fiscal period.3. FPC (Financial Purpose Code) Transfers: All the available money has to be transferred to the project before YEC or otherwise; all the undisbursed/unliquidated money associated with the projects has to be deobligated before starting YEC.4. Fund Substitution or Fund Adjustments has to be made on any project, which have been awarded, before starting the YEC.5. Clear all the projects with reservations and no obligations to $0. Zero out the un-obligatcd reservations in Amendnient_Funding table and remove the total and change all ready for award projects back to reservations required.6. Clear all holding pots for recoveries io $0. Clear Dc-obliga(ions for prior Fiscal Years at each Ycar-End- Close. Create table prior_year_deobligation as select * from deobligationg. Delete from deobligation where Fiscal Year the new fiscal year and aniount0. Then select distinct cost_ctr from session.operbud. Set operbud_sequence up for the new FY by inserting the FY and cost center values. Create another temp (able called scssion.opcrating_budgct_tcmp to update the opcrating_budgct table for carry over the pending balance into quarter 1 of current FY, by selecting value of ql_pending= (sum of FPC transfers in for prior FY - sum of FPC transfer out for prior FY + sum of recoveries for prior FY - sum of