Understanding the Supply Chain Warehouse

This chapter provides an overview of the Supply Chain Warehouse, the Supply Chain Warehouse structure, and the Supply Chain Warehouse components.

Supply Chain Warehouse Overview

PeopleSoft Supply Chain Warehouse is a comprehensive reporting and analysis platform. It includes a Multidimensional Warehouse (MDW) infrastructure that enables operational and near real-time reporting. This reporting aids in understanding the supply chain trends and issues that your organization is facing. PeopleSoft Supply Chain Warehouse includes packaged data marts that provide an organized multidimensional analysis and reporting environment, including Data Warehouse tables.

PeopleSoft delivers the PeopleSoft Supply Chain Warehouse complete with extract, transform, and load (ETL) jobs, data models, data marts, and a library of key supply chain metrics, as well as Data Warehouse tables. PeopleSoft also provides the tools that enable you to modify or add to the predefined reporting content.

PeopleSoft Supply Chain Warehouse includes PeopleSoft Supply Chain marts, which enable consolidating procurement spending, aggregating inventory availability, and combining customer satisfaction measures for corporate, operation, or department level analysis. The Supply Chain Warehouse also includes data marts that support detailed production and supply chain planning compliance analysis.

You can review the data against organizational metrics and perform strategic analyses to identify and track the multiple dimensions that affect profitability, as well as identify key performance drivers, trends, and opportunities

Note. For details of dimensions, see the PDF file that is published on CD-ROM with your documentation.

Understanding the Supply Chain Warehouse Structure

PeopleSoft marts are subsets of PeopleSoft Supply Chain Warehouse. Marts are subject-specific relational schemas created for a particular group of users for multidimensional analysis and reporting. Each core functional area of the warehouse has predefined marts.

The Supply Chain Warehouse is divided into six areas, or marts: Fulfillment and Billing, Procurement, Spend, Inventory, Manufacturing, and Supply Chain Planning.

Supply Chain Warehouse marts and business processes

Each mart is associated with a business process that helps you answer the questions that you need to keep your organization robust and ahead of its competition. With each mart, we present the fact tables that will help you answer your critical business questions.

Note. Although we list only the actual fact name, all facts that represent dollar amounts have three facts in the fact table, one for each possible selected reporting currency. Populating the facts for alternate currencies is optional.

For additional details of facts, see the PDF file that is published on CD-ROM with your documentation.

This section discusses:

Fulfillment and Billing Mart
Procurement Mart
Spend Mart
Inventory Mart
Manufacturing Mart
Supply Chain Planning Mart

Fulfillment and Billing Mart

Analytics derived from Fulfillment and Billing Mart support the order-to-cash processes within the supply chain by providing analytics that track customers, orders, invoices, returns, and shipping transactions. You can use the analysis of individual product sales by channel, region, and other dimensions to greatly assist future marketing and product development initiatives, yielding a significant bottom line impact. Analytics cannot only help maintain customer satisfaction, but they can also help drive efficiencies into the supply chain, maintain cost controls, and ensure that fulfillment is aligned with manufacturing capabilities. The data mart also enables complete margin analysis, helping you to identify and track sales, returns, costs, discounts, and gross profit by customer.

With Fulfillment and Billing Mart you can answer questions such as:

Which customers are returning the most products?
Which products are being returned the most often?
Why are products being returned?
Which customers contribute the most to profit?
Which products produce the most profit?
Which products are discounted the most, and to which customers?
What is the overall order fill rate?
What is the fill rate for each product?
What is the percentage of late shipments?
What is the value of the late shipments?
What are the total dollars shipped per period?
What was the total value of shipped products for a given period?
What was the total cost of the shipped products?
What is the gross margin per product shipped?

Order Fulfillment Business Process

Fulfillment and Billing Mart is related to PeopleSoft’s Order Fulfillment business process, which is also known as Order to Cash. The Order Fulfillment business process fulfills an organization's requirements for capturing, fulfilling, and settling goods sold. With the Order Fulfillment business process, you capture, confirm, and manage sales orders and contracts, deliver goods or services, and then invoice, collect, and resolve payment. The Order Fulfillment business process also helps you to manage returns and inventory, process customer payments, and maintain profitable customer relationships.

Fulfillment and Billing Delivered Fact Tables

With Fulfillment and Billing Mart PeopleSoft provides the following fact tables:

Billing
Fulfillment subject area facts:
- Sales Order
- Sales Order Line Ship
- Kits
- Bookings
- Order to Cash Cycle Time
Returned Material Authorization (RMA) Received

Billing Fact Table

The Billing fact table contains billing transaction information. This is an incremental fact table. With this fact group, you can answer questions such as “What is the revenue by customer?” and “What is the average discount?”

This table describes the Billing fact table:

Fact Name	Fact Description
Transaction Quantity	Quantity of the product charged in the billing line of the invoice. This fact helps you answer questions such as “What is the quantity charged on the invoice?”
Unit Amount	Per unit price for that product. This fact helps you answer questions such as “What is the unit price charged on the invoice?”
Discount Amount	Discount amount associated with that billing line. This fact helps you answer questions such as “What is the discount charged on the invoice?”
Surcharge Amount	Surcharge amount charged against that billing line. This fact helps you answer questions such as “What is the invoice surcharge amount?”
Tax Amount	Tax amount charged against that billing line. This fact helps you answer questions such as “What is the invoice tax amount?”
Gross Amount	Gross amount as calculated by the billing application for that invoice line. This fact helps you answer questions such as “What is the invoice gross amount?”
Net Amount	Net amount as calculated by the billing application for that invoice line. This fact helps you answer questions such as “What is the invoice net amount?”

Fulfillment - Sales Order Fact Table

The Sales Order fact table stores information related to the sales order header level and helps evaluate metrics such as Net Price, Quantity, List Amount, and so on. With this fact group, you can answer questions such as “What are product sales by channel? By customers? By shipment dates? By business units?”

This table describes the Sales Order fact table:

Fact Name	Fact Description
Net Price	Net unit price of a sales order. With this fact, you can answer questions such as “What is the price ordered by a customer?”
Quantity Ordered	Total quantity ordered. With this fact, you can answer questions such as “What is the quantity ordered by a customer?”
Billback Allowance	Total bill back allowance for the sales order. With this fact, you can answer questions such as “What is the billback value associated with a sales order?”
Discount	Total discount for the sales order. With this fact, you can answer questions such as “What is the sales order discount?”
List Price	Transaction list price per unit for the kit component item, for example, sold price. With this fact, you can answer questions such as “What is the list price of the product that was ordered?”
Order Amount	Total amount ordered for the entire order. With this fact, you can answer questions such as “What is the total dollars ordered by product?”, “By customer?”
List Amount	List amount for the entire order. With this fact, you can answer questions such as “Had the customer been charged list price, what would have been the total order amount?”
Extended Price	Total amount ordered for the entire order based on the order line rollup. With this fact, you can answer questions such as “What is the sales order extended price?”
Extended Cost	Total cost associated with an order. With this fact, you can answer questions such as “What is the sales order extended cost?”

Fulfillment - Sales Order Line Ship Fact Table

The Sales Order fact table stores information related to the sales order line and shipping line. With this fact group, you can answer questions such as “What are the shipment dates and delivery performance by customer? By channel? By product? By carrier?”

This table describes the Sales Order Line Ship fact table:

