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
DB Link to CS (CSU_FULCS, CSU_MACS, etc.) > Account (DX_HRXCS) > Role (CSU_CSXCHR) > Table/Views
Modification: Student Employment
- PS_STDNT_AWARDS
- PS_AID_YEAR_TBL
- PS_STDNT_CAR_TERM
- PS_TERM_TBL
- PS_PERSON
- PS_DIVERS_ETHNIC
- PS_PERS_DATA_EFFDT
- PS_NAMES
- PS_PERS_NID
- PS_PERSONAL_DT_FST
- PS_PERSON_ADDRESS
- PS_PERS_DATA_USA
- PS_EMAIL_ADDRESSES
- PS_PERSONAL_PHONE
- PS_NAME_CURR_VW
- PS_FED_AID_YR_TBL
- PS_CSU_WKS_SETUP (Added Feb 2024)
- PS_ITEM_TYPE_FA (Added Feb 2024)
Modification: TAE
- PS_CSU_CRSE_DEF_VW
- PS_INSTR_ADVISOR
- PS_INSTR_CRSE
- PS_CSU_INST_AO_DTL
- PS_INSTR_TERM_DTL
- PS_CLASS_TBL (CHRSMP3.00)
- PS_CSU_INST_TM_DTL (CHRSMP3.00)
- PS_CSU_APDB_SECTN (CHRSMP3.00)
CHRS Tables/View Accessible in CS
DB Link to CHRS (CSU_CS_HR_LINK) > Account (DX_HRXCS) > Role (CSU_CSXCHR) > Table/Views
- PS_BEN_PROG_PARTIC
- PS_COMPENSATION
- PS_CSU_JOB
- PS_CSU_JOB_TTL_TBL
- PS_CSU_JOBCD_GRP (not a view, but parent record of CSU_JOBCD_GRP_A)
- PS_CSU_JOBCD_GRP_A
- PS_CSU_MPP_FUN_TBL
- PS_CSU_MPP_JF_XLAT
- PS_CSU_PIP_HISTORY
- PS_CSU_POSN_DATA
- PS_CSU_SAL_GRADE
- PS_DEPT_TBL
- PS_EARNINGS_BAL
- PS_GP_PYE_PRC_STAT
- PS_JOB
- PS_JOB_EARNS_DIST
- PS_JOB_JR
- PS_JOB_LABOR
- PS_JOBCODE_TBL
- PS_PAY_EARNINGS
- PS_PAY_LINE
- PS_PER_ORG_ASGN
- PS_PER_ORG_ASGN_VW
- PS_PER_ORG_INST
- PS_CSU_POI_INFO_VW pulls from PS_PER_POI_SCRTY in CHRS
- PS_CSU_POI_INFO_VW pulls from PS_PER_POI_TRANS in CHRS
- PS_POSITION_DATA
- PS_SAL_GRADE_TBL
- PS_SAL_PLAN_TBL
- PS_SAL_STEP_TBL
- PS_PAY_CHECK pulls from PS_CSU_PAY_CHCK_VW in CHRS (removes SSN)
- PS_CSU_JOBEMPL_MAP
- PS_PER_ORG_ASG_HP
- PS_CSU_EMPL_MAP_VW
- PS_CS_EMPLID_MAP
CFS Tables/Views Accessible in CHRS
DB Link to CFS (CSU_FULHCM_LINK, CSU_MAHCM_LINK, etc.) > Account (DX_CFSCTE) > Role (CSU_CFSCTE) > Table/Views
Modification: ESP
- PS_SET_CNTRL_GROUP
- PS_CSU_FNAT_XLAT
- PS_CSU_FNAT_TBL
- PS_FUND_TBL
- PS_CSU_FUND_TBL
- PS_PROGRAM_TBL
- PS_CSU_CDIP_Rule1
- PS_CSU_CDIP_Rule2
- PS_CF_ATTRIB_TBL
- PS_CSU_CDIP_RUL4_D
- PS_CSU_BAT_TBL
- PS_CSU_BAT_XLAT
- PS_GL_ACCOUNT_TBL
- PS_CSU_AAT_XLAT
Modification: LCD
- PS_GL_ACCOUNT_TBL
- PS_FUND_TBL
- PS_CLASS_CF_TBL
- PS_PROJECT
- PS_PROGRAM_TBL
- PS_BU_LED_COMB_TBL
- PS_COMBO_DATA_BUDG
- PS_COMBO_GROUP_TBL
- PS_COMBO_FLDS_TBL
- PS_COMBO_CF2_REQ
- PS_CLASS_CF_TBL
- PS_LED_GRP_TBL
- PS_LED_TMPLT_TBL
CHRS Tables/Views Accessible in CFS
DB Link to CHRS (CSU_CHRCFSCTE_LINK) > Account (DX_CFSCTE) > Role (CSU_CFSCTE) > Table/Views
- PS_CSU_JOB_VW2
- PS_CSU_NAMES_VW
- PS_CURRENT_JOB_ALL
- PS_EMAIL_ADDRESSES
- PS_EMPLOYEES
- PS_ESTAB_TBL
- PS_JOB
- PS_JOB_VW
- PS_JOBCODE_TBL
- PS_JOBCODE_TBL_VW
- PS_NAMES
- PS_PERSONAL_PHONE
- PS_POSN_INCUM_VW
- PS_POSITION_DATA
- PS_PERSONNEL
- PSOPRDEFN
- PS_CSU_EMPLID_MAP
- PS_CSU_EMPL_MAP_VW
- PSUSEREMAIL
Campuses can request additional Table/Views by submitting a Change Control.
End of Article
0 Comments
Add your comment