Key

2020

See 2020.4 Release Notes

See 2020.3 Release Notes

2020.2

Notable Changes

Items can now be added to a Purchase Order after Receiving has started.
Changes to Estimates:
1. Attachments are now copied to Service Orders or Actions created from Estimates.
2. Remarks are now copied to Service Orders or Actions created from Estimates
Add Locations Actions can now be created from the 360 Wizard for non-Phone Services.

Please review the Database Changes in 2020.2 and make any necessary changes to your Adhoc Grids, Custom Events, and API calls.

Release 2020.2.5 (12-16-2020)

Component	Description	Incident(s)	Documentation
Billing	Billing Group Pricing now applies to GLA Charges.	IN-5072
Cable	Creating a new Cable Path from the Service form no longer defaults to creating the Path with a status of Left In.	IN-5066
Calls & Rating	The Call Rating process no longer fails if the Service Host cannot be determined.	IN-5057 IN-4321
Imports & Exports	The Call Import no longer triggers "Undefined index AUTH_CODE_FLAG" warning messages that can fill up the Error Log.
Imports & Exports	GLA Import Fixes The Import no longer creates a blank component record using an empty string rather than a null value. The Import can now find existing GLA records when the last component of the GLA is blank. Previously the Import was not able to look up those GLAs.	IN-4446 IN-5094
Inventory	Staging multiple pieces of Equipment at the same time from the Warehouse Actions grid no longer reuses the same Equipment record multiple times.	IN-4429
Reporting	Corrected minor formatting issues with PDF reports.	IN-5013
Service Desk	Users can now open the Service Desk Form that corresponds to the Workflow record from the Workflow Grids (i.e. if the Workflow is on an Action, the User may open the Action form or the Workflow form from the Workflow Grids).	IN-4427	My Service Desk Workflow
	The Service Desk Archive Log retention process now properly cleans up log entries based on the timeframe set by the configuration option ARCHIVE_LOG_RETENTION.		Archive Log
	Improved the loading times for the Service Desk Tab on Services & Equipment. For Oracle customers, the grid was either extremely slow or would not load.	IN-4336
	The "Type Value" selector on the Escalation Criteria form now lists all Service Desk Types.
	Service Desk number formats less than 8 digits now work properly.
	Service Desk Items will no longer allow Services and Equipment to be Owned by both a Contact and a Department Owner. Note: There will be an AdHoc added during the upgrade process to allow customers to find and fix any Services or Equipment that have two Owners defined.	IN-3335 IN-4395 IN-4340
	The columns on the Service Desk Archive grids now match the corresponding Service Desk Grids (i.e. the columns on the Service Desk Actions Archive grid now match the Service Desk Actions grid.)	IN-5090 IN-3923

Release 2020.2.4 (10-06-2020)

Component	Description	Incident(s)
API	Submitting poorly formed JSON data, or data with bad characters will no longer fail and return a null value. Now $params will be returned with the default data.
Billing	The Bill process now checks for Equipment Billling Group overrides for Equipment Charges.	IN-4342
Billing	The Bill process now checks for Billling Group overrides for GLA Charges.
Custom Logic	Restored the data displayed on the Schedule Tab on the Custom Events screen.	IN-4333
Inventory	The Warehouse Actions Return is now changing the Service Desk Equipment Status from Pending to Complete. Note: With this change, the Return "Quantity" field will no longer be available when returning "In" Equipment on Remove Actions. All items must be returned at the same time for Remove Actions.	IN-4304 IN-4262
General	Fixed issues with the validator when creating an empty database for new installs.
Reporting	Due to licensing the constraints of Oracle Java, we have officially dropped support and switched to using OpenJDK for Crystal Reports. Please submit any requests to upgrade java on our portal help.pcr.com.
Services	The Call Details Tab on the Service form now includes Rated Unbillable calls.	IN-4316
Service Desk	Service Desk Actions will no longer display an erroneous "was not found in the haystack" error on the Service Options field.
Service Desk	Completing a Service Order with Actions no longer produces erroneous "Failed to save record" errors, when there is some other issue on the form (such as no owner or a missing GLA).	IN-3000 IN-4225 IN-4239 IN-4365 IN-4192

Release 2020.2.3 (09-01-2020)

Component	Description	Incident(s)	Documentation
CustomerCenter	Approved Service Requests are now showing in the Service Requests Grid.
Custom Logic	Customer Validation now supports using call function to invoke Write methods for API types.		Custom Validation Syntax
Custom Logic	Large Custom API, Custom Events, and Custom Validation scripts no longer generate erroneous error messages. (e.g. that the str_replace function is not supported)	IN-4164
Events & Notifications	Workflow Start Date Notifications/Escalations are now triggered when the Workflow Start Date is set automatically.	IN-4216
Services	The Service Desk tab on Services once again includes Pending Add Actions.	IN-4215
Service Desk	Completing a Service ID Action no longer clears the Path Location.	IN-4188
Service Desk	SDC Workflow steps that should be added at completion are now added to Incidents and Work Orders upon completion.	IN-4196

Release 2020.2.2 (08-06-2020)

Component	Description	Incident(s)	Documentation
API	The Service Desk API now properly supports Service/ Equipment UDFs on Incidents.		Service Desk API Calls
CustomerCenter	The Service Option flags (Billable, Directory, Report 911, etc.) are now set for Task, Change, and Remove Actions on Service Requests created from CustomerCenter.	IN201833105 IN-2965
	SDCs are now properly applied to Service Requests when a matching SDC is found.	IN-4125
	Existing Service Charges are now added to Change Actions on a Service Request.	IN-4125
	Task Actions are no longer converted to or displayed as Add Actions in the Cart. Similarly, in certain cases, Add actions are no longer converted to or displayed as Tasks in the Cart.
Service Desk	Converting an Estimate to an Action now allows applying the Estimate to Task Actions.	IN-4153

Release 2020.2.1 (08-03-2020)

Component	Description	Incident(s)
Billing	The "Test File" column on the Call Details grid has been restored.	IN-3983
	The Available Charges Bulk Update event no longer fails on Oracle.	IN-4066
	Back Dating a Monthly Recurring Charge Stop Date on a Back-Billing & Forward-Billing Charge no longer generates double Credits	IN-4051
Cable	The Service Location column on the Ports/Pins/Lens grid now displays data for the "To Port" on a Path.	IN-3873
Events	Events that occur during the Fall Daylight Savings Time change should no longer fail.
Inventory	User-Defined Columns now stay in the correct position on the Equipment Grid after you save the Perspective.	IN-2899
General	Long-running reports sent via email no longer get stuck in an infinite loop (which prevented the reports from being sent out).	IN-3963 IN-3965 IN-3968 IN-3970 IN-3964 IN-3966
Service Desk	Completing a Service ID Action now sets the Ports/Pins/Lens status to Assigned. (Previously this was set to PDPC)
	Default Charges from Task type Service Catalogs are now applied to Task Actions.	IN-4031 IN-3915
	The Add From SDC button on the Service Desk Workflow tab, now selects from the correct SDCs.	IN-4094
	Adding Equipment to an Incident Request no longer generates an Oops Error.

Release 2020.2 (06-04-2020)

Component	Description	Incident(s)	Documentation
Billing	Changing the Charge Override Amount or Quantity on an unbilled Monthly Recurring Charge (MRC) and choosing "Effective Today" now stops the charge using yesterday's date. The charge is restarted with the new amount and the current date. Previously this was using "Date to Last Billed" no matter which option was chosen.
Imports & Exports	Multiple fixes for the Service Import: The Service Import now prevents you from updating the Service Catalog of an existing Service to a different Service Type (like Phone to Backbone) or to a different Service ID format. The Service Import can now update certain Service Type-specific fields like Report 911 and Directory if the Service Catalog is not provided to the import. The Service Import no longer requires you to provide a GLA when the GLA field is mapped. Running a Service Import in a batch, with two different Import Record Formats, no longer produces the same GLA error messages multiple times.		Service Import
	Fixes for the Charge Catalog Import: The Charge Catalog Import no longer fails if you do not map certain fields. The Charge Catalog Import now throws an error if you try to use an Inactive Object Code.		Charge Catalog Import
	Fixes for the Service Charge and GLA Charge Imports: Both Imports no longer require you to provide certain fields, like Service and GLA and Charge Catalog, if you provide the Charge Recid in the Import file. Both Imports now throw an error if you try to use a Category type Charge Catalog to create a Charge.		Service Charge Import GLA Charge Import
	Fixes for Charge Imports: Charge Imports no longer clear the Charge Stop Date when the Import file contains Stop Dates prior to the current date. Charge Imports will now clear the Amount Override on an existing charge if you provide a blank Override Amount value during an update.		Service Charge Import
	Most Imports now accept GLA values where the first or last GLA component is blank. (This does not currently cover Service Desk or Equipment Catalog Imports).	IN-3803
