Skip to content
Breadcrumbs

USPS Reports Guide –
USPS Reports by Number –
Report 858 Employee Skills Profile

This report displays a summary of employee skills. This includes the employee's number of years of experience, level of proficiency, and when the skill was last used.

Report Criteria

Category Personnel Management
Distribution Agency
Frequency Upon Request
Form 111
Sort Sequence Employee Name
Page Break  
Parameters HNKPM – END DATE
Databases Used HID, H4B, H0B, H7W, HNK
Selection Criteria All employees with a termination date less than the END DATE or null and with skills listed on H4BU1.
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

AS OF HNK.PMEDT
Displays the end date of the request period.
SSN H0B.EMPLOYEENO
Displays the employee's SSN.
EMPLOYEE NAME HID.RPTNAME
Displays the employee's name.
SKILL CODE H4B.SKILLDESC
Displays the employee's skill code. Codes are established on H7W01 at the agency level.
SKILL DESCRPTN H7W.SKILLDESC
Displays the description of the employee's skill.
PROFCNCY H4B.PROFIC
Displays the employee's proficiency in the skill listed as defined by the agency.
YEARS EXPRNCE H4B.NOYRSEXP
Displays the employee's number of years of experience with the listed skill.
LAST YEAR H4B.LSTYRUSED
Displays the last year the employee used this skill.

Sample Report

    REPORT:   858                             UNIFORM STATEWIDE PAYROLL/PERSONNEL SYSTEM                             PAGE:     1    
    AGENCY:   XXX                                   XXXXXXXXXXXXXXXXXXXXXXXXXXXXXX                               RUN DATE: XX/XX/20XX
                                                       EMPLOYEE SKILLS PROFILE                                   RUN TIME: 19:15:59
 
                                                           AS OF 09/30/20XX
                                                         
 SSN               EMPLOYEE                                SKILLS   SKILL                         PROFCNCY      YEARS    LAST      TN
                   NAME                                    CODE     DESCRIPTN                                   EXPRNCE  YEAR      E

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

  XXX-XX-XXXX      XXXXXXXXX, XXXX                         TEST 1   TYPING                        TY1           13.00    20XX
                                                           TEST 2   SPELLING                      PRO           15.00    20XX

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