Related Topics   

Education Detail Report

Contents

1 Overview

2 Sample Report

3 How-to

4 Fields

 

4 Fields

Field Name

Path to data field

Table/ field ID

Header

Name Key

Assigned by the system and not updateable. The system assigns a  new name key if an employees name is updated/changed: Human Resources / Profile / + Add or Edit

NAME.NALPHAKEY

Name

Human Resources / Profile / +Add or Edit

NAME-TYPE.FULL-NAME-FML

Address

Human Resources / Profile / +Add or Edit / Mail Addr

various

Check Location Description

Human Resources / Profile / General tab

HPADCL-LOC-CODES.HPADCL-SDESC

Building Description

Human Resources / Profile / Credits tab / + Add or Edit Degrees

HAABLD-BLD-CODES.HAABLD-SDESC

Social Security Number

Human Resources / Profile / + Add or Edit

NAME.FEDERAL-ID-NO

Summary

Highest Degree

Highest degree code: Human Resources / Profile / Credits tab / + Add or Edit Degrees

HAADEG-DEGREE-CODES.HAADEG-STATE-CODE

Degree Year

Human Resources / Profile / Credits tab / + Add or Edit Degrees

HPMPGD-DEGREES.HPMPGD-YR-REC

Academic After

If highest degree code is S, V, D, or blank, then credits = 0. Otherwise, credits are calculated.

Human Resources / Profile / Credits  tab / + Add or Edit Credits

HPMPGC-CREDITS.HPMPGC-CREDITS-EARNED

In-Service After

If highest degree code is S, V, D, or blank, then credits = 0. Otherwise, credits are calculated.

Human Resources / Profile / Credits tab / + Add or Edit Credits

HPMPGC-CREDITS.HPMPGC-CREDITS-EARNED

Excess Credits

Credits are calculated.

Human Resources / Profile / Credits tab / + Add or Edit Credits

HPMPGC-CREDITS.HPMPGC-CREDITS-EARNED

Non-Degree Credits

Credits are calculated.

Human Resources / Profile / Credits tab / + Add or Edit Credits

HPMPGC-CREDITS.HPMPGC-CREDITS-EARNED

District Quarter Credits

Calculated: Human Resources / Profile / Credits tab / + Add or Edit Credits

HPMPGC-CREDITS.HPMPGC-CREDITS-EARNED

District Only Credits

Calculated: Human Resources / Profile / Credits tab / + Add or Edit Credits

HPMPGC-CREDITS.HPMPGC-CREDITS-EARNED

Degrees

Degree

Human Resources / Profile / Credits tab / + Add or Edit Degrees

HPMPGD-DEGREES.HAADEG-CODE

Date

HPMPGD-DEGREES.HPMPGD-REC-DATE

Institution

NAME.LAST-NAME (if NAME.NAME-ID = HPMPGD-DEGREES.HPMPGD-INST-NAME-ID)

Major

HAADSC-DESCS.HAADSC-DESC (if HPMPGD-DEGREES.HAADSC-ID-MAJOR = HAADSC-DESCS.HAADSC-CODE and HAADSC-DESCS.IND = "PROG")

Educational Credit Records

District Credits Type

Calculated from Credits Earned field: Human Resources / Profile / Credits tab / +Add or Edit Credits

HPMPGC-CREDITS.HPMPGC-CREDITS-EARNED

State Credit Type

Quarter Credits

Calculated

All credits are converted to quarter credits by using the formula Credits x Conversion-Factor

Course Number

Human Resources / Profile / Credits tab / + Add or Edit Credits

HPMPGC-CREDITS.HPMPGC-COURSE-NBR

Course Description

HPMPGC-CREDITS.HPMPGC-COURSE-DESC

Date

HPMPGC-CREDITS.HPMPGC-COMP-DATE

Institution

NAME.LAST-NAME (if NAME.NAME-ID = HPMPGC-CREDITS.HPMPGC -INST-NAME-ID)

Recognition Criteria

HPMRCC-CODE

Approved Date

HPMPGC-CREDITS.HPMPGC-APPROVE-DATE  

Page Updated 11/03

Top