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

Data Type

Field Begin

Field Length

Description and Source

Header Information

ESD

Numeric

1

3

DISTRICT-CONFIG.SESD-CODE

County Number

Numeric

4

2

Field positions 1-2: DISTRICT-CONFIG.DISTRICT-CODE

District Number

Numeric

6

3

Field positions 3-5: DISTRICT-CONFIG.DISTRICT-CODE

Type

Alphanumeric

9

1

Type must be "S"

Fund

Alphanumeric

10

1

Fund must be "1"

System ID

Alphanumeric

11

4

Must be "F195"

Data Source

Alphanumeric

15

4

Must be "SAL" for "salary"

Fiscal Year

Numeric

19

9

Calculated from HPMPLN-PLAN.HPMPLN-YEAR

District Name

Alphanumeric

28

20

DISTRICT-CONFIG.DISTRICT-NAME

Filler

N/A

48

33

N/A

Detail Records

ESD

Numeric

1

3

DISTRICT-CONFIG.SESD-CODE

County Number

Numeric

4

2

Field positions 1-2: DISTRICT-CONFIG.DISTRICT-CODE

District Number

Numeric

6

3

Field positions 3-5: DISTRICT-CONFIG.DISTRICT-CODE

Type

Alphanumeric

9

1

Type must be "S"

Fund

Alphanumeric

10

1

Fund must be "1"

Object

Alphanumeric

11

1

Must be "2" for certificated or "3" for classified

Program

Alphanumeric

12

2

HAADSC-DESCS.HAADSC-CODE

Activity

Alphanumeric

14

2

HAADSC-DESCS.HAADSC-CODE

Duty Code

Alphanumeric

16

3

HAADSC-DESCS.HAADSC-CODE

FTE

Numeric

19

6

Calculated

Hours

Numeric

25

9

Calculated from Assignment Number of  Hours (HPMASN-ASSIGNMENTS.HPMASN-NBR-HRS) + Assignment Number of Minutes (HPMASN-ASSIGNMENTS.HPMASN-NBR-MIN) 60.

Certificated High

Numeric

34

7

Highest salary found Calculated FTE for the SPI Assignment Code. The highest salary = Contract Amount (HPMASN-ASSIGNMENTS.HPMASN-CONTRACT-AMT) –  any Add-On Pay Amount (HPMADD-ADD-ONS.HPMADD-PAY-AMOUNT).

Classified High

Numeric

34

7

If calculated by the hourly salary calculation method, the Salary Calculation Method field (HPMASN-ASSIGNMENTS.HPMASN-CALC-METHOD) = "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) –  any Add-On Pay Amount (HPMADD-ADD-ONS.HPMADD-PAY-AMOUNT) Contract Number of Hours (HPMASN-ASSIGNMENTS.HPMASN-NBR-HRS)+Contract Number of Minutes (HPMASN-ASSIGNMENTS.HPMASN-NBR-MIN) 60.

Example: (Contract Amount –Add-On Amount) (Number of Hours + Number of Minutes 60).

Certificated Low

Numeric

41

7

Lowest salary found Calculated FTE for the SPI Assignment Code. The lowest salary = Contract Amount (HPMASN-ASSIGNMENTS.HPMASN-CONTRACT-AMT) – any Add-On Pay Amount (HPMADD-ADD-ONS.HPMADD-PAY-AMOUNT).  

Classified Low

Numeric

41

7

If calculated by the hourly salary calculation method, the Salary Calculation Method field (HPMASN-ASSIGNMENTS.HPMASN-CALC-METHOD) = "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.

Certificated Total

Numeric

48

11

Sum of certificated salaries for the SPI assignment code.

Classified Total

Numeric

48

11

Sum of classified salaries for the SPI assignment code.

Filler

N/A

59

22

N/A