PeopleSoft Services Procurement 9.1 PeopleBook

Interactive Reports in PeopleSoft Services Procurement

This chapter provides an overview of interactive reports and discusses how to:

Populate the data mart.
Analyze service provider rosters.
Analyze service provider performance.
Analyze service provider length of stay.
Analyze expense life cycles.
Analyze expense variance.
Analyze supplier performance.
Compare supplier rates.
Analyze minority-owned suppliers.

Understanding Interactive Reports

PeopleSoft Services Procurement provides metrics on service providers, expenses, and suppliers to help you manage, measure, and analyze process and cost information across all aspects of the services procurement life cycle. The PeopleSoft system delivers standard analysis pages that cover the most common user requirements.

See Also

Common Elements Used In This PeopleBook

Service Provider Metrics

Service provider metrics provide information on service providers broken out by department, manager, purchase order, and supplier:

The service provider performance includes service provider rating information.

Note. Service provider performance metrics are not broken out by purchase order.
Service provider length of stay includes service provider continuous assignment information.

Expense Metrics

Expense metrics provide information on amounts committed, expended, and forecast on requisitions, work orders, and invoices:

Expense life cycle includes expenses that are incurred throughout the various stages of the expense cycle, including entry, submission, approval, invoiced but not approved, invoiced and approved by supplier, and invoiced and approved.

You can access expense life cycle data broken out by account, department, manager, supplier, and work order. For each dimension, you can also view the data by expense status.
Expense variance includes forecast versus actual expense information.

You can access expense variance data broken out by department, manager, purchase order, and supplier.

Supplier Metrics

Supplier metrics provide information on performance and rate comparisons by supplier and role:

Supplier performance includes requisitions sourced, candidates submitted, requisitions filled, and positions filled.
Supplier rate comparison includes rates that various suppliers charge for the same job role.
Minority-owned suppliers include the number of bids that a minority-owned supplier receives and the number of work orders that are awarded to each of these suppliers.

Minority-owned supplier metrics are analyzed by role.

Populating the Data Mart

You must populate the data mart before accessing the interactive report pages.

Note. If the data mart contains no data, a search page appears when you try to access an interactive reports page, but you can't progress from there.

This section discusses how to populate the data mart.

Page Used to Populate the Data Mart

Page Name	Definition Name	Navigation	Usage
Analysis Datamart	RUN_SPR_DM	Services Procurement, Interactive Reports, Analysis Datamart Engine	Enter parameters that are used to run the PeopleSoft Application Engine that populates the data mart for analysis purposes.

Populating the Data Mart

Access the Analysis Datamart page (Services Procurement, Interactive Reports, Analysis Datamart Engine).

Business Unit

Define the business unit for which you want to retrieve interactive report data.

Run for UserID and Run for all Spro Users

The system retrieves data and populates the data mart with data that is specific to the selected user. Select the Run for all Spro Users check box to retrieve data for all users. The current user appears as the default value in the Run for UserID field.

Duration Date and # of Reporting Months

The system uses the duration date in conjunction with the number of reporting months to determine the time period that is used to retrieve the interactive report data. Enter the number of reporting months to define the number of months before or after the duration date for which you want to retrieve data.

Enter a positive value for number of reporting months to indicate the number of months starting from the duration date that are to be included in the process. Use a negative number to indicate the number of months prior to the duration date that are to be included in the process.

Note. The system does not retrieve dates prior to the entered start date regardless of the entered duration date and number of reporting months.

Use Current Date

Select to define duration date as the current system date. If this check box is selected, the system uses the number of reporting months that are relative to the current system date for each process instance.

Length of Stay

You enter data in the Length of Stay group box to define the parameters that are used to retrieve data for the length-of-stay interactive report pages.

Length of Stay (Months)

Enter the duration that a service provider can stay on assignment in accordance with the laws that govern the organization's labor practices. The system default is six months.

The system uses this value for analysis calculations, including determining the excess duration on the length-of-stay interactive report pages.

As Of Date

Select the date for which the service provider is considered active.

Leave Period (months)

Enter the maximum allowable period between the end of a project and the start of the next project. This is used to determine the service provider's start date.

Process Results

The Process Analysis Datamart Application Engine process (SPR_DATAMART) retrieves data from transaction tables and copies it to a fact table that is used during analysis.

Note. You can define a regular processing schedule by using the Process Scheduler page.

See Also

PeopleTools PeopleBook: PeopleSoft Process Scheduler

Analyzing Service Provider Rosters