Fact Name	Fact Description
Shipping Line Count	Count of line items shipped for a particular sales order. With this fact, you can answer questions such as “How many items were shipped for this sales order?”
Ship Cost	Total ship cost for a line item on the sales order. With this fact, you can answer questions such as “What is the total shipping cost for this invoice?”
Ship Price	Price of shipping a line item. With this fact, you can answer questions such as “What is the shipping price for a line item?”
Quantity Shipped	Total quantity shipped for a line item. With this fact, you can answer questions such as “What is the total quantity shipped?”
Line Count	Total back ordered quantity for a line item. With this fact, you can answer questions such as “How many line items are there for this sales order?”
Unit Cost	Unit cost of each line item on the sales order. With this fact, you can answer questions such as “What is the unit cost of each line item in the sales order?”
Unit Price	Unit price of each item on the sales order. With this fact, you can answer questions such as “What is the unit price of each sales order line item?”
Unit List Price	List price for each line item. With this fact, you can answer questions such as “What is the listed price for each sales order line item?”
Unit Discount	Unit discount for each line item. With this fact, you can answer questions such as “What is the discount for each sales order line item?”
Quantity Ordered	Quantity ordered for each line item. With this fact, you can answer questions such as “What is the quantity ordered for each sales order line item?”
Quantity Shipped	Quantity shipped for each line item. With this fact, you can answer questions such as “What is the quantity shipped for each sales order line item?”
Quantity Backordered	Quantity back ordered for each line item. With this fact, you can answer questions such as “What is the quantity backordered for each sales order line item?”
Quantity Cancelled	Quantity cancelled for each line item. With this fact, you can answer questions such as “What is the cancelled quantity for this sales order line item?”
Extended Cost	Total cost of the line. With this fact, you can answer questions such as “What is the extended cost for the sales order line item?”
Extended Price	Total price of the line. With this fact, you can answer questions such as “What is the extended price for the sales order line item?”
Extended Discount	Total discount of the line. With this fact, you can answer questions such as “What is the total discount issued for the sales order line item?”

Fulfillment - Kit Fact Table

The Sales Order fact table stores specific data regarding a kit item on the sales order. With this fact group, you can answer questions such as “What is the number of kit items, the item unit cost, and shipped quantities associated with a product, a sales order, and a business unit?”

This table describes the Kit fact table:

Fact Name	Fact Description
Unit Cost	Unit cost for each line item on the sales order. With this fact, you can answer questions such as “What is the unit cost of each sales order line item?”
Unit Price	Unit price of each item on the sales order. With this fact, you can answer questions such as “What is the unit price of each sales order line item?”
Unit List Price	List price for each line item. With this fact, you can answer questions such as ‘What is the unit list price of each sales order line item?”
Unit Discount	Unit discount for each line item. With this fact, you can answer questions such as “What is the unit discount for each sales order line item?”
Quantity Ordered	Quantity ordered for each line item. With this fact, you can answer questions such as “What is the ordered kit item quantity?”
Quantity Shipped	Quantity shipped for each line item. With this fact, you can answer questions such as “What is the shipped kit item quantity?”
Quantity Backordered	Quantity backordered for each line item. With this fact, you can answer questions such as “What is the backordered kit item quantity?”
Quantity Cancelled	Quantity cancelled for each line item. With this fact, you can answer questions such as “What is the cancelled kit item quantity?”

Fulfillment − Bookings Fact Table

The Bookings fact table helps evaluate an employee based on the sales that they generate. With this fact group, you can answer questions such as “What is are the number of sales orders, booked amount, and discount by product, sales person and by requested ship date?”

This table describes the Bookings fact table:

Fact Name	Fact Description
Net Booked Quantity	Net booked order quantity for combination of employee, item, and day. With this fact, you can answer questions such as “What is the sales order net booked quantity?”
Net Booked Amount	Net booked extended price for the combination of employee, item, and day. With this fact, you can answer questions such as “What is the sales order net booked amount?”
Net Booked Cancelled Quantity	Net cancelled quantity for the combination of employee, item, and day. With this fact, you can answer questions such as “What is the net booked cancelled quantity for this sales order?”
Net Booked Cost	Net booked cost for the combination of employee, item, and day. With this fact, you can answer questions such as “What is the net booked cost for the sales order?”
Net Booked Shipped Quantity	Net booked shipped quantity for the combination of employee, item, and day. With this fact, you can answer questions such as “What is the net booked shipped quantity for this sales order?”
Net Booked Backordered Quantity	Net booked backordered quantity for the combination of employee, item, and day. With this fact, you can answer questions such as “What is the backordered quantity for the sales order?”
Net Booked Discount	Net booked discount for the combination of employee, item and day. With this fact, you can answer questions such as “What is the net booked discount for the sales order?”

Fulfillment − Order to Cash Cycle Time Fact Table

The Order to Cash Cycle Time fact table views the complete order to cash process and evaluates the time it takes to complete the process − or life cycle − of Order to Cash. The order to cash cycle time is a key measure of cash flow efficiency. The facts enable you identify each segment of the cycle to understand which segments need improvement. With this fact group, you can answer questions such as “What is the cycle time and lead time for sales order booking to shipping? Shipping to delivery? Delivery to return? Order to invoice? Order to cash?”

Note. All information represents the lead-time or cycle time in days.

This table describes the Bookings fact table:

Fact Name	Fact Description
Number of Days for Order to Pick	Days between order date and pick date. With this fact, you can answer questions such as “What is the lead time in days from sales order to order pick?”
Number of Days for Pick to Ship	Days between pick date and ship date. With this fact, you can answer questions such as “What is the lead time in days from order pick to order shipment?”
Number of Days for Scheduled to Ship	Days between scheduled date and ship date. With this fact, you can answer questions such as “What is the lead time in days from order schedule to order shipment?”
Number of Days for Ship to Deliver	Days between ship date and deliver date. With this fact, you can answer questions such as “What is the lead time in days from order shipment to delivery?”
Number of Days for Order to Ship	Days between order date and ship date. With this fact, you can answer questions such as “What is the lead time in days from order date to actual ship date?”
Number of Days for Order to Deliver	Days between order date and delivery date. With this fact, you can answer questions such as “What is the lead time in days from order date to delivery date?”
Number of Days for Deliver to Return	Days between delivery date and return date. With this fact, you can answer questions such as “What is the lead time in days from delivery date to return date?”
Quoted Lead Time	Lead time quoted at the contract level. With this fact, you can answer questions such as “What is the quoted lead time for sales order delivery?”
Number of Days for Order to Invoice	Days between order date and invoice date. With this fact, you can answer questions such as “What is the lead time in days from sales order to invoice?”
Number of Days for Order to Cash	Days between order date and payment date. With this fact, you can answer questions such as “What is the lead time in days from sales order to cash?”
Lead Time Variance	Difference between quoted lead time and ship date. With this fact, you can answer questions such as “What is the difference between quoted lead time and actual shipment lead time?”

RMA Received Fact Table

The Return Material Authorization (RMA) Received fact table stores data regarding returned material from a sales order and aids in evaluating return sales order price, quantity, and so on. This fact group helps you analyze customer returns by product, channel, carrier, and shipment date. With this fact group, you can answer questions such as “What is the number of products returned?” and “What is the returned amount by customer? By product? By channel? By carrier?”

This table describes the RMA Received fact table:

Fact Name	Fact Description
Received Line Count	Line count for received line items. With this fact, you can answer questions such as “How many sales order line items are returned?”
Sales Order Return Price	Return price for a sales order. With this fact, you can answer questions such as “What is the return price for the sales order line item?”
Sales Order Return Quantity	Total quantity returned for a sales order. With this fact, you can answer questions such as “What is the total sales order quantity returned?”
Sales Order Return Amount	Total Amount for a return quantity on a sales order. With this fact, you can answer questions such as “What is the total sales order return amount?”

Procurement Mart

With Procurement Mart, you evaluate the reliability, timeliness, and efficiency of your procurement process and supply base. Analyzing buyer workload, requisition fulfillment and purchase order processing enables you to identify and eliminate key procurement process inefficiencies. Procurement Mart also enables you to evaluate detailed supplier receipt, such as on time deliveries, over or under shipments, and product quality for complete supplier performance analysis. This crucial view of your procurement process can help your company expose problems early, reducing cost and increasing customer satisfaction.