Inventory	Items can now be added to a Purchase Order after Receiving has started.	Won Voting List #2	Purchase Order Purchase Order Equipment
Service Desk	Changes to Estimates: Attachments are now copied to Service Orders or Actions created from Estimates. Remarks are now copied to Service Orders or Actions created from Estimates	Users Group	Estimates
	Billing Group Pricing is now applied to a Charge if the Owner is Changed on a Service Desk Order or Action.	IN-2831 IN-2964
	Service Desk Items will no longer allow Services and Equipment to be Owned by both a Contact and a Department Owner. Note: There will be an AdHoc added during the upgrade process to allow customers to find and fix any Services or Equipment that have two Owners defined.	IN-3335
	Add Locations Actions can now be created from the 360 Wizard for non-Phone Services.
	Clicking "Save New" on an existing Action will now create a new Action with the Default Action GLA(s) from the Service Order. (Previously no GLAs were pulled onto the Action). This also addresses GLA Component Pricing not being applied to the new Action when using the "Save New" button.	IN-2998 (IN201834420) IN-2999 (IN201834421)
	Changing the GLA on an Action now updates any Default Service Charges loaded from the Service Catalog with the Component Pricing.	IN-2999 (IN201834421)

* Indicates external documentation not written by PCR.

Database Changes in 2020.2

Default Schema

Table Name	Change	Table Changes
No Changes

Metadata Schema

Table Name	Change	Table Changes
No Changes

Archive Schema

Table Name	Change	Table Changes
No Changes

2020.1

Notable Changes

- Added support for creating/updating Remarks and User-Defined Field values to the Contact API endpoint.
- Replaced PCR-360 API Token Authentication with a JSON Web Token.
- Various security fixes and enhancements for Custom Events, Custom Validation, Custom API, and Conditional Logic.
- Added an Audit Cleanup Event to remove Audit entries where no changes were made to the data, aside from updating the "Modified Date." These entries are effectively duplicates of the original Audit entry.
- Enhancements and bug fixes for the Cable Path Import and Department Hierarchy Import.
- Multiple Time Entry and Service Desk Labor fixes.

Please review the Database Changes in 2020.1 and make any necessary changes to your Adhoc Grids, Custom Events, and API calls.

Release 2020.1.5 (10-06-2020)

Component	Description	Incident(s)
API	Submitting poorly formed JSON data, or data with bad characters will no longer fail and return a null value. Now $params will be returned with the default data.
Billing	The Bill process now checks for Equipment Billling Group overrides for Equipment Charges.	IN-4342
Billing	The Bill process now checks for Billling Group overrides for GLA Charges.
Custom Logic	Restored the data displayed on the Schedule Tab on the Custom Events screen.	IN-4333
Inventory	The Warehouse Actions Return is now changing the Service Desk Equipment Status from Pending to Complete. Note: With this change, the Return "Quantity" field will no longer be available when returning "In" Equipment on Remove Actions. All items must be returned at the same time for Remove Actions.	IN-4304 IN-4262
General	Fixed issues with the validator when creating an empty database for new installs.
Reporting	Due to licensing the constraints of Oracle Java, we have officially dropped support and switched to using OpenJDK for Crystal Reports. Please submit any requests to upgrade java on our portal help.pcr.com.
Services	The Call Details Tab on the Service form now includes Rated Unbillable calls.	IN-4316
Service Desk	Service Desk Actions will no longer display an erroneous "was not found in the haystack" error on the Service Options field.
Service Desk	Completing a Service Order with Actions no longer produces erroneous "Failed to save record" errors, when there is some other issue on the form (such as no owner or a missing GLA).	IN-3000 IN-4225 IN-4239 IN-4365 IN-4192

Release 2020.1.4 (09-01-2020)

Component	Description	Incident(s)	Documentation
CustomerCenter	Approved Service Requests are now showing in the Service Requests Grid.
Custom Logic	Customer Validation now supports using call function to invoke Write methods for API types.		Custom Validation Syntax
Custom Logic	Large Custom API, Custom Events, and Custom Validation scripts no longer generate erroneous error messages. (e.g. that the str_replace function is not supported)	IN-4164
Events & Notifications	Workflow Start Date Notifications/Escalations are now triggered when the Workflow Start Date is set automatically.	IN-4216
Services	The Service Desk tab on Services once again includes Pending Add Actions.	IN-4215
Service Desk	Completing a Service ID Action no longer clears the Path Location.	IN-4188
Service Desk	SDC Workflow steps that should be added at completion are now added to Incidents and Work Orders upon completion.	IN-4196

Release 2020.1.3 (08-06-2020)

Component	Description	Incident(s)	Documentation
API	The Service Desk API now properly supports Service/ Equipment UDFs on Incidents.		Service Desk API Calls
CustomerCenter	The Service Option flags (Billable, Directory, Report 911, etc.) are now set for Task, Change, and Remove Actions on Service Requests created from CustomerCenter.	IN201833105 IN-2965
	SDCs are now properly applied to Service Requests when a matching SDC is found.	IN-4125
	Existing Service Charges are now added to Change Actions on a Service Request.	IN-4125
	Task Actions are no longer converted to or displayed as Add Actions in the Cart. Similarly, in certain cases, Add actions are no longer converted to or displayed as Tasks in the Cart.
Service Desk	Converting an Estimate to an Action now allows applying the Estimate to Task Actions.	IN-4153

Release 2020.1.2 (08-03-2020)

Component	Description	Incident(s)
Billing	The "Test File" column on the Call Details grid has been restored.	IN-3983
	The Available Charges Bulk Update event no longer fails on Oracle.	IN-4066
	Back Dating a Monthly Recurring Charge Stop Date on a Back-Billing & Forward-Billing Charge no longer generates double Credits	IN-4051
Cable	The Service Location column on the Ports/Pins/Lens grid now displays data for the "To Port" on a Path.	IN-3873
Events	Events that occur during the Fall Daylight Savings Time change should no longer fail.
Inventory	User-Defined Columns now stay in the correct position on the Equipment Grid after you save the Perspective.	IN-2899
General	Long-running reports sent via email no longer get stuck in an infinite loop (which prevented the reports from being sent out).	IN-3963 IN-3965 IN-3968 IN-3970 IN-3964 IN-3966
Service Desk	Completing a Service ID Action now sets the Ports/Pins/Lens status to Assigned. (Previously this was set to PDPC)
	Default Charges from Task type Service Catalogs are now applied to Task Actions.	IN-4031 IN-3915
	The Add From SDC button on the Service Desk Workflow tab now selects from the correct SDCs.	IN-4094
	Adding Equipment to an Incident Request no longer generates an Oops Error.

Release 2020.1.1 (05-29-2020)

Component	Description	Incident(s)	Documentation
API	Added SDC support to the Add Incident API endpoint.		Service Desk API
	The Barcode API now properly handles "Units" when creating Unit Equipment.		Barcode: Warehouse Bulk Add
	Incidents created by API now automatically select an SDC when one is not provided.
	Added the 'bill_date' parameter to the Service Charges API endpoint. This allows setting a Start Date for recurring charges via the API.	IN-3375	Service API Calls
Billing	Clicking on the "Switch to full detail view" link, on certain Test Bills, no longer redirects you to an error page.
Cable	The Ports/Pins/Lens Add Range functionality now properly updates Back Connects for ranges over 100 PPLs.	IN-3770
	Various "minor" issues with the Port Side Requirement were addressed.
	Service Desk Remove Actions now set Cable Pairs and Ports/Pins/Lens to Spare upon completion of the Action.	IN-3785 IN-3792 IN-3816
	Adding Multiple Path Legs no longer causes an error when adding a non-spare Ports/Pins/Lens to the same Path.	IN-3039
General	Expanded the Authentication Mapping (AUTH_MAPPING) field on the ROLES table to allow for longer SSO Group names.		Authorization Parameters
Services	When a Service is used on a Service Order that has multiple Actions, the Service Desk tab on the Service form no longer displays data for all of the Actions on that Order. Previously data for unrelated Actions was displayed on the Service Desk tab.	IN-3622 IN-3736

Release 2020.1 (04-10-2020)

Component	Description	Incident(s)	Documentation
API	Added support for creating/updating Remarks and User-Defined Field values to the Contact API endpoint.		Contact API
	Replaced PCR-360 API Token Authentication with a JSON Web Token.		Token Authentication Service Host Rest API Authorization Parameters *JSON Web Token Standard
	This release allows more HTML tags for HTML remarks added via the API. Allowed tags: 'a', 'img', 'strong', 'em', 'p', 'h1', 'h2', 'h3', 'h4', 'h5', 'ul', 'ol', 'li', 'table', 'tr', 'th', 'td', 'br', 'embed' Note: Support for these tags will come to the Remarks form in a later release.	IN-2857	Remarks: Allowed HTML Tags
