List of Tables

• User Roles and Dashboard Access
• Accessing Online Help
• Sample Date
• Oracle BI Feature Links
• Common Terms Used in Oracle BI Answers and Their Definition
• Tabs in the Oracle BI Answers Workspace
• Oracle BI Request Column Icons
• Sort Orders Available in Oracle BI Answers
• Predefined Variables
• Tables for Partitioning
• PSCA-001 : Current Supplier Base
• PSCA-002 : Current New Supplier Base
• PSCA-003 : Supplier Spend by product type
• PSCA-004 : Tier 1 Supplier Diversity Spend
• PSCA-005 : Tier 2 Supplier Diversity Spend
• PSCA-006 : Supplier Diversity Spend - Time Comparison
• PSCA-007 : Top 'n' Acceptance Rates
• PSCA-008 : Top 'n' Rejection Rates
• PSCA-009 : Products That Have Been Delivered On Time By Ordered Quantity
• PSCA-010 : Products That Have Been Delivered On Time By Total PO Lines
• PSCA-011 : Products That Have Been Delivered On Time By Ordered Amount
• PSCA-012 : Products That Have Been Delivered Late By Ordered Quantity
• PSCA-013 : Products That Have Been Delivered Late By Total PO Lines
• PSCA-014 : Products That Have Been Delivered Late By Ordered Amount
• PSCA-015 : Products That Have Been Delivered Early By Ordered Quantity
• PSCA-016 : Products That Have Been Delivered Early By Total PO Lines
• PSCA-017 : Products That Have Been Delivered Early By Ordered Amount
• PSCA-018 : Top n Late Purchase Order Line Deliveries
• PSCA-019 : Top n On Time Purchase Order Line deliveries
• PSCA-020 : Top n Early Purchase Order Line Deliveries
• PSCA-021 : Bottom n On Time Purchase Order Line Deliveries
• PSCA-022 : Bottom n Early Purchase Order Line Deliveries
• PSCA-023 : Bottom n Late Purchase Order Line Deliveries
• PSCA-024 : % Deliveries Received Early
• PSCA-025 : % Deliveries Received Late
• PSCA-026 : % Deliveries Received On Time
• PSCA-027 : Top n Performing Suppliers
• PSCA-028 : Bottom n Performing Suppliers
• PSCA-029 : Supplier Diversity Complete Report
• PSCA-030 : List of On Time Purchase Order Line Deliveries
• PSCA-031 : List of Late Purchase Order Line Deliveries
• PSCA-032 : List of Early Purchase Order Line Deliveries
• PSCA-033 : Proportion of Electronic Requisitions to Total Requisitions
• PSCA-034 : Requisition Status By Purchasing Organization
• PSCA-035 : Requisition Status By Buyer
• PSCA-036 : Requisition Status By Cost Center
• PSCA-037 : Requisition Count
• PSCA-038 : Number of Purchase Orders by Buyer
• PSCA-039 : Average Purchase Order Amount by Supplier
• PSCA-040 : Average Purchase Order Line Amount by Product Category
• PSCA-041 : Average Number of Product lines per purchase order
• PSCA-042 : Proportion of Low value Purchase Order Transactions
• PSCA-043 : Proportion of Electronic Purchase Orders
• PSCA-044 : Proportion of Rush Purchase Orders out of total purchase orders
• PSCA-045 : Number of Backorder Items by product Category by Total Spend
• PSCA-046 : Number of open backorders
• PSCA-047 : Standing Orders by all Suppliers
• PSCA-048 : Average Requisition to Receipt Cycle Time
• PSCA-049 : Time Comparison Report
• PSCA-050 : Average Approval Cycle Time
• PSCA-051 : Average Purchase Cycle Time
• PSCA-052 : Average Receipt Cycle Time
• PSCA-053 : List of Electronic Requisitions
• PSCA-054 : List of Requisitions
• PSCA-055 : Trend by Requisition Status (13 month trend) by Buyer
• PSCA-056 : Trend by Requisition Status (13 month trend) by Purchasing Department
• PSCA-057 : Trend by Requisition Status (13 month trend) by Cost Center
• PSCA-058 : Supplier Details by Spend - All Suppliers
• PSCA-059 : List of Requisitions for the selected Cost Center and Requisition Status
• PSCA-060 : List of requisitions for the selected Supplier and Purchasing Organization for requisition
• PSCA-061 : List of Requisitions for the selected Buyer and Requisition Status
• PSCA-062 : List of Low Value PO's
• PSCA-063 : Supply Expense for Enterprise
• PSCA-064 : Supply Expense by Business Unit
• PSCA-065 : Supply Expense trend by Business Unit
• PSCA-066 : Procedure Supply Expense by Procedure Category
• PSCA-067 : Procedure Supply Expense by Procedure Category by Product Category
• PSCA-068 : Procedure Supply Expense trend by Procedure Category
• PSCA-069 : Supply Expense by Product Category
• PSCA-070 : Supply Expense trend by Product Category
• PSCA-071 : Supply Expense by Department
• PSCA-072 : Supply Expense by Purchased Services
• PSCA-073 : Supply Expense by Cost Center - Previous Period comparison
• PSCA-074 : Supply Expense by Cost Center by Product Category
• PSCA-075 : Supply Expense trend by Cost Center
• PSCA-076 : Supply Expense by Product
• PSCA-077 : Supply Expense by Department by Product
• PSCA-078 : Supply Expense by Cost Center by Product
• PSCA-079 : Supply Expense as % of Net Patient Revenue Trend
• PSCA-080 : Supply Expense as % of Net Patient Revenue Trend by Business Unit
• PSCA-081 : Supply Expense as % of Operating Expense Trend
• PSCA-082 : Supply Expense as % of Operating Expense Trend by Business Unit
• PSCA-083 : Supply Expense per discharge Trend
• PSCA-084 : Supply Expense per discharge Trend by Business Unit
• PSCA-085 : Supply Expense per Adjusted Discharge Trend
• PSCA-086 : Supply Expense per Adjusted Discharge Trend by Business Unit
• PSCA-087 : Supply Expense per Case Mix Adjusted Discharge Trend by Business Unit
• PSCA-088 : Supply Expense per Patient Day Trend
• PSCA-089 : Supply Expense per Patient Day Trend by Business Unit
• PSCA-090 : Supply Expense per Case Mix Patient Day Trend by Business Unit
• PSCA-091 : Supply Expense per Adjusted Patient Day Trend
• PSCA-092 : Supply Expense per Adjusted Patient Day Trend by Business Unit
• PSCA-093 : Supply Expense per Case Mix Adjusted Patient Day Trend by Business Unit
• PSCA-094 : Pharmacy Department Supply Expense as % of Supply Expense
• PSCA-095 : Pharmacy Department Supply Expense trend by Product Category
• PSCA-096 : Radiology Department Supply Expense as % of Supply Expense
• PSCA-097 : Radiology Department Procedure Supply Expense per Diagnostic Procedure trend
• PSCA-098 : Radiology Department Procedure Supply Expense per Diagnostic Procedure trend by Product Category
• PSCA-099 : Laboratory Department Supply Expense as % of Supply Expense
• PSCA-100 : Laboratory Department Lab Test Supply Expense per lab test trend by Product Category
• PSCA-101 : Laboratory Department Lab Test Supply Expense per Lab Test trend
• PSCA-102 : Dietary Department Supply Expense as % of Supply Expense
• PSCA-103 : Dietary Department Patient Meal Supply Expense per Patient Meal trend
• PSCA-104 : Dietary Department Patient Meal Supply Expense per Patient Meal trend by Product Category
• PSCA-105 : Laundry Department Supply Expense as % of Supply Expense
• PSCA-106 : Laundry Supply Expense per Laundered Items weight trend
• PSCA-107 : Laundry Supply Expense per Laundered Items weight trend by Product Category
• PSCA-108 : Laundry Purchased Service Expense as % of Supply Expense
• PSCA-109 : Laundry Purchased Service Expense per Laundered Items weight trend
• PSCA-110 : Laundry Purchased Service Expense per Laundered Items weight trend by Product Category
• PSCA-111 : Laundry Replacement Expense per Laundered Items weight
• PSCA-112 : Surgical Supply Expense as % of Supply Expense
• PSCA-113 : Surgical Procedure Supply Expense per Case trend
• PSCA-114 : Surgical Procedure Supply Expense per Case trend by Product Category
• PSCA-115 : Surgical Procedure Supply Expense per Procedure
• PSCA-116 : Surgical Procedure Supply Expense per Procedure trend by Product Category
• PSCA-117 : Contracts Status Report
• PSCA-118 : Contracts Status Report by Supplier Performance Manager
• PSCA-119 : Contracts Status Report by Supplier and Supplier Type
• PSCA-120 : Contract Leakage Rate of Approved PO Spend
• PSCA-121 : Savings Opportunities
• PSCA-122 : Contract Utilization Trend
• PSCA-123 : Contract Utilization Trend by Product Category
• PSCA-124 : Contract Utilization Trend by Buyer
• PSCA-125 : Contract Utilization Trend by Supplier
• PSCA-126 : Item Current Status Report
• PSCA-127 : Item Current Status Report by Product Category
• PSCA-128 : Items and Contracts
• PSCA-129 : Items and Contracts by Product Category
• PSCA-130 : Contract / Non-Contract Spend by Purchasing Organization
• PSCA-131 : Contract / Non-Contract Spend by Purchasing Organization and Product Category
• PSCA-132 : Payables Leakage Rate
• PSCA-133 : Payables Leakage Amount by PO Number
• PSCA-134 : Invoice Match / Unmatch Report
• PSCA-135 : Match Report by Match Type
• PSCA-136 : Match Error % Report
• PSCA-137 : List of Invoices with Invoice Match Status Complete
• PSCA-138 : List of Invoices with Invoice Match Status Partial
• PSCA-139 : List of Invoices with Invoice Match Status Unmatch
• PSCA-140 : Blocked Inventory by Inventory Organization
• PSCA-141 : Blocked Inventory by Product Category
• PSCA-142 : Blocked Inventory by Storage Location
• PSCA-143 : Consignment Inventory by Inventory Organization
• PSCA-144 : Consignment Inventory by Product Category
• PSCA-145 : Consignment Inventory by Storage Location
• PSCA-146 : Consignment Inventory by Supplier
• PSCA-147 : Inventory Turnover by Inventory Organization
• PSCA-148 : Inventory Snapshot by Inventory Organization
• PSCA-149 : Inventory Snapshot by Product Category
• PSCA-150 : Inventory Snapshot by Storage Location
• PSCA-151 : List of Purchase Orders
• PSCA-152 : Inventory Balances by Inventory Organization
• PSCA-153 : Inventory Fill Rate, Recalls by Inventory Organization
• PSCA-154 : Inventory Count Variance by Inventory Organization
• PSCA-155 : Inventory Balances by Operating Organization
• PSCA-156 : Inventory Fill Rate, Recalls by Operating Organization
• PSCA-157 : Inventory Count Variance by Operating Organization
• PSCA-158 : Inventory Count Variance
• PSCA-159 : Inventory Count % Variance
• PSCA-160 : Number of items Cycle Counted
• PSCA-161 : Inventory Count Amount Variance
• PSCA-162 : Inventory Count Amount % Variance
• PSCA-163 : Inventory Amount Counted before Cycle Count
• PSCA-164 : Inventory movement types by Inventory Organization
• PSCA-165 : Inventory Issues from Warehouse to Departments
• PSCA-166 : Top n Product categories for each Movement Type by Inventory Organization
• PSCA-167 : Linen Issue and Return Weight by Cost Center
• PSCA-168 : Linen Leakage % and Waste % by Weight by Cost Center
• PSCA-169 : Linen Issue and Return Lines by Cost Center
• PSCA-170 : Clean Linen and Soiled Linen Weight Returned by Cost Center
• PSCA-171 : Standard Re-Order replenishment Quantity by item by Inventory Organization
• PSCA-172 : Average replenishment batch size Quantity by Product Category
• PSCA-173 : Average replenishment batch size by number of lines by Product Category by Inventory Organization
• PSCA-174 : Internal Fill Rate by Inventory Organization
• PSCA-175 : Average Time taken from Material Stock Request to Delivery
• PSCA-176 : Number of Open RMA Lines by Inventory Organization
• PSCA-177 : Number of Lines Returned to Inventory
• PSCA-178 : % of Lines Returned to Inventory
• PSCA-179 : Value of Inventory Returned
• PSCA-180 : Number of Lines returned to Inventory by Product Category
• PSCA-181 : Top 10 Products returns for a Product Category by Inventory Lines Returned
• PSCA-182 : Percent Lines returned to Inventory by (returning) cost center at an Inventory Organization
• PSCA-183 : Percent lines returned to Suppliers from an Inventory Organization
• PSCA-184 : Percent Lines returned to Suppliers from a Purchasing Organization
• PSCA-185 : Obsolescence by Number of items
• PSCA-186 : Obsolescence by % Items obsolete
• PSCA-187 : Obsolescence by Inventory Amount
• PSCA-188 : Obsolescence by % Inventory Amount
• PSCA-189 : Item Expiration report by Inventory Organization
• PSCA-190 : Item Expiration report by Cost Center
• PSCA-191 : Items recalled Trend by Cost Center
• PSCA-192 : Items recalled by Recall Authority
• PSCA-193 : Items recalled by Recall Product Category
• PSCA-194 : Volume, Utilization, Revenue Trend
• PSCA-195 : Supply Chain Financial Measures Trend
• PSCA-196 : Supply Chain Operational Performance Trend
• PSCA-197 : Leading Indicators (Compliance/ Standardization/Technology/Contract) Trend
• PSCA-198 : Quality/Safety Trend
• PSCA-199 : Supply Chain Financial Measures
• PSCA-200 : Supply Chain Operational Performance
• PSCA-201 : Leading Indicators ( Compliance/ Standardization/Technology/Contract)
• PSCA-202 : Volume, Utilization, Revenue
• PSCA-203 : Quality/Safety
• PSCA-204 : Contract Leakage Rate of Invoiced PO Spend
• PSCA-205 : Time Comparison Report - Average Approval Cycle Time
• PSCA-206 : Time Comparison Report - Average Purchase Cycle Time
• PSCA-207 : Time Comparison Report - Average Receipt Cycle Time
• PSCA-208 : Standing Orders by all Suppliers by Product Category
• PSCA-209 : Proportion of Rush Purchase Orders out of total purchase orders by Product Category
• Number of Backorder Items by Total Spend column descriptions
• Presentation Catalog - Dimensions
• Presentation Catalog - Facts
• Presentation Catalog - Measures