[ctcLinkfinaidsupport] FW: [Ctclink_qrydev] *** LAST REMINDER ***: PCD Refresh – Monday, November 2nd

Marjorie Facio mfacio at sbctc.edu
Fri Oct 30 11:31:18 PDT 2020


Hello FA Users,

Please see the announcement below regarding the PCD refresh. In case you are testing any processing or developing any queries.

Thanks!

FA SUPPORT

From: Ctclink_qrydev <ctclink_qrydev-bounces at lists.ctc.edu> On Behalf Of Emily Mullins via Ctclink_qrydev
Sent: Friday, October 30, 2020 9:13 AM
To: ctclink_qrydev at lists.ctc.edu
Subject: [Ctclink_qrydev] *** LAST REMINDER ***: PCD Refresh – Monday, November 2nd
Importance: High

Just a last friendly reminder that we are going to start doing our query backups at 12:00 p.m. noon today.

*** PLEASE DON’T WORK IN PCD UNTIL WE NOTIFY YOU THAT ALL THE REFRESH WORK HAS BEEN COMPLETED AND THAT WE ARE DONE ***

Remember, we will only back up:


  1.  In-progress Public and Private queries beginning with DEV_
  2.  We will not back up any folder
  3.  Training queries that begin with QXX_TRAIN_
  4.  Queries being developed for use in BI Publisher, Pivot Grid, or nVision that have been sent to Data Services via a Service Desk ticket.

Thank you!


Emily Mullins
Reporting and BI Solutions Analyst for ctcLink
[cid:image002.png at 01D41F5C.C755FAA0]
_______________________________________________________________
Washington State Board for Community and Technical Colleges
1300 Quince St SE | PO Box 42495 | Olympia, Washington 98504-2495
phone: (360) 704-1035 | email: emullins at sbctc.edu<mailto:emullins at sbctc.edu>

From: Ctclink_qrydev <ctclink_qrydev-bounces at lists.ctc.edu<mailto:ctclink_qrydev-bounces at lists.ctc.edu>> On Behalf Of Emily Mullins via Ctclink_qrydev
Sent: Wednesday, October 28, 2020 7:00 AM
To: ctclink_qrydev at lists.ctc.edu<mailto:ctclink_qrydev at lists.ctc.edu>
Subject: [Ctclink_qrydev] *** REMINDER ***: PCD Refresh – Monday, November 2nd
Importance: High


This is an email reminder about the PCD refresh happening next Monday, November 2nd, 2020.  Please read the email below.



Let us know if you have any questions.



Emily Mullins
Reporting and BI Solutions Analyst for ctcLink
[cid:image002.png at 01D41F5C.C755FAA0]
_______________________________________________________________
Washington State Board for Community and Technical Colleges
1300 Quince St SE | PO Box 42495 | Olympia, Washington 98504-2495
phone: (360) 704-1035 | email: emullins at sbctc.edu<mailto:emullins at sbctc.edu>

From: Ctclink_qrydev <ctclink_qrydev-bounces at lists.ctc.edu<mailto:ctclink_qrydev-bounces at lists.ctc.edu>> On Behalf Of Tamara Morrill via Ctclink_qrydev
Sent: Monday, October 26, 2020 10:24 AM
To: ctclink_qrydev at lists.ctc.edu<mailto:ctclink_qrydev at lists.ctc.edu>
Subject: [Ctclink_qrydev] PCD Refresh – Monday, November 2nd
Importance: High


PeopleSoft PCD (Production College Development environment) will be refreshed on Monday, November 2nd 2020.



*** PCD will stop being available on Friday, October 30th at noon. ***



STANDARD QUERIES

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.

                BI PUBLISHER, PIVOT GRID, AND nVision QUERIES

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.



*** Queries that do not follow these conventions will not be backed up and will be lost. ***



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.  *** Please do not log back into PCD after Friday, October 30th at noon but wait until you receive a notification from Data Services. ***





Remember:



  *   Naming convention for queries being developed in PCD

o   MUST begin with the prefix DEV_

  *   Naming convention for queries used for training in PCD

o   MUST begin with QXX_TRAIN

  *   Queries being developed for use in BI Publisher, Pivot Grid, or nVision reports in PCD
     *   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.



What you need to do:



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.



Why you need to do it:



*** Queries that do not follow this convention will not be backed up and will be lost. ***



Please let us know if you have any questions.


Tamara Morrill
Reporting and BI Solutions Analyst for ctcLink
[SBCTC sub-brand Data Services-small]
_______________________________________________________________
Washington State Board for Community & Technical Colleges
1300 Quince St SE | PO Box 42495 |  Olympia, Washington 98504-2495
email: tmorrill at sbctc.edu<mailto:tmorrill at sbctc.edu>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ctc.edu/pipermail/ctclinkfinaidsupport_lists.ctc.edu/attachments/20201030/7a050192/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 11590 bytes
Desc: image001.png
URL: <http://lists.ctc.edu/pipermail/ctclinkfinaidsupport_lists.ctc.edu/attachments/20201030/7a050192/attachment-0002.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.png
Type: image/png
Size: 11593 bytes
Desc: image002.png
URL: <http://lists.ctc.edu/pipermail/ctclinkfinaidsupport_lists.ctc.edu/attachments/20201030/7a050192/attachment-0003.png>
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: ATT00001.txt
URL: <http://lists.ctc.edu/pipermail/ctclinkfinaidsupport_lists.ctc.edu/attachments/20201030/7a050192/attachment-0001.txt>


More information about the ctcLinkfinaidsupport mailing list