Billing	Bill Summary totals on tabs/grids now include the Taxes from Usage and Calls.
Cable	The Cable Path Legs form and Service Desk Cabling Path Legs form will now populate both sides when the Port/Pin/Len is selected.
Cable	The Transfer Pair/Strand Range process now properly associates To/From Cabling Equipment pairs transferred from one cable to another. Because of this issue, the Cable Maintenance form displayed connected Equipment for Cables with no Pairs (and no Equipment for some cable with Pairs).	IN-3446 IN-2854
Catalogs	Now, when a Location is made Inactive, the child Locations are displayed in the Locations Grid as Inactive. Previously, the child Locations were incorrectly displayed in the grid as Active.	IN-3236 IN-2879
Custom Logic	Centralized the logic used to validate allowed PHP functions in Custom Logic. This affects Custom Validation, Custom API, Custom Events, and Conditional Logic. This change adds support for: PHP array_, is_, str,* etc. in Custom Logic. Using PHP Constants in Custom Logic (e.g. STR_PAD_LEFT). regex functions		Custom API Custom Validation Custom Events Custom Logic Import Conditional Logic Custom Logic Syntax
Custom Logic	Various security fixes for Custom Events, Custom Validation, Custom API, and Conditional Logic: Corrects false Custom Logic validation failures when there are multiple PHP versions installed on the server. Variable function calls are blocked. Access to the following constants is blocked The following globals are blocked The following PHP functions are blocked
General	Added User Defined Columns (UDCs) to the GLA picker.
	Added an Audit Cleanup Event to remove Audit entries where no changes were made to the data, aside from updating the "Modified Date". These entries are effectively duplicates of the original Audit entry.		Audit Events Historical Data Archiving Events
	Fixed various issues with Read-Only Permissions not working consistently.	IN-3387
Imports & Exports	Various Cable Path Import enhancements The import now allows appending Path Legs to existing Paths. The import now allows removing Cable Paths. Added the configuration option CHECK_SERVICE_STATUS. When this option is set to true, the import will throw an error when attempting to add a Path to a Service that is not Active.		Cable Path Import
	The Department Hierarchy Import now supports clearing and appending existing contacts to the Department Hierarchy Coordinator tab.	IN-2855
	Various fixes to to the Cable Path Import The import no longer allows creating a Path on a Service and Location, if that Location does not exist on the Service. The import no longer replaces Paths with Service data, from a different Service that has the same Location. The import now maintains the correct Pair Status values. The import can now find a Service record using either the formatted or unformatted Service ID.		Cable Path Import
	Various fixes to to the Department Hierarchy Import The import now finds the correct SLA when a Hierarchical String is provided in the import file. (e.g. "Parent SLA > Child SLA") The import now uses the correct concatenator (defined by the constant GLA_IMPORT_CONCATENATOR) for the following import fields: SLA, Default SLA, GLA, and Permitted GLA. The import will now throw an error if any of the following items from the import file are Inactive: Billing Group, Default GLA, Default SLA, Default Incident SLA, and Permission GLAs. The import now defaults new Department Hierarchy records to Active when no status is provided in the import file. New Department Hierarchy records now require the Billing Group. An error is thrown if a Billing Group is not provided in the import file. The import now restricts the allowed Default GLA, and GLA permissions to those allowed by the Billing Group provided in the import file. The import will throw an error if a GLA in the file is not allowed on the provided Billing Group.		Department Hierarchy Import
	Service Order and Work Order imports now properly save the SLA provided in the import file.
Inventory	We have enhanced our API and added a Barcode Endpoint. This will allow scanner software to interface with the API sending barcode transactions into PCR-360 to do things like Warehouse Bulk Add/Transfer, Complete Service Desk Equipment, and Logging Service Desk Labor. Note: This does require the development of a Barcode Scanner interface (software) to initiate the API calls from a scanner. PCR worked with a company, Big River Barcode, to develop similar scanner software for COMIT; we are working with them to develop a version to interact with PCR-360.		Barcode Barcode API Calls API Events: Quick Reference
People	Multiple Time Entry fixes: The Time Entry form no longer allows creating, editing, or deleting Labor entries for Voided, Billed, or Finalized Service Desk Items. The following values are now required from the Labor Form, the API or an Import: Date Worked Worker (Contact) Labor Type Deleting a Time Entry record now deletes the associated Labor record.	IN-2860 IN-2962	Time Entry Service Desk Labor Workflow
Service Desk	Changing the Cable Path on an Incident now adds an Activity Record to the Incident.		Incidents
	Service Desk Labor Charges are no longer updated when the amount on the Charge Catalog changes. Previously, changing the amount on the Charge Catalog kicked off an event that updated all Charges, including Labor Charges. Labor Charges, particularly those using a flat-rate charge, should be static and not updated by changing the Charge Catalog.	IN201834290
	Service Desk Labor Charges are no longer deleted in cases where the user attempted to delete a Labor record, but the Labor record could not be deleted. Previously, even when the Labor record could not be deleted, the associated Labor charge was deleted.
	Saving a new Labor record will no longer randomly display an "Oops Error" message.	IN-3293 IN-3082 IN-3089 IN-3102 IN-3408 IN-2931 IN-2892

* Indicates external documentation not written by PCR.

Database Changes in 2020.1

Default Schema

Table Name	Change	Table Changes
Table Name	Change	Table Changes
API_PERMISSIONS	Updated	Added Barcode as an API Permission
API_KEYS	Updated	ADD COLUMN DEFAULT_RATE_LIMIT INT DEFAULT 60 NOT NULL;
API_KEYS_USERS_TOKENS	Updated	MODIFY COLUMN TOKEN VARCHAR(255) NOT NULL; ADD COLUMN RATE_LIMIT INT DEFAULT 60 NOT NULL; ADD COLUMN RATE_LIMIT_REMAINING INT DEFAULT 60 NOT NULL; ADD COLUMN RATE_LIMIT_RESET DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL; ADD INDEX API_KEYS_USERS_TOKENS_1 (`TOKEN`);
CABLES_EQUIPMENT	Updated	Create missing "From Cabling Equipment" and "To Cabling Equipment" associations. Removed orphaned "From Cabling Equipment" and "To Cabling Equipment" associations.
BARCODE	Removed
BARCODE_TRANSACTIONS	New
EQP_CATALOG	Updated	CHANGE PART_NUM_BARCODE BARCODE VARCHAR(100);
EVENTS	Updated	Added an Audit Cleanup Event.
SERVICE_DESK_LABOR	Updated	MODIFY COLUMN LABOR_TYPE_LISTS_RECID INT NOT NULL; MODIFY COLUMN CONTACTS_RECID INT NOT NULL; MODIFY COLUMN WORKED_DATE DATETIME NOT NULL;

Metadata Schema

Table Name	Change	Table Changes
No Changes

Archive Schema

Table Name	Change	Table Changes
No Changes

2019

2019.7

Notable Changes

- Added an AdHoc Grid Report Library to the wiki.
- Updated various pages in the wiki to clarify current functionality.
- Added Service Desk Archiving
  - It allows users to delete old data, such as Locations, Contacts, and Equipment (Foreign Keys to Locations, Contacts, etc. on Service Desk prevent deleting data).
  - It allows users to archive and potentially clean up (delete) old Service Desk Data.
  - It provides the ability to Demolish a Location, which allows the deletion of a Location along with all sub-Locations and associated Cable Data.
  - Archiving old data improves the performance of grids and pickers.
  - Note: Customers interested in using Service Desk Archiving must email the Helpdesk to sign up for a training session to review how Archiving works and the implications of the various settings before PCR will turn on the Archiving Event. We will be setting up separate 2019.7 group training sessions to review new features.
- Added Work Order functionality to allow for one-time Orders that do not create or manage Services.
- Removed the Service Desk Cabling Report and replaced it with an AdHoc report.
- Removed the Cable Locations Report and replaced it with an Adhoc report.
- Numerous fixes to Service Desk Imports.
- Aging a Multiple Location Service that was used on an Incident no longer fails.
- Redesigned the My Service Desk: Assigned and Workgroup grids towards a workflow focus.

Please review the Database Changes in 2019.7 and make any necessary changes to your Adhoc Grids, Custom Events, and API calls.

Release 2019.7.12 (4-19-2021)

Component	Description	Incident(s)
General	Enabled Form Read/Write Permissions on Tree Elements, including the Catalogs tree tools. Users can now set the Catalog tree(s) to Readonly or Permissions Denied.	IN-5967
Reports	Emailing a grid report with all rows from the grid, now includes all rows (previously the emailed report only contained the first row).
Service Desk	Completing an Upgrade/Downgrade Action once again copies the UDF values to the Service. (This fix was back-ported from 2020.4.2)	IN-5983

