FMX Home
Glenn Hegar  ·  Texas Comptroller of Public Accounts

USPS Reports Guide
Report 525 Functional Job Class Listing

This report displays the job class codes that have an agency defined functional job class code associated with it. It automatically runs during the job class code rollover at FYE, but can also be requested as needed throughout the life cycle of a functional job class.

Functional job classes are an optional feature that an agency may use to further define job classes. HMLU1 is used to establish and maintain these relationships.

Report Criteria

Category Position Control
Distribution Agency
Frequency Annually at Fiscal Year-End; Upon Request
Form  
Sort Sequence
Options HNKPC
Position Type, Job Class Code, Functional Job Class Code
1
Position Type, Functional Job Class Code, Job Class Code
2
Page Break Position Type
Parameters HNKPC – START DATE, END DATE
Databases Used HML, HØC, HNK, HMQ, H1T, H7O
Selection Criteria All HMLU1 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 – Select 1 or 2.
Posting Report? No
Additional Notes This report automatically generates (with Sort 2) when the job class rollovers requested on HMQU1 and only provides a report when functional job classes are found. When an agency requests this report on HNKPC and no active functional job classes are found, the report will generate the report heading and message indicating “No Active Functional Job Classes Found”.

Report Headings

FROM/TO HNK.PCSTDT/HNK.PCEDT
Displays the beginning and ending dates of the requested period.
POSITION TYPE HML.POSTYPE
Displays the position type of the job class(es) listed:
  • Classified
  • Exempt
  • Unclassified
JOB CLASS HML.JOBCLASS
Displays the job class code for each functional job class code listed.
FUNC CLS HML.FUNCLASS
Displays the user-defined code used to further break down a job class into agency-specific job classes and titles.
JOB CLASS TITLE H7O.JCTITLE
Displays the state job title of the state job class code listed.
FUNCTIONAL TITLE HML.FCTITLE
Displays the job title of the functional job class code listed.
TABLE H7O.JCPAYTABTY
Displays the pay table of the job class listed.
A Classified Table A
B Classified Table B
C Classified Table C
02Unclassified
03Exempt
GRP/STEP H7O.JCPAYGRADE/JCBEGINSTE
Displays the pay group of the job class code, and the pay step of the job class code listed, when applicable.
EEO CAT H7O.JCEEOCODE
Displays the EEO code of the job class code listed.
FUNC EEO HML.FCEEOCODE
Displays the EEO code of the functional job class code listed.
FLSA STAT H7O.JCFLSASTAT
Displays the FLSA indicator of the job class code listed.
FUNC FLSA ML.FCFLSASTAT
Displays the FLSA indicator of the functional job class code listed.
JC TYPE H7O.JCBENCHM
Displays the job class type of the job class code listed.
MSR DERIVED FROM HMLU1
Displays the code used to identify managers from regular staff. Used by report 509 – Management to Staff Ratio Report required by the State Auditor's Office. The value displayed in this column indicates which values are allowed for the functional job class. If no value was entered on HMLU1, the column will display “All” indication all MSR values allowed for this functional job class.
HAgency Head
MManagement
SSupervisor
NStaff
EFFECTIVE DATE HML.HISTORYDT
Displays the date the functional job class code can be used.
INACTIVE DATE HML.FCINACTDT
Displays the date the functional job class code can no longer be used.

Sample Report

   REPORT:   525                             UNIFORM STATEWIDE PAYROLL/PERSONNEL SYSTEM                          PAGE:     1     
   AGENCY:   xxx                                     xxxxx xx xxxxxxxxxxxxxxx                                RUN DATE: XX/XX/20XX
                                                    FUNCTIONAL JOB CLASS LISTING                             RUN TIME: 12:53:08  
                                                   FROM 09/01/20XX TO 08/31/20XX                                                 

UNCLASSIFIED                                                                                          
                                                                                                      
JOB CLASS      JOB CLASS TITLE                        TABLE  GRP/STP  EEO CAT   FLSA STAT      JC TYPE     EFFECTIVE   INACTIVE  
  FUNC CLS     FUNCTIONAL TITLE                                       FUNC EEO  FUNC FLSA        MSR         DATE        DATE    
                                                                                                      
 0272         CHIEF COMMITTEE CLERK                     02    00/00     O       PROF-EXEMP   MEMBER EMPLO  09/01/20XX            
   6208       CHIEF COMMITTEE CLERK                                     O       ADMIN-EXEM       ALL       09/01/20XX            
 0051         CLERK I                                   02    02/00     C       ADMIN-EXEM   NON SPECIFIC  09/01/20XX            
   6209       CLERK I                                                   O       ADMIN-EXEM       H         09/01/20XX            
 0055         CLERK II                                  02    06/00     C       ADMIN-EXEM   NON SPECIFIC  09/01/20XX            
   6209       CLERK III                                                 O       ADMIN-EXEM       ALL       09/01/20XX            
 0058         CLERK-TYPIST, MEMBER                      02    00/00     O       PROF-EXEMP   MEMBER EMPLO  09/01/20XX            
   6209       CLERK TYPIST, MEMBER                                      O       ADMIN-EXEM       ALL       09/01/20XX            
 0139         ADMIN SCTY, MEMBER                        02    00/00     O       PROF-EXEMP   MEMBER EMPLO  09/01/20XX            
   6209       ADMIN SCTY, MEMBER                                        O       ADMIN-EXEM       ALL       09/01/20XX            
 0140         ADMIN ASSIST, MEMBER                      02    00/00     O       PROF-EXEMP   MEMBER EMPLO  09/01/20XX            






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