UM – System A.I.T.S.

PeopleSoft

Implementation

PlanBy

Ben Phelps

Transition Factors

• Relational (SA, FS, HR, EPM)

• Integrated (UM, MU, UM-R, UMKC, UMSL, HOSP, etc.)

• Row Level Security (bittersweet)

• Effective Dating

• Multiple Relationships within System

• Data stored in single location

Architecture

SA

HR

EPM

FS

Architecture

SA

HR

EPM

FS

Database Instances

• HR PRD 76*

(Dynamic)• HR RPT 76*

(Static)• HR TRN 76*• HR DEV 76• HR TST 76

• HR CNV 76• HR QA 76• HR CNV 83• HR TST 83• Plus ODBC

* User interface

Enterprise Performance Management

HRRPT

FSRPT

SARPT

Enterprise Performance Management

HRRPT

FSRPT

SARPT

HRODS

FSODS

SAODS

Enterprise Performance Management

HRRPT

FSRPT

SARPT

HRODS

FSODS

SAODS

Warehouse(engine)

EPM (continued)

• Cubes (multi-dimensional reporting)

• Balanced Scorecards (ties reporting to strategic plan)

• Analytics(forecasting & scenarios)

Implementation Schedule

Shortcut to ASP Module Deployment Plan 02252003.lnk

UM – System A.I.T.S.

Questions?