SWS Self-Audit Procedure

Purpose

SWS licensing is tiered by the number of active web services configured in your PeopleSoft environment. To keep licensing simple and respect the reality that most PeopleSoft environments are operated inside regulated or air-gapped networks, Cedar Hills Group does not connect to your systems or install phone-home telemetry. Instead, compliance is verified with a customer-run self-audit: once a year (or within 30 days of a request from Cedar Hills Group), you run a short SQL query and send the result.

This page documents the query, how to submit the result, and the true-up process if your active web service count has grown past your License Tier.

What Counts as a Web Service

A “web service” for licensing purposes is a single active row in the SWS configuration record C_SWS_CONF_TBL. Inactive configurations do not count.

The C_SWS_CONF_TBL record is documented on the SWS Installation page as one of the delivered SWS objects. The Active flag and the URL path (CHG_DE_PATH) are described on the SWS Configuration page.

The Self-Audit Query

Run the query below once per PeopleSoft environment that has SWS installed (including Development, Test, and Production). Each environment is a separate line item for licensing.

-- SWS License Self-Audit — count of active web services in this environment.
-- Run this as a PeopleSoft DBA or equivalent, once per environment, and
-- return the result to Cedar Hills Group.
SELECT
    COUNT(*) AS ACTIVE_WEB_SERVICES
FROM PS_C_SWS_CONF_TBL
WHERE ACTIVE = 'Y';

For a more detailed report that lists every active web service path — useful for verifying the count and identifying stray or obsolete configurations before you report — run:

-- SWS License Self-Audit — detailed listing of every active web service.
SELECT
    CHG_DE_PATH AS URL_PATH,
    ACTIVE
FROM PS_C_SWS_CONF_TBL
WHERE ACTIVE = 'Y'
ORDER BY CHG_DE_PATH;

How to Submit Your Result

1. Run the count query in every PeopleSoft environment that has SWS installed.
2. Record the DBNAME of the environment and the active web service count. For environments with more than the count alone would justify, also run the detailed listing query and export it to CSV.
3. Email the results to Cedar Hills Group at [compliance@cedarhillsgroup.com — confirm address]. Include:
   • Your organization name and the License Tier on your current purchase order.
   • For each PeopleSoft environment: the DBNAME, a short label (Dev, Test, Prod), and the active web service count.
   • Optionally, the detailed listing CSV for your production environment.

CSV export is the most convenient submission format — most PeopleSoft DBAs already have SQL tools that export query results to CSV in two clicks.

Frequency

Run the self-audit:

• Annually on the anniversary of your License Tier effective date, or
• Within 30 days of a written request from Cedar Hills Group (which under the License Agreement may be made no more than once per calendar year).

If You Are Over Your Tier

If your active web service count has grown past your License Tier cap, the situation is treated as a true-up, not a penalty. The goal is correct licensing, not a gotcha.

1. Contact Cedar Hills Group. The contact details on the Purchase SWS page apply.
2. Cedar Hills Group will issue a purchase order for the next-higher tier, prorated for the remainder of your current support term.
3. Once the true-up purchase order is paid, your License Tier is upgraded retroactive to the date the overage began.
4. You continue operating SWS without interruption during the process.

There is no penalty for over-reporting. If you report 31 active web services on a Pro tier (cap of 30), the resolution is to move you to Enterprise at the prorated delta. Reporting accurately, even when you are slightly over, is the intended use of this procedure.

Frequently Asked Questions

Do I need to report inactive configurations? No. Only rows where the Active flag is set to Yes count. Inactive rows may be left in place for historical reference without affecting your license count.

What if one web service is defined in Test and Prod — is that one or two? Each PeopleSoft environment is audited separately. A single web service configured in both Test and Prod counts as one active web service in each environment. The License Tier caps apply per environment, not globally across all environments.

What if Cedar Hills Group never asks for an audit? The License Agreement requires you to run the self-audit annually on your license anniversary regardless of whether Cedar Hills Group requests it. If your result is within your tier, a short confirmation email is sufficient.

What happens to my audit result after I send it? Cedar Hills Group treats audit submissions as confidential business information. Results are used only to confirm licensing compliance and to issue true-up purchase orders when required. See the confidentiality terms in the License Agreement.

Can I automate the audit? Yes. The count query is safe to schedule as a PeopleSoft Query or a database job and have the result emailed to your SWS license owner. Some customers schedule the query quarterly to spot trends before the annual audit.