[ctcLinkfinaidsupport] FW: [Ctclink_qrydev] *** REMINDER ***: PCD Refresh – Monday, January 4th

[Alan-Michael Alston]

Good Morning,

Please see the reminder below about the PCD refresh happening on January 4th.  Happy Tuesday!



Alan-Michael, FA ERP

From: Ctclink_qrydev <ctclink_qrydev-bounces at lists.ctc.edu> On Behalf Of Emily Mullins via Ctclink_qrydev
Sent: Tuesday, December 29, 2020 9:01 AM
To: ctclink_qrydev at lists.ctc.edu
Subject: [Ctclink_qrydev] *** REMINDER ***: PCD Refresh – Monday, January 4th
Importance: High


This is an email reminder about the PCD refresh happening next Monday, January 4th, 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 Emily Mullins via Ctclink_qrydev
Sent: Monday, December 28, 2020 10:21 AM
To: ctclink_qrydev at lists.ctc.edu<mailto:ctclink_qrydev at lists.ctc.edu>
Subject: [Ctclink_qrydev] PCD Refresh – Monday, January 4th
Importance: High


PeopleSoft PCD (Production College Development environment) will be refreshed on Monday, January 4th, 2020.



*** PCD will stop being available on Thursday, December 31st at noon (because of the holiday on Friday, January 1st). ***



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 Thursday, December 31st 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.


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>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ctc.edu/pipermail/ctclinkfinaidsupport_lists.ctc.edu/attachments/20201229/3912b836/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/20201229/3912b836/attachment-0001.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/20201229/3912b836/attachment-0001.txt>