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
- HCR_PUBLICATION_RULES.PersonBasicPublication.OnExecute (App Package)
- The tables/views listed for the DB Link Tables/Views
- 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.
- CSU_SEC_USERID_POST
- CSU_PROVISION_INT_POST
These integration messages are Sychronous.
CHRS Database Impacts
The tables/views listed for the DB Link (CSU_CHRCFSCTE_LINK)
The tables/views listed for the DB Link (CSU_CS_HR_LINK)
- CSU_LABOR_DIST
- CHR_LABOR_COST_DISTRIBUTION
These integration messages are Asychronous.
- CSU_CS_INTEGRATION_PERSON
These integration messages are Sychronous.
CFS Database Impacts
The tables/views listed for the DB Link (ex:CSU_MAHCM_LINK)
- 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.
- 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