USPS Reports Guide –
USPS Reports by Number –
Report 508 Active Positions
This report displays ALL active positions as of any given date. The person filling the position, the budget and actual salary information, and other miscellaneous position details are also included.
This report is a simplified version of Report 165, and replaces the USPS query known as the "165 LITE".
Report Criteria
Category | Position Control | ||||||
---|---|---|---|---|---|---|---|
Distribution | Agency | ||||||
Frequency | Monthly; Upon Request | ||||||
Form | |||||||
Sort Sequence |
|
||||||
Page Break | Organization Code | ||||||
Parameters |
|
||||||
Databases Used | H0C, HNK, HNP, HNO, HID, HNH, H7O, HO9 | ||||||
Selection Criteria | Options 1 and 2: All positions with an effective date less than or equal to the END DATE and an inactive date greater than or equal to the END DATE or null. Options 3 and 4: All positions with an effective date less than or equal to the last day of the CURR MONTH and an inactive date greater than or equal to the last day of the CURR MONTH or null. |
||||||
Produce Output? | Yes | ||||||
Request Screen | HNKPC – Select option 1 or 2; HPRPT – Set up to run automatically with Month-End Reports (enter option 3 or 4 instead of the standard x). | ||||||
Posting Report? | No | ||||||
Additional Notes | Call your USPS representative when ready to run Month-End Reports. |
Report Headings
- ORGANIZATION CODE HNP.ORGCODE
- Displays the organization code of the positions listed.
- AS OF HNK.PCEDT OR DERIVED FROM HNK.FLAG69
- Displays the end date of the request period.
- NAME/VACANT HID.RPTNAME/DERIVED FROM HNP
- Displays the name of the employee currently filling the position. If the position is vacant, ** VACANT will appear.
- SSN HNH.EMPLOYEENO
- Displays the employee's SSN. If the position is vacant, this field will be blank.
- POS NO HNP.POSITION
- Displays the employee's position number.
- PRIMARY PCA/IND HNP.PRIMLABCD
- Displays the labor code of the position.
- FLSA HNP.FLSASTAT
- Displays the FLSA indicator for the position.
- HAZ HMP.HAZDTYIND
- This field will display the employee's hazardous duty indicator, (N, Y, 8 or 9). If employee doesn't receive hazardous duty, leave blank.
- EEO HNP.JCEEOCD
- Displays the EEO code for the position.
- PAY FRQ HNP.FREQOFPAY
- Displays the pay frequency of the position.
M Monthly S Semi-Monthly - BUDGETED JOB CLS HNP.JOBCLASS
- Displays the budgeted job class code for the position.
- BUDGETED FUNC CLS HNP.BUDFUNCLS
- Displays the budgeted functional job class code of the position, if applicable.
- BUDGETED TB/GR/ST H7O.JCPAYTABLTY/HNP.PAYGROUP/HNP.PAYSTEP
- Displays the budgeted pay table, group, and step, if applicable, for the position.
- BUDGETED FTE HNP.PCAUTFTE
- Displays the budgeted FTE for the position.
- BUDGETED SAL HNP.SALARYBGT, HNP.HRLYRTBGT
- Displays the budgeted salary or hourly rate of the position.
- ACTUAL JOB CLS HNH.JOBCLASS
- Displays the actual job class code for the position.
- ACTUAL FUNC CLS HNH.ACTFUNCLS
- Displays the actual functional job class code of the position, if applicable.
- ACTUAL TB/GR/ST H7O.JCPAYTABLTY/HNH.POSPAYGRP/HNH.ACTUALSTEP
- Displays the actual pay table, group, and step, if applicable, for the position.
- ACTUAL FTE HNH.ASSIGNFTE
- Displays the actual FTE for the position.
- ACTUAL SAL HNH.HSALARY, HNH.HHRLYRATE
- Displays the actual salary or hourly rate assigned to the employee.
Summary: Totals by Organization/Division/Agency
- BUDGETED MO SAL DERIVED FROM HNP.SALARYBGT
- Displays the total amount of budgeted monthly salaries.
- ACTUAL MO SAL DERIVED FROM HNH.HSALARY
- Displays the total amount of actual monthly salaries.
- VACANT BUD SAL DERIVED FROM HNP
- Displays the total budgeted amount of vacant positions.
- AUTHORIZED FTE DERIVED FROM HNP.PCAUTFTE
- Displays the total number of authorized FTEs.
- ACTUAL FTE DERIVED FROM HNH.ASSIGNFTE
- Displays the total amount of actual FTEs.
- OVERFILL DERIVED FROM HNP
- Displays the total number of positions that are overfilled.
- UNDERFILL DERIVED FROM HNP
- Displays the total number of positions that are underfilled.
- # FILLED POSITIONS DERIVED FROM HNP
- Displays the total number of filled positions.
- # VACANT POSITIONS DERIVED FROM HNP
- Displays the total number of vacant positions.
Note: If the employee term date or the position inactive date is equal to the END DATE (on HNKPC) or CURR MONTH (H0CUS), the position will be displayed on the report as vacant.
Sample Report
REPORT: 508 UNIFORM STATEWIDE PAYROLL/PERSONNEL SYSTEM PAGE: 1 AGENCY: XXX XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX RUN DATE: XX/XX/20XX 10010010010 ACTIVE POSITIONS RUN TIME: 22:59:45 AS OF 08/31/20XX H L E F -------------BUDGETED-------------- --------------ACTUAL--------------- PRIMARY A S E R JOB FUNC JOB FUNC NAME/VACANT DATE SSN POS NO PCA/IND Z A O Q CLS CLS TB/GR/ST FTE SAL CLS CLS TB/GR/ST FTE SAL ------------------------------------------------------------------------------------------------------------------------------------ XXXXX, XXXXXXX XXX-XX-XXXX 01110001 P55555 N 2 A M E052 03/00/09 1.000 9583.33 E052 03/00/09 1.000 9583.33 XXXXXX, XXXXX XXX-XX-XXXX 01010225 P55555 N 2 P M 1602 B/15/ 1.000 5833.33 1602 1B/15/ 1.000 5833.33 XXXX, XXXXXXXX XXX-XX-XXXX 01258010 P55555 N 2 A M 1624 B/21/ 1.000 8333.33 1624 1B/21/ 1.000 8333.33 XXXXXX, XXXX XXX-XX-XXXX 01123105 P55555 N 1 P M 0162 B/11/ 1.000 3452.02 0162 1B/11/ 1.000 3452.02 XXXXXXXXX, XXXXXX XXX-XX-XXXX 78910603 P55555 N 2 A M 1624 B/21/ 1.000 8333.33 1624 1B/21/ 1.000 8333.33 XXXX, XXXXXXX XXX-XX-XXXX 01456005 P55555 N 1 Q M 0156 A/15/ 1.000 2436.00 0156 1A/15/ 1.000 2436.00 XXXXXX, XXXXXXXXX XXX-XX-XXXX 01025800 P55555 N 2 A M 1623 B/20/ 1.000 7083.33 1623 1B/20/ 1.000 7083.33 **VACANT 09/30/03 01147001 P55555 N 2 P M 1602 B/15/ 1.000 5000.00 XXXXXXXX, XXXXX XXX-XX-XXXX 01369004 P55555 N 2 A M BD25 02/01/01 .500 0.01 BD25 02/01/01 .500 0.01 XXXXXXX, XXXXXXXX XXX-XX-XXXX 01596005 P55555 N 2 A M BD25 02/01/01 .500 0.01 BD25 02/01/01 .500 0.01 XXXXXXX, XXXX XXX XXX-XX-XXXX 01013570 P55555 N 2 A M BD25 02/01/01 .500 0.01 BD25 02/01/01 .500 0.01 XXXXXXXXX, XXX XXX-XX-XXXX 01017963 P55555 N 0 Q M 0156 A/15/ 1.000 2436.00 0156 1A/15/ 1.000 2436.00 ------------------------------------------------------------------------------------------------------------------------------------- ORG 01010101010 MAIN STAFF SUMMARY AUTHORIZED ACTUAL # FILLED # VACANT BUDGETED MO SAL ACTUAL MO SAL VACANT BUD SAL FTE FTE OVERFILL UNDERFILL POSITIONS POSITIONS 52,490.70 47,490.70 5000.00 10.500 9.500 0 0 11 1