Skip to Main Content
Return to Navigation

Implementation Scenarios

This table provides answers to questions about Campus Solutions Warehouse implementation scenarios.

Question

Answer

What source versions of Campus Solutions does EPM support?

EPM supports PeopleSoft Campus Solutions 8.9 and 9.0.

What is the SRC_SYS_ID value that needs to be set for the Campus Solutions Warehouse?

Scenario One: Fresh installation of EPM 9.1 (Not an upgrade)

HCM and Campus Solutions can share the same database instance or Campus Solutions can exist in a separate database instance. In both the cases, we recommend you provide a unique value for the SRC_SYS_ID, different from the SRC_SYS_ID value that is being used for other warehouses (when there are other warehouses being implemented). For example, the SRC_SYS_ID can be set to CS9 or CS.

Scenario Two: Upgrade to EPM 9.1

Upgrading from EPM 9 to 9.1, the SRC_SYS_ID value that was used for Campus Solutions 9.0 should be carried over to EPM 9.1 as well.

If upgrading from earlier EPM version, you can provide a unique value for the SRC_SYS_ID, different from the SRC_SYS_ID value that is being used for other warehouses (when there are other warehouses being implemented). For example, the SRC_SYS_ID can be set to CS9 or CS.

What are the common jobs used by the Campus Solutions Warehouse?

  • PS_D_BUS_UNIT_COMP (Common Dimensions)

  • PS_D_BUS_UNIT_PF (Common Dimensions)

  • PS_D_LOCATION (Global Dimensions)

  • PS_D_PERSON (Global Dimensions)

  • PS_D_YEAR (Common Dimensions)

  • PS_D_DT_PATTERN (Common Dimensions)