Deltek is conducting routine scans on Vantagepoint cloud-hosted databases to enforce compliance with their policy on SQL custom objects. This effort supports the security, stability, and performance of the platform.

Key Policy Restrictions for Basic and Flex Cloud Levels
The following SQL objects are not allowed when created via custom scripts:

  • Custom tables

  • Custom indexes

  • Custom views

  • Custom triggers

These objects can negatively affect the shared cloud infrastructure and system integrity.

Attached Worksheet – Key Tabs to Review

Tabs that may require action:

  • Custom_Non_Compliant: Lists disallowed objects such as triggers, views, and custom tables. These need to be removed or rearchitected.

  • Schema: Identifies objects not using the .dbo schema. These must be updated.

  • Encrypted: Flags encrypted objects. These must be updated to remove WITH ENCRYPTION.

  • Custom_To_Review: Contains stored procedures and functions that include CREATE or WITH SCHEMA BINDING. Scripts creating permanent tables, views, indexes, or triggers are not allowed in Basic/Flex offerings.

  • Custom_To_Review_Audit: Lists procedures that contain data manipulation statements (INSERT/UPDATE/DELETE) on core Deltek tables but do not include auditing disable logic. These need to be reviewed for compliance with audit requirements.

Informational tabs:

  • All_Custom: Full list of custom objects by type. If empty, no action is needed.

  • Custom_Non_Partner: Custom objects not related to a Deltek partner. Review for compliance.

  • Custom_Partners: Partner-related objects. Coordinate with the partner to evaluate compliance.

  • Custom_API: Stored procedures accessed via API.

  • Workflow: Stored procedures used in workflows, which can help determine the impact of removal or changes.

  • Ext_Schema_Tables: Lists tables added dynamically by the application or via user-defined hubs.

Recommended Actions

Short-Term:

  • Review the Custom_Non_Compliant, Schema, and Encrypted tabs to identify urgent issues.

  • Determine whether any of these objects are required for daily operations.

Within Six Months:

  • Remove or revise all non-compliant objects.

  • For critical objects, seek compliant alternatives (such as workflows, UDHs, or calculated fields).

  • Coordinate with Deltek partners or your integration provider for supported updates.

Support and Resources Deltek encourages clients to work with their internal teams or partners to find compliant solutions. Their support team is also available to offer guidance. If any objects were implemented by a third party, Deltek recommends contacting that provider to discuss updates.

Reference Documentation:

Let us know if you'd like help reviewing flagged objects, determining usage, or reaching out to Deltek. We can assist with both remediation and communication.