USPS Reports Guide –
USPS Reports by Number –
Report 514 Active Employees Labor Code Distribution as of MM/DD/CCYY
This report displays all active employees with a primary labor code less than 100%. All secondary labor codes and percentages that have been established on HO2U1 are also displayed.
Report Criteria
| Category | Position Control |
|---|---|
| Distribution | Agency |
| Frequency | Upon Request |
| Form | |
| Sort Sequence | Organization Code; Primary Labor Code Organization Code; Position Number |
| Page Break | Organization Code |
| Parameters | HNKPC – END DATE |
| Databases Used | H0C, HNK, HNH, HO2, HID, H0B |
| Selection Criteria | All employees with an HNH record less than or equal to the END DATE and a PRIMLABPCT less than 100%. |
| Produce Output? | Yes |
| Request Screen | HNKPC |
| Posting Report? | No |
| Additional Notes | If the Labor Codes assigned to an employee do not equal 100%, the system will generate the following error: *** EMPLOYEE'S LABOR DISTRIBUTION DOES NOT TOTAL 100%. CORRECT ON HO2U1. *** |
Report Headings
- AS OF HNK.PCEDT
- Displays the end date of the request period.
- ORG CODE HNH.ORGCODE
- Displays the employee's organization code.
- NAME HID.RPTNAME
- Displays the employee's organization name.
- EMPLOYEE SSN HNH.EMPLOYEENO
- Displays the employee's SSN.
- POS # HO2.POSITION
- Displays the employee's position number.
- ACT DT HNH.HISTORYDT
- Displays the effective date of the assignment.
- JOB CLS / FUNC HNH.JOBCLASS
- Displays the employee's job class code and agency defined function job class (if applicable).
- JOB TITLE H7O.JOBTITLE and SCN.FCTITLE
- Displays the job class title from H7OU1 and (if applicable) the functional job class title from HMLU1.
- TB/GP-ST HNH.AGYCOMMENT
- Displays the pay table of the employee's pay group; the pay group of the employee's job class code; and the employee's pay step (if applicable).
- SALARY HNH.HSALARY, HNMH.HHRLRATE
- Displays the employee's monthly salary or hourly rate.
- PRIMARY LABOR HNH.PRIMLABCD
- Displays the employee's primary labor code.
- PCT HO2.LABPCT01
- Displays the employee's secondary and subsequent labor percent.
- SECONDARY LABOR
- Section includes the remaining percentages and labor codes.
- LAB HO2.LABCDE01
- Displays the employee's secondary and subsequent labor codes.
- PCT HO2.LABPCT01
- Displays the employee's secondary and subsequent labor percentages.
- TOTAL FOR ORG DERIVED
- Displays the total monthly salary.
- TOTAL RECORDS DERIVED
- Displays the total number of assignments with multiple labor codes by organization code.
Sample Report
REPORT: 514 UNIFORM STATEWIDE PAYROLL/PERSONNEL SYSTEM PAGE: 2
AGENCY: xxx xx xxxxx xx xxxxxxxx xxxxxxxxx RUN DATE: XX/XX/20XX
ACTIVE EMPLOYEES LABOR CODE DISTRIBUTION RUN TIME: 00:05:13
AS OF 08/31/20XX
ORG CODE: 00000303805 xxxxxxxx xxxxx-xxxxxxxxxxx x xxxxxxxxxxx
NAME POS # JOB CLS/FUNC TB/GRP-ST SALARY PRIMARY ----------------- SECONDARY LABOR -----------------
SSN ACT DT JOB TITLE LABOR PCT LAB PCT LAB PCT LAB PCT LAB PCT
xxxxxx, xxxxxxx x 20000009 1554 1B 13- 4917.70 P05805 57.6 P05002 8.0 P05800 34.4 0.0 0.0
XXX-XX-XXXX 09/01/20XX xxxxx xxxxx xxxxx x
xxxxxxx, xxxxxx 00000016 1016 16 09- 3292.64 P05805 56.3 P05000 10.0 P05800 33.7 0.0 0.0
XXX-XX-XXXX 09/01/20XX xxxxxxxxxx xxxxxxx
xxxxxxx, xxxxxx x 00000301 A046 03 00-02 5833.33 P05805 31.3 P05000 30.0 P05002 20.0 P05800 18.7 0.0
XXX-XX-XXXX 09/01/20XX xxxxxxxxx xxxxxxxx
xxxxxxxxxxx, xxxx xx 00000222 0162 1B 11- 4637.06 P05805 37.6 P05000 30.0 P05002 10.0 P05800 22.4 0.0
XXX-XX-XXXX 09/01/20XX xxxxxxxxx xxxx II
TOTAL RECORDS = 4