You use the service provider roster to analyze total service provider count by department, manager, purchase order, or supplier.

This section discusses how to:

View service provider roster summary information.
View service provider roster details.

Note. This section uses the service provider roster department summary and details as an example. Similar functionality applies to the other dimensions (manager, purchase order, and supplier) and respective detail pages.

Pages Used to Analyze Service Provider Rosters

Page Name	Definition Name	Navigation	Usage
Service Provider Roster (summary)	SPR_CONROS_DASH_PG	Services Procurement, Interactive Reports, Provider Roster	View service provider roster summary graphs and data. Access detail pages.
Service Provider - Department Roster	SPR_CONSROSDR_PG	Click the Department Detail link on the Service Provider Roster page.	View the department details.
Service Provider Roster - Department Details	SPR_CONROS_DASH_PG	Click the Department link on the Service Provider Roster (summary) page for department.	View detailed service provider roster information for a selected department.
Service Provider Roster - Manager Details	SPR_CONROS_DASH_PG	Click the Manager link on the Service Provider Roster (summary) page for Manager.	View detail service provider roster information for a selected manager.
Service Provider Roster - Purchase Order Details	SPR_CONROS_DASH_PG	Click the PO link on the Service Provider Roster (summary) page for Purchase Order.	View detailed service provider roster information for a selected purchase order.
Service Provider Roster - Supplier Details	SPR_CONROS_DASH_PG	Click the Supplier link on the Service Provider Roster (summary) page for Supplier.	View detail service provider roster information for a selected supplier.

Viewing Service Provider Roster Summary Information

Access the Service Provider Roster (summary) page (Services Procurement, Interactive Reports, Provider Roster).

Department, Manager, Purchase Order, and Supplier

Click the link at the top of the page to have the system display the service provider roster graph and data by department, manager, purchase order, or supplier.

Provider Count

Displays for each department the total number of service providers.

Viewing Service Provider Roster Details

Access the Service Provider Roster - Department Details page (click the Department Detail link on the Service Provider Roster page).

The system displays detailed information about the service providers for the selected department.

Click to view the requisition or work order.

Dimensions

Select the Dimensions tab.

In the example above, the system displays the procurement details for the department. Breakout by Manager, PO, or Supplier is also available

Analyzing Service Provider Performance

You use the service provider performance pages to analyze service provider performance by department, manager, or supplier.

Note. You use the service provider performance pages similar to the way that you use the service provider roster pages.

This section discusses how to view service provider performance summary information.

See Also

Analyzing Service Provider Rosters

Pages Used to Analyze Service Provider Performance

Page Name	Definition Name	Navigation	Usage
Service Provider Performance (summary)	SPR_CONPER_DASH_PG	Services Procurement, Interactive Reports, Provider Performance	View service provider performance summary graphs and data. Access detail pages.
Service Provider Performance - Department Details	SPR_CONSPERDR_PG	Click the Department link on the Service Provider Performance (summary) page for department.	View detailed service provider performance information for a selected department.
Service Provider Performance - Manager Details	SPR_CONSPERMR_PG	Click the Manager link on the Service Provider Performance (summary) page for manager.	View detailed service provider performance information for a selected manager.
Service Provider Performance - Supplier Details	SPR_CONSPERVR_PG	Click the Supplier link on the Service Provider Performance (summary) page for supplier.	View detailed service provider performance information for a selected supplier.

Viewing Service Provider Performance Summary Information

Access the Service Provider Performance (summary) page (Services Procurement, Interactive Reports, Provider Performance).

Rating (Avg)

Displays the average approver rating for the total number of service providers for the business unit for each department, manager, or supplier, depending on the dimension that you view.

Analyzing Service Provider Length of Stay

You use the service provider length-of-stay pages to analyze how long service providers have been on assignment by department, manager, purchase order, or supplier.

This section discusses how to:

View service provider length-of-stay summary information.
View service provider length-of-stay details.

Note. This section uses the service provider length-of-stay manager summary and details as an example. Similar functionality applies to the other dimensions (department, purchase order, and supplier) and respective detail pages.

Pages Used to Analyze Service Provider Length of Stay

