& Data Store
promise of the Oracle applications is the prospect of being able to enter
and retrieve more and better information that will assist in management
decisions, from the individual to the institutional level. It is expected
that the time consuming practice of re-keying information from the core
financial system into "shadow" systems will be substantially reduced,
if not eliminated, over time.
Standard reports are bundled with all Oracle
applications and can be requested by an authorized user at any time. They
have a fixed format and layout, but their content can be focused each
time the report is submitted by specifying selection parameters. The
standard reports supplied with Oracle Human Resources include absences
report, benefits enrollment registers, EEO reports, employee organization
movements reports, job and positions skills matching report, requisition
summary, salary review report, staffing budget details showing how current
staffing varies from projected budget, and termination report, among others.
For ad-hoc queries, Oracle Discoverer is a tool
that offers the capability of accessing the database with an interface
that allows users to generate informative, decision-ready reports. Templates
for instant report layout, seamless connectivity to the databases, and
point-and-click query construction provide a simple mechanism for users
to retrieve information.
of the Oracle information required by the University community will reside
in an Operational Data Store (ODS). The ODS will be a companion to the
existing Information Warehouse. There are many advantages to this strategy,
and one of the is that it reduces the workload placed on the Oracle applications.
If the only source of information were the Oracle applications, requests
for information would "compete" with the need for rapid transaction processing.