This report displays all employees as of the request date by pay table and salary group, SSN, name, position title, job class, position number, classification date, salary and step. The report also displays a total by salary group, pay table, division, and agency.
Report Criteria
Category |
Personnel Management |
Distribution |
Agency |
Frequency |
Upon Request |
Form |
111 |
Sort Sequence |
Options |
H0XCR Sort |
First Level - Organization Code, Pay Table, Pay Group, Employee
Name, Employee Number |
922 |
|
Page Break |
First Level - Organization Code, Pay Table, Pay Group |
Parameters |
HNKPM – END DATE |
Databases Used |
H0C, HNK, H7O, HNP, H0B, HID, HNH, HML |
Selection Criteria |
All Active and on-leave employees as of the HNK date. |
Produce Output? |
Yes |
Request Screen |
HSRPT |
Posting Report? |
No |
Additional Notes |
|
Report Headings
- DIVISION HNH.ORGCODE
- Displays the first three positions of the employee's organization code.
- EMPLOYEE SALARY GROUP AS OF HNK.PCEDT
- Displays the end date used to run this report.
- TABLE HNH.SALTBLTYP
- Displays the employee's pay table as defined by their job class code.
- GROUP HNH.ACTPAYGRP
- Displays the employee's pay group.
- EMPLOYEE SSN HNH.EMPLOYEENO
- Displays the employee's SSN.
- EMPLOYEE NAME HID.RPTNAME
- Displays the employee's name.
- TITLE HML.FCTITLE.HNP.JOBDESC
- Displays the functional job class title that corresponds to the employee's position. If a functional job class was not assigned, the job class title will display.
- JOB CLASS HNH.JOBCLASS
- Displays the employee's job class code.
- POSITION HNP.POSITION
- Displays the position number.
- CLASS DATE HNH.HPROMDATE
- Displays the date of the employee's last promotion, merit increase, or demotion.
If the employee is not classified or has not received one of the above salary
actions, this date will be the employee's hire date. This classification date
is used to track the twelve months lapse required for awarding merit increases.
Effective 09/01/1999, this twelve month lapse will be replaced by a six month
lapse.
- SALARY/HOURLY HNH.HSALARY, HNH.HHRLYRATE
- Displays the employee's current or hourly salary.
- STEP HNH.ACTUALSTEP
- Displays the employee's pay step, if applicable.
- SALARY GROUP EMPLOYEE COUNT Derived
- Displays the number of employees in a salary group.
- PAY TABLE EMPLOYEE COUNT Derived
- Displays the number of employees in a pay group.
- DIVISION EMPLOYEE COUNT Derived
- Displays the number of employees in a division.
- AGENCY EMPLOYEE COUNT Derived
- Displays the number of employees in the agency.
Sample Report
REPORT: 166
DIVISION: 000 UNIFORM STATEWIDE PAYROLL/PERSONNEL SYSTEM PAGE: 1
AGENCY: XXX XXXX XXXXX XXXXXXXXXXX XXXXX RUN DATE: XX/XX/20XX
EMPLOYEE BY JOB CLASSIFICATION RUN TIME: 2:00:00
EMPLOYEE SALARY GROUP AS OF 09/01/05
TABLE 00 GROUP 00
JOB SALARY/
EMPLOYEE SSN EMPLOYEE NAME TITLE CLASS POSITION CLASS DATE HOURLY STEP
XXX-XX-XXXX XXXX, XXXXXXXX CARTOON ARTIST A123 01010101 02/13/20XX 30.00 03
XXX-XX-XXXX XXXXXXXXX, XXX BOARD MEMBER C456 02020202 06/15/20XX 4,992.00 01
SALARY GROUP EMPLOYEE COUNT 2
PAY TABLE EMPLOYEE COUNT 2