Page Name	Definition Name	Navigation	Usage
Service Provider Length of Stay (summary)	SPR_CONLOS_DASH_PG	Services Procurement, Interactive Reports, Provider Length of Stay	View service provider length-of-stay summary graphs and data. Access detail pages.
Service Provider Length of Stay - Department Details	SPR_CONSLOSDR_PG	Click the Department link on the Service Provider Length of Stay (summary) page for department.	View detailed service provider length-of-stay information for a selected department.
Service Provider Length of Stay - Manager Details	SPR_CONSLOSMR_PG	Click the Manager link on the Service Provider Length of Stay (summary) page for manager.	View detailed service provider length-of-stay information for a selected manager.
Service Provider Length of Stay - Purchase Order Details	SPR_CONSLOSOR_PG	Click the Purchase Order link on the Service Provider Length of Stay (summary) page for purchase order.	View detail service provider length-of-stay information for a selected purchase order.
Service Provider Length of Stay - Supplier Details	SPR_CONSLOSVR_PG	Click the Supplier link on the Service Provider Length of Stay (summary) page for supplier.	View detailed service provider length-of-stay information for a selected supplier.

Viewing Service Provider Length-of-Stay Summary Information

Access the Service Provider Length of Stay (summary) page (Services Procurement, Interactive Reports, Provider Length of Stay).

Department, Manager, Purchase Order, and Supplier

Click the link at the top of the page to have the system display the service provider length-of-stay graph and data by department, manager, purchase order, or supplier.

Graphing Options

Select the options in the collapsible Graphing Options group box to define the parameters that are used for the graph. You must select parameters of like measurements. For example, you cannot select one measurement based on time and another based on count.

The system displays an error message if you select parameters of different measurement types.

Refresh Graph

Click to display the graph by using the selected graphing options and data points.

Note. Each row of data with a selected check box that appears on the bottom of the page is used as a data point for the graph.

By default, the system graphs the first five selected data rows that appear in the grid. You can select more than five rows, but the information appears smaller on the graph.

Average Excess Duration (days)

Displays the resulting calculation of the average projected end date less the start date for all service providers for the business unit by manager.

A positive value indicates the number of days in excess of the length of stay (in months) that is entered on the Analysis Datamart page, including Saturdays, Sundays, and holidays.

Note. The conversion from length of stay entered in months to excess duration appearing in days is based on using an average 30.4 days for a month.

Average Length of Stay (days)

Displays the resulting calculation of the average start date less end date for all service providers for the business unit by manager.

Viewing Service Provider Length-of-Stay Details

Access the Service Provider Length of Stay - Manager Details page (click the Manager link on the Service Provider Length of Stay (summary) page for manager).

The system displays detailed information about service providers for the manager.

Start Date	Displays the service provider's earliest start date, taking into account the leave period that is defined on the Analysis Datamart page. A service provider's start date may not be his or her earliest start date with the organization. If the service provider has left the organization and returned after a period of time that exceeds the leave period that you define on the Analysis Datamart page, then the service provider's start date is the date of his or her return to the organization.
Projected End Date	Displays the start date plus the length of stay that is defined on the Analysis Datamart page.
End Date	Displays the end date that is associated with the work order ID.
Excess Duration (days)	Displays the resulting calculation of projected end date less the start date for the service provider and work order. A positive value indicates the number of days in excess of the length of stay that is entered on the Analysis Datamart page, including Saturdays, Sundays, and holidays. Note. The conversion from length of stay entered in months to excess duration in days is based on an average 30.4 days for a month.
Combined Length of Stay (days)	Displays the resulting calculation of start date less end date for all service providers for the service provider and work order.

Analyzing Expense Life Cycles

You use the expense life cycle pages to analyze expenses at each stage of the expense cycle and by account, department, manager, supplier, or work order.

This section provides an overview of expense life cycle statuses and discusses how to:

View expense life cycle summary information.
View expense life cycle-by-status summary information.
View expense life cycle details by dimension and status.

Note. This section uses the expense life cycle work order summary and details as an example. Similar functionality applies to the other dimensions (account, department, manager, supplier, and work order) and respective detail pages.

Understanding Expense Life Cycle Statuses

The PeopleSoft system delivers expenses organized in these status categories:

Status	Description
Entered.	Timesheets and progress logs that are entered but not approved. These include timesheets and progress logs that are pending or denied status.
Submitted.	Timesheets and progress logs that are submitted by a service provider, but are not approved.
Approved.	Timesheets and progress logs that are approved but not invoiced.
Invoiced - Not Approved.	Timesheets and progress logs that are invoiced but pending approval. These include invoices that are generated, submitted to manager for approval, submitted to supplier for approval, rejected, rejected by supplier, and in adjusted status.
Invoiced - Supplier Approved.	Timesheets and progress logs that are invoiced and approved by the supplier.
Invoice Approved - Not Processed.	Timesheets and progress logs that are invoiced and approved, but not processed for billing.
Invoice Processed.	Invoices that are approved and processed.