Procurement Mart enables you to answer questions such as:

What is the total quantity ordered under contract per supplier or buyer?
What is the total dollar amount committed under contract per supplier or buyer?
What is the total dollar amount committed (ordered) per supplier?
Which suppliers contribute the most in terms of purchase order activity?
Which buyers are the most productive?
Which suppliers have the most returns?
How much improvement has a supplier made in returns?
How much more purchasing volume has transpired over the year?
What is the total amount ordered from a specific supplier over a specified time period?
What is the total purchase order dollars controlled by one buyer?
Has the number of rejected units from a supplier improved over time? Is a specific item causing the greatest number of rejects?
What is the supplier service quality?
How often does a supplier under or over ship?
Which suppliers have the best acceptance rates?
What percentage of time does a supplier ship early or late?
Do the early or late shipments occur at the beginning or end of the month?
What is the average difference between the shipment due date and receipt date? Has the supplier improved over time?
How often does a supplier over or under ship orders?
What is the value of those under or over shipments?
Is a supplier improving shipment accuracy from period to period?
What is the acceptance rate for orders received?
Has the percent inspected increased due to supplier past acceptance rates?
What is the value of the rejected orders?
How long does a requisition take to process?
What is the amount requisitioned by each department?

Procurement Business Process

Procurement Mart is tied to PeopleSoft’s Procurement business process, which is also known as the Source to Settle business process. The Procurement business process fulfills an organization's requirements for sourcing, engaging, procuring, and settling payment for goods, services, or both. The Procurement business process enables you to determine profitability and sourcing strategies, collaborate with suppliers, and drive efficient procurement and settlement for all goods and services.

Procurement Mart Delivered Facts

With Procurement Mart, PeopleSoft provides the following fact tables:

Purchasing subject area:
- Purchase Order Line fact
- Purchase Order Received Shipment fact
- Purchase Order Distribution fact
- Purchase Order Disposition fact
Procurement Match Analysis subject area contains the Matching Analysis fact.
Return to Vendor (RTV) Analysis subject area:
- RTV fact
- RTV Distribution fact
Procurement Cycle Lead Time
Requisition Analysis subject area:
- Requisition Line fact
- Requisition Analysis fact

Distribution and Receipt Analysis (Purchase Order) − Purchase Order Line Fact

The Purchase Order Line fact stores information related to the purchase order line level, which is the lowest purchase order transaction granularity. With this fact group, you can answer questions such as “What is the purchase order quantity by supplier?”, "What is the purchase order discount by business unit?”, “What is the purchase order discount by item?” and “What is the purchase order amount by carrier and order date?”

This table describes the Purchase Order Line fact table:

Fact Name	Fact Description
Line Extended Price	The unit cost multiplied by the number of units. With this fact, you can answer questions such as “What is the purchase order unit price?”
Unit Cost	The unit cost of one item, as purchased from the supplier, excluding freight, taxes, discounts, and other factors that might modify the actual unit cost you record when you receive the item. With this fact, you can answer questions such as “What is the unit cost of the item?”
Units On Hold	The unit cost of one item, as purchased from the supplier, excluding freight, taxes, discounts, and other factors that might modify the actual unit cost you record when you receive the item. With this fact, you can answer questions such as “What is the number of units on hold?”
Units Open	Total quantity of units that are open for the purchase order line. With this fact, you can answer questions such as “What is the number of open units?”
Units Ordered	Total quantity of units that were ordered for the purchase order line. With this fact, you can answer questions such as “What is the total number of purchase order units ordered?”
Units Received	Total amount for units received for the purchase order line. With this fact, you can answer questions such as “What is the total number of units received?”
Units Relieved	Total amount for units relieved for the purchase order line. With this fact, you can answer questions such as “What is the total number of units relieved?”
Units on Hold Amount	Total amount for units that are on hold for the purchase order line. With this fact, you can answer questions such as “What is the on hold purchase order amount?”
Units Open Amount	Total number of units multiplied by price with “Open” status on the purchase order line With this fact, you can answer questions such as “What is the total of open amounts?”
Units Relieved Amount	Total amount for units relieved for the purchase order line. With this fact, you can answer questions such as “What is the total received amount?”

Distribution and Receipt Analysis (Purchase Order) − Purchase Order Received Shipment Fact

The Purchase Order Received Shipment fact table stores purchase order received shipment information. With fact group, you can answer questions related to purchase order quantities and amount that are rejected, accepted and completed. This fact group also answers questions related to open amount and unit cost variance. This information is stored at the Receipt Line Shipment level.

This table describes the facts in the Purchase Order Received Shipment fact table:

Fact Name	Fact Description
Quantity Accepted	Quantity accepted for a purchase order. With this fact, you can answer questions such as “What is the purchase order accepted quantity?”
Quantity Inspected	Quantity inspected for a purchase order. With this fact, you can answer questions such as “What is the purchase order inspected quantity?”
Quantity Received	Quantity received for a purchase order. With this fact, you can answer questions such as “What is the purchase order received quantity?”
Quantity Rejected	Quantity rejected for a purchase order. With this fact, you can answer questions such as “What is the purchase order rejected quantity?”
Units Received	Number of units received for a purchase order. With this fact, you can answer questions such as “What is the purchase order number of received units?”
Units Adjusted	Number of units adjusted for a purchase order. With this fact, you can answer questions such as “What is the purchase order number of adjusted units?”
Units Closed	Number of units closed for a purchase order. With this fact, you can answer questions such as “What is the purchase order number of closed units?”
Units Open	Number of units open for a purchase order. With this fact, you can answer questions such as “How many units of a given item have an ‘Open’ status?”
Units Ordered	Units ordered for a purchase order. With this fact, you can answer questions such as “What is the total number of purchase order units ordered?"
Paid to Date	Purchase order paid date. With this fact, you can answer questions such as “What is the number of purchase order amount paid to date?”
Units Returned	Units returned for a purchase order. With this fact, you can answer questions such as “What is the number of purchase order units returned?”
Units Reworked	Units reworked for a purchase order. With this fact, you can answer questions such as “What is the number of purchase order units reworked?”
Units Scrapped	Scrapped units for a purchase order. With this fact, you can answer questions such as “What is the number of purchase order units scrapped?”
Units Stocked	Units stocked for a purchase order. With this fact, you can answer questions such as “What is the number of purchase order units stocked?”
Date Purchase Order	Order date from receipt. With this fact, you can answer questions such as “What is the purchase order receipt date?”
Line Fulfillment Status	Line fulfillment status for a purchase order. With this fact, you can answer questions such as “What is the line fulfillment status of the purchase order?”
Receipt On Schedule Status	Receipt on schedule status. With this fact, you can answer questions such as “What is the purchase order receipts on schedule status?”
Lead Time	Lead time for a purchase order. With this fact, you can answer questions such as “What is the purchase order lead time?”
Lead Time Planned	Planned lead-time for a purchase order. With this fact, you can answer questions such as “What is the purchase order planned lead time?”
Amount Accepted	Amount accepted for a received line. With this fact, you can answer questions such as “What is the purchase order accepted amount?”
Amount Inspected	Amount inspected for a received shipment line. With this fact, you can answer questions such as “What is the purchase order inspected amount?”
Amount Received	Amount received for a shipment line. With this fact, you can answer questions such as “What is the purchase order received amount?”
Amount Rejected	Amount rejected for a received shipment line. With this fact, you can answer questions such as “What is the purchase order rejected amount?”
Receipt Unit Cost	Unit cost at the order receipt of one item, as purchased from the supplier, excluding freight, taxes, discounts, and other factors that might modify the actual unit cost when receipt is recorded. With this fact, you can answer questions such as “What is the purchase order receipt unit cost?”
Standard Unit Cost	Standard unit cost at the order receipt level of one item as purchased from the supplier, excluding freight, taxes, discounts, and other factors that might modify the actual unit cost recorded when item is received. With this fact, you can answer questions such as “What is the purchase order item’s standard unit cost?”
Standard Unit Cost Variance	Variance between Receipt Unit Cost and Stand Unit Cost, calculated and stored during ETL. With this fact, you can answer questions such as ”What is the ordered unit cost variance?”
Ordered Unit Cost Variance	Used to calculate purchase price variance metric. With this fact, you can answer questions such as “What is the ordered unit cost variance?”
Amount Closed	Total amount closed for the purchase order receipt or voucher. With this fact, you can answer questions such as “What is the purchase order closed amount?”
Amount Open	Total amount for units that are open for the purchase order. With this fact, you can answer questions such as “What is the purchase order open amount?”
Receipt Amount Paid to Date	Total amount paid to date for the purchase order receipt or voucher. With this fact, you can answer questions such as “What is the purchase order receipt amount paid to date?”

