<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=Windows-1252">
<style type="text/css" style="display:none;"> P {margin-top:0;margin-bottom:0;} </style>
</head>
<body dir="ltr">
<div class="elementToProof" style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Hello! <br>
<br>
</div>
<div class="elementToProof" style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
I am working with our SME who runs the R2T4 process, and they would like to be able to limit the results/outputs of this query to only those accounts who have not been awarded at all. I understand that the updated query was made precisely
<i>to </i>include accounts with awarded aid. However, the change is slowing down the SMEs review process and I'm wondering what this community would recommend in response. Is there a field they can filter to after running or an alternative query that they can
use? Or perhaps there is an optional prompt that could be added to allow them to run it limited to that group? Maybe we are missing something about how results are intended to be used or reviewed? </div>
<div class="elementToProof" style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
Would love to know how other colleges handle this desire and/or what the best path forward/recommendations are for supporting this SME. </div>
<div class="elementToProof" style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div class="elementToProof" style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Thank you!</div>
<div class="elementToProof" style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Kelsey Denton</div>
<div id="appendonsend"></div>
<hr style="display:inline-block;width:98%" tabindex="-1">
<div id="divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" style="font-size:11pt" color="#000000"><b>From:</b> ctcLinkfinaidsupport <ctclinkfinaidsupport-bounces@lists.ctc.edu> on behalf of Molly Groyer via ctcLinkfinaidsupport <ctclinkfinaidsupport@lists.ctc.edu><br>
<b>Sent:</b> Monday, November 18, 2024 10:23 AM<br>
<b>To:</b> ctclinkfinaidsupport@lists.ctc.edu <ctclinkfinaidsupport@lists.ctc.edu>; dirfinaid@lists.ctc.edu <dirfinaid@lists.ctc.edu><br>
<b>Cc:</b> Ryan Kamper <rkamper@sbctc.edu><br>
<b>Subject:</b> [ctcLinkfinaidsupport] NEW R2T4 Query!</font>
<div> </div>
</div>
<style>
<!--
@font-face
{font-family:"Cambria Math"}
@font-face
{font-family:Aptos}
@font-face
{font-family:"Franklin Gothic Book"}
@font-face
{font-family:"Franklin Gothic Medium"}
p.x_MsoNormal, li.x_MsoNormal, div.x_MsoNormal
{margin:0in;
font-size:11.0pt;
font-family:"Aptos",sans-serif}
span.x_EmailStyle17
{font-family:"Aptos",sans-serif;
color:windowtext}
.x_MsoChpDefault
{font-size:11.0pt}
@page WordSection1
{margin:1.0in 1.0in 1.0in 1.0in}
div.x_WordSection1
{}
-->
</style>
<div lang="EN-US" link="#467886" vlink="#96607D" style="word-wrap:break-word">
<div role="alert" style="border:solid #9C6500 1.0pt; padding:2.0pt 2.0pt 2.0pt 2.0pt; margin-bottom:7.5pt; background:#FFEB9C">
<p style="font-family:Arial,Helvetica,sans-serif; font-size:10.0pt; line-height:10.0pt; color:black">
<strong style="font-size:11.0pt; color:#D70000; font-weight:bold">CAUTION:</strong> This email originated from outside of Green River College. Please do not click any links or open attachments unless you know the sender and know the information is safe. Even
if you know the sender, if the request or information seems unusual please check with the sender first before clicking a link or opening the attachment. If you are unsure, contact the IT Help Desk at x6050 or email
<a href="mailto:ithelpdesk@greenriver.edu">ithelpdesk@greenriver.edu</a>. <br>
<br>
Please do not give out or enter your Green River email, network login, password information on non-Green River websites.</p>
</div>
<div>
<div class="x_WordSection1">
<p class="x_MsoNormal">Good morning FA - </p>
<p class="x_MsoNormal"> </p>
<p class="x_MsoNormal">We have a new global Post-Withdrawal Disbursement query: <b>
QCS</b>_FA_POST_WITHDRAWN!<br>
<br>
The new query is similar to <b>CTC</b>_FA_POST_WITHDRAWN but with improvement in criteria and additional fields.<br>
<br>
<b>Criteria change:</b> QCS_FA_POST_WITHDRAWN compared to CTC_FA_POST_WITHDRAWN is not eliminating students who 'had' aid for the prompted term. For colleges like SFCC, that award full year of aid up front, eliminating that population of students may result
in missing students eligible for Post-Withdrawal disbursements.<br>
<br>
<b>New fields:</b><br>
- FINA Requirement checklists still in Initiated status? 'Y' or 'N'<br>
- Last Dt of Att - Stdnt Records from STDNT_CAR_TERM<br>
- Withdraw Code, Withdraw Reason, Withdrawal Date</p>
<p class="x_MsoNormal">- FA Load, FA Taken Units, Enrollment Intensity & Enrollment Intensity Calculate</p>
<p class="x_MsoNormal">- Term<br>
<br>
We also removed the middle name field from the query so we could reduce the amount of data returned & because it wasn’t a necessary field.</p>
<p class="x_MsoNormal"> </p>
<p class="x_MsoNormal">CTC_FA_POST_WITHDRAWN query has been archived.<br>
<br>
<b>Please note:</b> In order to ensure we did not miss any students in the available R2T4 queries & to accommodate business processes for 33 colleges, there may be some students that meet the criteria for multiple R2T4 queries.</p>
<p class="x_MsoNormal"> </p>
<p class="x_MsoNormal">Thank you,</p>
<p class="x_MsoNormal"> </p>
<p class="x_MsoNormal"><span style="font-size:12.0pt"><img width="59" height="91" id="x_Picture_x0020_1" alt="Title: SBCTC logo - Description: Compass" style="width:.6145in; height:.9479in" data-outlook-trace="F:1|T:1" src="cid:image001.png@01DB39A2.153FA7A0">
</span><span style="font-size:14.0pt; font-family:"Franklin Gothic Medium",sans-serif; color:#003764">Molly Groyer</span></p>
<p class="x_MsoNormal"><span style="font-family:"Franklin Gothic Medium",sans-serif; color:#003764">Functional Analyst, Campus Solutions (Financial Aid)</span></p>
<p class="x_MsoNormal" style="text-autospace:none"><span style="font-family:"Franklin Gothic Book",sans-serif; color:#003764">Washington State Board for Community and Technical Colleges</span></p>
<p class="x_MsoNormal" style="text-autospace:none"><span style="font-family:"Franklin Gothic Medium",sans-serif; color:#003764"><a href="mailto:mgroyer@sbctc.edu"><span style="color:#467886">mgroyer@sbctc.edu</span></a>
</span><span style="font-family:"Franklin Gothic Book",sans-serif; color:#003764">• o:
</span><span style="font-family:"Franklin Gothic Book",sans-serif; color:#1F3864">360-704-1058 •</span><span style="font-family:"Franklin Gothic Book",sans-serif; color:#3333FF"><a href="https://www.sbctc.edu/colleges-staff/it-support/default.aspx" originalsrc="https://www.sbctc.edu/colleges-staff/it-support/default.aspx" shash="WI/1KKufSSLB7ZY1wp623qCxmhODoYU52rtL2VV02xo7TZMd8KfDRONclqL0Nofdd/R2K3xXqV4W9D9kY+gDo2NSawLmNIjGegDW7AA2UOprHw3dRVCgahWaTZB7yOgMS0cgGk3sUoADaevW1GTkGGYqRcUoxd0xb4vmRzILwZM="><span style="color:#3333FF">
SBCTC.edu/IT Division</span></a></span><span style="font-size:12.0pt"></span></p>
<p class="x_MsoNormal"> </p>
</div>
</div>
</div>
</body>
</html>