| Oracle® Healthcare Provider Supply Chain Analytics Release Content Document Release 1.0.0.1 Part Number E18810-02 |
|
| View PDF |
| Oracle® Healthcare Provider Supply Chain Analytics Release Content Document Release 1.0.0.1 Part Number E18810-02 |
|
| View PDF |
Release Content Document
Release 1.0.0.1
E18810-02
December 2010
This document contains the following sections:
This Release Content Document (RCD) describes product features contained in the specified release of Oracle Healthcare Provider Supply Chain Analytics (OHPSCA). It is intended solely to help you assess the business benefits of implementing OHPSCA Release 1.0.0.1.
This document in any form, software or printed matter, contains proprietary information that is the exclusive property of Oracle. Your access to and use of this confidential material is subject to the terms and conditions of your Oracle Software License and Service Agreement, which has been executed and with which you agree to comply. This document and information contained herein may not be disclosed, copied, reproduced or distributed to anyone outside Oracle without prior written consent of Oracle. This document is not part of your license agreement nor can it be incorporated into any contractual agreement with Oracle or its subsidiaries or affiliates.
This document is for informational purposes only and is intended solely to assist you in planning for the implementation of the product features described. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described in this document remain at the sole discretion of Oracle.
This section contains the following topics:
This Release Content Document (RCD) communicates information about Oracle Healthcare Provider Supply Chain Analytics Release 1.0.0.1 (OHPSCA).
Oracle Healthcare Provider Supply Chain Analytics Release 1.0.0.1 is the initial release of this healthcare business intelligence application. OHPSCA provides advanced business intelligence and performance management insight to improve overall performance levels, manage costs and achieve better clinical outcomes for a healthcare delivery organization.
This section contains the following topics:
OHPSCA delivers advanced business intelligence that provides operational insight for supply chain activities across organizations. This release provides a consistent view of overall performance levels to manage costs and achieve better clinical outcomes. OHPSCA permits you to view key metrics to provide specific insights at your organization, region, and facility levels depending on user preferences. The consolidated view of metrics is designed to provide insight into the performance of supply chain departments across the organization, thereby supporting accurate and effective decision-making based on current and historical information.
OHPSCA is packaged as a series of out-of-the-box reports and dashboards, fully integrated to a dedicated data mart. The predefined data mart, combined with intuitive ad-hoc reporting capabilities empowers users and business teams to rapidly build reports to meet their immediate requirements without reliance on IT resources.
OHPSCA includes the following components:
OHPSCA Data Mart
Predefined facts and dimensions to derive and store business attributes and associated descriptive terms related to supply chain activities including procurement, spend, inventory, contracts and products.
Reports
Predefined tables and charts using Oracle Business Intelligence Enterprise Edition Plus.
Dashboards and Pages
Predefined functional dashboards and pages presenting reports by user roles.
User Roles
Customizable roles with access granularity to the level of individual pages in dashboards.
Support for creating new roles and modifying the predefined roles.
OHPSCA combines several advanced technologies to deliver a rich user experience, based on an extensible and scalable platform for supply chain performance management.
Oracle Business Intelligence Enterprise Edition Plus (OBI EE Plus)
OHPSCA uses OBI EE Plus to build and deliver rich dashboards, tables and charts, as well as an intuitive user ad hoc report builder.
This section contains the following topics:
This section contains the following topics:
All reports are implemented in Oracle Business Intelligence Interactive Dashboards and Oracle Business Intelligence Answers, providing a rich user experience for visualizing charts and tables, letting users drill down to further detail as required.
OHPSCA provides 207 reports related to performance management of supply chain workflow, focused on the following principal categories:
Supply Chain Summary
Provides insight into the overall Supply Chain operational and financial effectiveness.
Targets financial executives, supply chain management, and department managers.
Financial Performance
Provides Insight into key trends driving supply chain financial performance.
Targets financial executives, supply chain management, department managers, financial analysts, and payables supervision.
Operational Performance
Provides insight into internal fulfillment, supplier performance and Utilization.
Targets financial executives, supply chain management, inventory managers, department managers, and financial analysts.
Quality and Safety
Provides insight into the effectiveness of inventory management, laundry and recalls.
Targets financial executives, supply chain management, inventory managers, and department managers.
Organizational and Hospital Statistics
Provides insight into organization metrics including census, occupancy, admissions, discharges, transfers, cases and visits.
Targets financial executives, supply chain management, inventory managers, department managers, and financial analysts.
OHPSCA is pre-packaged with the following dashboards:
01 Summary Dashboard: Provides high level summary reports related to Supply Chain KPIs, hospital utilization statistics, leading or best practice indicators, and key supply chain operational metrics.
02 Financial Performance Dashboard: Provides reports related to supply expense trends, clinical department and cost center, supply expense trends, contract utilization and performance, and payables summary metrics.
03 Inventory Dashboard: Provides reports related to inventory, balances, discrepancies, movements, expirations, laundry utilization, and recalls.
04 Operational Performance Dashboard: Provides reports related to requisitions activity, purchase order activity, order analysis, and inventory.
05 Supplier Performance Products: Provides reports related to supplier scorecard, supplier diversity, supplier order, turnaround, and supplier order fulfillment accuracy.
06 Contracts: Provides reports related to contract utilization, utilization trends, contract status, and leakage rates.
07 Products Dashboard: Provides reports related to item master analysis and supply expense by product category and item.
Oracle Business Intelligence Answers can be exposed to users to let them rapidly build their own reports without extensive IT skills. To free business users from data structure complexity, OHPSCA pre-populates the metadata layer of Oracle Business Intelligence Answers with a logical view of supply chain related metrics, hierarchies, and calculations, expressed in straightforward concepts. The combination of predefined supply chain metrics with the intuitive, ad hoc reporting tool lets business users gain rapid insight into current supply chain workflow efficiency, helping them to identify bottlenecks with minimal burden on IT reporting teams.
The OHPSCA data mart is a predefined physical database schema consisting of facts and dimensions that store data elements required for supporting OHPSCA reports.
This section contains the following topics:
Dimensions are used to qualify metrics, and are typically associated with the use case show metric X, by dimension Y (for example, service efficiency summary by organization facility).
The following table lists the primary, non-system dimensions available in the physical database schema:
| Dimension | Description |
|---|---|
|
AP Spend Classification |
The spend classification used in Accounts Payable. |
|
Business Unit |
Internal organization associated with the measure. For example, it can be a group of departments or one or more hospitals. |
|
Buyer |
The Purchase Buyer associated with the supply chain transaction. |
|
Case Type |
The case type associated with the measure. A case is a logical sequence of interrelated interventions performed in a contiguous manner on a patient, by service providers with which supply consumption or equipment usage is associated. |
|
Company |
The company associated with the measure; a type of internal organization. |
|
Contract Leverage Type |
The bargaining position or advantage used in the contract negotiation. For example it could be price, quality, or business size. |
|
Contract Status |
The contract status, such as active, expired. |
|
Cost Center |
A type of internal organization against which supply chain transactions are tracked. For example, Cath Lab, Interventional Radiology, Operating Room 1. |
|
Date |
The date associated with the measure; includes two types: calendar and fiscal. |
|
Department |
A type of internal organization. For example, Pharmacy, Radiology, Laundry Services. |
|
Enterprise |
A type of internal organization. For example, University Health System. |
|
Expense Classification |
An expense category, such as medical supplies or surgical supplies. |
|
GL (General Ledger) Account |
A ledger account within the organization General Ledger. For example 1000 - Cash, 2000 - Asset. |
|
Inventory Business Unit |
A business organization that carries inventory. Each inventory business unit has inventory business management rules, storage locations, and products. For example INVBU1, INVBU1, Main Stores. |
|
Inventory Movement Type |
Inventory transaction types. For example, Issues, Receipts, Stocking, Transfers. |
|
Inventory Organization |
A type of internal organization hierarchy. For example, East Region > Hospital1 > INVBU1. |
|
Invoice Approval Status |
The state of the invoice within the approval process. For example, Approved, Pending Approval, Cancelled, Denied, Hold. |
|
Invoice Match Status |
The match status of the invoice. For example, Matched, Unmatched, Partially Matched, On Hold |
|
Invoice Requestor |
Information about the invoice requestor. |
|
Invoice Transaction Type |
The type of invoice transaction. For example, Purchasing Invoice, Payroll Invoice, Manual Entry. |
|
Last Receipt Date |
Last date received. |
|
Ledger |
Stores information about ledgers, within the General Ledger. |
|
Linen Status |
Status of Linen transactions. For example, Issued, Leakage, Waste. |
|
Manufacturer |
Information about the external organization that makes the product. |
|
Match Type |
Match types. For example, 2-way, 3-way, and 4-way. |
|
Operating Organization |
The operating organization is an internal organization at which operations are managed as a unit. For example, University Health System Main Hospital, Community Care Center. |
|
Patient Meal |
Information about Patient Meals. |
|
Procedure |
Procedure type. |
|
Product |
Defines product type, such as Finished Goods, Raw Material and other types of Products from the CRM, ERP & other source systems. |
|
Purchase Approval Status |
Defines status of the Purchase Approval process. For example, Requested, Pending Approval, Approved, Denied. |
|
Purchase Cycle Status |
Defines Purchase Cycle status. For example, Initial, Approved, Purchased. |
|
Purchase Line Type |
Defines Purchase Line status. For example, Expense, Asset, and Amount only. |
|
Purchase Order Transaction Type |
Defines Purchase Order type. For example, Blanket PO, Regular, Rush PO, Bill Only PO, Inventory PO. |
|
Purchase Receipt Transaction Type |
Defines Purchase Receipt transaction type. For example, Manual, Electronic, Blind Receipt. |
|
Purchase Requestor |
The initiator of a purchase requisition. |
|
Purchase Requisition Transaction Type |
Information about the Purchase Requisition transaction. For example, the name, type, and description of the Purchase Requisition transaction. |
|
Purchasing Category Code |
The internal Purchasing Category code. For example, Medical Supplies, Surgical Supplies, Janitorial Services. |
|
Purchasing Organization |
An internal purchasing organization. |
|
Recall Authority |
An organization that issues a recall. For example, FDA, EPA. |
|
Recipient Location |
Information about the location where goods and services are delivered, such as the address and telephone number. |
|
Requisition Approval Status |
Defines requisition approval status. For example, Pending Approval, Approved, Complete. |
|
RMA Status |
Defines Return Material Authorization status. For example, Complete, In Progress. |
|
Service Line |
Defines service line name. |
|
Status |
Defines Purchase Requisition From and To statuses. |
|
Storage Location |
Inventory storage location information, such as address, telephone number. |
|
Supplier |
Information about the supplier, such as name, address, telephone number, and diversity data. |
|
Supplier Account |
Stores multiple accounts for a supplier used in the purchasing and payment process. |
|
Supplier Acknowledgment Status |
Supplier acknowledgement status. For example, Backordered, Accepted, Rejected. |
|
Supplier Performance Manager |
Identifying information about a Supplier Performance Manager, such as name, address, telephone number, job title. |
|
Supplier Product |
Information related to products provided by a supplier, such as part number, price, unit of measure. |
|
UNSPSC |
Information related to the code and name of the UNSPSC product classification hierarchy. |
There are 24 base facts predefined in the OHPSCA data mart. Facts are used to store metrics and related information about products, purchasing, contracts, and expense and spend. Base facts include the following:
| Fact | Description |
|---|---|
|
Accounts Payable |
Stores AP invoice data such as invoice amount by line item, cost center, supplier, location, and purchase order. |
|
ADT Information |
Stores information about admissions and discharges, by operating organization. |
|
Contract |
Stores the current status of a contract. This table can be used to find contracts that are about to expire, by cost center, contract manager, line item, product, supplier and various internal organizations. |
|
Contract Status |
Stores states of the contract such as new, renew, expired. This table can be used to find contracts that are about to expire, by cost center, contract manager, line item, product, supplier and various internal organizations. |
|
Dietary Supply Expense |
Stores supply expense by product by patient meal transaction. |
|
Inventory Transaction |
Stores information about daily transactions that occur during a product's lifecycle at an inventory location of a business organization. The key information includes the different inventory movement types, the date of occurrence, cost center, and the quantity and value of the inventory transaction. |
|
Inventory Balance |
Stores daily information about inventory balances and values. This information includes quantities and values of different types of inventory such as available, consigned and obsolete inventory including consigned inventory. |
|
Inventory Balance Monthly |
Stores monthly information about inventory balances and values related to products whose inventory is maintained by the business organization. This information includes quantities and values of different types of inventory such as available, consigned and obsolete inventory, including that of consigned inventory. |
|
Laboratory Supply Expense |
Stores laboratory supply expense for each product. The expense classifications are laboratory supplies, radiology supplies, and medical gases. |
|
Laundry Supply Expense |
Stores laundry related product supply expense. The expense classifications are laundry supplies, laundry replacement supplies, and purchased services. |
|
Linen and Laundry Inventory |
Stores linen product related transactions that occur during a linen lifecycle at a business organization inventory location. |
|
Physical Count Inventory |
Stores information about the physical count process in an inventory organization. The data are stored at the level of a count date, count event, and inventory organization and contain data about discrepancies (variance) between system count and physical count. |
|
Procedure Supply Expense |
Stores the procedure supply expense for each product by procedure transaction in a case. Product supply expense type is identified by expense classification. |
|
Product Expirations, Lots, Recalls |
Stores the batch number by product by various internal organizations. |
|
Purchase Cost |
Stores purchase cost-related information that is distributed on the basis of the amount or value by the purchasing unit of a business organization. There can be many types of purchase orders and may include one-time, regular, blanket, release, and others. The data in this table are stored at the purchase order distribution level. Purchase orders, or the shipments, are distributed among different receivers, accounts, or cost centers. |
|
Purchase Delivery |
Stores supplier delivery schedules associated with purchase orders issued by the purchasing unit of a business organization. The types of purchase orders include but are not limited to one-time, regular, blanket, or release. The data in this table is stored at the purchase order, product line item and delivery schedule level. |
|
Purchase Order |
Stores supplier purchase orders issued by the purchasing unit of a business organization. The types of purchase orders include but are not limited to one-time, regular, blanket, or release. The data in this table are stored at the purchase order product line item level. |
|
Purchase Process |
Stores the time duration of all events related to the purchase process, commencing with a requisition. Information in this table enables analysis of the direct spend process within an organization, beginning with a purchase requisition, its approval, the creation of an approved purchase order, its submission to a supplier, the creation of a purchase schedule, and ending with its receipt of the products. |
|
Requisition |
Stores purchase requisitions issued by various departments of a business organization. Purchase requisition types include but are not limited to one-time, regular, or online. The data in this table is stored at the purchase requisition product line item level. |
|
Requisition Cost |
Stores purchase requisition costs that are distributed to various departments of a business organization. Types of purchase requisitions include but are not limited to one-time, regular, or online. The data in this table are stored at the purchase requisition product line item level. |
|
Requisition Status |
Stores data regarding requisition status with various actions performed as it passes through its life cycle stages. The data in this table are expected to be dynamic during the related cycles of the requisition. |
|
Revenue and Expense |
Stores information about revenue, expenses and margins at operating organization level. |
|
Supplier Spend |
Stores the two-tier supplier spend by supplier diversity. Data in this fact are stored by month. |
|
Supply Expense |
Stores daily product supply expense for the enterprise, by expense classification. |
OHPSCA provides 30 key reports where target values can be set and viewed. Targets can be set for multiple time periods or by dimension (Example: A target can be set on the Supply Chain % Net Patient Revenue report over 3 years and it can be viewed by each acute care facility). The report shows the target and the variance against target.
Oracle Healthcare Provider Supply Chain Analytics is dependent upon the following products:
Oracle BI Suite Enterprise Edition Plus (OBIEE) 10.1.3.4.1
Oracle Database 11gR2
None
Our goal is to make Oracle products, services, and supporting documentation accessible to all users, including users that are disabled. To that end, our documentation includes features that make information available to users of assistive technology. This documentation is available in HTML format, and contains markup to facilitate access by the disabled community. Accessibility standards will continue to evolve over time, and Oracle is actively engaged with other market-leading technology vendors to address technical obstacles so that our documentation can be accessible to all of our customers. For more information, visit the Oracle Accessibility Program Web site at http://www.oracle.com/accessibility/.
Accessibility of Code Examples in Documentation
Screen readers may not always correctly read the code examples in this document. The conventions for writing code require that closing braces should appear on an otherwise empty line; however, some screen readers may not always read a line of text that consists solely of a bracket or brace.
Accessibility of Links to External Web Sites in Documentation
This documentation may contain links to Web sites of other companies or organizations that Oracle does not own or control. Oracle neither evaluates nor makes any representations regarding the accessibility of these Web sites.
Oracle customers have access to electronic support through My Oracle Support. For information, visit http://www.oracle.com/support/contact.html or visit http://www.oracle.com/accessibility/support.html if you are hearing impaired.
Oracle Healthcare Provider Supply Chain Analytics Release Content Document, Release 1.0.0.1
E18810-02
Copyright © 2010, Oracle and/or its affiliates. All rights reserved.
This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited.
The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please report them to us in writing.
If this software or related documentation is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, the following notice is applicable:
U.S. GOVERNMENT RIGHTS Programs, software, databases, and related documentation and technical data delivered to U.S. Government customers are "commercial computer software" or "commercial technical data" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, the use, duplication, disclosure, modification, and adaptation shall be subject to the restrictions and license terms set forth in the applicable Government contract, and, to the extent applicable by the terms of the Government contract, the additional rights set forth in FAR 52.227-19, Commercial Computer Software License (December 2007). Oracle USA, Inc., 500 Oracle Parkway, Redwood City, CA 94065.
This software is developed for general use in a variety of information management applications. It is not developed or intended for use in any inherently dangerous applications, including applications which may create a risk of personal injury. If you use this software in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure the safe use of this software. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software in dangerous applications.
Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.
This software and documentation may provide access to or information on content, products, and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party content, products, and services. Oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third-party content, products, or services.
 Copyright © 2010, Oracle and/or its affiliates. All rights reserved. Legal Notices |
|