Component

Description

Type

Incident(s)

Documentation

General

Enabled Form Read/Write Permissions on Tree Elements, including the Catalogs tree tools. Users can now set the Catalog tree(s) to Readonly or Permissions Denied.

IN-5967

Reports

Emailing a grid report with all rows from the grid, now includes all rows (previously the emailed report only contained the first row).

Service Desk

Completing an Upgrade/Downgrade Action once again copies the UDF values to the Service. (This fix was back-ported from 2020.4.2)

IN-5983

Release 2019.7.11 (3-19-2021)

Component	Description	Incident(s)	Documentation
General	E911 Changes This update will update the data in the E911 snapshot and load E911 fields from All addresses in the Database. Generating the E911 report now requires using the USE_E911_NENA2_FIELDS configuration option, if the option is not enabled the process will throw an exception. NOTE: This will likely create a change record for every Service on a Building where the Nena2 fields were previously blank. The change records created by this process would be a one-time change. The E911 Report will now convert "Court" to the prefix "CT".	IN-5724
Notifications, Escalations, and Events	The Notification Log form no longer throws an error when the CC (email) Field is populated.	IN-5201
Service Desk	Added a new Escalation/Notification Filter Variable, SDWF_ADDNEW, to Service Desk Workflow events.	IN-5201	Escalation Criteria Creating an Escalation Escalations
Service Desk	The "Add From SDC" button on Workflow no longer triggers two Workflow Start Date Notifications.	IN-5201

Release 2019.7.10 (2-10-2021)

Component	Description	Incident(s)
API	When creating Upgrade/Downgrade Actions via the API, the Billable and Report 911 flags are now pulled from the Service Catalog, not the existing Service values (if values are not provided in the API Request).	IN-4978 IN-4987
Cable	Updating or saving a Cable Path on a Multiple Location Service no longer displays the message "A path may only be added to a Service with a Location."	IN-5670
General	The Crystal Reports: Batch Filters Grid should no longer fail to load for Oracle customers.	IN-5622
Imports & Exports	When creating Upgrade/Downgrade Actions via an Import, the Billable and Report 911 flags are now pulled from the Service Catalog, not the existing Service values (if values are not provided in the Import File).	IN-4978 IN-4987
Services	Generating a range of non-Phone Service records should no longer fail to create the Service records.	IN-5184 IN-5222 IN-5194
Service Desk	Increased the size of the "From Equipment Catalog" and "To Equipment Catalog" columns for the Service Desk Cable records to prevent data truncation. The Service Desk Cable Archive table was also updated.	IN-5047
	Adding a User-Defined Column (UDC) to the My Service Desk Workgroup or Workflow grids no longer displays an "Oops Error" message.	IN-5189
	Service Desk Archiving Fixes The Service Desk Archiving process will now archive Service Desk Items where some data was not defined (such as a NULL value for the USE_QUANTITY column on Service Desk Charge records). When a single Service Desk Item fails to Archive, will no longer get stuck; the process will continue to archive records.	IN-5090 IN-3923
	Returning Equipment on a Billed or Completed Action should once again create a credit charge.	IN-5177
	When creating Upgrade/Downgrade Actions on a Service Order, the Billable and Report 911 flags are now pulled from the Service Catalog, not the existing Service values.	IN-4978 IN-4987

Release 2019.7.9 (12-16-2020)

Component	Description	Incident(s)	Documentation
Billing	Billing Group Pricing now applies to GLA Charges.	IN-5072
Cable	Creating a new Cable Path from the Service form no longer defaults to creating the Path with a status of Left In.	IN-5066
Calls & Rating	The Call Rating process no longer fails if the Service Host cannot be determined.	IN-5057 IN-4321
Imports & Exports	The Call Import no longer triggers "Undefined index AUTH_CODE_FLAG" warning messages that can fill up the Error Log.
Inventory	Staging multiple pieces of Equipment at the same time from the Warehouse Actions grid no longer reuses the same Equipment record multiple times.	IN-4429
Reporting	Corrected minor formatting issues with PDF reports.	IN-5013
Service Desk	Users can now open the Service Desk Form that corresponds to the Workflow record from the Workflow Grids (i.e. if the Workflow is on an Action, the User may open the Action form or the Workflow form from the Workflow Grids).	IN-4427	My Service Desk Workflow
	The Service Desk Archive Log retention process now properly cleans up log entries based on the timeframe set by the configuration option ARCHIVE_LOG_RETENTION.		Archive Log
	Improved the loading times for the Service Desk Tab on Services & Equipment. For Oracle customers, the grid was either extremely slow or would not load.	IN-4336
	The "Type Value" selector on the Escalation Criteria form now lists all Service Desk Types.
	Service Desk number formats less than 8 digits now work properly.
	Service Desk Items will no longer allow Services and Equipment to be Owned by both a Contact and a Department Owner. Note: There will be an AdHoc added during the upgrade process to allow customers to find and fix any Services or Equipment that have two Owners defined.	IN-3335 IN-4395 IN-4340
	The columns on the Service Desk Archive grids now match the corresponding Service Desk Grids (i.e. the columns on the Service Desk Actions Archive grid now match the Service Desk Actions grid.)	IN-5090 IN-3923

Release 2019.7.8 (10-06-2020)

Component	Description	Incident(s)
API	Submitting poorly formed JSON data, or data with bad characters will no longer fail and return a null value. Now $params will be returned with the default data.
Billing	The Bill process now checks for Equipment Billling Group overrides for Equipment Charges.	IN-4342
Billing	The Bill process now checks for Billling Group overrides for GLA Charges.
Custom Logic	Restored the data displayed on the Schedule Tab on the Custom Events screen.	IN-4333
Inventory	The Warehouse Actions Return is now changing the Service Desk Equipment Status from Pending to Complete. Note: With this change, the Return "Quantity" field will no longer be available when returning "In" Equipment on Remove Actions. All items must be returned at the same time for Remove Actions.	IN-4304 IN-4262
General	Fixed issues with the validator when creating an empty database for new installs.
Reporting	Due to licensing the constraints of Oracle Java, we have officially dropped support and switched to using OpenJDK for Crystal Reports. Please submit any requests to upgrade java on our portal help.pcr.com.
Services	The Call Details Tab on the Service form now includes Rated Unbillable calls.	IN-4316
Service Desk	Service Desk Actions will no longer display an erroneous "was not found in the haystack" error on the Service Options field.
Service Desk	Completing a Service Order with Actions no longer produces erroneous "Failed to save record" errors, when there is some other issue on the form (such as no owner or a missing GLA).	IN-3000 IN-4225 IN-4239 IN-4365 IN-4192

Release 2019.7.7 (09-01-2020)

Component	Description	Incident(s)	Documentation
CustomerCenter	Approved Service Requests are now showing in the Service Requests Grid.
Custom Logic	Customer Validation now supports using call function to invoke Write methods for API types.		Custom Validation Syntax
Events & Notifications	Workflow Start Date Notifications/Escalations are now triggered when the Workflow Start Date is set automatically.	IN-4216
Services	The Service Desk tab on Services once again includes Pending Add Actions.	IN-4215
Service Desk	Completing a Service ID Action no longer clears the Path Location.	IN-4188
Service Desk	SDC Workflow steps that should be added at completion are now added to Incidents and Work Orders upon completion.	IN-4196

Release 2019.7.6 (08-06-2020)

Component	Description	Incident(s)	Documentation
API	The Service Desk API now properly supports Service/ Equipment UDFs on Incidents.		Service Desk API Calls
CustomerCenter	The Service Option flags (Billable, Directory, Report 911, etc.) are now set for Task, Change, and Remove Actions on Service Requests created from CustomerCenter.	IN201833105 IN-2965
	SDCs are now properly applied to Service Requests when a matching SDC is found.	IN-4125
	Existing Service Charges are now added to Change Actions on a Service Request.	IN-4125
	Task Actions are no longer converted to or displayed as Add Actions in the Cart. Similarly, in certain cases, Add actions are no longer converted to or displayed as Tasks in the Cart.
Service Desk	Converting an Estimate to an Action now allows applying the Estimate to Task Actions.	IN-4153

Release 2019.7.5 (08-03-2020)

Component	Description	Incident(s)
Billing	The "Test File" column on the Call Details grid has been restored.	IN-3983
Billing	Back Dating a Monthly Recurring Charge Stop Date on a Back-Billing & Forward-Billing Charge no longer generates double Credits	IN-4051
Cable	The Service Location column on the Ports/Pins/Lens grid now displays data for the "To Port" on a Path.	IN-3873
Events	Events that occur during the Fall Daylight Savings Time change should no longer fail.
General	Long-running reports sent via email no longer get stuck in an infinite loop (which prevented the reports from being sent out).	IN-3963 IN-3965 IN-3968 IN-3970 IN-3964 IN-3966
Service Desk	Completing a Service ID Action now sets the Ports/Pins/Lens status to Assigned. (Previously this was set to PDPC)
	Default Charges from Task type Service Catalogs are now applied to Task Actions.	IN-4031 IN-3915
	The Add From SDC button on the Service Desk Workflow tab, now selects from the correct SDCs.	IN-4094
	Adding Equipment to an Incident Request no longer generates an Oops Error.