Distribution and Receipt Analysis (Purchase Order) − Purchase Order Distribution Fact Table

The Purchase Order Distribution fact table is a highly multidimensional table that stores purchase order distribution information such as Merchandise Amount and Ordered Quantity. This information is stored at the Purchase Order Distribution Line level. With this fact group, you can answer questions such as “What is the purchase order freight amount for this supplier?”, What is the purchase order merchant amount for this carrier?” and “What is the purchase order sales tax amount for this business unit or item?”

This table describes the facts in the Purchase Order Distribution fact table:

Fact Name	Fact Description
Purchase Order Ship Line Count	Count of item lines shipped. With this fact, you can answer questions such as “How many lines on the purchase order have been shipped?”
Purchase Order Merchant Amount	Merchant amount for purchase orders. With this fact, you can answer questions such as “What is the purchase order merchant amount?”
Purchase Order Quantity	Quantity ordered for the purchase order With this fact, you can answer questions such as “What is the quantity for this purchase order?”
Purchase Order Freight Amount	Freight amount for the purchase order. With this fact, you can answer questions such as “What is the freight amount for this purchase order?”
Purchase Order Sales Tax Amount	Sales tax amount for the purchase order. With this fact, you can answer questions such as “What is the sales tax amount for this purchase order?”

Distribution and Receipt Analysis (Purchase Order) − Purchase Order Disposition Fact Table

The Purchase Order Disposition fact table stores purchase units removed from a purchase order line item for a specific reason such as a broken or wrong item. This helps in maintaining an accurate unit count for a particular item. With this fact group, you can answer questions such as “How many units were removed from this purchase order and what was the reason?”

This table describes the facts in the Purchase Order Disposition fact table:

Fact Name	Fact Description
Primary Unit of Measure	Primary unit of measure for the disposed item. With this fact, you can answer questions such as “What is the primary unit of measure for the disposed item?”
Primary Unit of Measure Units	Units disposed. With this fact, you can answer questions such as “How many units in the primary unit of measure were disposed?’

Matching Analysis Fact Table

The Matching Analysis Fact is a highly multidimensional table that stores the voucher dollar amount and age of vouchers related to invoice-entered date, invoice last updated date, and invoice age. This information is stored at the Voucher Line level. This fact group answers questions such as “What is the age of this invoice?”, “What is the age of the invoice?” and “What is the lead-time for each matching process by supplier?” “By item?” “By date?” “By business unit?”

This table describes the facts in the Entitlement fact table:

Fact Name	Fact Description
Voucher Amount	Voucher amount. With this fact, you can answer questions such as “What is the amount for this voucher?”
Invoice Age	Days between invoice date and match date. With this fact, you can answer questions such as “How long in days did it take between invoice date and invoice matching date?”
Invoice Entered Age	Days between invoice entered date and match date. With this fact, you can answer questions such as “How long in days did it take between invoice entered date and invoice matching date?”
Invoice Last Update Age	Days between invoice last update date and match date. With this fact, you can answer questions such as “How long in days did it take between invoice last update date and match date?”

RTV Analysis - RTV Fact Table

The RTV fact table is a highly multidimensional table that stores information at the RTV Line level. With this fact group, you can answer questions such as “What was the price of the units returned to vendor for a particular supplier?” and “How many units were returned to vendor for a specific item?”

This table describes the RTV fact table:

Fact Name	Fact Description
Purchase Order Price	Price for this purchase order. With this fact, you can answer questions such as “What is the price for this purchase order?”
Purchase Order Quantity Returned	Number of items returned for this purchase order. With this fact, you can answer questions such as “How many items on this purchase order were returned?”
Purchase Order Amount Returned	Number of items returned for a purchase order. With this fact, you can answer questions such as “How many items on this purchase order were returned?”

RTV Analysis - RTV Distribution Fact Table

The RTV Distribution fact table is a highly multidimensional table that stores RTV shipping line level information such PO Amount Returned and PO Quantity Returned. This information is stored at the RTV Shipping Line level. With this fact group, you can answer questions such as “How many items were returned for a business unit?”, “What was the reason for their being returned?” and “How many items were returned on a particular date?”

This table describes the RTV Distribution fact table:

Fact Name	Fact Description
Purchase Order Price	Price on the purchase order. With this fact, you can answer questions such as “What was the price of the returned item?”
Purchase Order Quantity Returned	Number of returned items on the purchase order. With this fact, you can answer questions such as “How many ordered units were returned on this purchase order?”
Purchase Order Amount Returned	Amount in dollars of returned items on a purchase order. With this fact, you can answer questions such as “What was the total amount for returned items on a purchase order?”

Procurement Cycle Lead Time Fact Table

The Procurement Cycle Lead Time fact table is a highly multidimensional table that stores the days between different points in the ordering, receiving, and payment processes. This information is stored at the Purchase Order Line level. With this fact group, you can answer questions such as “What was the lead time for the procurement process by supplier?” “By business unit?” “By date?” “By reject reason?”

This table describes the Procurement Cycle Lead Time fact table:

Fact Name	Fact Description
Expected Lead Time	Expected lead time that is quoted by suppliers. With this fact, you can answer questions such as “What was the quoted lead time by the supplier?”
Days from Purchase Order Dispatch to Last Receipt	Time in days from the purchase order dispatch to the last receipt. With this fact, you can answer questions such as “What was the number of days from the purchase order dispatch to the material receipt?”
Days From Receipt to Last Voucher	Time in days from receipt to last voucher. With this fact, you can answer questions such as “What is the number of days from material receipt to the voucher?”
Days From Voucher to Last Payment	Time in days from voucher to the last payment. With this fact, you can answer questions such as “How many days were there between the voucher and the last payment?”

Requisition Analysis − Requisition Line Fact Table

The Requisition Line fact table is a highly multidimensional table that stores requisition line level details. With this fact group, you can answer questions such as “What was the quantity for this material requisition?”, “What was the price for this material requisition?”, and “What were the buyer and buyer’s department for this material requisition?”

This table describes the Requisition Line fact table:

Fact Name	Fact Description
Quantity Requested	Quantity requested on the requisition. With this fact, you can answer questions such as “What is the requested quantity by the buyer?”
Price Requested	Price requested on the requisition. With this fact, you can answer questions such as “What is the requested price by the buyer?”

Requisition Analysis − Requisition Analysis Fact Table

The Requisition Analysis fact table is a highly multidimensional table that stores the days between different points in the requisition, ordering, receiving, and payment processes. This information is stored at the Requisition Line level. With this fact group, you can answer questions such as “What was the lead time for this requisition process for this business unit?” “For this buyer and buyer department?”, “For this location?”

This table describes the Requisition Analysis fact table:

