Related Topics   

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

 

12 Classified Employees Salary Report Fields

The following fields are used in this report:

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

Assignment Occur

The total number of assignments found for the specific SPI Assignment code.

Assignment FTE

The total amount of assignment FTE found for the specific SPI Assignment code.

Number of Hours

Calculated from Assignment Number of Hours (HPMASN-ASSIGNMENTS.HPMASN-NBR-HRS) + Assignment Number of Minutes (HPMASN-ASSIGNMENTS.HPMASN-NBR-MIN) 60 = The total hours found for the specific SPI Assignment code.

Hourly Rate of Pay (High)

If calculated by the hourly salary calculation method, the Salary Calculation Method (HPMASN-ASSIGNMENTS.HPMASN-CALC-METHOD) field = "Hourly" and rate is found in the Entered Pay (HPMASN-ASSIGNMENTS.HPMASN-ENTERED-PAY) field.

Rate is otherwise = Contract Amount (HPMASN-ASSIGNMENTS.HPMASN-CONTRACT-AMT) Contract Number of Hours (HPMASN-ASSIGNMENTS.HPMASN-NBR-HRS) + Contract Number of Minutes (HPMASN-ASSIGNMENTS.HPMASN-NBR-MIN) 60 = highest/lowest hourly rates of pay found for specific SPI Assignment.

Hourly Rate of Pay (Low)

Hourly Rate of Pay (Average)

Total Annual Salary divided by Number of Hours for the specific SPI Assignment code.

Total Annual Salary

Sum of salaries for the specific SPI Assignment code.

Page Updated 8/08

Top