CHRS Knowledge Base

DB Link Details

Updated on

A single database link contains multiple tables/views that CS, CHRS, and CFS use to pull data.  These tables/views have been standardized, simplified, and approved by the Chancellors Office. With CHRS being a shared environment, some of the tables/views have been modified to remove Level 1 Data (SSN, Citizenship, DOB, etc.).  Many of the views are locked down in CS using a crosswalk table that uses Business Unit or Company. Campuses should review all areas where database links are used and determine retrofits. This document provides an overview display of what tables/view are accessible between CS, CHRS and CFS. 

There will be 23 database links pulling CS data into CHRS (I.e., for TAE, Student Hire).  The naming convention is CSU_<3 digit company>CS * per development environment views; this may change.

CS Table/Views Accessible in CHRS 

CHRS Tables/View Accessible in CS

CFS Tables/Views Accessible in CHRS

CHRS Tables/Views Accessible in CFS

Campuses can request additional Table/Views by submitting a Change Control. 

End of Article

You are done. Great job!

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) Campus Integration Validation Checklist (With CMS for MTP)
Next Article (job aid) CHRS Integration(9.0, IB, PDM)
Do you need an article? Contact Us