Fact Name	Fact Description
Days from Requisition Creation to Approval	Time in days from requisition creation to approval. With this fact, you can answer questions such as “How long did it take from purchase order requisition to approval?”
Days From Requisition Approval to Last PO Dispatch	Time in days from requisition approval to the last purchase order dispatch. With this fact, you can answer questions such as “How long did it take from purchase order approval to purchase order dispatch?”
Days From PO Dispatch to Last Receipt	Time in days from purchase order dispatch to material receipt. With this fact, you can answer questions such as “How long did it take from purchase order dispatch to material receipt?”
Days From Receipt to Last Voucher	Time in days from material receipt to last voucher. With this fact, you can answer questions such as “How long did it take from material receipt to the last voucher?”
Days From Voucher to Last Payment	Time in days from voucher to last payment. With this fact, you can answer questions such as “How long did it take from the voucher to the last payment?”

Spend Mart

Every supply chain manager has an implicit goal to drive down unit cost without sacrificing product and service quality. But most managers do not have enough visibility into their supply chain to effectively manage the cost. Spend Mart enables you to examine the source-to-settle process to isolate maverick spending, excessive purchase price variances, and contract compliance issues. With Spend Mart, you are able to evaluate your supplier diversity programs to increase your government subsidies, look for opportunities to consolidate your supply base, and maximize your contract negotiations by leveraging supplier performance statistics. You will also gain visibility into spending across divisions and access, analyze and uncover information about spending patterns to help enhance relationships with existing suppliers, and initiate more profitable relationships with new suppliers. With Spend Mart you will be able to answer questions such as:

With which suppliers do we spend the most?
On which supplies do we spend the most?
What departments have the most maverick spend?
With which minority owned businesses are we spending the most?
Why are invoices not being paid on time?
Which supplier and products have the largest purchase price variance?

Spend Business Process

Spend Mart is related to PeopleSoft’s Procurement business process, which is also known as the Source to Settle business process. This business process is described with the Procurement Mart. Spend Mart helps measure the dollars flowing through the Source to Settle process. This mart enables you to analyze potential spending, for example, requisition amounts or open purchase order amounts, or invoiced amounts from suppliers, actual payments to suppliers, net discounts and adjustments.

Spend Mart Delivered Fact Tables

With Spend Mart, PeopleSoft provides the following fact tables:

Voucher
Voucher Line

Voucher Fact Table

The Voucher fact is a multidimensional fact table that stores information such as Payment Amount and Payment Discount. This information is stored at the Voucher level. With this fact group, you can answer questions such as “What is the amount paid out against a voucher and associated discounts by business unit or by date?”

This table describes the facts in the Voucher fact table:

Fact Name	Fact Description
Payment Count	The number of payments made against the voucher. With this fact, you can answer questions such as “What is the number of payments made against the voucher?”
Payment Amount	Amount paid for the voucher. With this fact, you can answer questions such as “What is amount paid for the voucher?”
Payment Discount	Discount associated with the payment for a voucher. With this fact, you can answer questions such as “What is the amount of discount associated with payment for a voucher?”
Voucher Line Count	Voucher line count associated with a voucher. With this fact, you can answer questions such as “What is the count of the voucher line associated with the voucher?”

Voucher Line Fact Table

The Voucher Line fact is a multidimensional fact table that stores accounts payable information captured in the Accounts Payable fact table and related detailed spending information from the General Ledger fact, Purchase Order Line fact, and Purchase Order Receipt and Voucher fact tables.

With this fact group, you can answer questions such as “What was the purchase order price compared to the voucher price by business unit, by buyer, or by date?”

This table describes the facts in the Voucher Line fact table:

Fact Name	Fact Description
Purchase Order (PO) Price	PO price associated with the voucher line item. With this fact, you can answer questions such as “What is the purchase order price associated with the voucher line item?”
Voucher Price	Voucher price associated with the voucher line item. With this fact, you can answer questions such as “What is the voucher price associated with the voucher line item?”
Voucher Quantity	Voucher quantity associated with the voucher line item. With this fact, you can answer questions such as “What is the voucher quantity associated with the voucher line?”
Voucher Line Count	Price variance between the purchase price and the current price of the item. With this fact, you can answer questions such as “What is the price variance between the purchase price and the current of the item on the voucher line?”

Inventory Mart

Inventory management is an act of balancing cost and service. Maintaining large inventories is expensive and risky. But, small inventories may compromise your ability to satisfy a sudden increase in demand. Inventory Mart provides supply chain performance analytics centered around these key inventory issues, such as demand, ability to meet demand, inventory turns, inbound supplies, quantities on hand, and other key metrics. These analytics can enable you to limit the direct costs of maintaining excess inventory, as well as the direct and indirect costs of not meeting the services levels required by your customers.

Inventory Mart enables you to answer questions such as:

How accurate is my inventory application count versus physical count?
Which inventory items have the best or worst accuracy?
What is the cost of the inaccuracy?
What is the value of inventory on hand?
How many weeks of supply are on hand?
What is the demand by item and by location?
What is the inventory value of the demand?
Has the weeks of supply improved from last year?
How much lower or higher are the inventory turns from last year?
Has the inventory accuracy improved from last year?
Is there enough supply to meet demand?
What is the status of the on hand stock?
Which items, and how many, are on hold?
What are the fast and slow movers (items)?
What are the fast and slow mover (item) trends?
What is the value of the fast and slow movers?
How often does inventory turn by item or by inventory location?
What is the inventory value by item or by location?
How many units of an item are currently in inventory?
How many weeks of supply are available to meet current demand?
How many units are on order to help meet demand?

Inventory Business Process

Inventory Mart supports multiple business process, including Order Fulfillment, Procurement, and Production, which is also known as Plan to Produce business process. The Order Fulfillment and Procurement business are described previously. With the Production business process, you can assess demand, determine supply requirements and allocate production capacity, as well as continually monitor and manage the efficiency of your production process.

Inventory Mart Delivered Fact Tables

With Inventory Mart, PeopleSoft provides the following fact tables:

Physical Inventory
Inventory Cycle Count
Inventory Transaction
Inventory Ledger
History Summary Ledger

Physical Inventory Fact Table

The Physical Inventory fact stores inventory information such as Open, Received, Hold, and Rejected Quantities. The facts are by inventory location, item and date dimensional criteria. That is, you can evaluate physical inventory by its location, by a specific item, or by a specific date or date range, or by all of these criteria.

This table describes the facts in the Physical Inventory fact table:

Fact Name	Fact Description
Open Quantity	Open quantity in inventory. With this fact, you can answer questions such as “How many of this item are available for the transaction?”
Restricted Quantity	Restricted quantity in inventory. With this fact, you can answer questions such as “How many of this item are restricted and not available for the transaction?”
Hold Quantity	Quantity on hold in inventory. With this fact, you can answer questions such as “How many of this item are on hold for the transaction?”
Rejected Quantity	Rejected quantity in inventory. With this fact, you can answer questions such as “How many of this item are rejected on the transaction?”

Inventory Cycle Count Fact Table

The Inventory Cycle Count fact is a multidimensional table that stores inventory information at a point in time in which inventory was counted, as well as how often those events occurred. This fact table helps evaluate metrics such as Unit Cost and Adjusted Cost that are calculated during the various cycle counts for a specific invoice. With this fact group, you can answer questions such as “What the total adjusted cost and adjusted quantities per cycle count by store? By inventory item? By business unit?”

This table describes the facts in the Inventory Cycle count fact table:

