<div dir="ltr">Hi All,<div><br></div><div>Thank you for the responses! It sounds like some schools are able to submit this month, but UCB won't be the only one submitting a file in December. We will likely submit ours next week or so.</div><div><br></div><div>Penny, we have around 150 students impacted by the Oracle bug that excludes names with spaces but we intend to manually add the names to the XML file and to change the <Birthdate> label to <BirthDate> per a different Oracle bug.</div><div><br></div><div>Cheers,</div><div>Steve</div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Mon, Nov 27, 2023 at 2:35 PM Arvin Tumonong <<a href="mailto:atumonong@ucmerced.edu" target="_blank">atumonong@ucmerced.edu</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div>
<div lang="EN-US">
<div>
<p class="MsoNormal">Hi Steve, <u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">Our systems team to be safe assumed the deadline was sooner than the end of the year so we target submission by end of November. I think it may be by the end of December.<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">After few bug fixes, UC Meced was able to send our file to COD using the Banner functionality (even though we don’t use Student Employment module in Banner) last week. We also processed the response files from COD and corrected records
rejected: 1. Missing field values 2. Students with zero amount and negative (COD only accepts >0 amounts) 3. Last name mismatch.
<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">This was our process in Banner:<u></u><u></u></p>
<ul style="margin-top:0in" type="disc">
<li style="color:rgb(23,43,77);margin-top:0in;margin-bottom:0in;background:white">
<span style="font-size:10.5pt;font-family:"Segoe UI",sans-serif;letter-spacing:-0.05pt">Creating a script to insert the FWS paid records onto
<strong><span style="font-family:"Segoe UI",sans-serif">REACAMP (</span></strong>Displays all FWS records created or updated<strong><span style="font-family:"Segoe UI",sans-serif">)</span></strong> from
<strong><span style="font-family:"Segoe UI",sans-serif">YJRWSIN </span></strong><strong><span style="font-family:"Segoe UI",sans-serif;font-weight:normal">(custom table in Banner where I-158 files are saved upon upload to Banner)
</span></strong><strong><span style="font-family:"Segoe UI",sans-serif"> </span></strong><u></u><u></u></span></li><li style="color:rgb(23,43,77);margin-top:0in;margin-bottom:0in;background:white">
<span style="font-size:10.5pt;font-family:"Segoe UI",sans-serif;letter-spacing:-0.05pt">Double check and reconcile total FWS student amounts (comparing them to UC Path DOPE Reports calendar year FWS paid total to verify) in REACAMP. Update/Edit incorrect amounts
manually in REACAMP. <u></u><u></u></span></li><li style="color:rgb(23,43,77);margin-top:0in;margin-bottom:0in;background:white">
<span style="font-size:10.5pt;font-family:"Segoe UI",sans-serif;letter-spacing:-0.05pt">then extract the file using
<strong><span style="font-family:"Segoe UI",sans-serif">RERCB1A (</span></strong>Process will extract calendar year earnings for students
<strong><span style="font-family:"Segoe UI",sans-serif">)</span></strong>. Please review page 46 of the webinar presentation.<u></u><u></u></span></li><li style="color:rgb(23,43,77);margin-top:0in;margin-bottom:0in;background:white">
<span style="font-size:10.5pt;font-family:"Segoe UI",sans-serif;letter-spacing:-0.05pt">then review file responses in
<strong><span style="font-family:"Segoe UI",sans-serif">REACODD</span></strong>- COD Document Control<u></u><u></u></span></li><li style="color:rgb(23,43,77);margin-top:0in;margin-bottom:0in;background:white">
<span style="font-size:10.5pt;font-family:"Segoe UI",sans-serif;letter-spacing:-0.05pt">To import response (</span><code><span style="font-size:9pt;font-family:"Roboto Mono";letter-spacing:-0.05pt;border:1pt none windowtext;padding:0in">CRCBMYOP</span></code><span style="font-size:10.5pt;font-family:"Segoe UI",sans-serif;letter-spacing:-0.05pt">)
file downloaded using EDConnect use RERCI1A<u></u><u></u></span></li><li style="color:rgb(23,43,77);margin-top:0in;margin-bottom:0in;background:white">
<span style="font-size:10.5pt;font-family:"Segoe UI",sans-serif;letter-spacing:-0.05pt">Correct the records with reject error codes in REACAMP<u></u><u></u></span></li><li style="color:rgb(23,43,77);margin-top:0in;margin-bottom:0in;background:white">
<span style="font-size:10.5pt;font-family:"Segoe UI",sans-serif;letter-spacing:-0.05pt">Rerun extract process and resubmit corrected records to COD<u></u><u></u></span></li></ul>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">Thanks.<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">Arvin<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<div style="border-right:none;border-bottom:none;border-left:none;border-top:1pt solid rgb(225,225,225);padding:3pt 0in 0in">
<p class="MsoNormal"><b>From:</b> Catherine Yu Li <<a href="mailto:ycli@ucdavis.edu" target="_blank">ycli@ucdavis.edu</a>> <br>
<b>Sent:</b> Monday, November 27, 2023 8:28 AM<br>
<b>To:</b> UC WS and Fiscal Workgroup <<a href="mailto:ucwsfiscal@lists.ucmerced.edu" target="_blank">ucwsfiscal@lists.ucmerced.edu</a>><br>
<b>Subject:</b> Re: [Ucwsfiscal] FWS COD Reporting - when are you submitting your file?<u></u><u></u></p>
</div>
</div>
<p class="MsoNormal"><u></u> <u></u></p>
<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.
<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></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? <u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></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?<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<p class="MsoNormal" style="background:white"><b><span style="font-size:10pt;font-family:Arial,sans-serif;color:rgb(0,18,55)">Catherine Li</span></b><span style="font-size:12pt;color:black"><u></u><u></u></span></p>
<p class="MsoNormal" style="background:white"><b><span style="font-size:9pt;font-family:Arial,sans-serif;color:rgb(0,18,55)">Associate Director</span></b><b><span style="font-size:9pt;font-family:Arial,sans-serif;color:rgb(29,29,29)"> || </span></b><b><span style="font-size:9pt;font-family:Arial,sans-serif;color:rgb(0,18,55)">Financial
Aid and Scholarships</span></b><b><span style="font-size:9pt;font-family:Arial,sans-serif;color:rgb(29,29,29)"> </span></b><span style="font-size:12pt;color:black"><u></u><u></u></span></p>
<p class="MsoNormal" style="background:white"><span style="font-size:9pt;font-family:Arial,sans-serif;color:black">p. 530-752-6904 | c. 530-400-6274 | w.
<a href="https://financialaid.ucdavis.edu/" target="_blank">financialaid.ucdavis.edu</a> | e. <a href="mailto:ycli@ucdavis.edu" target="_blank">
ycli@ucdavis.edu</a> </span><span style="font-size:12pt;color:black"><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:9pt;font-family:Arial,sans-serif;color:black">One Shields Avenue, Davis, CA 95616 </span><u></u><u></u></p>
</div>
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<div style="border-right:none;border-bottom:none;border-left:none;border-top:1pt solid rgb(225,225,225);padding:3pt 0in 0in">
<p class="MsoNormal"><b>From:</b> Jose A Aguilar <<a href="mailto:jose.aguilar@ucr.edu" target="_blank">jose.aguilar@ucr.edu</a>>
<br>
<b>Sent:</b> Wednesday, November 22, 2023 2:07 PM<br>
<b>To:</b> UC WS and Fiscal Workgroup <<a href="mailto:ucwsfiscal@lists.ucmerced.edu" target="_blank">ucwsfiscal@lists.ucmerced.edu</a>><br>
<b>Subject:</b> Re: [Ucwsfiscal] FWS COD Reporting - when are you submitting your file?<u></u><u></u></p>
</div>
</div>
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<p class="MsoNormal"><span style="font-family:Arial,sans-serif;color:rgb(23,78,134)">Hi Steve,<u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:Arial,sans-serif;color:rgb(23,78,134)"><u></u> <u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:Arial,sans-serif;color:rgb(23,78,134)">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.<u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:Arial,sans-serif;color:rgb(23,78,134)"><u></u> <u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:Arial,sans-serif;color:rgb(23,78,134)">Best,<u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:Arial,sans-serif;color:rgb(23,78,134)">Jose<u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:Arial,sans-serif;color:rgb(23,78,134)"><u></u> <u></u></span></p>
</div>
<div class="MsoNormal" align="center" style="text-align:center">
<hr size="1" width="98%" align="center">
</div>
<div id="m_6505510439013799164m_-6319846003367766311divRplyFwdMsg">
<p class="MsoNormal"><b><span style="color:black">From:</span></b><span style="color:black"> Steven McCabe <<a href="mailto:smccabe@berkeley.edu" target="_blank">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" target="_blank">ucwsfiscal@lists.ucmerced.edu</a>><br>
<b>Subject:</b> [Ucwsfiscal] FWS COD Reporting - when are you submitting your file?</span>
<u></u><u></u></p>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
</div>
<div>
<div>
<p class="MsoNormal">Hello! <u></u><u></u></p>
<div>
<p class="MsoNormal"><u></u> <u></u></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.<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></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.<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">Cheers and Happy Thanksgiving!<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">Steve<br clear="all">
<u></u><u></u></p>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<p class="MsoNormal"><span>-- </span><u></u><u></u></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:10pt">Steve McCabe<br>
Senior Business Systems Analyst</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10pt">University of California Berkeley</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10pt">Financial Aid and Scholarships Office</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-bottom:12pt"><span style="font-size:10pt"><a href="mailto:smccabe@berkeley.edu" target="_blank">smccabe@berkeley.edu</a></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><a href="http://financialaid.berkeley.edu/" target="_blank">financialaid.berkeley.edu/</a><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-bottom:12pt"><u></u> <u></u></p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
_______________________________________________<br>
Ucwsfiscal mailing list<br>
<a href="mailto:Ucwsfiscal@lists.ucmerced.edu" target="_blank">Ucwsfiscal@lists.ucmerced.edu</a><br>
<a href="https://lists.ucmerced.edu/mailman/listinfo/ucwsfiscal" rel="noreferrer" target="_blank">https://lists.ucmerced.edu/mailman/listinfo/ucwsfiscal</a><br>
</div></blockquote></div><br clear="all"><div><br></div><span class="gmail_signature_prefix">-- </span><br><div dir="ltr" class="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><font size="2">Steve McCabe<br>Senior Business Systems Analyst</font></div><div><font size="2">University of California Berkeley</font></div><div><font size="2">Financial Aid and Scholarships Office</font></div><div><font size="2"><a href="mailto:smccabe@berkeley.edu" target="_blank">smccabe@berkeley.edu</a><span title="Call with Google Voice"><span title="Call with Google Voice"><span title="Call with Google Voice"><br></span></span></span></font></div><div><a href="http://financialaid.berkeley.edu/" target="_blank">financialaid.berkeley.edu/</a><br></div><div><br></div><div><font size="2"><span title="Call with Google Voice"><br></span></font></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div>