<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=Windows-1252">
<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;}
/* 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:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph
{mso-style-priority:34;
margin-top:0in;
margin-right:0in;
margin-bottom:0in;
margin-left:.5in;
margin-bottom:.0001pt;
mso-add-space:auto;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
p.MsoListParagraphCxSpFirst, li.MsoListParagraphCxSpFirst, div.MsoListParagraphCxSpFirst
{mso-style-priority:34;
mso-style-type:export-only;
margin-top:0in;
margin-right:0in;
margin-bottom:0in;
margin-left:.5in;
margin-bottom:.0001pt;
mso-add-space:auto;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
p.MsoListParagraphCxSpMiddle, li.MsoListParagraphCxSpMiddle, div.MsoListParagraphCxSpMiddle
{mso-style-priority:34;
mso-style-type:export-only;
margin-top:0in;
margin-right:0in;
margin-bottom:0in;
margin-left:.5in;
margin-bottom:.0001pt;
mso-add-space:auto;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
p.MsoListParagraphCxSpLast, li.MsoListParagraphCxSpLast, div.MsoListParagraphCxSpLast
{mso-style-priority:34;
mso-style-type:export-only;
margin-top:0in;
margin-right:0in;
margin-bottom:0in;
margin-left:.5in;
margin-bottom:.0001pt;
mso-add-space:auto;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
p.msonormal0, li.msonormal0, div.msonormal0
{mso-style-name:msonormal;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
p.xxxxxmsonormal, li.xxxxxmsonormal, div.xxxxxmsonormal
{mso-style-name:x_xxxxmsonormal;
margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
p.xxxxxmsolistparagraph, li.xxxxxmsolistparagraph, div.xxxxxmsolistparagraph
{mso-style-name:x_xxxxmsolistparagraph;
margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
span.EmailStyle21
{mso-style-type:personal;
font-family:"Calibri",sans-serif;}
span.EmailStyle22
{mso-style-type:personal;
font-family:"Calibri",sans-serif;}
span.EmailStyle23
{mso-style-type:personal;
font-family:"Calibri",sans-serif;}
span.EmailStyle25
{mso-style-type:personal;
font-family:"Calibri",sans-serif;}
span.EmailStyle26
{mso-style-type:personal-compose;
font-family:"Calibri",sans-serif;}
.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;}
/* List Definitions */
@list l0
{mso-list-id:533538722;
mso-list-template-ids:2086184148;}
@list l0: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 l0:level2
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:1.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l0:level3
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:1.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l0: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 l0: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 l0: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 l0: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 l0: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 l0: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 l1
{mso-list-id:820315452;
mso-list-template-ids:183021964;}
@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:\F0B7;
mso-level-tab-stop:1.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l1:level3
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:1.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@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:1027868539;
mso-list-type:hybrid;
mso-list-template-ids:1167603694 2056525682 67698691 67698693 67698689 67698691 67698693 67698689 67698691 67698693;}
@list l2:level1
{mso-level-start-at:0;
mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:.75in;
text-indent:-.25in;
font-family:Symbol;
mso-fareast-font-family:Calibri;
mso-bidi-font-family:"Courier New";
mso-ansi-font-style:normal;}
@list l2:level2
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:1.25in;
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;
margin-left:1.75in;
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;
margin-left:2.25in;
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;
margin-left:2.75in;
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;
margin-left:3.25in;
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;
margin-left:3.75in;
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;
margin-left:4.25in;
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;
margin-left:4.75in;
text-indent:-.25in;
font-family:Wingdings;}
@list l3
{mso-list-id:1852144265;
mso-list-type:hybrid;
mso-list-template-ids:2061142590 67698703 67698713 67698715 67698703 67698713 67698715 67698703 67698713 67698715;}
@list l3:level1
{mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:1.0in;
text-indent:-.25in;}
@list l3:level2
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:1.5in;
text-indent:-.25in;}
@list l3:level3
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
margin-left:2.0in;
text-indent:-9.0pt;}
@list l3:level4
{mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:2.5in;
text-indent:-.25in;}
@list l3:level5
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:3.0in;
text-indent:-.25in;}
@list l3:level6
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
margin-left:3.5in;
text-indent:-9.0pt;}
@list l3:level7
{mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:4.0in;
text-indent:-.25in;}
@list l3:level8
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
margin-left:4.5in;
text-indent:-.25in;}
@list l3:level9
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
margin-left:5.0in;
text-indent:-9.0pt;}
@list l4
{mso-list-id:2015112613;
mso-list-template-ids:-1683959516;}
@list l5
{mso-list-id:2120250721;
mso-list-template-ids:-1647423732;}
@list l5: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 l5: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 l5:level3
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:1.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l5: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 l5: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 l5: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 l5: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 l5: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 l5: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;}
ol
{margin-bottom:0in;}
ul
{margin-bottom:0in;}
--></style>
</head>
<body lang="EN-US" link="#0563C1" vlink="#954F72">
<div class="WordSection1">
<p class="MsoNormal">Hello FA Users, <o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Please see the announcement below regarding the PCD refresh. In case you are testing any processing or developing any queries.
<o:p></o:p></p>
<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">FA SUPPORT<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> Ctclink_qrydev <ctclink_qrydev-bounces@lists.ctc.edu>
<b>On Behalf Of </b>Emily Mullins via Ctclink_qrydev<br>
<b>Sent:</b> Friday, October 30, 2020 9:13 AM<br>
<b>To:</b> ctclink_qrydev@lists.ctc.edu<br>
<b>Subject:</b> [Ctclink_qrydev] *** LAST REMINDER ***: PCD Refresh – Monday, November 2nd<br>
<b>Importance:</b> High<o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span style="color:#44546A">Just a last friendly reminder that we are going to start doing our query backups at 12:00 p.m. noon today.<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:.5in"><span style="color:#44546A"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#44546A">*** PLEASE DON’T WORK IN PCD UNTIL WE NOTIFY YOU THAT ALL THE REFRESH WORK HAS BEEN COMPLETED AND THAT WE ARE DONE ***<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:.5in"><span style="color:#44546A"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#44546A">Remember, we will only back up:<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:.5in"><span style="color:#44546A"><o:p> </o:p></span></p>
<ol style="margin-top:0in" start="1" type="1">
<li class="MsoListParagraphCxSpFirst" style="color:#44546A;mso-list:l3 level1 lfo3">
In-progress Public and Private queries beginning with DEV_<o:p></o:p></li><li class="MsoListParagraphCxSpMiddle" style="color:#44546A;mso-list:l3 level1 lfo3">
We will not back up any folder<o:p></o:p></li><li class="MsoListParagraphCxSpMiddle" style="color:#44546A;mso-list:l3 level1 lfo3">
Training queries that begin with QXX_TRAIN_<o:p></o:p></li><li class="MsoListParagraphCxSpLast" style="color:#44546A;mso-list:l3 level1 lfo3">
Queries being developed for use in BI Publisher, Pivot Grid, or nVision that have been sent to Data Services via a Service Desk ticket.
<o:p></o:p></li></ol>
<p class="MsoNormal" style="margin-left:.5in"><span style="color:#44546A"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#44546A">Thank you!<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#44546A"><o:p> </o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><b><span style="font-size:12.0pt;color:#1F3864">Emily Mullins<o:p></o:p></span></b></p>
<p class="MsoNormal" style="background:white"><span style="color:#1F3864;background:white">Reporting and BI Solutions Analyst for ctcLink</span><span style="color:#323E4F"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black"><img width="183" height="65" style="width:1.9062in;height:.677in" id="_x0000_i1025" src="cid:image001.png@01D6AE9C.D964A030" alt="cid:image002.png@01D41F5C.C755FAA0"><o:p></o:p></span></p>
<p class="MsoNormal"><b><span style="color:#CCCCCC">_______________________________________________________________<o:p></o:p></span></b></p>
<p class="MsoNormal"><b><span style="color:#1F3864">Washington State Board for Community and Technical Colleges<o:p></o:p></span></b></p>
<p class="MsoNormal"><span style="color:#1F3864">1300 Quince St SE | PO Box 42495 | Olympia, Washington 98504-2495<br>
phone: (360) 704-1035 | email:</span><span style="color:#1F497D"> </span><a href="mailto:emullins@sbctc.edu">emullins@sbctc.edu</a><u><span style="color:blue"><o:p></o:p></span></u></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> Ctclink_qrydev <<a href="mailto:ctclink_qrydev-bounces@lists.ctc.edu">ctclink_qrydev-bounces@lists.ctc.edu</a>>
<b>On Behalf Of </b>Emily Mullins via Ctclink_qrydev<br>
<b>Sent:</b> Wednesday, October 28, 2020 7:00 AM<br>
<b>To:</b> <a href="mailto:ctclink_qrydev@lists.ctc.edu">ctclink_qrydev@lists.ctc.edu</a><br>
<b>Subject:</b> [Ctclink_qrydev] *** REMINDER ***: PCD Refresh – Monday, November 2nd<br>
<b>Importance:</b> High<o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="xxxxxmsonormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#44546A">This is an email reminder about the PCD refresh happening next Monday, November 2<sup>nd</sup>, 2020. Please read the email below.<o:p></o:p></span></p>
<p class="xxxxxmsonormal" style="margin-left:.5in"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#44546A"> <o:p></o:p></span></p>
<p class="xxxxxmsonormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#44546A">Let us know if you have any questions.<o:p></o:p></span></p>
<p class="xxxxxmsonormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><b><span style="font-size:12.0pt;color:#1F3864">Emily Mullins<o:p></o:p></span></b></p>
<p class="MsoNormal" style="background:white"><span style="color:#1F3864;background:white">Reporting and BI Solutions Analyst for ctcLink</span><span style="color:#323E4F"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black"><img border="0" width="183" height="65" style="width:1.9062in;height:.677in" id="_x0000_i1026" src="cid:image001.png@01D6AE9C.D964A030" alt="cid:image002.png@01D41F5C.C755FAA0"><o:p></o:p></span></p>
<p class="MsoNormal"><b><span style="color:#CCCCCC">_______________________________________________________________<o:p></o:p></span></b></p>
<p class="MsoNormal"><b><span style="color:#1F3864">Washington State Board for Community and Technical Colleges<o:p></o:p></span></b></p>
<p class="MsoNormal"><span style="color:#1F3864">1300 Quince St SE | PO Box 42495 | Olympia, Washington 98504-2495<br>
phone: (360) 704-1035 | email:</span><span style="color:#1F497D"> </span><a href="mailto:emullins@sbctc.edu">emullins@sbctc.edu</a><u><span style="color:blue"><o:p></o:p></span></u></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> Ctclink_qrydev <<a href="mailto:ctclink_qrydev-bounces@lists.ctc.edu">ctclink_qrydev-bounces@lists.ctc.edu</a>>
<b>On Behalf Of </b>Tamara Morrill via Ctclink_qrydev<br>
<b>Sent:</b> Monday, October 26, 2020 10:24 AM<br>
<b>To:</b> <a href="mailto:ctclink_qrydev@lists.ctc.edu">ctclink_qrydev@lists.ctc.edu</a><br>
<b>Subject:</b> [Ctclink_qrydev] PCD Refresh – Monday, November 2nd<br>
<b>Importance:</b> High<o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="xxxxxmsonormal" style="margin-left:.5in"><a name="_Hlk44512006"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">PeopleSoft PCD (Production College Development environment) will be refreshed on Monday, November 2nd 2020. <o:p></o:p></span></a></p>
<p class="xxxxxmsonormal" style="margin-left:.5in"><span style="mso-bookmark:_Hlk44512006"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"> <o:p></o:p></span></span></p>
<p class="xxxxxmsonormal" style="margin-left:.5in"><span style="mso-bookmark:_Hlk44512006"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">***
<b>PCD will stop being available on Friday, October 30th at noon. ***</b><o:p></o:p></span></span></p>
<p class="xxxxxmsonormal" style="margin-left:.5in"><span style="mso-bookmark:_Hlk44512006"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"> <o:p></o:p></span></span></p>
<p class="xxxxxmsonormal" style="margin-left:.5in"><span style="mso-bookmark:_Hlk44512006"><b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">STANDARD QUERIES<o:p></o:p></span></b></span></p>
<p class="xxxxxmsonormal" style="margin-left:1.0in"><span style="mso-bookmark:_Hlk44512006"><b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">Any queries that do not begin with ‘DEV_’ will be deleted. This applies to all standard Public and
Private queries. We will be performing a query backup for in-progress queries (private and public) that meet the DEV_ naming convention. The backup will NOT be done by folder. This means if a query is in the DEVELOPMENT folder but doesn’t begin with DEV_
it will be overwritten and lost. <o:p></o:p></span></b></span></p>
<p class="xxxxxmsonormal"><span style="mso-bookmark:_Hlk44512006"><b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"> BI PUBLISHER, PIVOT GRID, AND nVision QUERIES<o:p></o:p></span></b></span></p>
<p class="xxxxxmsonormal" style="margin-left:1.0in"><span style="mso-bookmark:_Hlk44512006"><b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">Any query used in a BI Publisher, Pivot Grid, or nVision report DO NOT have to follow the DEV_ protocol
as it is very time consuming to change them back when they are ready to migrate. Instead, please submit a Service Desk ticket under Data Services – Reporting – Other with the title PCD Refresh Backup Request. Provide the name of the query being developed
for use in one of the advanced reporting tools in the body of the request. These queries will be individually backed up on an as-needed basis.<o:p></o:p></span></b></span></p>
<p class="xxxxxmsonormal" style="margin-left:.5in"><span style="mso-bookmark:_Hlk44512006"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"> <o:p></o:p></span></span></p>
<p class="xxxxxmsonormal" style="margin-left:.5in"><span style="mso-bookmark:_Hlk44512006"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">*** Queries that do not follow these conventions will not be backed up and will be lost. ***<o:p></o:p></span></span></p>
<p class="xxxxxmsonormal" style="margin-left:.5in"><span style="mso-bookmark:_Hlk44512006"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"> <o:p></o:p></span></span></p>
<p class="xxxxxmsonormal" style="margin-left:.5in"><span style="mso-bookmark:_Hlk44512006"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">The queries in the backup will be imported back to PCD after the refresh is complete and a notice is received
from Application Services. Data Services will send a message to you once our work is complete.
<b>*** Please do not log back into PCD after Friday, <span style="color:black">October 30th</span></b><span style="color:black">
</span><b>at noon but wait until you receive a notification from Data Services. ***</b><o:p></o:p></span></span></p>
<p class="xxxxxmsonormal" style="margin-left:.5in"><span style="mso-bookmark:_Hlk44512006"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"> <o:p></o:p></span></span></p>
<p class="xxxxxmsonormal" style="margin-left:.5in"><span style="mso-bookmark:_Hlk44512006"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"> <o:p></o:p></span></span></p>
<p class="xxxxxmsonormal" style="margin-left:.5in"><span style="mso-bookmark:_Hlk44512006"><b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">Remember:</span></b></span><span style="mso-bookmark:_Hlk44512006"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"><o:p></o:p></span></span></p>
<p class="xxxxxmsonormal" style="margin-left:.5in"><span style="mso-bookmark:_Hlk44512006"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"> <o:p></o:p></span></span></p>
<ul style="margin-top:0in" type="disc">
<li class="xxxxxmsolistparagraph" style="margin-left:.25in;mso-list:l2 level1 lfo6">
<span style="mso-bookmark:_Hlk44512006"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">Naming convention for queries being developed in PCD<o:p></o:p></span></span></li></ul>
<p class="xxxxxmsolistparagraph" style="margin-left:1.25in;text-indent:-.25in"><span style="mso-bookmark:_Hlk44512006"><span style="font-size:11.0pt;font-family:"Courier New"">o</span></span><span style="mso-bookmark:_Hlk44512006"><span style="font-size:7.0pt">
</span></span><span style="mso-bookmark:_Hlk44512006"><i><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">MUST begin with the prefix DEV_
</span></i></span><span style="mso-bookmark:_Hlk44512006"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"><o:p></o:p></span></span></p>
<ul style="margin-top:0in" type="disc">
<li class="xxxxxmsolistparagraph" style="margin-left:.25in;mso-list:l2 level1 lfo6">
<span style="mso-bookmark:_Hlk44512006"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">Naming convention for queries used for training in PCD<o:p></o:p></span></span></li></ul>
<p class="xxxxxmsolistparagraph" style="margin-left:1.25in;text-indent:-.25in"><span style="mso-bookmark:_Hlk44512006"><span style="font-size:11.0pt;font-family:"Courier New"">o</span></span><span style="mso-bookmark:_Hlk44512006"><span style="font-size:7.0pt">
</span></span><span style="mso-bookmark:_Hlk44512006"><i><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">MUST begin with QXX_TRAIN<o:p></o:p></span></i></span></p>
<ul style="margin-top:0in" type="disc">
<li class="xxxxxmsolistparagraph" style="margin-left:.25in;mso-list:l2 level1 lfo6">
<span style="mso-bookmark:_Hlk44512006"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">Queries being developed for use in BI Publisher, Pivot Grid, or nVision reports in PCD<o:p></o:p></span></span></li><ul style="margin-top:0in" type="circle">
<li class="xxxxxmsolistparagraph" style="margin-left:.25in;mso-list:l2 level2 lfo6">
<span style="mso-bookmark:_Hlk44512006"><i><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">MUST begin with the appropriate convention based on the reporting tool being used. Do not follow the DEV_ convention. Must be sent to Data Services via
Service Desk ticket.<o:p></o:p></span></i></span></li></ul>
</ul>
<p class="xxxxxmsolistparagraph" style="margin-left:.5in;text-indent:-.25in"><span style="mso-bookmark:_Hlk44512006"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:red"><o:p> </o:p></span></span></p>
<p class="xxxxxmsonormal" style="text-indent:.5in"><span style="mso-bookmark:_Hlk44512006"><b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">What you need to do:</span></b></span><span style="mso-bookmark:_Hlk44512006"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"><o:p></o:p></span></span></p>
<p class="xxxxxmsonormal" style="margin-left:.5in"><span style="mso-bookmark:_Hlk44512006"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"> <o:p></o:p></span></span></p>
<p class="xxxxxmsonormal" style="margin-left:.5in"><span style="mso-bookmark:_Hlk44512006"><a name="_Hlk44572703"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">Make sure any and all of your PCD queries that you want to keep begin with the
prefix DEV_ unless you have submitted a ticket requesting backup of queries that will be used for BI Publisher, Pivot Grid, or nVision reports.<o:p></o:p></span></a></span></p>
<span style="mso-bookmark:_Hlk44572703"></span>
<p class="xxxxxmsonormal" style="margin-left:.5in"><span style="mso-bookmark:_Hlk44512006"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"> <o:p></o:p></span></span></p>
<p class="xxxxxmsonormal" style="text-indent:.5in"><span style="mso-bookmark:_Hlk44512006"><b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">Why you need to do it:</span></b></span><span style="mso-bookmark:_Hlk44512006"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"><o:p></o:p></span></span></p>
<p class="xxxxxmsonormal" style="margin-left:.5in"><span style="mso-bookmark:_Hlk44512006"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"> <o:p></o:p></span></span></p>
<p class="xxxxxmsonormal" style="margin-left:.5in"><span style="mso-bookmark:_Hlk44512006"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">*** Queries that do not follow this convention will not be backed up and will be lost. ***<o:p></o:p></span></span></p>
<p class="xxxxxmsonormal" style="margin-left:.5in"><span style="mso-bookmark:_Hlk44512006"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"> <o:p></o:p></span></span></p>
<p class="xxxxxmsonormal" style="margin-left:.5in"><span style="mso-bookmark:_Hlk44512006"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">Please let us know if you have any questions.</span></span><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"><o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><b><span style="font-size:12.0pt;font-family:"Arial",sans-serif;color:#1F497D">Tamara Morrill<o:p></o:p></span></b></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial",sans-serif;color:#1F497D">Reporting and BI Solutions Analyst for ctcLink</span><b><span style="font-size:12.0pt;font-family:"Arial",sans-serif;color:#1F497D"><o:p></o:p></span></b></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial",sans-serif;color:black"><img border="0" width="182" height="65" style="width:1.8958in;height:.677in" id="Picture_x0020_1" src="cid:image002.png@01D6AE9C.D964A030" alt="SBCTC sub-brand Data Services-small"><o:p></o:p></span></p>
<p class="MsoNormal"><b><span style="font-size:8.0pt;font-family:"Arial",sans-serif;color:#CCCCCC">_______________________________________________________________<o:p></o:p></span></b></p>
<p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Arial",sans-serif;color:#1F497D">Washington State Board for Community & Technical Colleges<o:p></o:p></span></b></p>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#1F497D">1300 Quince St SE | PO Box 42495 | Olympia, Washington 98504-2495<br>
email: <a href="mailto:tmorrill@sbctc.edu"><span style="color:blue">tmorrill@sbctc.edu</span></a><o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</body>
</html>