The expense life cycle calculations include expenses from timesheets, progress logs, and invoices. For purposes of analysis, the PeopleSoft system delivers mapping for each expense life cycle status category as defined in these tables.

Timesheets

Timesheet mappings include:

Transaction Translate Value	Transaction Translate Value Description	Expense Life Cycle Status
ADJ	Adjusted	Approved
DEN	Denied	Entered
HLD	Hold	Submitted
PND	Pending	Entered
RAP	Approved	Approved
SUB	Submitted	Submitted

Note. Timesheet entries are mapped for analysis purposes at the detailed level.

Progress Logs

Progress log mappings include:

Transaction Translate Value	Transaction Translate Value Description	Expense Life Cycle Status
APR	Approved	Approved
DEN	Denied	Entered
HLD	Hold	Submitted
PND	Pending	Entered
SUB	Submitted	Submitted

Note. Progress log entries are mapped for analysis purposes at the detailed level.

Invoices

Invoice mappings include:

Invoice Status	Expense Life Cycle Status
Generated.	Invoiced - Not Approved.
Approved.	Invoice Approved - Not Processed.
Processed.	Invoice Processed.
Submitted.	Invoiced - Not Approved.
Rejected.	Invoiced - Not Approved.
Submitted to Supplier.	Invoiced - Not Approved.
Approved by Supplier.	Invoiced - Supplier Approved.
Rejected by Supplier.	Invoiced - Not Approved.
Canceled.	Not applicable.
Adjusted.	Invoiced - Not Approved.

Note. Invoice entries are mapped for analysis purposes at the header level.

Pages Used to Analyze Expense Life Cycles

Page Name	Definition Name	Navigation	Usage
Expense Life Cycle (summary)	SPR_EXPCYC_DASH_PG	Services Procurement, Interactive Reports, Expense Life Cycle	View expense life cycle summary graphs and data. Access detail pages.
Expense Life Cycle - Account by Status	SPR_EXPCYCAM_PG	Click the Account link on the Expense Life Cycle (summary) page for account.	View expenses that are incurred by account and status.
Expense Life Cycle - Account Details	SPR_EXPCYCAR_PG	Click the Status link on the Expense Life Cycle - Account by Status page.	View account details of expenses that are incurred by selected status.
Expense Life Cycle - Department by Status	SPR_EXPCYCDM_PG	Click the Department link on the Expense Life Cycle (summary) page for department.	View expenses that are incurred by department and status.
Expense Life Cycle - Department Details	SPR_EXPCYCDR_PG	Click the Status link on the Expense Life Cycle - Department by Status page.	View department details of expenses that are incurred by selected status.
Expense Life Cycle - Manager by Status	SPR_EXPCYCMM_PG	Click the Manager link on the Expense Life Cycle (summary) page for manager.	View expenses that are incurred by manager and status.
Expense Life Cycle - Manager Details	SPR_EXPCYCMR_PG	Click the Status link on the Expense Life Cycle - Manager by Status page.	View manager details of expenses that are incurred by selected status.
Expense Life Cycle - Supplier by Status	SPR_EXPCYCVM_PG	Click the Supplier link on the Expense Life Cycle (summary) page for supplier.	View expenses that are incurred by supplier and status.
Expense Life Cycle - Supplier Details	SPR_EXPCYCVR_PG	Click the Status link on the Expense Life Cycle - Supplier by Status page.	View supplier details of expenses that are incurred by selected status.
Expense Life Cycle - Work Order by Status	SPR_EXPCYCWM_PG	Click the Work Order link on the Expense Life Cycle (summary) page for work order.	View expenses that are incurred by work order and status.
Expense Life Cycle - Work Order Details	SPR_EXPCYCWR_PG	Click the Status link on the Expense Life Cycle - Work Order by Status page.	View work order details of expenses that are incurred by selected status.

Viewing Expense Life Cycle Summary Information

Access the Expense Life Cycle (summary) page (Services Procurement, Interactive Reports, Expense Life Cycle).

Total Amount

Displays total costs from time, expenses, and progress logs, including those in the various processing stages, by work order.

Viewing Expense Life Cycle-by-Status Summary Information

Access the Expense Life Cycle - Work Order by Status page (click the Work Order link on the Expense Life Cycle (summary) page for work order). You can also access this page for account, department, manager, supplier, and work order.

Total Amount

Displays the total costs from time, expenses, and progress logs for all work orders by status.