Fact Name	Fact Description
Cycle Event Count	Number of cycle counts for which the inventory was counted. With this fact, you can answer questions such as “How many cycle counts for this item were there for this invoice?”
Count Quantity	Quantity counted for each item in the inventory at cycle count. With this fact, you can answer questions such as “What is the count quantity for this cycle count?”
Adjusted Quantity	Adjusted quantity for each item. With this fact, you can answer questions such as “What is the adjusted quantity for this cycle count?”
Absolute Adjusted Quantity	Absolute adjusted quantity for each event. With this fact, you can answer questions such as “What is the absolute value of the quantity that is adjusted?
Unit Cost	Inventory unit cost for each cycle count. With this fact, you can answer questions such as “What is the unit cost for this cycle count?”
Adjusted Cost	Adjusted unit cost for each cycle count. With this fact, you can answer questions such as “What is the adjusted cost associated with the adjusted quantity for this cycle count?”
Absolute Adjusted Cost	Absolute adjusted unit cost for each cycle count. With this fact, you can answer questions such as “What is the absolute value of the adjusted cost associated with the adjusted quantity for this cycle count?”

Inventory Transaction Fact Table

The Inventory Transaction fact stores inventory transaction information such as Demand, Received, Issued, Quantity on Hand, Backorder, Purchase Order, Work Order Received, Hard Committed, Soft Committed, Future Commit, Units in Transit, Units in Inspection, and Inter Unit Transfer Quantity and Amount. This fact table also helps evaluate item cost and Quantity on Hand Cost. With this fact group, you can answer questions such as “How much inventory is available to meet demand?”, “How much inventory is being transferred from another Inventory location?”, “At what Cost?” and “How quickly am I turning over inventory?”

This table describes the facts in the Inventory Transaction fact table:

Fact Name	Fact Description
Transaction Demand Count	Inventory demand count for each transaction. With this fact, you can answer questions such as “What is the count of the quantity demanded for this transaction?”
Transaction Shipping Line Count	Shipping line count for each transaction. With this fact, you can answer questions such as “How many on each line was shipped for this transaction?”
Transaction Issue Count	Issue count in inventory for each transaction. With this fact, you can answer questions such as “How many on each line was issued for this transaction?”
Transaction Unit Count	Unit count for each transaction. With this fact, you can answer questions such as “How many units were involved in this transaction?”
Onhand	On hand quantity in inventory for each transaction. With this fact, you can answer questions such as “What is the quantity on hand for this transaction?”
Demand	Demand quantity for each transaction. With this fact, you can answer questions such as “What is the quantity demanded for this transaction?”
Supply Quantity	Supply quantity for each transaction. With this fact, you can answer questions such as “What is the count of the quantity supplied for this transaction?”
Issued Quantity	Issued quantity for each transaction. With this fact, you can answer questions such as “What is the count of the quantity issued for this transaction?”
Inter Unit Transfer Quantity	Inter unit transfer quantity for each transaction. With this fact, you can answer questions such as “What is the count of the quantity acquired through interunit transfers for this transaction?”
Quantity on Backorder	Quantity on backorder for inventory. With this fact, you can answer questions such as “What is the count of the quantity on back order for this transaction?”
Quantity on Purchase Order	Quantity on purchase order for inventory. With this fact, you can answer questions such as “What is the count of the quantity on the purchase order for this transaction?”
Quantity on Work Order Receipt	Quantity on work order receipt for inventory. With this fact, you can answer questions such as “What is the count of the quantity on the work order for this transaction?”
Quantity1 Other Primary Units	Quantity in other primary units; used if more inventory classifications are required. The first of two quantities that can be specified as additional offsets (subtractions from onhand) in the determination of quantities available for sale. With this fact, you can answer questions such as “What is the first quantity available as an additional offset?”
Quantity2 Other Primary Units	Quantity in other primary units, if more inventory classifications are required. The second of two quantities that can be specified as additional offsets (subtractions from onhand) in the determination of quantities available for sale. With this fact, you can answer questions such as “What is the second quantity available as an additional offset?”
Quantity Other Purchasing	Quantity that appears on documents, such as bid requests, which are not formal commitments by your organization to buy. With this fact, you can answer questions such as “What is the quantity proposed for the purchase?”
Quantity Hard Committed	The number of units committed to a specific location and lot. With this fact, you can answer questions such as “What is the committed quantity?”
Quantity Soft Committed	The number of units needed, but not committed to a specific location. With this fact, you can answer questions such as “What is the quantity required, but not committed?”
Quantity on Future Commit	The quantity on a sales order whose requested shipment date is beyond the standard commitment period for that branch. With this fact, you can answer questions such as “What is the quantity available for the commitment?”
Quantity Work Order Soft Commit	The number of units needed by work orders, but not committed to a specific location. With this fact, you can answer questions such as “What is the count of quantity as a soft commit on the work order?”
Quantity Work Order Hard Commit	Number of units hard committed to work orders in the primary unit of measure. With this fact, you can answer questions such as “What is the count of quantity as a hard commit on the work order?”
Units in Transit	Total quantity of items that are currently in transit to the warehouse. With this fact, you can answer questions such as “What is the number of units in transit?”
Units in Inspection	Total quantity of items that are currently being inspected. With this fact, you can answer questions such as “What is the number of units under inspection?”
Unit Cost	Unit cost for each item in inventory. With this fact, you can answer questions such as “What is the unit cost of the items in this transaction?”
Demand	Demand cost for each item in inventory. With this fact, you can answer questions such as “What is the demanded cost for each item in this transaction?”
Received	Receiving cost for each item in inventory. With this fact, you can answer questions such as “What is the cost that is received for the item in this transaction?”
Issued	Issuing cost for each item in inventory. With this fact, you can answer questions such as “What is the issuing cost for each item in this transaction?”
Inter Unit Transfer Cost	Inter unit transfer cost for each item in inventory. With this fact, you can answer questions such as “What is the cost incurred for the interunit transfers?”
Quantity on Loan to Manufacturing	The quantity of an item that is being used by manufacturing, but will be replaced. With this fact, you can answer questions such as “What is the quantity on loan to manufacturing?”
Quantity on Hand Cost	The total cost for all quantities on hand. With this fact, you can answer questions such as “What is the total cost associated with the quantity on hand?”

Inventory Ledger Fact Table

The Inventory Ledger fact stores inventory information that is related to the ledger level. With this fact group, you can evaluate primary unit of measure quantity, unit of measure unit cost, extended cost, and transaction explanation. With this fact group, you can answer questions such as “What is the total cost by Inventory Item? By Lot? By Inventory Location?”

This table describes the facts in the Inventory Ledger fact table:

Fact Name	Fact Description
Primary Unit of Measure Quantity	Total quantity of items involved in the transaction in the primary unit of measure. With this fact, you can answer questions such as “What is the total quantity of items involved in the transaction in the primary unit of measure?”
Ledger Sum Quantity	Sum of all quantities for transactions that have been archived to historical files. With this fact, you can answer questions such as “What is the sum of all of the quantities associated with this ledger transaction?”
Primary Unit of Measure Unit Cost	Cost per item in primary unit of measure. With this fact, you can answer questions such as “What is the unit cost of each item measured in the primary unit of measure?”
Ledger Extended Cost	Total cost associated with the transaction. With this fact, you can answer questions such as “What is the total cost associated with each transaction on this ledger?”
Ledger Sum Amount	Sum of all monetary amounts for transactions that have been archived to historical files. With this fact, you can answer questions such as “What is the sum of the amounts for all of the transactions associated with this ledger?”

History Summary Ledger Fact Table

The History Summary Ledger fact stores inventory information that relates at ledger level. Specifically, this fact table evaluates primary unit of measure quantity, unit of measure unit cost, extended cost, and transaction explanation. With this fact group, you can answer questions such as “What is the total sum of quantities of all transactions by business unit? For a specific fiscal year? By item location?”

This table describes the facts in the Web Response fact table:

