1.16k likes | 1.33k Views
Postsecondary Education Participants System Training Guide September 2013 Volume III (Visit our webpage @ www2.ed.gov/offices/OSFAP/PEPS). INDEX - Volume III Page Financial Statements : Financial Statement 4
E N D
Postsecondary Education Participants System Training Guide September 2013 Volume III (Visit our webpage @ www2.ed.gov/offices/OSFAP/PEPS)
INDEX - Volume III Page • Financial Statements: • Financial Statement 4 • Surety 25 • Correspondence Log 27 • Case Team Ratio Analysis Worksheet 31 • Tracking 33 • Waiver 36 • Change in Ownership 38 • Direct Loan Program: • Direct Loan Basic Information 40 • Program Review: • Program Review Information 46 • Deficiencies 62 • Reviewer Involvement 64 • Appeal 66
INDEX - Volume III Page • Management Improvement Service 68 • MIS Staff Involvement 75 • MIS Contact Log 77 • MIS Delivery Method 79 • MIS Issues 87 • Audit Resolution: • Tracking 90 • Audit Report 95 • Acceptability Review 104 • Finding 107 • Correspondence 111 • Appeal 113 • Missing Closeout Audit 115
Financial Statements – From the main menu bar select “School”, from the first drop down box select “Financial Statements”, from the second drop down box select “Case Teams” and from the third drop down box select “Financial Statement”.
The “Financial Statement Query” (pepsi105) screen will display. The screen lists all financial statements received by the Department since 1995/1996. Captured below are data fields “Fiscal Year End” to “Conclusion” and a brief definition of each of these data fields is provided on the next page. Furthermore, all the data elements housed on this rather lengthy screen are defined, on subsequent pages.
“FINANCIAL STATEMENT QUERY SCREEN” Data Elements:Current Status – Indicates the current status for the most recent Financial Statement (FS).Fiscal Year End – School’s fiscal year end date.Sch Grp – Indicator if the FS is for a “School Group”.FY End Chg – Indicator if the FS is for a period ending different than 06/30/CCYY.Init – Indicator if the FS is for an initial (new) school to Title IV participation.CIO – Indicator if the FS is for a Change in Ownership.Due Date – Date the FS is due to EZ Audit.Received Date – Date the FS was received by the Department.Reminder Letter Sent Date – Date a letter sent reminding school to submit FS.Delinquent Letter Sent Date – Date of letter sent advising school it failed to submit its FS and/or that the Department has not received the school’s FS.Release Date – Date the FS was released after the first round of QC.Out Come – Status of FS after primary review (i.e. complete or incomplete).Flagged – Indicates some type of concern (i.e. audit score, late refund, etc.).Score – Score of FS from Primary Review (Range +3 to –3).Concl – Conclusion (final determination) after Primary Review.
The ‘middle-screen’ data fields of the “Financial Statement Query” screen are viewed by using the “Horizontal Scroll” bar as we have done on other grid format screens. Captured below, data fields “Flagged Later” to Determination” make up this portion of the screen’s content. A brief definition of this group of data elements is provided on the following page.
“FINANCIAL STATEMENT QUERY SCREEN” Data Elements – (Continued):Flagged Later – Financialstatement was not originally flagged but the School Participation Management Team requested an override; and based on the override request the financial is now flagged.Admin Stay On/Off Dates – Date the audit, financial statement or recert application was placed on/taken off administrative stay.Admin Stay Reason – Reason for the administrative stay which is based on certain pre-established criteria.Determin. Date – Date the School Participation Team Financial Analysts completed their review/final determination.Determination – Code and type of Determination made by the School Participation Management Team Financial Analyst (i.e. without condition, letter of credit, denial, heightened cash monitoring 1, heightened cash monitoring 2 or reimbursement).
The last portion or farthest right of the “Financial Statement Query” screen will display by scrolling as far right as possible. A brief definition for “Financial Analyst” and “Case Team” are provided on the next page. Upon completion of that material, select the “Primary Review” button located on the lower left of the screen. (Note the cursor is in the “06/30/2005” of the Fiscal Year End Date data field; refer to applicable discussion on page 14)
“FINANCIAL STATEMENT QUERY SCREEN” Data Elements – (Continued):Financial Analyst – Name of the School Participation Management Team member responsible for the review and determination of financial statements associated with a school’s eligibility and certification process. Case Team – School Participation Team responsible for the financial statement.
Page 1 of the “Primary Review” screen will display. Data is displayed on this screen once the “Document Receipt and Control Center” (DRCC) has released the financial statement (FS). Remember, the FS data on this screen is the result of which of the FS (i.e. for which fiscal year end) your cursor was on while in the “Financial Statements Query” screen. Select the “Next Page” icon to continue.
Page 2 of the “Primary Review” screen will display with some results of the initial review of the financial statement by ED staff or contractor. Select the “Next Page” icon to continue reviewing data housed within the four (4) pages of the “Primary Review” screens.
Page 3 of the “Primary Review” screen will display. It captures the financial statement’s data ranging from ‘Total Assets’ to ‘Total Expenses’. Select the “Next Page” icon to continue.
Page 4 of the “Primary Review” screen will display. Select the “Incomplete Letter” button at the bottom of the page, left portion.
A forms message displays with an alert stating that the financial statement is complete. Select the “OK” button to dismiss the message.
The “Financial Statement Query” screen will redisplay. Select the “CM Worksheet” button located at the bottom of the screen.
Page 1 of the “Case Team Ratio Analysis Worksheet” screen will display. As suggested by its title, these two (2) screens serve as a worksheet to the Financial Analyst (FA) of a School Participation Management Team. The FA reviews the financial statement and conducts an analysis of its data to determine or derive an ‘acceptability’ conclusion. Select the “Next Page” icon to view Page 2.
Page 2 of the “Case Team Ration Analysis Worksheet” screen displays the summation of much of the financial statement data. Select the “Exit” icon to return back to “Financial Statement Query” screen.
The “Financial Statement Query” screen will redisplay. Select the “Participants” button located at the bottom of the screen.
The “Financial Statement Participant” screen will display. This screen is used to view all the schools within a group; of extreme value should one financial statement be submitted for the group. Select the “Exit” icon to leave this screen.
The “Financial Statement Query” screen will redisplay. Select the “Waiver” button, or the fifth access button located at the bottom of the screen.
Solely for the purpose of providing a visual display of the kind of information that is captured by the data fields of the “Financial Statement and Compliance Audit Waiver” screen, a new example school: ‘Prima Medical Institute – Mesa (OPE ID: 011570)’ is presented below. This school applied for and was granted (06/06/2006) a ‘financial statement and compliance audit’ waiver covering fiscal years 12/31/2004 – 12/31/2006. When your review is complete of this screen, exit this screen and return to the “Financial Statement Query” screen and ‘Arizona Automotive Institute’ data, on the next page.
The “Financial Statement Query” screen will redisplay with ‘Arizona Automotive Institute’, ‘OPE ID: 010847’. The far right portion of the screen captures “Stay Reason’ (if applicable), ‘Determination’ descriptions, ‘FA’ names and ‘Case Team’ identifying information. Select the “Exit” icon to continue.
Financial Statements Surety – From the main menu bar select “School”, from the first drop down box select “Financial Statements”, from the second drop down box select “Case Teams” and from the third drop down box select “Surety”.
The “Surety” screen will display the most current surety data for the school. To view all “Surety Requested” and “Surety Received” records for the school’s different “Fiscal/Award Year End” dates, use the “Next Record”/”Previous Record” icons . Select the “Exit” icon to continue.
Financial Statements Correspondence Log – From the main menu bar select “School”, from the first drop down box select “Financial Statements”, from the second drop down box select “Case Teams” and from the third drop down box select “Correspondence Log”.
The “Correspondence Log” screen will display. This screen captures all incoming correspondence via ezAudit for Audits, Financial Statements and supporting documents pertaining to an “EAPP” submission. The screen is displayed in a grid format. Use the “Horizontal Scroll” bar located on the bottom of the screen to view the screen in its entirety.
Continue to use the “Horizontal Scroll” bar located on the bottom of the screen to view more information.
The farthest right portion of the “Correspondence Log” screen ends with the “Case Team” data field and the “Print Letter” button. Select the “Exit” icon to continue.
Financial Statements Case Team Ratio Analysis Worksheet – From the main menu bar select “School”, from the first drop down box select “Financial Statements”, from the second drop down box select “Case Teams” and from the third drop down box select “Case Team Ratio Analysis Worksheet”.
Data associated with the “Case Team Ratio Analysis Worksheet” displays on two screens or has two (2) pages. They are the identical screens /pages of data viewed previously via the “CM Worksheet” button on the “Financial Statement Query” screen. Select the “Exit” icon to review the tracking of financial statements and compliance audits in PEPS.
Financial Statements Tracking – From the main menu bar select “School”, from the first drop down box select “Financial Statements”, from the second drop down box select “Case Teams” and from the third drop down box select “Tracking”.
The “Financial Statement/Audit Tracking” (pepsd143) screen will display. This screen tracks all incoming financial statements and compliance audits. The screen is displayed in a grid format. Use the “Horizontal Scroll” bar located on the bottom of the screen to view more information.
The last portion of the “Financial Statement/Audit Tracking” screen will display. The farthest right data fields of this screen are the “Pre ACN Receipt Date” field and the “Referral” button. Select the “Exit” icon to return to the PEPS main menu.
Financial Statements Waiver – From the main menu bar select “School”, from the first drop down box select “Financial Statements”, from the second drop down box select “Case Teams” and from the third drop down box select “Waiver”.
The “Financial Statement and Compliance Audit Waiver” (pepsd192) screen will display. Note: This is the exact same screen previously accessed via the “Waiver” button on the “Financial Statement Query” screen. Select the “Exit” icon to return again to the PEPS main menu.
Financial Statements, Change in Ownership – From the main menu bar select “School”, from the first drop down box select “Financial Statements”, from the second drop down box select “Case Teams” and from the third drop down box select “Change in Ownership”.
The “Change in Ownership” (pepsd190) screen will display. This screen serves somewhat as a one-time ‘balance sheet’ for the FA/School Participation Management Team reviewing a school’s ‘eAPP’ request for ‘change of ownership’ approval. Select the “Exit” icon to continue.
Direct Loan Program - From the main menu bar select “School”, from the first drop down box select “Direct Loan Program” and from the second drop down box select “Direct Loan Basic Information”.
The “Direct Loan Basic Information” (pepds131) screen will display. The left side of this bi-sectional screen provides the FDSLP ID number, DUNS number, SEQ NBR, program eligibility status, deferred and withdrawal information, if applicable. Select the “Locations...” button.
The “Location FDSLP ID Numbers” (Pepsd132) screen will display. Select the “Exit” icon.
The “Direct Loan Basic Information” screen will redisplay. Select the “Origination Option...” button below the second section of this screen that captures ‘Direct Loan Participation’ data such as ‘Start Date and Reason’, ‘End Date and Reason’ and ‘Origination Option’ information in a free-form note space.
The “Origination Option Information” (Pepsd133)screen will display with data such as ‘Option Definitions’, ‘Award Year’, ‘Option Start’, and ‘Option End’ date and ‘Reason’ data. Select the “Exit” icon.
The “Direct Loan Basic Information” screen will redisplay. A “Note” button provides access to the “Direct Loan Notes” screen that stores all DLOPS/DL staff notes and comments. Like other buttons, if a “<“ is present to its right, this indicates that there is a written note/comment which is accessible via the button. Select the “Exit” icon to return to the PEPS main menu.
Program Review - From the main menu bar select “School”, from the first drop down box select “Program Review” and from the second drop down box select “Program Review Information”.
The “Program Review Information” (pepsd209) screen will display. The screen displays a list of all program reviews recorded for this ‘OPE-ID’. For this exercise, be sure that you select the “PRCN” (Program Review Control Number) 200321121225 and it is highlighted. Select the “OK” button.
Page 1of 2 “Program Review Information” screens will display. This screen provides an overview of basic Program Review (PR) information: Review Type, Reason, Level, Scope, etc., and review and correspondence dates. Select the “Next Page” icon to continue.
Page 2 of the “Program Review Information” screen will display. It captures ‘award year’ and ‘case team actions’ data, as well as ‘liability’ and ‘repayment’ data. Select the “Current Deficiencies” button to continue.
The “Program Review Deficiencies” screen will display in a grid format. Within this portion of the screen is displayed: ‘deficiencies’- by code and name, ‘liability dollar amount(s)’, ‘formal fine action’, and ‘appeal’ status and ‘revised liability dollar amount(s)’ if applicable. Use the “Horizontal Scroll” bar located on the bottom of the screen to view more information to the right of the screen.