<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:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:"Segoe UI";
panose-1:2 11 5 2 4 2 4 2 2 3;}
@font-face
{font-family:"Roboto Mono";}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
code
{mso-style-priority:99;
font-family:"Courier New";}
span.xgmailsignatureprefix
{mso-style-name:x_gmail_signature_prefix;}
span.EmailStyle22
{mso-style-type:personal-compose;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;
mso-ligatures:none;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
/* List Definitions */
@list l0
{mso-list-id:1048341442;
mso-list-type:hybrid;
mso-list-template-ids:-1746926768 67698689 67698691 67698693 67698689 67698691 67698693 67698689 67698691 67698693;}
@list l0:level1
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:2.0in;
text-indent:-.25in;
font-family:Symbol;}
@list l0:level2
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:2.5in;
text-indent:-.25in;
font-family:"Courier New";}
@list l0:level3
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:3.0in;
text-indent:-.25in;
font-family:Wingdings;}
@list l0:level4
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:3.5in;
text-indent:-.25in;
font-family:Symbol;}
@list l0:level5
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:4.0in;
text-indent:-.25in;
font-family:"Courier New";}
@list l0:level6
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:4.5in;
text-indent:-.25in;
font-family:Wingdings;}
@list l0:level7
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:5.0in;
text-indent:-.25in;
font-family:Symbol;}
@list l0:level8
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:5.5in;
text-indent:-.25in;
font-family:"Courier New";}
@list l0:level9
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:6.0in;
text-indent:-.25in;
font-family:Wingdings;}
@list l1
{mso-list-id:1070731435;
mso-list-template-ids:1310380892;}
@list l1:level1
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l1:level2
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:1.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:"Courier New";
mso-bidi-font-family:"Times New Roman";}
@list l1:level3
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:1.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l1:level4
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:2.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l1:level5
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:2.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l1:level6
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:3.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l1:level7
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:3.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l1:level8
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:4.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l1:level9
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:4.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l2
{mso-list-id:1366446998;
mso-list-type:hybrid;
mso-list-template-ids:-950616210 67698689 67698691 67698693 67698689 67698691 67698693 67698689 67698691 67698693;}
@list l2:level1
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:Symbol;}
@list l2:level2
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:"Courier New";}
@list l2:level3
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:Wingdings;}
@list l2:level4
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:Symbol;}
@list l2:level5
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:"Courier New";}
@list l2:level6
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:Wingdings;}
@list l2:level7
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:Symbol;}
@list l2:level8
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:"Courier New";}
@list l2:level9
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:Wingdings;}
ol
{margin-bottom:0in;}
ul
{margin-bottom:0in;}
--></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" style="word-wrap:break-word">
<div class="WordSection1">
<p class="MsoNormal">Hi Steve, <o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></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.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></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.
<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">This was our process in Banner:<o:p></o:p></p>
<ul style="margin-top:0in" type="disc">
<li style="color:#172B4D;margin-top:0in;margin-bottom:0in;mso-list:l1 level1 lfo1;background:white">
<span style="font-size:10.5pt;font-family:"Segoe UI",sans-serif;letter-spacing:-.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><o:p></o:p></span></li><li style="color:#172B4D;margin-top:0in;margin-bottom:0in;mso-list:l1 level1 lfo1;background:white">
<span style="font-size:10.5pt;font-family:"Segoe UI",sans-serif;letter-spacing:-.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. <o:p></o:p></span></li><li style="color:#172B4D;margin-top:0in;margin-bottom:0in;mso-list:l1 level1 lfo1;background:white;margin-top:var(--ds-space-050, 4px)">
<span style="font-size:10.5pt;font-family:"Segoe UI",sans-serif;letter-spacing:-.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.<o:p></o:p></span></li><li style="color:#172B4D;margin-top:0in;margin-bottom:0in;mso-list:l1 level1 lfo1;background:white;margin-top:var(--ds-space-050, 4px)">
<span style="font-size:10.5pt;font-family:"Segoe UI",sans-serif;letter-spacing:-.05pt">then review file responses in
<strong><span style="font-family:"Segoe UI",sans-serif">REACODD</span></strong>- COD Document Control<o:p></o:p></span></li><li style="color:#172B4D;margin-top:0in;margin-bottom:0in;mso-list:l1 level1 lfo1;background:white;margin-top:var(--ds-space-050, 4px)">
<span style="font-size:10.5pt;font-family:"Segoe UI",sans-serif;letter-spacing:-.05pt">To import response (</span><code><span style="font-size:9.0pt;font-family:"Roboto Mono";letter-spacing:-.05pt;border:none windowtext 1.0pt;padding:0in">CRCBMYOP</span></code><span style="font-size:10.5pt;font-family:"Segoe UI",sans-serif;letter-spacing:-.05pt">)
file downloaded using EDConnect use RERCI1A<o:p></o:p></span></li><li style="color:#172B4D;margin-top:0in;margin-bottom:0in;mso-list:l1 level1 lfo1;background:white">
<span style="font-size:10.5pt;font-family:"Segoe UI",sans-serif;letter-spacing:-.05pt">Correct the records with reject error codes in REACAMP<o:p></o:p></span></li><li style="color:#172B4D;margin-top:0in;margin-bottom:0in;mso-list:l1 level1 lfo1;background:white">
<span style="font-size:10.5pt;font-family:"Segoe UI",sans-serif;letter-spacing:-.05pt">Rerun extract process and resubmit corrected records to COD<o:p></o:p></span></li></ul>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Thanks.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Arvin<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<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> Catherine Yu Li <ycli@ucdavis.edu> <br>
<b>Sent:</b> Monday, November 27, 2023 8:28 AM<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>
<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 <<a href="mailto:jose.aguilar@ucr.edu">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">ucwsfiscal@lists.ucmerced.edu</a>><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="1" 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" style="margin-bottom:12.0pt"><span style="font-size:10.0pt"><a href="mailto:smccabe@berkeley.edu" target="_blank">smccabe@berkeley.edu</a></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" style="margin-bottom:12.0pt"><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>