[ctcLinkfinaidsupport] Please read - Test environment for ISIRs

Mon May 13 11:12:37 PDT 2024

Hi Beth,

I have to use Google Sheets so this might be a separate issue. But mine
stopped working on the 3rd tab after 1,000 students. I dragged the formula
down and haven't had problems since.

Alicia

Thank you!

*Alicia Mallahan, MBA*

Out of Office: May 16, 17

Previous FA Student: Pell, WCG, WSOS, BFET

Executive Director of Financial Aid

she/her/hers

On Mon, May 13, 2024 at 10:04 AM Kelly Forsberg via ctcLinkfinaidsupport <
ctclinkfinaidsupport at lists.ctc.edu> wrote:

> Hi Beth,
>
>
>
> Can you please provide the EMPL you’re seeing on both queries but not
> showing up on the student tab?
>
>
>
> Thanks!
>
>
>
> *Kelly Forsberg*
>
> *ctcLink Functional Trainer | Financial Aid*
>
>
>
> *From:* ctcLinkfinaidsupport <ctclinkfinaidsupport-bounces at lists.ctc.edu> *On
> Behalf Of *Beth Hawes via ctcLinkfinaidsupport
> *Sent:* Monday, May 13, 2024 9:34 AM
> *To:* Alandra R Barker <alandra.barker at wwcc.edu>;
> ctclinkfinaidsupport at lists.ctc.edu; Ana Ybarra <aybarra at sbctc.edu>
> *Cc:* Dani Bundy <dbundy at sbctc.edu>
> *Subject:* Re: [ctcLinkfinaidsupport] Please read - Test environment for
> ISIRs
>
>
>
> *[Sent from outside SBCTC] *
>
>
>
> Thanks Alandra, but I already tried converting all the SSNs and IDs to
> number format and that didn’t resolve the issue. The part that’s confusing
> me is that we are getting results on the Student Info tab – it just seems
> to be missing some.
>
>
>
> Beth Hawes (she, her pronouns)
>
> Director of Financial Aid
>
> Financial Aid - Green River College
> <https://www.greenriver.edu/students/pay-for-college/financial-aid/>
>
> P: 253-333-4978 | SA243
>
>
>
> *From:* Alandra R Barker <alandra.barker at wwcc.edu>
> *Sent:* Monday, May 13, 2024 9:09 AM
> *To:* Beth Hawes <BHawes at greenriver.edu>;
> ctclinkfinaidsupport at lists.ctc.edu; aybarra at sbctc.edu
> *Cc:* Dani Bundy <dbundy at sbctc.edu>
> *Subject:* RE: [ctcLinkfinaidsupport] Please read - Test environment for
> ISIRs
>
>
>
> *CAUTION:* 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 ithelpdesk at greenriver.edu.
>
> Please do not give out or enter your Green River email, network login,
> password information on non-Green River websites.
>
> Good morning Beth!
>
>
>
> One of the issues I’ve had most commonly with my VLOOKUPs is numbers being
> formatted differently on different tabs, so the lookup doesn’t work.
> Typically that has happened if I accidentally click into a cell – the error
> about a  “number stored as text” disappears and the number re-formats
> itself, usually I can tell because the ID is right-aligning in the cell
> unlike the others. (Also a problem if I copy and paste some data from a
> query, but try to match it with manually entered data.) My solution is
> usually copy and paste the data again, just to make sure the formatting is
> consistent. I haven’t done anything is this Excel sheet yet, but the
> formulas seem to be correct and are built just like the ones I struggle
> with.
>
>
>
> Hope that helps!
>
>
>
> Alandra Barker
>
> *Financial Aid Office*
>
> *Financial Aid Specialist*
>
> *Walla Walla Community College*
> 500 Tausick Way, Walla Walla, WA 99362
> Phone: (509) 527-3671
> FA Phone: (509) 527-4301
>
> Fax: (509) 527-1875
> E-mail: financial.aid at wwcc.edu
>
>
>
> *From:* ctcLinkfinaidsupport <ctclinkfinaidsupport-bounces at lists.ctc.edu> *On
> Behalf Of *Beth Hawes via ctcLinkfinaidsupport
> *Sent:* Monday, May 13, 2024 8:30 AM
> *To:* Ana Ybarra <aybarra at sbctc.edu>; ctclinkfinaidsupport at lists.ctc.edu
> *Cc:* Dani Bundy <dbundy at sbctc.edu>
> *Subject:* Re: [ctcLinkfinaidsupport] Please read - Test environment for
> ISIRs
>
>
>
> CAUTION: This email did NOT originate from WWCC. Do not click links or
> open attachments unless you validate the sender and know the content is
> safe. If you are unsure, contact the Help Desk at 509.527.4357 or email
> support at wwcc.edu
>
> Is anyone else having trouble with the VLOOKUP spreadsheet? I loaded data
> into the first two tabs as instructed, and got some results on the Student
> Info tab. However, I was spot checking for a specific student and
> discovered that while they’re on both of the lists pulled straight from
> queries, she isn’t showing up on the third tab. Any idea why she might not
> be showing up on the Student Info tab? We were going to use this list to
> add F02s and determine which student files we should start reviewing.
>
>
>
> Beth Hawes (she, her pronouns)
>
> Director of Financial Aid
>
> Financial Aid - Green River College
> <https://www.greenriver.edu/students/pay-for-college/financial-aid/>
>
> P: 253-333-4978 | SA243
>
>
>
> *From:* ctcLinkfinaidsupport <ctclinkfinaidsupport-bounces at lists.ctc.edu> *On
> Behalf Of *Ana Ybarra via ctcLinkfinaidsupport
> *Sent:* Wednesday, May 8, 2024 8:06 AM
> *To:* ctclinkfinaidsupport at lists.ctc.edu
> *Cc:* Dani Bundy <dbundy at sbctc.edu>
> *Subject:* [ctcLinkfinaidsupport] Please read - Test environment for ISIRs
> *Importance:* High
>
>
>
> *CAUTION:* 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 ithelpdesk at greenriver.edu.
>
> Please do not give out or enter your Green River email, network login,
> password information on non-Green River websites.
>
> Hello FA Community!
>
>
>
> We have completed our testing of the ISIRs in PCD! You may begin loading
> ISIRs into PCD on *Thursday, May 9.*
>
>
>
> Attached is the comprehensive document we have been referring to that will
> assist you with viewing your ISIRs in PCD and getting file review and
> awarding at the ready in PROD if you so choose.
>
>
>
> I’ve also attached the FAQ Technical document from ED
> <https://fsapartners.ed.gov/sites/default/files/2024-03/TechnicalFAQandKnownIssues.pdf>
> that we would strongly advise you read and take note of outstanding issues,
> in tandem with our Contingency document, while you embark on file review
> and awarding. The FAQ document is a really good resource to have at the
> ready moving forward.
>
>
>
> *ISIR VIEW BUGS*
>
> Attached is a spreadsheet titled “PCD remaining ISIR view bugs.” This is a
> list of four items from Oracle that are still “buggy” to which we want to
> draw your attention, with additional notes/explanation for assistance.
>
>
>
> We’re releasing the attached document to you a bit early to afford you all
> some time to bump around in PCD, and get comfortable with the look and feel
> of the new ISIR.
>
>
>
> We see you have a FAC drop-in session Thursday, May 9, at 2 p.m. and we
> think it would be great to leverage that time to walk through the attached
> document, while taking a peek at PCD. Maybe one of the colleges that has
> decided to go this route could share their screen while they load their
> ISIRs?? Just a thought. 😊
>
>
>
> *LOGGING INTO PCD*
>
> Let’s say you haven’t logged into PCD, or it’s been quite some time. You
> will need to first talk to your local security administrator (LSA) to get
> your password reset OR select “Reset Password” option once you log in. If
> you’re having difficulties and your LSA cannot assist, please submit a
> ticket to Security with the following subject line: “PCD ISIR View security
> access”
>
>
>
> *WHAT’S NEXT?*
>
> By now you’re probably wondering, “Ana, when will your team walk us
> through this document and ISIR pages in PCD??”
>
>
>
> We have an answer!
>
>
>
> *Tuesday, 5/14 *
>
> *Morning Session, 9 – 11 AM*
>
> *Tuesday, 5/14*
>
> *Afternoon Session, 1 – 3 PM*
>
> Overview of Alternative Environment (PCD) – Purpose (ISIR only) & Security
> Expectations (what to do if…)  *[AMANDA]*
>
>    - *Q & A Support Time -*
>
> Walk Thru on Available Q&A docs*** *[AMANDA/KELLY]*
>
>    - *Q & A Support Time -*
>
> Walk Thru on 24/25 Contingency Awarding Guide *[KELLY]*
>
>    - *Q & A Support Time -*
>
> Demo on how to use VLOOKUP Spreadsheet *[KELLY]*
>
>    - *Q & A Support Time -*
>
> Open hour for Q & A from colleges *[AMANDA/KELLY]*
>
>    - *Q & A Support Time -*
>
>
>
> *listed below:
>
>
>
>
> *Wednesday, 5/15 Morning Session, 9 – 11 A.M.*
>
>
> *Wednesday, 5/15 Afternoon Session 1 – 3 P.M.*
>
> Overview of Alternative Environment (PCD) – Purpose (ISIR only) & Security
> Expectations (what to do if…)  *[AMANDA]*
>
>    - *Q & A Support Time -*
>
> Walk Thru on Available Q&A docs** [AMANDA/KELLY]*
>
>    - *Q & A Support Time -*
>
> Walk Thru on 24/25 Contingency Awarding Guide *[KELLY]*
>
>    - *Q & A Support Time -*
>
> Demo on how to use VLOOKUP Spreadsheet *[KELLY]*
>
>    - *Q & A Support Time -*
>
> Open hour for Q & A from colleges *[AMANDA/KELLY]*
>
>    - *Q & A Support Time -*
>
>
>
>
>
> ** Q&A docs*
>
>    - HEUG FA Product Advisory Group Google Sheet, tracking all bugs, HEUG
>    Posts, and issues related to FAFSA Simplification:
>    https://docs.google.com/spreadsheets/d/13dnCkWsVtnaNtQHiw8VHxFGYhv9lWzhou2m6ChzfOSo/edit?usp=sharing
>    - Dept of Ed Gen 24/52: (GENERAL-24-52) Update on Access to the
>    2024-25 FAFSA Form for Individuals Without a Social Security Number
>    (Updated May 6, 2024)
>    <https://fsapartners.ed.gov/knowledge-center/library/electronic-announcements/2024-04-30/update-access-2024-25-fafsa-form-individuals-without-social-security-number-updated-may-6-2024>
>
>
>
> Calendar invites with Webex login information are forthcoming to the
> ctclinkfinaidsupport listserv.
>
>
>
> We’ll see you all soon!
>
>
>
>
>
> Peace be with you,
>
>
>
>
>
> [image: Title: SBCTC logo - Description: Compass]Ana Ybarra, MA
>
> Associate Director Campus Solutions - Financial Aid
>
> Washington State Board for Community and Technical Colleges
>
> • o: 360-704-1024
>
>
> --
> ctcLinkfinaidsupport mailing list
> ctcLinkfinaidsupport at lists.ctc.edu
> http://lists.ctc.edu/mailman/listinfo/ctclinkfinaidsupport_lists.ctc.edu
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ctc.edu/pipermail/ctclinkfinaidsupport_lists.ctc.edu/attachments/20240513/c8719f38/attachment-0001.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.png
Type: image/png
Size: 8124 bytes
Desc: not available
URL: <http://lists.ctc.edu/pipermail/ctclinkfinaidsupport_lists.ctc.edu/attachments/20240513/c8719f38/attachment-0001.png>