FMX Home
Glenn Hegar  ·  Texas Comptroller of Public Accounts

USPS Reports Guide
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
Options HNKPC
Organization Code, Position Number, Job Class Code
1,3
Organization Code, Job Class Code, Position Number
2,4
Page Break Organization Code
Parameters
Databases Used HØC, 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.
MMonthly
SSemi-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 (HØCUS), 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      
Glenn Hegar
Texas Comptroller of Public Accounts
Questions? Contact statewide.accounting@cpa.texas.gov
Comptroller.Texas.Gov | FMX
FMX Sitemap | Contact FM
Accessibility Policy | Privacy and Security Policy