Skip to content

USPS Reports Guide
USPS Reports by Number

Report 860 Employee Training Profile

This report provides a list of employees and the courses they completed as well as their grades and credits earned.

Report Criteria

Category Personnel Management
Distribution Agency
Frequency Upon Request
Form 111
Sort Sequence First Level – Organization Code, Division, Employee Name, Employee Number
Page Break  
Parameters HNKPM – END DATE
Databases Used HID, H5O, H0B, HGO, HMP, HNP, HNK
Selection Criteria All employees not terminated as of the END DATE and that have a course record on H5001.
Produce Output? Yes
Request Screen HSRPT
Posting Report? No
Additional Notes A set up on H0XCR is not required for this report to run.

Report Headings

DIVISION HNP.ORGCODE
Displays the first three positions of the employee's organization code.
AS OF HNK.PMEDT
Displays the end date of the requested period.
EMPLOYEE SSN H0B.EMPLOYEENO
Displays the employee's SSN.
EMPLOYEE NAME HID.RPTNAME
Displays the employee's name.
COURSE ID H5O.COURSE
Displays the identification number of the employee's course.
COURSE NAME HGO.PCRSNA
Displays the name of the employee's course.
GRADE POINTS H5O.PGRADEPTS
Displays the numeric grade achieved by the employee.
CMPLTED HRS H5O.PCPLHRS
Displays the total credit hours earned by the employee for the course.
CREDITS EARNED H5O.PCREARNED
Displays the total course credits earned by the employee.
CREDIT TYPE HGO.PCRTY
Displays the credit type.
Blank FieldUndefined
CCEU's
OOther
QQuarter Hours
SSemester Hours
UUnknown

Sample Report

    REPORT:   860                             UNIFORM STATEWIDE PAYROLL/PERSONNEL SYSTEM                             PAGE:     1    
    AGENCY:   XXX                                   XXXXXXXXXXXXXXXXXXXXXXXXXXXXXX                               RUN DATE: XX/XX/20XX
                                                      EMPLOYEE TRAINING PROFILE                                  RUN TIME: 19:15:59
 DIVISION: 100
                                                           AS OF 09/30/20XX
                                                         
 EMPLOYEE          EMPLOYEE                        COURSE  COURSE                          GRADE   CMPLTED  CREDITS  CREDIT          
 SSN               NAME                            ID      NAME                            POINTS  HRS      EARNED   TYPE             

  XXX-XX-XXXX      XXXXXX, XXXXX X                 100     TEST 1   ACCOUNTING              CPA    10.00     2003       

  XXX-XX-XXXX      XXXXXXXXX, XXXX                 105     TEST 1   TYPING                  TY1    13.00     2003
                                                   110     TEST 2   SPELLING                PRO    15.00     2003

  XXX-XX-XXXX      XXXX, XXXXX X                   210     TEST 1   CPR                     EXP     4.00     2003