Viewing Expense Life Cycle Details by Dimension and Status

Access the Expense Life Cycle (details) page for a dimension and status.

The system displays detailed information about the work order for the selected status.

Analyzing Expense Variance

You use the expense variance pages to analyze expense variance by department, manager, purchase order, or supplier.

This section discusses how to:

View expense variance summary information.
View expense variance details.

Pages Used to Analyze Expense Variance

Page Name	Definition Name	Navigation	Usage
Expense Variance (summary)	SPR_EXPVAR_DASH_PG	Services Procurement, Interactive Reports, Expense Variance	View expense variance summary graphs and data. Modify parameters that are used to create the graphs. Access detail pages.
Expense Variance - Department Details	SPR_EXPVARDR_PG	Click the Department link on the Expense Variance (summary) page for department.	View detailed expense variance information for a selected department.
Expense Variance - Manager Details	SPR_EXPVARMR_PG	Click the Manager link on the Expense Variance (summary) page for manager.	View detailed expense variance information for a selected manager.
Expense Variance - Purchase Order Details	SPR_EXPVAROR_PG	Click the Purchase Order link on the Expense Variance (summary) page for purchase order.	View detailed expense variance information for a selected purchase order.
Expense Variance - Supplier Details	SPR_EXPVARSR_PG	Click the Supplier link on the Expense Variance (summary) page for supplier.	View detailed expense variance information for a selected supplier.

Viewing Expense Variance Summary Information

Access the Expense Variance (summary) page (Services Procurement, Interactive Reports, Expense Variance).

Graphing Options

Select the options in the collapsible Graphing Options group box to define the parameters that are used for the graph. You must select parameters of like measurements. For example, you cannot select one measurement based on time and another based on count.

The system displays an error message if you select parameters that are of different measurement types.

Refresh Graph

Click to display the graph by using the selected graphing options and data points.

Note. Each row of data with a selected check box that appears on the bottom of the page is used as a data point for the graph.

By default, the system graphs the first five selected data rows that appear in the grid. You can select more than five rows, but the information appears smaller on the graph.

Variance Amount

Displays the difference between the total purchase order amount and forecast total.

Viewing Expense Variance Details

Access the Expense Variance page (click the Department link on the Expense Variance (summary) page for department).

Click the Show All Columns button to view data from both the Expense Info (expense information) tab.

Analyzing Supplier Performance

You use the supplier performance pages to analyze supplier performance by supplier or role.

This section discusses how to:

View supplier performance summary information.
View supplier performance details.

Note. This section uses the supplier performance supplier summary and details as an example. Similar functionality applies to the role summary and detail pages.

Pages Used to Analyze Supplier Performance

Page Name	Definition Name	Navigation	Usage
Service Supplier Performance (summary)	SPR_SUP_S_PG	Services Procurement, Interactive Reports, Supplier Performance	View supplier performance summary graphs and data. Modify parameters that are used to create the graphs. Access detail pages.
Service Supplier Performance - Supplier Details	SPR_SUP_SR_PG	Click the Supplier link on the Service Supplier Performance summary page.	View requisition and candidate statistics by supplier.
Service Supplier Performance - Role Details	SPR_SUP_RR_PG	Click the Role link on the Service Supplier Performance summary page for role.	View requisition and candidate statistics for this role.

Viewing Supplier Performance Summary Information

Access the Service Supplier Performance (summary) page (Services Procurement, Interactive Reports, Supplier Performance).

Graphing Options

Select the options in the collapsible Graphing Options group box to define the parameters that are used for the graph. You must select parameters of like measurements. For example, you cannot select one measurement based on amount, such as purchase order amount, and another based on count, such as work orders filled.

The system displays an error message if you select parameters of different measurement types.

Refresh Graph

Click to display the graph by using the selected graphing options and data points.

Note. Each row of data with a selected check box that appears on the bottom of the page is used as a data point for the graph.

By default, the system graphs the first five selected data rows that appear in the grid. You can select more than five rows, but the information appears smaller on the graph.

Work Orders

Select the Work Orders tab.

View work order summary information for each supplier for the business unit.

Supplier Response

Select the Supplier Response tab.

View supplier response time summary information by supplier for the business unit.

Viewing Supplier Performance Details

Access the Service Supplier Performance - Supplier Details page (click the Supplier link on the Service Supplier Performance summary page).

Sourcing Information

View requisition details by project role for a selected supplier.

Work Orders

Select the Work Orders tab.

View work order details by project role for a selected supplier.

Supplier Response

Select the Supplier Response tab.

