Delivered KPIs

Details about the delivered KPIs are provided in the HCKPIS.PDF file that is located in the documentation. This file provides information about each of the delivered predefined KPIs through summary and detail tables. Use these tables to better understand Healthcare Scorecard calculations. You can also use the information in these tables as a basis for altering the scorecard to update KPIs and target rules.

All KPIs are stored in the enterprise data warehouse. PeopleSoft arranges this information by line of business (HR, Financials, Supply Chain, or CRM). This logical grouping is used for convenience and does not represent four separate warehouses. The Healthcare Scorecard spans all of the areas that are needed to provide a complete representation of the health of the organization.

Predefined KPIs are the basis for analysis within Healthcare Scorecard. You must understand the definition detail to understand what is being calculated in your scorecard results.

The delivered KPIs use the following sources: external data, financial data, human resources data, and supply chain data. The system also includes manual KPIs.

This topic discusses:

External data
Manual KPIs

External Data

The KPIs that are listed in this topic use data from external systems, such as Eclypsis TSI or McKesson Trendstar. You can configure the system to use data from such a system by creating an extract, transform and load (ETL) map to port the data from your system to the data warehouse tables that are used by these KPIs.

Note: You must configure your own ETL map for mapping this data into the data warehouse tables shown subsequently. For detailed information about how to create and use ETL maps, refer to the IBM WebSphere documentation.

The tables that you must populate are HC_EXT1_TABLE and HC_EXT2_TABLE.

HC_EXT1_TABLE

This table shows the structure of HC_EXT1_TABLE

Field	Description	Field Type	Field Length
BUSINESS_UNIT	Business unit.	Character	5
EFFDT	Effective date.	Date	10
EFF_STATUS	Status as of effective date.	Character	1
PATIENT_DAYS	Patient days.	Number	9.2
MAINTAINED_BED	Maintained beds.	Number	7

HC_EXT2_TABLE

This table shows the structure of HC_EXT2_TABLE

Field	Description	Field Type	Field Length
BUSINESS_UNIT	Business unit.	Character	5
EFFDT	Effective date.	Date	10
EFF_STATUS	Status as of effective date.	Character	1
CASE_MIX_INDEX	Case mix index.	Number	7.2
IP_ADMISSION	Inpatient admissions.	Number	7
IP_DISCHARGE	Inpatient discharges.	Number	7
IP_SURG_CASE	Inpatient surgical cases.	Number	7
OP_EMRG_VISIT	Outpatient emergency visits.	Number	7
OP_ENCOUNTER	Outpatient encounters.	Number	7
OP_SURG_CASE	Outpatient surgical cases.	Number	7

See also the PeopleSoft Performance Management Fundamentals documentation and the IBM Websphere documentation.

Manual KPIs

In addition to calculated KPIs, the system provides manual KPIs with the Healthcare Scorecard. Manual KPIs do not use data that is derived from PeopleSoft EPM tables to determine their values; the actual data element is stored in the data warehouse. Manual KPIs are loaded into the warehouse using the Scorecard Manual KPI page. Both calculated and manual KPIs use target rules to determine their assessments, and the system can calculate and assess quarter-to-date and year-to-date totals, depending on the options that you establish.