Release 2019.7.4 (05-20-2020)

Component	Description	Incident(s)	Documentation
API	Added SDC support to the Add Incident API endpoint.		Service Desk API
	Incidents created by API now automatically select an SDC when one is not provided.
	Added the 'bill_date' parameter to the Service Charges API endpoint. This allows setting a Start Date for recurring charges via the API.	IN-3375	Service API Calls
Billing	Clicking on the "Switch to full detail view" link, on certain Test Bills, no longer redirects you to an error page.
Cable	The Ports/Pins/Lens Add Range functionality now properly updates Back Connects for ranges over 100 PPLs.	IN-3770
	Various "minor" issues with the Port Side Requirement were addressed.
	Service Desk Remove Actions now set Cable Pairs and Ports/Pins/Lens to Spare upon completion of the Action.	IN-3785 IN-3792 IN-3816
	Adding Multiple Path Legs no longer causes an error when adding a non-spare Ports/Pins/Lens to the same Path.	IN-3039
General	Expanded the Authentication Mapping (AUTH_MAPPING) field on the ROLES table to allow for longer SSO Group names.		Authorization Parameters
Services	When a Service is used on a Service Order that has multiple Actions, the Service Desk tab on the Service form no longer displays data for all of the Actions on that Order. Previously data for unrelated Actions was displayed on the Service Desk tab.	IN-3622 IN-3736

Release 2019.7.3 (04-29-2020)

Component	Description	Incident(s)	Documentation
API	Creating a Service Desk Action via the API now sets the SDC_RECID. This bug prevented Workflows, Charges, etc. on an SDC from adding to the Action.	IN-2909 IN-2894
Billing	Refinements to Billing Invoices Added the GLA Description to the "Bill To" section. Invoices are now more customizable. The following may now be configured: The account info color The table row background-color Show/hide row borders The row border-color Suppress the current date. The date suppression is configurable for all reports, the bill, and Invoice The Invoice Remittance Coupon content is now configurable. The coupon can also be removed from the Invoice. Redesigned the Invoice Remittance Coupon. The Credit Card information was removed from the default design. Fixed layout issues with the PDF version of the Invoice. Renamed "Current Balance" to "Outstanding Balance." (i.e. the total amount due for Net-30, Net-60, Net-90, etc.) Moved the remittance coupon onto a separate page at the end of the Invoice. Tweaks to the Invoice's Payment Table formatting Long descriptions now wrap to the next line Payment date is now mm/dd/yyyy format The "Transaction Details" on the Invoice Printout are now listed and grouped by the Service ID, rather than the charge code.	IN-3519 IN-2859 IN-3207	Invoices Billing Parameters
Billing	The GLA Conflicts grid no longer generates an "Oops Error" when getting the grid count.	IN-3688
General	Numerous E911 Fixes and Improvements. Significantly increased the speed of the E911 Export process. Corrected the Community Name displayed on grids. Frequently the Building Number was displayed, but the Community Name was missing or incorrect. The E911 Export now includes Services with no Locations when determining if a Service should be flagged as a "Delete" in the export.		Exports E911 Feed
Service Desk	The Assigned Workflow and Workgroup grids now include Pending Workflow on Completed Service Desk Orders.	IN-3743

Release 2019.7.2 (03-16-2020)

Component	Description	Incident(s)	Documentation
Billing	Clicking the Billing tab on the Equipment form no longer causes an "oops" error.
Catalogs	Making a Charge Catalog Inactive now stops or deletes the Charges on a Service desk item when the Service Desk item has a status of Pending, Hold, or Complete. If the Service Desk item has a status of Void, Finalized, or Billed, the Charges will not be stopped/deleted. This applies to all Service Desk Equipment and Service Charges. Previously it would attempt to alter items with a status of Void, Finalized, or Billed.	IN-3580
Communications	Added Cisco features: Added the Associated Devices tab for Directory Numbers to the Service Desk Actions Communication form. Added a column to the Endpoint/Phone picker to indicate whether the endpoint/phone has an associated directory number.		Cisco Documentation
	Removed the checkboxes from Cisco Bulk Update Grids.	IN-3480
	The auto-assign for Cisco Gateway Endpoints/Phones on Service Desk Move Actions now uses the "Move To" Location instead of the original Location.	IN-3432	Cisco Documentation
	Adding a new Analog Endpoint/Analog Phone via a Service Desk Action now populates the directory number information from Device Defaults.	IN-3321
General	Refinements to the Demolish Location form: Updated the demolish button image and text Increased the form size Changed the event comment from "Event" to "Scheduled Archive Event"		Locations Location Catalogs
Services	Non-billable Services (i.e., the billable flag is not checked) with Charges, are now picked up by the Aging Process.
Services	The Service Aging process now uses the "Billing Complete" flag to determine if a Service with Charges can be aged. If any of the Charges are not flagged as "Billing Complete" then those Charges are considered Active, and the Service cannot be aged.	IN-3570 IN-3566
Service Desk	Service Desk Printout fixes: Saving the Print Prefs on the Service Order grid, and printing an Action, no longer leaves off the child data from the Action(s). The Service ID now displays on Service Desk Action printouts. Printing the Actions for a Service Order no longer repeats the Cable info for all of the Actions on each of the Action printouts.	IN-3532
	Returning Service Desk Equipment no longer drops the Equipment Charges when more than one Charge exists on the Service Desk item and those Charges have different Expense Types.	IN-3345
	The GLA Replace Process once again replaces the GLA on Service Charges.	IN-3506 IN-2910 IN-2923

Release 2019.7.1 (02-21-2020)

Component	Description	Type	Incident(s)	Documentation
General	Changes in 2019.7 prevented the Oracle Data load process from disabling foreign keys; this has been fixed.
	Corrected issues with the Bill, Call and Import Archiving processes.
	Cleaned up notices from Dashboard Widgets that could fill up the system log.

Release 2019.7 (01-27-2020)

Component	Description	Incident(s)	Documentation
API	Added the ability to create Work Orders via the API.		Work Order API
API	Added API attachment support for Service Desk API calls.		Service Desk API Calls Service Desk Action API Calls
Billing	The Billing Group totals on the Bill now match the data on the "Billing Group" form.
Cable	Removed the Cable Locations Report and replaced it with an Adhoc report. This report is available in the AdHoc Grid Report Library. The new AdHoc loads significantly faster than the original report grid.	IN201834275 IN201935535 IN201834626	Service Desk Cabling Report Building Adhoc Grids
	The Ports/Pins/Lens Range Generator no longer generates PPL records with the same IP Address when using an IP Address for the Range.
	Adding Multiple Path Legs no longer fails if Ports/Pins/Lens are assigned. Attempting to save multiple Path Legs, when the PPL does not allow multiples, now displays the proper error message to the user. Deleting the Service Desk Path Leg from the Service Desk Path Leg form no longer fails.	IN-3039
Communications	Closing an Avaya form with unsaved data now prompts the user to save the record.
General	Added a "Modified Date" and "Modified By" column to the Department Hierarchy grid. Note: This change may affect saved perspectives.	Users Group 2019
General	Removed the "Password Reset" button on the Add New Users form. (Resetting the password on a User before saving the record would throw an error)
Imports & Exports	Added a Work Order Import.		Work Order Import
	Added a Service Desk Miscellaneous Action Import.		Service Order Imports
	Added a field for the "Associated Project" to the Service Desk Imports and "Associated Problem" to the Work Order Import.		Service Order Imports
	Numerous fixes to Service Desk Imports: The CSR field now requires the Contact to have a Type of "Service Rep." Available Services are now correctly validated against Service Pools and follow the same eligibility restrictions as the Actions form. UDFs now work with Service Desk Imports. Added support for the Action Default GLA field. Services that are not "Assignable" can now be used with Remove or Task Action Imports. The Service Desk Import can now create Task actions without a Service Catalog specified. Only Upgrade/Downgrade Actions require the Service Catalog. The Service Desk Import now generates an error if an Owner is specified for anything other than an Add Action or Owner Change Action. Added validation to the Service Desk Imports to verify the following (any invalid combinations will result in an error): Only Auth Code Services use Class of Service Only Auth Code Services use Auth Code Type Only Backbone or Data Services use Bandwidth Only Phone Services use Report 911 Only Phone Services use Directory Some valid SDCs were throwing an error that the SDC was not valid for the action; this has been fixed. The Service Desk Import no longer ignores the Inactive status on the following fields: Service Rep, Owner Contact, Owner Dept, Requestor, Default GLA, Action Service Host, Action Owner Contact, Action Owner Dept, Action SLA, Action Location, & Action SDC. The Service Desk Import now correctly supports the Move-to Location field on Actions. The Service Desk Import now allows the existing Available Service Catalog to be a parent of the provided catalog. Example: if the Available Service has a Catalog of 'phone,' then the Catalog provided to the Import could be 'phone > Avaya'. However, the Import will error if the provided catalog is 'auth code'. If the SDC field is not mapped on the import definition or is not provided in an import file, the Service Desk Import no longer picks a random SDC. The SDA_Number field mapping was removed from the Service Desk Import. There is no need to set the Action number via an Import at this time. The Service Desk Import no longer allows Category Catalog items (i.e., Equipment, Service, or Charge Catalogs with the Category flag set).	IN201834801	Service Desk Imports