View supplier response time details by project role for a selected supplier.

Comparing Supplier Rates

You use the supplier rate comparison pages to analyze average rates of suppliers by supplier or role.

Note. You use the supplier rate comparison pages similar to how you use the expense life cycle pages.

This section lists the pages used to compare supplier rates.

See Also

Analyzing Expense Life Cycles

Pages Used to Compare Supplier Rates

Page Name	Definition Name	Navigation	Usage
Supplier Rate Comparison (summary)	SPR_SRTCMP_DASH_PG	Services Procurement, Interactive Reports, Supplier Rate Comparison	View supplier rate comparison summary graphs and data. Access detail pages.
Supplier Rate Comparison - Supplier Details	SPR_SRTCMPSM_PG	Click the Supplier link on the Supplier Comparison summary page for suppliers.	View average rates by role for this supplier.
Supplier Rate Comparison - Role Details	SPR_SRTCMPRM_PG	Click the Role link on the Supplier Comparison summary page for roles.	View average rates by supplier for this role.
Supplier Rate Comparison - Service Providers for Supplier and Role	SPR_SRTCMPSD_PG	Click the Current Project Manager link on the Supplier Rate Comparison - Role Details page.	View service providers by supplier for a selected role.
Supplier Rate Comparison - Service Providers for Role and Supplier	SPR_SRTCMPRD_PG	Click the Supplier link on the Supplier Rate Comparison - Supplier Details page.	View service providers by role for a selected supplier.

Analyzing Minority-Owned Suppliers

The Minority Owned Suppliers page shows a summary of the number of bids that minority-owned suppliers receive and the number of work orders that are awarded to each category for the business unit.

This section discusses how to view minority-owned supplier summary information.

Page Used to Analyze Minority-Owned Suppliers

Page Name	Definition Name	Navigation	Usage
Minority-Owned Suppliers	SPR_MOS_PG	Services Procurement, Interactive Reports, Minority-Owned Suppliers	View the number of bids that are received and the number of work orders that are awarded for each minority-owned supplier.

Viewing Minority-Owned Supplier Summary Information

Access the Minority-Owned Suppliers page (Services Procurement, Interactive Reports, Minority-Owned Suppliers).

Business Unit	Define the business unit for which you want to retrieve interactive report data.
Run for UserID and Run for all Spro Users	The system retrieves data and populates the data mart with data that is specific to the selected user. Select the Run for all Spro Users check box to retrieve data for all users. The current user appears as the default value in the Run for UserID field.
Duration Date and # of Reporting Months	The system uses the duration date in conjunction with the number of reporting months to determine the time period that is used to retrieve the interactive report data. Enter the number of reporting months to define the number of months before or after the duration date for which you want to retrieve data. Enter a positive value for number of reporting months to indicate the number of months starting from the duration date that are to be included in the process. Use a negative number to indicate the number of months prior to the duration date that are to be included in the process. Note. The system does not retrieve dates prior to the entered start date regardless of the entered duration date and number of reporting months.
Use Current Date	Select to define duration date as the current system date. If this check box is selected, the system uses the number of reporting months that are relative to the current system date for each process instance.

Department, Manager, Purchase Order, and Supplier	Click the link at the top of the page to have the system display the service provider roster graph and data by department, manager, purchase order, or supplier.
Provider Count	Displays for each department the total number of service providers.

Department, Manager, Purchase Order, and Supplier	Click the link at the top of the page to have the system display the service provider length-of-stay graph and data by department, manager, purchase order, or supplier.
Graphing Options	Select the options in the collapsible Graphing Options group box to define the parameters that are used for the graph. You must select parameters of like measurements. For example, you cannot select one measurement based on time and another based on count. The system displays an error message if you select parameters of different measurement types.
Refresh Graph	Click to display the graph by using the selected graphing options and data points. Note. Each row of data with a selected check box that appears on the bottom of the page is used as a data point for the graph. By default, the system graphs the first five selected data rows that appear in the grid. You can select more than five rows, but the information appears smaller on the graph.
Average Excess Duration (days)	Displays the resulting calculation of the average projected end date less the start date for all service providers for the business unit by manager. A positive value indicates the number of days in excess of the length of stay (in months) that is entered on the Analysis Datamart page, including Saturdays, Sundays, and holidays. Note. The conversion from length of stay entered in months to excess duration appearing in days is based on using an average 30.4 days for a month.
Average Length of Stay (days)	Displays the resulting calculation of the average start date less end date for all service providers for the business unit by manager.