<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=utf-8">
<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:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:"Segoe UI Emoji";
panose-1:2 11 5 2 4 2 4 2 2 3;}
/* 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;}
p.xmsonormal, li.xmsonormal, div.xmsonormal
{mso-style-name:x_msonormal;
margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
span.EmailStyle21
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:windowtext;}
span.EmailStyle22
{mso-style-type:personal-compose;
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="xmsonormal"><span style="font-size:12.0pt">Hello ctcLink FA Crowd, <o:p>
</o:p></span></p>
<p class="xmsonormal"><o:p> </o:p></p>
<p class="xmsonormal"><span style="font-size:12.0pt">Here are a couple of recent developments in ctcLink Financial Aid. Happy Friday!</span><o:p></o:p></p>
<p class="xmsonormal"><span style="font-size:14.0pt"> <o:p></o:p></span></p>
<p class="xmsonormal"><b><u><span style="font-size:16.0pt">Query Corner</span></u></b><span style="font-size:16.0pt"><o:p></o:p></span></p>
<p class="xmsonormal"><span style="font-size:12.0pt"> <o:p></o:p></span></p>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;color:#323130;background:white">Many colleges ask what a query does because the description is so short it's not always easy to tell. The query definition is where the details of a query is stored. If you go
to metalink (</span><span style="font-size:12.0pt;color:black;background:white"><a href="https://dataservicesmetalink.sbctc.edu/">https://dataservicesmetalink.sbctc.edu/</a>)</span><span style="font-size:12.0pt;color:#323130;background:white"> you can view
the definition, records, etc. </span><span style="font-size:12.0pt;font-family:"Segoe UI Emoji",sans-serif;color:#323130;background:white">🙂</span><span style="font-size:12.0pt;color:#323130;background:white"> However, it is often inconvenient to go to a different
system to look up the definition so there is a query that will show you the query definition!</span><span style="font-size:12.0pt;color:black;background:white">
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black;background:white"><br>
<br>
</span><b><span style="font-size:12.0pt;font-family:"Arial",sans-serif;color:black;background:#80FF80"><o:p></o:p></span></b></p>
<div>
<p class="MsoNormal"><b><span style="font-size:12.0pt;font-family:"Arial",sans-serif;color:black;background:#80FFFF">QCS_QUERY_DETAILS</span></b><b><span style="font-size:12.0pt;font-family:"Arial",sans-serif;color:black;background:#80FF80"><br>
<br>
</span></b><b><span style="font-size:12.0pt;color:black;background:#80FF80"><o:p></o:p></span></b></p>
</div>
<div>
<p class="MsoNormal"><b><span style="font-size:12.0pt;color:black;background:#80FF80"><o:p> </o:p></span></b></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black;background:#80FF80">Example of results:<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><b><span style="font-size:12.0pt;color:black;background:#80FF80"><o:p> </o:p></span></b></p>
</div>
<div>
<p class="MsoNormal"><b><span style="font-size:12.0pt;color:black;background:#80FF80"><img border="0" width="893" height="370" style="width:9.302in;height:3.8541in" id="_x0000_i1026" src="cid:image001.png@01D71CCD.C53CF9A0"><o:p></o:p></span></b></p>
</div>
<div>
<p class="MsoNormal"><b><span style="font-size:12.0pt;color:black;background:#80FF80"><o:p> </o:p></span></b></p>
</div>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black;background:white">The Reporting Team updated the FA group security to have access to the records to run this query so everyone should be able to run it now if you weren't able to before.
</span><span style="font-size:12.0pt;font-family:"Segoe UI Emoji",sans-serif;color:black;background:white">🙂</span><b><span style="font-family:"Arial",sans-serif;color:black;background:#80FF80"><br>
<br>
</span></b><o:p></o:p></p>
</div>
<p class="xmsonormal"><b><span style="font-size:12.0pt"> </span></b><o:p></o:p></p>
<p class="xmsonormal"><b><u><span style="font-size:16.0pt">Training Latest & Greatest</span></u></b><span style="font-size:16.0pt"><o:p></o:p></span></p>
<p class="xmsonormal"><span style="font-size:12.0pt"> </span><o:p></o:p></p>
<p class="xmsonormal"><b><span style="font-size:15.0pt;background:white">ctcLink Reference Center materials</span></b><span style="font-size:12.0pt;color:black"><br>
<br>
</span><b><span style="font-size:14.0pt;background:white">Updates to</span></b><span style="font-size:12.0pt;color:black"><br>
<span style="background:white">Update ATB Fields QRG – recommendation to not update any fields other than ATB code</span></span><span style="font-size:12.0pt"><o:p></o:p></span></p>
<p class="xmsonormal"><b><span style="font-size:12.0pt;color:black"><a href="http://ctclinkreferencecenter.ctclink.us/m/92421/l/940861-9-2-update-atb-fields">9.2 Update ATB Fields</a></span></b><span style="font-size:12.0pt"><o:p></o:p></span></p>
<p class="xmsonormal"><span style="font-size:12.0pt;color:black"><br>
<span style="background:white">Dual Processing Business Processing Guide – now includes improved steps for the Dual Processing Withdrawn Query</span></span><span style="font-size:12.0pt"><o:p></o:p></span></p>
<p class="xmsonormal"><b><span style="font-size:12.0pt;color:black"><a href="http://ctclinkreferencecenter.ctclink.us/m/96776/l/1241095-financial-aid-dual-processing-business-processing-guide">Financial Aid Dual Processing Business Processing Guide</a></span></b><span style="font-size:12.0pt"><o:p></o:p></span></p>
<p class="xmsonormal"><span style="font-size:12.0pt;color:black"><br>
<span style="background:white">Manually Reduce a Term Award – covers how to reduce an annual award in one term only</span></span><span style="font-size:12.0pt"><o:p></o:p></span></p>
<p class="xmsonormal"><b><span style="font-size:12.0pt;color:black;background:white"><a href="http://ctclinkreferencecenter.ctclink.us/m/92427/l/933809-9-2-manually-reduce-a-term-award">9.2 Manually Reduce a Term Award</a></span></b><span style="font-size:12.0pt"><o:p></o:p></span></p>
<p class="xmsonormal"><span style="font-size:12.0pt;color:black"><br>
</span><b><span style="font-size:14.0pt;background:white">New!</span></b><span style="font-size:12.0pt;color:black"><br>
<span style="background:white">Student Services Center Financial Aid QRG – how to view the Financial Aid tab in Student Center</span></span><span style="font-size:12.0pt"><o:p></o:p></span></p>
<p class="xmsonormal"><b><span style="font-size:12.0pt;color:black"><a href="http://ctclinkreferencecenter.ctclink.us/m/79750/l/929130-9-2-student-center-financial-aid-services">9.2 Student Center: Financial Aid Services</a></span></b><span style="font-size:12.0pt"><o:p></o:p></span></p>
<p class="xmsonormal"><span style="font-size:12.0pt;color:black"><br>
<span style="background:white">Manually Cancel a Term Award QRG – covers how to cancel an award in one term only, while keeping other term award in tact</span></span><span style="font-size:12.0pt"><o:p></o:p></span></p>
<p class="xmsonormal"><b><span style="font-size:12.0pt"><a href="http://ctclinkreferencecenter.ctclink.us/m/92427/l/1376131-9-2-manually-cancel-a-term-award">9.2 Manually Cancel a Term Award</a></span></b><span style="font-size:12.0pt"><o:p></o:p></span></p>
<p class="xmsonormal"> <o:p></o:p></p>
<p class="xmsonormal"> <o:p></o:p></p>
<p class="xmsonormal"> <o:p></o:p></p>
<p class="xmsonormal"> <o:p></o:p></p>
</div>
</body>
</html>