Fact Name	Fact Description
Ledger Summary Quantity	The sum of all quantities for transactions that have been archived to historical files. With this fact, you can answer questions such as “What is the sum of the quantities on all of the transactions associated with each ledger?”
Ledger Summary Amount	The sum of all monetary amounts for transactions that have been archived to historical files. With this fact, you can answer questions such as “What is the sum of the amounts related to the quantities on all of the transactions associated with each ledger?”

Manufacturing Mart

In today’s manufacturing environments, one of the challenges facing product managers, manufacturing managers, and operations analysts is understanding how production and machine schedules will meet orders and forecasted demand across multiple plants or production lines. Manufacturing Mart enables you to analyze your production schedule effectively to make informed decisions and ultimately optimize plant, equipment, and production investments. The capability provides the visibility into cost, reliability, timeliness, and efficiency of your manufacturing operations. Armed with this level of insight, you will be able to determine planned production downtime and product availability, calculate scrap costs for plant-level items, and capture production lead times by work order. With Manufacturing Mart, you can answer questions such as:

How effectively is production capacity being utilized?
How much time does it take to complete work orders?
What is the scrap cost per product? Per business unit?
How much downtime can be scheduled for maintenance?
What are the manufacturing lead times by work order?

Production Business Process

Manufacturing Mart supports the Production business process, which is also known as the Plan to Produce business process. This business process is described previously. The Production business process includes a production plan or schedule that identifies the type and amount of products to be manufactured over a given time period. Depending on the type of production, work orders or schedules are issued to the shop floor to commence production. Production is tracked through the production line until the order is complete. The completed production is either placed into inventory (make-to-stock) or may be shipped directly to the customer (make-to-order).

Manufacturing Mart Delivered Fact Tables

With Manufacturing Mart PeopleSoft provides the following fact tables:

Production Cost
Workorder Master
Workcenter Master
Workorder Routing
Workcenter Resource Unit
Workorder Part List
Workorder Time Transaction

Production Cost Fact Table

The Production Cost fact table is a highly multidimensional table that stores the cost information for a given work order. With this fact group, you can answer questions such as “How much does it cost to produce a product?” and “Which components are the most costly?”

This table describes the facts in the Production Cost fact table:

Fact Name	Fact Description
Standard Units Primary	Standard number of work order units that can be produced in a given period. With this fact, you can answer questions such as “ What is the standard number of units that can be produced, measured in the primary unit of measure (UOM)?”
Standard Amount	Standard amount in dollars to produce a given quantity. With this fact, you can answer questions such as “What is the standard cost associated with the standard number of units that can be produced, measured the primary UOM?”
Actual Units Primary	Number of actual units. With this fact, you can answer questions such as “What is the actual number of units that can be produced, measured in the primary UOM?”
Actual Amount	Actual amount to produce a given quantity of units. With this fact, you can answer questions such as “What is the actual cost associated with the actual number of units that can be produced, measured in the primary UOM?”
Current Units Primary	Number of current units. With this fact, you can answer questions such as “What is the actual number of units that can be produced, measured in the primary UOM?”
Current Amount	Current amount to produce a given quantity. With this fact, you can answer questions such as “What is the actual cost associated with actual number of units that can be produced, measured in the primary UOM?”
Planned Units Primary	Number of planned units. With this fact, you can answer questions such as “What is the planned number of units that can be produced, measured in the primary UOM?”
Planned Amount	Planned amount to produce a given quantity of units. With this fact, you can answer questions such as “What is the cost associated with the planned number of units that can be produced, measured in the primary UOM?”
Completed Units Primary	Number of completed units. With this fact, you can answer questions such as “What is the cost associated with the completed number of units that can be produced, measured in the primary UOM?”
Completed Amount	Completed amount to produce a given quantity. With this fact, you can answer questions such as “What is the cost associated with the completed number of units that can be produced, measured in the primary UOM?”
Scrapped Units Primary	Number of scrapped units. With this fact, you can answer questions such as “What is the number of scrapped units that can be produced, measured in the primary UOM?”
Scrapped Amount	The parent scrap cost to produce a given quantity of units. With this fact, you can answer questions such as “What is the cost associated with the number of scrapped units that can be produced, measured in the primary UOM?”

Workorder Master

The Workorder Master fact is a multidimensional table that stores the fact information of work orders such as the date and quantity of work order. With this fact group, you can answer questions such as “How many work orders are due on a specific date?”, “What is the percent completion of those orders?” and “How much scrap is being produced?”

This table describes the facts in the Workorder Master fact table:

Fact Name	Fact Description
Quantity Order Primary	Number of units requested on the work order. With this fact, you can answer questions such as “What is the number of units requested on the work order, measured in the primary UOM?”
Quantity Shipped Primary	Number of units completed on a work order. With this fact, you can answer questions such as “What is the shipped quantity that is associated with the work order, measured in the primary UOM?”
Quantity Scrapped Primary	Number of units scrapped for a work order. With this fact, you can answer questions such as “What is the quantity scrapped that is associated with the work order, measured in the primary UOM?”
Date Workorder Ordered	Date work order was ordered. With this fact, you can answer questions such as “What is the date that the work order was ordered?”
Date Workorder Requested	Date work order was requested. With this fact, you can answer questions such as “What is the date that the work order was requested?”
Date Workorder Started	Date work order was started. With this fact, you can answer questions such as “What is the date on which the work order was started?”
Date Workorder Completed	Date work order was completed. With this fact, you can answer questions such as “What is the date on which the work order was completed?”

Workcenter Master Fact Table

The Workcenter Master fact is a multidimensional table that stores the information of a work center. Work center is analogous to a production area. With this fact group, you can answer questions such as “How effectively am I utilizing my work centers?” and “What is the total capacity of a work center?”

This table describes the facts in the Workcenter Master fact table:

Fact Name	Fact Description
Work Center Utilization	Stand utilization rate at which a work center usually operates. With this fact, you can answer questions such as “What is the utilization capacity at which this work center can be used?”
Work Center Efficiency	Stand efficiency rate at which a work center usually operates. With this fact, you can answer questions such as “What is the rate of efficiency at which this work center can be used?”
Standard Capacity	Standard capacity level at which a work center usually operates. With this fact, you can answer questions such as “What is the standard capacity at which this work center can be used?”

Workorder Routing Fact Table

The Workorder Routing fact is a multidimensional table that stores the fact information of work order routing such as queue time, runtime, and labor time.

This table describes the facts in the Workorder Routing fact table:

Fact Name	Fact Description
Standard Move Hours	Standard number of hours required to move units for a work order. With this fact, you can answer questions such as “What is the standard number of hours required to move units per work order?”
Standard Queue Hours	Standard number of hours an item sits in a queue before being worked on at a work center. With this fact, you can answer questions such as “What is the standard number of hours that the item on the work order is in the queue?”
Standard Run Machine	Standard number of hours a machine will run for a work order. With this fact, you can answer questions such as “What is the standard number of hours that a machine is required to run for this work order”
Standard Run Labor	Standard number of labor hours needed for a work order. With this fact, you can answer questions such as “What is the standard number of labor hours required for this work order?”
Standard Setup Labor	Standard number of hours needed to set up machines for a work order. With this fact, you can answer questions such as “What is the standard number of hours required to set up the labor for this work order?”
Actual Run Machine	Actual number of machine hours reported for a work order. With this fact, you can answer questions such as “What is the actual number of machine work hours reported for this work order?”
Actual Run Labor	Actual number of labor hours reported for a work order. With this fact, you can answer questions such as “What is the actual number of labor work hours reported for this work order?”

Workcenter Resource Unit Fact Table

The Workcenter Resource Unit fact is a multidimensional fact table that stores the resource information of a work center. With this fact group, you can answer questions such as “Do I have enough capacity to complete the scheduled production at a work center?”

This table describes the fact in the Workcenter Resource Unit fact table:

Fact Name	Fact Description
Resource Unit	A number that indicates the capacity of a work center on a given day. With this fact, you can answer questions such as “What is the capacity of the work of this work center on a given day?”

Workcenter Part List Fact Table

The Workorder Part List fact is a multidimensional table that stores the part list information of a given workorder. With this fact group, you can answer questions such as “Do I have enough parts to complete the scheduled production at a work center?”

This table describes the fact in the Workcenter Part List fact table:

Fact Name	Fact Description
Part List Quantity Available	Quantity of components, ingredients, co-product or by-product issued or completed. With this fact, you can answer questions such as “What is the available part list quantity available?”
Part List Quantity Ordered Primary	Quantity of components, ingredients, or co-product or by-product ordered for a work order. With this fact, you can answer questions such as “What is the quantity ordered for the part list measured in the primary unit of measure?”

Workorder Time Transaction Fact Table

The Workorder Time Transaction fact is a multidimensional table that stores the time transaction of work orders. With this fact group, you can answer questions such as “Do I have enough work hours to complete the scheduled production at a work center?”

This table describes the fact in the Workorder Time Transaction fact table:

Fact Name	Fact Description
Hours Worked	A number that indicates the capacity of a work center on a given day. With this fact, you can answer questions such as “What is the capacity of the work of this work center on a given day?”

Supply Chain Planning Mart

Supply Chain Planning applications identify the right supply of materials to the right place, at the right time, at the lowest cost. The supposed optimization algorithms match product demand with supply to determine the most cost effective method to fulfill the requirements. The plan may recommend transfers of supply from other inventory locations, new purchases from suppliers, and the production of new products to meet the demand. If products must be produced, the planning application may also recommend the appropriate manufacturing sequence. Often, these recommended plans are altered to fit the conditions “on the floor.” These deviations cause the performance-against-plan to deteriorate and in extreme cases, make the plan unusable. To mitigate this problem, PeopleSoft has developed Supply Chain Planning Mart to provide visibility into the compliance of the plan to the actual transfer, purchase, or production. Supply Chain Planning Mart enables you to analyze the deviation from the recommended plan to actual order fulfillment, purchasing, production, inter unit transfers, inventory levels, and capacity utilization.

Supply Chain Planning Mart helps you answer questions such as:

How much has the plan changed from actual execution?
Which products are most out of compliance?
Which business units change the plan the most often?

Production Business Process

Supply Chain Planning Mart supports the Production business process, which is also known as the Plan to Produce business process.

Supply Chain Planning Mart Fact Tables

With Supply Chain Planning Mart PeopleSoft provides the following fact tables:

Sales Forecast
Production Compliance
Inventory Compliance
Production Capacity Compliance
Inventory Transfer Compliance
Purchasing Compliance

Sales Forecast Fact Table

The Sales Forecast fact captures the product quantities associated with shipments against sales orders for each calendar month. With this fact group, you can answer questions such as “What was the actual sales quantity for a particular customer?” and “What was the planned sales quantity for a specific channel and date?”

The grain of the Order Shipment fact table is captured at the Item Sales − Monthly Quantities level.

This table describes the fact in the Order Shipment fact table:

Fact Name	Fact Description
Actual Shipped Quantity	Quantity of product shipped against the sales order line. With this fact, you can answer questions such as “What was the actual shipped quantity?”
Requested Shipped Quantity	Quantity of product originally requested by the customer. With this fact, you can answer questions such as “What was the requested ship quantity?”
Planned Shipped Quantity	Planned quantity of product that was to be shipped against the sales order line. With this fact, you can answer questions such as “What was the planned shipped quantity?”

Production Compliance Fact Table

The Production Compliance fact captures the quantities and costs associated with production against a specific work order. With this fact group, you can answer questions such as “What is the planned production quantity for the work center?” and "What is the actual production quantity for the business unit?”

The grain of the Production fact table is captured at the Work Orders Completed level.

This table describes the fact in the Customer Acquisition fact table:

Fact Name	Fact Description
Actual Production Quantity	Quantity of product produced against the work order. With this fact, you can answer questions such as “What is the actual production quantity at each work center?”
Actual Unit Cost	Activity-based cost of production associated with the work order item. With this fact, you can answer questions such as “What is the actual production unit cost?”
Planned Production Quantity	Planned quantity of a product that was to be produced against the work order. With this fact, you can answer questions such as “What is the planned production quantity?”

Inventory Compliance Fact Table

The Inventory Compliance fact table captures daily inventory quantities. With this fact group, you can answer questions such as “What is the inventory ending quantity?” and “What is the deviation from actual to planned inventory quantities?”

The grain of the fact table is captured at the Inventory − Daily Inventory Acquisition level.

This table describes the facts in the Inventory Compliance fact table:

Fact Name	Fact Description
Actual Ending Quantity	Quantity of a specific item held in a specific inventory location at the end of the day. With this fact, you can answer questions such as “What is the actual ending inventory quantity?”
Planned Ending Quantity	Planned quantity of a specific item that was to be held in a specific inventory location at the end of the day. With this fact, you can answer questions such as “What is the planned inventory quantity?”

Production Capacity Compliance Fact Table

The Production Capacity Compliance fact captures the daily capacity utilization associated with production at a specific work center. With this fact group, you can answer questions such as “What is the planned production capacity for the work center?” and “What is the actual production capacity for the business unit?” The grain of the fact table is captured at the Work Center − Daily Production level.

This table describes the fact in the Production Capacity fact table:

Fact Name	Fact Description
Actual Utilized Capacity	Quantity of product that was actually produced by a particular work center. With this fact, you can answer questions such as “What is the actual utilized capacity in time units?”
Production Capacity	Theoretical maximum quantity of product that can be produced by a particular work center. With this fact, you can answer questions such as “What is the actual production capacity in time units?”
Planned Utilized Capacity	Planned quantity of product that was to be produced by a particular work center. With this fact, you can answer questions such as “What is the planned utilized capacity in time units?”

Inventory Transfer Compliance Fact Table

The Inventory Transfer Compliance fact captures the quantities associated with a transfer order between inventory business units. With this fact group, you can answer questions such as “What are the planned inter unit transfer quantities for the business unit?” and “What are the actual inter unit transfer quantities for the item on a specific date?”

The grain of the fact table is captured at the Transfer Orders - Received level.

This table describes the fact in the Inventory Transfer fact table:

Fact Name	Fact Description
Actual Transfer Quantity	Quantity of an item actually transferred against the transfer order. With this fact, you can answer questions such as “What is the actual inter unit transfer quantity?”
Planned Transfer Quantity	Planned quantity of an item that was to be transferred against the transfer order. With this fact, you can answer questions such as “What is the planned inter unit transfer quantity?”

Purchasing Compliance Fact Table

The Purchasing Compliance fact captures the quantities and costs associated with purchase orders. With this fact group, you can answer questions such as “What is the planned purchasing quantity for the business unit on a particular date?” and “What is the actual purchasing quantity for the supplier for a particular item?”

The grain of the fact table is captured at the Purchase Order Purchasing Transfer fact table:

Fact Name	Fact Description
Actual Purchase Order Line Quantity	Quantity of an item purchased according to the purchase order line. With this fact, you can answer questions such as “What is the actual purchase order quantity for each line item?”
Actual Voucher Quantity	Final quantity received and approved for payment, or voucher. With this fact, you can answer questions such as “What is the actual voucher quantity?”
Actual Voucher Cost	Final cost associated with the purchased item. With this fact, you can answer questions such as “What is the actual voucher cost?”
Purchase Order Purchase Price	Price of an item purchased according to the purchase order line. With this fact, you can answer questions such as “What is the actual purchase order price?”
Planned Purchase Quantity	Planned quantity of an item that was to be purchased. With this fact, you can answer questions such as “What is the planned purchase order quantity?”