USPS Reports Guide –
USPS Reports by Number –
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 | H0B, HNH, HID, H0C, HNK, HO0, 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 H0B.EMPLOYDATE
- Displays the date the employee was hired.
- VISA EXP DATE HO0.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