SPI Salary Exhibit Reports

Contents

1 Overview

2 Data Validation

3 Exception Report

4 Certificated Employees Rpt

5 Classified Employees Rpt

6 Benefits Report

7 Summary Report

8 How-to

9 User Tips

10 Exception Rpt Fields

11 Certificated Employees Rpt Fields

12 Classified Employees Rpt Fields

13 Benefits Report Fields

14 Summary Rpt Fields

15 F-195 Data Extract File Fields

Field Name

Path to data field

Table/ field ID

Fiscal Year

Calculated from Year field: Human Resources / Salary Negotiations / Position Maintenance

HPMPLN-PLAN.HPMPLN-YEAR

Program Code

Human Resources / Salary Negotiations / Position Maintenance

HAADSC-DESCS.HAADSC-CODE

Program Description

HAADSC-DESCS.HAADSC-DESC

SPI Assignment

Program, activity, and duty codes from HAADSC-DESCS.HAADSC-CODE

Title of Position

Description of duty codes from HAADSC-DESCS.HAADSC-DESC

Calculated Data

Field Name

How Calculated

Benefits

Calculated sum of all benefit dollars: Benefit Amount (HPMPLR-RESULTS.HPMPLR-AMOUNT) where the Type Indicator (HPMPLR-RESULTS.HPMPLR-TYPE-IND) = "F" for "benefit" = The total benefit dollars found for the specific SPI Assignment code.