CHRS Knowledge Base

Requesting CHRS environment to connect to CS environment

Updated on

This article provides guidance for production campuses on the steps to follow when requesting a non-production CHRS environment connection to their own masked Campus Solutions environment.

Overview

Databases are not provided to campuses for testing scenarios that require full integration between CS and CHRS, such as Tools Testing, MP Validation, etc. Campuses must supply their own masked CS database to connect to a CHRS non-production environment.

Before submitting the request, campuses are responsible for:

  • Ensuring that the refresh of their masked Campus Solutions (CS) environment aligns with the designated CHRS environment.

Once given the green light, campuses must:

  • Establish a database link from their masked CS environment to the designated CHRS environment.
  • Complete the required integration setup within their own masked CS environment.

Submit Request

Step 1: Submit a ServiceNow ticket

  • Type: Request
  • Category: CMS-CHRS
  • Subcategory: Integration
  • Ticket Short Description:
    • In the ticket short description, indicate that your campus needs to have CHRS connected to your own masked CS environment (example: Request for HACHRPSA to Connect to CAFULTST-Fullerton)
  • Description:
    • In the description provide the following:
      1. CS Database Name
      2. CS Database Clone Date
      3. CS URL ( Under CSU_CHRS_CS_INTEGRATION_POST)
      4. CHRS Database Name
      5. Reason for Request

The CS environment to be connected must be masked.

Step 2: CMS will complete the necessary steps to configure integration in the requested non-production CHRS environment, and update ServiceNow ticket that campus can proceed to connect their own masked CS environment.

Configure Campus Masked CS Environment

NOTE: The following steps must be completed by the campus in their own CS environment! 

Step 1: Navigate to the Domain Status 

  • Navigation: Menu > PeopleTools > Integration Broker > Service Operations Monitor > Administration > Domain Status

Step 2: Confirm the Domain Status is active

example domain status

Step 3:  Navigate to the Service Operations page

  • Navigation: Menu > PeopleTools > Integration Broker > Integration Setup > Service Operations > General page

Step 4: Confirm that the following Service Operations are active, have the correct URL prefixes, and reference the appropriate CHRS database in the URL.

  • CSU_SEC_USERID
  • CSU_PROVISION_INT

Use the CSU IB Monitor in CHRS to verify the correct URL prefixes required for the Service Operations (e.g., http://chr.hrdev.cmsdc/calstate.edu/)

example of CS database page first half of page
example of CS database page second half of page

Step 5: Confirm that this Service Operations is active. 

  • CSU_CHRS_CS_INTEGRATION_POST 

Step 4: Confirm the following Service Operations are inactive as they are related to PDM functionality in CS

  • CSU_MDH_POST
  • CSU_MDH_Local

Step 7: Create DB link from CS to CHRS

exec
system.csu_dblinks.build_hrxcs('hachr***');
Click to copy

Before executing, confirm the target database name.

Step 8: Recreate the Crosswalk table using SQL

DELETE FROM PS_CSU_CHRS_XREF;
INSERT INTO PS_CSU_CHRS_XREF(CSU_CHRS_ID, CSU_CS_ID)
SELECT CSU_CHRS_ID, CSU_CS_ID
FROM PS_CSU_EMPL_MAP_VW@CSU_CS_HR_LINK A , PS_INSTALLATION B
WHERE (B.COMPANY = 'XXX' AND A.BUSINESS_UNIT = 'XXXXX');
COMMIT;
Click to copy

Before you execute, update the XXXXX. The campus codes can be located in the CHRS Library

Step 9: Complete Campus Integration Validation Checklist (Without CMS) to confirm integration is setup correctly between CS and CHRS. 

End of Article

0 Comments

Add your comment

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Previous Article (job aid) Connect CS to CHRS (DB Link Only)
Next Article (job aid) Annual Connectivity Request
Do you need an article? Contact Us