Vantagepoint Custom Report: SCG Column Analysis

Understand your data before making configuration changes.

Managing field changes in Vantagepoint shouldn't be a guessing game. Every time you rename a field, hide a column, or change a dropdown in Screen Designer, there is a risk that you might accidentally "break" a hidden workflow or process running in the background.

The SCG VP Column Analysis report gives you X-Ray vision before you make changes.

How it helps you:

• Search Simply: Just type part of a name (like "Project" or "Client") and see results.

• Visualize Usage: We show you exactly which screens and tabs are using that field, so you know what will be affected.

• Workflow Protection: See if that field is triggering any automated alerts or updates. If a field is driving a critical workflow, this report warns you before you delete or modify it.

• Clean Up with Confidence: Want to remove an old field? Check first to see if it’s actually being used, or if it’s sitting empty.

The Bottom Line: Make configuration changes faster and with total peace of mind.

Full-Stack Impact Analysis & Data Dictionary.

When you are refactoring schema or debugging complex customization errors, "checking the front end" is cumbersome at best.

You need to know deep dependencies—stored procedures, views, and data density—to ensure data integrity, but you need a way to do it that isn't clicking around looking for stuff.

The SCG VP Column Analysis engine reveals the entire backend relationship of any column in your database.

Technical Specifications:

• Dependency Mapping: Instantly identifies SQL objects dependent on your target column, including Stored Procedures, Views, and Functions.

• Advanced Workflow Forensics: Traces column usage deep inside workflow logic, including specific Conditions, Modify Actions, and embedded Stored Procedures within the workflow engine.

• Metadata & Density Analysis: Returns precise table locations and row counts. Quickly determine if a column is NULL across the board or heavily populated before you migrate or deprecate it.

• Flexible Search Logic: Supports comma-delimited lists and partial string matching (e.g., searching "cust" returns Customer, CustType, and CustomField schema matches simultaneously).

The Bottom Line: Reduce technical debt and eliminate regression errors during upgrades or customizations.

The 3 images below are samples from a customer database: