1 - SWS License Agreement
1. Parties
This End User License Agreement (the “Agreement”) is between Cedar Hills Group, Inc., a United States corporation (“Licensor”, “Cedar Hills Group”, or “CHG”), and the legal entity identified on the executed purchase order (“Customer” or “Licensee”). The effective date of this Agreement is the date on the executed purchase order (the “Effective Date”).
2. Definitions
- “SWS Software” means the Cedar Hills Group Software Web Services module, delivered as a PeopleSoft Application Designer project containing PeopleCode, records, fields, pages, components, and related configuration objects, and any patches, upgrades, or releases provided by Licensor under this Agreement.
- “PeopleSoft Environment” means a distinct PeopleSoft database instance (a single
DBNAME) operated by Customer, including Development, Test, and Production environments. - “Production Instance” means a PeopleSoft Environment used by Customer to serve live, business-of-record transactions to end users or downstream systems.
- “Web Service” means a single active row in the SWS configuration record
C_SWS_CONF_TBL whose Active flag is set to Yes. Inactive rows are not counted for licensing purposes. The definition aligns with the self-audit procedure. - “License Tier” means the Junior, Pro, Enterprise, or System Integrator tier described on the Purchase SWS page, as identified on Customer’s executed purchase order.
- “Documentation” means the documentation published at
https://sws.books.cedarhillsgroup.com/, including this page. - “Support Hours” means the hours included in Customer’s License Tier for the then-current annual support and maintenance term.
3. Grant of License
Subject to Customer’s compliance with this Agreement and timely payment of the applicable fees, Cedar Hills Group grants Customer a perpetual, non-exclusive, non-transferable, non-sublicensable license to install, operate, and use the SWS Software within the number of PeopleSoft Environments and up to the Web Service count authorized by Customer’s License Tier. The current tier definitions, counts, and prices are published on the Purchase SWS page and are incorporated by reference into this Agreement.
The license is perpetual with respect to the version of the SWS Software delivered under Customer’s then-current support and maintenance term. If Customer elects not to renew annual support, Customer retains the right to continue operating the last-delivered version within the scope of this Agreement, but is not entitled to further patches, upgrades, or support.
4. Restrictions
Customer shall not, and shall not permit any third party to:
- Redistribute, sell, rent, lease, sublicense, or otherwise transfer the SWS Software or any portion of it to any third party.
- Install or operate the SWS Software in any PeopleSoft Environment that is not owned or operated by Customer, or on behalf of any entity other than Customer, except as expressly permitted for the System Integrator tier under a separately executed agreement.
- Remove, alter, or obscure the copyright notices, file headers, or attribution embedded in the SWS Software. See the Copyright Notice page for the required header text.
- Use the SWS Software to develop, market, or operate a product that competes with the SWS Software.
- Exceed the Web Service count authorized by Customer’s License Tier without truing up to the appropriate tier under Section 6.
- Transfer this Agreement, or any rights under it, to a successor entity (including by merger, acquisition, or change of control) without the prior written consent of Cedar Hills Group, which shall not be unreasonably withheld.
5. Source Code and Confidentiality
Customer acknowledges that the PeopleSoft platform requires the SWS Software to be delivered in source-readable form (PeopleCode, records, pages, and related Application Designer objects). The source form of the SWS Software is and shall remain the confidential information and trade secret of Cedar Hills Group.
Customer shall:
- Protect the SWS Software source with the same degree of care Customer uses to protect its own confidential information of similar sensitivity, and in no event with less than reasonable care.
- Restrict access to the SWS Software to employees, contractors, and authorized consultants who have a need to know for the purposes permitted under this Agreement and who are bound by written confidentiality obligations substantially equivalent to those in this Section.
- Not publish, post, share, or otherwise disclose the SWS Software source or any material portion of it to any public or third-party repository, message board, social media platform, AI training data set, or distribution service.
The confidentiality obligations in this Section survive termination of this Agreement.
6. Audit Rights and True-Up
Cedar Hills Group may, no more than twice per calendar year, request that Customer run the standard SWS self-audit procedure published at the Self-Audit Procedure page and return the results to Cedar Hills Group within 30 days of the request. The self-audit is executed entirely by Customer inside Customer’s environment; Cedar Hills Group does not connect to Customer’s systems.
If the self-audit results show that Customer’s Web Service count exceeds the count authorized by Customer’s License Tier, Customer shall true up to the appropriate License Tier within 30 days of the audit result. True-up fees are calculated at the then-current tier pricing published on the Purchase SWS page, prorated for the remainder of the current support term.
Customer’s refusal to run the self-audit, or failure to respond within 30 days, is a material breach of this Agreement under Section 11.
7. Copyright and Ownership
All right, title, and interest in and to the SWS Software, including all intellectual property rights, remain with Cedar Hills Group. Customer receives no ownership interest under this Agreement, only the license expressly granted in Section 3. All rights not expressly granted are reserved by Cedar Hills Group.
The copyright notice required in every SWS Software file is described on the Copyright Notice page. Customer shall preserve those notices in every copy of the SWS Software in Customer’s environments.
8. Support and Maintenance
Support and maintenance is separately renewable and is described on the Purchase SWS page. The first year of support is included in the initial purchase price. Renewal is annual.
The perpetual license granted in Section 3 is not affected by Customer’s decision to renew or decline annual support. If Customer declines renewal, Customer continues to operate the last-delivered version under the terms of this Agreement, without further patches, upgrades, or Support Hours.
9. Warranty
Cedar Hills Group warrants that, for 90 days from the Effective Date, the SWS Software will perform substantially in accordance with the Documentation. Customer’s exclusive remedy, and Cedar Hills Group’s sole obligation, for breach of this warranty is, at Cedar Hills Group’s option, to (a) repair or replace the SWS Software, or (b) refund the license fees paid for the SWS Software and terminate this Agreement.
EXCEPT FOR THE LIMITED WARRANTY IN THIS SECTION, THE SWS SOFTWARE IS PROVIDED “AS IS” AND CEDAR HILLS GROUP DISCLAIMS ALL OTHER WARRANTIES, EXPRESS OR IMPLIED, INCLUDING WITHOUT LIMITATION THE IMPLIED WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, AND NON-INFRINGEMENT.
10. Limitation of Liability
IN NO EVENT SHALL CEDAR HILLS GROUP BE LIABLE FOR ANY INDIRECT, INCIDENTAL, SPECIAL, CONSEQUENTIAL, OR PUNITIVE DAMAGES, OR FOR LOST PROFITS, LOST REVENUE, LOST DATA, OR BUSINESS INTERRUPTION, ARISING OUT OF OR RELATED TO THIS AGREEMENT OR THE SWS SOFTWARE, REGARDLESS OF THE THEORY OF LIABILITY.
Cedar Hills Group’s total aggregate liability under this Agreement shall not exceed the total fees paid by Customer to Cedar Hills Group in the twelve months preceding the event giving rise to the claim.
11. Termination
This Agreement, and the license granted under it, terminates automatically on any material breach by Customer that remains uncured 30 days after written notice from Cedar Hills Group. Material breach includes, without limitation:
- Unauthorized redistribution or disclosure of the SWS Software.
- Refusal to run, or failure to return the results of, the self-audit procedure under Section 6.
- Removal or obscuring of copyright notices required under Section 7.
- Non-payment of undisputed fees when due.
On termination, Customer shall:
- Immediately cease all use of the SWS Software.
- Within 30 days of termination, remove the SWS Software from every PeopleSoft Environment in Customer’s control, and certify in writing to Cedar Hills Group that removal is complete.
12. Governing Law and Venue
This Agreement is governed by the laws of the State of California, without regard to its conflict-of-laws rules. The state and federal courts located in California have exclusive jurisdiction over any dispute arising out of or related to this Agreement.
13. Entire Agreement; Amendments; Assignment; Severability
This Agreement, together with the executed purchase order and the pages of the SWS Documentation expressly incorporated by reference, is the entire agreement between the parties with respect to the SWS Software. It supersedes all prior and contemporaneous communications, whether written or oral.
This Agreement may be amended only by a written instrument signed by an authorized representative of each party.
Customer may not assign this Agreement, in whole or in part, without the prior written consent of Cedar Hills Group.
If any provision of this Agreement is held unenforceable, the remaining provisions shall remain in full force and effect, and the unenforceable provision shall be reformed to the minimum extent necessary to be enforceable.
2 - SWS Self-Audit Procedure
How to run the annual SWS license self-audit. A single SQL query against C_SWS_CONF_TBL returns the active web service count for each PeopleSoft environment.
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.
Customer runs the query, not Cedar Hills Group
Cedar Hills Group does not connect to your PeopleSoft environment, install agents, or collect telemetry. You run the audit query yourself, in your own tool of choice (SQL Developer, PeopleSoft Query Viewer, SQLPlus, TOAD, DBeaver, or any direct database client). You are in full control of the data that leaves your environment.
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;
Validate column names against your installed version
The column name for the Active flag in PS_C_SWS_CONF_TBL is shown here as ACTIVE. Depending on the installed release of SWS, the column may also appear as EFF_STATUS (with value 'A' for active) or under a CHG_-prefixed name. Before treating an audit result as final, confirm the exact column name against the record definition in your Application Designer or with DESCRIBE PS_C_SWS_CONF_TBL (Oracle) / sp_columns (SQL Server). Update the WHERE clause to match.
How to Submit Your Result
- Run the count query in every PeopleSoft environment that has SWS installed.
- 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. - Email the results to Cedar Hills Group at compliance@cedarhillsgroup.com. 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.
- Contact Cedar Hills Group. The contact details on the Purchase SWS page apply.
- Cedar Hills Group will issue a purchase order for the next-higher tier, prorated for the remainder of your current support term.
- Once the true-up purchase order is paid, your License Tier is upgraded retroactive to the date the overage began.
- 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.
3 - SWS Copyright Notice
Copyright notice embedded in every SWS file, the customer’s obligation to preserve it, and a short explanation of why it matters to both parties.
Copyright Statement
Copyright © Cedar Hills Group, Inc. All rights reserved.
SWS (Software Web Services) is the property of Cedar Hills Group, Inc. and is protected by United States and international copyright law. Unauthorized reproduction, redistribution, or disclosure of any portion of SWS is prohibited.
Every file delivered as part of SWS — PeopleCode, records, fields, pages, components, and supporting scripts — carries a header comment substantially in the following form:
/*
* SWS (Software Web Services)
* Copyright (c) Cedar Hills Group, Inc. All rights reserved.
*
* This file is licensed to the end customer under the SWS License Agreement.
* See: https://sws.books.cedarhillsgroup.com/legal/license-agreement/
*
* Redistribution, public disclosure, or removal of this notice is prohibited.
*/
The exact wording may vary slightly between object types — PeopleCode comments use /* ... */, while some Application Designer objects record the notice in their Description or Long Description fields — but the substance is the same: this file belongs to Cedar Hills Group, and its use is governed by the SWS License Agreement.
Customer’s Obligation to Preserve the Notice
Under Section 4 of the License Agreement, the customer agrees not to remove, alter, or obscure any copyright notice or file header delivered with SWS. This obligation applies to:
- The SWS source files as installed in every PeopleSoft environment.
- Any copy of the SWS source files moved into version control, backup, archive, or migration tooling.
- Any excerpt of the SWS source shared with internal staff, contractors, or consultants authorized to access SWS under the License Agreement.
The customer may add its own comments — local implementation notes, change history, internal ticket references — but must not remove or modify the Cedar Hills Group header.
Removal of the header is listed in the License Agreement as a material breach and is a ground for termination of the license.
What Copyright Protects — and Why It Matters to You
Copyright protects original creative expression automatically from the moment it is fixed in a tangible form. For SWS, that means every PeopleCode file, every Application Designer object, and every line of logic that ships to the customer is protected under United States and international copyright law the moment Cedar Hills Group writes it. No registration is required for protection to attach (though Cedar Hills Group may register copyrights with the U.S. Copyright Office as a matter of course).
Practically, copyright gives Cedar Hills Group the legal right to act if SWS is copied, redistributed, published, or disclosed outside the scope of the License Agreement — including seeking injunctive relief, damages, and, where applicable, statutory damages and attorney fees.
For the customer, that protection is useful for two reasons:
- It is what makes the license enforceable. The license is valuable to the customer precisely because the thing being licensed is protected property. A product that anyone could freely copy would not be sustainable for Cedar Hills Group to support long term.
- It clarifies responsibilities within the customer’s organization. The notice on every file makes it clear to every engineer, contractor, and consultant that the code is third-party licensed material — not the customer’s own code — and that the usual “copy this into the team snippets folder” reflex is not appropriate.