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.
- CSU_DPT_TBL_STG
- CSU_JC_TBL_STG
- CSU_JOB_STG
- CSU_PER_ORG_STG
- CSU_POSTN_STG
- 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
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.
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
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
End of Article
0 Comments
Add your comment