FMX Home
Glenn Hegar  ·  Texas Comptroller of Public Accounts

USPS Reports Guide
Report 503 Work Authorizations Expiring Within 120 Days of xx/xx/xxxx

This report displays information about an employee's work visa as of the USPS system date plus 120 days. This includes the employee's SSN, name, organization code, location code, job title, hire date, and visa expiration date.

Report Criteria

Category Personnel Management
Distribution Agency
Frequency Monthly/On request (HNKPM)
Form  
Sort Sequence Organization Code, Employee Number (Internal Sort)
Page Break  
Parameters  
Databases Used HØB, HNH, HID, HØC, HNK, HOØ, H70
Selection Criteria All employees with a visa expiration date that will expire within 120 days of the system date.
Produce Output? Yes
Request Screen HNKPM; HPRPT – Set up to run automatically with Month-End Reports.
Posting Report? No
Additional Notes Call your USPS representative when ready to run Month-End Reports.

Report Headings

ORGCODE HNH.ORGCODE
Displays the employee's primary organization code.
SSN HID.SOCSECNO
Displays the employee's SSN.
NAME HID.LASTNAME, HID.FIRSTNAME
Displays the employee's name.
LOCATION/EXT LOCATION CODE HNH.LOCCODE/HNH.EXTLOCCD
Displays the employee's location code and extended location code, if applicable.
JOB TITLE H70.JCTITLE
Displays the title for the employee's position assignment.
HIRE DATE HØB.EMPLOYDATE
Displays the date the employee was hired.
VISA EXP DATE HOØ.VISAEXPNDT
Displays the date the employee's work visa will expire. If the visa has already expired, the word EXPIRED will appear to the right of the date.

Sample Report

 REPORT:   503                               UNIFORM STATEWIDE PAYROLL/PERSONNEL SYSTEM                          PAGE:    1
 AGENCY:   XXX                                      XXXX XXXXX XXXXXXXXXXX XXXXX                              RUN DATE: XX/XX/20XX
                                            WORK AUTHORIZATION EXPIRING WITHIN 120 DAYS OF 7/31/20XX          RUN TIME: 2:00:00
                                                            
                        
                                                  LOCATION/
ORGCODE              SSN          NAME           EXT LOCATION CODE         JOB TITLE          HIRE DATE    VISA EXP DATE    

00000100100      XXX-XX-XXXX    XXXXX, XXXXX        00001/                CARTOON CHARACT     01/01/20XX    11/15/20XX       EXPIRED
00000100200      XXX-XX-XXXX    XXXX, XXXXXX        001                   CARTOON CHARACT     09/30/20XX    03/30/20XX       EXPIRED   
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