<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:m="http://schemas.microsoft.com/office/2004/12/omml" 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 15 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:DengXian;
panose-1:2 1 6 0 3 1 1 1 1 1;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:"\@DengXian";
panose-1:2 1 6 0 3 1 1 1 1 1;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.msonormal0, li.msonormal0, div.msonormal0
{mso-style-name:msonormal;
margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
span.xgmailsignatureprefix
{mso-style-name:x_gmail_signature_prefix;}
span.EmailStyle21
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal">Thank you Steve for checking in. Out IT team is trying to get data in this week but they are running into technical difficulties.
<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Because our payroll data in Banner is accumulated amount by aid year, we had to prepare the “calendar year data” manually in spreadsheet. Our IT told us that Ellucian recommended against scripting data to Banner table REACAMP that is designed
to transmit data to COD. Jose, how did you get your data in that table? <o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">We also learned that COD may allow schools to upload spreadsheet to their site, which surprised me. Did anyone try that route?<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal" style="background:white"><b><span style="font-size:10.0pt;font-family:"Arial",sans-serif;color:#001237">Catherine Li</span></b><span style="font-size:12.0pt;color:black"><o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><b><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#001237">Associate Director</span></b><b><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#1D1D1D"> || </span></b><b><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#001237">Financial
Aid and Scholarships</span></b><b><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#1D1D1D"> </span></b><span style="font-size:12.0pt;color:black"><o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:black">p. 530-752-6904 | c. 530-400-6274 | w.
<a href="https://financialaid.ucdavis.edu/">financialaid.ucdavis.edu</a> | e. <a href="mailto:ycli@ucdavis.edu">
ycli@ucdavis.edu</a> </span><span style="font-size:12.0pt;color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:black">One Shields Avenue, Davis, CA 95616 </span><o:p></o:p></p>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b>From:</b> Jose A Aguilar <jose.aguilar@ucr.edu> <br>
<b>Sent:</b> Wednesday, November 22, 2023 2:07 PM<br>
<b>To:</b> UC WS and Fiscal Workgroup <ucwsfiscal@lists.ucmerced.edu><br>
<b>Subject:</b> Re: [Ucwsfiscal] FWS COD Reporting - when are you submitting your file?<o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif;color:#174E86">Hi Steve,<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif;color:#174E86"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif;color:#174E86">Riverside was planning on sending it this week but the Banner software that was provided has a bug and we are now waiting for Ellucian to provide a patch for this. We plan on sending
it, hopefully in December.<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif;color:#174E86"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif;color:#174E86">Best,<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif;color:#174E86">Jose<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif;color:#174E86"><o:p> </o:p></span></p>
</div>
<div class="MsoNormal" align="center" style="text-align:center">
<hr size="2" width="98%" align="center">
</div>
<div id="divRplyFwdMsg">
<p class="MsoNormal"><b><span style="color:black">From:</span></b><span style="color:black"> Steven McCabe <<a href="mailto:smccabe@berkeley.edu">smccabe@berkeley.edu</a>><br>
<b>Sent:</b> Wednesday, November 22, 2023 1:04 PM<br>
<b>To:</b> UC WS and Fiscal Workgroup <<a href="mailto:ucwsfiscal@lists.ucmerced.edu">ucwsfiscal@lists.ucmerced.edu</a>><br>
<b>Subject:</b> [Ucwsfiscal] FWS COD Reporting - when are you submitting your file?</span>
<o:p></o:p></p>
<div>
<p class="MsoNormal"> <o:p></o:p></p>
</div>
</div>
<div>
<div>
<p class="MsoNormal">Hello! <o:p></o:p></p>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">During a call last week with other schools that use Peoplesoft Campus Solutions, some schools were attempting to send their calendar year 2022 workstudy earnings to COD this month because they interpreted the bit in the guidance that says
"by December" to mean "before" December. Personally I think the guidance says you need to submit by the time the FAFSA becomes available for students; which now appears to be around December 31st.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">UCB is planning on submitting in a few weeks (e.g. mid December) but we are wondering what you all are doing.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Cheers and Happy Thanksgiving!<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">Steve<br clear="all">
<o:p></o:p></p>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<p class="MsoNormal"><span class="xgmailsignatureprefix">-- </span><o:p></o:p></p>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt">Steve McCabe<br>
Senior Business Systems Analyst</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt">University of California Berkeley</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt">Financial Aid and Scholarships Office</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt"><a href="mailto:smccabe@berkeley.edu" target="_blank">smccabe@berkeley.edu</a><br>
<br>
</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><a href="http://financialaid.berkeley.edu/" target="_blank">financialaid.berkeley.edu/</a><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt"><br>
<br>
</span><o:p></o:p></p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</body>
</html>