Inventory	Added a "Display SD" button to the Warehouse Actions grid that opens the Service Desk record associated with the Equipment selected on the grid.	IN-2929	Warehouse Actions
	Added the "Manufacturer" and "Manufacturer Part Number" from the Equipment Catalog to the Equipment Grid. Note: This change may affect saved perspectives.	Users Group 2019
	Changed the 'Activity' tab on Equipment to 'Service Desk'.		Service Desk Tab
	Related Equipment Permissions no longer fail to update when updating Equipment Catalog records with more than 1000 child records.	IN201935538
	Returning Equipment on the Warehouse Actions grid now accounts for the Expense Type on the Equipment.	IN-2841
Services	Addressed issues related to Multiple Location Services: Unchecking the Multiple Locations flag on Services and saving the record no longer throws an "XHttp Request Action Failed" error. It is now possible to unset the Multiple Locations flag on a Service that was used on an Incident. Aging a Multiple Location Service that was used on an Incident no longer fails.	IN201833807 IN-2876 IN-2839
Service Desk	Added Service Desk Archiving Functionality It allows users to delete old data, such as Locations, Contacts, and Equipment. It allows users to archive and potentially clean up (delete) old Service Desk Data. Added a tab to the Location form to show records preventing Location deletion (i.e., demolish). It provides the ability to Demolish a Location, which deletes the Location along with all sub-Locations and associated Cable Data. Added a weekly event that will archive Service Desk Items based on the Service Desk Archiving Days setting on the tenant. Added a manual process for archiving individual Service Desk Items that are eligible for Archiving. Added an Archive Grid for each Service Desk type, and printouts for each of the Archived Service Desk types. (there are no forms for Archived Items). Added an Archive Log that contains information on the records that were successfully archived as well as the records that failed to archive. Added a new audit type of "Archive" to indicate (with an Audit record) when a Service Desk Item was archived. The Service Desk Tab on Equipment and Services displays both archived and non-archived Service Desk Items. (Requested at the 2019 Users Group) Archived Data will not be cleaned up automatically (at this time) but can be deleted manually from the grid.	IN-2949 I N201620470 IN201731118 Users Group 2019	Service Desk Archiving Requirements Service Desk Archiving Archive Eligible Grid Archiving Days (set the 'Aging' timeframe) Archive Log Service Desk Events Archive Parameters Services: Service Desk Tab Equipment: Service Desk Tab Usage Tab & Demolish Location
	Added Work Order functionality to allow for one-time Orders that do not create or manage Services. Added Work Orders to the following Grids "Service Rep," "Workgroup" and "Assigned Workflow" Reports. Added a Work Order Import. Added the ability to create Work Orders via the API. Renames all usage of "Orders" in PCR-360 to "Service Orders" to differentiate from Work Orders.		Work Order Requirements Service Desk Work Order Work Order API Work Order Import Associating Work Orders to Service Orders
	Added the Reference Field to Task Actions.		Task Types
	Redesigned the My Service Desk: Assigned and Workgroup grids towards a workflow focus. Note: This change may affect saved perspectives.		My Service Desk Grids
	Removed the Service Desk Cabling Report and replaced it with an AdHoc report. This report is available in the AdHoc Grid Report Library. The new AdHoc loads significantly faster than the original report grid.	IN201834275	Cable Locations Report Building Adhoc Grids
	Fixed a typo in the Cabling section of the Service Order Printout. (This affected the non-graphical version only).
	The Service Desk Charges Tab is now editable for Completed Service Desk Items. (Previously it was read-only)
	Fixed the Email Thread Section of the Service Desk Printout; it now shows values for Name, Subject, and Email.
	The Service ID now displays on Remove Action Printouts for Remove Actions created from the 360 Wizard.	IN-3139
	The Worker column is now populated by the SDC Workflow when it specifies the Workgroup and the Worker. (This stopped working in 2019.5)	IN-3269
	The Service Options field on Actions is no longer disabled after navigating from a Completed or Finalized Action to a Pending Action. This was problematic because if the Service Options were disabled, completing the Pending Action would clear the Service Flags (i.e., Report 911, Directory, Billable, etc.)	IN-3355

Database Changes in 2019.7

Default Schema

Table Name	Change	Table Changes
AUDITS	Updated	Increased the ACTION column from 6 to 7 characters.
EVENTS	Updated	Added the Weekly Archive Event.
PERMISSIONS_GRIDS	Updated	Changed the GRID_SCENARIO column values of 'orders' to 'service-orders'.
SD_TO_ARCHIVE	New
SERVICE_DESK	Updated	ADD COLUMN CREATED_DATE DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, ADD COLUMN PENDING_DATE DATETIME DEFAULT NULL, ADD COLUMN HOLD_DATE DATETIME DEFAULT NULL, ADD COLUMN COMPLETE_DATE DATETIME DEFAULT NULL, ADD COLUMN FINALIZED_DATE DATETIME DEFAULT NULL, ADD COLUMN BILLED_DATE DATETIME DEFAULT NULL, ADD COLUMN APPROVED_DATE DATETIME DEFAULT NULL, ADD COLUMN DENIED_DATE DATETIME DEFAULT NULL, ADD COLUMN VOID_DATE DATETIME DEFAULT NULL
SERVICE_DESK_ACTIONS	Updated	ADD COLUMN CREATED_DATE DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL ADD COLUMN PENDING_DATE DATETIME NULL ADD COLUMN COMPLETE_DATE DATETIME NULL ADD COLUMN FINALIZED_DATE DATETIME NULL ADD COLUMN BILLED_DATE DATETIME NULL ADD COLUMN HOLD_DATE DATETIME NULL ADD COLUMN VOID_DATE DATETIME NULL
SERVICE_DESK_APPROVAL	Updated	ADD CREATED_DATE DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL
SERVICE_DESK_ARCHIVE_LOG	New
SERVICE_DESK_INCIDENTS	Updated	ADD CREATED_DATE DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL
SERVICE_DESK_PROBLEMS	Updated	ADD CREATED_DATE DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL
SERVICE_DESK_CABLING_PIT	Updated	Increased the size of columns FROM_EQUIPMENT_CATALOG and TO_EQUIPMENT_CATALOG columns to 255 characters
SERVICE_DESK_WORK_ORDERS	New
SERVICE_DESK_WORKFLOW	Updated	ADD COLUMN CREATED_DATE DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, ADD COLUMN PENDING_DATE DATETIME DEFAULT NULL, ADD COLUMN HOLD_DATE DATETIME DEFAULT NULL, ADD COLUMN VOID_DATE DATETIME DEFAULT NULL
IMPORT_RECORD_TYPES	Updated	Changed the NAME column values of 'Service Desk' to 'Service Order'.
IMPORT_RECORD_TYPES_COLS	Updated	Removed any references to the Service Order Action number in the Service Desk Import definitions.

Metadata Schema

Table Name	Change	Table Changes
USAGE_LOCATION	New

Archive Schema

Note: The archive schema is new as of Release 2019.7.

Table Name	Change	Table Changes
SDA_SERVICE_DETAILS	New
SERVICE_DESK	New
SERVICE_DESK_ACTIONS	New
SERVICE_DESK_ACTIVITY	New
SERVICE_DESK_ASSOC	New
SERVICE_DESK_ATTACHMENTS	New
SERVICE_DESK_CABLING	New
SERVICE_DESK_CHARGES	New
SERVICE_DESK_COMMUNICATION	New
SERVICE_DESK_CONTACTS	New
SERVICE_DESK_EQP	New
SERVICE_DESK_EQP_ACT	New
SERVICE_DESK_EST_EQP	New
SERVICE_DESK_EST_LABOR	New
SERVICE_DESK_EST_CHARGES	New
SERVICE_DESK_GLA	New
SERVICE_DESK_INC_EQP	New
SERVICE_DESK_INCIDENTS	New
SERVICE_DESK_INQUIRY	New
SERVICE_DESK_LABOR	New
SERVICE_DESK_PROBLEMS	New
SERVICE_DESK_QUICKTICKS	New
SERVICE_DESK_THREAD	New
SERVICE_DESK_WORKFLOW	New
SERVICE_DESK_WORKFLOW_ACT	New
SERVICE_DESK_WORK_ORDERS	New
USER_DEFINED_FIELDS_VALS	New

