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 Field Undefined C CEU's O Other Q Quarter Hours S Semester Hours U Unknown
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