This report lists all defined pay tables. It displays the group, step, salary, and the effective and inactive dates of each pay rate. This report is automatically run during the pay table rollover at FYE.
Report Criteria
| Category |
Position Control |
| Distribution |
Agency |
| Frequency |
Annually at Fiscal Year-End; Upon Request |
| Form |
|
| Sort Sequence |
Table Type, Pay Group, Pay Step, Effective Date |
| Page Break |
Table Type |
| Parameters |
HNKPC – START DATE, END DATE |
| Databases Used |
H7S, HMQ, HNK |
| Selection Criteria |
All pay table records with an effective date between the HNK dates and an inactive date greater than START DATE, or null. |
| Produce Output? |
Yes |
| Request Screen |
HNKPC – 3 options – Select one:
| 1 | Classified Pay Tables only |
|---|
| 2 | Agency Pay Tables only |
|---|
| 3 | Both Classified and Agency Pay Tables |
|---|
|
| Posting Report? |
No |
| Additional Notes |
|
Report Headings
- FROM/TO HNK.PCSTDT/HNK.PCEDT
- Displays the beginning and ending dates of the requested period.
- TABLE TYPE H7S.STPAYTABLT
- Valid table types effective 9/1/01 thru 8/31/03.
| 1A | Classified Table A |
|---|
| 1B | Classified Table B |
|---|
| 1C | Classified Table C |
|---|
| 2A | Classified Pay Table A Reflecting the Increase |
|---|
| 2B | Classified Pay Table B Reflecting the Increase |
|---|
| 2C | Classified Pay Table C Reflecting the Increase |
|---|
| 02 | Unclassified Pay Table |
|---|
| 03 | Exempt Pay Table |
|---|
| B1 | Classified Pay Table B Not Refelcting the Increase – Agency Defined Steps |
|---|
| B2 | Classified Pay Table B Refelcting the Increase – Agency Defined Steps |
|---|
Valid table types effective 9/1/03
| 1A | Classified Table A |
|---|
| 1B | Classified Table B |
|---|
| 1C | Classified Table C |
|---|
| 02 | Unclassified Salary Schedule |
|---|
| 03 | Exempt Salary Schedule |
|---|
- PAY GROUP H7S.STGRADE
- Displays the pay group. Exempt pay groups are 00.
- PAY STEP H7S.STSTEP
- Displays the pay step within the pay group range.
- MONTHLY SALARY H7S.MONTHLYSA
- Displays the maximum monthly amount paid to the group/step based on a 2,080-hour work year.
- ANNUAL SALARY H7S.PSALARYMAX
- Displays the maximum annual amount paid to the group/step based on a 2,080-hour work year.
- HOURLY RATE H7S.PRATEMAX
- Displays the maximum hourly amount paid to the group/step based on a 2,080-hour work year.
- EFFECTIVE DATE H7S.HISTORYDT
- Displays the date the pay group/pay step can be used.
- INACTIVE DATE H7S.NACTDT
- Displays the date the pay group/pay step can no longer be used.
Sample Report
REPORT: 534 UNIFORM STATEWIDE PAYROLL/PERSONNEL SYSTEM PAGE: 1
AGENCY: XXX XXXX XXXXX XXXXXXXXXXX XXXXX RUN DATE: XX/XX/20XX
SALARY TABLE LISTING RUN TIME: 2:00:00
FROM 09/01/20XX TO 08/31/20XX
TABLE TYPE: 1A
MIN MAX MIN MAX MIN MAX
PAY MONTH MONTH ANNUAL ANNUAL HOURLY HOURLY EFFECTIVE INACTIVE
GROUP SALARY SALARY SALARY SALARY RATE RATE DATE DATE
03 1,404.16 2,036.08 16,850.00 24,433.00 8.10096 11.74663 09/01/20XX 06/01/20XX
04 1,474.41 2,137.83 17,693.00 25,654.00 8.50625 12.33365 09/01/20XX
05 1,548.08 2,244.75 18,577.00 26,937.00 8.93125 12.95048 09/01/20XX
06 1,625.50 2,357.00 19,506.00 28,284.00 9.37788 13.59808 09/01/20XX
07 1,706.75 2,474.83 20,481.00 29,698.00 9.84663 14.27788 09/01/20XX
08 1,792.08 2,598.58 21,505.00 31,183.00 10.33894 14.99183 09/01/20XX
09 1,881.75 2,728.50 22,581.00 32,742.00 10.85625 15.74135 09/01/20XX
10 1,975.83 2,864.91 23,710.00 34,379.00 11.39904 16.52837 09/01/20XX
11 2,094.33 3,246.25 25,132.00 38,955.00 12.08269 18.72837 09/01/20XX
12 2,220.00 3,441.00 26,640.00 41,292.00 12.80769 19.85192 09/01/20XX
13 2,353.25 3,647.50 28,239.00 43,770.00 13.57644 21.04327 09/01/20XX