CHRS Knowledge Base

HR Table Refresh in CS

Updated on

Overview

This job aid guides users through the process of running the HR Table Refresh in Campus Solutions, enabling the use of local tables rather than accessing them through Database Links.

Background

The HR Table Refresh runs on a campus specified recurrence (daily, twice a day, etc.) to populate the CS local tables with data from CHRS. The Application Engine in this process uses the DB Link CSU_CS_HR_LINK to pull CHRS Source data into the local tables in Campus Solutions.  This allows for faster performance when using processes that require CHRS integration such as Instructor Term Workload, Work Study and Student Center.   

Local CS Tables (Target)
  • CSU_DPT_TBL_STG
  • CSU_JC_TBL_STG
  • CSU_JOB_STG
  • CSU_PER_ORG_STG
  • CSU_POSTN_STG
CHRS Data (Source)
  •  DEPT_TBL
  • JOB
  • JOBCODE_TBL
  • PER_ORG_ASGN
  • POSITION_DATA

Setup Reoccurrence (CSU Refresh HR Data)

Step 1: In Campus Solutions, Navigate to Menu > CSU SA Baseline > CSU Integrations > CSU Refresh HR Data

In Campus Solutions, Navigate to Menu > CSU SA Baseline > CSU Integrations > CSU Refresh HR Data

Step 2: Create or enter Run Control.

Step 3: Select tables to populate. 

You must create at least one daily run control with ALL tables selected.  

Ad hoc processes can be run using selected tables.

Select tables to populate.

Step 4: Click Run

Step 5: Add an occurrence, for instance, "Daily 7PM".  

Make sure you click "Reset to Current Date" or processes could be queued to run backdated.  

Step 6: Click OK

HR Table Refresh Process Scheduler Request

Validate Setup (Work Study Monitoring View)

The Work Study Monitoring View uses integrated Job data from CHRS.  

Step 1:  In Campus Solutions, Navigate to Menu >CSU SA Baseline > CSU Financial Aid > Work Study > Use > Work Study Monitoring View

Step 2: In the Search Dialog enter Student Emplid, Academic Institution, and Aid Year

Step 3: Click “Search” 

Step 4: Select the Supervisor ID field lookup for the “Look Up Supervisor ID” window  to open

Step 5: Search by Supervisor Emplid or Name 

Step 6: Select the appropriate value

Step 7: Confirm the Supervisor ID field was updated with the selected Emplid

Confirm the Supervisor ID field was updated with the selected Emplid

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) CHRS Crosswalk table in CS
Next Article (job aid) Connect CS to CHRS (DB Link Only)
Do you need an article? Contact Us