<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<style>
<!--
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:Arial;
color:windowtext;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Hello Datamart users,<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>The Schedule of Expenditures of Federal Awards (SEFA) fiscal
year 2010 queries have been added to the Repository. Three queries were posted
and their titles and descriptions are as follows:<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><b><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial;font-weight:bold'>SEFA Reports 2010</span></font></b><font
size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>: This query
shows the amounts recorded for Federal Funds. Agencies use this report to
review the amounts recorded on SFMA in a format similar to what is reported for
the SEFA. Agencies are responsible for the final amounts reported on the SEFA.
This data model is only a tool to review information and is not final until
agency certification of the amounts. In addition, this query contains reports
that show additional detail as compared to the other two SEFA queries.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><b><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial;font-weight:bold'>SEFA Reports 2010 Express</span></font></b><font
size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>: This query
shows the amounts recorded for Federal Funds. Agencies use this report to
review the amounts recorded on SFMA in a format similar to what is reported for
the SEFA. Agencies are responsible for the final amounts reported on the SEFA.
This data model is only a tool to review information and is not final until
agency certification of the amounts. In addition, this query is streamlined to
run more efficiently and is recommended for larger agencies.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><b><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial;font-weight:bold'>SEFA Reports 2010 Express YE</span></font></b><font
size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>: This query
shows amounts recorded for Federal Funds. Agencies use this report to review
amounts recorded on SFMA in a format similar to what is reported for the SEFA. <i><span
style='font-style:italic'>The YE report should only be used during Month 13</span></i>.
This report runs off the 'YE GL Detail' Table, which is not updated until Month
13. This table retrieves updated data three times a week during Month 13
– new data becomes available on Monday, Wednesday and Friday. Agencies
are responsible for the final amounts reported on the SEFA. This data model is
only a tool to review information and is not final until agency certification
of the amounts.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Agencies should review their SEFA information on a periodic
basis. These reviews can really help resolve issues prior to year-end.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>If you find any issues with these reports, please do not
hesitate to contact your SARS analyst.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Thanks,<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Aaron Wallace</span></font><o:p></o:p></p>
<p class=MsoNormal><em><i><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Sr. Datamart Business Analyst</span></font></i></em><o:p></o:p></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>DAS-SCD-SARS</span></font><o:p></o:p></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
</div>
</body>
</html>