CHRS Knowledge Base

CS/CFS/CHRS Cross Database Impacts

Updated on

The purpose of this document is to provide campuses with a high-level insight into delivered tables, views, and integration messages within CHRS, CS, and CFS that will result in impacted functionality to CHRS, CS, and CFS when modified. 

These items are modified as part of an MP (Maintenance Pack) delivered by CS, CHRS, or CFS. Campuses are strongly advised not to alter any of the delivered tables, views, or integration messages within CS, as doing so may negatively affect the functionality and integration between CS/CFS and CS/CHRS.

Campus Solutions Database Impacts

Expand or collapse content Tables/Views
Expand or collapse content CHRS
  • HCR_PUBLICATION_RULES.PersonBasicPublication.OnExecute (App Package)
  • The tables/views listed for the DB Link Tables/Views
Expand or collapse content Integration Messages
Expand or collapse content CFS
  • PS_ GL_ACCOUNT_TBL
  • PS_BUS_UNIT_TBL_GL
  • PS_CLASS_CF_TBL
  • PS_CAL_DEFN_TBL
  • PS_CAL_DETP_TBL
  • PS_FUND_TBL
  • PS_JRNLGEN_APPL_ID
  • PS_LED_DEFN_TBL
  • PS_PROGRAM_TBL
  • PS_PROJECT
  • PS_SF_ACCTNG_LN
  • PS_VENDOR
  • PS_VNDR_ADDR_SCROL
  • PS_VNDR_ADDR
  • PS_VENDOR_ADDR_PHN
  • PS_VNDR_CNTCT_SCR
  • PS_VENDOR_CNTCT
  • PS_VNDR_CNTCT_PHN
  • PS_VNDR_LOC_SCROL
  • PS_VENDOR_PAY
  • PS_VNDR_BANK_ACCT
  • PS_VENDOR_LOC
  • PS_VOUCHER_BUILD
  • PS_VCHR_VNDR_STG
  • PS_VCHR_BANK_STG
  • PS_VCHR_HDR_STG
  • PS_VCHR_IBANK_STG
  • PS_VCHR_PYMT_STG
  • PS_VCHR_MSCH_STG
  • PS_VCHR_LINE_STG
  • PS_VCHR_DIST_STG

These integration messages are Asychronous.

Expand or collapse content CHRS
  • CSU_SEC_USERID_POST
  • CSU_PROVISION_INT_POST

These integration messages are Sychronous.

CHRS Database Impacts

Expand or collapse content Tables/Views
Expand or collapse content CFS

The tables/views listed for the DB Link (CSU_CHRCFSCTE_LINK)

Expand or collapse content CS

The tables/views listed for the DB Link (CSU_CS_HR_LINK)

Expand or collapse content Integration Messages
Expand or collapse content CFS
  • CSU_LABOR_DIST
  • CHR_LABOR_COST_DISTRIBUTION

These integration messages are Asychronous.

Expand or collapse content CS
  • CSU_CS_INTEGRATION_PERSON

These integration messages are Sychronous.

CFS Database Impacts

Expand or collapse content Tables/Views
Expand or collapse content CHRS

The tables/views listed for the DB Link (ex:CSU_MAHCM_LINK)

Expand or collapse content Integration Messages
Expand or collapse content CS
  • PS_SF_ACCTNG_LN
  • PS_VENDOR
  • PS_VNDR_ADDR_SCROL
  • PS_VENDOR_ADDR
  • PS_VENDOR_ADDR_PHN
  • PS_VNDR_CNTCT_SCR
  • PS_VENDOR_CNTCT
  • PS_VNDR_CNTCT_PHN
  • PS_VNDR_LOC_SCROL
  • PS_VENDOR_LOC
  • PS_VENDOR_PAY
  • PS_VNDR_BANK_ACCT
  • PS_VCHR_BANK_STG
  • PS_VCHR_IBANK_STG
  • PS_VCHR_MSCH_STG
  • PS_VCHR_PYMT_STG PS_VCHR_VNDR_STG
  • PS_VCHR_HDR_STG
  • PS_VCHR_LINE_STG
  • PS_VCHR_PYMNT_STG

These integration messages are Asychronous.

Expand or collapse content CHRS
  • PS_ GL_ACCOUNT_TBL
  • PS_BUS_UNIT_TBL_GL
  • PS_CLASS_CF_TBL
  • PS_CAL_DEFN_TBL
  • PS_CAL_DETP_TBL
  • PS_FUND_TBL
  • PS_JRNLGEN_APPL_ID
  • PS_LED_DEFN_TBL
  • PS_PROGRAM_TBL
  • PS_PROJECT
  • PS_HR_ACCTG_LINE
  • PS_CSU_LABOR_COST_DIST

These integration messages are Asychronous.

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) What Data Goes between CS/CHRS and CFS/CHRS (High Level)
Next Article (job aid) ​Campus Solutions (CS) 9.2
Do you need an article? Contact Us