This article provides guidance for production campuses on the steps to follow when requesting a non-production CHRS database connection to their own masked Campus Solutions environment.
Overview
CHRS production campuses do not have access to create database (DB) links or set up integrations within CHRS. However, they can create DB links and configure integrations within their own masked Campus Solutions (CS) environment. In most cases, a DB link is sufficient for development and testing directly in CS. However, certain scenarios, such as Tools Testing and MP Validation, etc. require full integration between CS and CHRS. When a campus needs to connect a CHRS non-production environment to their own masked CS environment, a ServiceNow ticket must be submitted.
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:
- CS Database Name
- CS Database Clone Date
- CS URL ( Under CSU_CHRS_CS_INTEGRATION_POST)
- CHRS Database Name
- Reason for Request
- In the description provide the following:
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 Service Operations page
- Navigation: Menu > PeopleTools > Integration Broker > Integration Setup > Service Operations > General page
Step 2: 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/)
Step 3: 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 5: Navigate to the Domain Status
- Navigation: Menu > PeopleTools > Integration Broker > Service Operations Monitor > Administration > Domain Status
Step 6: Confirm the Domain Status is active
Step 7: Create DB link from CS to CHRS
exec
system.csu_dblinks.build_hrxcs('hachr***');
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 = 'FUL' AND A.BUSINESS_UNIT = 'FLCMP')
OR (B.COMPANY = 'STA' AND A.BUSINESS_UNIT = 'STCMP')
OR (B.COMPANY = 'CMA' AND A.BUSINESS_UNIT = 'MACMP')
OR (B.COMPANY = 'CI' AND A.BUSINESS_UNIT = 'CICMP')
OR (B.COMPANY = 'CHI' AND A.BUSINESS_UNIT = 'CHICO')
OR (B.COMPANY = 'CMA' AND A.BUSINESS_UNIT = 'MACMP')
OR (B.COMPANY = 'SAC' AND A.BUSINESS_UNIT = 'SACST')
OR (B.COMPANY = 'BAK' AND A.BUSINESS_UNIT = 'BKCMP')
OR (B.COMPANY = 'CHO' AND A.BUSINESS_UNIT = 'COCSU')
OR (B.COMPANY = 'DOM' AND A.BUSINESS_UNIT = 'DHCMP')
OR (B.COMPANY = 'EBY' AND A.BUSINESS_UNIT = 'EBCMP')
OR (B.COMPANY = 'FRE' AND A.BUSINESS_UNIT = 'FRSNO')
OR (B.COMPANY = 'HSU' AND A.BUSINESS_UNIT = 'HMCMP')
OR (B.COMPANY = 'LBH' AND A.BUSINESS_UNIT = 'LBCMP')
OR (B.COMPANY = 'LAS' AND A.BUSINESS_UNIT = 'LACMP')
OR (B.COMPANY = 'MBY' AND A.BUSINESS_UNIT = 'MB000')
OR (B.COMPANY = 'NOR' AND A.BUSINESS_UNIT = 'NRCMP')
OR (B.COMPANY = 'CPP' AND A.BUSINESS_UNIT = 'POCMP')
OR (B.COMPANY = 'SBU' AND A.BUSINESS_UNIT = 'SBCMP')
OR (B.COMPANY = 'SDS' AND A.BUSINESS_UNIT = 'SDCMP')
OR (B.COMPANY = 'SFO' AND A.BUSINESS_UNIT = 'SFCMP')
OR (B.COMPANY = 'SJS' AND A.BUSINESS_UNIT = 'SJ000')
OR (B.COMPANY = 'SLO' AND A.BUSINESS_UNIT = 'SLCMP')
OR (B.COMPANY = 'CSM' AND A.BUSINESS_UNIT = 'SMCMP')
OR (B.COMPANY = 'SSU' AND A.BUSINESS_UNIT = 'SOCMP');
COMMIT;
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