2019.6

Notable Changes

- Added the following columns to the Service Desk Equipment tab:
  - Equipment ID
  - Asset Tag
  - Serial Number
  - Mac Address
- Renamed the Equipment column to Catalog: now the Catalog column only displays the Equipment Catalog Name and Description.
- Adding Location Permissions to a Service Catalog no longer prevents selecting any Service Catalog on Upgrade/Downgrade Actions. Catalogs are now appropriately restricted by the Locations on the Service Catalog and Service Pools.

Please review the Database Changes in 2019.6 and make any necessary changes to your Adhoc Grids, Custom Events, and API calls.

Release 2019.6.2 (01-27-2020)

Component	Description	Incident(s)	Documentation
Billing	Annual Recurring Charges, Semi-Annual Recurring Charges, and Quarterly Recurring Charges now bill correctly.		Forum Post
Cable	Renumbering a Cable Path no longer fails on Services with multiple associated Service Desk Actions.
	Removing Service Desk Cabling (Deleting or Voiding) now returns the cable statuses to Assigned.
	The Service Desk Cabling Auto-Assign no longer throws a "Duplicate Record" error indiscriminately. (This prevented closing Service Orders.)	IN-3018 IN-3263
	The Equipment ID (for Equipment that does not have a Location), is now displayed in the Completed Cabling tab.
Communications	Cisco "Change" Actions now respect the selected Directory Number (DN) on the Action.	IN-3233
Communications	Cisco Analog Endpoints/Phones now use the correct form.	IN-3319
CustomerCenter	Now, when a request is approved in CustomerCenter, the remark is created showing the actual approved amount instead of $0.00.	IN-3351
	Reopening the "Order Details" for Task Actions no longer shows the wrong form.	IN-3302
	The Approval Grid no longer shows the wrong Service Desk Item when using the Service Request link on the Approval page.	IN-3244 IN-3254
	The Owner on a Change Action now matches the Owner on the Service record (rather than defaulting to the logged-in user)
Imports & Exports	The Full Cable Path Import no longer replaces the path with different Service values (that are on the same Location).	IN-3303
Service Desk	The Equipment Catalog is no longer missing from the Service Order Printout.	IN-3357

Release 2019.6.1 (12-10-2019)

Component	Description	Type	Incident(s)	Documentation
Cable	The Service Desk Cabling Auto-Assign now properly links existing Paths. Previously, the auto-assign was throwing a Duplicate Path error.		IN-3018

Component

Description

Type

Incident(s)

Documentation

Cable

The Service Desk Cabling Auto-Assign now properly links existing Paths. Previously, the auto-assign was throwing a Duplicate Path error.

IN-3018

Release 2019.6 (11-14-2019)

Component	Description	Incident(s)	Documentation
API	The API now properly obeys Service Location Permissions. Previously, if no Service Catalogs set any Location Permissions (used for Services), the validation failed and would not create the Service Desk item.	IN-2846 (IN201935500)	Service Pools Upgrade/Downgrade Actions
API	Fixed various issues with Service Desk API Calls: The 'prob_code' and 'res_code' parameters now work as intended; both need to match against the provided Catalog. Owner validation now works as intended; the owner needs to match the owner on the Service or Equipment.		Service Desk API
Cable	The Show All/Show Restricted slider setting on pickers can now be saved with a Picker Perspective.	IN-2987 (IN201834047)
CustomerCenter	Changing the Stand-Alone Equipment Quantity from within the cart (using the Qty arrows) now carries through to the Service Request.	IN201936263
CustomerCenter	Phone numbers in the My Services/Equipment grid and on the Directory page are now correctly formatted like phone numbers.		Directory
General	The Custom Event Schedule form is no longer read-only.
	LDAP role mapping no longer fails when a group name contains commas.
	User-Defined Fields (UDFs) can now be used as the sorting column on a Saved Perspective.	IN-2990 (IN201834114)
Imports & Exports	The Equipment Catalog Import can now import Equipment Catalog User-Defined Fields.	IN-2893 (IN201936333)
Imports & Exports	The API now correctly obeys Service Location Permissions. Previously, if no Service Catalogs set any Location Permissions, the validation failed and would not create the Service Desk item.	IN-2846 (IN201935500)	Service Pools Upgrade/Downgrade Actions
Service Desk	Added the following columns to the Service Desk Equipment tab: Equipment ID Asset Tag Serial Number Mac Address This change also: Renamed the Equipment column to Catalog. Changed the Catalog column, so it only displays the Equipment Catalog Name and Description.	Part of IN-2885 (IN201936207)	Service Desk Equipment
	Service Desk Task Actions now load Default NRC Charges from the Charge Catalog. Task Actions will not allow MRC Default Charges.
	A change in 2019.3 caused several extra columns to appear on the Service Desk Equipment tab; the Equipment tab now displays the correct number of columns.		Service Desk Equipment
	Adding Location Permissions to a Service Catalog no longer prevents selecting any Service Catalog on Upgrade/Downgrade Actions. Catalogs are now appropriately restricted by the Locations on the Service Catalog and Service Pools.	IN-2846 (IN201935500)	Service Pools Upgrade/Downgrade Actions
	Inactive Service Pools no longer prevent selecting a Service Catalog on Upgrade/Downgrade Actions.	IN-2846 (IN201935500)	Service Pools Upgrade/Downgrade Actions

Database Changes in 2019.6

There are no database changes for 2019.6.

2019.5

Notable Changes

Optimized the Charges Grid and Ports/Pins/Lens Picker.
Added an Open Source Button to the Charges Grid.
Added Ports/Pins/Lens Transfer Import
Added an Add From SDC button to the Service Desk Workflow tab
Added a unique key on Ports/Pins/Lens. The Port/Pin/Len Side is now required. This prevents users from creating duplicate Ports/Pins/Lens records and prevents the system from creating duplicate Ports/Pins/Lens records from an Import.
- Note: When the test system is upgraded to 2019.5 or later, PCR will add an Adhoc grid (to test and production) for any customers who currently use cable. Customers are responsible for cleaning up the data on production before they can upgrade to 2019.5 (or later) in production. We will NOT upgrade any customers to 2019.5 or later if the Adhoc grid still contains duplicate Ports/Pins/Lens records. If you have any issues cleaning up the data, please send an email to help@pcr.com for assistance.

Please review the Database Changes in 2019.5 and make any necessary changes to your Adhoc Grids, Custom Events, and API calls.

Release 2019.5.2 (11-13-2019)

Component	Description	Incident(s)
Billing	Using GLA Splits no longer cause the Bill Progress Percentages to go above 100%.
	The Invoiced Amount on the Invoice Printout, Invoices Grid, and the GLA Account Totals/Current Balance now includes the Taxed Amount.	IN-2921 (IN201936601)
	Calls and Usage attached to Services with Split Expense GLAs Percentages now bill on each split. (Previously only the first split was billed).
	The Override Amount on Service Desk Equipment Charges is now carried over to the Equipment Charges after the Service Desk Item is Finalized.	IN-2922 (IN201936602)
CustomerCenter	Users can now set the Account Number/Default GLA on Stand-Alone Equipment. However, the Owner and GLA MUST be the same for all pieces of Stand-Alone Equipment. (i.e. You set the Owner and GLA on once piece of Stand-Alone Equipment and it applies to all of the Stand-Alone Equipment for that Request).	(IN201936659)
CustomerCenter	Creating a New Contact with CustomerCenter no longer throws an error.

Release 2019.5.1 (10-23-2019)

Component

Description

Type

Incident(s)

Documentation

Billing

Charges stopped exactly on the Start Date of a Bill now Prorate correctly.

IN201936583

Test Bills and Bill Estimates no longer flag charges as Billing Complete.

General

Corrected an issue that:

Prevented the Bulk Update from updating Services (for customers who do not user Service Pools)
Prevented Service Actions from saving (for customers who do not have any Auth Code Types defined).

Release 2019.5 (10-07-2019)

