When CHRS database is down for an extended time (Tools, CHRS implementation, etc.), specific steps are taken to ensure minimum impact to the CS and CFS environments. 

Campuses  

• Communicate to campus employees/POIs about the upcoming maintenance for CHRS and encourage all employees/POIS to make any personal data updates in CHRS prior to the maintenance.
• In CS:
  • Run HR Table Refresh in CS (this will allow for static data during CHRS downtime)
  • Pause Automated Processes (BUSN Email Previsioning, Schedule Jobs, etc.)
  • Review both Synchronous Messages to confirm NO errors
• In CFS:
  • Review Asynchronous Messages to confirm NO errors

 App Dev- HR/CHRS

• Send a bulletin regarding CHRS going down and being back up.
• Review both Synchronous and Asynchronous Messages to confirm NO errors in CHRS
• Open ServiceNow tickets and work directly with CO Tech Services for
  • All CHRS scheduled job processes PAUSED for ALL Campuses
  • To use “lock and unlock” scripts to prevent all employees/POIs from accessing CHRS during the maintenance 

Yes, the CHRS Non-PRD Clone Schedule is located here.

The following would be impacted:

• Assigning instructors to classes
• Work study processing.
• Personal Data cannot be saved in CS-Admissions will not function.
• Student Center (baseline may need a modification to address this).

The following would be impacted:

1. Adding / updating ChartFields: Fund, Account, Program, Project, or Class
2. Journal generation of HR data from the HR_ACCTG_LINE table which published the journal ID back to CHRS
3. Messages will error out and Campus IB Administrators will need to resubmit the messages when HCHRPRD IB is back up

If the CHRS database is down, then a notification will be sent to the campuses and no Asynchronous or Synchronous messages will go in or out of CHRS.

When a CS campus is down for an extended time (Tools, CHRS implementation, etc.), specific steps are taken to ensure that only the campus going through the maintenance is impacted.

Campuses

• Communicate to campus employees/POIs and share employees/POIs about the upgrade.
• Submit a ServiceNow ticket with the required 'lock and unlock' scripts for both employees and POIs. These scripts must cover both the CHRS and CS environments and be provided to the Upgrade Team
• In CS:
  • Review both Synchronous Messages to confirm NO errors..
  • Pause Automated Processes (BUSN Email Previsioning, Schedule Jobs, etc.). 

App Dev- HR/CHRS (in CHRS)

• Review both Synchronous Messages to confirm NO errors in CHRS
• Open ServiceNow tickets and work directly with CO Tech Services to PAUSE the following three CHRS job processes during any CS downtime:
  • CSU Employee Refresh
  • CSU POI Status Update
  • CSU WorkStudy Data Refresh

A variety of locations through CS will fail without the DB link from CS. For example 

• Add/Update Person

When a CFS is down for an extended time (Tools, CHRS implementation, etc.), specific steps are taken to ensure that only the campus going through the maintenance is impacted.

Campuses

• Communicate to campus employees/POIs and share employees/POIs about the upgrade.

App Dev - CFS 

• Send a bulletin regarding CFS going down and being back up.

App Dev-HR/CHRS 

• Review Asynchronous Messages to confirm NO errors prior to CFS down time in CHRS.
• Resubmit all Ayshcrnonous messages if errors occur, once CFS is back in CHRS.

All CHRS DB Links will fail and all Ayshcrnonous messages will go into a queued state until they can be resubmitted. The CHRS App Dev team will be responsible for resubmitting all Ayshcrnonous messages in CHRS when able. 

Yes

Yes, CHRS will have daily clones of production, Sunday through Thursday. Campuses can learn more about the clones by visiting the CHRS Non-Production page.

CMS will connect the CHRS Production Support databases to a campus owned CS database based on the annual ServiceNow ticket is submitted. 

Job Aid: Annual Connectivity Request

For requests related to Tools Testing, MP Validation, or similar scenarios, please refer to the following job aid: Requesting CHRS environment to connect to CS environment Job Aid.

For requests related to the annual connection, please refer to the following job aid: Annual Connectivity Request

No. Campuses that do not wish to provide one of their own CS masked database, they will not have integration connection with a CHRS Production Support database.

Campuses should refresh their masked Campus Solutions (CS) environment to align with the CHRS Production Support Environment selected during the ServiceNow ticket submission.

Yes, absolutely! In most cases, a database link provides sufficient access for development and testing directly within Campus Solutions (CS) without the need for full integration. However, if a campus requires full integration beyond the established connection, a ServiceNow ticket must be submitted.

Job Aid: Connect CS to CHRS (DB Link Only)

Job Aid: Requesting CHRS environment to connect to CS environment Job Aid.

Yes

No

Submit a ServiceNow ticket. 

In order to adjust the TNS for the new database take the following template and exchange ??? for the campus letter.

ca???waa =
 (description =
   (address_list =
    (address = (protocol = tcp)(host = ca???waa7.cmsdc.calstate.edu)(port = 1521))
   )
   (connect_data = (server = dedicated)(service_name = ca???waa))
 )

example:  ??? -> BAK   thus cabakwaa or ??? -? EB  thus caebwaa

cabakwaa =
 (description =
   (address_list =
    (address = (protocol = tcp)(host = cabakwaa7.cmsdc.calstate.edu)(port = 1521))
   )
   (connect_data = (server = dedicated)(service_name = cabakwaa))
 )