Component	Description	Incident(s)	Documentation
API	Added token-based authentication to Service Host REST API for Team Dynamix.		Service Host Rest APIs
Billing	Added the following columns to the Admin → Billing → View/Report → Charges Grid: Prorate Flag (Only if the configuration BILL_MRC_CHANGE_FORCE_PRORATE is turned off) MRC Start Date (only populated for MRCs) MRC Stop Date (only populated for MRCs) NRC Transaction Date (only populated for NRCs) Annual/Semi-Annual/Quarterly Recurring Date (only populated for Alternate Recurring Charges) Annual/Semi-Annual/Quarterly Stop Date (only populated for Alternate Recurring Charges)		Charges Report
	Added an Open Source button to the Admin → Billing → View/Report → Charges Grid. The new button opens the Source record: Service, GLA, Equipment, or Service Desk.
	Optimized the Admin → Billing → View/Report → Charges Grid to improve grid load times significantly. By default, the grid now autoloads (rather than waiting for you to add a filter or refresh the grid).
	The Bill grid's Check Progress form no longer shows more than 100% in the Processing Bill Calls section (when multiple Expense Object Code Overrides are defined). Note: The Process Bill Calls section may still show more than 100% in if GLA splits are used.
	GLA Changes now properly update Alternate Recurring Charges (Annual Recurring, Semi-Annual Recurring, and Quarterly Recurring).		Known Issue Forum Post GLA Charges Import Service Charges Import Charge Catalog Imports Services API (Charges) GLA API (Charges) Equipment API (Charges) Charge Catalogs Inventory Tabs - Charges
Cable	Optimized the Ports/Pins/Lens picker for Equipment records that have more than 10,000 ports.
Cable	Added a unique key on Ports/Pins/Lens. The Ports/Pins/Lens Side is now required. Note: When the test system is upgraded to 2019.5 or later, PCR will add an Adhoc grid (to test and production) for any customers who currently use cable. Customers are responsible for cleaning up the data in production before they can upgrade production to 2019.5 (or later). If you would like to review the Adhoc Queries or add them before scheduling your upgrade, please download the SQL file from the release notes. If you have any issues cleaning up the data, please send an email to help@pcr.com for assistance.		Duplicate PPL Adhoc Query Downloads MySQL Oracle
Communications	Added multiple enhancements to the Avaya Module: Avaya Phone Templates: Form and Grid Adds "System Use Templates" that can be copied to make customized templates Added support for 9608SIP set types		Avaya Documentation
CustomerCenter	Approvers are now able to see the Cancel Request Button on the View Request Page for their Requests.	IN201935025
CustomerCenter	The original Owner of a Service or Equipment is now preserved for a Change Owner Request.	IN201936238 IN201834895
General	Fixed an issue where some tool-tips, filters, and hover images would appear behind a PCR-360 form.	IN201731534
General	Users can now update existing List Values.	IN201936427
Imports & Exports	Added a Ports/Pins/Lens Transfer Import that will transfer ports from one Equipment record to another.		Ports/Pins/Lens/ Transfer Import
Services	The Associated Service Picker on Equipment now restricts the Services by the Location and Service Locations (for Multiple Location Services). The Service Location(s) must match (or be a descendant of) the Location specified on the Equipment record.
Service Desk	Added an Add From SDC button to the Service Desk Workflow tab. This button allows adding SDC workflow to any existing Service Desk item that is not closed (i.e., Void, Denied, Finalized, Billed, etc.).		Additional SDC Workflow: Requirements Workflow SDC
	Add Actions created by the PCR-360 Wizard now set the Service Options (Billable, Report 911), and the Default Service Host using the Service Catalog's defaults.	IN201833229 IN201834684
	Fixed alignment issues with the Service Order Description on the Service Desk Printout.	IN201936068
	The Workgroup and Worker fields are once again editable on the Service Desk Labor Form.	IN201935841 IN201935576	Service Desk Labor
	Equipment SDCs no longer match SDCs with the 'Any' SDC type selected. Equipment SDCs must exactly match the Equipment Catalog on the Service Desk Item.

Database Changes in 2019.5

Table Name	Change	Table Changes
Table Name	Change	Table Changes
`PORTS_PINS_LENS`	Updated	CHANGE `PORT_SIDE_LISTS_RECID` `PORT_SIDE_LISTS_RECID` `int` `NOT` `NULL;` `Added a Unique index on` `(EQUIPMENT_RECID, PORT, PORT_SIDE_LISTS_RECID)`
SERVICE_HOSTS	Updated	ADD COLUMN LOGIN_ADDRESS VARCHAR(100) NULL AFTER ADD COLUMN LOGIN_HEADERS LONGTEXT NULL ADD COLUMN TOKEN LONGTEXT NULL ADD COLUMN RATE_LIMIT INT NOT NULL DEFAULT 0 ADD COLUMN RATE_LIMIT_REMAINING INT NOT NULL DEFAULT 0 ADD COLUMN RATE_LIMIT_RESET DATETIME NULL AFTER

2019.4

Notable Changes

We added Historical Cable Data to Service Desk. This corrects several issues with Cable Statuses on Actions. In particular, completed Actions will now reflect the Cable status at the time of completion, not the current cable status.
We have converted Service Order Only Actions to Task Actions. This change gives customers a more generic way of tracking work on a Service Order; since not all work relates directly to a Service. This change replaces the Service Catalog type of "Service Order Only" with "Task" and adds a "Task" option to the Action selector on Service Desk Actions. Services cannot be created using "Task" type Service Catalogs.
We added several new Cisco Features and fixed several bugs.
We removed calDav support from the PCR-360 Calendar.
Users with an Administrator role can now add the Row ID column to any grid or picker.
When an Action is saved with a Service selected, Service Remarks are now automatically copied into the Activity/Remarks tab of the Action.
Added the ability to run Imports in Batches.

Please review the Database Changes in 2019.4 and make any necessary changes to your Adhoc Grids, Custom Events, and API calls.

Release 2019.4.3 (11-13-2019)

Component	Description	Incident(s)
Billing	Using GLA Splits no longer cause the Bill Progress Percentages to go above 100%.
	The Invoiced Amount on the Invoice Printout, Invoices Grid, and the GLA Account Totals/Current Balance now includes the Taxed Amount.	IN-2921 (IN201936601)
	Calls and Usage attached to Services with Split Expense GLAs Percentages now bill on each split. (Previously only the first split was billed).
	The Override Amount on Service Desk Equipment Charges is now carried over to the Equipment Charges after the Service Desk Item is Finalized.	IN-2922 (IN201936602)

Release 2019.4.2 (10-23-2019)

Component

Description

Type

Incident(s)

Documentation

Billing

Charges stopped exactly on the Start Date of a Bill now Prorate correctly.

IN201936583

Test Bills and Bill Estimates no longer flag charges as Billing Complete.

General

Corrected an issue that:

Prevented the Bulk Update from updating Services (for customers who do not user Service Pools)
Prevented Service Actions from saving (for customers who do not have any Auth Code Types defined).

Release 2019.4.1 (09-13-2019)

Component	Description	Type	Incident(s)	Documentation
General	Addresses slowness issues with the 2019.3 upgrade. Note: This fix reverts a bugfix introduced in 2019.1. "Fixed an issue where saving a Perspective sometimes unchecked the Auto Load Data checkbox." This bug will be addressed in a future release.		IN201936364 IN201936437

Component

Description

Type

Incident(s)

Documentation

General

Addresses slowness issues with the 2019.3 upgrade.

Note: This fix reverts a bugfix introduced in 2019.1. "Fixed an issue where saving a Perspective sometimes unchecked the Auto Load Data checkbox." This bug will be addressed in a future release.

IN201936364

IN201936437

Release 2019.4 (08-26-2019)

Component	Description	Documentation
API	Added a Service Desk Task Action endpoint.	Service Desk API Calls
Billing	Added a GLA format column to the Invoices grid.
Billing	The GLA Replace process now adds a remark to the GLA record and the Replacement GLA record containing the Original GLA, the New GLA, the effective date, and the user that updated the record.

2020

Notable Changes

Release 2020.2.5 (12-16-2020)

Component

Description

Type

Incident(s)

Documentation

Billing

Cable

Calls & Rating

Imports & Exports

Inventory

Reporting

Service Desk

Release 2020.2.4 (10-06-2020)

Component

Description

Type

Incident(s)

Documentation

API

Billing

Custom Logic

Inventory

General

Reporting

Services

Service Desk

Release 2020.2.3 (09-01-2020)

Component

Description

Type

Incident(s)

Documentation

CustomerCenter

Custom Logic

Events & Notifications

Services

Service Desk

Release 2020.2.2 (08-06-2020)

Component

Description

Type

Incident(s)

Documentation

API

CustomerCenter

Service Desk

Release 2020.2.1 (08-03-2020)

Component

Description

Type

Incident(s)

Documentation

Billing

Cable

Events

Inventory

General

Service Desk

Release 2020.2 (06-04-2020)

Component

Description

Type

Incident(s)

Documentation

Billing

Imports & Exports

Inventory

Service Desk

Database Changes in 2020.2

Default Schema

Metadata Schema

Archive Schema

Notable Changes

Release 2020.1.5 (10-06-2020)

Component

Description

Type

Browser not supported